Advanced MS Excel (Level 2) Training

This interactive live training includes a deeper discussion of advanced functions and tools in MS Excel to solve complicated problems.

IF FULL DAY CLASS, JOIN IN CUBAO

• lunch (fast food)
• 1 AM snack
• 1 PM snack
• printed handout
• printed certificate
• overflowing coffee
• WIFI access
• BRING OWN LAPTOP

IF VIA ZOOM

• PDF certificate
• PDF handout

Where in Cubao:

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City

INCLUSIONS if joining via Zoom

• PDF handouts
• PDF certificate

Outline

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