Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Master Excel Functions
Rating: 4.2 out of 5(39 ratings)
302 students

Master Excel Functions

Learn how to use Excel Functions and formulas to increase your ability to manipulate data.
Created byJoe Zawada
Last updated 2/2015
English

What you'll learn

  • Manipulate Data better using Excel functions and Formulas
  • Understand how Excel Functions work
  • Understand how to combine multiple functions in one cell

Course content

4 sections • 71 lectures • 4h 31m total length

  • ABS Function1:22

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

  • AND Function2:32

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

  • AVERAGE Function1:13

    Learn how to average numbers with the AVERAGE Funciton

  • CHOOSE Function2:42

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

  • CONCATENATE Function2:58

    Learn to combine fields with the CONCATENATE Function

  • COUNT Function1:19

    Learn how to use the COUNT function in counting your data

  • COUNTA Function1:09

    Learn how the COUNTA Function will count non blank cells

  • COUNTBLANK Function1:04

    Learn the COUNTBLANK function and see how it counts blank cells

  • COUNTIF Function2:14

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

  • COUNTIFS Function2:19

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

  • EXACT Function1:48

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

  • FIND Function3:05

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

  • FIXED Function2:19

    Learn how the FIXED function will round numbers

  • HLOOKUP Function3:40

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

  • IF Function3:19

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

  • IFERROR Function3:00

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

  • INDEX Function3:58

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

  • ISBLANK Function1:22

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

  • ISERROR Function2:36

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

  • ISNA Function2:19

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

  • LARGE Function2:49

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

  • LEFT Function2:05

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

  • LEN Function1:36

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

  • LOWER Function1:25

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

  • MATCH Function3:53

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

  • MAX Function2:05

    Master Excel's max function to identify the largest value in a range of numbers or dates, using ranges or individual inputs, as shown with 98 and October 6th.

  • MID Function1:48

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

  • MIN Function2:07

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

  • NOW Function0:45

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

  • OFFSET Function5:09

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

  • OR Function2:23

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

  • PRODUCT Function2:12

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

  • PROPER Function1:20

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

  • RAND Function1:41

    Learn how to get a random number from the RAND Function

  • RANDBETWEEN Function1:34

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

  • REPLACE Function3:01

    Learn how to replace parts of text with the REPLACE Function

  • REPT Function1:09

    Learn how to repeat text with the REPT Function

  • RIGHT Function1:38

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

  • ROUND Function1:52

    Learn how to round numbers with the ROUND Function

  • ROUNDDOWN Function1:19

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

  • ROUNDUP Function1:16

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

  • SEARCH Function2:20

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

  • SMALL Function2:01

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

  • SUBSTITUTE Function2:58

    Learn how to substitute text within text using the SUBSTITUTE Function

  • SUMIF Function1:41

    Learn how to add up numbers based on a criteria

  • SUM Function1:31

    Learn how to add numbers with the SUM Function

  • SUMIFS Function2:44

    Learn how to add up numbers based on multiple conditions

  • TODAY Function1:04

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

  • UPPER Function1:28

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

  • VLOOKUP Function6:31

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

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 this course is for:

  • 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

Report abuse