Content Provider
Theexceltrainer
Handout Materials
Presentation Slides
Additional Materials
Excel 2016 handout
Excel 2013 handout
Excel 2010 handout
Demo Files
Webinar Technical FAQs
Excelpowerpivot theexceltrainer

EXCEL POWER PIVOT: TAKING PIVOT TABLES TO THE NEXT LEVEL

Cost Free
Presentation Length 1.5 hours

Recorded DateJuly 2, 2019
CPE:Not available
(archived webinars do not offer CPE credits)
Course LevelIntermediate
Series: Excel, Bookkeeper
Course Description

Power Pivot, a free add-in for Excel, written by Microsoft, puts the “power” into Pivot Tables (hence the name!). Power Pivot lets you do things like:


  • Create a Pivot Table from multiple Excel-based lists (goodbye VLOOKUP)

  • Create a Pivot Table from very large datasets with no negative impact on performance

  • Combine together related data from multiple data sources (Excel, database, text file etc) into a single Pivot Table

  • Create powerful calculations on the data in your Pivot Tables (Goodbye to the relatively basic Calculated Fields feature built in to Excel)


In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence functionality & reporting within the familiar environment of Excel. If you want to take your reporting capabilities to the next level by learning how to leverage the functionality of Power Pivot, this is a must-attend training session!
 
Topics covered:


  • Importing your data into Power Pivot

  • Using the Data Model to create and manage relationships

  • 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



Prerequisite: This event is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot.  Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

Not logged
Testimonials
Profile img default

Konrad King (Everi Holdings, Inc.)

"Excellent webinar. Picked up a new Excel skill that I did not previously have and will be sharing the information with my co-workers. Please include a Power Query webinar -- we do a lot of data importing into Excel. Also, stick with answering the questions as we go along. I had a LOT of the same questions others were typing in, and it was great getting answers right during the lecture."

Jane Adams (Jane Adams' Consulting, LLC)

"Mike was a fantastic presenter! The topic was timely for me as I am looking at combining many new data sets. The presentation was delivered at a great pace, with the right amount of detail. Mike was conscientious of our limited time, but still managed to answer many participant questions throughout the presentation. I will definitely seek out webinars from Mike in the future!"
Profile img default

Gabriel Tang (Buckingham & Tang, LLC)

"One of the best presentations I've attended in a long time. Pacing was good, documentation files were nicely stepped, transitions were smooth and explanations were very detailed and clear/understandable, variations for the differences/nuances of Excel 2010, 2013 and 2016 were helpful. thoroughly enjoyable, would recommend to others looking for Excel training."
Profile img default

Don Hollerbach ()

"This course was very well organized, presented and had numerous participation opportunities. Very cogent and thoughtfully presented. One of the best I have ever seen. He is definitely a subject matter expert and give great insight to the workings of Power Pivot but also the underlying workings for a deeper understanding."

Katherine Manchester (Max Tax Holdings Inc)

"Mike was tremendously knowledgeable. He took the time to address all relevant questions he could fit in a manner that made the answers blend in with the presentation. I definitely gained knowledge during his presentation, and look forward to taking these tips and tricks back to the office."

Tasha Jefferson (Kuumba Creative Group, LLC)

"The presenter and information presented was very informative and helpful. I am better equipped to handle large amounts of data and link various data sets that that can be tied together by common pieces of data. The presenter was excellent and really walked us through everything step by step."

Sandy Harris (MTM Recognition Corporation)

"Mike is a fantastic instructor. He stated instructions clearly and demonstrated steps at least a couple of times. Even though I am only slightly familiar with using Pivot Tables, I never got lost or felt like I was in over my head. Thank you for this excellent lesson!"
Profile img default

Tina Lephiew ()

"This was hands down the most useful CPE I've ever attended. Mike was engaging and interesting. The fact that I was able to download the files and work through them as he went means I will actually retain these new skills! I can't wait to put them to use!"
Show more testimonials
PLEASE NOTE: ARCHIVED WEBINARS DO NOT QUALIFY FOR CPE
Linkedin
Theexceltrainer

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 Mike 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 wide variety of technology-related topics.

Mike is a fellow of The Learning and Performance Institute and has worked with and for many 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 critical business tasks and processes.

About Our Presenter

Theexceltrainer
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 Mike 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 wide variety of technology-related topics.
 
Mike 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.