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.4 (24 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.
4,184 students enrolled
$200
Take This Course
  • Lectures 11
  • Contents Video: 30 mins
    Other: 2 mins
  • Skill Level Beginner 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 3/2015 English

Course 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.)

What are the requirements?

  • Microsoft Excel in any version (works also with 2003, 2007, 2010)
  • Interest in best practice standard Excel tricks

What am I going to get from this course?

  • 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

What 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

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:03
Before We Go On
Article
Section 2: The 5 Best Excel Tricks
The Standard Way How To Bring Data Together (VLOOKUP-Formula explained)
07:24
The Coolest Tricks for Conditional Background Colors in Reports
Preview
03:40
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
Why and How To Use Pivot Tables in Everyday Life (Only Functions You Must Know)
Preview
06:14
Section 3: Conclusion
Overview Of The 5 Tricks
Article
Which Function For Which Purpose?
5 questions
You Did It! :-)
00:52
Section 4: 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