While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions are great ...

Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of Windows Vista, Windows Server 2008, Windows 7 and the ...

Learn how to suppress or hide zero values in an Excel sheet using one of these quick and easy methods. If you want to hide or suppress zero values in a spreadsheet, Excel offers three easy ways to get ...

This book is a resource for professors. It explains how the Excel files on this web site can be used in a variety of ways to help students learn. The files are standalone and freely available. They ...