How to split semicolon separated values in Excel
![Split Semicolon Separated Value in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-41-1.png)
Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!
How to save and reuse custom theme in Excel
![Custom Theme](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-40.png)
Save and reuse custom theme in Excel with ease by following our quick tutorial.
How to make gridlines invisible in Excel
![How to make gridlines invisible in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/04/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-42.png)
Make gridlines invisible or change the gridlines colour in your Excel workbook after reading our quick tutorial. Plenty of examples to learn from!
IF or IF or IF in Excel: use IFS instead!
![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 AND function in Excel (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!
How to increase indent in Excel
![Indenting in Excel Cells](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-30.png)
Discover how to increase indent in Excel and shortcut keys for indentation. Learn how to remove indent quickly to style your spreadsheets in a timely manner.
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.