Excel 2010 Basic

Microsoft Excel Training
Course Code: 
MSEXC2010BAS
Duration: 
Duration: 1 day
Overview: 
This course introduces delegates to the basic features of Microsoft Excel 2010. It is particularly suited to anyone who is new to spreadsheets and wants to start using the basics. Throughout the course there will be a focus on applying the topics covered within a business context. At the end of the course the delegates will be able to create, edit and print a simple spreadsheet.
Prerequisites: 
No prior knowledge of Excel or any other spreadsheet is required. However, delegates should be familiar with a keyboard, mouse and have a basic understanding of Windows.
Course Content: 

Delegates will learn how to:
Create and edit a simple worksheet
Open and save a workbook
Move around and select within a worksheet using the mouse and keyboard
Move and copy data using the Office clipboard and drag & drop
Create a simple formula
Understand, edit and correct simple formulae
Sort and filter a list
Preview and print the worksheet and change basic printing options
 
COURSE CONTENT
 
Basics
Starting Excel
Understanding the Excel 2010 user interface
Understanding Smart Tags
Opening, closing and saving a spreadsheet
Creating a spreadsheet
 
Entering Data
Entering text and numbers
Inputting dates
Introduction to Autofill
 
Editing Data
Using undo and redo to correct actions
Deleting and clearing cells or ranges
Using the spell checker
Selecting cells and ranges
Moving and copying data using the clipboard
Drag and Drop
 
Formatting basics
Inserting and deleting rows and columns
Changing the height and width of rows and columns
Simple formatting
Using AutoFormat
 
Creating a basic formula
Simple rules for formulae
Add, subtract, multiply and divide
AutoSum
Edit and understand simple formulae
AutoCalculate
 
Sorting and Filtering
Introduction to sorting
AutoFilter basics
 
Printing
Using Print Preview
Adjusting page orientation