How to use SUMIF in Excel?
![Sumif Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-5.jpg)
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?
![The different count functions in excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-2.jpg)
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!
Excel: Date to Text (dd/mm/yyyy)
![Date Formatting in Excel with the Text Function](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-8.png)
Convert a date to text in Excel within seconds with our free online Excel tutorial! Discover the handy TEXT function for dates.
How to trim spaces in Excel
![Trim Function Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-5.png)
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
![Unique Function Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-4.png)
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)
![Isblank Function Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-3.png)
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
![Today and Now Functions in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-2.png)
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
![Weeknum function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/11/Weeknum-function-excel.png)
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
![Weeknum function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/11/Weeknum-function-excel.png)
![Weeknum function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/11/Weeknum-function-excel.png)
![Weeknum function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/11/Weeknum-function-excel.png)
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.
Excel: how to capitalise the first letter of each word
![Capitalize the first letter of each work with the Proper function](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/02/Proper-Function.png)
![Capitalize the first letter of each work with the Proper function](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/02/Proper-Function.png)
Bring clarity to your Excel text elements: learn how to capitalise each word with the PROPER function.