Excel: How to split text into columns
If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it’s really easy to split text into columns.
How to convert text to date with Text to Columns in Excel?
Become an expert in MS Excel Spreadsheets by following our various tutorials. Save time and become the new SME for your team.
Join our Excel Qualifying Course now!
How to use the SEARCH function in Excel
How to search for specific data in Excel? Can I see some formula examples? How to find text in specific cells? And what’s the difference between FIND and SEARCH?
No worries, Ted Jordan is here to help!
How to change shapes in Excel column charts
Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.
HLOOKUP vs VLOOKUP: what’s the difference?
What’s the HLOOKUP function syntax? Can HLOOKUP look upward?
Find answers to your questions about the HLOOKUP function in Excel!
How to use the IFNA function in Excel
Discover how to change #N/A errors in Excel! Change the value to a custom value easily.
How to use the VLOOKUP function (with examples)
Do you want to learn how to use the VLOOKUP function in Excel?
Read our “VLOOKUP for dummies” tutorial and watch some examples for specific value, wildcard or using VLOOKUP with two sheets.
How to use the IFERROR function (Excel + Google Sheets)
Discover how to use IF ERROR in Excel or in Google Sheets in 4 easy steps!
No more errors on your documents or dashboards with the IF ERROR function.
