Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Introduction to Microsoft Excel

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to enter and edit information, write formulas, format cells, and print in Microsoft Excel.  This course is geared to new users who have little or no experience using Microsoft Excel or another spreadsheet application.

Course objectives:

  • Understand how to enter text, numbers, and dates properly
  • Write basic formulas that add, subtract, multiply, and divide cells
  • Format workbooks by setting columns widths, aligning data, formatting numbers, and applying borders/shading
  • Manage worksheets, keep headings on the screen, and sort data
  • Set print options and print workbooks

Building Simple Workbooks

  • Starting Excel and Examining Screen Elements
  • Basic Workbook Components
  • Opening Workbooks
  • Reviewing Workbook Data
  • Navigating Worksheets
  • Understanding Compatibility Mode
  • Entering General Text, Numbers, and Dates
  • Editing and 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
  • Checking for Spelling Errors
  • Saving and Closing Workbooks
  • Using Excel's Help Feature

Managing Worksheets

  • Renaming Worksheets
  • Adding Color to Worksheet Tabs
  • Moving Worksheets
  • Inserting and Deleting Worksheets

Writing and Copying Basic Formulas

  • Understanding Formulas Elements and Syntax
  • Understanding Excel’s Order of Precedence
  • Creating Basic Formulas
  • Using Functions in Formulas
  • Using the Sum Button
  • Copying Formulas
  • Using the Insert Function Tool
  • Using the TODAY Function to Insert the Current Date
  • Using Dates in Formulas
  • Using AutoCalculate

 

 

Formatting Worksheets

  • Changing Column Widths
  • Applying Fonts, Bold, Underline, and Italics
  • Copying Formatting from One Cell to Another
  • Aligning Data in Cells
  • Centering Data Across Columns
  • Wrapping Text within Cells
  • Formatting Numbers and Formulas
  • Formatting Dates
  • Applying Borders
  • Applying Fill Color
  • Inserting and Deleting Columns or Rows
  • Inserting Columns and Rows
  • Deleting Columns and Rows
  • Inserting Pictures or Clip Art
  • Moving and Resizing Pictures
  • Deleting Pictures

Freezing, Hiding, and Sorting Data

  • Keeping Headings on the Screen as You Work
  • Hiding and Unhiding Columns
  • Sorting Lists of Information
  • Creating Custom Sorts

Working with Printing and Page Setup Options

  • Previewing Before Printing
  • Changing Page Orientation
  • Adjusting Page Scaling
  • Printing Row and Column Headings
  • Adding Page Numbering
  • Printing Worksheets
  • Page Setup Options

 

 

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

$275 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$850 flat fee for up to 8 students
$950 for up to 12 students
$50 per additional student

Conducted at Softek’s Facility

$1000 flat fee for up to 8 students
$1100 for up to 12 students
$50 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Softek also offers a 3-hour series for this application. Visit our agendas page  to view our 3-hour classes. 

Why choose Softek?

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