Hey .. Wish me a Happy Birthday!
Yes, today is my Birthday and I am really happy because I am finally able to launch this Pivot Table Course and a Sales Dashboard which I would like to give you as a present. I have put in a lot of heart to make this a one stop shop comprehensive pivot table course for you and I am sure you’ll enjoy it as much as I have enjoyed making it
Outline of the Program
Here is the quick snapshot of what will you learn in the 4 part course
- Part 1 – Getting started with Pivot Tables
- Part 2 – Pivot Table Features and Options
- Part 3 – Pivot Table Calculations and Automation
- Part 4 – How to make a Dashboard with Pivot Tables and Excel Formulas
Part – 1
Notes for Part 1
- Top 25 Suggested Excel Shortcuts
- Turning off the GETPIVOTDATA function in Excel
- Download the Excel Files for Part 1
- Download the Video for Part 1
Part – 2
Notes for Part 2
- How to group dates in Pivot Tables
- Finding the correct quarter in the Indian financial year
- Download the Excel Files for Part 2
- Download the Video for Part 2
Part – 3
Notes for Part 3
Part – 4
Notes for Part 4
- Data Models in Pivot Tables – Excel 2013 (Not covered in the course!)
- Charts Formatting – Part 1, Part 2, Part 3
- Copying Chart Formats – Quick Tip
- How to make a chart in 1 keystroke
- Download the Excel Files for Part 4
- Download the Video for Part 4
- Also check out a Human Resource Dashboard
Returning back to my Birthday
Here is the picture of the cake that we cut last night. Hey I am not making you envious .. but I have cooked this awesome course for you and I also promise to treat you whenever we meet next!
Please subscribe
I would write and share with you about the awesome things that I learn and develop. Also please please share with me your comments about this course… would love to hear from you.. And do share this course with your friends and colleagues .. basically anyone who you know and needs help on Pivot Tables!! 😛
#ResquestaaPaiyanVe!! 😉 Take Care and Have fun!
