Similar Posts
Introduction to Power Query
Introduction to Power Query Hi Friends, we are starting with a new series of articles on a very important feature of MS Excel. Yes, that is Power Query. It was first introduced with Excel 2010…
Create Dynamic Data Validation List – Offset Function Method
Create Dynamic Data Validation List 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…
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…
How to find duplicates in excel?
How to 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…
EXCEL FUNCTION – WEEKDAY
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
How to Create Pie Chart in Excel (Complete Tutorial)
Pie Chart is one of the ways of visual presentation of your data sets. Sometimes it makes easier to understand the data while visualizing.