Course 10296: Beginner Skills in Microsoft Excel 2010
|
Offer Title
|
Course 10296: Beginner Skills in Microsoft Excel 2010
|
|
Offer Description
|
This online course is designed to help you use the Microsoft Excel 2010 interface, commands, and features to present, analyze, and manipulate various types of data.
Topics covered in this course include:
- Setting Excel Options
- Creating a New Workbook
- Adding and Moving Data in a Worksheet
- Formatting Cells and Using Borders and Margins
- Sorting and Filtering Data Lists
- Reviewing a Workbook and Using the Proofing Tools
- Creating and Editing Charts
- Inserting Shapes, Pictures, Clip Art, SmartArt Graphics, WordArt, Screen Shots, and Signature Lines
Student prerequisites:
Learners taking this course must have experience working with Microsoft Windows. They must be familiar with performing basic tasks such as opening a file, formatting text, and saving a file.
It is recommended that the learners complete Course 4697: Introduction to the New Microsoft® Office Fluent™ User Interface before taking this course.
|
|
Marketing Description
|
Summary: This online course is designed to help you use the Microsoft Excel 2010 interface, commands, and features to present, analyze, and manipulate various types of data.
Audience: Home and Office Users
Available Offline: Yes
|
For Registration Click Here
Collection 10358: Skills Training in Microsoft Excel 2010
|
Offer Title
|
Collection 10358: Skills Training in Microsoft Excel 2010
|
|
Offer Description
|
This 6 hour collection provides you with skills to create, customize, enhance, and share Excel 2010 workbooks.
Topics covered in this collection include:
- Working with the Interface Elements
- Creating and Editing Worksheets
- Formatting Cell Data
- Working with Equations and Formulas
- Creating and Formatting Charts
- Creating and Formatting Tables
- Working with PivotTables
- Working with Pivot Charts
- Creating, Editing, and Running Macros
- Working with External Data
Home and Office users taking this course should already be familiar with Microsoft Office Excel 2003, Microsoft Office Excel 2007, or other spreadsheet programs. Learners familiar with Excel 2003 should complete Course 4697: Introduction to the New Microsoft® Office Fluent™ User Interface.
|
|
Marketing Description
|
Summary: This 6 hour collection provides you with skills to create, customize, enhance, and share Excel 2010 workbooks.
Audience: Home and Office Users
Available Offline: Yes
|
For Registration Click Here
Course 10393: Intermediate Skills in Microsoft Excel 2010
|
Offer Title
|
Course 10393: Intermediate Skills in Microsoft Excel 2010
|
|
Offer Description
|
This online course is designed to help manage workbooks in Excel 2010.
Topics covered in this course include:
- Editing Worksheets
- Adding Headers, Footers, and Hyperlinks
- Formatting and Editing Cells
- Conditional Formatting
- Analyzing Data Lists
- Using What-If Analysis
- Performing Calculations
- Creating, Editing, and Formatting PivotTables
- Creating and Editing Charts
- Setting Excel 201 Options and Workbook Properties
- Linking and Embedding Objects
- Sharing Workbooks
Student Prerequisites:
Learners must have the basic skills of using Excel 2003. These include basic tasks such as opening a workbook, formatting text, and saving a workbook. It is recommended that the learners complete the course 4697 that introduces the Fluent Interface (ribbon).
|
|
Marketing Description
|
Summary: This two-hour course is designed to help you manage workbooks in Excel 2010.
Audience: Home and Office Users
Available Offline: Yes
|
For Registration Click Here
Course 10394: Advanced Skills in Microsoft Excel 2010
|
Offer Title
|
Course 10394: Advanced Skills in Microsoft Excel 2010
|
|
Offer Description
|
This online course is designed to help you customize and manage the Excel 2010 interface as well as know how to manage, manipulate, and format data.
Topics covered in this course include:
- Setting Excel 2010 Options
- Manipulating Worksheet Data
- Creating and Editing Named Ranges
- Working with Solver and PowerPivot Add-Ins
- Working with External Data
- Creating and Editing Web Queries
- Creating Sparklines and Trendlines
- Analyzing PivotTable Data
- Creating and Editing Macros
- Running a Macro
- Workbook Protection Levels
Student Prerequisites:
Learners must have the basic skills of using Excel 2003. These include basic tasks such as opening a workbook, formatting text, and saving a workbook. It is recommended that the learners complete the course 4697 that introduces the Fluent Interface (ribbon).
|
|
Marketing Description
|
Summary: This two-hour online course is designed to customize and manage the Excel 2010 interface as well as know how to manage, manipulate, and format data.
Audience: Home and Office Users
Available Offline: Yes
|
For Registration Click Here