Introduction
What is the most commonly used tool in data industry? You might have guessed it because of the title of the article – it is Excel. It is by far the most widely used tool for several reasons. Easy UI / UX for any one to start with, great features for doing simple exploratory and statistical analysis and almost universal availability make it a must have tool in your repository.
However, not many people realize the power of Excel. At times, it is surprising to see people using R / Python for simple financial and business analysis, just because they are not comfortable with Excel. They fail to realize how much power Pivot tables, conditional formating and simple formulas can deliver. Check out this article for some of these tricks: simple yet powerful tricks for analyzing data.
With that in mind, we thought we would share a cheat sheet for excel formulas and shortcuts. Below are the cheat sheets!
Here is the cheatsheet for all shortcuts (on Windows):
You can test your skills and knowledge. Check out Live Competitions and compete with best Data Scientists from all over the world.package in the comments below.
Sunil Ray is Chief Content Officer at Analytics Vidhya, India's largest Analytics community. I am deeply passionate about understanding and explaining concepts from first principles. In my current role, I am responsible for creating top notch content for Analytics Vidhya including its courses, conferences, blogs and Competitions.
I thrive in fast paced environment and love building and scaling products which unleash huge value for customers using data and technology. Over the last 6 years, I have built the content team and created multiple data products at Analytics Vidhya.
Prior to Analytics Vidhya, I have 7+ years of experience working with several insurance companies like Max Life, Max Bupa, Birla Sun Life & Aviva Life Insurance in different data roles.
Industry exposure: Insurance, and EdTech
Major capabilities: Content Development, Product Management, Analytics, Growth Strategy.
This is a gold mine. This will help Excel users significantly. Can't thank you enough !
Thanks Sunil. This is an awesome cheat sheet. I do not see the link for pdf download, could you please provide one?
Hi Xia, You can download now.
I've logged in but still cannot download :(
Hi Rakesh, You can download now.
Where to find the download link,I couldnt find one.
Hi Karthik, The download link has been added.
Thanks for the article, heavily use Excel for Data Analysis/Data Profiling.
Thanks for sharing the worthy information
Amazing list of Excel hacks. The shortcuts that you provided here will definitely help our Excel users. Thanks for Posting!
IT IS A HANDY TOOL PACK WHICH MAKE EXCEL WORK FASTER
Any good free pdf books for Excel for data analysis?
Unable to download Cheat Sheet . From where could I download it. Please help