Lesson One: Identifying the elements of the opening screen, entering addition formulas, adjusting column widths, using the SUM function, using the AutoSum feature. Lesson Two: Applying bold, italic and underline formats, changing font, selecting and formatting cells ranges , applying number formats, using AutoFill, entering formulas. Lesson Three: Inserting and deleting rows and columns, hiding and unhiding rows and columns, wrapping and indenting text, applying a fill colour, applying borders. Lesson Four: Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom. Lesson Five: Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, page orientation, adjusting margins and scaling, print preview and print a worksheet, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions. Lesson Six: Inserting and formatting headers and footers, inserting header and footer codes including date, page number and file name, copying and pasting data between worksheets, grouping and formatting multiple worksheets. Lesson Seven: Creating more complex formulas, making a cell reference absolute, displaying all formulas, customising and viewing calculations, using the NOW, TODAY and IF functions. Lesson Eight: Displaying a hidden worksheet, using the PMT and FV functions, recognising errors, using the IFERROR function. Lesson Nine: Column, line and pie charts, chart elements, adding and removing a data table, switching chart rows/columns, changing chart layout options, selecting and formatting chart elements , inserting sparklines, inserting moving, resizing and rotating pictures. Lesson Ten: Using Spell check, using Filter, finding and replacing text and formats, saving a workbook as a web page, hyperlinks.
Name: Microsoft Excel Qualification title: Spreadsheet Software Qualification type: Assessment Awarding Multiple Awarding Bodies Created 20170109 09:27:43 Updated 20170113 11:32:06
Exam and synoptic assessments Equipment required Exam and synoptic assessments
PITMAN TRAINING GROUP LIMITED
gail.charlton@pitman-training.com
n/a
Walkers Court, Audby Lane Town: Wetherby
Title: Spreadsheet Software Qualification: Spreadsheet Software Classification: Information and Communication Technology