This course is not currently offered by Global Knowledge. Information here is provided for reference only.

Explore beginner, advanced, and power-user topics for Excel 2010, the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files.

What You'll Learn

• Basics of Excel 2010
• Advanced functions in Excel for Office 2010

Who Needs to Attend

Individuals and business users with basic computer literacy

Prerequisites

There are no prerequisites for this course.

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Microsoft Office 2010: Beginning Excel

• Getting Started with Excel 2010
• Applying Basic Data Formatting in Excel 2010
• Moving and Getting Around in Excel 2010
• Moving Data and Modifying Worksheets in Excel 2010
• Saving, Sending, and Printing Excel 2010 Workbooks
• Using Conditional Formatting, Tables, and Sparklines in Excel 2010
• Reviewing and Protecting Content in Excel 2010
• Using Basic Formulas in Excel 2010
• Using Basic Functions with Excel 2010
• Inserting Basic Charts in Excel 2010
• Adding Visuals, Themes, and Styles to Excel Workbooks

2. Microsoft Office 2010: Advanced Excel

• Customizing Visual Elements in Excel 2010
• Customizing Workbook Settings, Conditional Formatting, and Number Formats
• Organizing Data and Objects in Excel 2010
• Ensuring Excel 2010 Data and Formulas are Correct
• Automating Excel Tasks using Macros
• Analyzing Data with What-if Analysis
• PivotTables and PivotCharts in Excel 2010
• PivotTable Filters, Calculations, and PowerPivot

3. Microsoft Office 2010: Power User Excel

• Sharing Excel 2010 Workbooks Online and on a Network
• Using Excel 2010 to Collaborate Online and with Other Office Applications
• Using Lookup, Reference, Math, and Text Functions in Excel 2010
• Manipulating Formulas and Using Forms in Excel 2010
• Using Excel 2010 Data Connections: Web Queries, XML, and Databases