Advanced Excel
Microsoft Excel - Level 3

Prerequisite: Beyond the Basics of Spreadsheets

Microsoft Excel is a popular spreadsheet program for setting up, tracking, analyzing and charting financial, statistical, and other types of information. Once information has been entered in an Excel worksheet, you can create formulas to perform calculations and “what-if” analyses. This is an advanced class on Microsoft Excel, and covers such topics as adding function formulas, performing various calculations, creating and modifying charts, inserting pictures, and performing “what-if” analyses.

The class objectives include:

• Using the AVERAGE, MAX and MIN formulas to perform statistical analysis
• Creating Date and Time formulas
• Using Financial formulas
• Determining loan payment amounts
• Creating IF formulas
• Inserting Headers and Footers
• Formatting and scaling a worksheet for printing
• Using the drawing toolbar

Excel 2003 - Level 3
Code: XCL03-3 Date: 1/12/2010 Time: 1:00PM-4:00PM Registration Fee: $75