Excel Introduction

Seminar Title: Microsoft Excel 2007/2010 Introduction

Seminar length: 1.0 day(s)

Certification: MOS: Microsoft Office Excel 2010 Exam 77–882
What You’ll Learn: You’ll complete the day with the skills to create, edit, format, and print basic Microsoft Office Excel 2007/2010 worksheets.

What You Need To Know Already: To be successful in this seminar, you’ll need to be familiar with using personal computers and you should have used the mouse and keyboard. Also, it’s important that you’re comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Certification
This seminar is one of a series of CI Center seminar titles that help you gain the Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for anyone who uses Microsoft’s business desktop software and wants to be recognized for their expertise with specific Microsoft products.

When you finish this seminar, you’ll be able to:

* create a basic worksheet by using Microsoft Excel 2007/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.

What We’ll Cover:

Lesson 1: Getting Started with Excel

Topic 1A: Identify the Elements of the Excel Interface
Topic 1B: Navigate and Select Cells in Worksheets
Topic 1C: Customize the Excel Interface
Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

Topic 2A: Create Formulas in a Worksheet
Topic 2B: Insert Functions in a Worksheet
Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

Topic 3A: Edit Worksheet Data
Topic 3B: Find and Replace Data
Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

Topic 4A: Apply Font Properties
Topic 4B: Add Borders and Colors to Cells
Topic 4C: Align Content in a Cell
Topic 4D: Apply Number Formatting
Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

Topic 5A: Manage Worksheets
Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Topic 6A: Define the Page Layout
Topic 6B: Print a Workbook

To register for this seminar, call Peggy at 812-206-0227