How To Create A Project Costing Application with Budget vs. Actual Costs In Excel [Free Download]

In this week’s training, I will show you how to create a Project Costing Application

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:34 – Overview
5:03 – Worksheet Design
43:18 – Change Event Worksheet
56:25 – Save and Update Project
1:14:17 – Load Project
1:28:00 – New Project
1:31:45 – Print Project

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelTraining #ProjectCosting #ProjectBudget #ExcelVBA

[jadaperez]

Thank I went for an interview with a construction Co last week. I've been in Construction for years but the position was for Accounts Payable. The Interviewer thought I was there for a different reason. I went from interviewing for a 15/hr position to making more than double that; I'm now the new Project Manager/Estimator for the company. I've spent the last four days learning Excel and I took this chart in this morning, and watched the owner's and Office Manager's eyes blend into their hairline. You have made me look like a frikin genius.

[israelmobley]

Buddy, let me just say. I have never, ever, EVER seen this before in my life. But you are certainly skilled. I could tell when you were in your groove and just moving through the coding for the macros, that shows experience. Thank you so much for taking the time to make/explain this and then offering the template for free to any person who is fortunate enough to see this.

I am a young construction business owner looking to revamp and revise the way the family company assesses it's finances. I watched your entire video even after downloading the template just so I can make sure I use it correctly.

Thank you again, you are awesome

[DrJohnPollard]

Randy,
I don't know how you do it. Every week you come up with a functional, simple, clear, useful video with a matching software project. It's not possible to do this, and yet you achieve it week after week. It truly is amazing. You are inspiring multitudes of excel worshipers. It's quite impressive.

[LawrenceLWWong]

This is the first time i leave a comment to a youtuber. I just cant wait to express my excitement when i see this! I just randomly bumped into your content and it has been quite a while since i see a high quality video tutorial before this. Thank you so much you have made my day so meaningful.

[czechyorker]

I keep missing the premiere but Always come here to learn something new. Many thanks for the great projects.

[harryjeganathan]

​Hi Randy, I really enjoy the your training videos. Every Tuesday I look forward the videos. Thank you 👍

[aakashpatel]

Sir, it really great... Your knowledge helps millions of people.

[dougmphilly]

i'm looking for an AIA like tracking model. this is a good start. thanks.

[smathers]

Thanks Randy..another great Excel model. In the real world though often something like this application would need to interface with an accounting system either as front end input or more likely read transactions exported from it.

[johnreyaurellano]

This is really what i need, thanks for the knowlegde you sharing bro!! 👊

[druckrc]

HI Randy
I really in joy watching your video I think I have watched over half on them . I tried reproducing your inventory mange with not much success . So I tried to reproducer this one once I thinking that it would really help me out at work. I think I spent total of 16 hrs checking the code making sure I have the right formulas in the right cells success.

[charlenemack]

I need a spreadsheet to track IT Project Costs, in addition to budget vs actual. Customer does not issue PO so I need a form for that. I enjoyed watching this video. I'm going to go through the rest to see of you have something I can use

[tanghingkwong]

Thanks for informative video. Useful for teaching & learning purpose.

[asimsiddiq]

very, very, excellent collection of project achievements.

[keep_digging]

this is the first time i have caught this while it is live, others i have had to watch afterwards

[ahmedqasim]

Thanks so much for such great helpful videos

[tienngotk]

This is the template i ha ve found so far. Thank you so much for sharing your great dashboard

[wayneedmondson]

Hi Randy. Another epic and awesome video and lesson! Thanks for sharing it. Thumbs up!!

[MeyerZevallos]

I really apreciate your time to get us this excellent video. Thank you so much Randy

[mdlokmanhossain]

This abosletuley amazing advice...❤️❤️❤️❤️❤️