Create a report in excel using a pivot table for sales data analysis is an important aspect of any business. Unless you…
How to use Fuzzy Lookup in Excel to Match Names Think: Sometimes, we need to find a match in-between tables. In such…
Comparing values in Excel is something that we all do once in a while. Microsoft Excel offers a number of options to…
Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to…
Degree Symbol Insert / Type in Excel What if you’re working on a Temperature Data? Here, you must learn how to use…
COUNTIF function in excel counts cells meeting a single criterion. It will Count the Empty or the Blank Cells present in the…
A horizontal bar chart may look appealing, but to make it may be troublesome. In this article, we going to learn how…
The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a…
In this blog, learn how to make a scatter plot in excel and you will able to make excel scatter plots at…
How to merge excel files or combine excel files into a single sheet from a different workbook using excel macro is the…
Subtotal Excel formula of excel advanced filter is a definite hit, both for beginners and experienced users who haven’t seen this feature…
In a continuation Excel VBA tutorial series of data manipulation using Macros; Today, we will try to merge excel files in a…
Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one…
Before We learn How to create Hyperlink, let’s Learn what is Hyperlink and where we can use it. What are Hyperlinks? A…
Wrap Text is the most known function of excel. There are times when it is difficult to adjust long texts within an…
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’…
Power Query also allows you to create a list query from a data table available. The column from the given data table…
Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List…
Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily…