How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it…
Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how…
To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI….
How to remove blank cells in Excel? confused? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes,…
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel…
Sorting data in alphabetical order is helpful when you have large amounts of data in a Pivot Table. Sorting lets you organize…
In this blog, we will Import data from SQL to Excel spreadsheets using VBA. Assuming that you have a little bit of…
Create sales dashboard in excel using VBA Codes
4 Mins read
You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used…
How to add Error Bars in Excel: Standard Deviation? Imagine that if all data was perfect, absolute and complete. Although actually, it…