TedJordan.Org - Logo

Analytics Posts 2

Do you want to upgrade your Excel worksheet to the next level? Use dynamic values in Excel text box to give a professional look to your spreadsheet. What is a dynamic value in Excel? A dynamic value corresponds to the result of a calculation made within a specific range. If the content within the specific […]

TRUE and FALSE in Excel (with examples)

TRUE and False in Excel

Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet Master with Ted Jordan!

How to add a password to Excel sheets

Protecting Excel Sheets with a Password

Add passwords to Excel workbooks and control who can open and edit your data. Learn how to create a password on Excel and how to unprotect Excel sheets.

Flash Fill in Excel: shortcut and use

Flash Fills in Excel

You don’t know how to use Flash Fill in Excel? No worries, Ted Jordan is here to teach you how to become an Excel Wizard! Learn what is the Flash Fill shortcut and save time filling your data automatically.

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.

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.