While Word and Outlook are the MS Office applications most frequently used in business situations, a large number of people assume that they know enough to use the applications without training – though, in the case of Word, they are usually incorrect, and would benefit from training. Excel is used nearly as much but a lot more people understand the need for training, meaning that introductory Excel courses are usually the most over-subscribed of any courses offered by an IT Training organization.
Overview
The basics of creating spreadsheets in Excel. Entering data, formulas, formatting and printing worksheets and workbooks
Target
For those whose job responsibilities include creating, inputting, editing, and printing basic spreadsheets
Students should know basic Windows, keyboard and mouse skills
Outline
Getting Started
Starting Excel
Opening a workbook
Understanding the display screen
Working with ribbons
The File tab
Quick Access toolbar
Status Bar
Switching between open workbooks
Excel Help
Entering Data
Moving the cell pointer
Selectig a range 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