Excel Introduction Course Outline (1 day)
*** WARNING: High Volume Class, Sign Up Early ***
Overview
Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.
Target Student
This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.
Prerequisites
Basic Windows, keyboarding and mouse skills.
Course Outline
Getting Started
Starting Excel
Opening a Workbook
Understanding the Display Screen
Working with the Ribbon
Exploring the File Tab
Working with the Quick Access Toolbar
Working with the Status Bar
Switching Between Opened Workbooks
Using Excel Help
Entering Data
Moving the Cell Pointer
Selecting a Range of Cells
Creating a New Workbook
Inserting, Renaming, and Deleting Worksheets
Entering Constant Values
Using Auto Fill to Enter Data
Saving a Workbook
Editing Cell Contents
Clearing Cell Contents
Working with Undo and Redo
Closing a Workbook
Using Formulas
Entering Formulas
Using Auto Fill with Formulas
Using the SUM Function
Summing Columns or Rows Automatically
Using Statistical Functions
Working with the Range Finder
Using Formula Error Checking
Working with Constant Values and Formulas
Copying and Pasting Constant Values and Formulas
Cutting and Pasting Constant Values and Formulas
Using Collect and Paste
Formatting Worksheets
Formatting Numbers
Changing the Font Format
Aligning Cell Contents
Merging Cells
Adding Borders
Applying Cell Styles
Modifying Columns and Rows
Changing Column Width
Changing Row Height
Inserting and Deleting Columns or Rows
Hiding Columns or Rows
Editing Workbooks
Working with AutoCorrect
Checking Spelling
Using Find and Replace
Printing Worksheets
Using Print Preview
Working with Print Settings
Using Page Setup Tools
Working in Page Layout View
Creating a Header and Footer
Using Page Break Preview
Printing a Worksheet
Exiting Excel