Excel 2010 Intermediate Course Outline
Overview
Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features. In this course, you will work with Microsoft® Office Excel® 2010 create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis. You will also learn to create shared workbooks and to track changes in shared workbooks. This course is designed for students who are interested in going beyond basic skills and need to chart and format using Microsoft® Office Excel® 2010.
*** WARNING: High Volume Class, Sign Up Early ***
This is one of our most popular classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.
Prerequisites
Excel 2010 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.
Working with Worksheets
Viewing, Renaming, and Color-coding Worksheets
Editing a Group
Manipulating Worksheets
Creating Linked Formulas
Using 3-D References
Working with Functions
Using Absolute Cell References
Creating and Using Named Ranges
Creating a Relative Named Range
Using Custom Zoom
Using Functions
Working with Insert Function
Using Financial Functions
Using Date Functions
Working with Formatting and Data Validation
Applying Conditional Formatting
Using Data Validation
Creating and Using Custom Formats
Working with Auditing and Error Checking Tools
Working with Charts
Creating Charts
Changing the Chart Location and Size
Changing the Chart Type
Modifying Chart Elements
Formatting Chart Elements
Adding and Removing Data Series
Printing Charts
Creating and Using a Chart Template
Creating a Sparkline
Using Table Features
Creating a Table
Using AutoComplete
Sorting a Table
Filtering a Table
Working with the Total Row
Creating a Calculated Column
Formatting a Table
Using Styles and Templates
Working with Cell Styles
Merging Styles
Using Templates
Creating Templates
Using Protection and Shared Workbook Features
Protecting Workbooks and Worksheets
Protecting a Workbook
Protecting a Worksheet
Allowing Users to Edit Ranges
Working with Shared Workbooks
Configuring a Workbook for Shared Use
Highlighting Tracked Changes
Creating the History Report
Reviewing Shared Workbook Changes
Merging Workbooks
View outline in Word
WEX210