This is your chance to get one step ahead of the jobs market with your Excel skills, and earn a nationally recognised Pitman Training certificate for your CV.
The course takes approximately 24 hours of self-paced study to complete, either at one of our training centres in London, Croydon or from home via distance learning. And you can choose whether to study the 2010 or 2013 version!Price: £452.17 per person.
Advanced Excel course also available.
Microsoft Excel Course Beginners To Intermediate – Content
In approximately 24 study hours, you’ll work through the following lessons:
Lesson One: Opening the Excel program, identifying the elements of the opening screen, creating a worksheet with text and numbers, entering addition formulas, adjusting column widths, using the SUM function in a formula, using the AutoSum feature, editing text and numbers, navigating a workbook and worksheets, saving, naming and closing a workbook, opening an existing workbook, exiting Excel
Lesson Two: Applying bold, italic and underline formats, changing font type and size, using the mini toolbar, changing the font colour, selecting and formatting cells ranges, selecting columns and rows, aligning cell contents horizontally, using merge and centre, applying number formats, printing the active worksheet, creating a new folder, saving a workbook with a different name and file type, viewing files in an open dialog box, using AutoFill, entering formulas for subtraction, multiplication, division and percentages
Lesson Three: Inserting and deleting rows and columns, hiding and unhiding rows and columns, minimising the ribbon, modifying column widths and row heights, aligning cell contents vertically, wrapping and indenting text, applying a fill colour, applying borders, undo and redo, moving and copying cell contents using drag and drop, moving and copying cell contents using cut, copy and paste, copying formats using format painter, clearing formats
Lesson Four: Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom, page break preview, page layout view, naming a worksheet, inserting and deleting a worksheet, repositioning worksheets, using the count function, saving a workbook as a template, creating a workbook from a template, online templates
Lesson Five: Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, deleting a custom theme, page orientation, adjusting margins and scaling, centring the sheet horizontally and vertically, print preview and print a worksheet, viewing/hiding gridlines and row and column headings, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions, using Quick Analysis, sorting columns in ascending and descending order
Lesson Six: Inserting and formatting headers and footers, inserting header and footer codes including date, page number and file name, copying and pasting data between worksheets, grouping and formatting multiple worksheets, switching between workbooks, viewing multiple workbooks, inserting and applying styles to a column, line and pie chart, using recommended charts, changing chart type
Lesson Seven: Creating more complex formulas, calculating percentages, making a cell reference absolute and knowing when this is needed, displaying all formulas on a worksheet, customising and viewing calculations in the status bar, the insert function dialog box, using the NOW, TODAY and IF functions, the function library, adding, viewing and editing comments, adding and deleting a button the Quick Access toolbar
Lesson Eight: Displaying a hidden worksheet, using the PMT and FV functions, recognising errors, using the IFERROR function, creating 3D formulas
Lesson Nine: Inserting column, line and pie charts, moving a chart to a new worksheet, add, reposition and remove chart elements, adding and removing a data table, switching chart rows/columns, changing chart layout options, selecting and formatting chart elements, inserting sparklines, inserting moving, resizing and rotating pictures, making picture ‘corrections’ and applying picture styles and effects, aligning multiple objects, inserting and formatting WordArt, inserting and modifying shapes, creating and modifying SmartArt
Lesson Ten: Using Spell check text in a worksheet, using Filter to display specific data, finding and replacing text formats within a worksheet, saving a workbook as a web page, inserting and using hyperlinks in a worksheet, using conditional formatting in a worksheet, customising the ribbon
To receive the full course outline or to enrol on the course, just get in touch!
How Pitman Training’s Excel Course Works
You can study this Microsoft Excel course in your own time, at your own pace, and receive support from our training team as and when you need it.
The course is audio based, and you’ll also receive a workbook which is yours to keep at the end of the course for future reference.
You can drop into the centre at times to suit you to study, and you can even study from home if getting to one of our centres is not convenient for you.
At the end of the course, you’ll take an exam leading towards your nationally recognised Pitman Training certificate.
Who Should Study This Microsoft Excel Course?
Our Microsoft Excel course is designed for anyone who needs to make figure work easier, particularly at work or university. You don’t need any prior experience in Excel to study this course.
It’s also suitable if you’re familiar with previous versions of Microsoft Excel and need to update your skills in line with the latest version.
If you already have some experience, you might want to try our Microsoft Excel Advanced course.
Don’t worry if you’re not sure which level you should take – our Course Advisors will be able to give you a free skills assessment.
You can also try a free course demo to help you decide whether this is the right course for you.
Call or email our friendly Course Advisors now to get started!
You can study Pitman Training’s Microsoft Excel course in the following locations:
Can’t get to one of our centres?
Get in touch today to find out about our home study options.
Please note – we are able to offer both Microsoft Office 2010 and Microsoft Office 2013 courses.
Browse our course list to see the full list of courses on offer at Pitman Training in London and Croydon.
Enquiring from the Manchester area? Click here for further details.