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 numbers from dates 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: how to 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.
How to get workbook statistics (Excel)
Discover a new Excel trick thanks to Ted Jordan: how to get workbook stats quickly.
Excel: how to capitalise the first letter of each word
Bring clarity to your Excel text elements: learn how to capitalise each word with the PROPER function.
Excel IF statement: how to use it for 3 conditions
Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!
XOR (Exclusive OR) function : how to use it in Excel
Learn what XOR means and how to use the Exclusive OR function in Microsoft Excel.
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.
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!
