VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only ...

Much like any mad scientist, we want to know how to make humans in Infinite Craft and hopefully, we’ll have better results than Mary Shelley’s Frankenstein. Making humans in Infinite Craft can unlock ...

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 ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

There's a new AI agent on the block for people who spend their waking hours inside spreadsheets. Navigate to Shortcut AI's website, and you'll find a page that looks almost exactly like an empty ...

Stop sparring with your spreadsheets! Here's how AI transformed my Excel and Google Sheet skills and powered up my productivity. From the laptops on your desk to satellites in space and AI that seems ...

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets. Carly Quellman, aka Carly Que, is a multimedia strategist ...

In Excel, you can access Copilot in the top right of the Excel Ribbon. 2 Simply select the icon, and a conversation will open with the assistant as a sidebar. From there, you can ask Copilot anything ...

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, ...

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 ...

This post may contain affiliate links. Read our disclosure policy here. Way back in the day (15 years ago!) I used to have a post on here about how I created a Price Book to keep track of the best ...