Microsoft Excel 2010

Introduction

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.

Overview:

This one day course teaches participants the skills necessary create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Delivery: Instructor-led, hands-on delivery either online, on-site at your place of business or at Front Runner. Our custom training meets your needs.

Duration: 1 day

Further Learning:

Microsoft Access 2010
Advanced
Microsoft Excel 2010
Intermediate

Objectives:

Upon successful completion attendees should able to:

Create a basic worksheet by using Microsoft Excel 2010.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.

Suggested topics:

Identify the Elements of the Excel Interface: Navigate and Select Cells in Worksheets, Customize the Excel Interface, Create a Basic Worksheet
Perform Calculations in an Excel Worksheet: Create Formulas in a Worksheet, Insert Functions in a Worksheet, Reuse Formulas
Modify a Worksheet: Edit Worksheet Data, Find and Replace Data, Manipulate Worksheet Elements
Modify the Appearance of a Worksheet: Apply Font Properties, Add Borders and Colors to Cells, Align Content in a Cell, Apply Number Formatting, Apply Cell Styles
Manage an Excel Workbook:: Manage Worksheets, View Worksheets and Workbooks
Print Excel Workbooks: Define the Page Layout, Print a Workbook