Excel Dashboard and Reporting
DATA ANALYSIS TRICKS

Best Excel Resources For 2020

While starting Excelsirji.Com, it is always been critical for me to find the best to amaze the viewer experience. So I spent many hours on web to read, explore amazing excel content which I really found helpful to grow as a perfect data analyst. I started learning new things and …

Read More
Free Tutorial on creating Pivot Tables in Excel
DATA ANALYSIS TRICKS

Pivot Table For Beginners – Part 1

Pivot Tables in excel is backbone of data analysis in excel. If you want to perform various analysis in excel, then I would suggest, learn this amazing excel feature to complete your analysis with in few minutes Common Queries For Pivot Tables What is it Why to use it How …

Read More
Pareto Chart Sample
DATA ANALYSIS TRICKS
1

Create Pareto Chart In Excel

What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of the causes. It will significantly improves the affected area and you will see good results.  …

Read More
Excel VLOOKUP
DATA ANALYSIS TRICKS
1

What is VLOOKUP in Excel?

An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.

Read More
Find Duplicate
DATA ANALYSIS TRICKS

Find Duplicates in Excel

Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and Remove duplicates. So you may watch my detailed video on “Complete Guide for Handling Duplicates” Here I will be explaining one …

Read More
DATA ANALYSIS TRICKS

Create Dynamic Data Validation List – Offset Function Method

When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all blank cells and keep adding and deleting the values from drop down dynamically. Here we want to talk …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn