Microsoft Excel Beginner

Overview

​

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.

Target Student

This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.

Prerequisites

​

Basic Windows, keyboarding and mouse skills.

Duration

​

1 day

​

Course Outline​

​

1. Getting Started With Microsoft Office Excel 2016

• Topic A: Navigate the Excel User Interface

• Topic B: Use Excel Commands

• Topic C: Create and Save a Basic Workbook

• Topic D: Enter Cell Data

• Topic E: Use Excel Help

​

2. Performing Calculations

• Topic A: Create Worksheet Formulas

• Topic B: Insert Functions

• Topic C: Reuse Formulas and Functions

​

3. Modifying a Worksheet

• Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

• Topic B: Search for and Replace Data

• Topic C: Use Proofing and Research Tools

​

4. Formatting a Worksheet

• Topic A: Apply Text Formats

• Topic B: Apply Number Formats

• Topic C: Align Cell Contents