It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
The AVERAGE functions in Excel are nice set of functions to get under your tool belt if data analysis is at all part of your
Following up on our post about some of the most commonly used text functions, today we’re going to focus on cleaning up
The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.
Very often in Excel you want to summarize a set of data to pull out insights. The MIN and MAX functions can help you do
In this post I’ll show you a quick excel shortcut for calculating a rate of change. Rate of change is defined as the
While the CONCATENATE and CONCAT functions seem like they might be the same thing, there are small differences between the
Creating a budget in Excel can be a painstaking process. Auditing what you spend on groceries, entertainment, rent,