Skip to content
Structured Analytic
Excel Mastery Online Course SQL Essentials Course Advanced Spreadsheet & Data Visualisation Course
Subscribe
  • Functions
  • Tools
  • Shortcut Keys
  • SQL
  • Functions
  • Tools
  • Shortcut Keys
  • SQL

tedjordan

How to run spell check in Excel (AutoCorrect)

February 14, 2026March 30, 2024 by tedjordan
Autocorrect quickly

Learn how to run spell check and how to turn on/off AutoCorrect quickly with Ted Jordan.

Categories Tools Tags excel, excel tips and tricks, excelpivot, shorts, spreadsheet, spreadsheetshort, tutorial Leave a comment

How to share an Excel file for editing

February 14, 2026March 29, 2024 by tedjordan
Share your Excel file: PDF, email, cloud…

Share Excel workbooks via mail or links, save them as PDF and work together with your colleagues on the same file. You will be able to do it all after reading our tutorial!

Categories Tools Tags excel tips and tricks, spreadsheet Leave a comment

How to create a sales forecast chart in Excel

February 14, 2026March 28, 2024 by tedjordan
Sales forecast graph in Excel.

Showcase actual vs targets in an Excel chart by following these quick and easy steps! Combine data to highlight your success.

Categories Tools Tags tutorial Leave a comment

Scroll to top button in Excel: how to add one?

February 14, 2026March 27, 2024 by tedjordan
Scroll to the top in Excel.

Add a scroll to top button in Excel to impress your customers and use shortcuts to go back to the first cell of your worksheet. Learn Excel tips and trick with Ted Jordan!

Categories Tools Tags excel, excel tips and tricks, excelpivot, shortcuts, spreadsheet, tutorial Leave a comment

How to define names in Excel (tables)

February 14, 2026March 26, 2024 by tedjordan

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!

Categories Tools Tags excel, excelpivot, formulas, shortcuts, shorts, spreadsheet, spreadsheetshort, tutorial Leave a comment

Conditional formatting in Excel: how to change cells colour based on value

February 14, 2026March 25, 2024 by tedjordan

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.

Categories Tools Tags cells, excel, excelspreadsheet, if function, shorts Leave a comment

TRANSPOSE: how to rotate data in Excel

February 14, 2026March 25, 2024 by tedjordan
Transpose function in Excel.

What’s the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how now!

Categories Functions Tags copy paste, data, excel, formulas, spreadsheets, Spreadsheetshorts, tutorial Leave a comment

How to format charts in Excel

February 14, 2026March 23, 2024 by tedjordan

Learn how to format charts in Excel for a more professional look: remove gridlines, style your graph title and rename axis labels.

Categories Tools Tags excel, excel tips and tricks, excelpivot, shorts, spreadsheet, spreadsheetshort, tutorial Leave a comment

How to create a simple gauge chart in Excel

February 14, 2026March 22, 2024 by tedjordan

Create a simple yet original gauge chart in Excel to highlight important metrics such as the number of clients you helped with your expertise.

Categories Tools Tags tutorial Leave a comment

Data Validation: Inserting drop-down in Excel

February 14, 2026March 21, 2024 by tedjordan

Drop-down in Excel: learn how to insert Data Validation, modify drop-down lists and remove them with ease. And discover why Data Validation is greyed out.

Categories Tools Tags data, tutorial Leave a comment
Older posts
Newer posts
← Previous Page1 … Page3 Page4 Page5 … Page9 Next →

Recent Posts

  • SQL Dialects – Understanding the Variations Across Platforms
  • SQL Best Practices – Writing Clean, Secure, and Efficient Queries
  • Troubleshooting Common SQL Errors – Debugging Tips and Tricks
  • Working with Stored Procedures, Functions, and Triggers in SQL
  • Understanding SQL Transactions – COMMIT, ROLLBACK, and ACID Properties

Recent Comments

No comments to show.

About

  • About Us
  • Contact
  • Advertising / Sponsored Content
  • Newsletter

Resources

  • Glossary
  • For Advertisers
  • Media Kit
  • Jobs / Work With Us

© 2026 Structured Analytic. All rights reserved. Terms of Use · Privacy Policy

About

  • About Us
  • Contact
  • Advertising / Sponsored Content
  • Newsletter

Resources

  • Glossary
  • For Advertisers
  • Media Kit
  • Jobs / Work With Us

© 2026 Structured Analytic. All rights reserved. Terms of Use · Privacy Policy