Free Webinar Recording – Excel Formula and Function Tips

Feedback score 95.8% based on 66 responses

In October 2019 I re-ran my Excel Formula and Function Tips session.

The detailed pdf manual and example file can be downloaded by using the button below. Content listed below the video.

Download Materials

CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.

This session covers lots of tips, tricks and techniques to speed up the formula creation process. You will learn:

  • how to quickly start a formula
  • the benefits of the numeric keypad
  • to use AutoComplete to save typing
  • how to easily insert $ signs to fix references
  • about the calculation sequence
  • how to use the colours Excel displays when editing formulas
  • the tricks on selecting large ranges
  • using formulas and Format as Table together
  • a helpful technique when working with ranges in other sheets

 

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

4 thoughts on “Free Webinar Recording – Excel Formula and Function Tips

  1. Hi Neale,
    You mention about copy down shortcut of CTRL D not saving time as you can double click with the mouse and it will fill down. Whilst true generally, in the circumstance when there is not data or the data in the column to the left does not go as far down as you want your copy down to go, I find that using CTRL D works very well and saves time.

    Thanks
    Anthony

    • Hi Anthony
      Ctrl + D is quicker than Ctrl + C and Ctrl + V but the fill handle is pretty quick too.
      In general the time it takes for you to select the range with the mouse before using Ctrl+D could have been used to drag the fill handle down manually and achieve the copy without the shortcut.
      You can maybe use SHIFT + PageDown to select the range quickly and be slightly quicker than dragging the fill handle – depends on how large the range is.
      Regards
      Neale

  2. Hi Neale

    This is really helpful and understand that sumifs is used when there are multiple criteria.

    In the formulae,I’m not understanding why it refers to the date columns several times.

    Thank you

    Shirley

    • Hi Shirley

      If the date range is being examined more than once it means you are applying more than one criteria to the date range.

      In this case greater than or equal to a specific date and less than or equal to another date.

      Hope that helps.

      Regards
      Neale