Excel Afterburner - beginner to speed demon in hours
4.6 (20 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.
147 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Afterburner - beginner to speed demon in hours to your Wishlist.

Add to Wishlist

Excel Afterburner - beginner to speed demon in hours

All of the most useful features, the quick way. All revenue goes to charity.
4.6 (20 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.
147 students enrolled
Created by Ezra Okon
Last updated 2/2016
English
Price: $35
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Speed through excel formatting and calculations
Use advanced functions to arrive at solutions from complicated data sets
Use pivot tables and LOOKUP functions to summarize large data sets quickly
Present data and solutions in beautiful charts and graphs
View Curriculum
Requirements
  • Students need to have a version of excel (preferably more recent than Excel '97) downloaded on their computer
Description

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

This course is 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
  • You don't recognize or use the Paste Special, HLOOKUP, INDEX, VLOOKUP, Conditional, Filter, or Pivot Table features, among other very important features.

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

Who is the target audience?
  • YOU CAN BENEFIT if you don't use conditional or lookup formulas frequently
  • YOU CAN BENEFIT if you rely on the mouse to complete your excel work
  • YOU CAN BENEFIT if you are either a complete beginner, or have not used excel for significant portions of your work
  • Your money is guaranteed by a full refund; if you decide that you are too advanced after buying the course, you are welcome to request a refund
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 16 Lectures Collapse All 16 Lectures 01:32:59
+
Course Introduction
16 Lectures 01:33:00

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





Preview 03:25

Please download the two attached sheets - the exercises, and the reference sheet.

Download the exercises and reference sheet
00:06

This lecture covers:

  • Navigating through excel cells faster than you ever imagined, without a mouse!
  • Highlighting large groups of cells quickly
  • Changing colors and basic formatting of highlighted cells
  • Introduction to the excel maze

By the time you solve the maze, you'll be ready to move on!

Preview 03:01

Through a paint-by-numbers game, this lecture covers:

  • Color formatting
  • The 'repeat action' tool which will speed every repetitive task up
  • Conditional formatting to change cell colors and formats dynamically and automatically, based on their contents
Preview 04:00

Get supreme control over your sheets using this awesome feature to eliminate hours of wasted time. Paste Special is much more than copy/paste - it will let you reorganize, reformat , protect, and perform math on large amounts of data/cells at once!

Exercise 3 - Paste Special
04:45

Ensure your understanding of the critical Paste Special feature with a few fun games

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

Take a formatting quiz to gauge your speed. Continue to practice this, and see how much your time improves!

If you'd like to make it on the leader board:
- Complete the formatting quiz while recording your screen (Screencast-o-matic offers an easy, free recording tool)
- Message me with a link to your video, either on Vimeo, Youtube, or some other platform

Formatting quiz!
04:03

Learn how to add a formula in a cell. This lesson will cover most basic formulas that you will use on a regular basis.

Exercise 5 - Basic Functions
06:02

Don't waste time typing formulas over and over! Locking and dragging cells is one of the biggest time-savers excel offers you.

Exercise 6 - Dragging and Locking Cells
10:02

A rapid-fire list of all of the formulas you will need, and practice with each one.

Exercise 7 - Rapid Function Practice
05:44

Now you're getting really advanced - learn to use formulas to skim through large amounts of data, and conditionals to return answers based on your inputs.

We also cover Data Validation, which is some 'frosting' - use this with your lookups to really impress your friends!

Exercise 8 - Lookup and Conditional Functions
10:31

You're almost an excel Jedi! You can reduce the mess on your spreadsheet and increase the power of your functions by learning how to nest one into another!

This can get confusing even for the most advanced users, but my simple method will take the headache away.

Exercise 9 - Nesting Formulas, and data filtering
10:53

Pivot tables are one of the fastest ways to rearrange, sum, and perform operations on thousands of lines of data at once. There's no easier way to get insight from an otherwise headache-causing list of data.

We'll cover charts briefly, which will allow you to cleanly present the data.

Exercise 10 - Pivot tables and Charts
08:33

Exercise 11 - Working with data
00:08

The answers to exercise 11, your final test! You've combined your knowledge, now see if you are right!

Exercise 11 answers - Working with data, and combining your knowledge
19:50

The end!
00:16
About the Instructor
Ezra Okon
3.9 Average rating
81 Reviews
2,337 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.