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

IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type

by admin | Feb 1, 2021 | Excel | Case Studies

In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how...

Identify non-attendance from a list of Zoom emails

by admin | Jan 25, 2021 | Excel | Case Studies

Recently in a class I had someone who had to track attendance over a number of days training via a bunch of Zoom Emails. This link shows you how you would extract a list of attendee email addresses from your Zoom list. The key is really to get your data in good shape....

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

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...
« Older Entries

Excel shortcut keys – FREE

Recent Posts

  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
  • 06 – How to create a chart with a max/min/target line
  • Exclude text from your conditional formatting for numbers
  • How to create a training roster in Excel .
  • IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type

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
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
  • 06 – How to create a chart with a max/min/target line
  • Exclude text from your conditional formatting for numbers
  • How to create a training roster in Excel .
  • IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type

Like Excel Expert on Facebook

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