Essential Excel Formulas and Functions Training

Entering and editing formulas, Understanding operator precedence, Copying and moving formulas, Understanding relative reference format, Understanding absolute reference format, Copying a formula without adjusting relative references , Displaying Worksheet Formulas , Working with range names in formulas , Pasting a name into a formula , Applying names to formulas, Understanding external references

Inserting functions, Supplying function arguments, Supplying range arguments, Inserting nested functions

Converting text, LOWER(), UPPER(), PROPER(), Extracting a substring, LEFT(), RIGHT(), MID(), Concatenation, Creating customer account numbers

Using the IF() function, Working with nested IF()s, Using AND, OR and NOT

Creating lookup tables, Using VLOOKUP() and HLOOKUP(), Using range lookups, Finding exact matches, Using the CHOOSE() function

How Excel handles dates and times, Construction dates with the DATE() function, Extracting date elements with DAY(), MONTH(), and YEAR() , Isolating the day, month and year , Determining the day of the week, Calculating the tme between two dates using DATEDIF(), Calculating elapsed time , Creating time sheets

ROUND() and MROUND() , ROUNDDOWN() and ROUNDUP() , CEILING() and FLOOR() , EVEN() and ODD() , INT() and TRUNC() , Using RANDBETWEEN() to generate data, Using RANDBETWEEN() to generate date and time values

How database functions work, Defining the Excel database, Defining the criteria area, Using AND and OR with your criteria, The DSUM() function, The DAVERAGE() function, The DCOUNT() function, DMIN() and DMAX(), The DGET() function

Understanding Excel error values, #DIV/0!, #NAME, #REF, #NULL!, #N/A, Using conditionals to anticipate error values, Using IFERROR(), Using the formula error checker, Auditing a worksheet, Tracing cell precedents and dependents, Evaluating formulas, Watching cell values