Get Any Excel Job Done at Work Using Excel Ninja Tricks (For All Excel Versions 2003, 2007, 2013, 2016)
What you will learn
Learn to think Excel!
Learn how data should actually look like!
Learn how to do the most common office tasks very quickly and precise
Get the Ninja mindset and understand why so many people are struggling with Excel. In future you will help them!
Get better jobs with your faster and tidier way of working
Description
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!
Content
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:
- 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!
English
language
Content
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
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