Further Details
The course spans 7 vital lessons which cover the following: 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.
Guide price
Interest Free Credit May Be Available. |
