Course Calendar     Log in


Register Online.

Microsoft® Excel 2010 Level I

Duration: 
1 day
Price: 
$375.00
Audience: 

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

This course requires the following prerequisites:

  • Windows XP Professional : Level 1
  • Windows XP : Introduction
Overview: 

As a new user of Microsoft Excel, you have the need to learn the most basic functionality offered by the program. You will become familiar with the user interface, how to use the help feature, modify cells, create basic formulas and use functions to calculate cell values.

Participants will not only become familiar with the interface and the basic functionality of Microsoft Excel but will also learn to manipulate data, modify worksheet elements, apply number formatting, apply cell styles and learn how to manage their worksheets and workbooks.

Topics: 

Section 1: Getting Started

  • Lesson 1.1: Starting Out
  • Lesson 1.2: About Workbooks
  • Lesson 1.3: Exploring your Workbook
  • Lesson 1.4: Getting Help with Excel
  • Section 1: Review Questions

Section 2: The Excel Interface

  • Lesson 2.1: The Quick Access Toolbar and File Menu
  • Lesson 2.2: The Home Tab
  • Lesson 2.3: The Insert Tab
  • Lesson 2.4: The Page Layout Tab
  • Lesson 2.5: The Formulas Tab
  • Lesson 2.6: The Data Tab
  • Lesson 2.7: The Review Tab
  • Section 2: Review Questions

Section 3: Excel Basics

  • Lesson 3.1: Working with Excel
  • Lesson 3.2: Basic Excel Features
  • Lesson 3.3: Moving your Data
  • Lesson 3.4: Custom Actions and Options Buttons
  • Lesson 3.5: Editing Tools
  • Section 3: Review Questions

Section 4: Editing your Workbook

  • Lesson 4.1: Modifying Cells and Data
  • Lesson 4.2: Cell Formatting
  • Lesson 4.3: Enhancing a Worksheet’s Appearance
  • Lesson 4.4: Working with Charts, Part 1
  • Lesson 4.5: Working with Charts, Part 2
  • Section 4: Review Questions

Section 5: Printing and Viewing your Workbook

  • Lesson 5.1: Using the View Tab
  • Lesson 5.2: Managing a Single Window
  • Lesson 5.3: Managing Multiple Windows
  • Lesson 5.4: Printing your Workbook
  • Section 5: Review Questions