Excel University Masters 1 Lite (No CPE, 1 Year)

(EUM1OD2)

Overview

Excel University Masters 1 teaches Power Query, Power Pivot, and Power BI. It demonstrates how to use these powerful tools to build the process that builds our reports (tables and graphs). We select the report and graph type based on Stephen Few's book, Show Me the Numbers. Plus, we incorporate his design practices to ensure effective communication. This course uses case studies to simulate real-world workbooks and projects. The final case study brings everything together as we build a dashboard to monitor our business. We complete each case study in both Excel and Power BI. There is also a library of Excel workbooks with reference charts. Check out the first video from the course below to learn more.

 

 

 

 

  • Table and Graph Topics

    • • Display type: selecting a table or graph
    • • Chart design practices
    • • How to feature key relationships graphically
    • • Nominal (order not important)
    • • Ranking (order matters)
    • • Part-to-whole (contributions to whole)
    • • Time series (over time)
    • • Distribution (distributed over range)
    • • Deviation (difference)
    • • Correlation (vary in relation to each other)
    • • Geospatial (locations)
  • Power Query Topics

    • • Get external data
    • • Various transformations, including unpivot
    • • Load to data model and table
    • • Chain queries
    • • Merge queries
  • Power Pivot Topics

    • • Relationships
    • • Measures (implicit / explicit)
    • • Various DAX functions
    • • Date (calendar) table
    • • Data vs lookup tables
  • Power BI Topics

    • • Getting external data
    • • Modeling data and writing measures
    • • Various visuals (matrix, table, column, bar, line, scatter, map)
    • • Power BI desktop, service, mobile app
    • • Slicers (and sync slicers)
  • Bonus Lesson

  • Author and Instructor

    Jeff Lenning CPA CITP
  • Subject

    Excel University Masters 1
  • Benefits

    Begin Now: begin training immediately
    On-Demand: train at your own pace
    Pause and Resume: pause and resume training as needed

  • Software

    Presented with Excel O365 and Power BI for Windows. Notes: Excel for Windows (2010+) and Power BI Desktop is supported. Excel for Mac is not supported.
  • Format

    On-Demand
  • Access Begins

    Immediately
  • Duration

    Work at your own pace during the one-year enrollment period.
  • Enrollment Period

    Your enrollment is valid for one year.

  • Lesson 1

  • Lecture Videos (minutes)
  • • Overview (23m)
  • • Power Query Intro  (21m)
  • • Power Pivot Intro (21m)
  • • Excel Reports Intro (16m)
  • • Case Study 1 (29m)
  • Homework
  • • Case Study 1
  • Additional Resources
  • • Answer Files
  • • Suggested Reading
  • • Interactive Handout
  • Lesson 2

  • Lecture Videos
  • • Case Study 2 - Excel (59m)
  • • Case Study 2 - Power BI (27m)
  • Homework
  • • Case Study 2
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (13m)
  • • Related Blog Post
  • Lesson 3

  • Lecture Videos
  • • Case Study 3 - Excel (45m)
  • • Case Study 3 - Power BI (18m)
  • Homework
  • • Case Study 3
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (6m)
  • • Related Blog Post
  • Lesson 4

  • Lecture Videos
  • • Case Study 4 - Excel (39m)
  • • Case Study 4 - Power BI (15m)
  • Homework
  • • Case Study 4
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (21m)
  • • Related Blog Post
  • Lesson 5

  • Lecture Videos
  • • Case Study 5 - Excel (28m)
  • • Case Study 5 - Power BI (6:31)
  • Homework
  • • Case Study 5
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (21m)
  • • Related Blog Post
  • Lesson 6

  • Lecture Videos
  • • Case Study 6 - Excel (27m)
  • • Case Study 6 - Power BI (7m)
  • Homework
  • • Case Study 6
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (3m)
  • • Related Blog Post
  • Lesson 7

  • Lecture Videos
  • • Case Study 7 - Excel (10m)
  • • Case Study 7 - Power BI (4m)
  • Homework
  • • Case Study 7
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (5m)
  • • Related Blog Post
  • Lesson 8

  • Lecture Videos
  • • Case Study 8 - Excel (34m)
  • • Case Study 8 - Power BI (13m)
  • Homework
  • • Case Study 8
  • Additional Resources
  • • Answer Files
  • • Extra Credit Solutions (10m)
  • • Related Blog Post

Materials

All course materials are provided digitally inside the course. There are no additional purchases required to complete the course. For students looking to dig deeper into the topics presented, these three books are suggested additional reading:

 

Program Level

Intermediate

Prerequisites

Comfortable with traditional PivotTable (or have taken either Excel University Volume 3 or the Xtreme PivotTables course)

Advance Preparation Needed

Ensure you have access to Excel for Windows (version 2010 or later), so that you can work through the homework exercises. Plus, you'll want to download Power BI desktop (free) if you want to work on the Power BI exercises. Excel for Mac is not officially supported.

Recommended CPE Credits

This course does not qualify under NASBA standards for continuing education (CPE) credit and should not be claimed as such.

Expiration

Program enrollment is valid for one year.

Refund Policy

Full 30-day refund; full refund for any course cancellations or registration into upcoming session if preferred.

Complaint Resolution

For information regarding adminstrative policies such as complaint resolution, please contact Jeff Lenning CPA CITP at 949-200-7688 or via email info@excel-university.com

 

Price: $179.00
Buy 2 or more for $143.20 each
Quantity: