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)
Reporting and Practical functions
Data Analysis
Analysis of Big Datasets
PivotTables and PivotCharts
Repetition - more exercises
Productivity Hacks to Get More Done in 2018
— 28 February 2017
- 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!
- 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.
- Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!