Single Courses

Accounts Basic Book-keeping Book-Keeping Level 2 - A Study Guide Purchase Ledger Sales Ledger Manual PAYE Final Accounts I Final Accounts II Sage Line 50 V.12 Sage Payroll V.10 Computing Internet Skills PC Basics Windows XP UK Online Windows 98 Windows Millennium Edition ECDL ECDL v4: CD Rom ECDL v4: Module 1 - Concepts in IT ECDL v4: Module 2 - Using a Computer & Managing Files ECDL: v4: Module 3 - Word Processing ECDL: v4: Module 4 - Spreadsheets ECDL: v4: Module 5 - Databases ECDL: v4: Module 6 - Presentations ECDL: v4: Module 7 - Information and Communication ECDL v4: Unit E Using IT Legal Secretarial Introductory Module Convenyancing Civil Litigation Company Law Criminal Family Law Wills & Probate Medical Secretarial Introductory Module Medical Audio Transcription MS Office Access 2007 Create, Manage & Integrate Files Excel 2000 Expert Excel 2007 Excel 2007 Expert Mail Merge Using Word 2007 Outlook 2007 PowerPoint 2007 Publisher 2007 Word and Excel…fast! Office 2007...fast! Word 2000 Expert Word 2007 Word 2007 Expert Office Admin Audio Transcription Level 1 Audio Transcription Level 2 Computer Keyboard Skills (Windows) Computer Keyboard Skills (Online Web Enabled) Effective Business Communication Faster Keyboarding Part 1 Faster Keyboarding Part 2 Keyboard Speed Development Numeric Data Entry Vocational Get Into - Marketing Get Into - Journalism Get Into - HR Get Into - PR Short Hand Shorthand Refresher Pitman New Era Refresher Teeline Fast Shorthand Teeline Shorthand Teeline Shorthand Refresher Shorthand Speed Development Web Design Dreamweaver 8 Frontpage 2000 Introduction to HTML Photoshop 6.0 Introduction

 

---

Excel 2000 Expert

Aims and Objectives

To learn advanced spreadsheet skills using Microsoft Excel

Know how to use Excel 2000 in order to sit the MOS Expert examination

The flexibility and value of self-study course designed to enable you to work at your own pace

A personalised workbook to use as a reference guide on completion of the course

The opportunity to gain the widely recognised Pitman Training Certificate

Target Audience

Those who wish to learn Excel 2000 to the Microsoft Office Specialist (MOS) Expert syllabus

Prerequisites

Knowledge of Excel 2000

Course Content

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. 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: Working with toolbars. Customising toolbars. Adding and removing buttons. Creating a new toolbar. Creating customised menus

Lesson 8: Using macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu

Lesson 9: Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values

Lesson 10: Working with data lists. Filtering lists and using custom filers. Form option buttons. Criteria option buttons

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

Lesson 12: Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating interactive pivot tables for the web

Lesson 13: Using analysing tools. Goal seeking. Using Solver. Scenario Manager

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

Course Duration: 18-20 Hours

Course Code: 1010111203