This freely available Excel course focuses on preparing you to take the Microsoft Office User Specialist (MOUS) Excel 2002 Core exam. It assumes familiarity with Excel 2000 or Excel 2002, and is intended to assist users in reviewing how to use Excel 2002 in developing and creating spreadsheets. In this course, you will review the Excel 2002 features used when working with cells, including entering data into cells, editing cells, moving cells, and creating hyperlinks in a spreadsheet.
For each training module below, a link for text-only training content is listed first, followed by the link for computer based training (CBT) with Graphics, for which the quizzes are not freely available and Internet Explorer is required.
Excel 2002: Working with Cells:
Text-only training:
http://tinyurl.com/j9fqf
CBT training:
http://tinyurl.com/znau3
In this unit, you will explore the types of data that can be entered into a spreadsheet, as well as ways to select a cell and format its contents.
Excel 2002: Working with Files:
Text-only training:
http://tinyurl.com/gvt8x
CBT training:
http://tinyurl.com/z8ofj
In this unit, you will discover how to locate and open a file using different search options. You will also learn how to use Excel to create folders to help you organize your files. Finally, you will use templates to create workbooks.
Excel 2002: Formatting Worksheets:
Text-only training:
http://tinyurl.com/fdr6n
CBT training:
http://tinyurl.com/hczjz
In this unit, you will learn different methods for applying formatting changes to cells, including font changes, borders, patterns, and background color.
Excel 2002: Page Setup and Printing:
Text-only training:
http://tinyurl.com/jd45b
CBT training:
http://tinyurl.com/zyeor
In this unit, you'll learn how to preview and print worksheets, and you'll learn how to use the print options available to you in the Print dialog box and the Print Preview window. You'll also learn how to preview a worksheet as a Web page before you convert it.
Excel 2002: Worksheets and Workbooks:
Text-only training:
http://tinyurl.com/ekcjj
CBT training:
http://tinyurl.com/kmwcu
In this unit, you will learn how to insert and delete rows and columns. You will also learn how to hide and unhide rows and columns. Finally, you will learn how to freeze and unfreeze rows and columns, and split a worksheet.
Excel 2002: Formulas and Functions:
Text-only training:
http://tinyurl.com/ermab
CBT training:
http://tinyurl.com/k8cvd
In this unit, you will be working with formulas. You will learn how to create a formula by typing and by selecting cell references. You will also learn how to revise formulas.
Excel 2002: Charts and Objects:
Text-only training:
http://tinyurl.com/j8zng
CBT training:
http://tinyurl.com/l4zre
In this unit, you'll learn two ways to create a chart. You'll learn how to create a default chart quickly. You'll also learn how to create a chart specific to your needs using the Chart Wizard.
For each training module below, a link for text-only training content is listed first, followed by the link for computer based training (CBT) with Graphics, for which the quizzes are not freely available and Internet Explorer is required.
Excel 2002: Working with Cells:
Text-only training:
http://tinyurl.com/j9fqf
CBT training:
http://tinyurl.com/znau3
In this unit, you will explore the types of data that can be entered into a spreadsheet, as well as ways to select a cell and format its contents.
Excel 2002: Working with Files:
Text-only training:
http://tinyurl.com/gvt8x
CBT training:
http://tinyurl.com/z8ofj
In this unit, you will discover how to locate and open a file using different search options. You will also learn how to use Excel to create folders to help you organize your files. Finally, you will use templates to create workbooks.
Excel 2002: Formatting Worksheets:
Text-only training:
http://tinyurl.com/fdr6n
CBT training:
http://tinyurl.com/hczjz
In this unit, you will learn different methods for applying formatting changes to cells, including font changes, borders, patterns, and background color.
Excel 2002: Page Setup and Printing:
Text-only training:
http://tinyurl.com/jd45b
CBT training:
http://tinyurl.com/zyeor
In this unit, you'll learn how to preview and print worksheets, and you'll learn how to use the print options available to you in the Print dialog box and the Print Preview window. You'll also learn how to preview a worksheet as a Web page before you convert it.
Excel 2002: Worksheets and Workbooks:
Text-only training:
http://tinyurl.com/ekcjj
CBT training:
http://tinyurl.com/kmwcu
In this unit, you will learn how to insert and delete rows and columns. You will also learn how to hide and unhide rows and columns. Finally, you will learn how to freeze and unfreeze rows and columns, and split a worksheet.
Excel 2002: Formulas and Functions:
Text-only training:
http://tinyurl.com/ermab
CBT training:
http://tinyurl.com/k8cvd
In this unit, you will be working with formulas. You will learn how to create a formula by typing and by selecting cell references. You will also learn how to revise formulas.
Excel 2002: Charts and Objects:
Text-only training:
http://tinyurl.com/j8zng
CBT training:
http://tinyurl.com/l4zre
In this unit, you'll learn two ways to create a chart. You'll learn how to create a default chart quickly. You'll also learn how to create a chart specific to your needs using the Chart Wizard.