Tips, Tricks & Hacks

MS Excel, MS Word, MS Powerpoint, Public Speaking, Health, etc...

Monday, November, 29th 2021

  • William Arthur Ward

    "Feeling gratitude and not expressing it is like wrapping a present and not giving it."

Important: Website content on this page is populated through RSS feeds which can be extremely temperamental. Please know some content may not always be available. If continued problems exist please send me an email.

Note: If you would like to see an additional news source or news category please submit your suggestion here.

Excel & Word Tips...

    Redditt – Excel Help

    • What is an array formula?

      IntroductionWhat is an array formula anyway?In simple terms, an array formula is a formula that works with an array of values, rather than a […]

    • Excel's RACON functions

      There are eight functions in Excel that work differently than you might realize. I call these "range-based conditional functions" or RACON […]

    • Download Coronavirus data to Excel

      This page provides examples of public Coronavirus data you can download to Excel with Power Query. Each example has a link, a screenshot to show […]

    • Tracking COVID-19 with Excel

      Above: Tracking public COVID-19 testing data in Excel with Power QueryAuthor  Dave Bruns

    • Alternatives to Dynamic Array Functions

      Dynamic Arrays are one of the biggest changes ever to Excel's formula engine. With 6 brand new functions that directly leverage dynamic arrays, […]

    • SEQUENCE Function in Excel

      In this tutorial, we will introduce you to the fabulous SEQUENCE function in Excel along with two ‘real world’ examples of its use. The […]

    • Sort by Drop Down List in Excel

      In this tutorial, we see how to sort by drop down list in Excel. We have a table containing details about pizza and their performance such as […]

    • Advanced SUM Function Examples – The Power of SUM

      This tutorial shows some advanced SUM function examples. The SUM function is far more powerful than many people realise, and this tutorial will […]

    • Display Negative Time in Excel

      Excel does not display negative time. So if you are working with negative times, there is a problem. Fortunately, there are ways to work around […]

    • Lookup Multiple Values in Excel

      In this tutorial, we will use Excel formulas to lookup multiple values and combine the results into a single cell, or row. We will also order […]

    • Macros with 32-bit API Calls

      I have a fairly slow running macro (~20 seconds) that works fine on one computer, but never finishes on another. If finally decided to figure […]

    • Name Manager updated

      Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features: – Edit the name’s […]

    • RefTreeAnalyser: Two updates

      Hi There, It’s been a while since I last posted here. Today I have released an update of my RefTreeAnalyser utility. The tool now allows you […]

    • Opening a File from a Userform Disables Ribbon

      In Excel 2019 16.0.10361.20002 32-bit, when I open a file from a userform (which for me is always), the hotkeys on the Ribbon don’t work. […]

    • Excel Virtually Global Tue 21 July to Thu 23 July 2020 Microsoft’s Most Valuable Professionals, or MVPs, are technology experts who […]

    • Excel VBA Masterclass

      Hi there. Hope you and yours are well in these difficult times! This is just a very short announcement that I’ll be doing an on-line version […]

    Powerpoint & Public Speaking Tips...

    Jazz Factory

    Personal Development Tips...

      Additional Resources...

      Health & Fitness Tips...

          Quote of the Day

          more Quotes