Excel Course for Beginners - Online course with 40 exercises!
+ Free shipping
Country/Region of Manufacture:
Additional Product InformationDo you have little or no experience with Microsoft Excel? .
In this online course you will learn everything you need to know to use Microsoft Excel as an effective tool!
Imagine how nice your workday would be, if you could: .
Stop struggling with Excel formulas that are not working!
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 skills! .
This is what you will learn: .
MODULE 1 - The fundamentals of Excel .
how to insert numbers and text, and how to use simple formulas and functions. .
how to make budgets and tables in an efficient way. .
typical mistakes beginners do and how to avoid them. .
how to use Absolute cell reference. .
how to use simple functions like SUM, AVERAGE, MIN, MAX, MODUS and MEDIAN. .
how to insert charts from datasets. .
how to make great looking reports and dashboards, that summarizes the other sheets in the workbook.
how to use VLOOKUP to find relevant information from datasets.
how to make advanced formulas with parenthesis and how to use data from other sheets in a formula. .
how to combine the IF-function with SUM, AVERAGE and COUNT, so you easily can find relevant information in datasets. .
how to use the AND- and OR-functions to analyze simple conditions. .
MODULE 4 - Analyzing big datasets .
A typical question you will learn to answer is: How many units of "Product 1" did "Region West" sell under "Sales Campaign XYZ" in "October"? .
MODULE 5 - PivotTable and PivotCharts .
how to use PivotTables to analyze big datasets. .
how to use PivotCharts to present data and illustrate important trends. .
When you know how to use PivotTables and PivotCharts, you can quickly extract the information you need from huge datasets! .
You will learn how to record simple Macros and how you can use them to save time by automate repeating tasks. .
In this module we are going to summarize and repeat what we have learned so far. Lets make sure you get the knowledge "into your fingers"!
How much time do I need to set off for the course?.
Each module is divided into two parts, one theory part and one with exercises. The theory part takes between 15 to 30 minutes to complete per module. After that you can download the exercises and practice as long as you wish. It´s about 1 hour of video content per module.
Also, I recommend that you go through the course in smaller increments, instead of everything at once. That way, you to get the knowledge "into your fingers" and you will remember the information longer.
Yes, I would love to help you! Write me an email or use the comment sections.
What happens after I buy the course?.
You will receive an email from me shortly after the purchase with username and password to the course portal. When you login you will get full access to the course. .
Do I need any previous knowledge to take this course?.
No, you will learn everything you need to know in this course. .
What if I don't have the opportunity to watch all the videos right now?.
You choose when and where you want to watch the videos. You have lifetime access to the videos, so you have plenty of time to complete the course.
Once you have gone through the content. There are no tests you have to pass, everyone gets a certificate! You will receive the course certificate by email as a PDF file.
Just let me know by sending me an email, and you should have your money in your account within a few days. I will give you all your money back, if you are not satisfied within 30 days!