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
    • Get and Transform your data
  • Products for Sale
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

How to create expiry dates in excel

by admin | Apr 16, 2019 | Excel | General, Training Records Management

    A question I get asked a lot on this website is about how to create expiry dates for different courses in Excel. So here is a video that shows you how to do it. It does require that you have a list of courses with their duration in days e.g. a course...

Tracking recurring meetings in Excel – have you had your one to one meeting this month?

by admin | Nov 1, 2018 | Excel | General, Training Records Management

A while back I was working with a company and one of the issues that came up was how to track if managers had completed their monthly one to one meetings with their staff.  They needed to see who had completed them and who hadn’t. The issue was that while they...

Learning Excel and the plane of all possibilities to know what to ask

by admin | Sep 26, 2018 | Excel | General

This year I attended a conference about John O Donohue , an Irish philosopher/mystic/poet who died in his early 50s. At that conference a friend of his called Dr Dan Siegel talked about how quantum physics and mysticism were now converging and  discovering what they...

Deferred Income – When you haven’t quite got the money in the bank – Part Two

by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General

Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income...

Deferred Income – when you haven’t quite got the money in the bank…Part One

by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General

Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post…:-) There are seven steps in this so I have published...

Training records management – summarizing percentage compliance

by admin | Mar 14, 2018 | Excel | General

So one of the questions that comes up when I am helping customers with this is how do you calculate what percentage of your staff are compliant. In this scenario, I have set up 16 employees who each have to do a Health and Safety and Induction course. Some of them...
« Older Entries

Excel shortcut keys – FREE

Recent Posts

  • Identifying once off, overdue, current and due for renewal training records
  • How to create expiry dates in excel
  • Tracking recurring meetings in Excel – have you had your one to one meeting this month?
  • Learning Excel and the plane of all possibilities to know what to ask
  • Deferred Income – When you haven’t quite got the money in the bank – Part Two

Categories

  • 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

  • Identifying once off, overdue, current and due for renewal training records
  • How to create expiry dates in excel
  • Tracking recurring meetings in Excel – have you had your one to one meeting this month?
  • Learning Excel and the plane of all possibilities to know what to ask
  • Deferred Income – When you haven’t quite got the money in the bank – Part Two

Like Excel Expert on Facebook

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