Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


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

  • Date: May. 25
  • Location: Calgary (Map)
  • Time: 9:00 am - 4:00 pm
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
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 2012
25-May-2012 $260 Regular Price $325 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer.

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 80 times.