This course ;consolidates existing knowledge of Microsoft Excel. Enter, Edit and organise data; Use Page Setup - fit data to one page, use of margins and headers/footers; Formulas to include: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTBLANK, COUNTIF, SUMIF, ROUND, TODAY, VLOOKUP; Absolute and Relative formulas with the use of the $ sign; Creating charts (Column, Pie and Line).
Name: Microsoft Units - Spreadsheets (Level 1) Qualification title: Level 1 Certificate Qualification type: Course provider certificate (this must include an assessed element) Assessment You will complete tasks throughout the course and build a portfolio, there is no formal exam. Awarding - Created 20161110 15:34:51 Updated 20170111 15:50:14
The use of a personal memory stick would be helpful. Equipment required The use of a personal memory stick would be helpful.
CENTRAL COLLEGE NOTTINGHAM
Further Education
enquiries@centralnottingham.ac.uk
0115 914 6414
http://www.centralnottingham.ac.uk
Maid Marian Way Town: Nottingham