How to freeze multiple rows and columns 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!
tedjordan
Excel: Convert Date to Text (dd/mm/yyyy)
Convert a date to text in Excel within seconds with our free online Excel tutorial! Discover the handy TEXT function for dates.
How to create a checklist in Excel
How to add a checkbox in Excel? How to tick a box? And where is the developer table? We answer it all in this article!
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 return 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.
TODAY and NOW formulas in Excel
Calculate the number of remaining days before a date in Excel easily with TODAY and NOW functions. Learn how to check when a worksheet was last refreshed or set deadlines automatically with these formulas.
How to get week number in Excel
Find any week number from a date value in Excel using WEEKNUM, DATE and ISOWEEKNUM functions. In business settings, we typically count in weeks so these handy formulas are a must for any analyst!
Excel: convert a date to day of the week
Do you want to know what day was a specific date? Or maybe you want to know what day will be the next bank holidays? Discover 2 great functions to use in Excel to do so! For past or future dates, they are the formulas to know to save time.
Redo or undo an action on Mac
Undo, redo, repeat: what are the shortcuts? Add a new skill by checking our quick tutorial regarding these actions. Command Z and Command Y will become your new favourite shortcuts!