Learn Excel Fast
4.4 (55 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,377 students enrolled

Learn Excel Fast

Discover the amazing power that lies hidden inside Excel, put it at your fingertips and tap into it any time you want
4.4 (55 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,377 students enrolled
Created by Igor Ovchinnikov
Last updated 4/2016
English
English
Current price: $44.99 Original price: $64.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 article
  • 22 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

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

Try Udemy for Business
What you'll learn
  • Discover and quickly tap into the astonishing, jaw-dropping power of Microsoft Excel! (You can tame it in a short afternoon!)
  • How to look and feel like a math wizard—even if you flunked math at school. (That’s what Excel is really for!)
  • How to quickly ease your mind into the wonderful world of Excel. (So you can immediately begin to take advantage of it—even if you are a complete rookie)
  • Amazing powerful shortcuts that make all the difference in the world for those who want to seriously get productive in Excel.
  • How to instantly make sense out of the mysterious universe of Excel formulas and functions. (The "myst" will start clearing soon!)
  • A dirty little secret of that arrogant computer geek from the next-door cubicle. (HINT: He does not know everything!)
  • Simple yet powerful tips and tricks to save you tons of time—you’ll smile to yourself every time you use them.
  • How to "tickle" your creative side to solve everyday Excel-workflow problems better than you ever dreamed possible.
  • How to start having fun at work when you're actually getting stuff done. (HINT: It feels delightful!)
Requirements
  • You must have an open mind so you are able and willing to learn what I am about to teach you!
  • You must have basic computing skills snugly under your belt. (So you are ready to proceed to the higher level)
  • You must have Excel installed on your computer because you'll need to practice what you'll learn
Description

Do you want to learn Excel fast?

If the answer  is “yes,” I have a good news for you!

It’s absolutely possible to jump right in and learn Excel fast! Extremely fast!

I know, you may not immediately believe me. After all, Excel is a very complex application with tons of mysterious functionality hiding deep under the surface. It has a confusing labyrinth of secrets lurking inside. And, frankly, it feels very nerdy.  

If you’re like my other smart students who had tried to conquer it “intuitively” and hit a snag, you probably already know how confusing it can be.

Well... that’s exactly why I’m suggesting that you take this course.

I believe it will help you gently ease your mind into the powerful world of Microsoft Excel. So you can finally begin to create beautiful spreadsheets. The best part: you don’t have to work hard to reveal its secrets.

In fact, you can be ready to do wonderful pro-level things with Excel in less than five enjoyable hours that you’ll spend with this course—even if you’re a total rookie and have never opened your mind to conquering it before right now.

In this easy-to-follow training you begin to discover the amazing power that lies hidden inside your Excel—which you can learn to harness and leverage for your own professional and personal advantage if you choose.

I’ll show you how you can immediately tap into that power with ease and have lots of fun playing with it any time you choose as well.

I also guarantee that a wealth of pleasantly valuable discoveries awaits you inside. This course is not simply a goldmine of crystal-clear instruction. It’s your self-paced program to learn the most important Excel tools and techniques step-by-step—without confusion.

In other words, it’s a collection of the most important fresh-out-of mint gold bars that you can stash in you professional tool box.

Here’s just a handful of what you are getting in this course...

  • How to tap into the astonishing, jaw-dropping power of Microsoft Excel! (You can tame it in a short afternoon!)

  • How to quickly ease your mind into the wonderful world of Excel. (So you can immediately begin to take advantage of it—even if you are a complete rookie)

  • Amazing powerful shortcuts that make all the difference in the world for those who want to seriously get productive in Excel.

  • How to instantly make sense out of the mysterious universe of Excel formulas and functions. (The "myst" will start clearing soon!)

  • A dirty little secret of that arrogant computer geek from the next-door cubicle. (HINT: He does not know everything!)

  • Simple yet powerful tips and tricks to save you tons of time—you’ll smile to yourself every time you use them.

  • How to stimulate your creative side to solve everyday Excel-workflow problems better than you ever dreamed possible.

  • How to look and feel like a math wizard—even if you flunked math at school. (That’s what Excel is really for!)

  • How to start having fun at work when you're actually getting stuff done. (HINT: It feels delightful!)

  • Which Excel functions are absolutely crucial to master right away! (They are "written in blood" in some job descriptions.)

Who this course is for:
  • You want a quick way to ease your mind into Excel. So you can get exactly what you want from it. (Even if you’ve never set foot in it before)
  • You feel that you learn better with crystal-clear explanations. (So that not only you but even a child could understand it)
  • You enjoy learning face-to-face—when you can see your teacher, not just hear them.
  • You would like to proudly smile to yourself after talking to those Excel geeks because you finally feel you completely understand them.
  • You believe it’s time to catapult your Excel skill to a higher orbit. (But you prefer that I gently guide you there step by step)
  • You would like to discover astonishing shortcuts that might save you tons of time and effort. (Even if you are a complete rookie)
  • Which Excel functions are absolutely crucial to master at once! (They are "written in blood" in some job descriptions.)
Course content
Expand all 33 lectures 04:27:14
+ A Few Things Before We Begin
3 lectures 09:58

Welcome to the Easy Excel Foundation course!

Preview 01:37

A few quick tips about Udemy's interface. If you have been on Udemy for awhile, you can skip this lecture.

Preview 05:57

What is the best way to learn Excel online? We all learn in a little bit different ways. Here I give you a couple of tips of what works for me when I learn new things.

Preview 02:24
+ First Things First
5 lectures 01:03:20

We begin our Excel tutorial with a quick overview of the Excel user interface.

Preview 13:18

What are the best ways to enter data in Excel? Here we acquire some important points regarding data entry in Excel.

Preview 15:32

How to use Fill Series in Excel? Acquire a full understanding of how the fill-handle works in Excel and learn the ways it can help you do what you want.

Preview 09:14

Let's learn some important tips on how to select data in Excel and how to move around an Excel spreadsheet.

Preview 15:35

Here you begin to learn how to format Excel spreadsheets and their cells.

Easy Direct Formatting In Excel
09:41
+ Formulas - The Power Of Excel
5 lectures 54:42

Excel Formulas is what makes Excel so powerful. In this lecture you learn how formulas in Excel are working. You will create your first Excel formulas in this lesson.

Easy Excel Formulas
07:07

If Excel formulas make Excel powerful and useful, Excel Functions make these formulas powerful and useful. Excel Functions are pre-built formulas that serve as building blocks of your creativity. We use Excel functions in formulas. It is very important to understand how Excel functions work. In this lecture you will learn to use Excel functions and will go through several examples.

Easy Excel Functions Basics
06:44

Excel cell references are the most fundamental Excel concept. Cell References in a formula are called the holy grail of Excel. In this lecture you will learn about Excel relative and absolute references and about how to use them in Excel formulas. It is important to become comfortable with them.

Relative And Absolute Cell References In Excel
19:53

AutoSum is the most common feature in Excel. Here you will explore the best practices and proven strategies when using AutoSum in Microsoft Excel.

Using AutoSum In Excel
11:07

Here we learn the so-called Excel Text functions. It is a category of Excel functions . These functions make it easy to manipulate data in Excel in a variety of useful ways. For example, how can I change case in Excel? You use Text Category of Functions. UPPER, LOWER, PROPER - these are examples of Excel Text Functions.

Easy Text Functions
09:51
+ Working With Dates
1 lecture 05:26

In this lecture you will learn how to use Excel NOW and Excel TODAY functions. It is a quick basic tutorial on these useful functions. These are examples of Excel functions that do not require any arguments to return a result. There are plenty of such functions in Excel. Their purpose is to provide automatically up-datable result that you can use in Excel formulas.

Excel TODAY and NOW Functions
05:26
+ Logical Functions
4 lectures 26:52

This lecture is the first look at Logical IF function in Excel. Logical IF function is one of the most common functions in Excel.

Logical IF Function Introduction
04:42

In this lecture we two logical Excel functions, one named Excel AND function and the other one Excel OR function. These Excel functions are useful in formulas that utilize the logical If function in Excel.

Excel Logical Functions: AND, OR
05:08

Here you learn how to use Excel's IF function in conjunction with logical AND function and OR function. These logical Excel functions make a powerful combination.

Using Logical Functions IF, AND, OR Together
10:17

Björn Már Sveinbjörnsson, one of your fellow students in this course, posed a question: How can we take a series of numbers in Excel and count all of the ones that are greater than 5 and less than or equal to 10. There are many ways to do it in Excel. Here you learn how to do it with the Excel IF function, the AND Function, and the SUM function.

Exercise Using IF AND SUM (courtesy of Björn Már Sveinbjörnsson)
06:45
+ Conditional Statistical Functions
4 lectures 27:36

In this lecture you will learn how to use condtional statistical functions SUMIF and SUMIFS. These useful Excel functions are used in formulas, where we need to sum selectively.

SUMIF and SUMIFS: Conditional Sum in Excel
08:50

We continue to learn Excel conditional statistical functions. This time we explore AVERAGEIF AND AVERAGEIFS. There are Excel formulas where these functions are extremely useful.

AVERAGEIF and AVERAGEIFS: Conditional Average
06:04

Let's continue to learn conditional statistical functions in Excel and take a look at the COUNTIF and COUNTIFS.

COUNTIF and COUNTIFS: Conditional Count
08:38

Now, as we are familiar with Excel COUNTIFS function, we are ready to solve Björn Már Sveinbjörnsson's problem with an easier and more direct Excel formula.

COUNTIFS Conditional Number Counting (courtesy of Björn Már Sveinbjörnsson)
04:04
+ VLOOKUP Function Tutorial
5 lectures 30:54

VLOOKUP in Excel is one of the most important and widely used functions. This section is a VLOOKUP tutorial. This lecture is an introduction to VLOOKUP Excel Function. You will learn how to use it and will get a good idea of how VLOOKUP Function is working and not working in Excel.

VLOOKUP Function Introduction
08:16

In this lecture we continue our Excel VLOOKUP Tutorial and take a look at how to fill data in Excel with VLOOKUP function. It is the most powerful use for this function in Excel.

Fill Data With VLOOKUP Function
06:46

Here you learn how to use VLOOKUP Excel Function with the approximate match option. You should be able to understand in what siituations the approximate match is useful.

Excel VLOOKUP With Approximate Match
04:48

In this lesson we will use a what's called Excel's Named Range as a data array for VLOOKUP. It is a better way than using Excel cells range reference and is considered to be one of the best practices in VLOOKUP.

VLOOKUP With A Named Range As Table Array
05:29

An Excel Table is a very interesting object. It is a, sort of, special purpose named range. In this lecture we go through using an Excel Table as a lookup table or the Table Array for VLOOKUP.

Use Excel Table In VLOOKUP
05:35
+ Loan Payment Calculations With PMT
2 lectures 14:14

Let's take a look at Excel financial functions. PMT is used to calculate the monthly payment on a loan. Let's use this common Excel function in a formula that helps us figure out how much we need to pay every month for a loan.

Monthly Loan Payment With PMT Function
08:33

Let's learn how to use the Goal Seek. It is a simple, but very powerful Excel tool. It allows you to perform reverse calculations in any Excel formula that you create.

Goal-Seek Analysis Tool
05:41
+ A Few More Important Things
4 lectures 34:12

In this lecture we look a bit more at formatting in Excel. We discover the concept of Excel Styles. I hope, you get some good ideas and tips on formatting Excel spreadsheets.

More on Formatting
19:23

Excel printing is not as easy as, lets say, that in Word. In this lesson you will begin to acquire the skill of printing in Excel.

Printing in Excel
12:58

A few closing remarks.

Preview 01:06
Bonus Lecture: Special Offers
00:45