Advanced MS Excel (Level 2) Training

Name: Advanced MS Excel (Level 2) Training
Start: 2024-10-16T09:00:00+08:00
End: 2024-10-16T16:00:00+08:00
Location: 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

Schedule

Wed Oct 16 2024 at 09:00 am to 04:00 pm

UTC+08:00

Location

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH | Quezon City, MM

This interactive live training includes a deeper discussion of advanced functions and tools in MS Excel to solve complicated problems.
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