Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


Excel 2013 Intermediate Course Outline

 (1 day)
Version 2013

*** 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.

Need Training Outside of Regular Work Hours?
We also offer this class in an after hours format. Check out our after hours classes by clicking on this link.

Classes After Hours


Prerequisites
Excel 2013 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 Absolute Named Ranges
Creating a Relative Named Range
Using Custom Zoom
Using Functions
Working with Insert Function
Using Financial Functions
Using Date Functions
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
Applying a Chart Filter
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
Creating a Slicer
Working with the Total Row
Creating a Calculated Column
Formatting a Table

Working with Formatting and Data Validation
Applying Conditional Formatting
Using Data Validation
Creating and Using Custom Formats
Using the Quick Analysis Tool

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

Using Styles and Templates
Working with Cell Styles
Merging Styles
Using Templates
Creating Templates
View outline in Word

WEX213

Attend hands-on, instructor-led Excel 2013 Intermediate training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)
More dates...

Fee:  $295

Savings options:

 CEA Apps Saver
 Office 5 for 4
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com