The complete Excel crash course for data analysis
A no-nonsense primer on everything you need to become a star Analyst, taught by an ex-BCG consultant and ex-Amazon PM
Lectures -40
Resources -1
Duration -1.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Do you want to become known as the 'Superstar Analyst' on your team? Want to deliver rapid analysis and insights, but unsure where to start with the various formulas? Still, slowly clicking around in messy Excel workbooks?
Excel mastery is an upfront investment that will save you thousands of hours throughout your career. This was one of the best personal investments I ever made which was further honed as a BCG consultant and Amazon PM. I would like to pass my best learnings on.
Consultants, Business Analysts, Data Analysts, and Business Intelligence Engineers pride themselves on rapidly delivering beautiful, dynamic, and structured analysis. If you work in this field, mastering Excel is essential.
After this crash course, you will know exactly how to do that. We will walk through examples of all the important formulas a superstar analyst needs to know, and the little-known shortcuts to do it faster than anyone else.
By the end of this course, you will:
Master all the important formulas in Excel that matter, without getting overwhelmed by less important details
Know the best practices used by top analysis in consulting and Amazon
Understand when and how to use each formula - you will shine in delivering workbooks that are beautiful and insightful, not just correct
Who this course is for:
- This is a fast-paced, intermediate to advanced course. It is not recommended for those completely new to Excel
Goals
Navigate quickly around Excel (without using a mouse)
Clean data in preparation for data analysis
Use dynamic formulas to conduct detailed data analysis
Use beautiful and best-in-class formatting
Structure your workbook to be clear and auditable
Prerequisites
You should have a basic understanding of Excel or more to fully benefit from this course
![The complete Excel crash course for data analysis The complete Excel crash course for data analysis](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13646/course_13646_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
How to use this course 02:59 02:59
How to navigate quickly in Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to clean data in preparation for analysis
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to analyze data
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to format your output
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Best practices for structuring your workbook
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Lucas Lin](https://www.tutorialspoint.com/assets/profiles/576335/profile/200_272524-1692609877.jpg)
Lucas Lin
I have extensive experience at BCG and Strategy& providing case coaching for a large number of pre-final round candidates. I've also worked at Amazon and in product management, as well as received offers for companies like Instagram and Tencent.
I focus on using real cases and providing actionable feedback (e.g. structured thinking, creative insights, top-down communication).
My 1-on-1 clients have enjoyed very high hit rates and received offers from top firms including McKinsey, BCG, Bain, Oliver Wyman, and Strategy&.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)