From Beginner to Expert
- improve your workday!
Learn how to make reports and dashboards, analyze big datasets, use PivotTables and PivotCharts, make Macros and how to use the 30 most used formulas and functions in Excel.
During this course you will be guided through more than 30 practical exercises. You can watch the videos when and where you want, all you need is internet connection.
You can watch the videos as many times as you want during the next 12 months!
Imagine how nice your workday would be, if you could:
-
stop fooling around with Excel functions that are not working!
-
easier understand other people's Excel workbooks!
-
easier find the feature and function you should use!
-
be able to 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 - Reporting and Practical functions
You will learn:
- how to make great looking reports and dashboards, that summarizes the other sheets in the workbook.
- how to make nested IF-functions (more than two alternatives).
- 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.
MODULE 2 - Analyzing data
You will learn:
- 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 3 - 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 4 - PivotTable and PivotCharts
You will learn:
- 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!
MODULE 5 - Macros
You will learn how to record simple Macros and how you can use them to save time by automate repeating tasks.
MODULE 6 - Summary
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"!
And you will get...
Fast support
Ask a question in the comment section or write me an email. I usually answer within 30 minutes!
Certificate
Get a course certificate you can add to your CV or job applications!
Unlimited replays
Watch the videos as many times as you want in 12 months!
Access when and where you want
Watch the videos from mobile, tablet or PC/Mac, all you need is internett connection!
30-day money back guarantee!
Just contact me within 30 days of your purchase and receive a full refund, no questions asked!
Order today, and start improving your workday now!
$197
1 PaymentFor your security, all orders are processed on an encrypted, secure server.
FAQ
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.
Will I get free support?
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 right after the purchase where you will find a link to the course portal. When you login you will get full access to the course. You can start watching the course right away!
Do I need any previous knowledge to take this course?
You need basic Excel knowledge to benefit from this course. I made this course a natural extension of the beginner's course, so if you have completed Excel for Beginners you'll be fine.
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. The videos will be available to you for 12 months, so you should have plenty of time to complete the course.
When will I get my certificate?
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.
How do you make sure the payment is secure?
You can choose to pay with Paypal or Stripe. They take care of your billing information and makes sure the transaction is safe. Your credit card information are never touching my servers!
How do I get a refund?
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!