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:
New Horizons London
Courses / Programs
New Horizons is the world’s largest independent IT training company providing a variety of computer training courses including, Microsoft Training, Cisco Training and CompTIA Training. New Horizons has over 300 centres in 60 countries.

New Horizons London is conveniently located in Devonshire Square in central London, within a 2 minute walk of Liverpool Street Station (Circle, Central, Hammersmith and Metropolitan Lines) and Aldgate Station (Metropolitan and Circle Lines). There is excellent access to and from the city via underground, bus or train.

Through an integrated learning approach New Horizons delivers a wide range of technology and business skills computer training from basic application and desktop productivity tools to complex IT systems. We help clients and individuals who need to upskill and get IT certified.
Computer Training Certification Courses including Microsoft Training, Cisco Training & CompTIA Training Courses:

- Business Skills courses
- Cisco courses
- CompTIA courses
- Design and Media courses
- Information Security courses
- Microsoft Windows 7
- Microsoft Technical courses
- Mentored Learning courses
- Microsoft Application courses
- Online Live courses
- VMware courses
Mullan Training, Belfast
Courses / Programs
Mullan Training is a Northern Ireland based Computer Training Provider and has been providing high quality training to the public and private sectors for over 15 years. Based at Blackstaff Studios (Amelia Street, Belfast), we occupy spacious fully air-conditioned training suites right in the heart of Belfast City Centre - Just opposite the Europa Hotel.

We offer flexible & comprehensive training packages and specialise in customised courses - where appropriate, clients can use their own data for closed courses. Our extensive range of public and closed courses includes Microsoft, Macromedia, Adobe Creative Suite, QuarkXpress, Crystal Reports, Business Objects and many more.
- Microsoft Office
- Microsoft Office 2007
- Microsoft Office Specialist
- Adobe (Including CS3)
- Desk Top Publishing & Graphics Display
- Macromedia
- Report Writing
- Database
- SAGE
- Corel
- Web Design
- Internet
- Lotus
- Freelance Graphics
- Organizer
- SmartCenter
University of Roehampton, London Online
Courses / Programs
Online MSc in Information Systems Management - for UK and international students / professionals:

The ability to manage and understand information systems is now viewed as one of the most important business skills of the future.

To help organisations to embrace innovative technologies to achieve strategic and operational competitive advantages, future business systems analysts, management consultants and IT directors need to be equipped with new management competencies to deal with the challenges associated with dynamic business environments, which are increasingly dependent on the effective exploitation of IS.

This online MSc Information Systems Management programme will help equip you with the critical thinking skills needed to excel in a management position within this dynamic and evolving sector.

When you graduate, you’ll have the opportunity to take part in our graduation ceremony in London; you’ll also receive exactly the same degree certificate as our on-campus graduates.

Examples of Career Options:
- IT / IS manager
- IT / IS project manager
- Chief information officer
- Chief technology officer
- Director of information systems/ technology

Professional Faculty:
“I am proud to be a part of Roehampton Online! The use of the latest technology in our University is transforming higher education into a valuable collaborative learning experience.”  
–  Dr. Dimitrios Koufopoulos, Online Faculty, University of Roehampton
MSc in IS Management:

Through shared group activities and individual assignments, students explore the practical applications of contemporary theory for leading, managing others and working independently to ensure you and your organisation stay at the forefront of this key field in business.

Programme Modules:
- Learning and Leading in a Dynamic Era
- Managing the IS Function
- Organisations and the Business Environment
- Managing Projects
- Innovative Technologies
- Strategic Information Systems
- Research Methods
- Management Research Project
iTrain Education, Central London
Courses / Programs
Conveniently located in Clerkenwell in Central London, iTrain are Oracle experts. With more than 15 years of experience, we deliver a wide range of independent Oracle courses, across all technology disciplines. iTrain courses are available as public courses, in a closed environment on the client site, or in our training centres for individual clients. In addition, we offer SAP training and Java courses. We also have training centres in Edinburgh, Swindon and Reading.

As part of iTrain’s dedication to the highest measurable standard of customer care and in line with its quality management strategy, iTrain has full corporate ISO 9001:2008 registration.

The iTrain London office provides easy accessibility by foot, bus, tube, or train from the London mainline stations. It is situated only a short walk from Farringdon Station and near Angel, King's Cross, Barbican, and Chancery Lane Stations. It is in close proximity to excellent local restaurants, pubs, markets, and the historic attractions in the heart of London. Our dedicated centre staff offer a choice of rooms set in a professional business environment with the added benefits of on-site IT support.
Oracle Training Courses:
- Oracle Core Technology
- Oracle Database
- Oracle Middleware/Development
- Oracle Applications
- Oracle BI & Reporting

Further Courses:
- SAP Business Intelligence
- SAP Human Capital Management
- SAP Finance and Control
- Java & Web Technologies
Focus on Training
Courses / Programs
Focus on Training offers accredited training courses throughout the UK in the fields of Project Management and IT & Service Management. Our courses are suitable for individuals who want to gain professional accreditations and we also offer on-site training for companies that caters for their specific needs. We offer courses in London, Liverpool, Manchester, Leeds, Newcastle, Glasgow, Edinburgh and Belfast among many other locations.

We network with the top training providers to supply you with the open course and on-site training solutions which best meet your needs. We deliver the benefits of a managed training service - without the costs and inflexibility. We aim to provide: Knowledgeable and independent advice; The fastest and most convenient course booking experience; Quality training; Excellent value.
Project Management courses include:
Agile & Scrum; APM; Change Management; Introduction Courses; Microsoft Project; MSP; P30 & PPSO; PMI; PRINCE2; Risk Management

IT & Service Management courses include:
Business Analysis; CISCO; IT Governance & Security; CompTIA; ITIL; Microsoft - Office; Microsoft - Technical; Software Testing; Systems Devt & Architecture; VMWare