Info for MS Office Training Classes

**Functions in 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

COURSE DESCRIPTION

This course is designed for participants who have a basic knowledge of Excel functions and want to discover how advanced functions can help save time at work. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. Also learn how to create conditional formatting rules using formulas, perform complex calculations using Array formulas and create customized lists using data validation.

TOPICS COVERED INCLUDE:

• Understand and use formula auditing - Cover Review of Math Rules
• Understand and use absolute referencing - Relative Reference only part of cell and why
• Perform advanced calculations within various function library categories
  • Understand and work with Array Formulas
  • Database Functions
  • Text functions
  • Logical Functions
  • Date Functions
  • Accounting Functions
• Understand and create nested formulas
• Use wildcards with functions
• Nest functions other than If
• Conditional Formatting using functions & and validation rules

PREREQUISITE

• Comfort level with using computers - Level 3 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.