# The Complete Excel Blueprint

Learn how to make reports and dashboards, use PivotTables and PivotCharts, analyze big datasets and how to use the 30 most used formulas and functions in Excel.

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 and replay the videos as many times as you want!

## 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!
• easily analyze important parameters and become one of the management's most important assets!
• impress colleagues with your Excel new 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 - 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"!

## Review from a happy student

"Fantastic course!! I learned A LOT and I feel that I know Excel much better! Halvard is great at teaching and showing us what to do!"

## And you will get...

#### Certificate

A certificate could be a great addition to your CV and future job applications!

#### Fast support

Ask a question in the comment section or write me an email. I usually answer within 30 minutes!

#### 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!

## \$57

4 MONTHLY PAYMENTS

• Access for 12 months
• Certificate of Completion
• First priority email support
• 30-day money back guarantee!

## \$197

ONE PAYMENT

• Access for 12 months
• Certificate of Completion
• First priority email support
• 30-day money back guarantee!

## \$397

ONE PAYMENT

• Access for the rest of your life
• Certificate of Completion
• First priority email support
• 30-day money back guarantee!

## FAQ

How much time do I need to set off for The Complete Excel Blueprint?

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 Complete Excel Blueprint?

You will receive an email from me right after the purchase with username and password to the course portal. When you login you will get full access to the course. You can start watching the course right now!

Do I need any previous knowledge to take this The Complete Excel Blueprint?

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. You have lifetime access to the videos, so you 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!

Close

50% Complete

### Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.