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 remove gridlines in Excel

February 14, 2026April 9, 2024 by tedjordan
Remove gridlines in Excel

Make gridlines invisible or change the gridlines colour in your Excel workbook after reading our quick tutorial. Plenty of examples to learn from!

Categories Tools Tags excel, shortcuts, tutorial Leave a comment

What is the IFS function? (Excel)

February 26, 2026April 8, 2024 by tedjordan
IFS function

Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own pace!

Categories Functions Tags formulas, if function, IF vs IFS, ifna Leave a comment

AND function in Excel (with examples)

February 14, 2026April 7, 2024 by tedjordan
AND functions

Learn with ease how to write AND function in Excel by watching our short video and our various examples. Use AND with multiple cells or/and conditions and with text like a pro!

Categories Functions Tags excel tips and tricks, if function, tutorial Leave a comment

Filter data: Excel FILTER formula

February 14, 2026April 6, 2024 by tedjordan
Filter data formula in Excel.

Learn how to filter data with a formula in Microsoft Excel and how to use FILTER with condition. Become more efficient with our Excel tips and tricks.

Categories Functions Tags excel tips and tricks, shortcuts, tutorial Leave a comment

COUNTIFS with multiple criteria (Excel)

February 14, 2026April 5, 2024 by tedjordan
COUNTIF with multiple criteria in Excel

Use COUNTIFS with multiple criteria like a pro and expand your Excel knowledge with Ted Jordan. Learn some tips and tricks to save time and to avoid errors.

Categories Functions Tags count, tutorial Leave a comment

TRUE and FALSE in Excel (with examples)

February 26, 2026April 4, 2024 by tedjordan
True and False functions in Excel.

Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet Master with Ted Jordan!

Categories Functions Tags data, excel, excel function, if function, true, true false Leave a comment

How to increase indent in Excel

February 14, 2026April 3, 2024 by tedjordan
Indent shortcut keys

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.

Categories Shortcut Keys Tags cells, excel, shortcuts, tutorial Leave a comment

CONCAT vs CONCATENATE in Excel

February 14, 2026April 2, 2024 by tedjordan
Concat vs Concatenate

Learn how to combine cells in Excel with Ampersand, CONCAT and CONCATENATE. Choose the way you prefer to impress your employer and customers.

Categories Functions Tags excel tips and tricks, tutorial Leave a comment

How to add a password to Excel sheets

February 14, 2026April 1, 2024 by tedjordan
add password to Excel document

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.

Categories Tools Tags data, excel, excelpivot, shorts, spreadsheet, spreadsheetshort, tool, tutorial Leave a comment

Excel Flash Fill shortcut

February 14, 2026March 31, 2024 by tedjordan
Flash Fill shortcut keys

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.

Categories Shortcut Keys Tags data, excel, shortcuts, shorts, spreadsheet, spreadsheetshort, tutorial Leave a comment
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 … 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