Intermediate Excel

8 Hours

Building on the Introduction to Excel, this workshop will enable participants to develop more advanced excel functions and incorporate macros.

• Review of Excel Functions
  
• Graphing Data
  · Introduction
  · Function Formats
  · Types of Functions
  
• Introduction to Command Macros
  · Executing Simple Commands with Macros
  · Creating Batch Programs
  
• Advanced Macro Techniques
  · Branching
  · The If Condition
  · Input Commands with Prompts
  · Creating Custom Menus
  
• Combining Files
  · Combining Files Using
  · File Combine Entire File
  · File Combine Named Range
  
• Studying and Creating Complex Spreadsheets
  
• Data File Management
  · Creating a Database
  · Sorting a File
  · Finding Records in a File
  · Selecting Records from a File