Excel training classes near me in San Diego

Excel Advanced Class in San Diego CA




Register

FUNCTIONS:

Basic Functions:

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

Count Functions:

• CountIf (count cells meeting one criteria)
• CountIfs (count cells meeting two or more criteria)

Sum Functions:

• SumIf (sum cells meeting one criteria)
• SumIfs (sum cells meeting two or more criterion)
• SumProduct (sum the product of multiple columns)

If Functions:

• If (test to see if cells meet one criteria and assign a result)
• And (assign a True or False value to rows that meet two or more criteria)
• Or (assign a True or False value to rows meet two or more criteria)
• Ifs (check to see if cells meet two or more criteria and assign a result)
• IfError (substitute something else for an error message)

HLookup & VLookup Functions:

• HLookup (look up data in a row
• VLookup (look up data in a column)
• XLookup (look up data in a column and a row)

Financial Functions:

• Pmt (calculate payments on a loan)

Text Functions:

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

Date /Time Functions:

• Date (display current date)
• Now (display current date/time)
• Calculate number of days/months/years between two different dates
• Day (extract the day from a date field)
• Month (extract the month from a date field)
• Year (extract the year from a date field)

Misc:

• AverageIf (average a range cells if they meet a single criteria)
• AverageIfs (average a range cells if they meet multiple criteria)
• "Nest" functions (place one function within another)
• Workbook Controls (Sliders, Spin Button, Option Button) to create an interactive spreadsheet
• Dashboard (create one sheet that combines charts, sheets, workbook controls, etc)

GOAL SEEK:

Goal Seek allows you to calculate an unknown value in a given formula, but is only useful for problems that involve finding a single variable. When the desired result of a calculated cell is known, but not the input value that calculation needs to reach that result, you can use Goal Seek.

SOLVER:

Solver is a tool that helps you find solutions involving multiple variables.

SCENARIOS:

Scenarios are part of a group of commands that can be called what-if analysis tools. A scenario is a set of values that a user can create and save and then substitute at any time in the worksheet. The user can then switch to any of these new scenarios to view different results in the worksheet. To compare several scenarios, you can create a report that summarizes them on the same page.

"WHAT-IF" TABLES:

What-If Tables allow you to analyze data and produce a table to show the results. When a single variable like the unit price changes, use a one-input What-If Table. If the unit price AND number of units sold changes, use the two-input What-If Table.

MACROS:

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

WORKBOOK CONTROLS:

Add buttons and sliders to a spreadsheet that run macros.