Table of Contents
TRAINING SESSION 1
Unit Overview
Unit Learning Outcomes (ULOs)
Case Study: Louie’s Bait Shop
TOPIC 1.1—UNDERSTANDING EXCEL’S INTERFACE
Starting Excel
Open a Workbook
Applying the Ribbon Display Options and Quick Access Toolbar
Create a New Workbook
Save a Workbook
Switching Between Open Workbooks
Using Help
Practice Project 1-1: Create and Save a Workbook
TOPIC 1.2—ENTERING DATA
Using Cell Pointer Options
Selecting a Cell Range
Enter Text and Numbers
Edit Cell Contents
Replace or Clear Cell Contents
Align and Indent Cell Contents
Cut, Copy, and Paste Cell Contents
Inserting, Renaming, and Deleting Worksheets
Practice Project 1-2: Edit a Worksheet
TOPIC 1.3—USING BASIC FORMULAS
Exploring the Formulas tab
Entering Formulas
Using the Sum Function
Using the Insert Function Button
Using Absolute and Relative Cell References
Editing the Formula Cell Range
Using the Range Finder and Error Checker
Practice Project 1-3: Use Basic Formulas
TOPIC 1.4—FORMATTING A WORKSHEET
Changing Font Face, Size, and Color
Aligning Cell Contents
Applying Cell Styles
Using the Format Painter
Applying Number Formats
Using Borders and Shading
Using Workbook Themes
Practice Project 1-4: Format Data in a Worksheet
Excel Workshop Application-1