-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Microsoft Excel for Cash Flow Management
Microsoft Excel for Cash Flow Management
£29 ex Vat
Take This Course OR
1 Year Access 
Level 3 - Diploma
27 Students -
8 hours, 12 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
Overview
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:
- 24/7 access to the course for 12 months
- No hidden fees or exam charges
- CPD endorsed certification on successful completion
- Full Tutor support on weekdays (Monday – Friday)
- Efficient exam system, assessment and instant results
- Improve your chance of gaining professional skills and better earning potential.
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.
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 | ||
Related Courses
Intermediate
Intermediate
Intermediate
COPYRIGHT © 2022 One Education
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