Excel 2003 Level 3

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Objective

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Introducing the Acend Modern Classroom

Classes Guaranteed to Run

An assessment process takes place at the start of class that results in the creation of a personalized learning plan for each participant . We integrate each individual's specific project objectives with their skill gaps to create the learning prescription. The instructor assumes the role of consultant and guides each participant through the process of filling the critical gaps identified in the learning plan.

Performance-based Objectives

Upon successful completion of this course, students will be able to:

* Customize workbooks.
* Collaborate with others using workbooks.
* Audit worksheets.
* Analyze data.
* Work with multiple workbooks.
* Import and export data.
* Structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

* Topic 1A: Create a Macro
* Topic 1B: Edit a Macro
* Topic 1C: Customize Access to Excel Commands
* Topic 1D: Apply Conditional Formatting
* Topic 1E: Add Data Validation Criteria
* Topic 1F: Update a Workbook's Properties
* Topic 1G: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

* Topic 2A: Protect Files
* Topic 2B: Share a Workbook
* Topic 2C: Set Revision Tracking
* Topic 2D: Review Tracked Revisions
* Topic 2E: Merge Workbooks
* Topic 2F: Adjust Macro Settings
* Topic 2G: Administer Digital Signatures

Lesson 3: Auditing Worksheets

* Topic 3A: Trace Cell Precedents
* Topic 3B: Trace Cell Dependents
* Topic 3C: Locate Errors in Formulas
* Topic 3D: Locate Invalid Data and Formulas
* Topic 3E: Watch and Evaluate Formulas
* Topic 3F: Group and Outline Data

Lesson 4: Analyzing Data

* Topic 4A: Create a Trendline
* Topic 4B: Create Scenarios
* Topic 4C: Perform What-If Analysis
* Topic 4D: Develop a PivotTable© Report
* Topic 4E: Develop a PivotChart© Report
* Topic 4F: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

* Topic 5A: Create a Workspace
* Topic 5B: Consolidate Data
* Topic 5C: Link Cells in Different Workbooks
* Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

* Topic 6A: Export to Microsoft Word
* Topic 6B: Import a Word Table
* Topic 6C: Import Text Files

Lesson 7: Structuring XML Workbooks

* Topic 7A: Develop XML Maps
* Topic 7B: Import, Add, and Export XML Data
* Topic 7C: Manage XML Workbooks
* Topic 7D: Apply XML View Options

Additional Details

Pre-Requisites

Excel 2007 Level 2 or equivalent experience

Certificates offered

Certificate of Completion

Cancellation Policy

Cancellations or postponements received more than ten business days prior to the first day of the course will be subject to a 15% administration fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.

Map & Reviews

Acend Corporate Learning
[ View Provider's Profile ]

Toronto Training Center
69 Yonge St
Suite 1200
Toronto, Ontario
Canada   M5H 1A1

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

The amount of material was a little much (maybe an hour) to cover in the allotted time - but otherwise good.

Reviewed by Lisa K. 2011

   

The room was too cold for me. The Instructor was very helpful.

Reviewed by Agnes S. 2011

   

A co worker of mine, did not receive the certificate of completing the course. As well, I received a website to log to after the course for 30 days (The Online Support). Although the vendor ID number does not exisit. I have gone back to my contact at Last Minute Training, and haven't received any feedback from her. The course was good, the follow up, was the greatest service.

Reviewed by Jennifer S. 2011

   

Would like to have access to the on-line training materials for this course for a period of time after course completion

Reviewed by Sandra B. 2011

   

Hi - the server crashed during my session and I would like to reschedule. Can someone contact me to do this?

Reviewed by Maura A. 2011