Excel: Building a 13-Week Cash Flow
Focused View
Chris Reilly
2:29:24
0 View
01 - Unlocking the power of cash flow forecasting.mp4
00:50
01 - 13-week cash flow overview.mp4
02:51
02 - A simple cash flow.mp4
02:44
03 - What were going to build.mp4
03:14
04 - Email from the CFO.mp4
02:36
01 - Format bank data.mp4
03:50
02 - Inserting helper columns.mp4
03:53
03 - Add the week-ending date.mp4
03:24
04 - Import cash forecast template.mp4
03:49
05 - Build the error checking tab.mp4
03:23
06 - Conditional format error checking.mp4
03:55
07 - Build transaction mapping tab.mp4
04:13
08 - Build unique IDs and categories.mp4
07:08
09 - Build an exact match formula.mp4
04:28
10 - Build a text contains formula.mp4
06:48
01 - Calculate the history.mp4
07:00
02 - Bring in the AP aging report.mp4
03:59
03 - Bring in the AR aging report.mp4
03:17
04 - Link the AR and AP aging reports.mp4
05:10
05 - Finish the cash forecast.mp4
06:29
01 - Establish summary dates.mp4
02:31
02 - Populate the summary.mp4
05:28
03 - Build a cash flow chart.mp4
05:52
01 - New email from CFO.mp4
02:12
02 - Duplicate the cash forecast.mp4
02:27
03 - Bring in new bank data.mp4
04:16
04 - Bring in the AR and AP reports.mp4
04:01
05 - Refresh the history in the cash forecast.mp4
02:29
06 - Update the forecast.mp4
04:12
07 - Update the summary.mp4
02:11
01 - Add variance tags.mp4
03:06
02 - Begin the variance report.mp4
03:23
03 - Bring in the variance report layout.mp4
01:00
04 - Start populating the bridge.mp4
04:25
05 - Calculate the category variances.mp4
06:54
06 - Finish the bridge.mp4
03:51
07 - Close out the file.mp4
04:30
01 - Course summary and conclusion.mp4
03:35
Description
In this practical course, learn how to create a robust and dynamic cash flow forecast using Microsoft Excel. Instructor Christopher Reilly shows you how to clean up your source data, build a cash flow forecast from scratch, summarize your findings, and refresh the forecast with new data. You'll also discover how to perform variance analysis to compare actual results against your projections. By the end of this course, you'll have a powerful tool to help you manage your business's cash flow and make informed financial decisions.
More details
User Reviews
Rating
average 0
Focused display
Category
Chris Reilly
Instructor's Courses
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 38
- duration 2:29:24
- Release Date 2025/02/25
