Excel 2007 Essential Training

A detailed look at the features and uses of Excel 2007, including how and why to use spreadsheets.

Introduction

• Welcome

1. Getting Started

• Why use a spreadsheet?
• What's changed in Excel 2007?
• The Ribbon
• The Microsoft Office Button

2. Setting Up Excel 2007

• What's on the Ribbon?
• Making your way around the Ribbon
• Customizing the Ribbon
• Customizing the Microsoft Office Button

3. Modifying Worksheets

• Opening old worksheets
• Adding and deleting worksheets
• Inserting and deleting cells
• Freezing areas of a worksheet

4. Basic Formatting

• Width and height
• Numeric formats
• Alignment of data
• Playing with fonts
• AutoFilter
• Formatting as a table

5. Advanced Formatting

• Removing duplicates
• What is Conditional Formatting?
• Working with Conditional Formatting
• Managing Conditional Formatting rule preferences
• Converting text to columns
• Data validation

6. Using Templates, Styles, and AutoFormat

• Templates
• Styles
• AutoFormat

7. Managing Lists in Excel

• Excel lists have now become tables
• Converting text to columns
• Sorting and Grouping
• Creating a summary report

8. Reviewing Worksheets

• Proofing your work
• Providing comments on worksheets

9. Sharing Worksheets

• Protecting and sharing a worksheet
• Allowing others to edit ranges
• Track Changes

10. Printing Workbooks

• Preparing to print
• Print Preview
• The Page Layout Tab
• Page Breaks
• The Page Layout View
• Headers and Footers

11. Enhancing Worksheets

• Adding themes to your worksheet
• Page setup options
• Scale to Fit
• Worksheet options
• Inserting images

12. Using Templates

• Using templates

13. Manipulating the Screen Display

• Workbook Views
• Hiding and Zooming
• Window Panes
• More screen options

14. Importing Data

• Importing from Access
• Using the Import Wizard for text files

15. Finding and Replacing Data

• The Find and Select button
• Find and Replace
• Removing duplicates

16. Working with Formulas

• What are formulas?
• Order of Operations
• Relative and absolute referencing
• The new Formula Tab

17. Working with Basic Functions

• What are Functions?
• AutoSum
• Minimum
• Trim
• Left

18. Working with Advanced Functions

• Concatenation
• SumIf
• Lookup
• What-If Analysis

19. Charts

• Why create a chart?
• Creating your chart
• Modifying your chart
• Laying out your chart

20. Pivot Tables

• What are PivotTable reports and PivotChart reports?
• Creating a PivotTable
• Laying out your PivotTable
• Designing your PivotTable
• Creating a PivotChart

21. Working with Macros

• Why use macros?
• Creating a macro
• Macro security

22. Workflow in Excel 2007

• Reviewing a workflow in Excel

Conclusion

• Conclusion