Insert row shortcut: how to create shortcuts in Excel
Create shortcut keys in Excel to add rows or a pivot table to your spreadsheet like a pro! Learn how to customise shortcuts and how to create new ones with Ted Jordan.
How to Custom Sort in Excel
Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort like a pro.
Design and unformat tables in Excel
Unformat Excel table easily and design it like a pro within seconds! Convert cell range to a table and vice versa.
SUMIFS between two dates (Excel)
SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!
How to use SUMIF in Excel?
We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different types of criteria.
COUNT vs COUNTA in Excel: what’s the difference?
Check how many cells contain numbers or data in your Excel table with COUNT and COUNTA functions! If you are wondering how many empty cells are in your table, read our tutorial until the end!
How to freeze a row in Excel
Pin top row and column in Excel in only 2 clicks and learn how to freeze multiple rows in less than 10 seconds!
How to trim spaces in Excel
Remove extra spaces quickly in your spreadsheets with the TRIM function! Watch our videos to learn from examples.
How to find unique values in Excel
Remove duplicate values within seconds using the UNIQUE formula in Excel worksheets. Learn how to use the UNIQUE function in your tables. Save time now!
ISBLANK function in Excel (formula and examples)
How to return a value if a cell is blank in Excel? What is the ISBLANK formula? We got it all covered: check our video! Plenty of examples to learn from in our article, indicating if a cell is empty or not in Excel.
