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 *
Telephone Number
City / State / Area where I live
I live in this country *
I am a citizen of *
Program/s I am interested in *
Max. 500 characters. Currently .
Preferred Starting Date
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...
One-Tech Training, North London
Courses / Programs
One-Tech Training is a private training centre in the borough of Haringey in North London, offering computer training and IT consultancy services to both UK and Overseas Students. Our training courses lead to internationally recognised qualifications from organisations like: CompTIA, Microsoft, Cisco, CIW and the British Computer Society. We offer several modes of training to suit every need including One-2-One training. One-Tech is fully accredited by the British Accreditation Council for Independent Further and Higher Education (BAC).

IT is one of the fastest growing career fields in the world today. IT skills are essential in all industries and are necessary in many diffrent job roles. We provide you with the guidance and training to help you choose a career in IT or plan your career change to IT.
- PC Support (A+)


- Web Design (Web Design Specialist, E-Commerce Specialist, CIW Web Foundations Associate, CIW Web Development Professional)

- Programming (MCTS)

- Project Management (PRINCE2)

- SAP and Software Testing
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)
Sureskills Ltd, Belfast
Courses / Programs
SureSkills is Ireland's largest independent training and IT services company with offices in Belfast (Northern Ireland) and Dublin. We offer a wide range of IT Training, Business Skills Training and IT Services to businesses and companies of all sizes in both the public and private sectors. Our aim is to deliver training that will enhance employee performance and maximise business benefits from IT systems.

SureSkills employs the largest base of certified trainers in Ireland, allowing us to offer a comprehensive range of technical training courses and certification in technologies including Microsoft, VMware, Lotus, Commvault, Dell, Cisco, Novell and CompTIA. We deliver over 40,000 days of training annually providing practical training for both current and aspiring IT professionals.

Our computer training courses include Microsoft Office & Desktop, ECDL, Project Management Training, Microsoft Windows OS and much more. Our technical training courses include Windows Server OS, Windows .NET, VMware, Citrix, CISCO and a variety of storage solutions.
IT Training & Certification Courses Include:
- Microsoft Office & Desktop
- Microsoft Windows OS
- Project Management Training
- Cisco Training
- Dell Training
- VMware
- Software Development Training
- Microsoft SharePoint
- Microsoft Server Technologies Training
- Citrix Training
and much more...
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.