Chat with us, powered by LiveChat
  • LOGIN
  • No products in the cart.

Microsoft Excel for Cash Flow Management

Microsoft Excel for Cash Flow Management

2 STUDENTS ENROLLED

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.

While I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification 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
Assessment
TAKE THIS COURSE

COPYRIGHT © 2018 One Education