How to take advantage of the Name box in Microsoft Excel Your email has been sent Scrolling around a large sheet can be tedious, awkward, and occasionally, even fruitless because you simply can’t find ...

Combining or merging the first and last names in an Excel spreadsheet or workbook requires using the CONCAT and Ampersand functions or formulas. You can also use ...

Please note: This item is from our archives and was published in 2022. It is provided for historical reference. The content may be out of date and links may no longer function. Using range names in ...

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character ...

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you. If you regularly work with Excel spreadsheets, you probably find yourself repeating ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.