Microsoft Office Certifications (Microsoft) There is no better place to start your Excel learning. 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.
Excel University, Seal Beach, CA. 1,955 likes 5 talking about this. Excel University provides online Excel training to accounting and finance professionals. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning's Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you. If you're an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning).
Learn Microsoft Excel so that you can get your work done faster. We provide online, on-demand, self-paced, video-based lessons.
Sign up for our free Excel blog to join 50,000+ who learn from us each week.
Courses provide an online, on-demand, interactive learning experience. Watch the lecture videos, complete the hands-on exercises, pass the exam, and earn certifications. Excel University is a NASBA CPE sponsor and our courses are offered for CPE credit.
A Campus Pass provides access to our entire catalog of undergraduate and masters lessons. It includes live Office Hours with Q&A and full access to the Student Union. Extreme gamification ensures this is the most fun you can have learning Excel.
Coaching provides the help you need to optimize your workbooks for efficiency and accuracy. The coaching sessions are live and you can share your screen to receive immediate assistance. We offer group coaching plus an option for individual sessions.
Certifications are awarded when you complete the Undergraduate and Masters programs. They are available with Courses and a Campus Pass. You can display them on your LinkedIn profile, resume, CV, or website. You also receive a LinkedIn recommendation.
Hundreds of articles, blog posts, and videos are available to help you learn free. Join the 50,000+ people who receive weekly Excel tips by subscribing to our blog.
Jeff Lenning Excel University
Thanks for subscribing! We will send you an email each time we write a new article.
Excel University Voucher
Our virtual Campus Advisor will make recommendations based on your goals and experience level and get you to the right resource in moments.
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
- Update to Mapping tables technique (using Power Pivot)
Author and Instructor
Jeff Lenning CPA CITPSubject
Excel University Masters 1Benefits
Begin Now: begin training immediately
On-Demand: train at your own pace
Pause and Resume: pause and resume training as neededSoftware
Presented with Excel O365 and Power BI for Windows. Notes: Excel for Windows O365 is the recommended version for taking this course, however, these tools are also available for legacy versions of Excel starting with Excel for Windows (2010+). Excel for Mac is not supported.Format
On-DemandAccess Begins
ImmediatelyDuration
Work at your own pace during the one-year enrollment period.Enrollment Period
Your enrollment is valid for one year.
|
|
|
|
|
|
|
|
Materials
All course materials are provided digitally inside the course. There are no additional purchases required to complete the course.
Excel University Blog
A digital PDF copy of M is for (data) Monkey by Ken Puls and Miguel Escobar is included in the course. You can download the eBook to keep as a permanent reference. The course teaches selected Power Query topics presented in the book. The book covers far more detail about Power Query, and provides an excellent resource to read during or after you work through the lessons.
For students looking to dig deeper into the topics presented, these books are suggested additional reading:- Show Me the Numbers by Stephen Few
- Power Pivot and Power BI by Rob Collie and Avichal Singh
Objectives
- Recall which type of graph is useful to feature a given relationship (nominal, ranking, part-to-whole, time series, distribution, deviation, correlation, and geospatial)
- Identify the Excel feature that summarizes values and displays them in rows and columns and includes totals
- Recall which tool is designed to get and transform data
- State the Excel feature that creates a graph
- Recall which tool allows you to relate multiple tables and write measures for use in a report
- Recognize that an explicit measure is written in Power Pivot
- Recall which application incorporates the same technologies included in Power Query and Power Pivot
Program Level
BasicPrerequisites
Although there are no course prerequisites, prior experience with traditional PivotTables is recommended.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 supported.Delivery Method
QAS Self-studyRecommended CPE Credits
19Field of Study
Computer Software & ApplicationsExpiration
Program enrollment is valid for one year and participant must complete the final exam within this time period.
Coaching provides the help you need to optimize your workbooks for efficiency and accuracy. The coaching sessions are live and you can share your screen to receive immediate assistance. We offer group coaching plus an option for individual sessions.
Certifications are awarded when you complete the Undergraduate and Masters programs. They are available with Courses and a Campus Pass. You can display them on your LinkedIn profile, resume, CV, or website. You also receive a LinkedIn recommendation.
Hundreds of articles, blog posts, and videos are available to help you learn free. Join the 50,000+ people who receive weekly Excel tips by subscribing to our blog.
Jeff Lenning Excel University
Thanks for subscribing! We will send you an email each time we write a new article.
Excel University Voucher
Our virtual Campus Advisor will make recommendations based on your goals and experience level and get you to the right resource in moments.
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
- Update to Mapping tables technique (using Power Pivot)
Author and Instructor
Jeff Lenning CPA CITPSubject
Excel University Masters 1Benefits
Begin Now: begin training immediately
On-Demand: train at your own pace
Pause and Resume: pause and resume training as neededSoftware
Presented with Excel O365 and Power BI for Windows. Notes: Excel for Windows O365 is the recommended version for taking this course, however, these tools are also available for legacy versions of Excel starting with Excel for Windows (2010+). Excel for Mac is not supported.Format
On-DemandAccess Begins
ImmediatelyDuration
Work at your own pace during the one-year enrollment period.Enrollment Period
Your enrollment is valid for one year.
|
|
|
|
|
|
|
|
Materials
All course materials are provided digitally inside the course. There are no additional purchases required to complete the course.
Excel University Blog
A digital PDF copy of M is for (data) Monkey by Ken Puls and Miguel Escobar is included in the course. You can download the eBook to keep as a permanent reference. The course teaches selected Power Query topics presented in the book. The book covers far more detail about Power Query, and provides an excellent resource to read during or after you work through the lessons.
For students looking to dig deeper into the topics presented, these books are suggested additional reading:- Show Me the Numbers by Stephen Few
- Power Pivot and Power BI by Rob Collie and Avichal Singh
Objectives
- Recall which type of graph is useful to feature a given relationship (nominal, ranking, part-to-whole, time series, distribution, deviation, correlation, and geospatial)
- Identify the Excel feature that summarizes values and displays them in rows and columns and includes totals
- Recall which tool is designed to get and transform data
- State the Excel feature that creates a graph
- Recall which tool allows you to relate multiple tables and write measures for use in a report
- Recognize that an explicit measure is written in Power Pivot
- Recall which application incorporates the same technologies included in Power Query and Power Pivot
Program Level
BasicPrerequisites
Although there are no course prerequisites, prior experience with traditional PivotTables is recommended.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 supported.Delivery Method
QAS Self-studyRecommended CPE Credits
19Field of Study
Computer Software & ApplicationsExpiration
Program enrollment is valid for one year and participant must complete the final exam within this time period.Registration
To register, add this course to your cart by clicking the Buy Now button and then complete the checkout process.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.comOfficial Registry Statement
Excel University, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.| Price: $287.00 |
| Buy 2 or more for $229.60 each Buy 20 or more for $143.50 each |
