This training includes a thorough review of the basics and a thorough discussion of the advanced topics.  There are more exercises and participants will be exposed to various practical and complicated scenarios.

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.)
• Handling Date and Time Problems

Shortening Long Formulas with Arrays
Lookup Functions

• VLOOKUP
• Advanced Usage of VLOOKUP
• INDEX and MATCH

Part 2. Data Management Tools
Text-to-Columns

• Delimited
• Fixed Width

Conditional Formatting

• Basic Conditional Formatting
• Formula-Based Format

Data Validation

• Basic Dropdown Menus and Cell Validations
• Advanced Dropdown Menus
• Advanced Data Validation Scenarios

Subtotal Tool
 
Part 3.  Charts

• Basic Charts
• Combination Charts
• Other Charting Options in Excel
• Sparklines
• Using INDIRECT to Create Dynamic Charts

 
Part 4. Analyzing and Presenting Data Using PivotTables

• Basic PivotTable Features
• Refresh and Change Data Source
• Creating Calculated Fields
• Constructing Reports using PivotTables
• Grouping Data
• Using Slicers
• PivotCharts
• Creating Dashboards using PivotCharts

Part 5.  Error Handling

• Understanding Errors in Formulas
• Solving Errors in Formulas

Part 6.  Introduction to Macros

• Understanding Macro Security
• Macro Recording
• Assigning Macros to Images and Buttons