Microsoft Excel 2007 Full Introduction

Excel 2007 training
Course Code: 
MSEXC2007INTR
Duration: 
Duration: 2 day
Overview: 
This course gives delegates a thorough introduction to the core functions and features of Microsoft Excel 2007. 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.
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: 

Overview
 
This course combines the topics from our Basic and Beyond Basic course.
 
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
 
COURSE CONTENT
 
Basics
Understanding the Excel 2007 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
AutoCalculate
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
 
Printing
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
 
Charts
Creating a simple chart
Modifying a simple chart
Printing charts
 
Special Features
Freeze Panes