Beginners To Intermediates & Advanced Users.
Short Excel Courses In London Or Croydon.

button(3)

Management Courses

Short Excel Courses

Pitman Training in London’s Notting Hill and High Holborn, and in Croydon offers two short Excel courses.

Beginners/Intermediates

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

Advanced

Lesson One:

Using AutoFill, carrying out date calculations, adding a worksheet background, showing/hiding gridlines and headings, creating and working with tables, converting text to columns, removing duplicates, consolidating data, hiding/unhiding worksheets, using paste special, creating a custom format.

Lesson Two:

Defining, using and managing named ranges, using named ranges in formulas, inserting, modifying and removing hyperlinks, formatting elements of a column chart, using functions: ROUND; SUMIF; IF; IFERROR; AND, using the IF function nested with OR.

Lesson Three:

Using conditional formatting, editing a conditional formatting rule, using the Rules Manager, formatting cells meeting a specific condition, applying more than one conditional formatting rule, sorting data using cell attributes, filtering data using cell attributes, using advanced filter options.

Lesson Four:

Recording and running macros, editing a macro, running a macros from the Quick Access Toolbar, deleting macros, using data validation, tracing precedent/dependent cells in a worksheet, evaluating formulas, tracing errors.

Lesson Five:

Summarising data using subtotals, using database functions, grouping and ungrouping data, creating a pivot table, refreshing pivot table data, filtering information in a pivot table, formatting pivot table data.

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:

Protecting worksheet cells, applying and removing passwords, setting file properties, sharing workbooks, merging workbooks, tracking changes, accepting or rejecting changes, using the Document Inspector, marking a workbook as final, removing a password, adding a digital signature.

Lesson Eight:

Using statistical function: COUNTA, COUNTBLANK, COUNTIF, using text functions: PROPER, UPPER; LOWER; CONCATENATE, using financial functions: PV; NPV; RATE, using nested functions.


About Our Short Excel Courses.

Each in-depth Excel course requires approximately 25-30 hours of study at our comfortable training centres and on passing your exam, you’ll earn a nationally recognised certificate to prove your skills.

You can start your Excel course at any time and study at hours to suit you during our long opening hours which include evenings and Saturdays.

Our friendly, experienced trainers are on hand at all times to help you achieve your training goals as quickly as possible, providing advice, guidance and one-to-one tuition when you get stuck, confused or need remotivating!

At the end of your training, you’ll take a practical exam which leads to the award of a Pitman Training certificate.

Why not visit us to sample the courses before making up your mind?

Contact Us