Advertisement
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
Advertisement
Event Venue & Nearby Stays
222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH, Philippines
Tickets
