Introduction to Excel

with Ned Krastev

4.8/5

(3728)

Even in data science, smaller datasets are processed quicker in Excel rather than Python, R, or SQL. This course gives you the skills you need to crunch numbers in the number one spreadsheet program.

4 hours 83 lessons

Start course

Course Overview

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!

83 High Quality Lessons

3 Practical Tasks

4 Hours of Video

Certificate of Achievement

Topics covered

data analysisdata visualizationExcel

What You'll Learn

Every data analyst needs Excel in their arsenal. This course will teach you how to apply various Excel techniques for performing calculations, data manipulations, analyses, and more!

Understand Excel best practices

Navigate spreadsheets professionally

Use keyboard shortcuts

How to use Excel functions

Insert and format different types of charts

Work with pivot tables

Curriculum

Welcome! Course Introduction Free

10 Lessons 31 Min

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.
Welcome to the Course 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 Formatting Free Pasting Values, Formulas and Formats with Paste Special Free
Useful Tools & Tips Free

29 Lessons 62 Min

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.
Inserting a Line Break with Alt + Enter Free Do More with Your Sales Data with Excel's Text to Columns Feature Free Create Easily Printable Excel Documents Free How to Wrap Text in Excel and Adjust a Cell's Size Free Insert Hyperlinks into Excel Spreadsheets Free Using Excel's Freeze Panes to Handle Large Datasets Free Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do Free A Quick Introduction to Excel's Pivot Tables Free Initial Formatting Is Key for Creating Professional-looking Spreadsheets Free Macros Are a Great Timesaver! Here's Why Free How to Use the Same Macro On Multiple Workbooks Free The Secret to Faster Scrolling in Excel Free Be even quicker: F5 + Enter Free Using Absolute and Relative Cell References Free Find and Select Cells That Meet Specific Conditions Free How to Create Dynamic Names in Excel Spreadsheets Free Using Named Ranges to Make Formulas More Readable Free How to Add a Drop-down List in Excel Free Using Custom-sort to Sort Multiple Columns Within a Table Free Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts Free Multiply by 1 Free Find and Replace - References Free Find and Replace - Formatting Free Green References Free Beauty Saving - The Professional Way of Saving Files Free The Power of F2 Free Conditional Formatting Free Introduction to Custom Cell Formatting Free Custom Formatting - An example Free
Beginner, Intermediate & Advanced Functions

17 Lessons 52 Min

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 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
Practical Exercise "Build a P&L From Scratch"

16 Lessons 41 Min

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.
Introduction to the Case Study What You Will See Next Understand Your Data Source Before You Start Working on It Ordering the Source Worksheet Create a Code: The Best Way to Organize Your Data and Work Efficiently with It Learn How to Create a Database Using Lookup Functions (Vlookup) to Fill the Database Sheet Use Sumif to Complete the Database Sheet Using Index & Match as a Substitute for Vlookup The Mapping Exercise Mapping the Rows in the Database Sheet Building the Structure of the P&L Sheet A Practical Example of Professional Formatting in Excel Populate the P&L Sheet with Sumif Learn How to Find Mistakes with Countif Calculating Growth Rates in Excel
Introduction to Excel Charts

7 Lessons 15 Min

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
Building Professional Charts in Excel

4 Lessons 22 Min

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.
Stacked Column Chart with a Secondary Axis Doughnut Chart Area Chart Bridge Chart

Student feedback

4.8/5

3728 ratings

5 stars

3251 (87%)

4 stars

385 (10%)

3 stars

74 (2%)

2 stars

12 (0%)

1 star

6 (0%)

Luka

18.11.2022

As a total beginner in this field, I feel like I couldn't follow entirely with all the terms. I recommend adding to course information which courses are recommended to follow before this one. Furthermore, the location of the exam within the course should be changed, as already suggested in the comments. Lastly, I wasn't fan of how the videos had various styles instead of sticking to one style, and the last video also repeats information that was taught in an earlier video. It would be good to pay attention to this sort of things when making changes to courses. Overall, I did learn a lot of new things in Excel. I could follow it relatively well considering I have no background in this field.

Helen Xie

17.11.2022

The only problem I find is that the lessons are kind of disconnected, if I learn one thing, then I have to wait a lot lessons apart to know further how it is helpful. The tests also cover stuff we have not learned in the module, it is only in the next module I find what needed to be done in the previous test.

Abigail Harper

11.07.2022

Needs functionality for users with Google Sheets instead of Excel. While most of the functions and formulas work the same during practice, I can't do anything with the exam materials provided since I can't pay for office and can't even click through the files. Very disappointed.

Keith

28.01.2023

"Numbers stored as text" error after creating the code column and trying to paste special values. This was mentioned on "Create a Code" by another student but hasn't been answered. I'm going to keep going and tell it to ignore, let's see if this derails the entire process.

Jesus Chavez Erhard

06.12.2022

At the moment of me writing this, I am in part 2 of the course, Useful Tools & Tips, and I like how the course is structured, I like that we are given exercises to do ourselves, and I like we are given material to read. I hope I can learn a new thing or two from excel.