How I Analyze Excel School Sales using Pivot Tables [video]
Some of you know that I run an online excel training program called Excel School. If you want to join, click here. Only 8 days left.
I run excel school mainly to meet new students, understand their problems and learn new ways to solve them. But, Excel School also presents me with an interesting analytics challenges. In this post, I will share 2 pivot table based analytic techniques I used just yesterday to answer few questions I had about Excel School sign-ups.
Watch this 15 min. video to see how I analyze the data
I have fixed the audio now. Sorry for the mess-up earlier. Watch again to enjoy the video.
Join Excel School Today, Only 8 days left
Of course, you knew I was going to ask you to join. So here it goes.
My Excel School program is going thru 3rd batch and I encourage you to join. The program helps you to learn excel step by step and become awesome. It has 22 hours of video lessons, 45+ download workbooks and an awesome teacher (me 😀 ). Go ahead and find out more.
More Pivot Table & Analysis Tricks:
- Group Dates in Pivot Tables – a short guide
- Simplifying data analysis with Excel Tables
- Analyzing and Visualizing Search Terms – Excel Dashboard Example
- More on Analytics and Pivot Tables
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Putting it all together – Final Project Evaluation Model [Part 6 of 6]||Displaying & Selecting a Scenario using VBA [Modeling in Excel] »|