Sunil Ray — December 9, 2016
Beginner Business Analytics Cheatsheet Excel

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!

excel-function-infographics-001

Here is the cheatsheet for all shortcuts (on Windows):

excel-shortcuts-001

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.

About the Author

Sunil Ray

I am a Business Analytics and Intelligence professional with deep experience in the Indian Insurance industry. I have worked for various multi-national Insurance companies in last 7 years.

Our Top Authors

Download Analytics Vidhya App for the Latest blog/Article

13 thoughts on "Cheatsheet – Excel Functions & Keyboard Shortcuts"

Sudheer Rao
Sudheer Rao says: December 09, 2016 at 11:32 am
This is a gold mine. This will help Excel users significantly. Can't thank you enough ! Reply
xia
xia says: December 09, 2016 at 4:00 pm
Thanks Sunil. This is an awesome cheat sheet. I do not see the link for pdf download, could you please provide one? Reply
Rakesh
Rakesh says: December 09, 2016 at 10:18 pm
I've logged in but still cannot download :( Reply
Karthik
Karthik says: December 10, 2016 at 5:44 am
Where to find the download link,I couldnt find one. Reply
Swati Kashyap
Swati Kashyap says: December 10, 2016 at 6:33 am
Hi Karthik, The download link has been added. Reply
Swati Kashyap
Swati Kashyap says: December 10, 2016 at 6:33 am
Hi Rakesh, You can download now. Reply
Swati Kashyap
Swati Kashyap says: December 10, 2016 at 6:33 am
Hi Xia, You can download now. Reply
xia
xia says: December 10, 2016 at 8:41 pm
Thank you :-) Reply
Ramdas
Ramdas says: December 16, 2016 at 4:10 pm
Thanks for the article, heavily use Excel for Data Analysis/Data Profiling. Reply
Raja
Raja says: December 18, 2016 at 4:50 pm
Thanks for sharing the worthy information Reply
Bifty Alex
Bifty Alex says: April 11, 2017 at 1:12 pm
Amazing list of Excel hacks. The shortcuts that you provided here will definitely help our Excel users. Thanks for Posting! Reply
BANWARI LAL
BANWARI LAL says: November 01, 2017 at 5:48 pm
IT IS A HANDY TOOL PACK WHICH MAKE EXCEL WORK FASTER Reply
Hemant Trivedi
Hemant Trivedi says: May 24, 2018 at 3:57 pm
Unable to download Cheat Sheet . From where could I download it. Please help Reply

Leave a Reply Your email address will not be published. Required fields are marked *