Using Microsoft Excel

Level 1

Course Description


 

Length: 6 hours

Prerequisites: Working knowledge of Windows

 

           
 

Entering Data

•  Excel Workbook Window
•  Moving Around in a Worksheet
•  Selecting Cells in a Worksheet
•  Entering Data
•  Editing Data
•  Undoing Changes
•  Working With Workbooks
•  Inserting, Deleting, Renaming, and Moving     worksheets
•  AutoCorrect
•  AutoFill

Formatting Data

•  Excel Options
•  Page Setup
•  AutoFormat
•  Formatting Toolbar
•  Formatting Numbers
•  General Numbering
•  Currency
•  Dates
•  Time
•  Telephone Number
•  Social Security Numbers
•  Text
•  Custom Formats
•  Formatting Fonts
•  Formatting Borders
•  Formatting Patterns
•  Inserting Cells, Rows, & Columns
•  Hiding Cells, Rows, & Columns
•  Freezing Rows or Columns
•  Merge & Center
•  Comments

Printing Spreadsheets

Register For This Class

Formulas, Range Names, Copy, & Paste

•  Creating Simple Formulas
•  Using AutoSum
•  Using the Function Wizard
•  Common Function Formulas
•  Naming Cell Ranges
•  Copying Data
•  Copying Formulas
•  Copying Values
•  Moving Data