How to Merge Cells in Excel (with Video)
Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to
06
Oct
How to Use the SUMIF Function
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
27
Sep
How to Use CONCATENATE in Microsoft Excel
There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT
01
Sep
Using SUMIFS in Excel to Analyze a Budget
Creating a budget in Excel can be a painstaking process. Auditing what you spend on groceries, entertainment, rent,
23
Jun
DATE vs. DATEDIF Functions
It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
03
May
AVERAGE vs. AVERAGEA vs. AVERAGEIFS
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
30
Apr
How to Clean Large Text Strings (LEN, CHAR, CONCATENATE, and more)
Following up on our post about some of the most commonly used text functions, today we’re going to focus on cleaning up
28
Apr
XLOOKUP vs. INDEX & MATCH
The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.
15
Apr
Min and Max Functions in Excel
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
22
Mar