Running a business - Banking, finance & insurance

Recently added Tips & Advice

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?
Read more

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?
Read more

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?
Read more

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?
Read more

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?
Read more

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?
Read more
Running a business - Banking, finance & insurance

Most read Tips & Advice

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?
Read more

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?
Read more

SPREADSHEETS - 07.05.2020

A better way to show year on year changes in Excel

The board has asked you to come up with a year on year variance report. One way of doing this is to use formulas, but this will take time to set up and can lead to errors if changes are made to the data table. Is there a better way?
Read more

Cookie policy