Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Works with any Excel version!
This course contains downloadable xlsx-files attached to every lecture containing the tables, formulas and data shown in the videos!
Learn how to succeed on your job + get the best jobs possible with these proven Excel Ninja tricks!
80% of the Excel problems in office are not related to nice graphs or complicated formulas! They are related to summing up numbers from several Excel files and/or poor data quality. And exactly this is covered in this course.
It's easy to learn. You just need:
and you will get your things in order.
Learn how to
30 day full refund policy + no questions asked!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Before We Go On
|Section 2: Get Data Into Shape!|
About The Mindset
First, Let's Delete Some Useless Information!
An Underrated Task: Add Missing Information (Part 1)
Add Missing Information (Part 2)Preview
|Section 3: Compare Data from Different Excel Files!|
Common Business Tasks Which Require Comparing
Find Differences in a Second With an Easy FormulaPreview
Perform a Delta Analysis into Both Directions
The Finish: Set Up an Email Based on Your Analysis (1)
Complete the Email Based on Your Analysis (2)
|Section 4: Gather Numbers, Find and Correct Errors!|
Gather Numbers in a Second
How Do We Update All the Numbers? (1)
Update the Numbers With a Trick! (2)
Sum Up Data With an Easy Formula (1)
Sum Up Data: Let's Complete the Picture! (2)
Explanation and Disadvantages of Vlookup (1)
Ninja Trick: Be Better and Faster than Vlookup (2)
What If You Cannot Find an ID
Little Trick: How to Get Rid of #N/APreview
Competitive Advantage: Understand Inconsistencies! (1)
How to Deal with Inconsistencies (2)
|Section 5: Bonus Course: "Excel Pivot Tables in A Nutshell"|
All You Need To Know To Build Your First Pivot Table
Another Detailed Example
How About A Table With More Than Two Dimensions?
Advanced Killer Trick - Bring Data Into Your Individualized Report
|Section 6: BONUS|
GET OTHER COURSES WITH 40% OFF
Do you know that feeling one day ahead of vacation when you sort out your
projects, send overdue emails and suddenly get a lot things done? For me every day should be as successful as that! And I would like to share enough knowledge with you to make that happen.
I work as a project manager, entrepreneur and management consultant for more than 15 years. I love to deconstruct systems, improve processes and bring projects to success (and did that already for various customers all over Europe).
Currently I work full time as a project manager and process expert. My daily business it to make things faster and manage multiple things at the same time.
I am into time- and self management. I love improving myself and assist others in working faster and with better results.
In the past decade I studied various resources about time management, project management, and self management. Doing that I came to the conclusion that 80% of the common "self management tips" do not work as promised. That's why I developed invented my own system for being as productive as possible.