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