Master Excel Functions

Learn how to use Excel Functions and formulas to increase your ability to manipulate data.
3.6 (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.
122 students enrolled
$20
Take This Course
  • Lectures 71
  • Contents Video: 4.5 hours
  • 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 3/2015 English

Course 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!

What are the 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.

What am I going to get from this course?

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

What 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

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: Complete Tutorial on 50 most common Excel function
01:22

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

02:32

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

01:13

Learn how to average numbers with the AVERAGE Funciton

02:42

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

02:58

Learn to combine fields with the CONCATENATE Function

01:19

Learn how to use the COUNT function in counting your data

01:09

Learn how the COUNTA Function will count non blank cells

01:04

Learn the COUNTBLANK function and see how it counts blank cells

02:14

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

02:19

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

01:48

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

03:05

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

02:19

Learn how the FIXED function will round numbers

03:40

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

03:19

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

03: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

03:58

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

01:22

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

02:36

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

02:19

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

02:49

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

02:05

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

01:36

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

01:25

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

03:53

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

MAX Function
02:05
01:48

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

02:07

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

00:45

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

05:09

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

02:23

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

02:12

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

01:20

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

01:41

Learn how to get a random number from the RAND Function

01:34

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

03:01

Learn how to replace parts of text with the REPLACE Function

01:09

Learn how to repeat text with the REPT Function

01:38

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

01:52

Learn how to round numbers with the ROUND Function

01:19

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

01:16

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

02:20

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

02:01

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

02:58

Learn how to substitute text within text using the SUBSTITUTE Function

01:41

Learn how to add up numbers based on a criteria

01:31

Learn how to add numbers with the SUM Function

02:44

Learn how to add up numbers based on multiple conditions

01:04

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

01:28

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

06:31

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

Section 2: Excel Function Tips and Tricks
11:06

Learn the difference between absolute cell reference and relative cell reference

04:49

Learn how to use formulas in Arrays

14:10

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

02:39

Learn how formulas work when using a formatted table

05:05

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

06:01

Learn the step by step way to nesting an IF Statement

09:00

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

04:19

Learn how to use Paste Special with Formulas

02:05

Learn all about the Status Bar

15:01

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

Section 3: Advanced Excel Functions
03:18

Learn how to randomly choose among your choices your supply

05:02

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

03:13

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

09:47

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

15:07

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

03:38

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

Section 4: Real world Examples with Questions to help learn
10:18

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

12:11

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

08:04

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

10:28

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

04:26

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Joe Zawada, 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.

Ready to start learning?
Take This Course