Master Excel Functions

Learn how to use Excel Functions and formulas to increase your ability to manipulate data.
3.6 (5 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.
134 students enrolled
25% off
Take This Course
  • Lectures 71
  • Length 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

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

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.


Section 1: Complete Tutorial on 50 most common Excel function

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


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


Learn how to average numbers with the AVERAGE Funciton


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


Learn to combine fields with the CONCATENATE Function


Learn how to use the COUNT function in counting your data


Learn how the COUNTA Function will count non blank cells


Learn the COUNTBLANK function and see how it counts blank cells


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


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


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


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


Learn how the FIXED function will round numbers


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


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


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


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


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


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


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


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


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


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


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


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

MAX Function

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


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


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


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


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


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


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


Learn how to get a random number from the RAND Function


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


Learn how to replace parts of text with the REPLACE Function


Learn how to repeat text with the REPT Function


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


Learn how to round numbers with the ROUND Function


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


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


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


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


Learn how to substitute text within text using the SUBSTITUTE Function


Learn how to add up numbers based on a criteria


Learn how to add numbers with the SUM Function


Learn how to add up numbers based on multiple conditions


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


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


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

Section 2: Excel Function Tips and Tricks

Learn the difference between absolute cell reference and relative cell reference


Learn how to use formulas in Arrays


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


Learn how formulas work when using a formatted table


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


Learn the step by step way to nesting an IF Statement


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


Learn how to use Paste Special with Formulas


Learn all about the Status Bar


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

Section 3: Advanced Excel Functions

Learn how to randomly choose among your choices your supply


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


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


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


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


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

Section 4: Real world Examples with Questions to help learn

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


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


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


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


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