This manual uses complex spreadsheets to produce evidence for the CLAIT Advanced 2006 Unit 2 assessments. All aspects of Excel are covered as evidence is collected. The student will be able to: create multi-level spreadsheets for a common purpose, use a range of complex formulas and functions, create a macro and analyze spreadsheet data, format and maintain spreadsheets, print spreadsheets and formulas. Data files are available to download allowing you to practice the software features. Endorsed by OCR.
| ISBN | 1860054749 | | Pages | 184 | | ISBN13 | 9781860054747
(What's this?) | | Published in | Sunderland | | Publisher | CiA Training Ltd | | Series title | CLAIT Advanced | | Imprint | CiA Training Ltd | | Height (mm) | 297 | | Format | Spiral / Comb Bound | | Width (mm) | 210 | | Publication date | 29 Aug 2008 | | Academic level | Revision/study guides |
|
|
|
Spreadsheet PrinciplesFormattingFormulasAuditing and ValidationCell ReferencingCommentsPrintingLinkingShared WorkbooksMulti-Level SpreadsheetsEditingFunctionsFiltering ListsNamesPivot TablesMacrosCharts
Enlarge
