Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add These 5 Excel Tricks Will Save Your Job to your Wishlist.

Add to Wishlist

These 5 Excel Tricks Will Save Your Job

Want to work with Excel like a pro? Improve your job performance with the Top 5 best practice Excel tricks.
4.1 (57 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.
5,818 students enrolled
Last updated 1/2017
$10 $200 95% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 30 mins on-demand video
  • 4 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Works with any Excel version!

Would you like to be a professional office worker? Work like a pro?
Learn how to save your job with the 5 best practice Excel tricks professionals use every day! If you know the basics and how to actually do them, the next step towards a better job will be only a matter of time!

This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!

What you will learn

  • The basic way to bring data together
  • Why conditional background colors are so cool
  • Sum up parts of data under a certain condition (sounds complicated, but it's not!)
  • Compare two tables - line by line - but in a second
  • Why so many people use pivot tables

30 day full refund policy + no questions asked! (If bought via Udemy website. If you bought the course via App and are not satisfied, please contact me directly.)

Who is the target audience?
  • Anyone who wants to learn or to repeat the standard Excel tricks professionals use every day
  • Anyone who wants to perform better and work faster
Students Who Viewed This Course Also Viewed
What Will I Learn?
Know the 5 Top Excel tricks professionals use every day
Learn the standard way to gather information automatically
Learn the basics about summing up and comparing data from different tables
View Curriculum
  • Microsoft Excel in any version (works also with 2003, 2007, 2010)
  • Interest in best practice standard Excel tricks
Curriculum For This Course
Expand All 11 Lectures Collapse All 11 Lectures 32:13
1 Lecture 00:13
2 Lectures 01:44

Before We Go On
The 5 Best Excel Tricks
5 Lectures 27:57
The Standard Way How To Bring Data Together (VLOOKUP-Formula explained)

How To Sum Up Data under Certain Conditions (How I Use SUMIF)

Find Deltas Between Two Tables Very Easily (That's How I See COUNTIF)

2 Lectures 01:55
Overview Of The 5 Tricks

Which Function For Which Purpose?
5 questions

You Did It! :-)
1 Lecture 00:14
About the Instructor
4.1 Average rating
654 Reviews
28,613 Students
10 Courses
Be Ahead of Your Time


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.

Report Abuse