Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating &working with subtotaled lists, using various database functions to summarize data, creating &working with pivot tables & charts.


 
Course Outline
This course introduces user to Excel's advanced features and functions by showing users how to add, edit, search for, and delete records in a data list using a form. How to sort data in a data list, creating and working with subtotaled lists, using various database functions to summarize data, creating and working with pivot tables and charts, and how to import external data from various sources into Excel.

Course Content Maintaining Data Lists
  • Data List Concepts
  • Using Data Forms
  • Using Lookup Tables
Sorting List
  • Sorting Concepts
  • Sorting Lists
  • Custom Sort Orders
Filtering Lists
  • Filtering Concepts
  • Using AutoFilter
  • Using Advanced Filter
  • Working with Filtered Data
Summarizing Data
  • Changing Font Type, Size, Colour, and Styles
PivotTables
  • PivotTable Concepts
  • Creating PivotTables
  • Modifying PivotTable Layouts
  • Working with PivotTables
  • Additional PivotTable Information
  • PivotCharts
Using MS Query to Retrieve Data
  • Overview
  • Starting Query from Excel
  • Defining the Data Source
  • Query Wizard
  • Returning Data to Excel
  • Microsoft Query
  • Refreshing Data from a Query
  • Importing Query Data from Web Pages
Supplemental Topics
  • Data Parsing

Prerequisites & Certificates
Pre-Requisites

Excel 2003 - Level II or equivalent knowledge experience

Certificates offered

Certificate of completion


Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ View Provider's Profile ]

Reviews
 
The course was excellent and the instructor did a great job but why does everybody cut the time short. I think we should take a shorter lunch and get more class time instead of leaving a half of an hour early!
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 1636 times.