Excel 2007 Beyond Basics

Course Code: 
1 Day
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.
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

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

Refresher on basic formatting
Using AutoFormat
Using Format Painter

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

Creating a simple chart
Modifying a simple chart
Printing charts

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