London Notting Hill -
020 7792 5214
London High Holborn -
020 7025 4700
Manchester -
0161 923 6814
This is your chance to be one step ahead when it comes to acquiring spreadsheet skills for work.
This programme will take you
approximately 24 hours to
complete and you can spread this time any
way
you wish for up to 3 months, at our Notting Hill, High
Holborn
or Manchester training centres.
At the end of your 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.
To find out more, just call our friendly Course Advisors:
Notting Hill - 020 7792 5214
Holborn - 020 7025 4700
Manchester - 0161 923 6814
What Is Covered.
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
To book your sample lesson, to enrol or to find out more, simply call us:
Notting Hill - 020 7792 5214
Holborn - 020 7025 4700
Manchester - 0161 923 6814
Who Should Attend This Excel Course?
This Excel course was written for anyone who needs to make figure work easier, particularly at work or university and who has little or no experience with Excel or is self-taught.
It is a much more thorough Excel course than many, covering beginners' to intermediates subjects in depth.
And because you can study this course at times to suit you, time can be taken to practice and become "fluent" in all aspects of Excel.
If you should need a higher level of Excel skill, we also offer an advanced course. Click here to learn about our Advanced Excel Course.
To book your sample lesson, to enrol or to find out more, simply call us:
Notting Hill - 020 7792 5214
Holborn - 020 7025 4700
Manchester - 0161 923 6814
