Pitman Training in London’s Notting Hill and High Holborn, and in Croydon offers two short Excel courses.
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
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.
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.
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.
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.
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.
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.
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.
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?