Become the Excel Hero with Advanced Excel Tricks for Job
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
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.