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!

Description

ContentLearn 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:

• A handful of highly effective Excel formulas

• The Excel Ninja mindset

... and you will get your things in order.

Learn how to

• Clean up any Excel table, especially in a business context

• Add missing information into files you received

• Find differences between two Excel tables very fast

• Address differences in a structured way

• Update your numbers using a different file

• Get information out of another table super fast

• Find and extinguish inconsistencies in a table

30 day full refund policy + no questions asked!

• Anyone who wants to understand the secrets of Excel mastery
• Anyone who wants to perform better and work faster
• You should have some Excel knowledge though, the course is not for complete beginners.
• If you are not 100% satisfied, please contact me! You'll get your money back.

Course content

• Introduction
  • Welcome!
  • Introduction
  • Welcome!
• Get Data Into Shape!
  • About The Mindset
  • Request for Help & Get One Course for Free
  • First, Let's Delete Some Useless Information!
  • An Underrated Task: Add Missing Information (Part 1)
  • Add Missing Information (Part 2)
• Compare Data from Different Excel Files!
  • Common Business Tasks Which Require Comparing
  • Find Differences in a Second With an Easy Formula
  • 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)
• 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/A
  • Competitive Advantage: Understand Inconsistencies! (1)
  • How to Deal with Inconsistencies (2)
• 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
• BONUS
  • My Other Courses