Microsoft® Office Excel® 2010: Transition from  Excel 2003 (First Look)
	Course Specifications
Course number: 084575
Course length: 0.5 day(s)
	Course Description
Course Objective: You will use the new and enhanced features in Microsoft Office Excel 2010.

Target Student: This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010.

Prerequisites: Students must have prior knowledge of Microsoft Office Excel 2003 or Excel XP on the Windows operating system. 
	Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components: 
•	A 1 GHz Pentium®-class processor or faster. 
•	A minimum of 1 GB of RAM is recommended. 
•	A 10 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for the Office installation. 
•	A CD-ROM drive. 
•	A mouse or other pointing device. 
•	A 1024 x 768 resolution monitor is recommended. 
•	Network cards and cabling for local network access. 
•	Internet access (contact your local network administrator). 
•	A printer (optional) or an installed printer driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.) 
•	A projection system to display the instructor’s computer screen. 
	Software Requirements
Each computer requires the following software:
•	Microsoft® Office® Professional Plus 2010 (Beta) 
•	Silverlight 3.0™ 
	Course Objectives
Upon successful completion of this course, students will be able to: 
•	identify the elements of the Microsoft Office Excel 2010 environment. 
•	organize data in Excel worksheets. 
•	analyze Excel data by sorting, filtering, and conditionally formatting it. 
•	present Excel data using charts, illustrations and PivotTables. 
•	use Office Web Apps. 
	Course Content
Lesson 1: Identifying the Elements of the Excel 2010 Environment
Topic 1A: Identify the User Interface Elements 
Topic 1B: Identify the Ribbon Components 
Topic 1C: Use Contextual Tabs 
Topic 1D: Use Excel Galleries 
Topic 1E: Customize the Excel Interface 
Lesson 2: Organizing Data
Topic 2A: Identify the Enhancements to Excel 2010 Spreadsheets 
Topic 2B: Insert Tables 
Topic 2C: Format Tables 
Lesson 3: Analyzing Data
Topic 3A: Apply Conditional Formatting 
Topic 3B: Sort Data in a Spreadsheet 
Topic 3C: Filter Data in a Spreadsheet 
Topic 3D: Apply a Formula 
Lesson 4: Presenting Data
Topic 4A: Create Charts 
Topic 4B: Format Charts 
Topic 4C: Work with Illustrations 
Topic 4D: Create PivotTables and PivotCharts 
Topic 4E: Share Excel Charts 
Topic 4F: Save Data in Compatible Formats 
Lesson 5: Using Office Web Apps
Topic 5A: Save Excel Spreadsheets to the Web 
Topic 5B: Access and Work with Spreadsheets on the Web 
Appendix A: New Features in Microsoft Office Excel 2010 
Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2010 
Appendix C: Link Formatting in Tablet PCs 
Appendix D: Mobile Features