These 5 Excel Tricks Will Save Your Job
4.3 (109 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.
8,605 students enrolled
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.3 (109 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.
8,605 students enrolled
Last updated 8/2017
English
English [Auto-generated]
Price: $25
30-Day Money-Back Guarantee
Includes:
  • 30 mins on-demand video
  • 4 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • Microsoft Excel in any version (works also with 2003, 2007, 2010)
  • Interest in best practice standard Excel tricks
Description

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
Compare to Other Excel Courses
Curriculum For This Course
+
Welcome!
1 Lecture 00:32
Welcome!
00:32
+
Introduction
1 Lecture 01:03
+
The 5 Best Excel Tricks
6 Lectures 28:23
The Standard Way How To Bring Data Together (VLOOKUP-Formula explained)
07:24

Request for Help & Get One Course for Free
00:26


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

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

+
Conclusion
2 Lectures 01:55
Overview Of The 5 Tricks
01:03

Which Function For Which Purpose?
5 questions

You Did It! :-)
00:52
+
BONUS
1 Lecture 00:14
BONUS: GET PREMIUM COURSES WITH 92% OFF
00:14
About the Instructor
Sebastian Glöckner
4.2 Average rating
1,145 Reviews
44,296 Students
13 Courses
Responsible for Your Success!

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.