Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.


 
Course Outline
This course is designed for users who are familiar with Excel and want to expand their knowledge.

Learning Objectives Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.

Course Outline
Working with Outlines
  • Applying an Outline
  • Expanding/Collapsing an Outline
  • Modifying Outline Settings
  • Clearing an Outline
  • Using Auto Outline
Working with subtotals
  • Creating and using Subtotal Data
  • Removing Subtotals from a List
Working with Data Forms
  • Viewing the Data Form
  • Editing Data Form Records
  • Adding Data Form Records
  • Defining Criteria
  • Clearing Data Form Criteria
  • Deleting Data Form Records
Working with Autofilter
  • Creating a Custom AutoFilter
  • Using Advance Filters
Pivot Tables
  • Creating a PivotTable Report using Wizard
  • Modifying Pivot Tables
  • Working with Pivot Tables
  • Pivot Table Charts
Importing and Exporting
  • Importing Data using MS Query
  • Changing External Data Range Properties
  • Importing a Table from a Web Page
  • Exporting Data to Other Applications

Prerequisites & Certificates
Pre-Requisites

Participants must have good working knowledge of Excel Introduction and Excel Intermediate.

Certificates offered

Certificate of completion


Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.


Map & Reviews
CompuEase
[ View Provider's Profile ]

Reviews
 
The crse was very well paced, covering all aspects of Microsoft Excel that I wanted to learn / had questions on. The trg provider is very well versed in both the subject and teaching / instructing skills, ensuring that all questions are answered before moving on to the next lesson / exercise. The crse handout booklet used and will use in the future is a great ref.
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1930 times.