Microsoft Office Excel 2010: Transition
from MS Excel 2003
Overview
TCCIT Solutions provides high quality, affordably priced, training classes in Microsoft Excel 2010. With experienced instructors and a convenient midtown NYC location, we offer Microsoft Excel 2010 courses for the corporate community. TCCIT Solutions offers group classes and private tutoring to beginner and more advanced corporate clients in Microsoft Excel 2010. We offer onsite training or classes at our facility on 34th Street and Madison in New York City.
Description
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.
Course Objective:
You will use the new and enhanced features in Microsoft Office Excel 2010.
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
Prerequisites:
Students enrolling in this course should have prior knowledge of Microsoft Office Excel 2003 or Excel XP on the Windows operating system.
TCCIT Solutions Course Curriculum for Microsoft Excel 2010: Transition from Excel 2003:
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
For more information about Corporate Training, please either call us at your convenience at 212-684-5151 or email us at info@TCCITSolutions.com.
You can always view our Complete Course List and our Complete Schedule.