The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

Tracking time-in-lieu or “how many days holidays have I got left?”

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...

Doing the “total spend this year”, “total spend this month” shuffle using SumIFS

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...

PMT FUNCTION | MORTGAGE REPAYMENT CALCULATOR

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...

EXCEL FOR SMALL BUSINESS | THE VALUE OF GOOD BOOKKEEPING

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...

Excel shortcut keys – FREE

Recent Posts

  • Identify non-attendance from a list of Zoom emails
  • 02 – Excel formulas – adding up numbers and dates
  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management

Like Excel Expert on Facebook

Recent Posts

  • Identify non-attendance from a list of Zoom emails
  • 02 – Excel formulas – adding up numbers and dates
  • Simple Vaccination timetable
  • 01 – Starting Excel from the beginning
  • My 21 for 2021

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved