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:
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
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
Acentar, London
Courses / Programs
Acentar is an SAP management consulting, information technology, training and outsourcing company in south-east London, in the borough of Southwark. We provide consulting, implementation and development services on SAP/ERP and related technologies. We offer outstanding on-site and online instructor-led Live Virtual Classroom (LVC) SAP training, consulting and resourcing solutions worldwide. Our SAP training courses are designed for both corporate (companies already running SAP or planning to run SAP) and individuals wanting to expand their SAP skills or knowledge.

All of our SAP courses can be delivered onsite at our training centres or at SAP clients' sites. We currently deliver most of our courses through our classrooms and online through our instructor-led Virtual Class taking into consideration costing and ease of attendance.

Our SAP training courses covers most areas of SAP Business Suite, SAP Netweaver, SAP BI, SAP MM, SAP FICO, SAP CRM, SAP HR/HCM, SAP ABAP, SAP Netweaver Basis, SAP BI/BW, SAP MDM, SAP XI, SAP SRM, SAP SCM and related technologies. Training classes and courses are delivered by some of the most experienced SAP consultants in the market today.
- SAP Certification Level Training
- SAP Configuration Level Training
- SAP Project Team Training
- SAP End User Level Training
Silicon Beach Training, Brighton
Courses / Programs
Silicon Beach Training in Brighton, England (1 hour south of London), is an accredited training provider offering over 300 Internet, IT, Web Design, Leadership Training, & Management Training Courses. Our range of Web Design training courses are delivered by experienced designers and programmers.

We provide Dreamweaver training, Photoshop for the Web, CSS Training, and Flash training. For businesses developing CMS (content management systems) and social media strategies we also offer Joomla training and Wordpress training.

Our Web Design Week is our most popular web and internet course. A cost effective way to learn web design. This training course incorporates Dreamweaver training, Photoshop for the Web training and a Web Design training day that will cover the basics of good design.
Web Design training courses:

- Web Design Week
- Dreamweaver training
- Photoshop for the Web
- CSS Training
- Flash training
- Joomla training
- Wordpress training
- HTML 5 Training
- Web Accessibility Training
- RapidWeaver Training
- ActionScript Training
- Social Media
- SEO
- Google Analytics
& 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+)

- Networking (MCSA, MCSE, MCTS, MCITP, CCNA, CCNP)

- 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