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

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.

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!

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.