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
04/05/2022
No Comments
OUR BLOG
20 Alternative Excel methods to VLOOKUP
20 Alternative Excel methods to VLOOKUP. Function VLOOKUP – Find and return related data from the other table. Structured reference: [@CURRENCY] – Lookup
06/11/2020
No Comments
How to break an Excel Password
How to break an Excel Password There are many ways to protect an Excel spreadsheet from viewing and editing. One of them is to
20/10/2020
No Comments
UK Stamp Duty Calculator in Excel
UK Stamp Duty Calculator in Excel (England & NI) Excel spreadsheet calculates the Stamp Duty (SDLT) on your residential property purchase in England or Northern
16/05/2020
No Comments
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
30/04/2020
2 Comments
London Coronavirus Heatmap in Excel
London Coronavirus Heatmap in Excel Check how many confirmed cases in London borough in Excel tracker? Whether we like it or not, for some time
17/03/2020
No Comments
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
20/02/2020
No Comments
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
05/12/2019
No Comments
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
05/11/2019
No Comments
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
31/10/2019
No Comments
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
17/10/2019
No Comments
A Multiplication Table in EXCEL
A Multiplication Table in EXCEL Create a multiplication table in Excel Let me give you some different ways to handle formulas. Firstly, using the so-called
04/08/2019
No Comments