Advanced Excel Modelling Course with Formulas, VBA, Power Query
Review
COURSE REVIEWS
Course Reviews
No Reviews found for this course.
Getting prepared - access the software and course materials | |||
The structure of the course – first things first! | 00:05:00 | ||
Set up free trial | 00:03:00 | ||
Getting started | |||
Starting A New Company File | 00:11:00 | ||
Setting up the system | |||
set up nominal accounts | 00:11:00 | ||
Enter opening balances | 00:02:00 | ||
Reverse opening balances – accruals and prepayments | 00:06:00 | ||
Report Journal | 00:05:00 | ||
Nominal ledger | |||
Amend The Nominal Ledger | 00:07:00 | ||
Report listing the nominal ledgers | 00:02:00 | ||
Customers | |||
Enter customers | 00:09:00 | ||
Report on customer contact information | 00:01:00 | ||
Suppliers | |||
Enter Suppliers | 00:05:00 | ||
Supplier Contact List | 00:02:00 | ||
Sales ledger | |||
Enter Invoices | 00:09:00 | ||
Invoice Entering | 00:03:00 | ||
Invoice batch | 00:06:00 | ||
Post Sales Credit Notes | 00:08:00 | ||
Report showing Customer Activity | 00:03:00 | ||
Aged Debtors | 00:02:00 | ||
Purchases ledger | |||
Post Supplier Invoices | 00:03:00 | ||
Entering a Batch of Supplier Bills | 00:09:00 | ||
Credit Notes Suppliers | 00:05:00 | ||
Reclassify Supplier Bills – Flash Bulbs Purchased | 00:04:00 | ||
Supplier Account Activity Report | 00:04:00 | ||
Sundry payments | |||
Post Cheques | 00:07:00 | ||
Report showing supplier payments | 00:01:00 | ||
Sundry receipts | |||
Receipts from customers | 00:07:00 | ||
Report showing customer receipts | 00:02:00 | ||
Petty cash | |||
Post Petty Cash Transactions and Report | 00:04:00 | ||
Post cash payments to ledgers | 00:02:00 | ||
Enter petty cash items | 00:14:00 | ||
Report on Petty Cash Payments Proper | 00:05:00 | ||
Post Sundry Payments | 00:05:00 | ||
Report Bank Payments | 00:03:00 | ||
VAT - Value Added Tax | |||
VAT Return | 00:03:00 | ||
Bank reconciliation | |||
Reconcile The Bank | 00:10:00 | ||
Provide A Report Showing Any Unreconnciled Transaction | 00:02:00 | ||
Payroll / Wages | |||
Post the Wages Journal | 00:08:00 | ||
Posting Journal Adjustments | 00:02:00 | ||
Reports | |||
Month end adjustments | 00:03:00 | ||
Month end reports | 00:06:00 | ||
Tasks | |||
Task- Crearing the accounts | 00:06:00 | ||
Task – Customer report | 00:01:00 |
Advanced Excel Modelling Course with Formulas, VBA, Power Query
No Reviews found for this course.