Microsoft Excel (Level 3 / Advanced)

Location: Toronto Date: 2010-02-10
List Price: $295 Offered Price: $236.00
Seats Available: 2

ctc TrainCanada ~ computer training Toronto, Markham, Mississauaga Cancellation Policy

Description:

Lesson 1.1 Outlining And Grouping Your Data

Using Automatic Outlining

Displaying And Collapsing Levels

Grouping Data Manually

Creating Subtotals

Labs Practice Exercise

Lesson 1.2 Pivottables

What Is A Pivottable?

Creating A Pivottable Frame

Specifying Data In A Pivottable

Rearranging Pivottable Data

Labs Practice Exercise

Lesson 1.3 More On Pivottables

Modifying Pivottable Calculations

Formatting A Pivottable

Refreshing A Pivottable

Charting A Pivottable

Creating A Pivottable Based On Data From An External Database

Labs Practice Exercise

Lesson 1.4 Exploring Scenarios

What Is A Scenario?

Creating A Scenario

Creating A Scenario Summary Report

Saving Multiple Scenarios

Labs Practice Exercise

Lesson 1.5 What If Analysis

Using A One And Two Input Data Table

Using Goal Seek

Using Solver

Labs Practice Exercise

Lesson 2.1 Excel And Hyperlinks

Hyperlinks And The Internet

Inserting Hyperlinks

Modifying Hyperlinks

Using The Web Toolbar

Browsing Hyperlinks In Excel

Labs Practice Exercise

Lesson 2.2 Excel Workbooks As Web Pages

Interactive And Non-Interactive Web Pages

Saving A Workbook As A Web Page

Saving A Worksheet As A Web Page

Saving A Chart As A Web Page

Saving A Range As A Web Page

Labs Practice Exercise

Lesson 2.3 Getting Data From The Internet

Importing From An External Data Source

Creating A Web Query

Saving A Web Query

Refreshing A Web Query

Labs Practice Exercise

Lesson 3.1 Creating And Using Shared Workbooks

Sharing A Workbook

Requesting Reviews

Reviewing A Workbook

Tracking Changes

Merging And Revising A Shared Workbook

Labs Practice Exercise

Lesson 3.2 Visual Basic And Macros

Adding Code To Your Macro

Adding Comments To Vba Code

Declaring Variables

Prompting For User Input

Iteration Over A Range

Using If Then Else Statements

Labs Practice Exercise

Lesson 3.3 Advanced File Management

Identifying File Properties

Searching For Files

Protecting Personal Information

Creating Back Up Files

Changing Auto-Recovery Settings

Labs Practice Exercise

Lesson 3.4 Excel Security

Digital Signatures

Macro Security

Protecting Your Workbook With A Password

Labs Practice Exercise

Lesson 3.5 Custom And Advanced Features In Excel

Customizing Excel By Changing Options

Using Custom Autofill Lists

What Is Text To Speech?

Using Detect And Repair

Labs Practice Exercise

Pre-Requisites:

Prerequisites include an introductory course in Excel or equivalent working knowledge with the software.

Certificates offered:

Certification of Completion

Duration Details:

1 day
9:00am - 4:00pm

Facility Location:

Toronto Office
595 Bay Street, Suite 302
Po Box 178
Toronto
Ontario
Canada
M5G 2C2

This listing has been viewed 22 times.