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

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

Calculating exam results : pass, fail, compensation pass

by admin | Apr 6, 2015 | Excel | Advanced Lessons

I recently got a request through LinkedIn from someone I met at a conference who wanted to know how she could do the following.. She wanted to calculate exam results given the following parameters. ” If they do not fail any module but can now have up to a...

Tables and Structural References or how to do a lot less highlighting when creating formulas

by admin | Oct 7, 2013 | Excel | Advanced Lessons, Excel | General

One of the issues I come across frequently in class are people who have to work with large amounts of data. That often means a Lot of scrolling and selecting of lists of data and I have often wondered how I could make this easier for people. I have found an answer...

DATA TABLE | QUICKLY CREATE A LARGE TABLE OF VALUES

by admin | Oct 23, 2012 | Excel | Advanced Lessons, Excel | General

In this blog posting, I’m going to show you how to use a feature in Excel to create a large table of values. The feature is called Data Tables and I’m going to use the PMT function with it to show you how to quickly create a large table of  loan repayment...

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

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