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 ) 327 students enrolled
Reviewed on 2021-02-05 12:09:53 Last updated on 2024-04-25 01:33:41 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
  •     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
  • 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!



$25 $34
(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

$ 2648.6 Earned

1 Courses

Jasper Kingsley

MTech

More Recommended Courses

European International University - Paris

The course; Research Methodology: Quantitative and Qualitative Analysis has been 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 programme as it offers you a measure of control and autonomy over what you learn. Learn the best methods and principles required to conduct and compile effective research with this professional certificate online course by EIU-Paris.

5

(11 Ratings)

Price

$350

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

$25

Prof. Dr. Edward Roy Krishnan

There is no direction if there are no goals to achieve. An entrepreneur needs to set definite and specific goals for his/her personal life and business. This course will teach you important time-tested goal setting strategies that work wonders.

4

(5 Ratings)

Price

34

$25

Prof. Dr. Edward Roy Krishnan

Be an unstoppable entrepreneur. Get rid of burnouts. Erase self-doubts. This course helps you with techniques to achieve unlimited motivation and stay constantly inspired to do well in life, and business.

5

(4 Ratings)

Price

32

$20

Prof. Dr. Edward Roy Krishnan

Entrepreneurs are not born. They are made. Success in entrepreneurship can be learned. There are communities in the mindset and habits of successfully entrepreneurs. This course teaches you the attitudes and actions required to become a successful entrepreneur.

5

(6 Ratings)

Price

34

$25

Prof. Dr. Edward Roy Krishnan

Failure is a stepping stone to success. It is normal for entrepreneurs to fail. But every failure in a business should make an entrepreneur better in what he/she does. This course teaches you how to carefully anticipate business failures with the aim of averting them.

5

(3 Ratings)

Price

$25

Prof. Dr. Edward Roy Krishnan

Be an unstoppable entrepreneur. Get rid of burnouts. Erase self-doubts. This course helps you with techniques to achieve unlimited motivation and stay constantly inspired to do well in life, and business.

5

(2 Ratings)

Price

$25

Prof. Dr. Edward Roy Krishnan

Science proves that being grateful increases happiness. Gratitude moves people to experience more positive emotions, better health, increased resiliency, and improved relationships. This course teaches you how to achieve true and lasting happiness and greatness by being grateful in life.

5

(8 Ratings)

Price

32

$25

Find the right course for you

Answer a few questions to get personalized recommendations.

Get Started Dismiss