Register Now      202-747-5000

Essentials of Microsoft Excel

365 | 2019 | 2016
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

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).

We offer the above listed class as a private group class in the following delivery formats:

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 or Softek
1-4 students $1000
5-8 students $1150
9-12 students* $1250
*$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 $125 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. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee