Tony Arkwright's Learning Zone
Tony's Powerpoint Presentations
These powerpoint presentations are stored on the college INTRANET and as such can only be accessed if you view by logging on to a machne WITHIN the college. (moral is - come to college to do your study ! )
01 - Columns Widths and Alignment
02 - Protecting a Worksheet
03 - User Specifications
04 - Lookup Tables
05 - The LOOKUP function
06 - Naming Cell Ranges
07 - Using List and Combo Boxes
08 - Cash Flow Forecasts
09 - Data Entry Forms validation and Error Messages
10 - Formatting Cells
11 - Level Test
12 - Using Macro's
13 - Templates and Forms
14 -
NEW
- Menu Screens
Tony's Advanced Spreadsheet Notes
01 - Using a Spreadsheet for Cash Flow
02 - The IF Statement
03 - The LOOKUP function
04 - Password Protecting your Spreadsheet
05 - Macros
06 - Create a Pictogram
07 - IF statement exercise
08 - Password Protecting your Spreadsheet
09 - Save changes to the sheet
10 - Pre Assignment exercise
11 -
NEW
- The OFFSET function
Tony's Advanced Spreadsheet Examples
01 - EX1.xls
02 - Accounts.xls
03 - If2.xls
04 - level test.xls
05 - ACCOUNTS_L2.xls
06 - Invoice practical tutor demos
07 - macro example 1
08 - close
09 - drop down menu easy