Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

Microsoft Excel dominates the world of spreadsheets and is backed by seriously powerful capabilities in data analysis. With so many features, there's always something new to learn. To get to grips ...

Kelly L. Williams, CPA, Ph.D., explains how to use XLOOKUP, a new function for Excel 365 users that essentially replaces VLOOKUP and HLOOKUP. It is very easy to dissect the contents of a cell in Excel ...

Excel is a powerful tool that can help you manage, analyze, and present data effectively. However, many users only scratch the surface of its capabilities, often relying on manual processes and basic ...

This year, Spreadsheet Day falls on Saturday, Oct. 17, a day in which number crunchers worldwide gather around the formula bar, fill their cells with all sorts of values, and reminisce about the 1979 ...

This Microsoft Excel 2019 Intermediate Quick Reference provides shortcuts, tips, and tricks for the spreadsheet software. Use it to brush up on the basics and to find alternate methods to your ...

Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing ...