Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Đổi giao diện
Giao diện cũ
Giao diện mới
en
English
Data Science Courses
Excel PowerPivot - Excel Data Analysis & DAX for Beginners
0 students
Last updated
Jan 2025
Enrol now
Overview
Course content
Instructors
About the course
Show more...
Course content
Sections:
5
•
Activities:
0
•
Resources:
30
Expand all
Section 1
Introduction
001 Course Introduction Sm6Q gitir
002 Instructor Introduction Philip Trick mIKa gitir
003 Review of Basic Excel Skills Needed for this Course ikfi gitir
004 Winning with Relationships w3s6 gitir
005 How To Get The Most Out Of This Course TKrz gitir
Section 2
PowerPivot Basics
006 What is PowerPivot HkhF gitir
007 Understanding Data Structures 1S2U gitir
008 Understanding the Basics of Relationships v9Su gitir
009 Relationship Detection bZe2 gitir
010 How to Leverage Relationships in PowerPivot zQbS gitir
Section 3
The Excel Data Model
011 Intro to the PowerPivot Window and Ribbon lD8M gitir
012 How to Use the Base Commands FTzR gitir
013 Calculated Columns vs Measures YEN2 gitir
014 Introduction to DAX TsSE gitir
015 Adding Calculated Columns 6zN2 gitir
016 DAX Conditional Functions hKOL gitir
017 Adding Calculated Measures Y8eT gitir
018 Understanding Context in DAX jTiw gitir
019 Managing Context in DAX VtKN gitir
020 Using Variables in DAX rnAl gitir
021 DATEDIFF Function Zt4t gitir
022 Math Functions C9E7 gitir
023 DAX Aggregations PGSc gitir
Section 4
Supporting Features and Advanced Concepts
024 Custom Hierarchies 1Rn3 gitir
025 PowerPivot KPIs Key Performance Indicators 8Kd6 gitir
026 Advanced Measure Computations xVW0 gitir
027 PowerPivot Excercise ziUz gitir
029 PowerPivot Excercise Solution 2qUG gitir
030 How To Find The Quiz Answers IGCw gitir
Section 5
Conclusion
032 Conclusion and Next Steps uBlg gitir
Instructors
Enrolment options
Excel PowerPivot - Excel Data Analysis & DAX for Beginners
Course modified date:
11 Jan 2025
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Resources
Share this course
Scroll to top
×
Close
×
Close