Intermediate for MS Office Training Classes

Intermediate Excel

********

Files: level 1 - dowload zip file

Files: level 2 - dowload zip file

Questions & Additional Info From Class:

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

COURSE LENGTH - 8 Hours

COURSE DESCRIPTION:

This course builds upon the foundational knowledge presented in the Microsoft Excel Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

• Quick 10 minute formula/function review
• Functions to cover in class:
  • Sum If,
  • AverageIf,
  • CountIf If
  • Nested Ifs
• Help with functions
• Formula auditing group
• Named Ranges
• Database functionality
• Freeze Panes
• Page Break Preview
• Data Validation Filtering Tables
• Quick 30 minute intro on Pivot Tables:
  • Create a simple pivot table using tables Refresh data

WHO SHOULD ATTEND

• Anyone comfortable with computers who would like to learn more about spreadsheet creation.

PREREQUISITE

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