This Event has Passed
Friday, March 02, 2018
3:00 PM - 4:00 PM
3:00 PM - 4:00 PM See all dates and Times
https://goo.gl/v2y7K6
Event Tag
Categories
OVERVIEW 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
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.
For more detail please click on this below link:
https://goo.gl/v2y7K6
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
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
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.
For more detail please click on this below link:
https://goo.gl/v2y7K6
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882