Chris Menard Training

Excel Advanced Files

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

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: 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

VSTACK and HSTACK for data organisation

GEOMEAN vs AVERAGE

TOCOL Function

Data Tables: One Input Tables

Data Tables: Two Input Tables