How to format graphs in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-18-1.png)
Learn how to format graphs in Excel for a more professional look: remove gridlines, style your graph title and rename axis labels.
Excel AutoSum shortcut: how to sum a column
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-15.png)
The AutoSum shortcut or how to save time to calculate sum of columns or rows in Excel. Learn how to use AutoSum in MS Excel with our various examples (with short videos and with images).
Insert row shortcut: how to create shortcuts in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-12.png)
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
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-10.png)
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
![Design and Unformat Tables in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-8.jpg)
Unformat Excel table easily and design it like a pro within seconds! Convert cell range to a table and vice versa.
How to get rid of DIV/0 error in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/If-Error-Function.jpg)
Learn how to remove DIV/0 in Excel: get rid of DIV/0 or replace the error message with text. You could also change cells colour when the divide by zero error message is created by the system.
SUMIFS between two dates (Excel)
![SumIF Function for Dates in Excek](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-6.jpg)
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?
![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.
Cell absolute reference: what’s the Excel dollar sign shortcut?
![Absolute Referencing in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2023/12/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-4.jpg)
The Excel absolute reference shortcut will become one of your favourites to save time! Switch from relative to absolute references in seconds using this trick.
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!