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 ...

We have all been there, perhaps at work, staring at a massive spreadsheet filled with data that needs to be transformed into a meaningful report by the end of the day. You feel overwhelmed and unsure ...

Despite whether you're an Excel power user or just reasonably experienced with spreadsheets, it's worth making sure you've seen some of the new features in the Microsoft Office 2010 ($389 street, 4 ...

The SCAN function is best used when you need a running total—a sum that accumulates row by row, with the accumulated value ...

The second edition (2020) is freely available as an open educational resource. MicroExcel.pdf (8MB) Click to download and open with a pdf reader. The second edition has additional content and updated ...

Whether you've earned a data-related job promotion or recently learned some new Microsoft Excel skills, take the How-To Geek Intermediate Excel Test to put your expertise under the microscope! This is ...

Jazz up your Microsoft Excel workbook by creating conditional statements to visually represent trends within your data. The Conditional Format tool allows you to define conditional statements to ...