This introductory course is designed for users new to Excel or those users who want to learn a little more about the basic functions of the program.
Introductory Excel Training Outline
Getting Around in Excel
- Worksheets and Workbooks
- Renaming a Worksheet
Spreadsheet Basics
- Cells, Columns and Rows
- Absolute vs. Relative References
- Relative References
- Absolute References
Entering Data
- Entering Labels
- Entering Data
- Inserting a Row or Column into a Worksheet
Manipulating Data
- Changing Column Width or Row Height
- Copying Cell Contents using Copy and Paste
- Using the AutoSum Button
- Using AutoFormat
- Moving a Range Using the Mouse
- Hidden Data
- Grouped Data
Formulas and Advanced Calculations
- Entering Formulas
- Copying a Formula using the Fill Handle
- Common Functions
- Building Formulas by Pointing
Charts and Graphics
- Using Excel to create Graphs and Chart
Printing and Reports
- Displaying and Printing Worksheet Formulas
- Page Setup Options
- Adding Headers and Footers
|
