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 writing more about these articles which I am going to publish over the time of period
Here are some best excel resources for 2020 which we recommend. These can make you awesome in Excel and Data Analytics
I really some excel books amazing which are easy for any new user to learn about Excel, Power Pivot, Dashboard making tricks. If you are thinking to learn Excel in real sense, you should read these booksÂ
You may also explore other awesome excel books which can really help you to become awesome data expert. Click here to know more
Here are Top Excel Blogs which you can refer for ultimate learning and new tricks for Advanced Excel, Data Analytics and many more or you may click here to find “Top 50 Excel Blogs for 2019“
We will keep updating this page with more interesting excel resources which you may like and find worthreading.
Have a great day 🙂
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…
Remove Duplicates in Excel Highlight/Select the Column A, similar to shown in below screenshot: Go To “Data” tab on Menu Bar and click on “Remove Duplicates” as shown below: Once you click on “Remove Duplicates”,…
In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data
How to Compare TWO Columns in Excel? Comparing Columns in Microsoft excel is much often feature that is used while managing database. We have many ways to compare the columns in excel and can be…