Microsoft® Excel 2007: core skills

Small & Medium Business

Packed with useful tips for users who know how to navigate the Microsoft Excel 2007 interface, this course explains how to get the results you want from Excel formulas and functions, how to find data more easily with sorts and filters, how to manage multi-sheet workbooks, how to apply page formatting, such as headers and footers and much more. 24 Ratings

	You can enrol at any time!	Enrol »
	07/11/2008 - 31/10/2010

• Find out how to select the appropriate formula or function for your current task
• Create formulas that include absolute references and named ranges
• Sort data by single or multiple columns
• Filter data by single or multiple criteria using examples and forms
• Manage a multi-sheet workbook and refer to 3D ranges in formulas
• Create custom page headers and footers
• Apply styles and conditional formatting

	» Lesson 1: Formulas and functions
	Microsoft Excel offers hundreds of formulas and functions; in this lesson, you'll try the most useful ones and learn how to get help with others you might need. You'll also explore absolute cell referencing and its role in copying formulas. » Preview the first lesson
	Lesson 2:  Working with multiple worksheets
	A Microsoft Excel workbook is more than just a single sheet. In this lesson, you will move into three dimensions and learn how to use multiple sheets, name and format sheet tabs and create formula and function references to cells on multiple sheets.
	Lesson 3:  Finding, sorting and filtering data
	Long lists of data can be intimidating, but Microsoft Excel has excellent sorting and filtering capabilities to help bring data under control. This Microsoft Excel tutorial shows you several strategies for finding and organizing data.
	Lesson 4:  Performing advanced formatting
	In this final lesson, you'll learn powerful formatting skills, such as styles, custom headers and footers and conditional formatting, for making your Microsoft Excel workbooks and spreadsheets as effective as possible.

• » Tune up your Microsoft® Windows Vista PC
• » Microsoft® Word 2007: core skills
• » Understanding Microsoft® Windows Vista Business edition