Microsoft Excel for Cash Flow Management
Microsoft Excel for Cash Flow Management
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - ENDS SOON
Offer Ends In
Days
:
Hours
:
Minutes
:
Seconds
OR
1 Year Access 
Level 3 - Diploma
29 Students -
8 hours, 12 minutes
Overview
Master the art of financial stability with our Microsoft Excel for Cash Flow Management course. Whether you are a seasoned cashflow manager or just stepping into the finance world, this course will provide you with the vital skills to excel. Learn how to manage and analyse your company’s financial flow using cashflow-management excel techniques that are crucial for day-to-day operations.
Our course covers essential topics such as cash receipts and disbursements internal controls, bank reconciliations, and petty cash handling. You’ will gain confidence in managing your finances with Microsoft Excel for Cash Flow Management by learning the necessary internal controls that keep your business secure.
Additionally, tackle a comprehensive problem, reinforcing your new cash flow excel skills. With detailed resources, including a Bank Reconciliation and Cash Control Diploma, you will leave this course ready to manage cash flow with confidence and precision.
Course Design
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
– Video lessons
– Online study materials
– Mock exams
– Multiple-choice assessment
How is the course assessed?
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.
Will I receive a certificate of 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.
Why study this course?
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.
Frequently Asked Questions
Maintain cash flow in Excel by forecasting income and expenses, tracking actual figures, and using formulas to analyze totals.
Yes, Excel has a cash flow function that helps you manage and analyze your cash flow. You can create a cash flow statement using formulas to track inflows and outflows, making it easier to assess your financial health.
Yes, you can find cash flow templates in Excel that help track income and expenses. These templates make it easier to manage cash flow and plan for financial needs.
Course Curriculum
| 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 | ||
No reviews found for this course.
Related Courses
Advanced
Level 2 - Certificate
Intermediate
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add