Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

To merge or combine the first and last names in Excel you can make use of the CONCAT Ampersand, Flash Fill or TEXTJOIN functions or formulas.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

Digital Trends How to name and save a workbook Just like when you use Microsoft Word, it’s crucial to name and save your Excel files right from the start.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.