# Two-way Data Table in Excel is a great tool for sensitivity analysis

In an earlier post, I have introduced Data Table as a “secret weapon” to conduct sensitivity analysis. Now let’s go one step further and look at a more...

Skip to content
# tutorial

# Two-way Data Table in Excel is a great tool for sensitivity analysis

# Filter Data Right in your Pivot Table Fields!

# Sensitivity Study (or Scenarios) with Data Table

# PivotTable: Calculated Fields

# Dashboard with PivotTable

# Data Slicer and Timeline are Useful Reporting Tools in PivotTable

# How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac

# How much gasoline do we American consumers buy each week? An Example of Excel Modeling

# Most Used Excel Shortcut Keys – Mac and PC

# How to Draw a 3-D Chart

Category

In an earlier post, I have introduced Data Table as a “secret weapon” to conduct sensitivity analysis. Now let’s go one step further and look at a more...

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

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

Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total...

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

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

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

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

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

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