Microsoft Excel (2007, 2010) (Level 3 / Advanced)

This course will teach you how to create outlines and subtotals, Pivot Tables and Reports, create and use Macros and Forms. Items marked with an asterisk are for 2010 only.

Course Outline

This course will teach you how to create outlines and subtotals, Pivot Tables and Reports, create and use Macros and Forms. Items marked with an asterisk are for 2010 only.

Course Outline
EXPLORE THE USER INTERFACE (IF REQUIRED FOR UPGRADE STUDENTS)

• Office Button (2007)
• Backstage View
• Ribbon Overview
• Mini Toolbar
• Status Bar
• Shortcut Key Tips
• Contextual Tabs

OPTIONS

• Change Excel Options

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
• Use Slicer to Filter Pivot Table Data*
• Use Sparklines*
• Use the PowerPivot Add In*

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 INTERENT

• 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
• Use Sharepoint 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

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

FORMS

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

Additional Details

Pre-Requisites

The prerequisites for this course are the successful completion of an intermediate course on Excel or several months experience with the software. A good knowledge of the Windows environment is also required.

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 ]

Ottawa Office
Suite 220, 350 Sparks Street
Delta Office Tower
Ottawa, Ontario
Canada   K1R 7S8

Reviews

 

   

Very helpful course. Excellent instructor.

Reviewed by Lesley A. 2012

   

This level of Excel should not be considered as advanced level. It is rather biginner level. I was expecting to learn more. 95% of the content I already knew.

Reviewed by Rehan F. 2012

   

The course is good for a basic overview of many advanced Excel features. The instructor and facilities were good. However, some of the items listed on the syllabus (new features in Excel 2010) were NOT covered and it wasn't due to a lack of time. I came to find out that the instructor had not planned to cover them at all. This was very disappointing, especially since we took very look breaks (easily almost 2 hours of combined break time in a class that went from 9-4) so there was ample time to cover the topics.

Reviewed by Zainab A. 2011