This training includes a thorough discussion of the advanced topics.  Participants will be exposed to various practical and complicated scenarios.  A special consideration is given to Financial personnel who works with various worksheets to present different financial models.

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
  • Shortening Long Formulas with Arrays
• Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH

 Part 2.  Data Management Tools

• Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Format
• Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
• Subtotal

Part 3. PivotTables

• Basic PivotTable Features
• Tables
• Grouping Data
• Using Slicers
• Calculated Fields
• PivotCharts

Public Schedule