Excel 2007 Level 3

Learn some of the more specialized & advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, & sharing Excel data with other applications.

Course Outline

Your training in and use of Microsoft® Office Excel® 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

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.

Course Outline

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: 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: Administer Digital Signatures
Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Troubleshoot Invalid Data and Formulas
Topic 3D: Watch and Evaluate Formulas
Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data

Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: 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 Excel Data
Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web

Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML

Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data

Additional Details

Pre-Requisites

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.

   

I loved the Adobe InDesign course but as a new user I felt there was so much material to cover and I wanted to take my time getting familiar with the program and learning about everything. I think if the class had been 2 days instead of 1 it would have been perfect!

Reviewed by Laurel A. 2012

   

Manual provided was totally different then computer training. Expected more hands on training instead of just watching an instruction video.

Reviewed by Kellie D. 2012

   

Great

Reviewed by larissa h. 2012

   

The video - was not at all interactive - only concepts were presented. The manual completedly different from the video material. I have no objections to using different approaches but a course on any software must include interactive materials.

Reviewed by Katarina F. 2012

   

The course was set up in a way which was easy to follow. However, I thought there was a lot of information to take in the day. The instructor was very helpful and very knowledgeable.

Reviewed by Bonnie . 2012

   

The training provider, Melanie, was exceptional. She was very knowledgeable and sat with me personally for hands on training. I found the course to be long and difficult to complete in one day.

Reviewed by Bonnie . 2012

   

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