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 ) 329 students enrolled
Reviewed on 2021-02-05 12:09:53 Last updated on 2025-04-29 16:48:30 English
What I will learn?

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
  •     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
  •     10. Competitive Advantage: Understand Inconsistencies, Part -1 4
  •     11. How To Deal With Inconsistencies, Part- 2 8
  •     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
  • No Requirements
+ View More
Course Objective
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 $22
(Non Credit)

You are not logged in !

Add to cart
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

$ 2664.8 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

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.

5

(11 Ratings)

Price

$15

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

TEST INSTITUTE

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

Prof. Dr. Edward Roy Krishnan

This course teaches you how to start and grow your own business from the scratch. It provides time-tested blueprint for a successful startup.

5

(3 Ratings)

Price

$120

Find the right course for you

Answer a few questions to get personalized recommendations.

Get Started Dismiss