Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4

In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Outline

In Microsoft® Office Excel® 2007: Level 2, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective:
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Course Content

Unit 1: Using multiple worksheets and workbooks
Topic A: Using multiple workbooks
Topic B: Linking worksheets with 3-D formulas
Topic C: Linking workbooks
Topic D: Managing workbooks

Unit 2: Advanced formatting
Topic A: Using special number formats
Topic B: Using functions to format text
Topic C: Working with styles
Topic D: Working with themes
Topic E: Other advanced formatting

Unit 3: Outlining and subtotals
Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Unit 4: Cell and range names
Topic A: Creating and using names
Topic B: Managing names

Unit 5: Lists and tables
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering
Topic D: Working with tables

Unit 6: Web and Internet features
Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks
Topic C: Distributing workbooks

Unit 7: Advanced charting
Topic A: Chart formatting options
Topic B: Combination charts
Topic C: Graphic elements

Unit 8: Documenting and auditing
Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Unit 9: Templates and settings
Topic A: Application settings
Topic B: Built-in templates
Topic C: Creating and managing templates

Prerequisites & Certificates

Before starting this course, students are recommended to take the following Element K course or possess equivalent knowledge: Microsoft Office Excel 2007: Level 1.

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, and course ware fees where applicable. 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
TekSource Corporate Learning
[ View Provider's Profile ]

I wish that there had been more examples and more exercises for pivot tables and vlook up. They are very valuable tools.
Reviewed by 2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 8794 times.