Our comprehensive Microsoft Excel course is aimed at beginner to intermediate users of Excel.
It’s your chance to be one step ahead of the jobs market with your Spreadsheet skills, and get a nationally recognised Pitman Training certificate on your CV.
You’ll enjoy working at your own pace with pre-recorded lessons, a high quality workbook and PC, support by our friendly, experienced on-site trainers.
At the end of your Excel course, you can take an exam, and when you pass you’ll receive a nationally respected Pitman Training certificate as proof of your practical ability.
Who Should Take This Excel Course?
Our Microsoft Excel 2010 course is designed for anyone who needs to make figure work easier, particularly at work or University.
If you have little experience with Excel or are self-taught, we recommend starting with this Beginner to Intermediates Excel course.
Our flexible training methodology allows you to study at times to suit you, so you can take your time to practice and become familiar with all aspects of Excel.
If you need a higher level of Excel skill, we also offer an Advanced Excel course.
How We Train
This Microsoft Excel course is self-paced, meaning you can drop in when you like to one of our training centres and study your course.
It’s easy to fit your studies around your other commitments, such as work or family life, as we operate really flexible opening hours, which include evenings and Saturdays.
Plus, full trainer support is available if you need any help or have any questions, and when you study from home our expert trainers can be reached by phone or email.
We run four Pitman Training centres in the UK – please visit the pages below for maps and directions.
If you can’t reach one of our training centres, we are able to offer this course via distance learning.
People Who Enrolled On Microsoft Excel Also Tried Word…
Why not join them and impress potential employers with your depth of Microsoft Office knowledge?
Covering everything from the absolute basics through to the creation of sophisticated formulae to automate even the most complex calculations, you’ll soon get to grips with Excel with our comprehensive course.
Here’s what’s covered:
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
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
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
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
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
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
More complex formulas, absolute as well as relative cell references, AutoCalculate, functions SUM, DATE/TIME, COUNT, IF, adding, viewing and editing comments
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
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
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
We offer a wide range of Microsoft Office courses at Pitman Training in London and Manchester to suit all abilities.
This course is a module in a number of our diploma programmes, including the Microsoft Office Plus Diploma.
Click the link if you would list to see our full list of Microsoft Office courses.
Alternatively, if you want to push your Excel skills to a more expert level, check our Advanced Excel course.
Don’t worry if you’re not sure which Microsoft Excel course is for you, are Course Advisors are here to help and assess your skills.
To get in touch, just call or email us today. You can even try a free demo to make sure the course is for you!
Top Excel Tip
“Use F7 for a quick spell check on Excel, and don’t forget that F4 allows you to repeat the last action as often as you want until you start a new action.” For more tips from Nicky, follow her on Twitter.