TRAIN Online Class Schedule
Course Excel 2003 Advanced[LS000531/CR/01]
Prerequisites Excel 2003 Intermediate or equivalent knowledge using Excel.
Requal. Interval One Time Only
Contact Karen Karlix-Smith
Target Audience People who need to use Excel at an advanced level.
Objective Learn how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Course Content Apply conditional formatting, add data validation criteria, and create, edit, and run macros. Create a workspace, consolidate data, view the consolidated data, and link cells. Protect your worksheet and workbook, share workbooks, set revision tracking, merge workbooks, and track changes. Trace cell precedents and dependents, locate errors in formulas, locate invalid data and formulas, and group and outline data. Develop a PivotTable Report, a PivotChart Report, and P4erform Statistical Analysis with ToolPak.
Instructor's Comments If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.

Invalid Fermi ID: 00000X

Fermi ID Employee   Visitor   Contractor   Other -- Fermilab Phone Book
  This course has a fee. Select the project and task to use when the class is booked.
Note: The task code popup above requires a recent version of JavaScript. If no tasks appear when you select a project code please use a newer browser. If one is not available please contact the ServiceDesk for assistance. If you return to this page please re-select your project code to re-populate the task code popup.
Waiting List Option Add me to any class that becomes available.
Do you wish to be added to the waiting list? When a class is created or an opening becomes available, persons on the waiting list are automatically enrolled. An email notification will be sent at that time.