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 *
Gender
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:
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
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
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
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