Part 2 is Tuesday, Jan 26th at 7PM


This is an online event.



Barry Black, Education Director
Mid-Florida SCORE

Understanding Your Business Using Excel pt2

  • Analyze your Accounting data
  • Forecast P&L and Cash Flow
  • Predict business impacts

Microsoft Excel can be a powerful tool to help you understand your business better and make data driven decisions. This workshop will show you how directly reuse your accounting system data and add your knowledge to predict the future of your business.

Very basic familiarity with Excel is a prerequisite, but all techniques and calculations will be fully explained. We will show you how to export your data from your accounting system to use in Excel. You will be able to forecast Profit & Loss and a basic cash flow.

Part 1 Jan 19th – Getting accounting data and making corrections to prepare the model. Part 1 has already been held and the recording should be viewed at https://midflorida.score.org/event/understanding-your-business-using-excel-3 

Part 2 Jan 26th– Create the forecast and analyze the result

Workshop Presenter: John Manry, over 40 years as a senior leader in commercial software development. Experience in finance/accounting, HR, and payroll. Used Excel extensively to help clients and manage the business.

There is a registration fee of $15 for this event which covers both parts described above. You can make payment using either a credit card or PayPal account. You can pay with your credit card without opening a PayPal account as shown in this video