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, lookup functions, and more!

Sign up to
preview the course
for FREE!

Create a free account and start learning data science today.

create free account
Our graduates work at exciting places:
walmart
tesla
paypal
citibank
booking.com

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.

FREE Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
FREE Data Entry Techniques in Excel
FREE How to Make Your Spreadsheets Look Professional
FREE Inserting, Deleting, and Modifying Rows & Columns
FREE Excel Formulas for Beginners
FREE Excel Functions
FREE Work Efficiently by Using Cut, Copy, and Paste
FREE Pasting Values, Formulas and Formats with Paste Special

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.

FREE How to work with text in Excel
FREE Efficient navigation in Excel
FREE Freeze panes and Custom sort
FREE Excel pivot tables
FREE Improve the layout of your Excel sheets
FREE Working with Excel macros
FREE Fixing cell references
FREE Find and Replace
Show all lessons
FREE Named ranges and dynamic names
FREE Custom Number Formatting
FREE How to Add a Drop-down List in Excel
Premium course icon Excel tips and tricks
Premium course icon Conditional Formatting
Show fewer lessons

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.

Premium course icon Key Excel Functions: If
Premium course icon Enlarge the formula bar
Premium course icon Key Excel Functions: Sum, Sumif, Sumifs
Premium course icon Key Excel Functions: Count, Counta, Countif, Countifs
Premium course icon Key Excel Functions: Average & Averageif
Premium course icon Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
Premium course icon Working with text in Excel
Premium course icon Find the Highest and Lowest Values in a Range: Max & Min
Show all lessons
Premium course icon =' and '+' are interchangeable when you start typing a formula
Premium course icon Use Round in Your Financial Models
Premium course icon Excel's Lookup Functions: Vlookup & Hlookup Made Easy
Premium course icon Index, Match, and Their Combination - The Perfect Substitute for Vlookup
Premium course icon Using Excel's Iferror Function to Trap Spreadsheet Errors
Premium course icon A Useful Tool for Financial Analysis - The Rank Function
Premium course icon Create Flexible Financial Models with Choose
Premium course icon Goal Seek Will Help You Find the Result You Are Looking For
Premium course icon Perform Sensitivity Analysis with Excel's Data Tables Functionality
Show fewer lessons

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.

Premium course icon Build a P&L from scratch: data preparation
Premium course icon Build a P&L from scratch: fill in the database
Premium course icon Build a P&L from scratch: mapping
Premium course icon Build a P&L from scratch: creating a P&L
Premium course icon 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.

Premium course icon Introduction to Excel Charts
Premium course icon Beginner's Guide to Inserting Charts in Excel
Premium course icon Modifying Excel Charts - The Easy Way
Premium course icon Making Your Excel Charts Sexier - Proven Tips
Premium course icon Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
Premium course icon New Ways to Visualize Your Data - Treemap Charts
Premium course icon How to Represent Trends with Sparklines
Premium course icon Stacked Column Chart with a Secondary Axis
Show all lessons
Premium course icon Doughnut Chart
Premium course icon Area Chart
Premium course icon Bridge Chart
Show fewer lessons

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 that you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.

Premium course icon Intro to Pivot tables
Premium course icon Editing a Pivot table
Premium course icon Formatting a Pivot table
Premium course icon Adjusting a Pivot table
Premium course icon GETPIVOTDATA
Premium course icon 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 4. Learn how to create advanced charts

Premium course icon Introduction to the case study
Premium course icon Working with an SAP data extraction
Premium course icon Preliminary mapping of the data extraction
Premium course icon Creating an output structure of the FMCG model
Premium course icon Improving the layout and appearance of the FMCG report
Premium course icon Inserting formulas and automating calculations
Premium course icon Creating a Master Pivot Table: The main data source for the FMCG report
Premium course icon GetPivotData is great! Extracting data from the Master Pivot Table
Show all lessons
Premium course icon Combining Slicers and GetPivotData: The key to our success
Premium course icon Getting fancy with Excel slicers
Premium course icon This is how the report can be used in practice by high-level executives
Show fewer lessons
MODULE 1

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 up on your knowledge from the previous one. Whereas the other three modules are designed to improve upon your technical skillset, 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

Trust the other 276,000 students

Ready to start?
Sign up today for FREE!

Whether you want to scale your career or transition into a new field, data science is the number one skillset employers look for. Grow your analytics expertise and get hired as a data scientist!