Microsoft Excel – Intermediate

128 Hours | 4-Weeks

Course Description

Have some experience with Excel and want to improve your skills? This course will help you learn intermediate Excel techniques.

 This course has been developed for people wanting to utilize Excel to perform calculations using a variety of common worksheet functions, templates, filter, sort and summarize database lists, format and modify charts, and conditionally format cells.

Course prerequisites

Participants will need to have attended the Beginner Microsoft Excel course or have a working knowledge of the topics covered.

Student Learning Outcomes

In this course, you will learn to create and modify complex spreadsheets and use tools that allow you to customize worksheets. You will:

  1. Understand and use a range of common worksheet functions;
  2. Understand and utilize Absolute Referencing;
  3. Organize a database list by advanced filtering and subtotaling;
  4. Utilize Conditional Formatting to change cell appearance; and
  5. Create, modify and format a range of charts.

Completion Requirements

Successful completion of the topics covered in the training course.