MICROSOFT® EXCEL (INTERMEDIATE-ADVANCED)
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.