How to create a simple gauge chart in Excel
Create a simple yet original gauge chart in Excel to highlight important metrics such as the number of clients you helped with your expertise.
Data Validation: Inserting drop-down in Excel
Drop-down in Excel: learn how to insert Data Validation, modify drop-down lists and remove them with ease. And discover why Data Validation is greyed out.
Excel AutoSum shortcut: how to sum a column
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 use COUNTIF: greater than
COUNTIF: greater than, less than, not blank; this Excel function is so handy! Learn how to use it in your spreadsheets with Ted Jordan.
How to create shortcuts in Excel
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
Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort like a pro.
Unformat tables in Excel
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 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)
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.