SPREADSHEETS
Email the course tutor Caron or telephone 0116 232 5166

Distance Learning / Home Study

• FD9 - Microsoft^® Excel Introduction

• FD9i - Microsoft^® Excel Intermediate

• FD10 - Microsoft^® Excel Advanced

FD9 - Microsoft^® Excel Introduction

Using Microsoft^® Excel 97, 2000 or XP this course is suitable if you have little or no experience of the program. Available as a distance learning / home study course.

Topics include:

Introduction; Getting Started; 
Creating Worksheets; 
Open, Close, New and Save As; 
Views, Toolbars and Options; 
Editing Cell Contents; Spreadsheet Mathematics; Building Formulae; Working with Functions; Relative and Absolute References; Navigation and Movement Techniques; Copying and Moving Data; 
Page Setup Options; Inserting and Removing Pagebreaks; Spellchecker; Layout, Headers and Footers; Undo and Repeat Last Command;
Number Format and Format Painter; 
Formatting Cells and AutoFormat; 
Rows and Columns, (Inserting and Deleting); 
Printing and Print Preview; Printing the Formulas;
What If? and Goal Seek; 
(May also include an introduction to Charts).

Certificate upon completion

FD9i - Microsoft^® Excel Intermediate

Using Microsoft^® Excel 97, 2000 or XP this course follows on from the introductory level. Available as a distance learning / home study course.

Option 1   
This course is suitable if you wish to concentrate on setting up worksheets using different formulas and also mastering chart techniques.  It includes:  

Working with Workbooks; Building Formulae and Using Functions; (SUM, MAX, MIN, AVERAGE, COUNT, IF, DATE); Relative and Absolute References; Filling Cells and Number Series; Page Setup; Cell Names and Comments; Custom Lists and AutoComplete; Linking Sheets and Workbooks; What If? and Goal Seek; Creating Charts and Chart Options; Formatting Charts; Moving and Re0sizing Charts; Charts with Multiple Data Series; Updating and Deleting Charts.

Option 2
Topics for this option include:

Introduction and Course Objectives; The Open and Save As Dialog Boxes; The Look In List Box and Sorting Files; Sharing Files Between Different Versions of Excel; Working with Workbooks; Linking Sheets and Workbooks; Managing and Renaming Sheets; Copying and Moving Sheets; Deleting and Inserting Sheets; Changing Defaults; More about Relative and Absolute References; Marking Cell References as Absolute; More about What If? and Goal Seek;  Filling Cells and Number Series; Using Fill Right, Down and Across Worksheets; Using AutoFill Values, Series, Dates, Text and Numbers; Custom Lists and AutoComplete; Setting Up and Using Custom Lists; Using AutoComplete and Pick From List; Cell Names and Comments; Naming Names and Defining Names; Using Cell Names for Navigation and in Formulas on Large Worksheets; Creating, Editing and Deleting Comments; More about Page Setup; Page Options, Orientation and Scaling; Headers and Footers; Margin and Sheet Options; Grid Lines, Page Breaks and Printing Titles; Creating Charts; Creating, Moving and Re-sizing Charts; Using the Chart Toolbar and the Chart Menu; Charts with Multiple Data Series and Custom Chart Types; Formatting Charts and Chart Objects; Patterns, Legends, Fonts and Grid Lines; Data Series; Pictures, Text Boxes and Drawing Tools; Inserting Pictures and Adding Borders; Changing Object Properties; Using Text Boxes and Drawing Tools; Grouping and Ungrouping Objects; Finding Data and Using Replace;  Sorting Data and Sort Options; Excel and Databases; Fields and Records.

Certificate upon completion

FD10 - Microsoft^® Excel Advanced

Using Microsoft^® Excel 97, 2000 or XP this course follows on from the introductory and intermediate levels. Available as a distance learning / home study course.

Topics include:

Introduction and Course Objectives; More about Functions; The COUNT Function; Maximum and Minimum Values; Using AutoCalculate; The TODAY Function; Conditional Functions; The IF Function, Embedded or Nested IFs; Data Forms and Filters; Using the Advanced Filter Options; Setting up the Criteria and Running the Filter; Creating and Using Macros; Assigning Shortcut Keys; Using Audit; Finding Cell Errors; Tracing Precedents and Dependents; Attaching a Comment to a Cell; Finding Invalid Data; More about Goal Seek; Data Tables and What If? Analysis; Financial Functions; Using Functions to Create a Table Comparing Different Interest Rates, Loan Terms, Loan Amounts and Repayments. Creating, Editing and Deleting Scenarios; Using Subtotals and Creating Charts from the Subtotals; Using the Outline Symbols; Using Functions with Subtotals and Hidden Rows; Pivot Tables and Pivot Charts; Using the MATCH and LOOKUP Functions; Workbook Security; Locking Cells and Protecting Worksheets; Using Read-only and Passwords to Open and Modify.

Certificate upon completion