How to Merge Two Excel Files?
Accessing data from multiple Excel files can be time-consuming and hard. You often have to switch between multiple open windows, it’s messy and you feel like there’s data all over …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Delete a Pivot Table in Excel?
Pivot tables are great analytical tools that help you sort, organize and summarize data. However, they can hamper the performance of your workbook if overused, or if you have a …
Weighted Average Formula In Excel (Examples)
You might come across some data distributions where different quantities carry different levels of importance (or weightage). A standard average is not really a good representation of such distributions, since …
How to Separate Names in Excel
Performing operations on names like search, sort, filter, etc. is usually easier when full names are separated into separate columns. In fact, separating names is such a frequently performed data …
How to Break Links To External References in Excel?
Often when you inherit Excel files from other people, they can have links to other external Excel files and ranges. Many times, you don’t need to keep these links to …
Compound Interest Formula in Excel
Compound interest is a concept heavily used by the banking and finance industry. If you’re investing or saving money in a bank, Compound Interest is the magical formula that is …
How to Calculate Percentage Difference in Excel (Formulas)
The term ‘percentage difference’ is often misunderstood. A lot of people get mixed up between the terms ‘percentage difference’ and ‘percentage change’. Both are completely different concepts and have completely …
How to Group by Months in Excel Pivot Table?
One of the most important applications of Pivot tables is summarizing your data. You can use Pivot tables to summarize data by a number of factors, including by month, day, …
SPILL Error in Excel – How to Fix?
If you’re using Excel 365 or newer versions, you might have come across the SPILL error. This is a new error code that you will find in addition to the …
Extract Last Name in Excel
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list. For example, we …
Find the Closest Match in Excel (Nearest Value)
There are enough functions in Excel to help you if you need to find an exact match for a value from a list. However, if you’re looking to find the …
Count the Number of Yes in Excel (Using COUNTIF)
Excel is quite commonly used in processing survey data and results. In many cases, these surveys are used to collect user responses as Yes or No. and then as part …