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/Investment

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

Public Course at Softek Private Course at Your Office Private Course at Softek
This class is $500 flat fee up to 8 students $575 flat fee up to 8 students
only offered $550 flat fee up to 12 students $625 flat fee up to 12 students
for private groups. $35 per additional student $35 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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