.5 - day course
Print this page
Course Code: S174en
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 ;