by admin | Jul 4, 2017 | Excel | Case Studies, Excel | Excel for Small business, Excel | General
A common issue for many organisations is tracking time-in-lieu i.e. someone has a certain number of days/hours holidays(vacations) allocated but they can increase that by doing overtime and then taking time off – “in-lieu”. While some organisations...
by admin | Sep 23, 2014 | Excel | Case Studies, Excel | Excel for Small business, Excel | General
Recently I went in to do some training with a new manager who had been tearing his hair out with his Excel sheet. The spreadsheet had already been set up for him and the previous incumbent had done some interesting array formula variations using If and Sum – and...
by admin | Oct 23, 2012 | Excel | Advanced Lessons, Excel | Excel for Small business
In today’s tutorial we are going to look at how to use the PMT function in Excel to calculate mortgage repayments. In another post, I’m going to show you how to use the PMT function with another Excel feature (called Data Tables) to very quickly generate a...
by admin | Oct 15, 2012 | Excel | Excel for Small business
Jakki Francis is a qualified accountant making her unique amongst bookkeepers. She offers a virtual bookkeeping service for women in business, done well, on time and stress free, whilst supporting you and your business. www.morethanabookkeeper.com One of her...