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

Modifying

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

  • w-facebook

© 2017 by Professional Institute of Technology

2625 S. Rainbow Blvd Ste. B-100

Las Vegas, NV 89146

​Tel: 702-853-7482 (PITA) 

​Fax: 702-853-9075    

Licensed by the Commission on Post-Secondary Education