Beginning Excel -Step by Step Basics: Training Session 1- Parts 1 & 2

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

*Please email kariwood@evolve-consultingandtraining.com for discount pricing on 10 or more units.