Power Pivot Excel 365 - From Zero to Hero

Course Feature

Cost

Paid
Provider

Udemy
Certificate

Paid Certification
Language

English
Start Date

2021-11-22
Learners

No Information
Duration

No Information
Instructor

Paula Guilfoyle CPA

Add to Favorites

4.5

2,292 Ratings

This course is designed to take novice PowerPivot users to a level of comfort and confidence in working with PowerPivot models, using Pivot tables and charts, DAX calculations and DAX time intelligence functions. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. This course consists of 5 modules, each with learning activities, videos and articles to reinforce what is covered. Learn how to link tables, create relationships, insert pivot tables and charts, work with DAX and use time intelligence functions. Get the most out of this course and become a PowerPivot hero!

Show All

Power Pivot Excel 365 - From Zero to Hero

Go to class

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
By taking this course, one will acquire the skills and knowledge to work with Power Pivot models, use Pivot tables and charts, carry out DAX calculations, and use DAX time intelligence functions. Specifically, one will learn how to create linked tables, get data into Power Pivot, create relationships, insert pivot tables and charts, work with slicers and timelines, understand the basics of DAX, create calculated columns and measures, use time intelligence functions, and set up date and calendar tables.
Professional Growth:
This course contributes to professional growth by providing users with the skills and knowledge to use Power Pivot Excel 365 to its fullest potential. Through the five modules, users will learn how to link tables, create relationships, insert pivot tables and charts, work with DAX functions, and use time intelligence functions. With this knowledge, users will be able to analyze and visualize data more effectively, allowing them to make more informed decisions and better understand their data.
Further Education:
This course is suitable for preparing further education as it covers a wide range of topics related to Power Pivot Excel 365. It provides an in-depth look at Power Pivot, including how to link tables, get data into Power Pivot, create relationships, work with pivot tables and charts, and use DAX functions and time intelligence functions. The course also includes workbooks to download and activities to reinforce the learning material. With this comprehensive course, users will be able to gain the necessary skills and knowledge to use Power Pivot Excel 365 effectively and confidently.

Course Syllabus

Power Pivot Orientation

Relationships

Creating PowerPivot tables and Charts

Introduction to DAX for PowerPivot Users

Time Intelligence Expressions

Show All

Recommended Courses

Complete Introduction to Excel Power Pivot [2023 Edition]

4.7

Udemy 4,500 learners

Learn More

This course provides a comprehensive introduction to Excel Power Pivot for powerful data analysis. Learn to work with millions of rows of data, create relationships between tables, and understand the DAX formula language. Create calculated fields and measures, perform sophisticated calculations such as Time Intelligence Filtered Data and Segmentation, and analyze data using Pivot Tables and Pivot Charts. With this 2023 edition, you will have the skills to create data models in Excel and make the most of your data.

Powerpoint 2016 2019 365 - Master powerpoint presentation

4.7

Udemy 96,600 learners

Learn More

Explore the essentials of Powerpoint 2016 2019 365 - Master powerpoint presentation

Webinar Marketing Mastery: Beginner to Pro Overnight

4.4

Eduonix 0 learners

Learn More

Gain an introduction to Webinar Marketing Mastery: Beginner to Pro Overnight

Essential Tools for Windows System Administrators

1.5

Udemy 6,500 learners

Learn More

Windows System Administrators can use a combination of Windows Builtin Tools and Open Source Tools to efficiently manage their systems. This guide provides an overview of the essential tools available.