Project Description

Class Length: 2 Days

Retail Price: $300

Multiple Seat Discounts Available

Live online available!

You can learn from work, home, or here at Computer Tutors. On days that this class is scheduled, you have the option to join us using Skype for Business.

Enroll Now

Details

At the conclusion of this course, a student will have more intermediate Excel skills.  The student will be able to work more efficiently with data.  This includes the following: intermediate level functions, tables, data validation, sparklines, and more advanced editing options.

Day 1 Day 2
Functions: Text & Conditional Creating & Formatting Tables
Relative & Absolute Cell Reference Sorting Data & Text to Columns
Range Names Data Subtotals
Managing Multiple Excel Windows Filtering Data
Enhancing Appearance Conditional Formatting
New Chart Types & Options Outlines & Grouping Data
Sparklines Track Changes & History
Data Validation Comments

This course is designed for students who have some experience using Microsoft Excel version 2010 or newer.

It is recommended that the student have some working knowledge of a version of Excel or has completed the Excel New User course.