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
Next Course
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
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-13309
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-13310
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-13311
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
free essential-tools-for-windows-system-administrators-13326
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.
Favorites (0)
Favorites
0 favorite option

You have no favorites

Name delet