Course Contents
Microsoft Excel
Microsoft Excel (module 301) - FREE
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
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.
Microsoft Excel (module 302)
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
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,
Microsoft Excel (module 303)
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
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
Microsoft Excel (module 304)
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
Print & page break preview options, changing break positions, orientation, scaling, inserting & deleting page breaks, margins, normal, preset and custom headers and footers, set and clear print area, page printing order, showing titles and gridlines when printing, keep headings on the screen, printing multiple sheets.
Microsoft Excel (module 305)
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
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, have several different types of chart in one, charting multiple ranges, getting a chart into Word, Linking a chart in Word.
Microsoft Excel (module 306)
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
Working with formulas and functions, using percentage, Functions including average, sum, maximum, minimum and looking at more functions and the syntax of functions, copy formulas & functions & understanding relative & absolute cell references, inserting, viewing and editing comments. Hiding and un-hiding columns and rows.
Microsoft Excel (module 307) - coming in April 2009
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
How data is stored, field and record delimiters, header records and flatfile data, sorting and filtering using AutoFilter and Advanced filter methods (using AND and OR) and wildcard searches, combining data from several cells, finding data, using find and replace (across several sheets), using the text import wizard, looking at Excel data in Word and visa versa, creating drop down lists for consistent data entry using data validation.
Microsoft Excel (module 308) - coming in April 2009
Estimated completion (including workbook exercises) 7-10 hours (click here to log in)
Clean up a data file to remove unwanted (or blank records), create a pivottable using an excel file, field lists, data items area, the pivot table toolbar, drop page fields in different zones on the pivot table and notice the way information is presented changes, create pivottable charts based on the pivot table. |
