Learn everything about Analytics

Cheatsheet – Excel Functions & Keyboard Shortcuts

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.

You can also read this article on Analytics Vidhya's Android APP Get it on Google Play
This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved

13 Comments

%d bloggers like this:
Join 150000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!
%d bloggers like this:
Join 150000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!