Microsoft Excel 2010

Overview

Microsoft Excel is the world's most popular spreadsheet program; learning how to use the software with Pitman Training shows that you've taken one of the best Excel courses available.

This course is also designed to prepare you for the City & Guilds Spreadsheet Processing Techniques Intermediate Exam, MCAS test and ECDL Advanced Spreadsheet exam. You don't need any prior experience of MS Excel but you will need to be familiar with the Windows environment and have some basic keyboard experience.

Our Microsoft Excel course is very flexible - you will have the freedom to take the Excel Lessons at your own pace, based at one of our handy town or city centre locations, with support on hand should you need it. And a workbook will be yours to take away as a handy reference guide.

This Excel course comprises several Lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace. Just some of the areas covered include creating worksheets, formatting text, simple and complex formulas; handling rows and columns, autocomplete, using styles, headers and footers, average, max and min functions and using charts.

Having completed your Microsoft Excel course, you could add Microsoft PowerPoint and Word to your list of achievements. Or you could give your career a serious boost by completing one of our highly respected diplomas, for example our Foundation in Book-keeping Diploma or our Microsoft Office Diploma, which could help maximise your career potential.

Who is it for?

Those who wish to learn this popular spreadsheet program

Description

Lesson One - Including: The opening Excel 2007 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 - Including: 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 - Including: 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 - Including: 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 - Including: 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 - Including: 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 - Including: More complex formulas, absolute as well as relative cell references, AutoCalculate, functions SUM, DATE/TIME, COUNT, IF, adding, viewing and editing comments

Lesson Eight - Including: 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 - Including: 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 - Including: 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