Microsoft Excel is the world most popular spreadsheet with powerful features like Worksheets with calculations, databases and graphs and charting. Here is a list of all the topics included in our online Microsoft Excel course. There are two workbooks included with each course, the 2000/2003 version and the 2007/2010 version. Remember that as of January 2011 course enrollment includes lifetime membership so you can use the course as a resource for the rest of your working life!
Microsoft Excel (module 301)
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)
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)
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)
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)
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)
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)
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)
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.
