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!
What is SUMIF?
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 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!
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!
Workbook statistics (Excel)
Discover a new Excel trick thanks to Ted Jordan: how to get workbook stats quickly.
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 how to use the Excel Exclusive OR function in your spreadsheets: XOR.