36. Spreadsheet Software (AAT)

• 36.01. Spreadsheet basics: USEFUL TIPS, Mouse click, Undo, Help, SPREADSHEET STRUCTURE, Definition, Rows, columns & cells, WORKBOOKS & WORKSHEETS, Files & folders, Worksheets, Workbooks, ENTER DATA INTO CELLS, Selecting multiple cells, COPYING CELLS, DEALING WITH ROWS & COLUMNS, Inserting a column, Inserting a row, Deleting a column, Deleting a row, Changing the width of a colum, Changing the height of a row, USING BASIC FORMULAS, Calculating averages.
• 36.02. Formatting the spreadsheet data: FORMATTING - STYLE, Making data bold, Using italics, Undelining data, Note - changing back to normal text, FORMATTING TEXT - FONT & SIZE, Font face, Font size, FORMATTING - NUMBERS, Dealing with decimal places, Displaying commas in figures, Dealing wth currencies, Dealing with percentages, CELL ALIGNMENT, Merged cells, DATA FORMATS, PAGE SETUP & PRINTING, Headers & footers.
• 36.03. Advanced formatting: CELL DISPLAY, Using borders, Using font & fill colour, MOVING A COLUMN OR A ROW, HIDE A ROW OR A COLUMN, SPECIFYING ROW HEIGHT & COLUMN WIDTH, CELL & WORKSHEET PROTECTION, CONDITIONAL FORMATTING, DATA VALIDATION, A note on copying data validation.
• 36.04. Spreadsheet functions: FORMULAS, MATHEMATICAL OPERATORS, FUNCTIONS - AN EXPLANATION, RANGES, MATHEMATICAL FUNCTIONS, ABS, INT, SUM, AUTOSUM, How to use AUTOSUM, CELL ADDRESSING, Relative addressing, Absolute addressing, DATA FUNCTIONS, TODAY, NOW, LOGICAL FUNCTIONS & OPERATORS, Logical operators, IF, LOOKUP FUNCTIONS, HLOOKUP, VLOOKUP, Notes on lookups, Circular references.
• 36.05. Sorting, checking & importing data: FORMULA VALIDATION, Show formulas, Error checking, Circular references, Trace precedents, Trace dependents, SPELL CHECK, FIND & REPLACE, Find, Replace, SORTING DATA - THE SORT TOOL, Filter, SUB TOTALS, LINKING & EMBEDDING, Copy & paste, Embedding, Linking, EXPORT & IMPORT.
• 36.06. Statistical functions & charts: STATISTICAL FUNCTIONS, Count, MAX, MIN, AVERAGE, ANALYSIS TOOLS, Rank & percentile, Moving averages, Histogram, TYPES OF CHARTS, Bar chart, Line chart, Pie chart, Scatter chart, Doughnut, Bubble, CREATING A CHART, Scatter chart with trend line, Charts - learning about the software.
• 36.07. Pivot tables & workbook management: WINDOW - FREEZE PANES, PASTE SPECIAL, WORKING WITH MULTIPLE WORKSHEETS, Copying a worksheet, WORKING WITH MULTIPLE WORKBOOKS, Using Copy & Paste to move data, PIVOT TABLES - AN INTRODUCTION, What is a pivot table?, Advantages of a pivot table, Examples of pivot tables, CREATING A PIVOT TABLE, REMOVING OR CHANGING A PIVOT TABLE, Changing fields, Clearing a pivot table, FORMATTING PIVOT TABLES, Cell display, Table style, Subset of data, DRILL DOWN, Column C before formatting, Column C after formatting, WHAT-IF SCENARIOS, Goal seek, Data tables.

END