TRAIN Online Class Schedule
Course Excel 2010: Advanced [WDRS0123/CR/01]
Prerequisites Windows: Introduction, Excel: Introduction and Intermediate or equivalent knowledge.
Prerequisite Course
Requal. Interval One Time Only
Contact Barbara Brooks
Reference Material
Target Audience Individuals who need to learn various advanced techniques for manipulating data.
Objective * 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
Course Content 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
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.

Class Schedule

Class Code 83354 -- Online enrollment is restricted to on-site access or authenticated users.  If you have an account LOGIN now.  Or you may CREATE AN ACCOUNT if you have a valid FNAL email address registered in the FNAL telephone directory.  Otherwise, contact the instructor or course contact to enroll.
When:
Wednesday12/03/201408:30 AM -- 04:30 PM
Instructor: D.C.G.
Where Training Center, Rd. A-1, Computer Training Room
Offered To FERMILAB
Fee 275.00
Attendees 4/16