Lesson 1: Getting Started with Excel
Exploring Spreadsheet Uses
Defining Workbooks/Worksheets
Using the Office Assistant
Lesson 2: Creating Worksheets
Creating New Workbooks
Using the AutoComplete Feature
Saving and Closing New Workbooks
Lesson 3: Modifying Worksheets
Opening Existing Workbooks
Copying Worksheet Data
Moving Worksheet Data
Cutting and Pasting Data
Deleting Data and Reversing Actions
Saving Existing Workbooks
Lesson 4: Formatting Worksheets
Inserting and Deleting Rows/Columns
Changing Column Widths/Row Heights
Using Numeric Formats
Changing the Alignment of Data
Using Conditional Formatting
Lesson 5: Printing Worksheets
Previewing Print Jobs
Using Page Break Preview
Defining Page Setup Options
Creating Headers and Footers
Printing Worksheets
Lesson 6: Formulas and Functions
Creating Formulas
Editing Formulas
Using Relative Cell References
Using Absolute Cell References
Using Mixed Cell References
Using Functions
Using AutoSum
Using AutoCalculate
Lesson 7: Using Multiple Worksheets
Working with Multiple Worksheets
Inserting and Deleting Worksheets
Moving and Copying Data Between Worksheets
Grouping Worksheets
Creating 3-Dimensional Formulas
Renaming Worksheets
Lesson 8: Enhancing Worksheets
Changing Text and Font Attributes
Adding and Modifying Borders
Creating and Modifying 3-Dimensional Objects
Lesson 9: Using Styles and AutoFormats
Creating Styles
Formatting Cells with Styles
Modifying and Deleting Styles
Using AutoFormats
Lesson 10: Working with Charts
Creating Charts
Formatting Charts
Resizing and Moving Charts
Editing Chart Data
|
