TRAIN Online Class Schedule
Course Excel 2010: Intermediate[WDRS0122/CR/01]
Prerequisites Windows: Introduction and Excel: Introduction or equivilent knowledge.
Requal. Interval One Time Only
Contact Barbara Brooks
Authorized Instructors Barbara Brooks (WR)
Target Audience Individuals with basic knowledge of Excel and who has experience creating worksheets and charts but need the additional benefits this class provides.
Objective Upon successful completion of this course, participants will be able to: Manage cell and range names, calculate data across worksheets, use specialized functions and analyze data with logical and lookup functions. Create and modify tables, format tables, sort or filter worksheet or table data and calculate data in a table of worksheet. Create, modify and format charts. Create a PivotTable report and analyze data using PivotCharts. Insert and modify pictures and ClipArt. Draw and modify shapes. Illustrate workflow using SmartArt graphics and layer and group graphic objects. Customize the Excel environment and workbooks. Manage themes. Create and use templates.

Course Content * Creating Data with Advanced Formulas
* Organizing Worksheet and Table Data
* Presenting Data Using Charts
* Analyzing Data Using PivotTables, Slicers and PivotCharts
* Inserting Graphic Objects
* Customizing and Enhancing Workbooks and the Excel Environment
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.