Excel: how to round numbers to the nearest 5 or 10?
Round up, round down or round off numbers in Excel with these formulas! Many examples are shared so you can learn easily the Excel ROUND functions. Discover how to round decimal numbers now!
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 resize 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 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 keyboard shortcuts to use in Excel and Google Sheets (+ 1 Bonus)
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.
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!
