Online Training Courses - Collection 10358: Skills Training for Microsoft Excel 2010

View Video Demo
Price
£19.143
(excl. VAT)
Call to Buy 0870 145 1600
or email:

enquiries@itsgroup.org.uk
Publisher Name: MICROSOFT LEARNING
ISBN: 5038470031885
User Level: Beginner/Intermediate
• Product Information
• Table of Contents
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.

This collection includes the following courses:
Course 10296: Beginner Skills in Microsoft Excel 2010
Course 10393: Intermediate Skills in Microsoft Excel 2010
Course 10394: Advanced Skills in Microsoft Excel 2010

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard
This course requires Excel 2010 installed on your computer to carry out the local labs included in the course.

Subscription: 1 year.
Course 10296: Beginner Skills in Microsoft Excel 2010

Creating and Editing Worksheets
Introduction
Introduction to Excel 2010
Setting Excel Options
Creating a New Workbook
Adding and Moving Data in a Worksheet
Lab: Creating a Worksheet and Adding Data
Modifying a Worksheet
Working with Worksheets
Adding Formulas
Lab: Manipulating Worksheets
Printing a Worksheet
Self Test

Formatting Worksheet Data
Introduction
Modifying the Formatting of Cells
Using Borders and Margins
Lab: Formatting Cell Data
Introduction to Excel Table Styles
Sorting and Filtering a Data List
Reviewing Workbook Data
Using Proofing Tools
Self Test

Working with Charts and Graphics
Introduction
Creating and Editing Charts
Formatting Charts
Lab: Creating and Formatting Charts
Working with Shapes
Inserting Graphics
Inserting Objects in a Worksheet
Lab: Adding Graphics to a Worksheet
Self Test

Module Summary

Glossary

Course 10393: Intermediate Skills in Microsoft Excel 2010

Managing Workbooks in Excel 2010
Module Overview
Enhancing Workbooks
Introduction
Modifying Worksheets
Adding Headers and Footers
Editing Worksheets
Working with Office Themes
Formatting and Editing Cells
Conditional Formatting
Inserting Hyperlinks
Formatting Cell Data
Self Test

Working with Data
Introduction
Extending a Data Series
Analyzing Data by Using Data Lists
Cleaning Up and Outlining Data Lists
Using What-If Analysis
Performing Calculations
Working with Data Lists
Self Test

Working with Tables and Charts
Introduction
Creating and Editing Pivot Tables
Formatting PivotTables
Analyzing PivotTable Data
Working with a PivotTable
Working with PivotCharts
Editing Charts
Using Table Styles
Using PivotTables
Self Test

Working with Advanced Features of Excel 2010
Introduction
Setting Excel Options
Setting Workbook Properties
Customizing the Ribbon
Customizing the Quick Access Toolbar
The Track Changes Feature
Linking and Embedding Objects
Sharing a Workbook
Working with the Advanced Features
Self Test

Module Summary

Glossary

Course 10394: Advanced Skills in Microsoft Excel 2010

Working with Advanced Features of Excel 2010
Module Overview

Customizing Excel 2010
Introduction
Setting Excel 2010 Options
Defining Workbook Protection Levels
Customizing Worksheet Views
Self Test

Working with Worksheet Data
Introduction
Manipulating Worksheet Data
Creating Named Ranges
Managing Named Ranges
Inserting Equations
Analyzing Data
Working with a PowerPivot Workbook
Lab: Working with Worksheet Data
Self Test

Working with External Data
Introduction
Defining and Editing External Data Connections
Working with XML Data
Creating and Editing Web Queries
Lab: Working with External Data
Self Test

Working with Tables and Charts
Introduction
Working with Charts
Creating a Sparkline Chart
Creating Different Types of Charts
Adding Trendline to a Chart
Analyzing Pivot Table Data
Lab: Working with Tables and Charts
Self Test

Automating Workbooks
Introduction
Introduction to Macros
Creating a Macro
Editing a Macro
Running and Deleting a Macro
Lab: Working with Macros
Self Test

Module Summary

Glossary