Executive PA
- This Diploma is designed for Individuals who wish to gain comprehensive secretarial, business and computer skills in preparation for a career as a Personal Assistant.
Legal
- Whether you are a newly experienced secretary or have been in a secretarial position for a while, you may be looking at how to advance your career.
Medical
- The Medical Secretary Diploma covers a comprehensive range of practical skills and information, essential for a secretary working in the medical profession.
Secretarial
- The Secretarial Diploma covers a wide range of skills required by effective secretaries and you'll find yourself as a crucial mechanism to an organisations success.
Receptionist
- This Diploma gives you the necessary skills in telephone call handling, keyboarding, good administrative skills and the essentials of a good receptionist.
Microsoft Office
- This Diploma is designed for Individuals who wish to validate their skills using Microsoft Office applications.
Accounting
- This Diploma is designed for Those who wish to develop a range of manual and computerised book keeping and payroll skills.
Business IT
- This Diploma will cover a wide range of skills - from touch-typing to mastery of the most common programs in Microsoft Office.
Web Design
- This Diploma provides you with the vital skills for a successful career as a web support technician leading on to the well paid employment opportunities in web design.

Don't delay call today!
0800 0646 500

Excel Training For Advanced And Expert Users.

Aimed at proficient users of Microsoft Excel, the leading spreadsheet, this is the higher level of our two Excel courses, designed to take you to an advanced, expert level in only 25 study hours at our comfortable Pitman Training centres.

Our self-paced training methodology means you can study when you want at times to suit you.

All students receive a high-quality workbook and on successfully passing a final exam, sought-after Pitman Training and Microsoft IT Academy certificates!

You'll leave this fascinating course able to prove your ability with pivot tables, analysis tools and data management.

You'll enjoy confidently creating Excel templates, working with multiple worksheets and providing all the necessary frameworks for cash flow and P&L projections.

Our friendly tutors will be with you every step of the way on this in-depth, 8 lesson course.

To enrol or find out more, call

Bromley: 0208 313 3882

Chatham: 01634 818400

Croydon: 0208 688 0378

Dartford: 01322 220430

Gravesend: 01474 320734

Maidstone: 01622 693141

Sittingbourne: 01795 423338

Tunbridge Wells: 01892 545228

Or contact us by email.

What Is Covered.

In 8 lessons, you will learn:

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 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 from 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

To find out more or to make your booking, just call