# PivotTable: Calculated Fields

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

Skip to content
# statistics

# PivotTable: Calculated Fields

# 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

# How to Draw a 3-D Chart

# Chance of Nothing Happening? The Power of Joint Probabilities

# Tesla Needs to Be More Rigorous in Discussing Numbers

Category

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

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

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

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

Not to pick on Tesla – Many companies do this – But it really needs to be more rigorous in discussing its numbers. Take the most recent press release on its car...