Excel Course for Advanced Users

Excel Course for Advanced Users

Now there's an advanced level Microsoft Excel course using the world-famous Pitman Training methodology.

Within just 20 study hours at our training centres in London (High Holborn or Notting Hill), & Manchester this Excel course will enable you to develop  and retain expert skills to help you add real value to your career.

This Excel course programme covers the City & Guilds Spreadsheet Processing Techniques Intermediate exam as well as the Microsoft Certified Application Specialist test (MCAS) and EDCL Advanced (Spreadsheets) exam.

Find out more about Pitman Training and how this Excel Course for Advanced Users in London (High Holborn or Notting Hill) & Manchester can help you here.

This Excel Course for Advanced Users is essential for anyone who wants to become an expert in Microsoft Excel is aimed at people who are already performing complex calculations in Excel and who need to gain extra value from the application, or those who have already taken our Excel Course 2007 for beginners to intermediates.

.

Contact us to find out if this course is suitable for you here

Come visit us to sample this course, free.

Just call our friendly Course Advisors:

London Notting Hill - 020 7792 5214

London High Holborn - 020 7025 4700

Manchester - 0161 923 6814

We're looking forward to hearing from you.

Learn how our self-paced learning methodology means you can study our Excel Course for Advanced Users at your own pace in our London & Manchester training centres. Contact us here now.

Contact us here to find out how long this course could take you to complete

This Excel Course for Advanced Users is made up of 8 practical and easy to follow core lessons that will make you an expert in Excel:

In 8 practical, exercise packed lessons, you'll learn the following:

Lesson One:
Using AutoFill, carrying out
date calculations, adding a worksheet
background, showing/hiding gridlines
and headings, creating and working with tables, converting text to columns,
removing duplicates, consolidating data, hiding/unhiding worksheets, using paste
special, creating a custom format.

Lesson Two:

Defining, using and managing named ranges, using named ranges in
formulas, inserting, modifying and removing hyperlinks, formatting elements of a
column chart, using functions: ROUND; SUMIF; IF; IFERROR; AND, using the IF
function nested with OR.

Lesson Three:
Using
conditional formatting, editing a conditional formatting rule, using the Rules
Manager, formatting cells meeting a specific condition, applying more than one
conditional formatting rule, sorting data using cell attributes, filtering data
using cell attributes, using advanced filter options.

Lesson
Four:
Recording and running macros, editing a macro, running a
macros from the Quick Access Toolbar, deleting macros, using data validation,
tracing precedent/dependent cells in a worksheet, evaluating formulas, tracing
errors.

Lesson Five:
Summarising data using
subtotals, using database functions, grouping and ungrouping data, creating a
pivot table, refreshing pivot table data, filtering information in a pivot
table, formatting pivot table data.

Lesson Six:

Inserting headers and footers, copying and pasting data between
worksheets, grouping and ungrouping worksheets, creating a new workbook,
switching between workbooks, viewing multiple workbooks, hiding and unhiding a
workbook, saving as a template, creating a workbook from a template using
existing templates and online resources.

Lesson Seven:

Protecting worksheet cells, applying and removing passwords, setting file
properties, sharing workbooks, merging workbooks, tracking changes, accepting or
rejecting changes, using the Document Inspector, marking a workbook as final,
removing a password, adding a digital signature.

Lesson Eight:

Using statistical function: COUNTA, COUNTBLANK, COUNTIF, using text
functions: PROPER, UPPER; LOWER; CONCATENATE, using financial functions: PV;
NPV; RATE, using nested functions.

Find out how this is one of the most comprehensive courses in Britain. It's a lot to learn, but don't worry, our course advisors will be with you every step of the way.

On successfully passing the final exam, you will be awarded sought-after Pitman Training and Microsoft IT Academy certificates!

Contact us here.

This Excel Course for Advanced Users, costs just £414.36 (inc VAT) to include all course material, exam fee and certificate.

You can start this course at any time (no waiting for term to start) and come in to study at times to suit you during our long opening hours which include evenings and Saturdays.

This course leads to a nationally recognised Pitman Training qualification.

Contacting us is easy - just ask your question here.

(NB: Government funding is not available for this course and attendance is required in London's Notting Hill or High Holborn or Manchester to complete the course.)