PROPER function in Excel: capitalise the first letter of each word
Bring clarity to your Excel text elements: learn how to capitalise each word with the PROPER function.
Excel IF statement: how to use it for 3 conditions
Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!
XOR (Exclusive OR) function : how to use it in Excel
Learn how to use the Excel Exclusive OR function in your spreadsheets: XOR.
Excel: how to round numbers to the nearest 5 or 10?
Round up, round down or round off numbers in Excel with these formulas! Many examples are shared so you can learn easily the Excel ROUND functions. Discover how to round decimal numbers now!
How to use dynamic values in text (Excel)
Learn how to use dynamic values in text in your Excel spreadsheets. Mix text and functions within cells easily and present professional tables to your colleagues or customers.
How to use the LEFT, RIGHT and MID functions
Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start in Excel or if you are an expert, this guide is for you!
How to use the SEARCH function in Excel
How to search for specific data in Excel? Can I see some formula examples? How to find text in specific cells? And what’s the difference between FIND and SEARCH?
No worries, Ted Jordan is here to help!
HLOOKUP vs VLOOKUP for dummies: Excel formulas and examples
HLOOKUP and VLOOKUP tutorial for Excel beginners: understand the difference between HLOOKUP vs VLOOKUP, how and when to use these formulas, how to use wilcards… Read our “VLOOKUP for dummies” tutorial now!
How to use the IFNA function in Excel
Discover how to change #N/A errors in Excel! Change the value to a custom value easily.
How to use the IFERROR function (Excel + Google Sheets)
Discover how to use IF ERROR in Excel or in Google Sheets in 4 easy steps!
No more errors on your documents or dashboards with the IF ERROR function.
