Day 4
Let me ask you, are you a fan of pivot tables? Perhaps you are, and that's cool with me! Many people, however, struggle to get pivot tables to do the things they need to do. I personally had trouble getting pivot tables to display in a neat-and-tidy way on real-world Excel projects. So, I sought a different approach that I'm sharing with you today.
Excel's often overlooked data analysis formulae bring the power of pivot tables with greater control for the user. I've build my whole data analysis approach around these formulae. It's an approach that underpins all my data analysis work, including creation of sophisticated Excel dashboards for customers. I'm excited to bring you some of these formulae today, starting with simple 'single criteria' analysis ...
DAY 4: Learning Outcomes
Excel's often overlooked data analysis formulae bring the power of pivot tables with greater control for the user. I've build my whole data analysis approach around these formulae. It's an approach that underpins all my data analysis work, including creation of sophisticated Excel dashboards for customers. I'm excited to bring you some of these formulae today, starting with simple 'single criteria' analysis ...
DAY 4: Learning Outcomes
- use the UNIQUE formula
- create a SUMIF formula
- create a AVERAGEIF formula
- create a partial absolute reference
Enjoying the Excel Data Analysis Crash Course? Check out our Excel Basics course.