OUR BLOG

101 Excel Macros Add-Ins

101 Excel Macros. TRILOGY – 3 Excel Add-Ins (.xlam) How to activate an Excel Add-In? Download Free 1st  Add-In  Macros – Sheets Save file on

Read More »

EURO2020 Excel Sweepstake

EURO2020 Excel Sweepstake Due to the coronavirus pandemic, European Football Championship Euro2020 is postponed till the next year. However, I have prepared a spreadsheet for

Read More »

The most accurate Pie Chart

The most accurate Pie Chart Don’t you feel you need a proper pie chart in Excel? Unfortunately it’s not available yet. However, don’t despair! I’ve

Read More »

Excel Named Range

Excel Named Range Defining names in Excel involves giving a range of cells a unique name, which means that you can easily refer to a

Read More »

Excel Pace Calculator

Excel Pace Calculator The Excel Runner Pace Calculator, is available for download at the bottom of the article or in the Downloads tab and it

Read More »

IFS vs nested IF

IFS vs. nested IF Excel IF Statement Syntax of Excel IF Statement:​ = IF ( Logical Test , Value if True , Value if False

Read More »

XLOOKUP vs VLOOKUP

XLOOKUP vs VLOOKUP Forget about the VLOOKUP function. The new XLOOKUP function has arrived, being a genuine alternative for VLOOKUP, HLOOKUP, INDEX and MATCH. If

Read More »