Category Archives: business

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 Ireland in 2020-21

UK Stamp Duty Calculator in Excel

It is extremely easy to use and you can save the file on your computer or any drive:

  1. Select Property:
    • Single property
    • Additional property or a Buy to Let

2. Property Price:

  • Enter a value of property.

Stamp duty automatically appears in the green box along with the effective tax rate below.

Stamp duty holiday.

The government has temporarily increased the stamp duty threshold to £500,000 for property sales in England and Northern Ireland, until 31 March 2021.

Download free New UK Stamp Duty Calculator 2020-21 by clicking button below:

Download Free

You can learn similar tips and tricks in Excel at a comprehensive Training in London.



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 you know how to use the XLOOKUP function, you will never bother to use VLOOKUP anymore. The new feature, which has been recently introduced, has more options and is characterised by its flexibility, efficiency and user-friendliness.


=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [If_not_Found], [Match_Mode], [Search_Mode])​​

1. Lookup_Value
2. Lookup_Array
3. Return_Array
4. [If_not_Found] – #N/A
5. [Match_Mode] – default FALSE – Exact match

6. [Search_Mode] – default TRUE – First to last

Benefits of XLOOKUP over VLOOKUP:

✅ the searched result in the column may be placed to the left of the column with the searched value;

✅ change of the structure of the table with data by inserting or removing columns will not affect the result;

✅ we select only relevant ranges and not necessarily the entire table;

✅ it can return a range, not just a value;

✅ it can return a value, if not found;

✅ the exact search is set to 0 by default in argument 4, the most commonly used option;

✅ it can return the nearest higher value if we declare (1) in the 4th argument;

✅ should we look for the closest value in the 4th argument we do not need to have any data sorted;

✅ wildcard support only if you declare (2) in the 4th argument;

✅ it can search for the last value (-1) in argument 5;

✅ it carries out binary search;

✅ it performs searches not only vertically, but also horizontally if we mark the ranges accordingly;

✅ faster functionality.

You can learn similar issues and tricks at my comprehensive Excel Training in London.

UK Salary Calculator Template Spreadsheet

UK Salary Calculator

UK Salary Calculator
In the United Kingdom on April 6, each year is the start of the new fiscal year. Therefore, for employees in the UK, I have prepared UK Salary Calculator spreadsheet. Based on the annual gross salary and works out each of its components: Personal Allowance, Taxable Income, Income Tax, National Insurance Contributions and Net Salary called Take Home Pay. In addition, I have calculated the equivalent information for different periods such as year, month, week and day. In the last option, we can define the number of hours in a day. Apart from the gross amount, and the amount of working daily hours, the spreadsheet includes the option of choosing the Tax Years from 2009-10 to 2019-20.

UK Salary calculator has been prepared for taxpayers born after 6th April 1948, who are not entitled to any special incentives, tax exemptions or special tax-free amount. This calculator calculates the mean values due to the different periods, but the actual net pay wage that the taxpayer will receive may differ from the calculations. This may be due, inter alia, to the fact that for various reasons the taxpayer receives an irregular salary in a tax year or receives remuneration from more than one source.

FREE spreadsheet download

Please feel free to download UK Salary Calculator 2019-20 template spreadsheet. It does not require any additional software or any registration. It is also free of adverts and VBA code. Just click on the button below to download the file.

Download Free

If you are interested in special access to advanced functions and methods used in this spreadsheet, including full access to Excel Spreadsheets Salary Calculator 2021-22, use Buy Now, button below.

  • Excel Spreadsheet Salary Calculator inc. 2021-22 NEW!
    • UK, Wales & NI
    • Scotland
  • Passwords to all spreadsheets published on Downloads