Essentials of Microsoft Excel

3 Hours

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the most essential skills needed to enter and edit information, write formulas, format cells, and print spreadsheets in Microsoft Excel.

Course Objectives

Understand how to enter text, numbers, and dates
Write basic formulas that add, subtract, multiply, and divide cells
Format columns/rows and format cells with borders, shading, fonts, etc.
Insert and delete columns or rows
Preview and print workbooks

Course Outline

Building Simple Workbooks

Understanding Excel Terminology
Examining Important Screen Elements
Opening Workbooks
Reviewing Workbook Data
Entering General Text
Entering Numbers
Entering Dates
Editing Cells
Deleting Cell Contents
Understanding Mouse Pointer Shapes
Selecting Cells, Rows, and Columns
Moving Data by Drag-and-Drop
Copying Data with the Fill Handle
Reversing Mistakes with Undo and Redo
Saving Workbooks
Closing Workbooks

Writing and Copying Basic Formulas

Understanding Formula Syntax
Creating Basic Formulas
Using Functions in Formulas
Using the Sum Button
Copying Formulas

Formatting and Printing Worksheets

Changing Column Widths
Applying Fonts, Bold, Underline, and Italics
Aligning Data in Cells
Formatting Numbers and Formulas
Formatting Dates
Applying Borders
Applying Fill Color
Inserting and Deleting Columns or Rows
Previewing Before Printing
Printing Worksheets

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students	$850
5-8 students	$1000
9-12 students*	$1100
*$35 per additional student

Private Group Class: At Your Location
1-4 students	$1100
5-8 students	$1250
9-12 students*	$1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.