Posted on 19 May 2009
How do I create a dashboard in Excel?
To create a dashboard in Excel you organize the data used by the dashboard in an excel workbook, create flexible models out of the data and then finally present the data as a properly formatted report or a dashboard. Before we begin, always keep in mind that if the dashboard you are creating is going to be used (and oftentimes maintained) by other ...
Continue Reading
Posted on 19 May 2009
In this post you will learn about how to format pivot tables in excel. Formatting a pivot table is often the step that people tend to miss out when presenting information using pivot tables. By formatting a pivot table you can make the data stand out, occupy less screen 'real estate' and make the user's life simpler.
(You can download a copy of the
format a pivot table in excel workbook with an example here.)
How to Format a Pivot Table?
Let ...
Continue Reading
Posted on 14 May 2009
Bonavista systems, the makers of Microcharts, have invited entries for this years Excel Dashboard Competition. All you have to do is to present a dashboard which uses nothing more than Excel 2000 (or higher) and no other software other than Bonavista's Chart tamer and micro charts. The dashboards are going to be judged on 'the clarity and effectiveness of their design'. Entries can use any combination of tables, Excel charts, ...
Continue Reading
Posted on 13 May 2009
An SQL Statement is a statement written in SQL. Every SQL statement could be classified as either a Data Access Control Statement, Data Definition Statement, Data Manipulation and Retrieval Statement or a Data Transaction Control Statement. You can download a
complete set of SQL statements (SQL Satement & Basics.pdf) here. This handbook describes most of the frequently used SQL statements and contains numerous examples of how to use those statements.
...
Continue Reading
Posted on 12 May 2009
A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The
six sigma table can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level.
The sigma table has five columns – the yield or the accuracy level ( 1 – the defect rate), the ...
Continue Reading
Posted on 11 May 2009
This Sudoku solver in Excel will help you solve a sudoku puzzle with brute force. This Sudoku solver, has been written in VBA and incorporates a brute force algorithm which helps its solve some of the toughest sudoku puzzles using nothing more than an excel spreadsheet.
You can
download the Sudoku Solver in Excel with Code, Logic and Algorithm here.
In this article we will talk about how to develop a Sudoku solver using code in Excel, discover the tips ...
Continue Reading
Posted on 11 May 2009
How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can
download a copy of the six sigma calculator in excel here.
Before ...
Continue Reading
Posted on 10 May 2009
You can
download the house of quality template in excel here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...
Continue Reading
Posted on 08 May 2009
The results of the "Stress Test - Housing Crisis of Shame" are out. I just saw
NY Times publish the stress test figures this morning. The first thing that came to my mind when I saw the results was, well.......not that they require another $75 billion, that's pretty well known to most of us by now, was ....gosh.....what an opportunity wasted. Here was a important and relevant piece of data that could have really been presented better using ...
Continue Reading
Posted on 07 May 2009
This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for
creating simple Gantt charts, there are other commercial tools available for developing more complex versions of the Gantt chart.
GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...
Continue Reading
Posted on 05 May 2009
Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...
Continue Reading
Posted on 04 May 2009
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to
download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...
Continue Reading
Posted on 29 April 2009
Here is a comprehensive list of more than 125 keyboard shortcuts in Excel. You can
download the entire list of keyboard shortcut keys as an Excel workbook here. These shortcuts cover formatting cells and worksheets, inserting rows and columns, calculations, handling workbooks and a number of other useful keys that will make you an Excel Keyboard expert in no time....
Continue Reading
Posted on 21 April 2009
The VBA For Loop and the Do While loops are the two most important loops in the VBA language. They can be used to carry out a specific task in an iterative manner till such time that a condition is met (or the VBA loop is terminated).
Download the worksheet with examples of
the for, do while and do until loops in VBA
The VBA For Loop
The VBA For ...
Continue Reading
Posted on 18 April 2009
Ever wondered how do you convert your excel spreadsheets in to the PDF format? Here are a few tools (mostly free though some are free only during the trail period) that can help you convert from excel to the PDF format (.xls to .pdf).
ExpressPDF
ExpressPDF is a website based online excel to pdf conversion tool. You will need to submit the document to be converted on the website and ...
Continue Reading
Posted on 16 April 2009
If all you need to do is to get a copy of the
Excel Waterfall Chart Template with Negative Values then you can simply download it here.
For those interested in knowing how to create a waterfall chart in excel, please read on.
How do I create a waterfall chart in excel?
There are two ways to create a waterfall chart in Excel. The first is to simply lay out a grid ...
Continue Reading
Posted on 16 April 2009
How do you reach Mahabaleshwar from Mumbai
Well there are two ways to reach Mahabaleshwar from Mumbai
Route 1: Bombay-Panvel -Lonavla-Pune-Shirwal-Khambatki Ghat -Wai-Panchgani-Mahabaleshwar (Total distance around 305 kms, driving time with break 7 hours)
Route 2: Bombay-Kalamboli-Panvel-Pen-Mahad-Pholadpur-Mahabaleshwar (Total distance around 237 kms)
The first one is preferable. That way you cover a major part of the route going along the Mumbai-Pune Expressway and the remaining through reasonably good Pune-Satara bypass. That way you are ...
Continue Reading
Posted on 08 April 2009
Although not used frequently, excel data forms can be a useful tool to work your way through a medium size data set. Imagine your boss just handed over a set of invoices and asked you to type them onto a worksheet. Now life would have been a lot simpler had he given you say a dozen invoices but as Murphy said, anything that can go wrong it will. And as ...
Continue Reading