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

Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos

by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks

I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...

Excel shortcut keys – FREE

Recent Posts

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

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

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

Like Excel Expert on Facebook

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