Advanced MS Excel Training

This training will review and strengthen the basics of Excel and enhance this further with knowledge of advanced functions and tools of the program.

November 14, 2023

9AM-4PM

INCLUSIONS if joining in Cubao

• AM and PM snacks
• handouts
• certificate
• overflowing coffee
• WIFI access
• lunch (fastfood)

Where: Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC

INCLUSIONS if joining via Zoom

• PDF handouts
• PDF certificate

Outline:

Part 1. Advanced MS Excel Functions (includes review of Basic Functions)

• Combining Texts using CONCATENATE
• Changing Case of Texts
• Other Accessory Text Functions (FIND, SUBSTITUTE, etc.)

• Basic IF Statements
• Nested and Series IF Statements
• Using AND and OR to Combine Logic
• Combining IF with Other Functions

• Math and Date Functions

• Conditional Math Functions (SUMIF, COUNTIF, AVERAGEIFS, etc.)
• Using Wildcards with Math Functions

• Shortening Long Formulas with Arrays

• Basic and Other Uses of VLOOKUP
• Other Lookup Functions: XLOOKUP, INDEX, and MATCH

Part 2. Exploring the Data Tab Tools

• Basic Conditional Formatting
• Creating own Rules in Conditional Formatting
• Creating Basic Dropdown Menus and Cell Validation
• Advanced Dropdown Menu
• Subtotal Tool

Part 3. Analyzing Data Using PivotTables

• Basic PivotTable Features
• Grouping Data
• Using Slicers
• Calculated Fields
• PivotCharts
• Connecting PivotCharts with Slicers

Part 4. Introduction to Macros

• Macro Recording
• Understanding Macros
• Assigning Macros to Buttons