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.  Advanced MS Excel Functions

• Text Functions
  • Combining Texts
  • Changing Case
  • Other Accessory Text Functions
• Logical Functions
  • Basic IF Statements
  • Nested and Series IF Statements
• Math Functions
  • Basic Math Functions
  • Named Ranges
  • Conditional Math Functions
  • Absolute vs Relative Cell References
• Date Functions
• Array Formulas
• Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
• Advanced Lookup Functions
  • INDEX
  • 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
• Subtotal
• Consolidate Tool
• Security Options (Protecting Sheets)

Part 3.  Charts

• Basic Charts
• Combination Charts
• Sparklines

Part 4.  PivotTables

• Basic PivotTable Features
• Using Tables with PivotTables
• Refresh vs Change Data Source
• Grouping Data
• Using Slicers
• Creating Calculated Fields
• PivotCharts
• Linking PivotTables

Part 5.  Introduction to Macros

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

Public Schedule