
Excel Advanced (FullDay)  $159 This class is intended for: PC/Windows Users: Excel 2007201020132016365 Course Materials: FREE Certificate of Completion (optional): $5 Course Length: 7 hours Count Functions: Count (count cells containing numbers) CountA (count cells containing text) 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.) Sum Functions: SumIf (add cells that meeta 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 Functions: Average (average numbers) AverageIf (average cells that meet a single criteria  words, numbers, etc.) AverageIfst (average cells that meet multiple criteria  words, numbers, etc.) If Functions: If (assign a true or false result to cells that meet a single criteria) And (assign a true or false value to rows that meet multiple criteria) Or (assign a true or false value to rows meet one or another criteria) HLookup / VLookup / Index / Match Functions: HLookup (look up data in a row) VLookup (look up data in a column) Match & Index (look up data in a column & row) Financial Functions: Pmt (calculate payments and interest rates on a loan) FV (calculate the future value of an investment) Text Functions: Concatenate (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) Date /Time Functions: Date (calculate days/months/years between two different dates) Month (display the month) Year(display the year) Misc: "Nest" functions (combine functions  place one function within another) Round Function (round off results to a given number of decimal places) Named Ranges / Dynamic Ranges: Use Named Ranges in Functions to refer to specific regions of a spreadsheet. Create Dynamic Ranges that automatically include new data added at the bottom of a spreadsheet. "WhatIf" Tools: 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 is a tool that helps you find solutions to problems involving multiple variables. Scenarios are part of a group of commands that can be called whatif 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. WhatIf 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 oneinput WhatIf Table. If the unit price AND number of units sold changes, use the twoinput WhatIf Table. Macros: Create Absolute and/or Relative Macros to automate common, repetitive tasks. WorkBook Controls: Add buttons, sliders, and checkboxes to a worksheet to create a "userfriendly" interface for less experienced users. Click to Call: (858) 5789476 Click to Contact Us Click to View Map / Directions  


