Learn Excel 2016 Formulas & Functions in Only 90 Minutes
4.7 (11 ratings)
56 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel 2016 Formulas & Functions in Only 90 Minutes to your Wishlist.

# Learn Excel 2016 Formulas & Functions in Only 90 Minutes

Quickly take control of Excel's powerful math features, for Windows and Macintosh
4.7 (11 ratings)
56 students enrolled
Created by Bob Flisser
Last updated 8/2016
English
Current price: \$10 Original price: \$30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 3.5 hours on-demand video
• 44 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• 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.
View Curriculum
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.
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.

Who 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.
Compare to Other Excel Courses
Curriculum For This Course
31 Lectures
03:19:37
+
Course Introduction
1 Lecture 01:16
Preview 01:16
+
Writing Simple Formulas
6 Lectures 31:44
Chapter 1 introduction
00:15

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.

How do you write a formula?
01:25

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

How to do basic adding and subtracting
07:31

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.
Use a formula to join text content
06:44

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

Learn how functions work
05:27

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.

Why you sometimes need absolute references
10:22

Test your knowledge of chapter 2.

Chapter quiz
3 questions
+
Commonly-Used Functions
6 Lectures 39:37
Chapter 2 Introduction
00:28

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

How to calculate averages
04:20

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

How to find the highest, lowest and quantity of values
06:34

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

Computer dating: functions to insert and calculate dates
10:54

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

Create automatic subtotals
08:51

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

Write formulas that span multiple worksheets
08:30

Test your knowledge of chapter 3.

Chapter quiz
3 questions
+
Functions that Make Decisions
6 Lectures 40:32
Chapter 3 introduction
00:16

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

Preview 08:28

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

SUMIF and AVERAGEIF: sums and averages that depend on a condition
05:44

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

New for 2016: IFS and SWITCH to cure nested IF statements
10:25

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

New for 2016: MAXIFS and MINIFS find highest and lowest with multiple criteria
04:33

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.

Using VLOOKUP to create a lookup table
11:06

Test your knowledge of chapter 4.

Chapter quiz
3 questions
+
Using Math, Statistical, Financial and Text Functions
8 Lectures 57:44
Chapter 4 introduction
00:12

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

Preview 09:02

Learn how to calculate four common statistical functions.

Functions for correlation, standard deviation, median and nth-largest
12:16

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

Calculate the monthly payment on a loan
12:31

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

Use Net Present Value to measure the quality of an investment
03:41

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

Use a function to customize the display of error messages on a sheet
06:35

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

Methods for extracting text
12:57

Thank you and goodbye (for now)
00:30

Test your knowledge of chapter 5

Chapter quiz
3 questions
+
Using Tables and Creating Macros
4 Lectures 28:44

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.

Using tables for sorting data
08:02

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

Introduction to macros
01:21

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

Recording a simple macro
10:06

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.

Editing macros using VBA
09:15

Test your knowledge of chapter 6.

Chapter quiz
3 questions