Excel – Level 1

Description

Overview:

Learn the basic concepts and skills students need to start being productive with Microsoft Excel including how to create, save, share, and print worksheets that contain various kinds of calculations and formatting.

Prerequisite(s):

At least one year experience using Windows 10, 8, or 7

Audience:

Outline:

Lesson 1: Fundamentals

• Getting around
• Workbook basics

Lesson 2: Creating worksheets

• Entering data
• Formulas
• Functions
• Moving and copying data
• Reference types

Lesson 3: Formatting

• Text formatting
• Number formatting
• Alignment
• Borders and highlighting
• Styles and themes

Lesson 4: Manipulating data

• Data entry shortcuts
• Paste options
• Inserting, deleting, and hiding

Lesson 5: Charts

• Creating charts
• Chart types and elements

Lesson 6: Output

• Managing worksheet windows
• Printing worksheets
• Sharing workbooks

Lesson 7: Settings and templates

• Workbook options and properties
• Templates