Who should attend? |
This course is intended for users who are familiar with Microsoft Excel and want to learn about the new end-user features of Microsoft Office Excel 2007, as well as the new features from Microsoft Office Excel 2002, and/or Microsoft Office Excel 2003 if required. |
Prerequisites |
Microsoft Excel 2000, Microsoft Excel 2002, or Microsoft Office Excel 2003 to an intermediate level. |
Course Objectives |
Upon completion of the course, participants will be able to accomplish the following:
- Use features and functionality pertaining to the new user interface, as well as features relating to file formats, compatibility, locating hidden data, and the Help facility.
- Use the Page Layout View, as well as formatting features that make it easy to enhance the appearance of workbooks.
- Use data management features that make it easy to work with workbook data.
- Use the import data from Web Pages feature, the Text to Speech feature, the expanded the grid size and workbook capacity, digital signatures, spell checking, PivotTables, and collaborative functionality.
|
Course Content |
|
|
User Interface and File Features
Migration Topics ; Exploring the New User Interface ; Understanding Microsoft Office Excel 2007 File Formats ; Publishing PDF and XPS Documents ; Using the Document Information Panel ; Using the Document Inspector ; Finalizing Workbooks ; Using the Updated Help System ;
|
|
Viewing and Formatting Workbooks
Migration Topics ; Using Page Layout View ; Applying and Creating Custom Themes ; Inserting SmartArt ; Using Quick Styles and Style Galleries ; Creating Charts ; Using Improved Conditional Formatting ;
|
|
Managing Data and Formulas
Migration Topics ; Resizing the Name Box and the Formula Bar ; Using the Name Manager ; Using Formula AutoComplete ; Creating Excel Tables ; Using Improved Sorting and AutoFiltering ; Using Structured References in Table Formulas ;
|
|
Supplemental Topics
Migration Topics ; Increased Grid Size and Workbook Capacity ; Using Digital Signatures ; Using the Shared Spelling Checker ; Using Improved PivotTables ; Exploring Collaborative Functionality ;
|
|
|
|
|