Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

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)
Rating: 4.0 out of 54.0 (248 ratings)
14,289 students
Created by Sebastian Glöckner
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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

Requirements

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

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!

Who this course is for:

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

Course content

6 sections • 29 lectures • 2h 22m total length

  • Welcome!
    00:21
  • Preview04:57
  • Preview01:24

  • About The Mindset
    01:28
  • Request for Help & Get One Course for Free
    00:25
  • First, Let's Delete Some Useless Information!
    06:04
  • An Underrated Task: Add Missing Information (Part 1)
    05:50
  • Preview05:10

  • Common Business Tasks Which Require Comparing
    05:04
  • Preview05: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

  • 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
  • Preview03:02
  • Competitive Advantage: Understand Inconsistencies! (1)
    04:06
  • How to Deal with Inconsistencies (2)
    07:45

  • 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

  • Check this out!
    00:17

Instructor

Sebastian Glöckner
Diplom-Informatiker, 14 Jahre Vollzeit-Projektmanager
Sebastian Glöckner
  • 4.4 Instructor Rating
  • 9,662 Reviews
  • 144,582 Students
  • 89 Courses

                                            (Please scroll down for english version.)

Kennst Du das Gefühl, wenn Du am letzten Tag vor dem  Urlaub plötzlich extrem viel geschafft bekommst? Nur, weil Du ein festes Ziel vor Augen hast? Für mich sollte jeder Tag so sein! 

Ich bin Diplom-Informatiker und arbeite seit 14 Jahren als Vollzeit-Projektmanager und Consultant. Ich liebe es, komplexe Abläufe zu verstehen, Prozesse zu verbessern und Projekte zum Erfolg zu führen. 

Seit fast 25 Jahren beschäftige ich mich außerdem mit Microsoft Excel und wende das auch täglich in meinen Projekten an. 

Aus dem Grund gehen die meisten meiner Kurse hier in Richtung Projektmanagement und Excel. Da kann mir einfach keiner mehr was vormachen, und ich teile mein Wissen am liebsten mit echten Beispielen aus der Praxis.


--------------------------------------------------------------

English Version

Do you know the feeling when you suddenly get a lot of work done on the last day before your holiday? Only because you have a fixed goal in mind? For me every day should be like this! 

I have a degree in computer science and have been working as a full-time project manager and consultant for 14 years. I love to understand complex processes, to improve processes and to lead projects to success. 

I have also been working with Microsoft Excel for 25 years and apply it to my projects on a daily basis. 

That's why most of my courses here focus on project management and Excel. Nobody can fool me anymore and I prefer to share my knowledge with real examples from practice.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.