Course curriculum
-
-
Creating a PivotTable, Using Subtotals and Grandtotals
FREE PREVIEW -
PivotTables Columns and Row Totals
-
PivotTables Styles and Grand Total Calculation
-
Setting up a Relationship in PivotTables
-
PivotTables Using Percentages
-
Advantages of using Tables to Create PivotTables
-
PivotTable Use Timeline for Dates
FREE PREVIEW -
PivotTables - 3 Things That Drive Users Crazy
-
How to Group Text in a PivotTable
-
Using Multiple Filters in a PivotTable
-
Grouping Data with XLOOKUP
-
Saving a PivotTable without Source Data
-
6 Easy tips for the PivotTable Field List
-
-
-
Data Validation: Getting Started
FREE PREVIEW -
Data Validation: Advanced - Using the INDIRECT Function
-
Protecting Cells in a Worksheet
-
-
-
IF Function: Getting Started
-
IF Functions with AND / OR Functions
-
Creating Nested IF Functions
-
IFERROR Function
-
-
-
Financial Functions: Getting Started
-
TEXTSPLIT Function
-
IMAGE Function
-
GCD Function - Greatest Common Denominator
-
3 Functions demonstrated: CONCATENATE, CHAR and TEXTJOIN
-
RATE Function example
-
SORT and UNIQUE functions
-
GROUPBY Function
-
IF / AND / OR Functions
-
Removing Duplicates with PowerQuery
-
EOMONTH (End of Month) Function
-
TEXTBEFORE and TEXTAFTER (combined)
-
DATE Function
-
INT function (Split date and time)
-
VALUE function
-
UNIQUE and FILTER functions combined
-
-
-
Data Tables: One Input Tables
-
Data Tables: Two Input Tables
-
![](https://import.cdn.thinkific.com/741268/courses/2366584/YwKFpPHRROyHCxxEFUoV_Advanced%20Thumbnail.jpg)
About this course
- $14.99
- 58 lessons
- 4.5 hours of video content