Excel for Sales Analysis
- improve your workday!
Learn how to make reports and dashboards, analyze CRM exports and how use PivotTables and PivotCharts to find and illustrate trends.
During this course you will be guided through more than 40 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!
You will learn...
MODULE 1 - Reporting and Practical functions
You will learn:
- how to make great looking sales reports and dashboards.
- how to use VLOOKUP to find relevant information from lists.
MODULE 2 - Analyzing data
You will learn how to use advanced IF-functions to:
- summarize each reps sales results.
- find total sales revenue from each product.
- find average sale during a period.
- quicly figure out who qualifies for a sales bonus, and who do not.
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 - 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 certificate you can add to your CV or future 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!
$117
4 monthly payments
- Access for 12 months.
- 40+ practical exercises.
- Certificate.
- First-priority email support.
- 30-day money back guarantee!
You get instant access to the course after registration!
$397
1 payment
- Access for 12 months.
- 40+ practical exercises.
- Certificate.
- First-priority email support.
- 30-day money back guarantee!
You get instant access to the course after registration!
Lifetime access
$597
1 payment
- Access for the rest of your Life!
- Get all future updates for free!
- 40+ practical exercises.
- Certificate.
- First-priority email support.
- 30-day money back guarantee!
You get instant access to the course after registration!
Invoice - only corporations
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! Just 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 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!