Excel 2007 Essential Training

Introduction

• Welcome

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

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

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

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

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

• Templates
• Styles
• AutoFormat

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

• Proofing your work
• Providing comments on worksheets

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

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

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

• Using templates

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

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

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

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

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

• Concatenation
• SumIf
• Lookup
• What-If Analysis

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

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

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

• Reviewing a workflow in Excel

• Conclusion