Master Excel Functions
3.3 (4 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.
148 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Excel Functions to your Wishlist.

Add to Wishlist

Master Excel Functions

Learn how to use Excel Functions and formulas to increase your ability to manipulate data.
3.3 (4 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.
148 students enrolled
Created by Joe Zawada
Last updated 2/2015
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
11 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Manipulate Data better using Excel functions and Formulas
  • Understand how Excel Functions work
  • Understand how to combine multiple functions in one cell
View Curriculum
Requirements
  • Need to have Microsoft Excel 2003 or greater. Preferably 2007 or greater to follow along.
  • Just very basic knowledge of Excel needed. No knowledge of Excel functions needed.
Description

This course helps to teach you how to learn Excel Functions and Formulas. You will learn how to take that knowledge and apply it to everyday examples to show how you can use it at work.

In this course, you will learn:

  1. the 50 most common Excel functions
  2. The basics needed to get the most out of Functions
  3. Advanced and nested functions to truly show their power
  4. Real World examples to show how to apply it to your job

You should get this course because I have taught Excel to accountants for many years. I go slow enough and show every step, to help beginners understand. But I also go in depth for more advanced users to benefit.

This course is made up of over 4 hours of video and over 100 pages of screenshots and writing to help explain what Excel functions are all about. Get this course and I know you will increase your Excel knowledge!

Who is the target audience?
  • This course is for people who want to learn how to manipulate data better by using Excel Functions
  • This course is for people who use Excel for their job but need help understanding it's functionality
  • This course is also for people who use Excel occasionally but just want a better understand of it
  • This course is not tailored for advanced users who know most of the advanced features.
  • This course is for people who consider themselves beginners or intermediate in Excel and want to improve their understand to stand out in their job
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 71 Lectures Collapse All 71 Lectures 04:31:30
+
Complete Tutorial on 50 most common Excel function
50 Lectures 01:51:43

You will learn how the ABS function works and will be able to get the absolute value of any number.

Preview 01:22

Learn how to use the AND function to get TRUE or FALSE results

Preview 02:32

Learn how to average numbers with the AVERAGE Funciton

Preview 01:13

Learn how the CHOOSE function will pick from choices you give it.

Preview 02:42

Learn to combine fields with the CONCATENATE Function

Preview 02:58

Learn how to use the COUNT function in counting your data

COUNT Function
01:19

Learn how the COUNTA Function will count non blank cells

COUNTA Function
01:09

Learn the COUNTBLANK function and see how it counts blank cells

COUNTBLANK Function
01:04

Learn how to use the COUNTIF function to count numbers based on criteria in a cell

COUNTIF Function
02:14

Learn how to use the COUNTIF function to count numbers based on criteria in multiple cells

COUNTIFS Function
02:19

Learn how the EXACT function will tell if two strings are exactly alike

EXACT Function
01:48

Learn how the FIND function will find something within a cell and tell you where it is

FIND Function
03:05

Learn how the FIXED function will round numbers

FIXED Function
02:19

Learn how the HLOOKUP function works for pulling data horizontally from tables

HLOOKUP Function
03:40

Learn how the IF function operates and checks criteria to give a TRUE or FALSE result

IF Function
03:19

Learn to use the IFERROR function to check your formulas for errors and return a value of your choice if there is an error

IFERROR Function
03:00

Learn how the INDEX function returns a value from an array of values

INDEX Function
03:58

Learn how the ISBLANK function returns a TRUE or FALSE if the cell is blank or not.

ISBLANK Function
01:22

LEARN about the ISERROR function and how it tells you if there is an error

ISERROR Function
02:36

Learn how the ISNA function checks for the #N/A error and returns TRUE or FALSE

ISNA Function
02:19

Learn about the LARGE Function and how it will pull one of the largest values in a range, based on your criteria

LARGE Function
02:49

Learn about the LEFT Function and see how it pulls the leftmost characters of a word

LEFT Function
02:05

Learn about the LEN Function and see how it will count th number of characters in a cell

LEN Function
01:36

Learn how the LOWER function will convert all characters to lower case.

LOWER Function
01:25

Learn how the MATCH function will find a cell in an array of cells and return its position in that array

MATCH Function
03:53

MAX Function
02:05

Learn how to use the MID function to return the middle number in an array

MID Function
01:48

Learn how to get the lowest value in a range with the MIN Function

MIN Function
02:07

Learn how the NOW function gives you the current time and date

NOW Function
00:45

Use the OFFSET Function to return a cell or range of cells

OFFSET Function
05:09

Learn how to use the OR Function to give you TRUE or FALSE based on your criteria

OR Function
02:23

Learn the PRODUCT function to give you the result of multiplying numbers

PRODUCT Function
02:12

Learn how the PROPER function will change the case of text to its correct way

PROPER Function
01:20

Learn how to get a random number from the RAND Function

RAND Function
01:41

Learn how to get a whole random number from 1 to x with the RANDBETWEEN Function

RANDBETWEEN Function
01:34

Learn how to replace parts of text with the REPLACE Function

REPLACE Function
03:01

Learn how to repeat text with the REPT Function

REPT Function
01:09

Learn how to get the rightmost characters from text with the RIGHT Function

RIGHT Function
01:38

Learn how to round numbers with the ROUND Function

ROUND Function
01:52

Learn how to round down to a number with the ROUNDDOWN Function

ROUNDDOWN Function
01:19

Learn how to round up to a number with the ROUNDUP Function

ROUNDUP Function
01:16

Learn how the SEARCH function will find an item in a cell and return its position

SEARCH Function
02:20

Learn how to get the smallest, 2nd smallest, 3rd ...value in a range

SMALL Function
02:01

Learn how to substitute text within text using the SUBSTITUTE Function

SUBSTITUTE Function
02:58

Learn how to add up numbers based on a criteria

SUMIF Function
01:41

Learn how to add numbers with the SUM Function

SUM Function
01:31

Learn how to add up numbers based on multiple conditions

SUMIFS Function
02:44

Learn how to get Today;s date with the TODAY Function

TODAY Function
01:04

Learn how to get your text into ALL caps with the UPPER Function

UPPER Function
01:28

Learn how to pull in data from another table with the VLOOKUP Function

VLOOKUP Function
06:31
+
Excel Function Tips and Tricks
10 Lectures 01:14:15

Learn the difference between absolute cell reference and relative cell reference

Absolute verse Relative Cell Reference
11:06

Learn how to use formulas in Arrays

Using Arrays in formulas
04:49

Learn what the common Excel error messages mean and how to get around them

Common Excel Error Messages
14:10

Learn how formulas work when using a formatted table

Formulas in Formatted Tables
02:39

Learn what the most common VLOOKUP errors are and how to fix them

Common VLOOKUP Errors
05:05

Learn the step by step way to nesting an IF Statement

How to Nest an IF Statement
06:01

Learn how to name a Range of cells in Excel for use in Formulas

Naming a Range
09:00

Learn how to use Paste Special with Formulas

Paste Special
04:19

Learn all about the Status Bar

Status Bar
02:05

Learn how to deal with multiple matches when doing a VLOOKUP statement

Multiple Matches with VLOOKUP formulas
15:01
+
Advanced Excel Functions
6 Lectures 40:05

Learn how to randomly choose among your choices your supply

CHOOSE...RANDBETWEEN
03:18

Learn how to use these two functions to check for errors in your spreadsheet and replace the errors

IF...ISERROR
05:02

Learn how to check for multiple criteria in your IF statements without having to nest IF Statements

IF...AND
03:13

Learn how to use this powerful multi function to pull information from tables. This will replace VLOOKUP.

INDEX...MATCH
09:47

Learn how to pull in a cell or multiple cells of information from other tables

OFFSET...MATCH
15:07

Learn this error fix for one of the most common VLOOKUP errors

VLOOKUP...TRIM
03:38
+
Real world Examples with Questions to help learn
5 Lectures 45:27

Learn how to break apart a phone number with text functions and count how many people meet certain criterias.

Real World Example 1
10:18

Learn how to calculate someone's age with date functions and use the VLOOKUP to pull over Employee data from a larger table.

Real World Example 2
12:11

Learn how to calculate a golfer's average score, calculate lowest and 3rd lowest score and count the number of golfers that meet certain criterias

Real World Examples 3
08:04

Learn how to calculate bonuses on sales using the AND statement and nested If's

Real World Examples 4
10:28

Learn how to count the length of User Id's and shorten or replace them if too long.

Real World Examples 5
04:26
About the Instructor
Joe Zawada
3.3 Average rating
4 Reviews
148 Students
1 Course
Excel Specialist

I have used and trained Microsoft Excel in an Accounting environment for 15 years. In that time I have learned how to use many of the Excel functions in order to help me manipulate my financial data better. I work on many spreadsheets in my office and have helped many accountants to work more efficient by teaching them tricks and tips in Excel.

I have also worked a lot with pivot tables and interactive dashboards to display financial information. All of these skills have helped me to master so many aspects of Excel to enable me to work more efficiently and also to train other accountants in using Excel.

In addition to training people in my office, I also do freelance Excel work for other companies when they need an excel expert. Additionally I write tutorials and make videos and post on a blog to help train more people in using Excel.