Class Outline

 
UNC Charlotte

Information & Technology Services
Faculty and Staff Training

 

Getting Started with Excel Spreadsheets

Microsoft Excel spreadsheets allow for easy manipulation and calculation of numeric data. This class will teach you how to create a spreadsheet in Excel, and manipulate, format and edit cells and cell data.

Length: 
2 hours		 Book:
Optional Reference Book
 		 Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows (or Macintosh) Desktop

Download Module

Course Content


Getting Started with Excel 
  • Starting the program
  • The program window
  • Opening & saving a spreadsheet
  • Selecting cells
  • Selecting toolbars
  • Closing, & exiting

Building and Editing Worksheets

  • Planning, designing, and creating a worksheet
  • Entering text and numerical data
  • Copying and moving cell entries
  • Creating basic formulas
Formatting a Worksheet
  • Selecting fonts and point sizes
  • Changing attributes and alignment
  • Adjusting column widths
  • Inserting and deleting rows and columns
  • Applying colors, and borders
  • Checking spelling
 

Top of Page