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:
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!
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 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
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
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
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
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.
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.