TRAIN Online Class Schedule
Course Excel 2007 Advanced[WDRS0071/CR/01]
Prerequisites Excel: Introduction and Intermediate.
Requal. Interval One Time Only
Contact Nicole Gee
Target Audience People who need to learn various advanced techniques for manipulating data.
Objective Create and edit a Macro. Apply conditional formatting, add data validation criteria, update a workbook¿s properties and modify Excel¿s default settings. Protect your worksheet and workbook and add and remove file passwords, share workbooks, set and review tracked revisions, merge workbooks, and administer digital signatures. Trace cells, locate errors in formulas, troubleshoot invalid data and Formulas, watch and evaluate formulas and create a data list outline. Create a Trendline, Scenarios, perform What-If Analysis. Create a workspace and consolidate data, link and edit cells in different workbooks. Export Excel data and import a delimited text file. Develop XML maps and import and export XML data.
Course Content ¿ Streamlining Workflow
¿ Collaborating with Others
¿ Auditing Worksheets
¿ Analyzing Data
¿ Working with Multiple Workbooks
¿ Importing and Exporting Data
¿ Using Excel with the Web
¿ Structuring XML Workbooks
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.
Project:
Task
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.