Learn Excel 2016 Formulas & Functions in Only 90 Minutes

Quickly take control of Excel's powerful math features, for Windows and Macintosh
4.8 (10 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.
41 students enrolled
Instructed by Bob Flisser IT & Software / Other
$19
$30
37% off
Take This Course
  • Lectures 31
  • Length 3.5 hours
  • Skill Level Intermediate Level
  • 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 3/2016 English

Course Description

To be a more proficient Excel user and add value to your job or career, you should know how to use Excel's math capabilities. That means writing formulas and using functions, some of which are new in Excel 2016. It doesn’t have to be complicated or scary, and with this course’s friendly, understandable and approachable style, you can quickly become an Excel expert. In 4 chapters, we will learn 30 built-in functions useful in different fields, industries, careers and tasks, and will learn efficient, time-saving techniques. You get 90 minutes of videos with new and completed class files and a reference guide.

What are the requirements?

  • Before starting this course, you should know the basics of Excel, including how to open, save and close files, how to enter text and numbers on a worksheet, and how to edit cells. The course begins with a brief refresher on how to enter basic formulas.

What am I going to get from this course?

  • Write basic formulas for addition, subtraction, multiplication and division.
  • Learn new functions introduced in winter 2016.
  • Write formulas that combine and split text.
  • Understand how to use any function.
  • Use statistics formulas, like AVERAGE, VARIANCE and STANDARD DEVIATION.
  • Calculate subtotals.
  • Write functions that make decisions, like IF and SUMIF.
  • Create LOOKUP tables
  • Use exponents, square roots and logarithms.
  • Use financial functions to calculate payments and rate of return.
  • Control the display of error messages.

What is the target audience?

  • This is a level 2 course, so take it if you’ve already completed an introductory course or have experience using basic Excel tasks.

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: Course Introduction
Welcome!
Preview
01:16
Section 2: Writing Simple Formulas
Chapter 1 introduction
00:15
01:25

If it’s been a while since you’ve used Excel or if you just learned the fundamentals, this lesson gives you a short review of the basics.

07:31

Add and subtract numbers on a simple worksheet. Learn how to save time with the AutoFill feature.

06:44
You can use formulas to manipulate text, as well as numbers. In this lesson, you'll combine a column of first names and a column of last names into one column of full names.
05:27

Excel has over 400 built-in functions. This lesson shows you the starting point for how they all work.

10:22

Usually, you want Excel to rewrite your formulas when you copy and paste and move data around. Learn how to prevent that from happening when the need arises.

3 questions

Test your knowledge of chapter 2.

Section 3: Commonly-Used Functions
Chapter 2 Introduction
00:28
04:20

Calculating averages manually can lead to incorrect results. Learn how to use a function that gets it right.

06:34

In a range of cells, find the highest and lowest numbers, and count how many there are.

10:54

Learn the functions and formulas to calculate and manipulate dates and time.

08:51

Let Excel create automatic subtotals and other calculations in a long worksheet.

08:30

We'll show you how to write formulas that can span multiple worksheets and even multiple workbooks.

3 questions

Test your knowledge of chapter 3.

Section 4: Functions that Make Decisions
Chapter 3 introduction
00:16
08:28

Use the IF function when you want the value of one cell to depend on the value of another cell.

05:44

Combine the SUM and AVERAGE functions with the decision making ability of the IF function.

10:25

New functions for 2016! Evaluate several criteria at once without complicated formula nesting.

04:33

New functions for 2016! Find the highest or lowest number in a range based on a value that you specify.

11:06

VLOOKUP lets you use Excel as a small database. Enter one piece of information and Excel will use that to return other information for that row.

3 questions

Test your knowledge of chapter 4.

Section 5: Using Math, Statistical, Financial and Text Functions
Chapter 4 introduction
00:12
09:02

Use functions that calculate exponents, square roots, common, natural and any-base logarithms.

12:16

Learn how to calculate four common statistical functions.

12:31

Plug in the amount you're borrowing, the interest rate and payback period to find out how much the payments will be.

03:41

Is an investment worth the money? Use a net present value calculation to help you decide.

06:35

Use a function to make the worksheet display helpful messages instead of errors.

12:57

Use some of Excel's powerful functions for manipulating text… and learn how to cheat!

Thank you and goodbye (for now)
00:30
3 questions

Test your knowledge of chapter 5

Section 6: Using Tables and Creating Macros
08:02

A whole Excel worksheet might look like a table, but tables have specific features that let you manipulate, sort, format and manipulate data like a small database.

01:21

Brief introduction to what macros are, how to create and edit them, and how to store them.

10:06

The most simple way to create a macro is by recording your keystrokes and mouse clicks. You can them play them back later.

09:15

To edit macros or write them from scratch, you use Visual Basic for Applications (VBA). It's a programming language used by all the Microsoft Office applications. In this lesson, we go into the VBA editor to examine the code Excel created when we recorded the macro in the previous lesson, and make two changes to the code.

3 questions

Test your knowledge of chapter 6.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bob Flisser, Trainer, author, web & multimedia developer

Bob Flisser has been a trainer and technical writer since the 1980s. He currently has over a dozen video courses released by several commercial publishers, and was the co-author of a series of books of tips and shortcuts for Microsoft Word, Excel, PowerPoint, and Windows. He has also written magazine articles and training manuals, and created training centers for companies large and small.

Since 1995, Bob has been the vice president and the web and multimedia developer at Software School, Inc., a software training and graphic design company in New Jersey. He is also a board member of the Mediatech Foundation, which provides free technology access to his community.

Bob is a graduate of The George Washington University with a degree in financial economics and international business.

Ready to start learning?
Take This Course