What Will I Learn?

• How to set up your data and create a Pivot Table in less than 3 minutes which will increase your efficiency!
• How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Pivot Table, taking your analytical skills to another level
• How to create an Interactive Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management
• Pivot Table tips & special Bonus attendee material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!

Requirements:

• Excel 2007, 2010 & 2013. This course was recorded using Excel 2010 but all the concepts taught are compatible with Excel 2013 and 2007.
• Microsoft & Apple compatible

What you will learn?

• How to set up your data and create an Excel Pivot Table in less than 3 minutes which will increase your efficiency!
• How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Excel Pivot Table, taking your analytical skills to another level!
• How to create an Interactive Excel Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management!
• Pivot Table tips & special Bonus material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!

Who is the target audience?

• New users, beginners, intermediates and advanced Excel users