Become the Excel Hero with Advanced Excel Tricks for Job

Get Any Excel Job Done at Work Using Excel Ninja Tricks (For All Excel Versions 2003, 2007, 2013, 2016)
4.4 (34 ratings) Instead of using a simple lifetime average, Udemy calculates a
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.
2,316 students enrolled
$200
Take This Course
  • Lectures 29
  • Contents Video: 2.5 hours
    Other: 1 min
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course 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!

What are the requirements?

  • Microsoft Excel in any version (tricks work also with 2003, 2007, 2010)
  • Interest in high-end Excel tricks and the Ninja mindset

What am I going to get from this course?

  • 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

What is the target audience?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Welcome!
Article
Section 1: Introduction
Teaser Video
Preview
01:24
Welcome!
Preview
01:24
Before We Go On
Article
Section 2: Get Data Into Shape!
About The Mindset
01:28
First, Let's Delete Some Useless Information!
06:04
An Underrated Task: Add Missing Information (Part 1)
05:50
Add Missing Information (Part 2)
Preview
05:10
Section 3: Compare Data from Different Excel Files!
Common Business Tasks Which Require Comparing
05:04
Find Differences in a Second With an Easy Formula
Preview
05:48
Perform a Delta Analysis into Both Directions
04:10
The Finish: Set Up an Email Based on Your Analysis (1)
04:16
Complete the Email Based on Your Analysis (2)
05:44
Section 4: Gather Numbers, Find and Correct Errors!
Gather Numbers in a Second
07:03
How Do We Update All the Numbers? (1)
05:27
Update the Numbers With a Trick! (2)
04:58
Sum Up Data With an Easy Formula (1)
05:32
Sum Up Data: Let's Complete the Picture! (2)
04:59
Explanation and Disadvantages of Vlookup (1)
07:14
Ninja Trick: Be Better and Faster than Vlookup (2)
07:03
What If You Cannot Find an ID
08:10
Little Trick: How to Get Rid of #N/A
Preview
03:02
Competitive Advantage: Understand Inconsistencies! (1)
04:06
How to Deal with Inconsistencies (2)
07:45
Section 5: Bonus Course: "Excel Pivot Tables in A Nutshell"
All You Need To Know To Build Your First Pivot Table
06:14
Another Detailed Example
08:00
How About A Table With More Than Two Dimensions?
02:09
Advanced Killer Trick - Bring Data Into Your Individualized Report
09:33
Section 6: BONUS
GET OTHER COURSES WITH 40% OFF
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sebastian Glöckner, Make Things Happen!

Hi!

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.

Ready to start learning?
Take This Course