Excel 2003

Designed for beginners to spreadsheets who wish to progress to learn Excel 2003 to the Microsoft Office User Specialist (MOUS) core user syllabus. Students will need experience of using a Windows operating system and ideally keyboarding skills.

The course lasts for about 20 hours and covers the following topics:

Lesson One – Including: The Excel 2003 screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help

Lesson Two – Including: Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format

Lesson Three – Including: Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard

Lesson Four – Including: AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template

Lesson Five – Including: Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references

Lesson Six – Including: Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments

Lesson Seven – Including: Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace

Lesson Eight – Including: Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram

Excel 2003 Expert

Ideal for anyone wishing to learn Excel 2003 to the Microsoft Office Specialist (MOS) Expert syllabus. Students will need prior knowledge of Excel to proficient level.

The course lasts for about 18 hours and covers the following topics:

Lesson One - Including: Creating a template, using an existing template, editing a template, creating custom views, deleting custom views, consolidating data, creating a workspace file, using workspace files, creating and modifying custom number formats, using conditional formatting, deleting conditional formatting

Lesson Two - Including: Printing grouped worksheets and multiple workbooks, naming and modifying cell ranges, moving a named range, using range names to locate data, deleting a named range, using range names in calculations, formatting and resizing graphics, formatting charts and diagrams, finding trends in data

Lesson Three - Including: Setting security levels for macros, creating macros, running macros, editing a macro, creating a toolbar and menu to hold macros, deleting macros, deleting a toolbar button, deleting a custom toolbar and menu

Lesson Four - Including: Applying data validation rules, adding input messages and error alerts, locating invalid data, tracing precedents and dependents, tracing errors, evaluating formulas, using the watch window, using AutoFilter and Advanced Filter, using a data form

Lesson Five - Including: Compiling subtotals and consolidations, summarising data using outlining tools, using the database functions DSUM and DAVERAGE, using the Query Wizard with an external data source, analysing data using pivot tables, creating a pivot table chart, creating a pivot table chart, creating a pivot table from external data

Lesson Six - Including: Using data analysis to calculate rank and percentile, solving a problem using goal seek, using solver to calculate a quotation, creating What-If Analyses using the scenario manager

Lesson Seven - Including: Protecting worksheets and workbooks, applying and removing passwords, sharing a workbook, merging workbooks, understanding workbook history, track changes , eccept or reject changes, using digital signatures

Lesson Eight - Including: Inserting an embedded object inserting a linked object, retrieving data fro the web, saving as a web page, publishing worksheets, editing a web page and republish, saving an Excel workbook as an XML document, mapping daa in a workbook, importing an XML document into an existing mapping

Excel Introduction

Designed for beginners to spreadsheets who wish to progress to learn Excel 2000 to the Microsoft Office User Specialist (MOUS) core user syllabus. Students will need experience of using a Windows operating system and ideally keyboarding skills.

The course lasts for about 20 hours and covers the following topics:

Lesson 1: Creating a spreadsheet, Entering text and numbers, Navigating a spreadsheet, Saving, naming and closing a spreadsheet, Opening an existing spreadsheet, Editing cell contents.

Lesson 2: Formatting, Selecting cells and ranges, Text alignment, Merging and centring, Printing, Inserting and deleting rows, Simple formulas, Moving and copying cells, AutoFill, Editing formulas.

Lesson 3: Using AutoComplete, Freezing and Unfreezing panes, Text orientation, Page break preview, Changing page orientation, Adjusting margins and scaling, Centring horizontally and vertically, Displaying gridlines, Inserting headers and footers, Printing selected data, Naming a worksheet, Deleting a worksheet.

Lesson 4: Using AutoCalculate, Applying absolute cell references, Cell formatting, Using more complex formulas, Applying borders, Using styles

Lesson 5: Inserting a new worksheet, Naming a worksheet, Grouping and ungrouping worksheets, Applying wrap text formatting, Indenting text, Creating linked formulas, Printing row and column headings, Centring text horizontally and vertically.

Lesson 6: Using the SUM and COUNT functions, Using the formula palette to enter formulas for AVERAGE, MAX and MIN, Sorting columns, Using the Now, Date, IF, PMT and FV functions.

Lesson 7: Using the Chart Wizard, Formatting and editing charts, Saving selected data and a workbook as a web page, Inserting and using a hyperlink, Sending a workbook via email, Deleting an object, Using find and replace

Excel Expert

Ideal for anyone wishing to learn Excel 2000 to the Microsoft Office Specialist (MOS) Expert syllabus. Students will need prior knowledge of Excel to proficient level.

The course lasts for about 20 hours and covers the following topics:

Lesson 1 - Importing and exporting data. Object linking and embedding. Importing data from web files.

Lesson 2 – Using templates. Creating and applying custom templates. Editing and storing templates.

Lesson 3 – Using multiple workbooks. Linking workbooks. Linking workbooks. Creating and using workspace files.

Lesson 4 – Formatting numbers. Using custom formats. Using conditional formats.

Lesson 5 – Printing workbooks. Grouping worksheets. Printing multiple workbooks. Using the report manager.

Lesson 6 – Working with named ranges. Moving and deleting a named range. Range names in calculations. Adding and removing toolbar buttons. Creating toolbars.

Lesson 7 – Using Macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu.

Lesson 8 - Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values.

Lesson 9 – Working with data lists. Filtering lists and using custom filters. Form option buttons. Criteria option buttons.

Lesson 10 – Data management. Searching for data with advanced filters. Summarising data with outlines. Querying a database. Controlling formatting and layout. Refreshing external data.

Lesson 11 – Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating Interactive Pivot tables for the web.

Lesson 12 – Using Analysis Tools. Goal seeking. Using Solver. Scenario Manager

Lesson 13 – Workgroups. Applying worksheets protection. Password protecting a file. Adding comments to the worksheet. Working with shared workbooks. Merging workbooks. Tracking changes and resolving conflicts.