Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.

The SUMIFS function works in a similar way with text as with numbers, but there are two key differences. First, text in Excel ...

So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split ...

There are several methods to unhide all rows in Excel if you forgot about them or mistakenly hidden them. First, make sure to disable sorting or allow the sorting to select all rows. At the same time, ...

If you often scroll through long Excel sheets, learning how to freeze the top 2 rows will make navigation far smoother. Excel’s Freeze Panes feature lets you lock multiple rows, columns, or both, so ...

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using ...

Ben Richardson is the director of Acuity Training, one of the UK’s leading providers of classroom-based Excel training. Microsoft Excel allows you to clean and explore data, as well as add advanced ...

I am currently working on a book about the use of AI in academic research, and every now and then, I like to share bits and pieces from that work here on Educators Technology. This post is one of ...

Columns can be hidden in Excel to streamline the spreadsheet's appearance and protect sensitive information, keeping the data intact but out of sight. Look for gaps or double lines between column ...

Ever since OpenAI launched ChatGPT, things have changed dramatically in the tech landscape. The large language model (LLM) by OpenAI is powerful enough that it can do multiple things, including ...

Have you ever found yourself wrestling with Excel, trying to keep your total rows accurate as your data grows or shrinks? It’s a common frustration—manually updating totals every time something ...