Count Characters in Cell
When dealing with data that is a combination of text, special characters, and numbers, you might run across a situation where
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
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
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
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,
DATE vs. DATEDIF Functions
It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
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
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
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.