- : 13 Marks
– The following formula structures will come in handy:
- : =PMT(rate,nper,pv,fv,type)
- : =FV(rate,nper,pmt,pv,type)
- : =PV(rate,nper,pmt,fv,type)
- : =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Course Curriculum
- L09 C. Processing | Cash Book Processing
- L09 D. Processing | Journal Processing
- L10 A. Second Month | Processing a Second Month
- L10 B. Second Month | Processing a quotation
- L10 C. Second Month | Creating Sales Orders and Invoices
- L10 D. Second Month | Creating a Credit Note
- L10 E. Second Month | Additional Processing
- L10 F. Second Month | Remittance Assistant
- L10 G. Second Month | Month End Processing
- L10 H. Second Month | Tax Manager
- L11 A. The View Menu | General Ledger
- L11 C. The View Menu | Supplier Reports
- L11 D. The View Menu | Inventory Reports
- L11 D. The View Menu | Inventory Reports
- L12 A. Sundry Optimisation | Correction Of Errors
- L12 B. Sundry Optimisation | Scheduled Invoices
- L12 C. Sundry Optimisation | Take On Balances
- L12 D. Sundry Optimisation | Financial Reports
- L12 E. Sundry Optimisation | Bank Recon Statement
- Lesson 01 | Navigate in Pastel
- Lesson 01 | Open a company in Pastel
- Lesson 02 | Edit Customers
- Lesson 02 | Edit General Ledger
- Lesson 02 | Edit Inventory
- Lesson 02 | Edit Suppliers
- Lesson 03 | Create a Purchase Note
- Lesson 03 | Goods received notes
- Lesson 03 | Journals
- Lesson 03 | Return and debit
- Lesson 03 | Supplier invoice
- Lesson 04 | Create a quotation
- Lesson 04 | Credit Notes
- Lesson 04 | Debit Notes
- Lesson 04 | Tax Invoices
- Lesson 04 | Sales Orders
- Lesson 05 | Inter - account Transfers
- Lesson 05 | Processing in the payments cash book
- Lesson 05 | Reference Numbers
- Lesson 06 | Monthly Processing
- AIN2601 L02 SETTING UP THE PRINTER
- AIN2601 L03 RESOLVING THE DECIMAL SEPERATOR
- AIN2601 L04 INSTALLING PASTEL PARTNER
- AIN2601 L05 CREATING A COMPANY
- AIN2601 L06 REGISTERING PASTEL PARTNER
- AIN2601 L07 EDITING A CHART OF ACCOUNTS
- AIN2601 L08 ADDING GENERAL LEDGER SUB ACCOUNT
- AIN2601 L09 SETUP THE COMPANY PARAMETERS
- AIN2601 L10 BACKING UP AND RESTORING
- AIN2601 L11 SETUP - THE USERS
- AIN2601 L12 SETUP - THE ENTRY TYPES AND TAX
- AIN2601 L13 SETUP - UPDATE THE EDIT MENU
- AIN2601 L14 SETUP - UPDATE THE PROCESS MENU
- AIN2601 L15 SETUP - PROCESSING OPTIONS
- AIN2601 L16 SETUP OF CUSTOMERS CONTROL
- AIN2601 L17 SETUP OF SUPPLIERS CONTROL
- AIN2601 L18 SETUP OF INVENTORY
- AIN2601 L19 INTEGRATING THE GL TO INVENTORY
- AIN2601 L20 LOGGING IN AND OUT OF USER'S
- AIN2601 L21 FIXING THE USER PASSWORD IN USE ISSUE
- AIN2601 L22 WHAT IS OPEN ITEM AND BALANCE FORWARD
- AIN2601 L23 WHAT IS DATE OUT OF PERIOD
- AIN2601 L24 EDIT CUSTOMER ACCOUNTS
- AIN2601 L25 EDIT SUPPLIER ACCOUNTS
- AIN2601 L26 EDIT INVENTORY CATEGORIES
- AIN2601 L27 EDIT INVENTORY ITEMS
- AIN2601 L28 EDIT GENERAL LEDGER ACCOUNTS
- AIN2601 L29 TAKE-ON OF OPENING BALANCES EXPLAINED
- AIN2601 L30 TAKE-ON OF O/B - THE TRIAL BALANCE
- AIN2601 L31 TAKE-ON OF O/B - CUSTOMERS
- AIN2601 L32 TAKE-ON OF O/B - SUPPLIERS
- AIN2601 L33 TAKE-ON OF O/B - INVENTORY
- AIN2601 L34 TAKE-ON OF O/B - THE CASH BOOK
- AIN2601 L35 WORKING OUT AGEING ON AN AGE ANALYSIS
- AIN2601 L36 PROCESSING OF DAILY TRANSACTIONS
- AIN2601 L37 PROCESS A PURCHASE ORDER
- AIN2601 L39 MAKING SURE YOUR GRN DATE IS CORRECT
- AIN2601 L38 PROCESS A GOODS RECEIVED NOTE
- AIN2601 L40 PROCESS A PETTY CASH TRANSFER
- AIN2601 L41 UPDATING ALL OPEN BATCHES
- AIN2601 L42 PROCESS A SALES QUOTATION
- AIN2601 L43 PROCESS A SALES ORDER
- AIN2601 L44 PROCESS CHANGES TO A SALES ORDER
- AIN2601 L45 PROCESS A TAX INVOICE
- AIN2601 L46 CHECKING ON BACK ORDERS
- AIN2601 L47 USING THE REORDER ASSISTANT
- AIN2601 L48 PROCESS USING THE REMITTANCE ASSISTANT
- AIN2601 L49 PROCESSING IN THE PETTY CASH BOOK
- AIN2601 L50 RESTORE THE PETTY CASH FLOAT AMOUNT
- AIN2601 L51 PROCESSING IN JOURNAL SCREENS
- AIN2601 L52 USING EXCEL TO WORK OUT DEPRECIATION
- AIN2601 L53 PREPARE A BANK RECONCILIATION
- AIN2601 L54 CHANGING OPEN ITEM TO BALANCE FORWARD
- Study Unit 14: Selecting an appropriate accounting information system
- Study Unit 4 / 5: Creating user-friendly spreadsheets
- Study Unit 13: Financial reporting structure
- Study Unit 12: Finance and Investment cycle
- - 204 Semester 02 Part 011 hour 0 mins
- - 104 Semester 01 Part 011 hour 0 mins
- - 205 Semester 02 Part 011 hour 0 mins
- - 202 Semester 02 Part 011 hour 0 mins
- - 102 Semester 01 Part 011 hour 0 mins
- - 107 Semester 01 Part 011 hour 0 mins
- - 207 Semester 02 Part 011 hour 0 mins
- - 203 Semester 02 Part 011 hour 0 mins
- - 108 Semester 01 Part 011 hour 0 mins
- - 208 Semester 02 Part 011 hour 0 mins
- - 105 Semester 01 Part 011 hour 0 mins
- - 109 Semester 01 Part 011 hour 0 mins
- - 209 Semester 02 Part 011 hour 0 mins
- - 106 Semester 01 Part 011 hour 0 mins
- - 206 Semester 02 Part 011 hour 0 mins
- - 101 Semester 01 Part 011 hour 0 mins
- - 201 Semester 02 Part 011 hour 0 mins
- - 103 Semester 01 Part 011 hour 0 mins
- - 110 Semester 01 Part 011 hour 0 mins
- Study Unit 1: Data and the computerised information system process
- Study Unit 7: Overview of transaction processing
- Study Unit 4 / 5: Exam - Formulas
- - 109 Semester 01 Part 021 hour 0 mins
- - 209 Semester 02 Part 021 hour 0 mins
- - 106 Semester 01 Part 021 hour 0 mins
- - 206 Semester 02 Part 021 hour 0 mins
- - 107 Semester 01 Part 021 hour 0 mins
- - 207 Semester 02 Part 021 hour 0 mins
- - 102 Semester 01 Part 021 hour 0 mins
- - 101 Semester 01 Part 021 hour 0 mins
- - 201 Semester 02 Part 021 hour 0 mins
- - 103 Semester 01 Part 021 hour 0 mins
- - 203 Semester 02 Part 021 hour 0 mins
- - 108 Semester 01 Part 021 hour 0 mins
- - 110 Semester 01 Part 021 hour 0 mins
- - 210 Semester 02 Part 011 hour 0 mins
- - 210 Semester 02 Part 021 hour 0 mins
- - 104 Semester 01 Part 021 hour 0 mins
- - 105 Semester 01 Part 021 hour 0 mins
- - 205 Semester 02 Part 021 hour 0 mins
- - 208 Semester 02 Part 021 hour 0 mins
- Study Unit 8: Revenue and receipts cycle
- Study Unit 2: The Database Environment
- Study Unit 4 / 5: Exam - Operators
- - 109 Semester 01 Part 031 hour 0 mins
- - 209 Semester 02 Part 031 hour 0 mins
- - 206 Semester 02 Part 031 hour 0 mins
- - 106 Semester 01 Part 031 hour 0 mins
- - 107 Semester 01 Part 031 hour 0 mins
- - 207 Semester 02 Part 03 NO EXCEL
- - 102 Semester 01 Part 031 hour 0 mins
- - 101 Semester 01 Part 031 hour 0 mins
- - 201 Semester 02 Part 031 hour 0 mins
- - 110 Semester 01 Part 031 hour 0 mins
- - 210 Semester 02 Part 031 hour 0 mins
- - 105 Semester 01 Part 031 hour 0 mins
- - 208 Semester 02 Part 031 hour 0 mins
- - 108 Semester 01 Part 03 NO EXCEL
- Study Unit 9: Acquisition and payments cycle
- Study Unit 4 / 5: Exam - Referencing Cells
- - 203 Semester 02 Part 031 hour 0 mins
- Study Unit 3: Utilising databases
- Study Unit 4 / 5: Exam - Logical Test
- Study Unit 4 / 5: Exam - TEXT
- Topic 1 – Data management and Utilisation Revision with Quiz
- Study Unit 10: Inventory and Production cycle
- - 202 Semester 02 Part 021 hour 0 mins
- - 204 Semester 02 Part 02
- Study Unit 4 / 5: Exam - COUNTIF
- Study Unit 11: Payroll and Personnel cycle
- Topic 3 – Accounting Cycles Revision T Accounts
- - 202 Semester 02 Part 031 hour 0 mins
- - 204 Semester 02 Part 03
- Study Unit 4 / 5: Exam - SUM
- Topic 3 – Accounting Cycles Revision with Quiz
- Study Unit 4 / 5: Exam - ROUND
- Study Unit 4 / 5: Exam - AVERAGE
- Study Unit 4 / 5: Exam - MAX
- Study Unit 4 / 5: Exam - MID
- Study Unit 4 / 5: Exam - MIN
- Study Unit 4 / 5: Exam - LEFT
- Study Unit 4 / 5: Exam - RIGHT
- Study Unit 4 / 5: Exam - PMT
- Study Unit 4 / 5: Exam - FV
- Study Unit 4 / 5: Exam - IF
- Study Unit 4 / 5: Exam - PV
- Study Unit 4 / 5: Exam - VLOOKUP
- Study Unit 4 / 5: Exam - Percentages
- Study Unit 6: Spreadsheet security, risks and controls
No Comments