What is in this lesson?
- Grouping in the world of data model
- Hierarchies
- Number grouping
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
Calculating things in Pivots
What is in this lesson?
- Display value as option
- Calculated fields / measures
- More about Power Pivot
GETPIVOTDATA – talking to pivots
What is in this lesson?
- GETPIVOTDATA() intro
- Examples
Formatting pivot tables, charts and slicers
What is in this lesson?
- Formatting options for pivots
- Pivot charts
- Slicer formattting
Continue reading “Formatting pivot tables, charts and slicers”
Answering business questions – Pivot table case study
What is in this lesson?
- Defining questions
- Answering them thru Pivots
Continue reading “Answering business questions – Pivot table case study”
How to pick right chart for your data?
What is in this lesson?
- Why right charts?
- Process for chart selection
- Formatting tips
- Advanced charts?
Introduction to Excel charting
What is in this lesson?
- Getting started with charts
- Chart formatting
- Combination charts
Anatomy of an Excel chart
What is in this lesson?
- Various elements of a chart explained
Working with new charts in Excel 2016 / Office 365
What is in this lesson?
- Box plots, Parteto charts
- Treemap, Sunburst charts
- Waterfall charts
- Forecast charts
Continue reading “Working with new charts in Excel 2016 / Office 365”
Conditional charts
What is in this lesson?
- Highlight chart elements on condition
- NA() formula
- Examples
- Class formula