Intermediate Excel

Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!
This course will help you increase your efficiency with Excel and make your work outstanding and unique.

Prerequisites

What you will learn

• Unit 1 Organizing Worksheet and Table Data
  
  - Introduction to tables
  - Formatting tables using table styles
  - Using formulas in tables
  - Sorting and Filtering table data
• Unit 2 Understanding Popular Excel Functions
  
  - Understanding Named Ranges
  - Applying business functions
  - Creating functions that handle text
  - Performing basic lookup functions
  - Creating functions that work with dates and times
• Unit 3 Improving Worksheet Appearance
  
  - Formatting cells in worksheets
  - Correcting common function errors
  - Creating and using templates
  - Customizing Excel toolbar
• Unit 4 Analyzing Data Using Data Validation and Pivot Tables
  
  - Understanding how to convert text to columns
  - Understanding how to analyze spreadsheet data
  - Understanding the basic pivot table layout and key terms
  - Creating and formatting simple pivot tables

How to register

This course is offered as part of a VCC program only.

Contact us

If you have any question, please email at advising@vcc.ca.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.