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

Workbook statistics (Excel)

January 26, 2026February 11, 2024 by tedjordan

Discover a new Excel trick thanks to Ted Jordan: how to get workbook stats quickly.

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

Excel: how to add a line break inside a cell

February 14, 2026February 9, 2024 by tedjordan
Line break shortcut: option + enter

Discover how to write multiple lines in one cell in Excel with Ted Jordan!

Categories Shortcut Keys Tags excel tips and tricks, shortcuts Leave a comment

How to capitalise each word in Excel

January 14, 2026February 8, 2024 by tedjordan
Proper function in Excel.

Bring clarity to your Excel text elements: learn how to capitalise each word with the PROPER function.

Categories Functions Tags tutorial Leave a comment

Excel IF statement: how to use it for 3 conditions

January 14, 2026February 7, 2024 by tedjordan
IF statement in Excel.

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Categories Functions Tags data, excel, shorts, spreadsheet, spreadsheets, tip, tutorial Leave a comment

XOR (Exclusive OR) function : how to use it in Excel

January 14, 2026February 6, 2024 by tedjordan
XOR function in Excel

Learn how to use the Excel Exclusive OR function in your spreadsheets: XOR.

Categories Functions Tags data, excel, excel function, NAME, shorts, spreadsheet, tip, tutorial Leave a comment

Copy paste values like a pro! (Excel + Google Sheets)

January 11, 2026February 5, 2024 by tedjordan
Copy paste values and shortcut keys

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now by reading our article.

Categories Shortcut Keys Tags copy paste, data, excel, shortcuts, shorts, spreadsheets, tip, tutorial Leave a comment

Excel: how to round numbers to the nearest 5 or 10?

January 14, 2026November 24, 2023 by tedjordan
MROUND function in Excel

Round up, round down or round off numbers in Excel with these formulas! Many examples are shared so you can learn easily the Excel ROUND functions. Discover how to round decimal numbers now!

Categories Functions Leave a comment

How to move between cells when arrow keys are not working (Excel)

January 11, 2026November 19, 2023 by tedjordan
Move between cells with keyboard.

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Categories Shortcut Keys Tags arrow keys, cells, excel, shorts, tutorial Leave a comment

Quick way to insert a slicer in Excel

January 26, 2026November 17, 2023 by tedjordan

Discover a simple method to add slicers in Excel to your tables. Watch our short video or read our tutorial to save time and increase your spreadsheets knowledge.

Categories Tools Tags data, excel, pivot table, shorts, slicer, spreadsheets, tip Leave a comment

How to stretch columns and rows in Excel (2 steps)

January 27, 2026November 16, 2023 by tedjordan

Learn how to stretch, readjust or enlarge columns and rows in your MS Excel worksheet!

Categories Tools Tags columns, data, excel, rows, shorts, spreadsheets, tutorial Leave a comment
Older posts
Newer posts
← Previous Page1 … Page6 Page7 Page8 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