Microsoft Excel – 40 Exercises for beginners. Learn by doing

Learning by doing with Excel exercises! A practical approach to learn Microsoft Excel for beginners.

Instructor:

Halvard Bastiansen

8,337 students enrolled

English [Auto]

How to use Excel as an efficient tool. The best way to learn is with practical exercises.

Master Microsoft Excel from Beginner to Advanced

Learn the most common Excel functions used in the Office

Build a solid understanding on the Basics of Microsoft Excel

The best way to learn Excel is by doing practical exercises.

Do you have little or no experience with Microsoft Excel? We will go through more than 40 practical exercises, where you will learn everything you need to know to use Microsoft Excel as an effective tool!

We will start with 10 basic exercises, where you will learn the fundamentals of how to use Excel. Then you will learn how to make reports and dashboards, use PivotTables and PivotCharts, analyze datasets and how to use the 30 most used formulas and functions in Excel.

Each module in the course is divided into two parts, one theory part and one practice part where you use what you have learned. All exercises have video solutions.

This course is for you, if you want to:

stop struggling with Excel formulas that are not working!
easier understand other people’s Excel worksheets!
easier find the formula you should use!
build your own Excel sheets, instead of asking other people to make them for you!
easily analyze important parameters and become one of the management’s most important assets!
impress colleagues with your Excel new skills!

The fundamentals (10 exercises)

Download exercises

The Fundamentals

Formulas and Charts

Budget and Tables

Absolute Cell Reference and Goal Seek

The IF Function

Reporting and Practical functions

Introduction to Reporting and Practical Functions

Exercise 1-4 (video solution)

Data Analysis

Introduction to Data Analysis

Exercise 1-6 (video solution)

Exercise 7 (video solution)

Analysis of Big Datasets

Introduction to Analysis of Big Datasets

Exercise 1-6 (video solution)

Exercise 7-9 (video solution)

PivotTables and PivotCharts

Introduction to PivotTables and PivotCharts

Exercise 1-6 (video solution)

Repetition - more exercises

Exercise 1-3 (video solution)

Exercise 4-8 (video solution)

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

4.6

4.6 out of 5

753 Ratings