SPREADSHEETS - 30.06.2020
Using Excel’s MOD function when drawing up budgets
You’re drawing up revised budgets and forecasts and need to allocate amounts across months. Using Excel’s MOD function can help simplify the process. How does it work?
CORONAVIRUS - INSURANCE - 30.06.2020
Business interruption insurance - are you covered?
Some insurers are refusing to cover losses arising from the coronavirus pandemic so the FCA is seeking an urgent court decision to provide clarity. What steps can you take in the meantime to put the company in the strongest position possible?
CORONAVIRUS - CAPACITY - 22.06.2020
Managing capacity post-lockdown
The economy is starting to open but with demand likely to be down and concerns over staffing, you’ve started thinking about the balance of capacity versus level of business. How do you get this right to maximise profitability?
CORONAVIRUS - FORECASTING - 03.06.2020
Preparing a short-term cash-flow forecast
With the coronavirus crisis, the company’s cash flow is starting to come under pressure. The board have asked you to prepare a short-term cash-flow forecast covering the next three months. Where do you start?
SPREADSHEETS - 03.06.2020
How to clean up dirty data
One of the biggest hurdles to overcome when trying to combine data is having to clean up data that has, for example, extra spaces in cells or numerous duplicates, i.e. it’s “dirty”. How can Excel help you speed up the process?
PROCUREMENT - 03.06.2020
Pricing an outsourcing contract
Your company is in the process of negotiating an outsourcing contract for software development. Given the uncertain economic times, should it be priced on a fixed or cost-plus basis?