Description
Power Pivot is an Excel add-in that can be used to perform powerful data analysis and create sophisticated data models. Join our upcoming webinar to gain a good understanding about Power Pivot that takes pivot tables and data analysis to the next level.
AREAS COVERED
Session highlights include…
- Importing your data into Power Pivot
- Using the Data Model to create and manage relationships
- Hierarchies in PowerPivot
- Creating a pivot table from related Excel tables
- Creating a pivot table from related data sources (including external sources)
- Creating calculated fields (measures)
- An introduction to the DAX formula language to create simple calculated columns
- Creating KPI’s
LEARNING OBJECTIVES
You will learn, using practical examples, how the add-in provides Business Intelligence functionality & reporting within the familiar environment of Excel.
Speaker Profile
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012, he founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a variety of Excel topics.
Mr. Thomas is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
About Training Doyens
Based in Colorado, Training Doyens organizes world class webinars and seminars, providing training solutions to companies big and small. We offer affordable pricing and customization at any budget.
For more detail please click on this below link:
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
