Microsoft® Office Excel 2007: New Features
(One-day workshop)


Date(s): Aug 28 | Sep 14 | Sep 24 (1:00-4:00 pm) | Oct 1 | Oct 31 | Nov 1 (1:00-4:00 pm) | Dec 12 (1:00-4:00 pm) | Nov 13 | Dec 6

Instructor(s): TBA

Description
You have worked with Microsoft® Office Excel 2003, and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will work with the new and enhanced features in Microsoft® Office Excel 2007.

Intended Audience
This course is designed for experienced Excel users who have worked with earlier versions of Microsoft® Office Excel, ideally Microsoft® Office Excel 2003, and who have upgraded to Microsoft® Office Excel 2007.

Prerequisites
Students enrolling in this course should understand how to use some version of Excel, preferably 2003, and have some familiarity with the Internet. This course covers the commonly used new features for a typical user. Due to the nature of this course and the minimal prerequisites, there are other, more advanced new features that are not covered in depth.

Topics Include:

  • Lesson 1: Exploring the Excel Environment
    • Explore the User Interface
    • Work with the Ribbon
    • Work with Contextual Tabs
    • Use the Excel Galleries
    • Customize the Excel Interface


  • Lesson 2: Organizing Data
    • Explore the Enhancements in Excel 2007 Spreadsheets
    • Insert Tables
    • Format Tables


  • Lesson 3: Analyzing Data
    • Apply Conditional Formatting
    • Sort Data in a Spreadsheet
    • Filter Data in a Spreadsheet
    • Apply a Formula


  • Lesson 4: Presenting Data
    • Create Charts
    • Format Charts
    • Work with Illustrations
    • Create PivotTables© and PivotCharts©
    • Share Excel Charts
    • Save Data in Presentable Formats


  • Appendix A: New Features in Microsoft Office Excel 2007

  • Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2007

To learn more about nSight training programs and for assistance, please contact our Training department at 781-273-6300 or Training@nSightWorks.com.

Go to the top of the page.

 


Join nSight's email list to receive information about our communications services, special deals, and upcoming events.
Download Fall 2007 Workshop Schedule


nSight is a Certified Provider member of the International Association for Continuing Education and Training (IACET)—a nonprofit association dedicated to quality continuing education and training programs. nSight is certified to offer continuing education credits (CEUs) to students who successfully complete its training workshops. One (1) CEU is equal to ten (10) contact hours. Learn more at www.IACET.org.

Each 1-day course offers .8 CEU. Each 2-day course offers 1.6 CEUs.

     © 2007 nSight, Inc. All Rights Reserved.