About this Event
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
Event Venue & Nearby Stays
Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines
PHP 262.48 to PHP 2518.71