Master Excel Spreadsheets With Ease

Learn Excel from scratch and succeed! Microsoft Excel tutorial that quickly takes your Excel skills to the next level.
4.9 (32 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.
1,318 students enrolled
$30
Take This Course
  • Lectures 33
  • Contents Video: 4.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course Description

Over 1,200 people like you have already taken this course. Why? Because it's easy to understand.

You may be asking yourself: What is the easiest way to learn Excel? Where do I begin? How do I build a spreadsheet? What is the best way to enter data in Excel? Are there any shortcuts? Which formulas and functions do I need to know? What is Excel VLOOKUP? What is Excel table array? How do I use the IF function? What the heck are AND, OR functions?

If these questions sound familiar, this course is for you. It begins as a basic Excel tutorial and quickly takes you to the next level of Excel knowledge and expertise.

What will happen during this course?

1. You will watch high-quality instruction videos that are clear and to the point.

2. You will practice what I teach you using the sample files that I provide.

3. You will learn tricks and shortcuts that will save you time.

4. You will discover that Excel can actually be fun!

What will happen after you take this course?

1. You will realize that you are much more comfortable with Excel.

2. Projects that once took days will now only take hours.

3. Your colleagues and your boss may be surprised!

This Excel course is one of the Easy Excel With Igor series. Igor's other high quality Excel tutorials include: "Data Manipulation In Excel" which shows you how to save up to 90% of time when using Excel for certain data management tasks; "Excel Conditional Formatting Master Class" where you can learn how to improve your spreadsheets using conditional formatting in Excel; "Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering data-crunching skills in Pivot Tables; “Microsoft Excel Charts Master Class" that builds your skills in creating Excel charts and graphs.

What are the requirements?

  • Basic computer skills are a prerequisite for this course. Such as: clicking, dragging, and dropping.

What am I going to get from this course?

  • Develop skills in Excel tools
  • Learn how to create and use Excel formulas
  • Become familiar with most important Excel functions
  • Learn Excel best practices
  • Learn Excel tips and tricks

What is the target audience?

  • Beginners who want to master Excel quickly.
  • Everyone who is looking for a better way.
  • Those who search for a friendly Excel tutorial.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: A Few Things Before We Begin
01:37

Welcome to the Easy Excel Foundation course!

05:57

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

02:24

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.

Section 2: First Things First
13:18

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

15:32

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

09:14

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.

15:35

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

09:41

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

Section 3: Formulas - The Power Of Excel
07:07

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.

06:44

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.

19:53

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.

11:07

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

09:51

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.

Section 4: Working With Dates
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.

Section 5: Logical Functions
04:42

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

05:08

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.

10:17

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.

06:45

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.

Section 6: Conditional Statistical Functions
08:50

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.

06:04

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.

08:38

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

04:04

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.

Section 7: VLOOKUP Function Tutorial
08:16

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.

06:46

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.

04:48

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.

05:29

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.

05:35

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.

Section 8: Loan Payment Calculations With PMT
08:33

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.

05:41

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.

Section 9: A Few More Important Things
19:23

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.

12:58

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.

01:06

A few closing remarks.

Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course