TTC 

Microsoft Excel

 

Introduction to Excel

This class provides an introduction to the spreadsheet program, Excel.  Participants will learn the Excel basics, including:

  • Entering, editing, and deleting data
  • Creating simple formulas
  • Using built-in functions
  • Filling formulas and labels
  • Changing the page set-up
  • Resizing columns and rows
  • Adding and deleting columns and rows
  • Moving and copying data using the mouse and the cut, copy, and paste commands
  • Formatting numbers and text
  • Using borders and shading
  • Creating a chart with Excel’s built-in Chart Wizard
  • Creating a template

Two 3-hour sessions. Cost: $100. Seniors: $60.

 

Intermediate Excel

A step beyond the basics, this class includes:

  • Linking files

  • Protecting your data

  • Working with multiple sheets

  • Creating a macro

  • 3-D formulas that combine like cells from several sheets

  • Formulas that link and simultaneously calculate a group of values from multiple workbooks

  • IF formulas

  • Formulas that work with time and dates

One 3-hour session. Cost: $50. Seniors: $30.

Creating and Merging an Excel Database

In addition to being a spreadsheet program, Excel often doubles as a database program, used to store and organize textual data such as names, addresses, and telephone numbers.  Such a database is often used as the data source for a mail merge. 

In this class, using Excel and Word, you will learn how to:

  • Create a database in Excel

  • Apply custom formatting to make data entry simple

  • Use techniques that make data entry quick and easy

  • Sort your data alphabetically, numerically, or by date

  • Filter your database so that only records that meet specific criteria can be seen

  • Create COUNTIF and SUMIF formulas

  • Use your database to create labels, envelopes, and form letters using Word’s Mail Merge function

 One 3-hour session.  Cost: $50.  Seniors: $30.

 

Technology Training Center
York, Pennsylvania

 Contact Us | Home