Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...

Luc Haasbroek is a writer and videographer from Durban, South Africa. He has been writing professionally about pop culture for eight years. Luc's areas of interest are broad: he's just as passionate ...

tcapy is a Python library for doing transaction cost analysis (TCA), essentially finding the cost of your trading activity. Across the industry many financial firms and corporates trading within ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

Charted zero values can have unintended results you can easily miss. Here are a few techniques you can use to hide and manage zeros in your workbook to keep that from happening. A drop to zero in a ...

Microsoft Excel runs events using Visual Basic for Applications, or VBA, a programming language for writing macros. Events often run in response to direct user input, such as when a user fills a form ...

Stephanie Weber is a writer and comedian who has bylines in Reductress, The AV Club, Mental Floss, Slate, Mr. Skin, and more. She has an MFA in dramatic writing from SCAD. She wrote and directed the ...

remove-circle Internet Archive's in-browser bookreader "theater" requires JavaScript to be enabled. It appears your browser does not have it turned on. Please see ...