Enter a course name, school type and location:

Contact Page - Advanced Microsoft Excel courses

Image of Pitman Training London Pitman Training London:
As the oldest-established office skills training organisation in the UK, Pitman Training in London's Notting Hill and High Holborn offers a wide-range of courses leading to nationally recognised qualifications.

Email: Contact us below    ( or request a callback ).

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 London centres in High Holborn and Notting Hill.

Our self-paced training methodology means you can study when you want at times to suit you. All students Photo of Contact Page - Advanced Microsoft Excel courses 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.

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.

Contact Us Today - Send a Quick Email here:
( or request a callback ).

First & Family Name *
Email Address *
Phone Number
City / State / Area where I live
I live in this country *
Program / Start Date preferred *
Max. 500 characters. Currently .
Address: WC1V 7JZ, London, England , UK & England
Related Schools & Programs. Inquire to our admissions team today:
Giant Training & Development, Belfast
Courses / Programs
Giant Training is a computer training school in the heart of Belfast City offering a wide range of courses to cater for the creative markets. We provide professional training in the graphic design, publishing, internet, internet marketing, multimedia, communication, print and photographic industries. Our courses provide a wealth of training and vocational knowledge for businesses and students alike in both tailored and scheduled courses.

We have an Apple Mac and PC Training suites setup to cater for 6 trainees. Courses take place for 1-6 trainees depending upon what you require. If we do not list the course you are looking for please contact us. We have a wide network of Industry experts at hand that can cater for your needs.
Our training courses include:

- Apple
- Adobe (Photoshop, Lightroom, Illustrator, Indesign, Fireworks, Flash, Dreamweaver)
- Quark Xpress (Highest Qualified Quark trainer)
- Microsoft Office
- Social Media (Twitter for business, Facebook)
- Wacom Demonstrators
- Final Cut Pro
- Adobe Premiere
- After Effects
- Digital Photography
and many more...
Activia Training
Courses / Programs
Activia Training is an IT Applications Training school with training centres accross the UK in West London, Heathrow, Birmingham, Slough, Aylesbury & more. Activia Training offers in-class and on-site training in the Microsoft Office suite and desktop applications from Macromedia, Adobe, Sage and Lotus. We can deliver software training on your premises wherever you are in the UK, and maintain a 100% commitment to providing service of the highest standard and at prices that are among the most competitive in the market.
Microsoft Desktop training:
- Access Training
- Excel Training
- FrontPage Training
- Office Training
- Outlook Training
- PowerPoint Training

- Sage training
- Lotus training
- Crystal Reports training
- Web Design training
- Computer Skills training
& more...
Intersys Computer Training, London
Courses / Programs
Founded in 1998, Intersys provides computer training for beginners to advanced users. Providing IT solutions for many years, we offer a range of Microsoft certification courses including Microsoft Certified Systems Engineer (MCSE) and Microsoft Office Specialist (MOS). Our training facilities are situated in Twickenham which is 10 miles southwest of Central London in the borough of Richmond upon Thames and easily reached by bus and train.

Intersys will provide people with fast and efficient means to better your IT skills for daily use on your computer. Courses cover subjects such as Windows 7, Windows XP, Office 2007 (Excel, Word, Powerpoint, Outlook), Photoshop and many more software packages. Our teachers can also teach users how to use the Internet safely, or how to become a Star Ebayer.

For the more serious students, it will allow you to enter the marketplace prepared for new opportunities and open to a new area of work. Our instructors are all Microsoft qualified and classes are available on weekdays, evenings and weekends.
- MCITP: Enterprise Administrator
- MCITP: Server Administrator
- MCITP: Database Administrator and Developer
- MCSE: Microsoft Certified Systems Engineer
- MOS: Microsoft Office Specialist
- Introduction to Computers

Included: Windows 7, Windows XP, Office 2007 (Excel, Word, Powerpoint, Outlook), Photoshop and many more software packages.
Macresource Computer Training
Courses / Programs
Macresource Computer Training specialise in providing quality IT training throughout the UK on a variety of web technologies and computer software packages, especially those by Macromedia and Adobe. These software environments have become the standard for web and multimedia development since they empower companies to develop web solutions more quickly than ever. We offer three types of computer training courses: Public Training Courses at our central London training centre, on several popular software packages such as Dreamweaver and Flash; Private Training Courses, ideal for those companies or individuals who require training, away from their office, but which is tailored to their specific requirements; On-site Training Courses if you have in-house training facilities or an office which is suitable for holding a training course, we can conduct the training on your premises and using your facilities.
These include: Macromedia Dreamweaver, Macromedia Flash and ActionScript, Macromedia Fireworks, Macromedia Director, Macromedia Freehand, Adobe Acrobat, Adobe Illustrator, Adobe PageMaker, Adobe Photoshop and ImageReady, QuarkXPress, FileMaker Pro
Hands On Technology Transfer, Inc. (HOTT)
Courses / Programs
Hands On Technology Transfer, Inc. (HOTT) offers competency-based IT training programmes in 9 cities across the United Kingdom (London, Liverpool, Manchester, Leeds, Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow). These programmes are designed with one main goal; making sure you and your staff will be competent and productive. And we guarantee that our training will be more cost-effective than training from any other source. At HOTT, we guarantee the quality of our courses with a full 100% money-back guarantee, and small class sizes.
Object Oriented Analysis and Design, Java/J2EE, Web Development (HTML, JavaScript, Perl, ASP, PHP), XML Programming, UNIX/Linux, ANSI C, X/MOTIF, C++ Programming, Microsoft Visual C++, MFC, COM/DCOM, Windows System Programming and Device Drivers, Visual Basic Programming,