Advanced MS Excel Training

This interactive live training includes a thorough discussion of advanced functions and tools in MS Excel.

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

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

TIME

All schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from inquire@insightsmanila.com or chat with us to confirm.

Outline

This training includes a thorough discussion of the advanced topics. Participants will be exposed to various practical and complicated scenarios.

Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365

Part 1. Basic to Advanced MS Excel Functions
Text Functions

• Combining Texts (CONCATENATE)
• Extracting Values from Texts (LEFT, RIGHT, MID)
• Changing Case (UPPER, LOWER, PROPER)
• Other Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)

Logical Functions

• Basic IF Statements
• Nested and Series IF Statements
• Combining Logical Statements with AND and OR

Math Functions

• Basic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)
• Named Ranges
• Conditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)

Shortening Long Formulas with Arrays
Lookup Functions

• VLOOKUP
• Advanced Usage of VLOOKUP
• INDEX and MATCH

Part 2. Managing Data Using Excel Tools
Conditional Formatting

• Basic Conditional Formatting
• Formula-Based Formatting

Data Validation

• Basic Dropdown Menus and Cell Validations
• Advanced Dropdown Menus

Subtotal Tool

Part 3. Analyzing and Presenting Data Using PivotTables

• Basic PivotTable Features
• Refresh and Change Data Source
• Grouping Data
• Using Slicers
• PivotCharts

Part 4. Introduction to Macros (if time permits)

• Understanding Macro Security
• Macro Recording