In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We walk through simple methods using built-in Excel tools to organize your ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

Have you ever struggled to sort data in Excel in a way that truly fits your needs? Imagine trying to organize a list of regions not alphabetically, but in a specific order like “North, South, East, ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

If you get the You can’t change part of an array error in Microsoft Excel, this post will help you fix the error. An array is essentially a collection of items ...

Throwing a lot of work into a shared Excel sheet can be rewarding, which is why it’s even more soul-crushing to wake up one day to find it destroyed. Unfortunately, whether by accident or malice, ...

We show you how to use the SUM formula in Excel, how to use the AutoSum feature and how simple additions with the plus sign work. Microsoft Excel is the most widely-used spreadsheet program, integral ...

Visual Basic for Applications, or VBA, is a Microsoft programming language that allows users to create scripts to execute certain actions, automate repetitive functions, and create custom forms and ...

On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...