Info for MS Office Training Classes

**Advanced Excel

Files: level 1 - dowload zip file

Files: level 2 - dowload zip file

Files: level 3 - dowload zip file

Questions & Additional Info From Class:

• **keyboard Shortcuts**
• PEMDAS - important for formulas

COURSE LENGTH - 8 Hours

TOPICS COVERED INCLUDE:

• Level 2 Review
• Advanced Excel Functions:
  • Vlookup
  • Match
  • Index
• Importing/Exporting Data
• Analytical Tools:
  • Goal Seek
  • Scenario
  • Solver
• Running and Recording a Macro
• Create a button and save a shortcut key
• Where to save macros Different types of macros
• Advanced Charts Combo
• Chart Advanced filtering and database function (if time permits)

PREREQUISITE

• Comfort level with using computers - Level 2 or equivalant skills

METHOD OF TRAINING

• Remote - Live. Course will be facilitated to engage participants in active learning to support knowledge retention. In an interactive learning environment, participants will have numerous opportunities to apply what they are learning to their workplace and to practice skills learned.

COURSE TRAINING PROVIDER

• Center for Business & Technology at CCM
• For questions or to schedule a course delivery, please call 973-328-5188.