TRUE and FALSE in Excel (with examples)
Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet Master with Ted Jordan!
What is SUMIF?
We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different types of criteria.
Excel: Convert Date to Text (dd/mm/yyyy)
Convert a date to text in Excel within seconds with our free online Excel tutorial! Discover the handy TEXT function for dates.
How to trim spaces in Excel
Remove extra spaces quickly in your spreadsheets with the TRIM function! Watch our videos to learn from examples.
XOR (Exclusive OR) function : how to use it in Excel
Learn how to use the Excel Exclusive OR function in your spreadsheets: XOR.
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!