# Filter Data Right in your Pivot Table Fields!

One of the ‘hidden treasure’ in Pivot Table a lot of people do not know about is that you can filter data right in your Pivot Table Fields. This is extremely...

# Sensitivity Study (or Scenarios) with Data Table

In managerial decision making, many time we need more than just an optimal decision. Often we would like to know how my results change if I change my decision in a certain...

# 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...

# 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....

# 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...

# Chance of Nothing Happening? The Power of Joint Probabilities

Yesterday, as I was reading a book about Blackstone, the famed asset management company, something caught my attention.  It was about how one of its executives describing...

# This Site Has Abundant Climate Data

I have always been fascinated by climate data. Just today while researching for data on this topic, I came upon the Berkley Earth website and found that it has warehoused...

# Here is Another Example on Why Excel will Never Go Away – Julia Computing

Recently I had a conversation with a colleague who argues that Excel will die because he felt people are switching to other computing environments such as R. While I agree...