Microsoft Excel Introduction 2007

Excel Basics

Printing
• Exploring the Excel window
• Preparing to print
• Spreadsheet terminology
• Page set up options
• Opening and Closing workbooks
• Navigating around a worksheet Formatting and Manipulating Worksheets
• Keyboard Shortcuts and Menu Items
• Formatting text
• Formatting rows and columns

Entering and Editing Data
• Formatting numbers
• Creating a new Excel workbook
• Inserting rows and columns
• Entering and editing labels and values
• Deleting rows and columns
• Selecting cells and data ranges
• Freezing panes
• Moving and copying data
• Splitting the screen
• Linking worksheets in a workbook
• Saving and updating a workbook

Sorting and Filtering
• Using Quick Sort buttons

Formulas and Functions
• Using AutoFilter
• Creating new formulas
• Using SUM function Charts
• Using AVERAGE, MIN, MAX and COUNT
• Creating a simple chart using Chart Wizard
• Copying formulas and functions
• Formatting a chart
• Understanding Absolute and Relative references
• Editing formulas and functions