COURSE DESCRIPTION
Works with any Excel version!
Learn how to succeed on your job + get the best jobs possible with these proven 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 formulas
- The right 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
This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!
CURRICULUM
About The Mindset
Add Missing Information (Part 2)
An Underrated Task: Add Missing Information (Part 1)
Common Business Tasks Which Require Comparing
Compare Data from Different Excel Files!
Competetive Advantage: Understand Inconsistencies! (1)
Complete the Email Based on Your Analysis (2)
Explanation and Disadvantages of Vlookup (1)
Find Differences in a Second With an Easy Formula
First, Let's Delete Some Useless Information!
Gather Numbers in a Second
Gather Numbers, Find and Correct Errors!
Get Data Into Shape!
How Do We Update All the Numbers? (1)
How to Deal with Inconsistencies (2)
Introduction
Little Trick: How to Get Rid of #N/A
Ninja Trick: Be Better and Faster than Vlookup (2)
Perform a Delta Analysis into Both Directions
Sum Up Data With an Easy Formula (1)
Sup Up Data: Let's Complete the Picture! (2)
The Finish: Set Up an Email Based on Your Analysis (1)
Update the Numbers With a Trick! (2)
Welcome!
What If You Cannot Find an ID
LINK FOR THE FREE COURSE
No comments:
Post a Comment
Note: only a member of this blog may post a comment.