Dashboard with PivotTable
Dashboard is an effective communication tool to summary and highlight your data and your analysis. Here is an example of an Excel Dashboard that I made with PivotTable (and...
Category
tutorial
Data Slicer and Timeline are Useful Reporting Tools in PivotTable
Most of us know how to use a Filter in PivotTable, but do you know that there is an even better tool in slicing data in PivotTable? Yes, there is, and the name is, well, Data...
How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac
When two columns of data are of different scale, you will need to use a combo chart to plot each column on a separate axis. In the video below, one column is numbers of...
How much gasoline do we American consumers buy each week? An Example of Excel Modeling
I am a fan of Bill Gates. But the reason I bring his name up in here is because he just demonstrated the power of logical thinking, something very important in Excel modeling....
Most Used Excel Shortcut Keys – Mac and PC
Finally I found some time to sit down and compile a list of Excel shortcut keys that I personally consider most used (and thus most useful). Please note that these are only...
How to Draw a 3-D Chart
If you have 3-dimensional data, drawing a 3D chart can be very helpful in visualizing how the two variable jointly affect the outcome. In Microsoft Excel, such 3D charts are...
How Advance do People Make Rental Car Reservations? The Result May Surprise You!
Spring break is upon us. Many students of mine are heading to exotic location, and quite a few of them have reserved rental cars many weeks earlier. But here is the question:...
How to Draw a Pareto Chart?
Pareto chart, put simply, is a sorted frequency chart. It is used mainly for identifying the most frequent occurrences in a collected sample. Some business-situation questions...
Sparkline (aka chart-in-a cell) really sparkles!
In many cases, you need to generate a series of graphs using Excel, and yet do not want to put them into one single picture. For example, you would like to draw the price...
Data Table is a Secret Weapon in Excel Modeling and Analysis
Scenario analysis (also called What-ifs) is an indispensable part of business decision models. What is demand is only half of predicted? What if conversion rate is 50% higher?...