Receive alert emails about other courses like this
ShareEmbed on your website
Venues and dates
Close ↑Open ↓
Suite 339/341, Grove House, 27 Hammermsith Grove,
Where to eat
The Red Lion - 2 Castelnau, London
Bangkok Garden - 8 Rocks Lane, Barnes, London
Indian Zilla - 2-3 Rocks Lane, Barnes, London
Mamma - 3 Rocks Lane, Barnes
Riva - 169 Church Road, London
Where to park
U.G.C. Hammersmith Car Park - London
Exchange Shopping Centre Car Park - London
Hand Car Wash - 1 Putney Bridge Approach, London, Fulham
CCP - 84-90 Fulham High Street, Fulham, London
City Car Wash & Services - 413-415 New Kings Road, London
Close ↑Open ↓
Duration 20 Hours
Method / place Classes in Hammersmith (London)
Suitability Those who wish to learn this popular spreadsheet program.
Course objectives To learn the Excel program to Microsoft Office Specialist Level. The flexibility and value of a self-study course designed to enable you to work at your own pace A personalised workbook to use as a reference guide on completion of the course. The opportunity to gain the widely recognised Pitman Training Certificate.
Requirements Familiar with Windows environment and basic keyboarding experience.
Consult with training provider
Close ↑Open ↓
Aims and Objectives To learn the Excel program to Microsoft Office Specialist Level. The flexibility and value of a self-study course designed to enable you to work at your own pace A personalised workbook to use as a reference guide on completion of the course. The opportunity to gain the widely recognised Pitman Training Certificate.
Target Audiences Those who wish to learn this popular spreadsheet program.
Prerequisites Familiar with Windows environment and basic keyboarding experience.
Course Content Lesson 1: Including: The Excel screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help.
Lesson 2: Including: Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format.
Lesson 3: Including: Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard.
Lesson 4: Including: AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template.
Lesson 5: Including: Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references.
Lesson 6: Including: Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments.
Lesson 7: Including: Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace.
Lesson 8: Including: Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram.