Become Excel Expert With Jasper Kingsley

This course shall help you get any excel job done at work using Excel Ninja Tricks For All Excel Versions . This course will cover everything from Excel fundamentals to advanced tools and functions. Whether you're just learning to navigate Excel or are already using it regularly but don't quite have a grasp on all of its tools, this course will teach you so many things that will make your job easier and beef up your resume.

5 ( 2 ratings ) 326 students enrolled
Created on 2021-02-05 12:09:53 Last updated on 2021-09-26 10:36:16 English
What i will learn?
    • Learn how data should actually look like.
    • Learn how to do the most common office tasks very quickly and precisely.
    • 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.
    • Knowledge of all the essential Excel formulas.
    • Make great presentations using the Conditional and Table formatting options.
    • Increase your efficiency by learning how to create and use important Excel shortcuts.
    • Get the Ninja mindset and understand common struggles in using Excel. 
    • Get better jobs with your faster and tidier way of working.


Lessons for this course
4 Units
  •     1. How Good Data Looks Like! 2
  •     2. Shaping Our Data 6
  •     3. Add Missing Information, Part -1 6
  •     4. Add Missing Information, Part -2 5
  •     1. Common Business Tasks Which Require Comparing 5
  •     2. Find Differences In A Second With An Easy Formula 6
  •     3. Perform A Delta Analysis Into Both Directions 4
  •     4. Set Up An Email Based On Your Analysis, Part- 1 4
  •     5. Complete The Email Based On Your Analysis, Part- 2 6
  •     1. Gather Numbers In A Second 7
  •     10. Competitive Advantage: Understand Inconsistencies, Part -1 4
  •     11. How To Deal With Inconsistencies, Part- 2 8
  •     2. How Do We Update All the Numbers, Part- 1 5
  •     3. Update The Numbers With A Trick, Part- 2 5
  •     4. Sum Up Data With An Easy Formula, Part- 1 6
  •     5. Sum Up Data, Part- 2 5
  •     6. Explanation And Disadvantages Of Vlookup, Part- 1 7
  •     7. Ninja Trick: Be Better And Faster Than Vlookup, Part-2 7
  •     8. What If You Cannot Find An Id 8
  •     9. Little Trick: How to Get Rid of #N/A 3
  •     1. All You Need To Know To Build Your First Pivot Table 6
  •     2. Another Detailed Example 8
  •     3. How About A Table With More Than Two Dimensions? 2
  •     4. Advanced Killer Trick-Bring Data Into Your Individualized Report 10
Requirements
  • You will need a PC with any version of Excel installed in it.

+ View More
Course Objective

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & 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. This course shall provide you highly effective Excel formulas and the Excel Ninja mindset.

Learn how to succeed in your job or get the best jobs possible with these proven Excel Ninja tricks. 

About the instructor
Jasper Kingsley
+ View More
About Teacher
IT Expert, Trainer
Student feedback
Average rating
5

charlie adams


12:38:31 PM 2021-02-12

Yes, absolutely.. this is amazing experience to get understanding of Excel, VBA and macros.. just love the concept of automation the stuff using VBA (the powerful tool).. I'm glad that successfully I completed this course and able to add the skill of Excel into me. Highly recommended!!

CS

Catherine Smith


03:00:00 PM 2021-01-05

Loved the interaction and uniqueness of training making it personable, thank you!



$9
(Non Credit)

You are not logged in !

Includes:
  • Blockchain stored certificate
  • 4 Units
  • Full lifetime access
  • Access on mobile



Training 5 or more people?

Get your team access to 4,000+ top Pedagog courses anytime, anywhere.

Join as Institution

About instructor

0 XP Earned

$ 2640.5 Earned

1 Courses

Jasper Kingsley

MTech

More Recommended Courses

Joel Farnworth

A comprehensive look at both the creation of organisation/business strategy and how, once created a strategy is best implemented. Essentially a module from the European International University's MBA programme this is available as a separate purchase for those who wish to focus their learning on creation and implementation of strategic intent. With detailed coverage of the topic, this online offering is delivered in 30 sections and needs approximately 25 hours of learning time. Designed over a six month period in 2019, it is an up to date summary of what we have learned about creating and (more importantly) delivering strategic intentions to successfully progress any organisation.

5

(5 Ratings)

Price

$14

Mr. Robert Brand

The project management course covers the best practices of modern project management.

4

(4 Ratings)

Price

$10

Joel Farnworth

A comprehensive look at best practice in both leadership and people management. The fundamental start point is that Leadership is different from Management and, although almost all agree to this, research continues to show that businesses and organisations are struggling to identify and use these differences effectively. Business results are suffering as a result. Taken from the European University's MBA programme, this online offering is provided in 30 sections and involves approximately 25 hours of learning. Designed over a six month period in 2019 it brings together much that we have learned on impactive leadership as opposed to effective management!!

5

(4 Ratings)

Price

$10

Dr. Katina Grigoraskos

This course is designed to develop skills in designing, conducting and evaluating action research in the context of management practice. Research can be one of the most interesting features of any degree course as it offers you a measure of control and autonomy over what you learn. It gives you an opportunity to confirm, clarify, pursue – or even discover –new aspects of a subject or topic you are interested in.

5

(11 Ratings)

Price

$150

Joel Farnworth

A comprehensive look at the progress made and best practices now used increasingly in mainstream HR services that impact business success. The programme covers the moves made from HR's administrative roots to strategic business partner and now the intentions to become a predictive contributor to future business/organisation success. Progress has not been smooth - much more disjointed than we would have liked - but what has emerged (and continues to evolve) are a number of key service deliverables that impact business progress and that set the scene for HR capabilities and deliverables going forward. Taken for the European International Universitiy's MBA programme, this offering is designed in 30 learning sections that require approximately 25 hours of learning.

4

(4 Ratings)

Price

$12

Robert Park

A course that focuses on effective planning, pricing, and promoting of goods and services intended to its target market with practical operational recommendations.

5

(7 Ratings)

Price

$15

Thitival Hutasingh

In this course, we will lay the foundation for understanding the dynamic field of operations and supply management

5

(3 Ratings)

Price

$15

Dr. Anastasia Maga

The Financial Management course focuses on the financial management of an organization and encompasses the full range of financial management techniques, including analysis, planning, and control.

5

(3 Ratings)

Price

$15

Find the right course for you

Answer a few questions to get personalized recommendations.

Get Started Dismiss

Welcome to Pedagog! I'm Lexi, the Pedagog Support bot 🤖