Microsoft Excel
Training Course
Are you looking for work and need spreadsheet skills? Microsoft Excel is used to create tables, worksheets with calculations and charts. It is also used to manipulate reports created by MYOB accounting software.
Steve Slisar has taught over 8,000 students how to use Microsoft Excel and created a systematic training course that covers the most basic to gradually more advanced tools in the Excel program. The current version 2007 is radically different to the versions from 1997, 2000, 2002 and 2003 and the forthcoming course will teach you how to navigate and use the new Excel 2007 version.
Microsoft Excel 2007 Beginners course
Chatswood Training Centre
Wednesday 5th May
9.30am to 3.30pm
This course is designed to give you the Excel skills you need on a daily basis. It includes how to work with existing spreadsheet files, plus creating your own, making it look good, performing calculations and inserting charts. There will be demonstrations of the differences between 2003 and 2007 too.
This is a more detailed description of the topics covered:
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.
Charting basics, chart types, data source, chart titles, axis labels, legend, data tables, pie charts, chart wizard, editing charts specifications after it is created, plot area, category and value axis, formatting a chart, getting a chart into Word.
|
