Microsoft Excel (2000, XP, 2003) (Level 3 / Advanced)

Students will learn how to work with datasets by grouping data, creating pivot tables, adding hyperlinks, share workbooks, and create advanced macros.

Course Outline

This course will teach you how to use formulas and advanced functions, add and format graphics, and protect and finalize a workbook.

Course Outline

MANIPULATE DATA

• Use Automatic Outlining
• Display and Collapse Levels
• Manually Group Data
• Create Subtotals

PIVOT TABLES

• Create a Pivot Table
• Change and Rearrange Pivot Table Data
• Modify Pivot Table Format and Structure
• Chart a Pivot Table
• Create a Pivot Table from External Data

USING EXCEL WITH OTHER PROGRAMS

• Link to an Access Database
• Transform Excel into an Access Database
• Import and Export Data to and from Text and CSV files
• Import Data from External Sources
• Link and Embed from Other Sources

ADVANCED CALCULATIONS

• Create and Use Scenarios
• Create a Scenario Summary Report
• Save Multiple Scenarios
• Use a One and Two Input Data Table
• Use Goal Seek
• Use the Solver

EXCEL AND THE INTERNET

• Add, Modify and Remove Hyperlinks
• Save Workbooks, Sheets, Charts and Ranges as Webpages
• Create, Save and Refresh a Web Query
• Publish to a Document Server

ADVANCED TASKS

• Create, Open and Edit a Shared Workbook
• Track Changes in a Shared Workbook
• Create, Use and Modify Custom Lists
• Use VLOOKUP
• Consolidate Workbooks
• Link Workbooks
• Combine Worksheets
• Compare and Merge Workbooks

MACROS

• Macro Security
• Record and Play a Macro
• Record and Run a Relative Reference Macro
• Assign a Macro to a Keystroke or Quick Access Toolbar

OPTIONS

• Customize Toolbars
• Change Excel Options

FORMS

• Create a Blank User Form
• Add and Use Form Controls
• Assign a Macro to a Control

Additional Details

Pre-Requisites

Certificates offered

Certificate of Completion

Cancellation Policy

There is no consequence if you cancel/reschedule this registration with a minimum of 10 business days notice prior to the first day of this course. Full payment is required if you cancel/reschedule this registration within the non-cancellation period of 10 business days prior to the first day of the course. Substitutions are welcome.

Map & Reviews

ctc TrainCanada
[ View Provider's Profile ]

Calgary Office
900-6th Avenue SW, Suite 600
Calgary, Alberta
Canada   T2P 3K2

Reviews

 

   

The course was great.

Reviewed by Samantha H. 2012