Excel Training
in San Diego or Online

• Applying formulas such as autosum
• Formatting spreadsheets for visual effects and numeric formats
• Sorting and filtering data
• Inserting graphics and SmartArt diagrams
• Working with large spreadsheets
• Designating and controlling print areas
• Basic functions such as average, max, min, sum
• Extrapolating a pattern to autofill cells for dates or incremental counters
• Transposing data (switching columns and rows)

REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Oct 21           6am - 1pm  day - register
        Nov 4            9am - 4pm  day - register
        Dec 2            9am - 4pm  day - register
        Dec 16           6am - 1pm  day - register

• Applying proper formula syntax of special characters
• Working with different types of math operators and understanding the Order of Operations
• Using 3D formulasto combine data from different worksheets with the same workbook or file
• Linking cells from different workbooks and getting the latest information with automtic updates
• Consolidating data from different worksheets and workbooks
• Using Validation to improve the speed and accuracy of data entry
• Adding drop-down lists and pop-up explanantion boxes
• Creating and working with Pivot Tables
• Auditing formulas to discover and resolve errors
• Creating and editing workbook wemplates
• Using Conditional Formatting to make important numbers stand out
• Password protecting all or part of a workbook

REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Oct 23           6am - 1pm  day - register
        Nov 6            9am - 4pm  day - register
        Nov 20           9am - 4pm  day - register
        Dec 4            9am - 4pm  day - register
► More dates

        Dec 18           6am - 1pm  day - register

• Understanding and working with different Count Functions to streamline your work
• Understanding and working with SumIf, SumIfs, and SumProduct
• Understanding and working with Average, AverageIf, and AverageIfs fucntions
• Leveraging VLookup to look up data in a column and Match and Index to lookup data in a column and row
• Calcuating papyments and interest rates on a loan with Pmpt and deriving the future value of an investment with FV
• Manipulating and extracting data with text fucntions
• Calculating date and time with date and time functions
• Nesting functions (combining functions - placing one function within another)
• Using Named Ranges in formulas and functions to refer to specific regions of a spreadsheet
• Creating Dynamic Ranges that automatically expand to include new data
• Using builtin "What-If" tools
  • GOAL SEEK is a great tool when you know the answer you're looking for and need to change a single variable to achieve that goal. For example, what would the interest rate on a loan need to be in order to make your monthly payments a certain amount.
  • SOLVER is a more powerful tool than Goal Seek. Solver helps you find solutions to problems involving multiple variables. It also allows you to set "Constraints" (limits to what Solver can do) so the results are realistic
  • CENARIOS are a set of values that a user can create and then substitute at any time in the worksheet. The user can switch to any of these new scenarios to view different results in the worksheet.
  • DATA TABLES allow you to analyze data and produce a table to show the results using one or two variables. For example, in a single table you can see the profitability of different combinations of unit prices and units sold.
• Automating common and repetitive tasks with macros (does not conver creating or editing VBA macros in this class)
• Adding buttons, sliders, and checkboxes to a worksheet with a "user-friendly" interface for less experienced users

REGISTER:
Price:  $290 for 6 hours.
In-Person Training:
        No classes scheduled. Get a quote for private training.
Online Live Training:
        Oct 11           9am - 4pm  day - register
        Oct 25           6am - 1pm  day - register
        Nov 8            9am - 4pm  day - register
        Nov 22           9am - 4pm  day - register
► More dates

        Dec 6            9am - 4pm  day - register
        Dec 20           6am - 1pm  day - register