The Microsoft Excel for Cash Flow Management course is intended for the business owners looking for an excellent demonstration and examples of how to create and format a statement of cash flows with Excel.
This course will help you to perform a cash flow analysis and learn to prepare an estimate or plan for future cash flows. You will understand the cash flow statement essentials, such as operating, investing and financing activities and how to control cash and efficiently deal with internal controls.
Learning how to adjust the bank accounts to secure the accounts, verify the accuracy of the account, and how to check all transactions through bank statement etc. also explained in this course.
Benefits of studying Microsoft Excel for Cash Flow Management:
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Excel for Cash Flow Management is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Introduction | |||
Introduction | 00:06:00 | ||
Internal Controls Overview and Cash Internal Controls Introduction | |||
2 Internal Controls Overview and Cash Internal Controls Introduction | 00:01:00 | ||
10 Internal Controls. | 00:19:00 | ||
PDF – 20 Cash Internal Controls Overview | 00:01:00 | ||
20 Cash Internal Controls Overview | 00:08:00 | ||
Multiple Choice Questions 1 – Cash and Internal Controls | 00:08:00 | ||
Accounting Comic Break | 00:01:00 | ||
Cash Receipts Internal Controls | |||
3 Cash Receipts Internal Controls | 00:01:00 | ||
30 Cash Receipts Internal Controls | 00:08:00 | ||
Multiple Choice Questions 2 – Cash and Internal Controls | 00:09:00 | ||
Accounting Comic Break | 00:01:00 | ||
Cash Disbursements Internal Controls | |||
4 Cash Disbursements Internal Controls | 00:01:00 | ||
PDF – 40 Cash Dismemberment Internal Controls | 00:01:00 | ||
40 Cash Disbursements Internal Controls | 00:08:00 | ||
Multiple Choice Questions 3 – Cash and Internal Controls | 00:08:00 | ||
Accounting Comic Break | 00:01:00 | ||
Bank Reconciliations | |||
5 Bank Reconciliations | 00:02:00 | ||
PDF – 50 Bank Reconciliation D & D | 00:01:00 | ||
50 Bank Reconciliation-Accounting%2C Financial | 00:20:00 | ||
Excel Download | 00:01:00 | ||
9.10 Bank Reconciliation January | 00:23:00 | ||
Excel Download | 00:01:00 | ||
Worksheet – 9.12 Bank Reconciliation Adjusting Entries January | 00:18:00 | ||
Excel Download | 00:01:00 | ||
Worksheet – 9.15 Bank Reconciliation February | 00:21:00 | ||
Excel Download | 00:01:00 | ||
Worksheet – 9.20 Bank Reconciliation Feb. Adjusting Entries | 00:14:00 | ||
Multiple Choice Questions 4 – Cash and Internal Controls | 00:08:00 | ||
Short Calculation 1 | 00:10:00 | ||
Accounting Comic Break | 00:01:00 | ||
Petty Cash | |||
6 Petty Cash | 00:02:00 | ||
PDF – 60 Petty Cash | 00:01:00 | ||
60 Petty Cash | 00:20:00 | ||
Excel Download | 00:01:00 | ||
Worksheet – 800.10 Petty Cash Journal Entries Part 1-Accounting%2 | 00:10:00 | ||
Worksheet 800.20 Petty Cash Journal Entries Part 2-Accounting%2C | 00:11:00 | ||
Multiple Choice Questions 5 – Cash and Internal Controls | 00:08:00 | ||
Short Calculation 2 | 00:10:00 | ||
Accounting Comic Break | 00:01:00 | ||
Comprehensive Problem | |||
7 Comprehensive Problem | 00:01:00 | ||
Excel Download | 00:01:00 | ||
1 Accounting%2C Financial – Comp Prob Service Co 1 Part 1 | 00:15:00 | ||
2 Accounting%2C Financial – Comp Prob Service Co 1 Part 2 | 00:15:00 | ||
3 Accounting%2C Financial – Comp Prob Service Co 1 Part 3 | 00:15:00 | ||
4 Accounting%2C Financial – Comp Prob Service Co 1 Part 4 | 00:22:00 | ||
5 Accounting%2C Financial – Comp Prob Service Co 1 Adjusting Entr. | 00:15:00 | ||
6 Comp Prob Service Co 1 Adjusting Entries part 6 | 00:20:00 | ||
7 Accounting%2C Financial – Comp Prob Service Co 1 Financial Stat | 00:15:00 | ||
8 Accounting%2C Financial – Comp Prob Service Co 1 Financial Stat | 00:17:00 | ||
9 Accounting%2C Financial – Comp Prob Service Co 1 Closing Proces | 00:10:00 | ||
10 Comp Prob Service Co 1 Closing Process part 10 | 00:11:00 | ||
Multiple Choice Questions 6 – Cash and Internal Controls | 00:08:00 | ||
Multiple Choice Questions 7 – Cash and Internal Controls | 00:09:00 | ||
Accounting Comic Break | 00:01:00 | ||
Definitions & Key Terms | |||
8 Definitions & Key Terms | 00:01:00 | ||
Bank Statement Definition – What is Bank Statement%3F | 00:03:00 | ||
Canceled Checks Definitions – What are Canceled Checks%3F | 00:02:00 | ||
Cash Definition – What is Cash%3F | 00:01:00 | ||
Cash Equivalents Definition – What are Cash Equivalents%3F | 00:02:00 | ||
Cash Over and Short – What is Cash Over and Short%3F | 00:02:00 | ||
Check Definition – What is Check%3F | 00:02:00 | ||
Check Register Definition – What is Check Register%3F (1) | 00:03:00 | ||
Deposits in Transit – What are Deposits in Transit%3F | 00:03:00 | ||
Gross Method Definition – What is Gross Method%3F | 00:04:00 | ||
Invoice Definition – What is Invoice%3F (1) | 00:02:00 | ||
Liquid Assets Definition – What are Liquid Assets%3F | 00:03:00 | ||
Liquidity Definition – What is Liquidity%3F | 00:03:00 | ||
Outstanding Check Definition – What are Outstanding Checks%3F | 00:03:00 | ||
Petty Cash Definition – What is Petty Cash%3F | 00:03:00 | ||
Purchase Requisition Definition – What is Purchase Requisition%3F | 00:02:00 | ||
Bank Reconciliation Definition – What is Bank Reconciliation | 00:05:00 | ||
Vendee Definition – What is Vendee%3F | 00:02:00 | ||
Vendor definition – What is vendor%3F | 00:02:00 | ||
Accounting Comic Break | 00:01:00 | ||
Resources – Bank Reconciliations and Cash Control Diploma | |||
Resources – Microsoft Excel for Cash Flow Management | 00:00:00 | ||
Order Your Certificate | |||
Order Your Certificate Now | 00:00:00 |
Membership renews after 12 months. You can cancel anytime from your account.