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 remove gridlines 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!
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.
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.
How to add a password to Excel sheets
![Protecting Excel Sheets with a Password](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-28.png)
Add passwords to Excel workbooks and control who can open and edit your data. Learn how to create a password on Excel and how to unprotect Excel sheets.
Flash Fill in Excel: shortcut and use
![Flash Fills in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-27.png)
You don’t know how to use Flash Fill in Excel? No worries, Ted Jordan is here to teach you how to become an Excel Wizard! Learn what is the Flash Fill shortcut and save time filling your data automatically.