TedJordan.Org - Logo

How to format graphs in Excel

Learn how to format graphs in Excel for a more professional look: remove gridlines, style your graph title and rename axis labels.

AutoSum shortcut: quick sum of column (Excel)

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).

How to Custom Sort in Excel

Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort like a pro.

How to get rid of DIV/0 error in Excel

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

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

We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different types of criteria.

What is COUNT in Excel and how to use COUNT?

The different count functions in excel

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!