Excel 2010 Full Introduction

Microsoft Excel training
Course Code: 
Duration: 2 day
This course gives delegates a thorough introduction to the core functions and features of Microsoft Excel 2010. It is particularly suited to anyone who is new to spreadsheets and wants to quickly develop a comprehensive understanding of the basics. Throughout the course there will be a focus on applying the topics covered efficiently within a business context. At the end of the course the delegates will be able to create, edit, format and print a spreadsheet using simple formulae and create a basic chart. They will be able to manipulate data, create charts and work with multiple sheet workbooks. This course combines the topics from our Basic and Beyond Basic course.
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
Format the data to enhance the appearance of the worksheet
Create formulae to calculate worksheet data
Understand, edit and correct formulae
Create and modify simple charts
Sort and filter data
Preview and print the worksheet and change printing options
Understanding the Excel 2010 user interface
Understanding Smart Tags
Customising the Quick Access Toolbar
Opening, closing and saving a spreadsheet
Creating a spreadsheet
Inputting Data
Entering text and numbers
Inputting dates
Using 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
Moving rows and columns
Hiding rows and columns
Formatting the contents of a cell / range
Using Format Painter
Using AutoFormat
Creating a formula
Simple rules for formulae
Add, subtract, multiply and divide
Edit and understand simple formulae
Understanding cell addresses – relative and absolute references
Using dates in formulae
Troubleshooting a formula – circular references, order of precedence
Using Excel functions
Refresher on basic functions; SUM, AVERAGE, MAX, MIN, COUNT
Using AutoSum and the extended AutoSum
Creating basic =IF functions
Working with multiple sheets
Naming sheets and using colour on sheet tabs
Moving and copying sheets
Using Print Preview and Page Break Preview
Adjusting page setup options including margins, headers and footers
Setting Print Titles and Print Ranges
Using print titles for multiple page worksheets
Sorting and Filtering Data
Quick Sort
Sorting data
Filtering using AutoFilter
Introduction to Custom Filters
Creating a simple chart
Modifying a simple chart
Printing charts
Special Features
Freeze Panes