Intro to Microsoft Excel 2007
for Business

This 4-hour course is designed to introduce you to the enhanced capabilities and efficiencies of Microsoft Excel 2007.

• What's New in Excel 2007?
• Becoming Familiar with the New User Interface
• Managing Larger Data Collections
• Understanding the New Office File Formats
• Formatting Cells and Worksheets
• Managing Data Tables More Effectively
• Creating Formulas More Easily
• Summarizing Data
• Creating Powerful Conditional Formats
• Creating More Attractive Charts
• Controlling Printouts More Carefully
• Setting Up a Workbook
• Creating Workbooks
• Modifying Workbooks
• Modifying Worksheets
• Customizing the Excel Program Window
• Working with Data and Data Tables
• Entering and Revising Data
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheeet Data
• Defining a Table
• Performing Calculations on Data
• Naming Groups of Data
• Creating Formulas to Calculate Values
• Summarizing Data That Meets Specific Conditions
• Finding and Correcting Errors in Calculations
• Changing Workbook Appearance
• Formatting Cells
• Defining Styles
• Applying Workbook Themes and Table Styles
• Making Numbers Easier to Read
• Changing the Appearance of Data Based on Its Value
• Adding Images to Worksheets
• Focusing on Specific Data by Using Filters
• Limiting Data That Appears on Your Screen
• Manipulating List Data
• Defining Valid Sets of Values for Ranges of Cells
• Reordering and Summarizing Data
• Sorting Data Lists
• Organizing Data into Levels
• Looking Up Information in a Data List
• Combining Data from Multiple Sources
• Using Data Lists as Templates for Other Lists
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data
• Printing
• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing
• Printing Data Lists
• Printing Parts of Data Lists
• Printing Charts