The Power Excel Course

The Power Excel Course

Current Status

Price

Free

Get Started

Log In to Enroll

Course Content

Lesson Content

0% Complete

0/4 Steps

Excel Versions and Compatibility

Power Excel Course Objectives

Power Excel and its Benefits

Course Resources Page

Lesson Content

0% Complete

0/7 Steps

What is the Data Model

The key Concept of Normalization

Creating and Editing Table Relationships

Active v Inactive Relationships

The Concept of Cardinality

Connecting Multiple Data Tables

Introduction to Filter Context

Lesson Content

0% Complete

0/5 Steps

What is a Power Pivot

Calculated Columns and How to Create them

What are DAX Measures

Implicit and Explicit Measures

More about Filter Context

Lesson Content

0% Complete

0/9 Steps

DAX Count Functions

DAX Logical Functions

Switch and Switch(true) Functions

The Calculate Function

The Filter Function

The ALL Function

The Related Function

The Iterator Functions