Excel 2003 Advanced Course

Working with Advanced Excel Functions

Make sure you understand the full range and power of Excel's built-in functions and formulas, and learn shortcuts and time-savers, such as doing quick "what-if" interest calculations. This section of our Advanced Excel training adds practical skills to your Excel toolbox right away, including how to:

• Calculate any answer you need with advanced built-in formulas, such as the IF function that lets you specify conditions for calculations
• Move, nest, and substitute formula factors without losing functionality
• Use the table lookup functions to save time doing calculations on your data
• Even manipulate text with functions, for example, use the PROPER function to convert the first letter of a range of cells to uppercase

Analyzing Data with Microsoft Excel

One of the most important Excel features is its ability to display and highlight only relevant data. For example, a manager may just want to see a summary of key numbers and the bottom line. In this section, you'll learn how to:

• Compress or expand your display with the outline feature
• Summarize large amounts of data on different spreadsheets with the consolidate command
• Filter selected data to display only the rows that fit your criteria
• Use database functions to perform calculations on fields within a list or database

Using PivotTables in Excel

Stop avoiding PivotTables because you're not sure how to use them! We'll show you how easy it is to use PivotTables to summarize and analyze your data. And once you have set up a PivotTable, how to generate reports and graphic displays of your data that make it easy to communicate the figures to others. You will leave our Advanced Excel training course knowing how to:

• Confidently step through the PivotTable and PivotChart Wizard
• Lay out and modify PivotTable fields directly in a worksheet without the Wizard
• Use the Page placeholder field to filter information by viewing one category of data at a time
• View just the data you want with groups and the AutoSort and AutoShow commands
• Add subtotals, grand totals, and other summary fields like maximums and averages
• Add calculated fields, for example, a projected sales field calculated as a 10% increase over current sales
• Easily create a PivotChart to graphically display PivotTable data

Working with Data Analysis Tools

In what might be the most important unit of the course, you will learn how to use Excel's powerful tools for getting real-time answers to support your decision making. You'll learn how to solve complex problems, and the best ways to do "what-if" analyses and projections. Our experienced instructors will show you the insider secrets for how to:

• Do simple "what-if" calculations with one or two variables, or complex scenarios with up to 32 variables
• Create "best case" and "worst case" projections with the Scenario Manager
• Use the built-in Goal Seek tool to find a value that will return a desired result
• Quickly figure out answers to complex problems with the Solver tool, for example, how to maximize profit by controlling the amount spent on advertising

Working with Macros in Excel

A macro is a series of instructions you can save and apply with one click, increasing your speed and accuracy. You can record any procedures or calculations you find yourself repeating regularly. In this part of the Advanced Excel training class, you will get a chance to practice hands-on how to:

• Prepare for and record a macro
• Set up a menu command, shortcut key, or button to run a macro
• Determine when to create a macro

Working with External Data

Rather than re-entering data you already have in other formats, we'll show you how to save time by importing it into Excel. This section also covers exporting data, and adding hyperlinks to external destinations. You will learn how to:

• Import almost any kind of data, including web pages, Lotus 1-2-3, QuattroPro, dBASE, XML, and text files
• Analyze Microsoft Access data in Excel
• Export data from Excel both to other applications and to earlier versions of Excel
• Add hyperlinks to other places like a different cell in the worksheet, or a different workbook, a Word file, or a web page

Prerequisites:

• Working experience with Microsoft Excel.

Advanced Excel 2003 courses are offered at four locations::

• Advanced Excel 2003 course San Francisco
  
• Advanced Excel 2003 course Los Angeles
  
• Advanced Excel 2003 course San Jose
• Advanced Excel 2003 course Sacramento