Pitman Training Microsoft Excel Expert Certificate

Course Title: Pitman Training Excel 2003 Expert Certificate (PTXECT)

Awarding Body: Pitman Training
Pitman Training is the largest independent training network in Ireland offering local solutions to businesses and individuals alike. With Pitman Training you have the best choice of training options:
· Career Solutions with its renowned National Diploma Programme
· Fully flexible IT and Office Skills training – attend when you like
· Classroom training courses tailored for all levels
· Seminar courses to develop personal skills
· Online training and Home Study options
· IT Technical learning tracks with full mentoring support

Intended Audience:
Those who wish to learn this popular spreadsheet program to Microsoft Office Specialist (MOS) Expert level.

Entry Requirements: Working knowledge of Excel or completion of MS Excel Proficient Course.


Exemptions: Exemptions are granted by modules based on previous Pitman Training Certification.

Course Details

Lesson One - 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 - 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 - 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 - 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 - 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 - 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 - Protecting worksheets and workbooks, applying and removing passwords, sharing a workbook, merging workbooks, understanding workbook history, track changes, accept or reject changes, using digital signatures

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

Duration: 18 Hours flexi study

Cost: Contact us for more details

Further Study: Pitman Training Office Certificate or Diploma Range of courses