MrExcel Presents: Project Accounting in Excel

April 12, 2023

On-Demand Webinar

Bill Jelen, MrExcel, hosted “Project Accounting in Excel” on the 12th of April, 2023 @ 12 PM EDT | 5 PM GMT.

When you watch the recording you will discover

Budget versus Actual: How can you merge a top-down budget with bottom-up actuals? Learn how to use the data model in Excel to create relationships between tables with different levels of granularity.
Projecting your Forecasted Completion Date: You have 72 work days to complete 300 units of work. Log your progress each day and have Excel predict if you will finish on day 70 (great!) or day 170 (oh no!). Find out how that dreaded “dotted red line” on the chart can forecast your propensity to procrastinate.
Visualize your Project PPrSan with a Gantt chart in Excel: True, Excel does not offer a built-in Gantt chart, but there are plenty of ways to hack one together. Watch as MrExcel builds a Gantt Chart with conditional formatting and then download the finished workbook.
Store your team task list in OneDrive: The entire team can easily access the report and use Excel sheet view to see just their tasks. Also check out how the new threaded comments can allow you to alert other team members that you have a question about a task.
Project Tracking and Project Review in Excel: Quickly create and maintain projects, tasks, and other related information.

Meet the Presenter

Bill Jelen – MrExcel

Bill Jelen is the host of MrExcel.com and the author of 64 books about Microsoft Excel including: Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.

Jelen produced over 2400 episodes of his Excel video podcast entitled Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.

Connect with MrExcel