This class is intended for:

PC/Windows Users: Excel 2016-2019-365

Certificate of Completion (optional): $5

Course Length: 1 Day

**Sum**(sum or total of a range of cells)**Average**(average a range of cells)**Max**(display highest number in a range cells)**Min**(display lowest number in a range of cells)

**Count**(count cells containing values)**CountA**(count non-blank cells)**CountBlank**(count blank cells)**CountIf**(count cells that meet a single criteria - a word, a number, etc.)**CountIfs**(count cells that meet multiple criteria - words, numbers, etc.)

**SumIf**(add cells that meet a single criteria - a word, a number, etc.)**SumIfs**(add cells that meet multiple criteria - words, numbers, etc.)**SumProduct**(sum cells meeting multiple criteria - words, numbers, etc.)

**Average**(average numbers)**AverageIf**(average cells that meet a single criteria - words, numbers, etc.)**AverageIfs**(average cells that meet multiple criteria - words, numbers, etc.)

**If**(assign a true or false result to cells that meet a single criteria)**Nested Ifs**(assign a true or false result to cells that meet multiple criteria)**Ifs**(assign a true or false result to cells that meet multiple criteria)**If Error**(substitute something in place of an error message)**If And**(assign a true or false value to rows that meet multiple criteria)**If Or**(assign a true or false value to rows meet one or another criteria)

**VLookup**(look up data in a row)**HLookup**(look up data in a column)**XLookup**(look up data in a row AND a column)

**PMT**(calculate payments and interest rates on a loan)**FV**(calculate the future value of an investment)

**Concatenate | Concat**Concatenate (combine data from multiple cells into one cell)**Text Join**(combine data from multiple cells into one cell)**Trim**(remove extra blank spaces between Concatenated text)**Upper**(convert all text to uppercase)**Lower**(convert all text to lowercase)**Proper**(capitalize first letter of each word)**Left**(extract a number of characters from the left side of a cell)**Right**(extract a number of characters from the right side of a cell)**Mid**(extract a number of characters from the middle of a cell)

**Today**(displays currrent day and time)**Now**(display current date)**Day**(extract day from a cell containing a date)**Month**(extract the month from a cell containing a date)**Year**(extract the year from a cell containing a date)**Date Calculations**(determine the number of days/months/years between two dates)

Combine functions" "nest" one function within another.

Create Absolute and/or Relative Macros to automate common, repetitive tasks.

Add buttons, sliders, and checkboxes to a worksheet to create a "user-friendly" interface for less experienced users.

Nicole T.

** Call 858-578-9476**

6920 Miramar Road - Suite 206

San Diego, CA 92121

858-578-9476

We also offer classes on:

Beginning Excel | Intermediate Excel | Excel Formulas | Excel Pivot Tables | Excel Charts |

Beginning Excel | Intermediate Excel | Excel Formulas | Excel Pivot Tables | Excel Charts |