MS Excel 2010 Course Outline

  • Course Description/Length/Prerequisites

In this course, you will use Microsoft Excel to manage, edit, and print data. 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. You have basic computer skills such as using a mouse and navigating through windows.

  • Learning Objectives/Outcomes

Upon completion of this hands-on course, students will be able to:

  • Start Microsoft Excel; identify the main components of the Excel window and an Excel workbook; use the Help feature; and navigate worksheets
  • Enter and edit text, values, formulas; insert pictures in a worksheet; use AutoFill; and save and update a workbook
  • Move and copy data; insert and delete ranges; and work with relative and absolute references when creating and copying formulas
  • Use the SUM function, the AutoSum button, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet
  • Format text, numbers, rows, and columns in a worksheet; use conditional formatting; copy formats; and use table formats
  • Preview and control Page Setup options for a worksheet; check spelling;find and replace data; print a worksheet; and set and clear a print area
  • Create, format, modify, and print charts based on worksheet data
  • Manage large worksheets and multiple worksheets
  • Course Details

Getting Started

Spreadsheet terminology

Exploring the Excel window

Getting help

Navigating workbooks

Entering and Editing Data

Entering and editing text and values

Entering and editing formulas

Working with pictures

Saving and updating workbooks

Using Functions

Entering functions

AutoSum

Other useful functions

Formatting Worksheets

Formatting text

Formatting rows and columns

Formatting numbers

Conditional formatting

Copying formats and applying table formats

Printing

Preparing to print

Page Setup options

Printing worksheets

Creating Charts

Chart basics

Modifying charts

Printing charts

Managing Large Workbooks

Viewing and printing large worksheets

Using multiple worksheets

    1. Number of Trainees: 5 person
    2. Training Frequency: 60 hours in total, 3 hours at one time, twice a week, schedule on every Tuesday and Thursday.
    3. Training Duration: Jan 14, 2016 – Mar 22, 2016
    4. Delivery Method: Onsite training (send trainers to participants’ workplace)
    5. Tuition Cost: $200/hr (Total tuition $12,000)