Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT
Creating a budget in Excel can be a painstaking process. Auditing what you spend on groceries, entertainment, rent,
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.