Copy paste values like a pro! (Excel + Google Sheets)
Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now by reading our article.
How to move between cells when arrow keys are not working (Excel)
Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!
Quick way to insert a slicer in Excel
Discover a simple method to add slicers in Excel to your tables. Watch our short video or read our tutorial to save time and increase your spreadsheets knowledge.
How to stretch columns and rows in Excel (2 steps)
Learn how to stretch, readjust or enlarge columns and rows in your MS Excel worksheet!
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.
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 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.
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.
How to use IFERROR (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.