Advanced MS Excel Training

Insights Training

Date Time: February 18, 2023 | 8:30 am
Time Zone: GMT+8:00 China Taiwan Time

Total Hours

7 Hrs

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
-Connecting PivotCharts with Slicers
Part 4. Introduction to Macros
-Macro Recording
-Understanding Macros
-Assigning Macros to Buttons

About the Event

This interactive live web training includes a thorough discussion of advanced functions and tools in MS Excel. No Paypal, no problem! Pls email or chat for other payment options. This training is on February 18-19, 2023, 8:30AM-12NN via Zoom.