Cheatsheet – Excel Functions & Keyboard Shortcuts

Sunil Ray 24 May, 2018 • 2 min read

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.

Sunil Ray 24 May 2018

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.

Frequently Asked Questions

Lorem ipsum dolor sit amet, consectetur adipiscing elit,

Responses From Readers

Clear

Sudheer Rao
Sudheer Rao 09 Dec, 2016

This is a gold mine. This will help Excel users significantly. Can't thank you enough !

xia
xia 09 Dec, 2016

Thanks Sunil. This is an awesome cheat sheet. I do not see the link for pdf download, could you please provide one?

Rakesh
Rakesh 09 Dec, 2016

I've logged in but still cannot download :(

Karthik
Karthik 10 Dec, 2016

Where to find the download link,I couldnt find one.

Ramdas
Ramdas 16 Dec, 2016

Thanks for the article, heavily use Excel for Data Analysis/Data Profiling.

Raja
Raja 18 Dec, 2016

Thanks for sharing the worthy information

Bifty Alex
Bifty Alex 11 Apr, 2017

Amazing list of Excel hacks. The shortcuts that you provided here will definitely help our Excel users. Thanks for Posting!

BANWARI LAL
BANWARI LAL 01 Nov, 2017

IT IS A HANDY TOOL PACK WHICH MAKE EXCEL WORK FASTER

Brian Mwangi
Brian Mwangi 01 Mar, 2018

Any good free pdf books for Excel for data analysis?

Hemant Trivedi
Hemant Trivedi 24 May, 2018

Unable to download Cheat Sheet . From where could I download it. Please help