Excel Afterburner Fundamentals
3.5 (62 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.
2,227 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Afterburner Fundamentals to your Wishlist.

Add to Wishlist

Excel Afterburner Fundamentals

Triple your excel speed in 2 hours
3.5 (62 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.
2,227 students enrolled
Created by Ezra Okon
Last updated 2/2016
English
Price: Free
Includes:
  • 31 mins on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to triple your excel speed without using the mouse
  • Move and manipulate large amounts of data in seconds
  • Build exposure to basic functions
View Curriculum
Requirements
  • Students will need to have Microsoft Excel downloaded on their computer. It doesn't matter what version!
Description

100% of all my course revenue will be donated. Why? Read on...

This course is a preview to my full Excel Afterburner class

It's right for you if:

  • You've never used excel before
  • You rely on the mouse to get your work done
  • You wonder if there are ways to get your work done more quickly

This course is based on the training Wall Street bankers use to become the fastest and most productive excel users in the world. You will learn to quickly navigate your excel sheets, organize/format data, calculate/solve problems confusing problems, and present your data beautifully..

The quick exercises are specifically designed to build off of each other so that you get continued practice on the basics as you get more advanced.

I have been extremely fortunate in my career to graduate from Harvard Business School and work for some of the top companies in the world. I didn't originally come from an ivy league school; in fact, I was rejected from most universities and jobs I applied to. I know how hard it can be to propel yourself forward, and many people helped me get where I am today.

I will give 100% of my tuition to Kiva, an organization that helps educate and secure financing for business owners in impoverished areas. That way, you can help others while you're learning yourself.

Once you've completed this course, check out my others to advance your skills!

Who is the target audience?
  • This course is meant either for excel beginners, or excel users who rely on the mouse to get their work done. See my other courses for more advanced excel learning
Compare to Other Excel Courses
Curriculum For This Course
+
Background information and course materials
2 Lectures 03:31

This lecture covers:
- How to use the course resources (shortcut and exercise files)
- How to enter text in cells
- How to edit cells
- PC vs. Mac
- The Excel ribbon vs. the older toolbar
- Basic cell navigation

Introduction
03:25

Download the exercises and the reference sheet
00:06
+
Course lectures and exercises
9 Lectures 27:37

Learn to navigate through excel without a mouse, using your arrow keys. To make things even faster, you'll learn how to jump THROUGH large blocks of cells, to get right where you need to go.

Exercise 1 - Navigation maze (keyboard navigation shortcuts)
03:01

Learn various methods of formatting cells, including Conditional Formatting, where you can teach excel to format cells for you automatically

Exercise 2 - Paint by Number (quick formatting, and conditional formatting)
04:00

Learn Paste Special, one of the most powerful tools to prevent you from repeating repetitive formatting or function tasks.

Exercise 3 - Paste Special
04:45

Play some fun games using Paint Special

Exercise 4 - Pick and Pop (a past special game)
01:40

See how fast your formatting has gotten, with a challenge!

Formatting quiz
04:03

Learn the basics of functions and formulas, the tools that make excel one of the most powerful systems in the world for analysis.

Exercise 5 - basic functions
06:02

Now that you've learned the basics, here are some fun excel pranks you can play on your friends!

Fun excel pranks
03:22

Congratulations!
00:36

Congratulations on finishing! This course only touches on the power of excel. Take my other courses to learn many more tips and tricks to make you the most expert excel user in your workplace!

My other available courses
00:08
About the Instructor
Ezra Okon
4.4 Average rating
89 Reviews
2,394 Students
2 Courses
Harvard MBA and Business Educator

100% of my course revenue will be donated. Read my story to find out why...

I started my career getting rejected from most universities and jobs I applied to. Eventually, I was able to overcome the odds and graduate with an M.B.A from Harvard Business School, and work at some of the top financial, industrial, and consulting firms in the world.

Breaking through was not easy - most people starting in top schools and firms develop in an environment where they are taught to think, speak, and walk the way that investors, recruiters, and admissions officers would expect you to. For someone without experience, it takes a significant amount of money and time to achieve the same development.

The secret to my turnaround was learning to educate myself to the point where I could be a resource for others. I struggled through self-learning tutorials, textbooks, and expensive online courses so that I could start to be viewed as a supply of knowledge, and gain confidence and respect.

I've spent years developing courses to educate students and small business owners outside of 'Tier I' networks. I know how difficult it was for me to teach myself the necessary skills, so I focus on efficiency, speed, and practicality in all of my courses.

My goal now is to make it easier for other to break into their own 'Tier I' network. I'm putting all of my course material online for an affordable price. Any revenue that I collect from these courses will be given to Kiva.org, an organization that helps small business owners in impoverished countries secure loans to improve their own lives.

By taking my courses, you are helping someone else's career while you help your own.