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 […]

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 increase indent in Excel

Indenting in Excel Cells

Discover how to increase indent in Excel and shortcut keys for indentation. Learn how to remove indent quickly to style your spreadsheets in a timely manner.

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.

How to define names in Excel (tables)

Transpose Function in Excel

Discover shortcuts to create Excel tables and rename them; learn how to define selections and name them. Use structured references in Excel formulas to save time!