 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will create, edit, format and print basic worksheets and charts in Excel.
Students will learn how to use an electronic spreadsheet to create basic worksheets and charts.
Prerequisites:
Windows Introduction, or equivalent knowledge.
Unit 1 : Getting Started
Enter Data in a Worksheet
Edit Data
Change Text Appearance
Save a Workbook
Obtain Help
Unit 2 : Editing Your Worksheet
Move Data to Other Cells
Copy Data to Other Cells
Fill Cells with a Series of Data
Insert and Delete Rows and Columns
Undo and Redo an Entry
Find and Replace Numbers
Enter Data in a Range
Verify Data in a Range
Unit 3 : Performing Calculations
Sum a Range of Data
Use a Built-in Function
Copy a Formula
Create an Absolute Reference
Unit 4 : Formatting
Specify Numeric Format
Create a Custom Numeric Format
Change Font Size and Type
Create and Apply Styles
Add Borders to Cells
Find and Replace Formats
Change Column Width and Row Height
Shrink Text to Fit
Align Cell Contents
Merge and Split Cells
Apply an AutoFormat
Unit 5 : Working with Multiple Worksheets
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Copy Worksheets
Change the Number of Worksheets
Unit 6 : Creating and Modifying Charts
Create a Chart
Modify Chart Items
Format a Chart
Change the Chart Type
Unit 7 : Setting Page Display and Printing Options
Freeze and Unfreeze Rows and Columns
Set Print Titles
Set Page Margins
Create a Header and Footer
Change Page Orientation
Insert and Remove a Page Break
Print a Range