Getting Started


  • Starting Excel

  • Understanding the Display Screen

  • Working with the Ribbon

  • Working with the Quick Access Toolbar

  • Exploring the File Tab

  • Opening a Workbook

  • Managing Open Workbooks

  • Using Excel Help

Entering Data


  • Moving the Cell Pointer

  • Selecting a Range of Cells

  • Creating a New Workbook

  • Entering Constant Values

  • Saving a Workbook

  • Editing Cell Contents

  • Clearing Cell Contents

  • Working with Undo and Redo

  • Closing a Workbook

  • Exiting Excel

Using Formulas


  • Entering Formulas

  • Using the SUM Function

  • Summing Columns or Rows Automatically

  • Using Statistical Functions

  • Working with the Range Finder

  • Using Formula Error Checking

Formatting Worksheets

  • Formatting Numbers

  • Changing the Font Format

  • Aligning Cell Contents

  • Merging Cells

  • Adding Borders

  • Applying Cell Styles


Columns and Rows


  • Changing Column Width and Row Height

  • Using AutoFit

  • Inserting and Deleting Columns or Rows

  • Hiding Columns or Rows

  • Using Custom Worksheet Views

Microsoft Excel

Hours of Operation   

PITA Campus Hours

Monday - Friday 8am to 5pm

PITA Testing Center Hours

Tuesday, Wednesday, Thursday: 9am to 10pm


Friday, Saturday: 9am to 5pm

2625 S. Rainbow Blvd Ste. B-100

Las Vegas, NV 89146

​Tel: 702-853-7482 (PITA) 

​Fax: 702-853-9075    

© 2017 by Professional Institute of Technology

Licensed by the Commission on Post-Secondary Education

  • w-facebook