This one-day Microsoft Excel 2007 Intermediate
Training Course builds on the skills and concepts taught
in Excel 2007: Basic. Students will learn how to use
multiple worksheets and workbooks efficiently, and they
will start working with more advanced formatting options
including styles, themes, backgrounds, and watermarks.
They will also learn how to create outlines and
subtotals, how to create and apply cell names, and how
to work with lists and tables. Students will save
workbooks as Web pages, insert and edit hyperlinks, and
save a workbook as a PDF file. This course also covers
advanced charting techniques, worksheet auditing and
protection, file sharing and merging, and workbook
templates. Designated as Approved Courseware. For
comprehensive certification training, students should
complete Excel 2007: Basic, Intermediate, and Advanced.
Contact us for further details.
After completing this course, students will know how to:
Using multiple worksheets and
workbooks
Using multiple workbooks
Linking
worksheets with 3-D formulas
Linking workbooks
Managing workbooks
Advanced formatting
Using
special number formats
Using functions to format text
Working with styles
Working with themes
Other
advanced formatting
Outlining and subtotals
Outlining and consolidating data
Creating subtotals
Cell and range names
Creating and using names
Managing names
Lists and tables
Examining lists
Sorting and filtering lists
Advanced filtering
Working with tables
Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Distributing workbooks
Advanced charting
Chart
formatting options
Combination charts
Graphic
elements
Documenting and auditing
Auditing
features
Comments in cells and workbooks
Protection
Workgroup collaboration
Templates and settings
Application settings
Built-in templates
Creating and
managing templates
Before taking this course, you
should be familiar with personal computers and the use
of a keyboard and a mouse. Furthermore, this course
assumes that you've completed the Excel 2007: Basic
course or have equivalent experience.
Beforetaking this course, you
should be comfortable using a personal computer and Microsoft Windows. You should have some
experience using Microsoft Excel. You will get the most
out of this course if your goal is to become proficient
in such tasks as consolidating data, using advanced
chart formatting options, sorting and filtering lists,
using special formatting options, using templates, using
error tracing features, protecting worksheets, and
linking worksheets and workbooks.
For comprehensive training, you should complete all of the following courses: Excel 2007: Basic, Excel 2007: Intermediate, and Excel 2007: Advanced.