Automated forecasting in Excel: AFP DIY automation series
What is the easiest way to have Excel create an automated forecast leveraging your time-series data? Dr. Kevin Kelly takes ...
Tag: Excel
Web scraping with Power Query: AFP DIY automation series
Getting your data into Excel can be a chore, but Dr. Kevin Kelly, shows how to “scrape the web” to ...
How to use Excel's Solver: AFP DIY automation series
The Solver add-in to Excel expands your analytical toolkit by optimising your model output to fit your goals, such as ...
The enduring use of spreadsheets in finance
Love them or hate it, spreadsheets have been around since 1979 with the release of VisiCalc, a program written for ...
Financial modelling in times of COVID-19 uncertainty part one
A good financial analyst follows certain procedures and discipline This article will explain major errors made with financial modelling and ...
Webinar: Automate planning processes to react faster and adapt to uncertainty
Who says you need to give up your Excel spreadsheets to bring finance into the digital era. Jedox' Excel+ philosophy ...
Prepare for Tomorrow: Planning & Budgeting using existing Excel skills
Your finance team insists on using spreadsheets but would like to reap the benefits of higher-value planning, budgeting and analysis. ...
