7574 ITQ Spreadsheet software

Spreadsheet software Level 1 (127) Excel 2007 (XP)

Contains 172 pages on the following topics:

Absolute cell reference, Align left/right/centre, Applications, Arithmetic operator precedence, Arithmetic operators, AutoFill, AutoSum, AVERAGE function, Backup, Bar chart, Borders and Shading, Chart mini toolbar, Clear cells, Column widths, Command tabs, Copy/Paste, COUNT function, Data types (Character, Numeric), Date (Today) function, Delete cell contents, Delete row/column, Design, Directory/Folder, Error Values, Filenames, Files, Find and replace, Font and font size, Format Cells (Accounting, Bold/italic/underline, Currency, Custom, Date, General, Number, Percentage, Text), Formula Bar, Formulas, Graphs.charts, Header/Footer, Help. IF function, Insert row/column, Line graph, Logical Errors, MAX function, Merge and centre text, MIN function, Move data, Office Button, Open file, Orientation, Page Setup, Pie chart, Print chart, Print formulas, Print gridlines, Print Preview, Print Row and column headings, Print selected cell range, Printers, Print, Quick Access toolbar, Reference operator, Relative cell reference, Replication, ROUND function, Row height, Save file, Scroll window, Select cell/row/column, Select a range of cells, Sort data, Status bar, SUM function, Syntax Errors, Toolbars, Undo, Version numbers, Worksheet tabs, Exercises, Questions, Sample assignment, Answers

Spreadsheet software Level 2 (227) Excel 2007 (XP)

Contains 246 pages on the following topics:

Absolute cell reference, Align text, Arithmetic operator precedence, Arithmetic operators, AutoSum, AVERAGE function, Borders and shading, Character data type, Character formats, Column widths, Command tabs, Comparison operators, Conditional formatting, Copy data between spreadsheets, Copy/paste cells, COUNT function, Data abstracts, Data capture form, Date functions, Delete cell contents, Delete column/row, Delimited files, Design, Enhance text (bold, italics, underline), Error values, Extract data, Filter, Find a file, Find and replace, Floppy disk, Font, Font size, Footer, Format cells (Accounting, Currency, Custom, Date, General, Number, Percentage, Text, Time, Wrap text), Formula Bar, Formulas, Free/Unfreeze panes, Goal seek, Graphs and charts, Header, Hide/Unhide columns/rows, IF function, Implement and test, Insert column/row, INT function, Link spreadsheet data, Logical errors, LOOKUP function, Margins, MAX function, Merge and centre text, MIN function, Mini toolbar, MOD function, Move cells, Move a row, Name Box, Named range, Office Button, Operators, Orientation, Page break, Paste Special, Print formulas, Print Preview, Print quality, Print row and column headings, Print to fit, Print worksheet, Protect/Unprotect cells, Quick Access toolbar, Reference operator, Relative cell reference, Remote files, Removable/portable media, ROUND function, Row height, Select a range of cells, Series (AutoFill), Sort data, Split windows, Status bar, SUM function, Summarise totals, Syntax errors, Templates, Testing, Toolbars, Undo, User instructions, Validation, Version control, What if, Worksheets, Wrap tex, Questions, Sample assignment, Answers

Spreadsheet software Level 3 (327) Excel 2007 (XP)

Also suitable for the Advanced VQ

Contains 368 pages on the following topics:

Absolute cell reference, Area chart, Arithmetic operator precedence, Arithmetic Operators, Auditing tools, Automatic calculation, Bar chart, Borders and Shading, Breakeven Analysis, Button control,Circular reference, Clipboard, Command buttons, Combination chart, Command tabs, Comments, Comparison Operators, Conditional formatting, Custom format, Data Tables (One Variable, Two Variable), Date format, Date & Time functions, Design, Document macros, Doughnut chart, Embedded object, Error Values, Expected results, Export data, Filter, Financial functions (FV, INTRATE, IRR, PMT, PV, RATE), Find and replace, Font, Forms, Formula Bar, Formulas, Freeze/unfreeze panes, Goal seek, Graphs/charts, Header/Footer, Help. Hide formulas, Hide/Unhide, Hyperlink, IF function, Import data, Invoice System, ISERROR function, Line graph, Linked object, Logical errors, Lookup functions(HLOOKUP, INDEX, LOOKUP, MATCH, VLOOKUP), Macros, Manual calculation, Mathematical functions (INT, PI, RAND, RANDBETWEEN, ROUND, SUM), Merge and centre, Multiple worksheets, Name Box, Named ranges, Office Button, Office Clipboard, Page Break, Page Setup, Pie chart, Pivot tables, Print, Print column headings on every page, Print Area, Print formulas,Print Preview, Print row and column headings, Protect worksheet, Publish a worksheet, Quick Access toolbar, Reference operator, Relative cell reference, Replication, Scale to Fit page ~(condensed print), Series, Share workbooks, Solver, Sort data, Statistical functions (AVERAGE, COUNT, COUNTA, MAX, MEDIAN, MIN, MODE, PERCENTILE, STDEV, VAR), Status bar, Summarise totals, Syntax errors, Tables, Templates, Testing, Text functions (CONCATENATE, LEFT, LEN, MID, RIGHT, TEXT, TRIM, VALUE), Text operator, Time format, Toolbars, Unlock cells, User instructions, Validation, xy scatter chart, Questions, Sample assignment, Answers