4.75 out of 5
4.75
748 reviews on Udemy

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
34 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)

1
Download exercises
2
The Fundamentals
3
Formulas and Charts
4
Budget and Tables
5
Absolute Cell Reference and Goal Seek
6
The IF Function

Reporting and Practical functions

1
Introduction to Reporting and Practical Functions
2
Exercise 1-4 (video solution)

Data Analysis

1
Introduction to Data Analysis
2
Exercise 1-6 (video solution)
3
Exercise 7 (video solution)

Analysis of Big Datasets

1
Introduction to Analysis of Big Datasets
2
Exercise 1-6 (video solution)
3
Exercise 7-9 (video solution)

PivotTables and PivotCharts

1
Introduction to PivotTables and PivotCharts
2
Exercise 1-6 (video solution)

Repetition - more exercises

1
Exercise 1-3 (video solution)
2
Exercise 4-8 (video solution)
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4.8
4.8 out of 5
748 Ratings

Detailed Rating

Stars 5
449
Stars 4
238
Stars 3
49
Stars 2
9
Stars 1
4