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!
Sign up to
preview the program
for FREE!
Create a free account and start learning data science today.
create free accountOur 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.
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.
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.
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.
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.
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.
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 ModulesWhy 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!