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

• Understanding Macro Security
• Macro Recording