How to add a password to Excel sheets
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.
Excel Flash Fill shortcut
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 run spell check in Excel (AutoCorrect)
Learn how to run spell check and how to turn on/off AutoCorrect quickly with Ted Jordan.
How to define names in Excel (tables)
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!
Conditional formatting in Excel: how to change cells colour based on value
Change cells colours based on value and become a spreadsheet pro! Watch our videos and examples to learn how to use conditional formatting in MS Excel.
How to format charts in Excel
Learn how to format charts in Excel for a more professional look: remove gridlines, style your graph title and rename axis labels.
Excel AutoSum shortcut: how to sum a column
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 create shortcuts in Excel
Create shortcut keys in Excel to add rows or a pivot table to your spreadsheet like a pro! Learn how to customise shortcuts and how to create new ones with Ted Jordan.
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.
Unformat tables in Excel
Unformat Excel table easily and design it like a pro within seconds! Convert cell range to a table and vice versa.