Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - 40 Exercises for beginners. Learn by doing
Rating: 4.7 out of 5(866 ratings)
8,686 students

Microsoft Excel - 40 Exercises for beginners. Learn by doing

Learning by doing with Excel exercises! A practical approach to learn Microsoft Excel for beginners.
Created byHalvard Bastiansen
Last updated 10/2019
English

What you'll learn

  • 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

Course content

6 sections • 18 lectures • 6h 6m total length

  • Download exercises0:08
  • The Fundamentals32:11

    Learn the fundamentals of Microsoft Excel through 10 hands-on exercises, covering worksheets, cells, formatting, formulas, functions, charts, and auto fill.

  • Formulas and Charts25:15
  • Budget and Tables23:31

    Develop practical Excel skills by using simple formulas and charts, including sum, average, min, max, median, and line and clustered column charts with Hawaii rainfall and test data.

  • Absolute Cell Reference and Goal Seek24:03

    Learn to use absolute cell references and goal seek in Excel to model investment growth and loan amortization, building year-by-year balances and solving for required returns or rates.

  • The IF Function12:55

Requirements

  • This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016 and 2019

Description

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!


Who this course is for:

  • Self-thought and beginners with little prior experience.
  • If your looking to take your Excel skills from beginner to Great, then this course is for you.
  • If you like learning by doing, then this course is for you.

Report abuse