From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling
Join today to access over 24,600 courses taught by industry experts.
Logical functions (IF, AND, and OR) - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling
Logical functions (IF, AND, and OR)
Play video to see the transcript
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
-
Exercise File: Subscribe to access.
Glossary_Excel_Business_Intelligence.zip -
Exercise File: Subscribe to access.
Ex_Files_Excel_Business_Intelligence.zip
Download the exercise files for this course.
Get started with a free trial today.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere.
Get started with a free trial today.
Contents
-
-
(Locked)
Power Query introduction27s
-
Meet Power Query (known as Get & Transform)2m 40s
-
(Locked)
The Query Editor3m 17s
-
(Locked)
Options for loading data in Excel1m 40s
-
(Locked)
Basic Power Query table transformations8m 6s
-
(Locked)
Text-specific query editing tools10m 17s
-
(Locked)
Number-specific query editing tools7m 41s
-
(Locked)
Date-specific query editing tools7m 39s
-
(Locked)
Create a rolling calendar with Power Query5m 2s
-
Add index and conditional columns with Power Query7m 44s
-
(Locked)
Group and aggregate data with Power Query7m 10s
-
(Locked)
Pivot and unpivot data with Power Query8m 52s
-
(Locked)
Modify Excel workbook queries4m 18s
-
(Locked)
Merge queries7m 43s
-
(Locked)
Append queries5m 49s
-
(Locked)
Connect Excel to a folder of files9m 32s
-
(Locked)
Excel Power Query best practices2m 42s
-
(Locked)
-
-
(Locked)
Data modeling introduction28s
-
Meet the Excel data model3m 38s
-
(Locked)
Data versus diagram view2m 33s
-
(Locked)
Database normalization4m 15s
-
(Locked)
Data tables versus lookup tables5m 40s
-
(Locked)
Relationships versus merged tables2m 7s
-
Create table relationships6m 55s
-
(Locked)
Modify table relationships2m 7s
-
(Locked)
Active versus inactive relationships3m 55s
-
(Locked)
Relationship cardinality5m 43s
-
(Locked)
Connect multiple data tables5m 59s
-
(Locked)
Filter direction5m 8s
-
(Locked)
Hide fields from client tools4m 59s
-
(Locked)
Define hierarchies3m 54s
-
(Locked)
Data model best practices1m 37s
-
(Locked)
-
-
(Locked)
Introduction to Power Pivot and DAX29s
-
Create a Power Pivot table5m 27s
-
(Locked)
Power Pivots versus normal pivots2m 48s
-
(Locked)
Introduction to Data Analysis Expressions (DAX)1m 12s
-
(Locked)
Calculated columns8m 39s
-
(Locked)
DAX measures2m 24s
-
(Locked)
Create implicit measures1m 59s
-
(Locked)
Create explicit measures (AutoSum)7m 8s
-
(Locked)
Create explicit measures (Power Pivot)7m 42s
-
(Locked)
Understand filter context9m 18s
-
(Locked)
Step-by-step measure calculation12m 6s
-
(Locked)
Recap: Calculated columns versus measures2m 29s
-
(Locked)
Power Pivot best practices1m 48s
-
(Locked)
-
-
Introduction to DAX functions27s
-
(Locked)
DAX formula syntax and operators4m 5s
-
(Locked)
Common DAX function categories3m 54s
-
(Locked)
Basic math and stats functions12m 45s
-
(Locked)
COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS10m 35s
-
(Locked)
Logical functions (IF, AND, and OR)16m 49s
-
(Locked)
Switch and Switch (TRUE)10m 33s
-
(Locked)
Text functions10m 53s
-
(Locked)
The CALCULATE function14m 39s
-
(Locked)
Add filter context with FILTER: Part 19m 20s
-
(Locked)
Add filter context with FILTER: Part 214m 23s
-
(Locked)
Remove filter context with ALL9m 6s
-
(Locked)
Join data with RELATED3m 39s
-
(Locked)
Iterator ("X") functions: SUMX12m 20s
-
(Locked)
Iterator ("X") functions: RANKX5m 33s
-
(Locked)
Basic date and time functions4m 58s
-
(Locked)
Time intelligence formulas17m 2s
-
(Locked)
Speed and performance considerations3m 3s
-
(Locked)
DAX best practices2m 3s
-
(Locked)
Final section53s
-
(Locked)
Data visualization options4m 24s
-
(Locked)
Wrapping up47s
-