>>  STEP 1 - Find a Course                       >>  STEP 2 - Select a Class                       >>  STEP 3 - Register & Pay
Registration | Contact Us | Policies | Online Forms | Find a Course | Home PageAdvanced Search | Site Map | FAQ
Microsoft Excel 2003: Advanced

March 14 - 16, 2011
08:30 - 16:00, Mon-Wed
Washington, DC$745
June 20 - 22, 2011
08:30 - 16:00, Mon-Wed
Washington, DC$745

Overview:
Explore the advanced management features of the Microsoft Excel database in this three-day course. Primary focus is on using the analysis components within the application to budget and manage financial expenses. Participants learn to work with databases, templates, lists, macros and audit tools. Particular attention is devoted to summarizing large amounts of data rapidly, performing what if analyses, and working problems backwards to find variables when a desired outcome or scenario is known.
Who Should Attend?
Microsoft Excel users who wish to learn the advanced features of the application will benefit from this course.
Prerequisites:
Microsoft Excel 2003: Introduction and Microsoft Excel 2003: Intermediate.
Objectives:
  • Learn to utilize the AutoFilter to process lists
  • Generate Pivot Table reports and Page Field reports on large databases to display quick summaries
  • Maintain consistent appearance of workbooks through the preparation of templates
  • Comparison of various outcomes in worksheets by analyzing data with scenarios and goal seeking
  • Apply auditing processes on workbooks
  • Produce macros for frequently used operations and tasks


  • Course Details
    CODE:  SPRD9952T
    TYPE:  Classroom-Day
    LENGTH:  3 Day(s)
    CREDIT:  1.8 CEU
    Related Information
    Print This Page



    Copyright © 2010 Graduate School Need Assistance? Call Customer Support at 888-744-4723