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:
Macresource Computer Training
Courses / Programs
Macresource Computer Training specialise in providing quality IT training throughout the UK on a variety of web technologies and computer software packages, especially those by Macromedia and Adobe. These software environments have become the standard for web and multimedia development since they empower companies to develop web solutions more quickly than ever. We offer three types of computer training courses: Public Training Courses at our central London training centre, on several popular software packages such as Dreamweaver and Flash; Private Training Courses, ideal for those companies or individuals who require training, away from their office, but which is tailored to their specific requirements; On-site Training Courses if you have in-house training facilities or an office which is suitable for holding a training course, we can conduct the training on your premises and using your facilities.
These include: Macromedia Dreamweaver, Macromedia Flash and ActionScript, Macromedia Fireworks, Macromedia Director, Macromedia Freehand, Adobe Acrobat, Adobe Illustrator, Adobe PageMaker, Adobe Photoshop and ImageReady, QuarkXPress, FileMaker Pro
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
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...
Learning Solution, London
Courses / Programs
Learning Solution offers a range of courses in the fields of IT, Social Media and Mobile Development, including Microsoft, Cisco and CompTIA certifications. We are conveniently located in the borough of Southwark in Central London, just 2 minutes walking distance from London Bridge and Liverpool Street tube stations.

At Learning Solution, we are committed to helping build tomorrow's business leaders. Dedicated to creating global competence in IT, Business and Accounting, we have designed our courses to be world class, stay industry relevant and market responsive, and most importantly, keep our students way ahead of the rest.

Our teaching is modelled to be case-study based and application oriented, where students and faculty evaluate theories and principles in the context of everyday business needs and challenges. Our student-faculty ratio, is one of the healthiest in the industry, and creates the ideal environment for one on one mentoring and academic engagement between the student and faculty. We also encourage joint involvement between students and faculty, in corporate projects and research opportunities.
- Microsoft courses
- Cisco courses
- CompTIA courses
- Sun Microsystem courses
- Oracle courses
- Red Hat courses
- Web Design & Development courses
- Project Management courses
- Accounting courses
- Social Media courses
- Mobile Development courses
& more...
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