MX2007-2 - Microsoft Excel 2007: Intermediate
| Categories |
Applications Training, Microsoft Excel Training, Microsoft Office Training, MOUS Certification Training |
| Duration |
1 day (7 hours) |
| Pre-requisites |
MX2007-1 - Microsoft Excel 2007: Introduction or equivalent experience (with instructor approval).
|
|
|
|
| Courseware |
MX20072-TL (240 pages) |
| Price |
$195 |
| Notes |
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.
|
This 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 the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam (77-602). For comprehensive certification training, students should complete Excel 2007: Basic, Intermediate, and Advanced.
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