How to use dynamic values in text (Excel)
Learn how to use dynamic values in text in your Excel spreadsheets. Mix text and functions within cells easily and present professional tables to your colleagues or customers.
tedjordan
How to use the LEFT, RIGHT and MID functions
Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start in Excel or if you are an expert, this guide is for you!
How to add and use calculated fields in Pivot Tables
Learn how to add, customise and use calculated fields in Excel or Google. Discover how to change fields names or formulas in your Pivot Tables.
5 Google Sheets and Excel shortcuts to know
Excel shortcuts help you become more efficient when you want to select cells, for example. No more scrolling while working in Google Sheets or Excel worksheets!
Plenty of Excel shortcuts work on Google Sheets, so learn how to use them.
How to split text into columns in Excel
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? How to search for *? 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 for dummies – Excel
HLOOKUP and VLOOKUP tutorial for Excel beginners: understand the difference between HLOOKUP vs VLOOKUP, how and when to use these formulas, how to use wilcards… Read our “VLOOKUP for dummies” tutorial now!
How to use the IFNA formula in Excel
Discover how to change #N/A errors in Excel! Change the value to a custom value easily.