Excel 2007 Beyond Basics

Course Code: 
MSEXC2007BB
Duration: 
1 Day
Overview: 
This course recaps the basic functions and features of Microsoft Excel 2007 and covers methods to work more efficiently. It is particularly suited to anyone who is self taught or who has previously received basic training on an earlier release of Excel. It is also ideal for those currently inputting on existing worksheets that are now faced with creating their own spreadsheets. 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 confident with formulae and basic functions, able to manipulate and chart data and work with multiple sheet workbooks.
Prerequisites: 
Prior use of Excel or another spreadsheet package is necessary. Delegates must be able to open and save a workbook, add data and print.
Course Content: 

Delegates will learn how to:
Use shortcuts to move around and select within a worksheet
Move and copy rows, columns or ranges easily
Create formulae to calculate worksheet data
Understand, edit and correct formulae
Use basic functions including =IF
Sort and filter data
Create and modify a simple chart
Preview and print the worksheet and change printing options
 

Basics
Working with the user interface
Customising the Quick Access Toolbar
Using Smart Tags
 

Inputting Data
Using AutoFill
Creating custom lists
Inputting shortcuts
 

Editing Data
Navigation and selection shortcuts
Refresher on basic editing
Using spell check
Refresher on moving and copying data using the clipboard
Drag and drop
 

Formatting
Refresher on basic formatting
Using AutoFormat
Using Format Painter
 

Formulae
Refresher on formulae
Understanding and avoiding circular references
Order of precedence
Understanding relative and absolute references
Using dates in formulae
Creating a formula with data from other sheets and workbooks
Using a 3D formula to calculate across multiple sheets
 

Using Excel functions
Refresher on basic functions; SUM, AVERAGE, MAX, MIN, COUNT
Using AutoSum and the extended AutoSum
Creating basic =IF functions
 

Working with data
Adding comments
Sorting lists
Basic use of AutoFilter
Using find and replace
Freezing panes
 

Working with multiple sheets
Naming sheets and changing the colour of sheet tabs
Moving and copying sheets
 

Charts
Creating a simple chart
Modifying a simple chart
Printing charts
 

Printing
Refresher on printing and previewing options
Adjusting page setup options including margins, headers and footers
Using print titles for multiple page worksheets