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

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!

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