Course Description

In this course participants will work with Microsoft Office Excel® to create spreadsheets and workbooks that can be used to store, manipulate, and share data.

In the higher levels, the participants will work with charts and tables along with other useful formatting tools. They will also learn to create formulas that use built-in functions to perform advanced analysis. The class also covers the creation of shared workbooks and the tracking of changes within them.

Audience

Designed for individuals interested in increasing their knowledge and proficiency with Excel, this workshop can be of great value for participants transitioning from older versions of Excel and anyone wishing to move their Excel skills to a higher level.

Prerequisites

Prospective students should be familiar with basic computer terminology, be proficient with the use of the mouse and keyboard, and have at least six months’ experience using Microsoft Excel for level 2. Level 3 participants should have taken levels 1 and 2. Participants should understand basic mathematical principles to obtain full advantage of what the workshop offers.

Topics and Course Content

Level 1 – Course Outline

  • Program Fundamentals
  • Getting Started with Worksheets
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbook Contents
  • Create and Work with Charts

Level 2 – Course Outline

  • Create Advanced Formulas
  • Analyze Data with Logical and Lookup Functions
  • Create and Modify Tables
  • Sort and Filter Data
  • Create, Modify, and Format Charts
  • Create a PivotTable, Filter Data, and Analyze Data
  • Insert and Modify Graphic Objects
  • Customize Workbooks
  • Create and Work with Templates

Level 3 – Course Outline

  • Working with Macros
  • Auditing Worksheets
  • Analyzing Data
  • Working with Multiple Workbooks
  • Exporting Excel Data
  • The Web and External Data
  • Customizing Excel

Learning Goals and Results

Level 1 participants will be able to create a basic worksheet, perform calculations, modify a worksheet, create and work with charts, print workbook contents, and manage an Excel workbook.

Level 2 participants will be able to use advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables, Slicers, and Pivot Charts, insert and modify graphic objects in a worksheet, and customize and enhance workbooks.

Level 3 participants will be able to automate common tasks, create and edit a macro, audit workbooks to avoid errors, export data, and share data through exports and the web.

Time Investment

Each level is 48 hours of classroom time taken in 4-hour sessions over the course of 12 consecutive weeks.

Please Note: Course content and time investment can also be customized to an individual company’s needs.


Employee Application Employer Application