TedJordan.Org - Logo

Analytics Posts

Did you know you could define names in Excel for tables, worksheets, workbooks… and cells? Naming a table can save you time when entering formulas in Microsoft Excel. Also, it reduces the risk of errors when you work with large tables. In this free tutorial, learn how to rename tables and how to define names […]

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.