Online Excel 2003 to 2010 Upgrade Training
Microsoft » Microsoft Excel
Only $49.95
ONLINE Excel 2010 Upgrade TRAINING FEATURES
- Learn Excel 2010 Upgrade online with these interactive online Excel 2010 Upgrade courses.
- Affordable Pricing (Only $49.95 for the complete series)
- A full year to complete the Excel 2010 Upgrade courses
- Retake the Excel 2010 Upgrade courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
- Excel 2003 to 2010 Upgrade Series (10 hours)
1. Navigating the Updated Office Interface
Time: 2 hours
This course provides information about the new user interface designed for the Microsoft Office applications.
Objectives
- List and describe the features of the new Office 2007 user interface
- Change application settings in Office 2007 products
- Use the Live Preview feature
Topics
- Why the big change?
- The Ribbon: Command tabs and contextual tabs
- The Ribbon: The Office menu
- Galleries and live preview
- Other new interface features
2. Common Features in Office 2010
Time: 3 hours
This course explores the new features that the major Office 2010 applications have in common.
Objectives
- Modify and minimize the Ribbon
- Use Backstage view
- Capture windows and clippings
- Add artistic and color effects to images
- Save documents to the Web
- Work with Office Web Apps
Topics
- Modifying the Ribbon
- Working with Backstage View
- Capturing Windows and Clippings
- Removing Image Backgrounds
- Adding Artistic and Color Effects
- Checking Document Accessibility
- Saving Documents to the Web
- Working with SkyDrive
- Using Office Web Apps
3. What's New in Excel 2007
Time: 3 hours
This course provides an overview of the new features in Microsoft Office Excel 2007.
Objectives
- Identify features of the new Excel 2007 user interface
- Convert Excel data into table format
- Use Excel 2007's Formula AutoComplete feature
- Analyze data in Excel 2007 using conditional formatting
- Create professional looking reports
- Insert and format charts
- Work with PivotTables and PivotCharts
Topics
- The new look of Excel 2007
- Using the workbook
- Creating and formatting tables
- Formula features
- Analyzing data using conditional formatting
- Creating reports
- Creating charts
- Creating PivotTables and PivotCharts
4. What's New in Excel 2010
Time: 2 hours
This course explores the new features in Microsoft Excel 2010.
Objectives
- Describe the new Ribbon features
- Show data trends with sparklines
- Use the slicer with PivotTables
- Build equations
Topics
- Reviewing the Ribbon Tabs in Excel
- Showing Data Trends with Sparklines
- Using the Slicer
- Building Equations
Resources for Excel 2003 to 2010 Upgrade
- Know of a good resource for Excel 2003 to 2010 Upgrade Online Training? Please Let Us Know.