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 ).

Name *
Email Address *
Phone Number
City / State / Area where I live
I live in this country *
Program / Start Date preferred *
Remaining characters
(you may be asked to complete a Captcha)
Address: WC1V 7JZ, London, England , UK & England
Some interested visitors submitting program inquiries to our school up to 2018-08-15 were from:

Ath, Belgium;   London;   Malta;   Tooting Broadway, London;   Manchester;   and more.
Related Schools & Programs. Inquire to our admissions team today:
Tresham College of Further and Higher Education
Courses / Programs
Tresham is a College of Further and Higher Education with campuses located one hour from London in the English East Midlands. At Tresham we offer an extensive range of computing courses to suit all abilities, right up to the Higher National Diploma offered in association with the University of Northampton.

Tresham College is an approved academy for CompTIA, CISCO and Microsoft offering a range of specialist programmes for technicians and engineers.
Full-time BTEC Diploma Courses:
- 3D and Multimedia
- Games and Software Development
- IT Technicians
...

Part Time Courses:
- Adobe - Dreamweaver
- Adobe - Flash
- Microsoft PowerPoint (Beginner to Advanced)
- Microsoft Outlook
- Search Engine Optimisation
...
PTR Associates
Courses / Programs
PTR Associates in Wokingham (33 miles west of central London), England is an IT Computer Training centre offering Instructor-led classroom based software development training. PTR have 20 years experience delivering professional IT training in a relaxed and friendly environment, focusing on the needs of the individual.

We stand out because we're different. Not all training companies are the same and at PTR we celebrate our differences. Our training courses are as flexible as possible to make sure that every delegate gets the maximum out of the experience. The quality of our instructors is second to none which is why we recently became a TAP Silver Partner - an independent recognition of training quality. We are also a Microsoft Certified Partner and have many years of experience with Microsoft products.

Flexible training through scheduled or tailored courses with standard class sizes or one-to-one courses empowers people to produce outstanding results for themselves and their organisations. Online e-Learning Course are also available.
- ASP .Net Courses
- C Programming Courses
- Cisco Courses
- Citrix Courses
- CIW Courses
- CompTia Courses
- Database Courses
- Exchange Server Courses
- Java Courses
- Linux Courses
- MCSD Courses
- MCSE Courses
- Microsoft .NET Courses
- Oracle Courses
- Perl Courses
- Programming Courses
- Security Courses
- SQL Courses
- Unix Courses
- VBA Courses
- Visual Basic Courses
- Web Design Courses
- XML Courses
& more...
Erp Training
Courses / Programs
ERP Training is Europe’s premier SAP institute based in Croydon in South London in the London Borough of Croydon, providing customer project-based Training and Placements in SAP. At ERP Training, we believe in imparting modern, high quality in-class training to both aspiring graduates and talented professionals to keep them abreast with the changing needs of the competitive market place.

We have a full team of ERP professionals including SAP, Oracle and Microsoft technologies in the areas of business processes, across various industries and organisational settings. The job opportunities available in the UK are in implementation, customisation, support, scaling, maintenance, and job upgradation, including opportunities in Europe and USA.

With years of international experience in technology and functional domains related to ERPs, we are confident in designing and delivering substantial training to individuals and corporate businesses in these areas. Our aim is to be a one-stop shop for all your training & documentation needs.

East Croydon Railway Station provides services to Central London to the north and to Sussex, Surrey, and Kent to the south.
Customer project based Training and Placements in the following areas of SAP:

* SAP Financials & Management Accounting (FICO)
* SAP Human Capital Management (HR)
* SAP Sales Order Management (SD)
* SAP Procurement (MM)
* SAP Customer Relationship Management (CRM)
* SAP Business Intelligence (BI)
* SAP Business Objects (BO)
* SAP Netweaver Administration (BASIS)
* SAP ABAP
Microsoft Training London
Courses / Programs
Microsoft Training London have provided Microsoft training (Microsoft office training) in London and UK wide since 1992 with Microsoft qualified trainers. MS office software training is provided in a range of formats, including bespoke solutions all with Instructor led training classes.
Public schedule, on-site, closed company, tailored and one-to-one courses include MS Project, Access, Excel, Powerpoint, Word, Outlook, Lotus notes, Dreamweaver, Frontpage, TNA, Visio.
The College Of Central London
Courses / Programs
Situated just 2 miles northeast of London city, in the London Borough of Hackney, The College of Central London is a private College of further and higher education, established over 37 years ago. We offer computer courses designed to provide a sound knowledge of the principles of structured programming, computer theory, information processing, computer organisations and data communications systems. Students who successfully complete courses at the college can either seek employment in the computer industry, or continue their studies in higher education.

Networking capabilities and the Microsoft Windows operating environment ensure students use software under industry standard operating systems. Students therefore develop practical skills beneficial in a commercial environment. The college ensures that each student has access to a computer. As a private college we are able to control our own fee structure and it has always been our goal to offer students quality education at affordable fees. Students come from all over the world. Overseas students make up the majority of the student fraternity, adding to a rich and diverse student community, representing 65 different countries.
Computer courses including the BTEC Higher National Diploma in Computing; City and Guilds e-Quals Advanced Diploma for IT Users; Internet Programming and Web Development. Our computer courses are designed to provide a sound knowledge of the principles of structured programming, computer theory, information processing, computer organisations and data communications systems. Overseas students welcome.
Pitman Training London
Courses / Programs
Pitman Training London have training centres in central London, located in High Holborn, Notting Hill and Paddington. We provide training in Microsoft Word, Excel, Access, PowerPoint, and Outlook as well as a Microsoft Office diploma course. The use of technology is paramount to the efficiency and effectiveness of a business, and a total command of Microsoft’s universally accepted software is crucial.

Our Microsoft courses will give you increased satisfaction and could increase your earnings potential and enhance your career prospects in today's competitive job market. Learning Microsoft Office skills is easy with Pitman Training. Our tried and trusted methods are the best available. You will work at your own pace in our comfortable premises, helped by experienced tutors as required. You choose your own hours and keep the reference materials when the course is over.

On completion, you will receive a Pitman Training Diploma that is recognised nationally and internationally by employers. We have a full range at every level to suit all-comers, whether you need your skills as serious working tools or simply to keep up with the kids.
Microsoft Office Plus Diploma Training Course includes the following core subjects:

- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Outlook
- Microsoft Access

Training in individual Microsoft Office applications can also be taken as separate courses.