Microsoft Excel 2007/2010 Beginners Training Course at Chatswood (February 2011)

This course is designed to give you fundamental Microsoft Excel skills to use existing spreadsheet files and create your own from scratch. 

Topics include:

The Excel screen including toolbars, formula bar, name box, column and row headings, sheet tabs… uses for Excel (Worksheet, Database & Charting). Getting around a spreadsheet using keyboard & mouse, moving between workbooks. Selecting (or highlighting) cells, columns and rows & entire spreadsheets. Entering information into workbooks and resizing columns.

Select cells, columns & rows, range names, select several ranges, drag & drop, cut copy & paste, enter data & edit cells, insert, resize and delete columns, use AutoFit, AutoComplete, create a database, understand hyperlinks in Excel, undo & redo, AutoFill, working with series, series options.

Formula basics, formulas keys, enter formulas using keyboard, mouse and arrow keys, AutoSum and function basics, AutoCalculate, Copying formulas & Functions quickly, merging cells, alignment, currency & percentage formatting, borders & shading and indentation, date and number formatting, format painter, AutoFormats, repeating actions quickly.

The course includes a workbook containing exercises you can use to practice your new skills

You'll learn using Microsoft Excel 2007, and the training material also has information about the same commands using the earlier version (Microsoft Excel 2000-2003) with some handy tips and tricks.

This course includes access to the EzyLearn Online courses 301, 302 and 303 which 12 months access so you can use the training videos and workbooks as a resource after your initial training.

Microsoft Excel 2007/2010 course outline information