This course is aimed at people who are new to spreadsheets or those who have been "passively" using Excel and who want to have more opportunity to explore what it can do.
In approximately 20 hours, your skill level will soar as you learn the following skills:
Lesson 1: Creating a spreadsheet, entering text and numbers, navigating a spreadsheet, saving, naming and closing a spreadsheet, opening an existing spreadsheet, editing cell contents.
Lesson 2: Formatting, selecting cells and ranges, text alignment, merging and centring, printing, inserting and deleting rows, simple formulas, moving and copying cells, AutoFill, editing formulas.
Lesson 3: Using AutoComplete, freezing and unfreezing panes, text orientation, page break preview, changing page orientation, adjusting margins and scaling, centring horizontally and vertically, displaying gridlines, inserting headers and footers, printing selected data, naming a worksheet, deleting a worksheet.
Lesson 4: Using AutoCalculate, applying absolute cell references, cell formatting, using more complex formulas, applying borders, using styles.
Lesson 5: inserting a new worksheet, naming a worksheet, grouping and ungrouping worksheets, applying wrap text formatting, indenting text, creating linked formulas, printing row and column headings, centring text horizontally and vertically.
Lesson 6: Using the SUM and COUNT functions, Using the formula palette to enter formulas for AVERAGE, MAX and MIN, sorting columns, using the Now, Date, IF, PMT and FV functions.
Lesson 7: Using the Chart Wizard, formatting and editing charts, saving selected data and a workbook as a web page, inserting and using a hyperlink, sending a workbook via email, deleting an object, using find and replace.
|
|
