IF or IF or IF in Excel: use IFS instead!
Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own pace!
How to write AND function in Excel (with examples)
Learn with ease how to write AND function in Excel by watching our short video and our various examples. Use AND with multiple cells or/and conditions and with text like a pro!
Filter data with a formula: Excel FILTER
Learn how to filter data with a formula in Microsoft Excel and how to use FILTER with condition. Become more efficient with our Excel tips and tricks.
COUNTIFS with multiple criteria: how to use it
Use COUNTIFS with multiple criteria like a pro and expand your Excel knowledge with Ted Jordan. Learn some tips and tricks to save time and to avoid errors.
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!
Combine cells: CONCAT and CONCATENATE in Excel
Learn how to concatenate two columns in Excel with Ampersand, CONCAT and CONCATENATE. Choose the way you prefer to impress your employer and customers.
Excel TRANSPOSE formula: how to rotate columns to rows
What’s the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how now!
How to use COUNTIF: greater than
COUNTIF: greater than, less than, not blank; this Excel function is so handy! Learn how to use it in your spreadsheets with Ted Jordan.
How to get rid of DIV/0 error in Excel
Learn how to remove DIV/0 in Excel: get rid of DIV/0 or replace the error message with text. You could also change cells colour when the divide by zero error message is created by the system.
SUMIFS between two dates (Excel)
SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!
