What is the IFS function? (Excel)
![IF vs IFS Functions in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-38.png)
Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own pace!
How to write the Excel AND function (with examples)
![AND Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-35.png)
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
![Filtering Data with a Formula in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-34.png)
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
![Countifs with Multiple Criteria](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-33.png)
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)
![TRUE and False in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-31.png)
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
![Concatenate Functions Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-29.png)
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
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
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
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-14.png)
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
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/If-Error-Function.jpg)
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)
![SumIF Function for Dates in Excek](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-6.jpg)
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!