About Us News and Events Membership Ordering Support Contacts Site Map OCLC
Home Education and Training eContent OCLC Services Consulting and Custom Training Digitization and Preservation  

Microsoft® Excel for Power Users 1a: Creating & Modifying Worksheets

Register for upcoming sessions of this course

Policies, cancellations, and inclement weather information.

Prerequisites 

Basic Windows® skills and working knowledge of Excel.

Course description

Custom Training Course

Learn how to be more effective when using Excel.  This 1/2 day course is designed to review three major components of the software program in order to help you become more efficient and successful.

Why take this course?

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet.  You have also used paper-based systems to store data and run calculations manually.  You now want to save time and move that data to an electronic format.  In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

What you will learn

You will get an overview of Excel, perform tasks with worksheets, and use electronic calculations.

Topics covered include

Getting Started with Excel

  • An Overview of Excel
  • Navigate Excel
  • Select Data
  • Enter Data
  • Save a Workbook
  • Obtain Help

Modifying a Worksheet

  • Move and Copy Data Between Cells
  • Fill Cells with Series of Data
  • Edit Cell Data
  • Insert and Delete Cells, Columns, and Rows
  • Find, Replace, and Go To Cell Data
  • Spell Check a Worksheet

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create an Absolute Reference

Follow up courses

Course details

Course: S 101

Duration: 1/2 Day

Fee:

Members:   112.00
Non-Members:   160.00

Instructor: