ICUC - Enabling Efficient Measurable Learning

Full Library Membership

Microsoft Office 2007

Microsoft Office 2003

Microsoft Office 2002

Microsoft Office 2000

Microsoft Windows

Other Courses

Microsoft Excel 2002


Purchase Excel 2002 for just £25.49
Submit Form

Microsoft Excel 2002

  • A complete Excel training solution that includes hands-on lessons, student assessments, reports, printable certificates and more!
  • Master what you want at your own pace and at a time and place that suits you.
  • Learn real-world skills you can apply right away with our bite-sized interactive lessons that simulate the experience of using Microsoft Excel.
  • You have the support of a UK local-rate helpline.

The Excel 2002 course is divided into 8 chapters containing a total of 80 interactive learning lessons which takes you through the skills and knowledge you need to make effective use of Microsoft Excel 2002.

The beauty? It's there all the time, at your fingertips - when you need a little help on how to do something, go to your online learning - look it up and get a refresher, in just a few minutes - no need to trouble anyone else and you don't need to remember.

The content covered:

The Fundamentals
Starting Excel 2007, What's New in Excel 2007, Understanding the Excel 2007 Program Screen, Understanding the Ribbon, Using the Microsoft Office Button and Quick Access Toolbar, Using Keyboard Commands, Using Contextual Menus and the Mini Toolbar, Using Help, Exiting Excel 2007

Worksheet Basics
Creating a New Workbook, Opening a Workbook, Navigating a Worksheet, Entering Labels, Entering Values, Selecting a Cell Range, Overview of Formulas and Using AutoSum, Entering Formulas, Using AutoFill, Understanding Absolute and Relative Cell References, Using Undo and Redo, Saving a Workbook, Previewing and Printing a Worksheet, Closing a Workbook

Editing a Worksheet
Editing Cell Contents, Cutting, Copying, and Pasting Cells, Moving and Copying Cells Using the Mouse, Using the Office Clipboard, Using the Paste Special Command, Checking Your Spelling, Inserting Cells, Rows, and Columns, Deleting Cells, Rows, and Columns, Using Find and Replace, Using Cell Comments

Formatting a Worksheet
Formatting Labels, Formatting Values, Adjusting Row Height and Column Width, Working with Cell Alignment, Adding Cell Borders, Background Colors and Patterns, Using the Format Painter, Using Cell Styles, Using Document Themes, Applying Conditional Formatting, Creating and Managing Conditional Formatting Rules, Finding and Replacing Formatting

Creating and Working with Charts
Creating a Chart, Resizing and Moving a Chart, Changing Chart Type, Applying Built-in Chart Layouts and Styles, Working with Chart Labels, Working with Chart Axes, Working with Chart Backgrounds, Working with Chart Analysis Commands, Formatting Chart Elements, Changing a Chart's Source Data, Using Chart Templates

Managing Workbooks
Viewing a Workbook, Working with the Workbook Window, Splitting and Freezing a Workbook Window, Selecting Worksheets in a Workbook, Inserting and Deleting Worksheets, Renaming, Moving and Copying Worksheets, Working with Multiple Workbooks, Hiding Rows, Columns, Worksheets and Windows, Protecting a Workbook, Protecting Worksheets and Worksheet Elements, Sharing a Workbook, Creating a Template

Working with Page Layout and Printing
Creating Headers and Footers, Using Page Breaks, Adjusting Margins and Orientation, Adjusting Size and Scale, Adding Print Titles, Gridlines and Headings, Advanced Printing Options

More Functions and Formulas
Formulas with Multiple Operators, Inserting and Editing a Function, AutoCalculate and Manual Calculation, Defining Names, Using and Managing Defined Names, Displaying and Tracing Formulas, Understanding Formula Errors