|
Excel Basics
|
· Creating an Excel Workbook
· Examining the Excel Environment
· Opening an Existing Workbook
· Navigating a Worksheet
|
· Creating a New Workbook
· Saving a New Workbook
· Moving Between Workbooks
· Closing a Workbook and Exiting Excel
|
|
Working with Data
|
· Entering Text and Numbers
· Entering Simple Formulas
· Choosing Formula Cell References Manually
· Using AutoSum
|
· Changing and Deleting Data
· Using Undo and Redo
· Using Find and Replace
· Spell Checking Your Worksheet
|
|
Editing a Worksheet
|
· Working with Ranges
· Copying, Cutting, and Pasting Data
· Copying and Moving Cells Using Drag
and Drop
|
· Changing Column Width and Row Height
· Inserting and Deleting Columns and Rows
· Copying Data and Formulas with AutoFill
|
|
Formatting a Worksheet
|
· Formatting Text
· Formatting Values
· Using the Format Painter Button
· Alignment and Text Wrapping
· Merging Cells and Centering Text
· Adding Cell Borders
|
· Applying Color and Shading to Cells
· Applying Styles
· Hiding/Unhiding Rows and Columns
· Freezing and Unfreezing Rows and Columns
· Inserting and Removing Page Breaks
|
|
Page Setup and Printing
|
· Page Setup and Print Preview
· Setting Page Options
· Adjusting Margins
|
· Inserting Headers and Footers
· Adjusting Print Options
· Printing a Worksheet
|
|
Formulas and Functions
|
· Relative, Absolute, and Mixed References
· Copying Formulas
|
· Min, Max, Count and Average Functions
· The Insert Function Button
|
|
Modifying Workbooks
|
· Adding and Deleting Worksheets
· Copying, Renaming, and Repositioning Worksheets
· Grouping Worksheets
|
· Changing Worksheet Tab Colors
· Using 3-D Formulas and References
|