Introduction to Microsoft Excel
Microsoft Excel is the #1 productivity software in the world. A huge amount of data comes in a spreadsheet format, so an analyst needs Excel in their arsenal. This course will teach you all the Excel skills you need to perform multi-layered calculations, create charts, manipulate data, look up functions, and more!
4 hours 
27 exercises 
1 assignments 
236 downloadables
Sign up to
preview the program
for FREE!
Create a free account and start learning data science today.
create free account
Our graduates work at exciting places:
Section 1
Welcome! Course Introduction
This section is fundamental for those of you who have never used Excel. We will start from the very basics: introducing the Excel ribbon, learning how to insert (and delete) rows and columns, how to perform data entry tasks, and how to format worksheets professionally. In addition, you will create your first formulas and functions, and cut, copy, and paste values for the first time.
Section 2
Useful Tools & Tips
Once you are familiar with the basic operations in Excel, it will be time to learn Excel best practices and learn how to navigate spreadsheets professionally. In this section, you will learn how to apply fast scrolling, use keyboard shortcuts, format sheets professionally, fix cell references, use named ranges, apply custom cell formats, and much more.
Excel tips and tricks
Conditional Formatting
Section 3
Beginner, Intermediate & Advanced Functions
Excel is one of the most popular productivity tools the business world has ever seen. The main reason for this is Excel functions. Here, you will learn how to use Excel functions like a true professional. We will start with some easier examples (SUM, COUNT, AVERAGE, IF, MAX, MIN, VLOOKUP, HLOOKUP), and gradually introduce more advanced (and more powerful) functions such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, INDEX, MATCH, INDEX & MATCH, etc.
Key Excel Functions: If
Enlarge the formula bar
Key Excel Functions: Sum, Sumif, Sumifs
Key Excel Functions: Count, Counta, Countif, Countifs
Key Excel Functions: Average & Averageif
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
Working with text in Excel
Find the Highest and Lowest Values in a Range: Max & Min
=' and '+' are interchangeable when you start typing a formula
Use Round in Your Financial Models
Excel's Lookup Functions: Vlookup & Hlookup Made Easy
Index, Match, and Their Combination - The Perfect Substitute for Vlookup
Using Excel's Iferror Function to Trap Spreadsheet Errors
A Useful Tool for Financial Analysis - The Rank Function
Create Flexible Financial Models with Choose
Goal Seek Will Help You Find the Result You Are Looking For
Perform Sensitivity Analysis with Excel's Data Tables Functionality
Section 4
Practical Exercise "Build a P&L From Scratch"
It is one thing to learn how to work with Excel’s most important tools, but it is even better to apply these techniques in a practical exercise. This is what we will do here. The “Build a P&L from scratch” exercise allows you to see how everything you have learned so far can be put into practice.
Build a P&L from scratch: data preparation
Build a P&L from scratch: fill in the database
Build a P&L from scratch: mapping
Build a P&L from scratch: creating a P&L
Build a P&L from scratch: adding % variations
Section 5
Building Professional Charts in Excel
One of the strongest features of Microsoft Excel, besides multi-layered calculations, is that it allows you to visualize data. Here, you will learn how to insert and format different types of charts that will help you make sense of numbers and figure out their trend.
Introduction to Excel Charts
Beginner's Guide to Inserting Charts in Excel
Modifying Excel Charts - The Easy Way
Making Your Excel Charts Sexier - Proven Tips
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
New Ways to Visualize Your Data - Treemap Charts
How to Represent Trends with Sparklines
Stacked Column Chart with a Secondary Axis
Doughnut Chart
Area Chart
Bridge Chart
Section 6
Introduction to Pivot tables
Pivot Tables are capable of summarizing thousands of rows of data in just a few seconds. All you have to do is drag and drop, and you will be able to create the report you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.
Intro to Pivot tables
Editing a Pivot table
Formatting a Pivot table
Adjusting a Pivot table
GETPIVOTDATA
Slicers
Section 7
A practical case study with Pivot Tables
In this case study, you will: 1) apply in practice what you have learned so far, 2) work on a real-world task, 3) enhance your spreadsheet formatting skills, and 4) learn how to create advanced charts.
Introduction to the case study
Working with an SAP data extraction
Preliminary mapping of the data extraction
Creating an output structure of the FMCG model
Improving the layout and appearance of the FMCG report
Inserting formulas and automating calculations
Creating a Master Pivot Table: The main data source for the FMCG report
GetPivotData is great! Extracting data from the Master Pivot Table
Combining Slicers and GetPivotData: The key to our success
Getting fancy with Excel slicers
This is how the report can be used in practice by high-level executives
Data Science Fundamentals
This course is part of Module 1 of the 365 Data Science Program. The complete training consists of four modules, each building upon your knowledge from the previous one. Whereas the other three modules are designed to improve upon your technical skill set, Module 1 is designed to help you create a strong foundation for your data science career. You will understand the core principles of probability, statistics, and mathematics; you will also learn how to visualize your data.
See All Modules
Why Choose the 365 Data Science Program?
Practice
Real-life project and data. Solve them on your own computer as you would in the office.
Q&A Hub
Our expert instructors are happy to help. Post a question and get a personal answer by one of our instructors.
Certificates
Earn a verifiable certificate after each completed course. Celebrate your successes and share your progress with your professional network!
Trust the other 500,000 students
The course is in-depth and is delivered at a steady pace with eye catching visuals. The instructors go through all the basics really well. They try not to over-simplify the material, you get a good sense аof how deep Data Science is in the course. Great job!!!
This course is amazing! After watching the video carefully and doing all the exercises, I am even capable of having discussions with Machine learning major Master’s students! High standard course with reasonable pricing.
Very clear and in-depth explanation of data science and how all the inter-related concepts apply in real life business environment. Absolutely great for beginners! Best data science course I have come across so far!
I would highly recommend the course to any beginner who wants to venture into the world of Data Science. The concepts are very well explained and there is an emphasis on practical application which really helps create a better understanding of the concepts.
Ready to start?
Sign up today for FREE!
