TRAIN Online Class Schedule
Course Excel 2007: New Features [WDRS0044/CR/01]
Prerequisites Experience with some version of Excel preferably 2003 or XP and some familiarity with the Internet.
Prerequisit Course
Requal. Interval One Time Only
Contact Nicole M Gee
Reference Material
Target Audience Experienced Excel users who have worked with earlier versions of Excel, ideally Excel 2003 and who have upgraded or will upgrade to Office 2007.
Objective Explore the new features of Excel 2007. Customize the Excel Interface to fit your workplace needs. Analyze the enhancements in Excel spreadsheets and select those that will improve particular applications. Apply a Formula, use the enhanced Function Wizard, calculation options and the Function Library to improve the usability of a spreadsheet. Work with enhanced chart tools, chart templates and the SmartArt Gallery to improve the appearance and readability of a spreadsheet. Create enhanced PivotTables and PivotCharts.
Course Content Work with the MS Office Button, the Ribbon, the Quick Access Toolbar, the Contextual tab, the Excel Galleries, and the MS Office Window Frame. Customize the Excel Interface to fit your workplace needs. Explore the enhancements in Excel spreadsheets. Work with the enhanced tables, format tables. Use the Conditional Formatting Button, the Conditional Formatting Categories, and the Conditional Formatting Rules Manager Dialog Box. Sort and Filter data. Apply a Formula, use the enhanced Function Wizard, calculation options and the Function Library. Work with enhanced chart tools, chart templates and the SmartArt Gallery. Create enhanced PivotTables and PivotCharts.
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