Home > Course Catalog > Microsoft Software > Excel

Microsoft Office Excel 2007: New Features Training

This outline is also available in these languages: ??languagelist??

Course #:

MSOF-170

Format:

Classroom, Online

Duration:

1 day

Price*:

315.00 USD

Professional Development Units:

Continuing Development Units:

Course Tier: ??Tier??

Per Student Kit Price: ??KitPricePerStudent??

ibm

Delivery Options:

Public Scheduled Classes - Register for classes below Search Catalog Sign Up to be notified
Self-Paced Training - Purchase below Search Catalog
Public Scheduled Webinar - Register below Sign Up to be notified
Webinar Recording - View Now

Custom Group Training - Request a proposal



See all
Format
 
Self-Paced
Purchase ??country-to-buy-from?? course Add to Cart
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Close
Location
Location
Dates
 
Virtual
Virtual
28-May-14
Contact LearnQuest
Virtual
Virtual
18-Aug-14
Contact LearnQuest


 
Classes marked with a are Guaranteed to Run on the scheduled dates.
 

There are ??othercoursecount?? similar courses in different countries and/or formats.Click here to see them.

Need a customized class for your group? Contact Us.

No classes scheduled? Sign Up to be notified when new classes are added.


*Public Price per Student


This course is designed to introduce students to the new features in Microsoft Office Excel 2007.
 


Upon completion of the course, students will be able to:
  • Explore the new and enhanced Microsoft Office Excel 2007 environment
  • Organize data in Excel worksheets using enhanced tables and table formats
  • Analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options
  • Present Excel data using enhanced charts and illustrations
  • Work with the enhanced options of PivotTables and PivotCharts for conducting selective analysis

  • Users experienced with previous versions of Excel

  • Knowledge of Excel 2003 or XP
  • Familiarity with the Internet

  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
  2. Organizing Data
    • Explore the enhancements in Excel 2007 spreadsheets
    • Insert tables
    • Format tables
  3. Analyzing Data
    • Apply conditional formatting
    • Sort data in a spreadsheet
    • Filter data in a spreadsheet
    • Apply a formula
  4. Presenting Data
    • Create charts
    • Format charts
    • Work with illustrations
    • Create PivotTables and PivotCharts
    • Share Excel charts
    • Save data in presentable formats
  5. Appendix A: New Features in Microsoft Office Excel 2007
  6. Appendix B: Enhanced File and Compatibility Features in Micrososft Office Excel 2007
     

??Testimonials??


This course is included in the following Roadmaps:

Do you have an IBM EdPack?

Find out why you should transfer to a LearnPass

Check Out the LearnQuest Blog

Read More.

Learn how you can save up to 20% on LearnPass

Click to find out more.

LearnQuest is an Authorized IBM Global Training Provider

Learn more about IBM training with LearnQuest

Training Roadmaps

Training roadmaps can help you plan your course to success

Events

LearnQuest attends and exhibits regularly at industry events.

See what some of our clients have said about us

View client testimonials
View a list of LearnQuest clients.