This training includes a thorough discussion of the advanced topics. Participants will be exposed to various practical and complicated scenarios.

Excel 2019, Office 365, Microsoft 365

Review of Excel Functions

Quick Review of Excel Functions
Troubleshooting Excel Error Messages
Solving Complex Problems in Excel
Advanced Logical Structures
Combining AND and OR in One Formula
Complex Nested IFs
Advanced Conditional Formatting (Formula-Based)
Advanced Lookup Scenarios
Looking Up Matrices
Using INDIRECT Function to Lookup Several Tabs
Advanced Criteria in SUMIFS, COUNTIFS, etc.
Dealing with Intermediate to Advanced Date Problems (Tenure, Ageing, etc.)
Using Arrays to Shorten Formulas
Array 1: Merging Ranges within a Formula
Array 2: Merging Formulas into one Formula
Array 3: Combining Criteria in SUMIFS
Using Wildcards to Deal with Inconsistent Arguments/Lookup Values

Using MS365 Functions in Excel

Shortening Formulas using LET Function
Using New Functions: TEXTSPLIT, IFS, XLOOKUP, etc.

Using PowerPivot to Combine Tables into One Pivot Table

Using PowerQuery to Extract and Fix Data from Other Sources
Creating Advanced Calculations in PivotTables
Customizing the Slicer

Exploring New Charts in Excel

Map Charts
Waterfall Charts

Advanced MS Excel (Level 2) Training