Excel Course For Beginners & Intermediates

Excel Course For Beginners & Intermediates

This is a fully comprehensive Excel course aimed at beginner to intermediate users!

The course will take you approximately 24 hours to complete and you can spread this time any way you wish for up to 6 months, at either our London (Notting Hill or High  Holborn)  or Manchester training centres. You'll enjoy working at your own pace with pre-recorded lessons, a high quality workbook and a PC, supported by our friendly, experienced on-site trainers.

Our step-by-step course is delivered as a self-paced programme so you can learn at your own pace at times to suit you at Pitman Training London (in Notting Hill or High Holborn) & central Manchester.

Find out more about Pitman Training and how this Excel Course For Beginners & Intermediates in High Holborn or Notting Hill London & Manchester can help you here.

This Excel Course For Beginners & Intermediates is essential for anyone who wants to become proficient in the 2007 version of Microsoft Excel - from beginners and intermediates, and for anyone who is new to excel spreadsheets or wants to improve their skills.

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 Beginners & Intermediates 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 2007 Course For Beginners & Intermediates is made up of 10 comprehensive and easy to follow core lessons.

This programme is very comprehensive and will cover everything from the absolute
basics of creating spreadsheets through to the creation of sophisticated
formulae to automate even the most complex calculations.

Lesson One:

The opening screen, creating a
worksheet with text and numbers, entering simple formulas, adjusting column
widths, editing cells, navigating a workbook and worksheets, using AutoSum,
saving, naming and closing a workbook, adding a button to the Quick Access
Toolbar, opening an existing worksheet, accessing Help in Excel

Lesson Two:

Formatting text, changing font
type and size, using the mini toolbar, changing the font colour, selecting cells
and ranges, aligning text horizontally, merging and splitting cells, formatting
numbers, printing the active sheet, creating a folder, saving in a different
format

Lesson Three:
Inserting and
deleting rows, hiding and unhiding rows and columns, modifying column widths and
cell heights, aligning cells vertically, wrapping and indenting text, adding
colour to cells and ranges, applying borders to cells and ranges, moving and
copy cells, undo and redo, cut, copy and paste, AutoFill

Lesson Four:
AutoComplete, text
orientation, selecting non-adjacent data, freezing and unfreezing panes
horizontally and vertically, using Zoom, page break preview, naming and renaming
a worksheet, inserting a worksheet, repositioning worksheets, deleting a
worksheet

Lesson Five:
Using styles to enhance a
worksheet, creating a custom style, the Page Layout ribbon, using themes to
enhance a worksheet, creating and deleting a custom theme, page orientation,
adjusting margins and scaling, centring the sheet horizontally and vertically,
print preview, displaying gridlines, printing row and column headings, setting
and clearing a print area

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:
More complex formulas,
absolute as well as relative cell references, AutoCalculate, functions SUM,
DATE/TIME, COUNT, IF, adding, viewing and editing comments

Lesson Eight:
AVERAGE, MAX
and MIN functions, sort columns using ascending and descending order, the PMT
and FV functions, entering formulas into grouped worksheets, recognising errors,
using the IFERROR function, using 3D referencing to link worksheet data

Lesson Nine:
Inserting charts, changing
chart type, formatting a plot area, formatting a data series, inserting and
resizing a picture, applying picture effects, aligning multiple objects,
inserting WordArt, inserting and modifying a drawing object, creating and
modifying SmartArt

Lesson Ten:
Using Spell check, using
Filter to display specific data, finding and replacing text within a worksheet,
saving a workbook as a web page, publishing a web page, inserting and using
hyperlinks, using conditional formatting

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 successful completion of this Excel course, you can take an exam and when you pass, you'll earn a handsome, nationally recognised Pitman Training certificate as proof of your practical ability.

Contact us here. This Excel Course For Beginners & Intermediates,costs just £414.36.

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.

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

 Contacting us is easy - just ask your question here.