Excel 2007 Intermediate Study Guide

1-4239-1813-4 © 2008 Publish date: March 31, 2007 240 pages

 

Microsoft Excel 2007 Training Courseware
Intermediate Level	$25.99
<="style5 style8">** Unlimited Courseware Printing License:	Call 1-866-718-7246

 

Courseware ID: excel-2007-int-sg

The second course in our three-part series of computer training books designed to teach you MS Excel is the Excel 2007 Intermediate study guide. This course has earned a 4.9 out of 5 rating for overall quality from ProCert Labs. It builds on the basic skills and concepts you learned from following our Basic course.

The Excel 2007 Intermediate courseware covers using multiple worksheets and workbooks efficiently as well as the more advanced formatting options such as themes, styles, watermarks, and backgrounds. You will also learn about creating outlines, subtotals, and cell names as well as work with lists and tables. Finally, you will learn how to save your workbooks as a Web page and as a PDF file and how to insert hyperlinks. Other topics include advanced charting techniques, file sharing and merging, worksheet auditing and protection, and workbook templates.

Like our basic and advanced courses, the Microsoft Excel training courseware is approved curriculum for the Microsoft Certified Application Specialist program. Together, these courses will prepare you for the Excel 2007 exam (70-602).

You can learn these intermediate level techniques on your own terms using this self-directed approach to your training. Whether you complete the course in a day or take much longer is your choice. You'll move from each comprehensive unit ready to tackle the next. Hands-on activities serve to challenge you and reinforce the content.

Courseware Objectives

By following this Excel 2007 courseware, you will learn how to use 3-D formulas to link worksheets, add a Watch window, link workbooks, and create a workspace. You will know how to apply special formats and custom number formats and be able to control the display of zero values.

Other topics include using functions for formatting text, working with styles, applying themes, merging and splitting cells, transposing data, adding background colors, and adding watermarks. You will be comfortable creating outlines and subtotals and you will know how to use multiple subtotal functions. The course teaches you about cell and range names, using names in formulas, and applying 3-D names.

You will learn about sorting lists by columns, filtering lists based on specific criteria, copying filtered results, table formatting, structured referencing, naming tables, and using the [#This row] function.

Other Microsoft Excel 2007 courseware topics include saving worksheets as PDF files, publishing worksheets as web pages, working with hyperlinks, and sending worksheets as e-mail attachments.

You will learn how to format data points, work with combination charts and trendlines, add graphic elements, use auditing features, protect worksheets, add comments, share, merge, and track changes in a workbook, find and remove hidden and personal data, and mark your workbook as final.

Finally, you will know how to change the default application settings, use Excel templates, and create and manage your templates.

Courseware Contents

Unit 1 covers multiple worksheets and workbooks

• Working with multiple workbooks
• Linking worksheets and linking with 3-D formulas
• Managing workbooks

Unit 2 covers advanced formatting

• Working with special number formats
• Working with functions to format text
• Using styles
• Using themes
• Other advanced formatting

Unit 3 goes over outlining and subtotals

• Outlining and consolidating data
• Subtotals

Unit 4 covers cell and range names

• Creating names
• Managing names

Unit 5 goes over lists and tables

• Working with lists
• Sorting and filtering lists
• Advanced filtering techniques
• Tables

Unit 6 covers Web and Internet features

• Saving your Excel workbooks as Web pages
• Working with hyperlinks
• Distributing workbooks

Unit 7 discusses advanced charting

• Chart formatting options
• Combination charts
• Adding graphic elements

Unit 8 covers documenting and auditing

• Auditing features
• Entering comments in cells and workbooks
• Protecting workbooks and worksheets
• Workgroup collaboration

Unit 9 discusses templates and settings

• Application settings
• Working with built-in templates
• Creating and managing templates in Excel