Computer Software Training - York, Pa Computer Software Training - York, Pa
Computer Software Training - York, Pa Computer Software Training - York, Pa
Computer Software Training - York, Pa

Computer Education

Beginner to Advanced Classes


Ask about Customized Classes


On-site Employee Training

Database Design

Call on Sargent Software
to create or
to assist with the creation of
Excel or PowerPoint projects
at your place of business.

Serving Central Pennsylvania -
York, Lancaster, Harrisburg
and surrounding areas

Jeanina Sargent
(717) 586-1878
Contact Jeanina

Become a fan of Sargent Software on Facebook

Microsoft Excel as a Database

Students will learn how to create a Database in Microsoft Excel where records can be sorted and filtered. Learn how simple queries can generate powerful result.

 

 

Database Manager

  • Creating a Database
  • Sorting Data
  • Filtering Data
  • Using a Data Form

Consolidating Data

  • Linking Files
  • Updating Links

Organizing Your Worksheets

  • Working with Multiple Sheets
  • Inserting a New Worksheet
  • Naming Worksheets
  • Moving Worksheets
  • Hiding/Unhiding Groups

Formatting Options

  • Custom Formatting

Excel Functions

  • Formulas

Excel Charts

  • Creating Charts
  • Selecting Chart Objects
  • Sizing The Chart
  • Applying Text Attributes to Chart Objects
Computer Software Training - York, Pa
Computer Software Training - York, Pa Computer Software Training - York, Pa