Need Help Or More Information?
Tel:
020 7025 4700
High
Holborn
Tel:
020 7792 5214
Notting Hill
Pitman
Training Centres
Northumberland
House
303-306 High Holborn
London
WC1V 7JZ
United House
9 Pembridge Road
London
W11 3JY
|
| 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 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, 14 lesson
course.
|
|
We're
now a Microsoft IT Academy!
That
means you can qualify for internationally recognised Microsoft
certificates as well as Pitman Training qualifications.
High
Holborn
020 7025 4700
Notting
Hill
020 7792 5214
Click
here to email us.
|
|
What Is Covered.
In 14 lessons, you will
learn:
- Lesson
One: Importing and
exporting data. Object linking and embedding. Importing data from web
files.
- Lesson
Two: Using templates.
Creating and applying custom templates. Editing and storing templates.
- Lesson
Three: Using multiple
workbooks. Linking workbooks. Linking workbooks. Creating and using
workspace files.
- Lesson
Four: Formatting numbers.
Using custom formats. Using conditional formats.
- Lesson
Five: Printing workbooks.
Grouping worksheets. Printing multiple workbooks. Using the report manager.
- Lesson
Six: Working with named
ranges. Moving and deleting a named range. Range names in calculations.
Adding and removing toolbar buttons. Creating toolbars.
- Lesson
Seven: Working with
Toolbars. Customising toolbars. Adding & removing buttons. Creating
a new toolbar. Creating customised menus.
- Lesson
Eight: Using Macros.
Recording macros. Running and editing macros. Assigning a macro to a
toolbar or menu.
- Lesson
Nine: Auditing a worksheet.
Data entry validation. Auditing data dependency. Showing cells containing
ERROR values.
- Lesson
Ten: Working with data
lists. Filtering lists and using custom filters. Form option buttons.
Criteria option buttons.
- Lesson
Eleven: Data management.
Searching for data with advanced filters. Summarising data with outlines.
Querying a database. Controlling formatting and layout. Refreshing external
data.
- Lesson
Twelve: Pivot tables.
Creating pivot tables. Modifying and grouping pivot tables. Creating
Interactive Pivot tables for the web.
- Lesson
Thirteen: Using Analysis
Tools. Goal seeking. Using Solver. Scenario Manager.
- Lesson
Fourteen: Workgroups.
Applying worksheets protection. Password protecting a file. Adding comments
to the worksheet. Working with shared workbooks. Merging workbooks.
Tracking changes and resolving conflicts.
To find out
more or to make your booking, just call 020 7025 4700 for High Holborn,
020 7792 5214 for Notting Hill and speak to one of our course advisors.
Or contact us by email.
©
Holborn Training Ltd 2008. All Rights Reserved.
Site Map Privacy
Policy Website Terms
Terms Of Business - Individual
Students Terms Of Business
- Corporate Bookings
|
How
Do I Know Which Level I'm At?
This in-depth
spreadsheet course was written for intermediate Excel users wishing to
become expert.
It follows on
from our Excel Proficient course.
The chances are
that you'll know some of the content of each Excel course.
No problem!
Just call us on
020 7025 4700
for High Holborn,
020 7792 5214
for Notting Hill
and talk to one of our experienced course advisors.
They'll be able
to suggest the right route for you.
Or contact
us by email.
Whichever course
you choose, you can be certain you'll get plenty of practical information
from the training.
And you'll be
able to store it for future reference in your Pitman Training workbook!
Just come along
with an open mind and a willingness to learn and we'll do the rest!
To find out more
about our advanced Excel training, just call us on
020 7025 4700
for High Holborn,
020 7792 5214
for Notting Hill,
or contact
us by email.
|
