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:
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
Pitman Training Guildford
Courses / Programs
Pitman Training has over 100 training centres in the UK and is one of the largest independent training providers in the world. Pitman Training Guildford offers a wide range of IT, office skills and administration training courses to private individuals and organisations in South West Surrey and North East Hampshire.

We offer a complete scheduled programme of Microsoft Office one day courses for businesses including Excel, Word, PowerPoint, Access and Project. We also provide training for private individuals in Microsoft Word, Excel, PowerPoint, Access and Outlook as well as Sage accounting software and web design training.

Unlike a normal school or college, our self-paced training methodology means you start your course and study whenever you wish. Also, because we're open on some evenings and Saturdays you can easily fit your studies around your other commitments such as work or family.
- Microsoft Office 2003
- Microsoft Office 2007
- Excel
- Word
- PowerPoint
- Access
- Outlook
- Project
- Dreamweaver CS4
- Bookkeeping
- Publisher
- Sage Line 50
- Sage Payroll
- Photoshop
- Flash
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,
University of Surrey
Courses / Programs
University of Surrey is located in Guilford, Surrey (40 minutes from London by train) in the south-east of England, and provides BSc degree programmes in computer science, and computing & information technology. All of our programmes are available as 4-year BSc degrees including a professional training year, or as 3-year BSc degrees without a professional placement.

For anyone who wants to be involved in working at the cutting edge of technological science for the modern age, a degree in computing is a natural first step. Computers are integral to numerous spheres, from business and government to the media and research. With sophisticated computing skills, you can be at the forefront of innovation and opportunity.

Our degree programmes are developed in close consultation with an Industrial Advisory Board that comprises representatives of major IT organisations in the UK. These representatives also contribute directly with teaching to provide you with up-to-date and relevant experiences of IT. This is further supported by the inclusion of an industrial placement year. This ensures that our degrees reflect the contemporary concerns and requirements of modern business and industry.
- Bachelor of Science (BSc) Honours Degree in Computer Science: 3 years

- Bachelor of Science (BSc) Honours Degree in Computer Science: 4* years

- Bachelor of Science (BSc) Honours Degree in Computing and Information Technology: 3 years

- Bachelor of Science (BSc) Honours Degree in Computing and Information Technology: 4* years

* Programme includes a professional training year

- Bachelor of Science (BSc) Honours Degree in Computer Science and Engineering
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