Chapter 1 - Getting Started with Excel
Chapter 2 - Entering Data and Using Number Formats
Chapter 3 - Using a Workbook
Chapter 4 - Calculating Worksheets
Chapter 5 - Proofing/Printing a Workbook
ViaLab Exercises
Chapter 1 - Getting Started with Excel
 Exploring the Excel Workspace
Examining a Worksheet
Locating/Opening Existing Workbooks
Using the Open Dialog Box
Moving Between Worksheets in a Workbook
Selecting Cells
Go To a Specific Cell
Chapter 2 - Entering Data and Using Number Formats
Entering Text and Numbers
Applying Number Formats
Modifying the Size of Columns
Using AutoFit
Modifying the Size of Rows
Chapter 3 - Using a Workbook
Creating a New Workbook
Inserting Worksheets
Moving/Deleting Worksheets
Renaming a Worksheet
Working with Series (AutoFill)
Editing Cell Content
Using Save/Save As
Modifying Alignment of Cell Content
Merging Cells
Applying Font Styles
Copying/Applying Formats
Chapter 4 - Calculating Worksheets
Arithmetic Operators
Entering Formulas in a Cell
Using Copy/Paste Commands
Using the Formula Bar
Using Excel Functions
Using the Formula Palette
Using AutoSum
Clearing Cell Content/Formatting
Using Undo/Redo
Copying a Worksheet
Chapter 5 - Proofing/Printing a Workbook
Checking Spelling
Examining Print Settings
Printing an Entire Workbook
Previewing a Worksheet
Setting Page Margins and Centering
Setting Up Headers/Footers
Setting/Clearing a Print Area
ViaLab Exercises
Changing the Cell Format
Adding Worksheets
Entering a Subtraction Formula
Checking Spelling/Printing a Worksheet
Changing the Font
|
|
