Welcome to

 

         Lifeline to Learning®

          The online learning center for life's most important skills

                                                    About Our Courseware
    All Lifeline to Learning courseware has been developed, tested
    and proven effective over many years. Each program has been
    created as a tool to be used either by an instructor in a workshop
    environment, or for individual use.  All of our courses are user
    friendly and easily downloaded.

    System Requirements:   Adobe Reader, level 8 or newer
                                                   Microsoft Office, Version 2007
                                                      Get Adobe Reader

Microsoft Excel Basic
                                                                                                Table of Contents of The Instructor's Guide

Table of Contents

Section 1: Getting Started .............................................................................................................. 1

Lesson 1.1: Starting Out ........................................................................................................................ 2

What is Microsoft Excel 2007? ............................................................................................................................ 2

Opening Microsoft Excel.................................................................................................................................... 3

Interacting with Excel ........................................................................................................................................ 6

Closing Excel ..................................................................................................................................................... 8

Step-By-Step ..................................................................................................................................................... 10

Lesson 1.2: About Workbooks ............................................................................................................ 14

Creating a New Workbook ............................................................................................................................... 15

Opening a Workbook ....................................................................................................................................... 19

Saving a Workbook .......................................................................................................................................... 22

About Excel File Types..................................................................................................................................... 23

Closing a Workbook ......................................................................................................................................... 25

Step-By-Step ..................................................................................................................................................... 27

Skill Sharpener ................................................................................................................................................. 31

Lesson 1.3: Exploring your Workbook ............................................................................................... 32

Using Worksheets ............................................................................................................................................. 32

The Active Cell ................................................................................................................................................. 34

Selecting Cells .................................................................................................................................................. 35

Exploring a Worksheet ..................................................................................................................................... 35

The Zoom Feature ............................................................................................................................................ 36

Step-By-Step ..................................................................................................................................................... 40

Skill Sharpener ................................................................................................................................................. 43

Lesson 1.4: Getting Help in Excel 2007 .............................................................................................. 44

Using the Help Screen ...................................................................................................................................... 44

About Online Help ........................................................................................................................................... 46

About Offline Help ........................................................................................................................................... 48

Step-By-Step ..................................................................................................................................................... 50

Skill Sharpener ................................................................................................................................................. 53

Section 1: Case Study ........................................................................................................................... 54

Section 1: Review Questions ................................................................................................................ 55

Section 2: The New Interface ...................................................................................................... 58

Lesson 2.1: The Quick Access Toolbar ............................................................................................... 59

The Default Buttons ......................................................................................................................................... 59

Adding Buttons ................................................................................................................................................. 60

Removing Buttons ............................................................................................................................................ 61

Customizing the Toolbar .................................................................................................................................. 61

Step-By-Step ..................................................................................................................................................... 65

Skill Sharpener ................................................................................................................................................. 68

Lesson 2.2: The Home Tab .................................................................................................................. 69

Clipboard ......................................................................................................................................................... 69

Font .................................................................................................................................................................. 71

Alignment ......................................................................................................................................................... 72

Number ............................................................................................................................................................. 74

Style .................................................................................................................................................................. 75

Cells ................................................................................................................................................................. 75

Editing .............................................................................................................................................................. 76

Step-By-Step ..................................................................................................................................................... 78

Skill Sharpener ................................................................................................................................................. 83

Lesson 2.3: The Insert Tab .................................................................................................................. 84

Tables ............................................................................................................................................................... 84

Charts ............................................................................................................................................................... 85

Illustrations ...................................................................................................................................................... 86

Shapes .............................................................................................................................................................. 87

Links ................................................................................................................................................................. 88

Text ................................................................................................................................................................... 89

Step-By-Step ..................................................................................................................................................... 90

Skill Sharpener ................................................................................................................................................. 95

Lesson 2.4: The Page Layout Tab ....................................................................................................... 96

Themes ............................................................................................................................................................. 96

Page Setup ..................................................................................................................................................... 100

Scale to Fit ..................................................................................................................................................... 103

Sheet Options ................................................................................................................................................. 104

Arrange .......................................................................................................................................................... 105

Step-By-Step ................................................................................................................................................... 108

Skill Sharpener ............................................................................................................................................... 112

Lesson 2.5: The Formulas Tab .......................................................................................................... 113

The Function Library ..................................................................................................................................... 113

Defined Names ............................................................................................................................................... 115

Formula Auditing ........................................................................................................................................... 116

Calculation ..................................................................................................................................................... 116

Step-By-Step ................................................................................................................................................... 118

Skill Sharpener ............................................................................................................................................... 121

Lesson 2.6: The Data Tab .................................................................................................................. 122

Get External Data .......................................................................................................................................... 122

Connections .................................................................................................................................................... 123

Sort and Filter ................................................................................................................................................ 123

Data Tools ...................................................................................................................................................... 124

Outline............................................................................................................................................................ 125

Step-By-Step ................................................................................................................................................... 126

Skill Sharpener ............................................................................................................................................... 130

Lesson 2.7: The Review Tab .............................................................................................................. 131

Proofing ......................................................................................................................................................... 131

Comments ....................................................................................................................................................... 132

Changes.......................................................................................................................................................... 133

Step-By-Step ................................................................................................................................................... 134

Skill Sharpener ............................................................................................................................................... 137

Section 2: Case Study ......................................................................................................................... 138

Section 2: Review Questions .............................................................................................................. 139

Section 3: Excel Basics .............................................................................................................. 141

Lesson 3.1: Working With Excel 2007 .............................................................................................. 142

Columns, Rows, Cells, and Ranges .................................................................................................................. 142

Creating Worksheet Labels .............................................................................................................................. 144

Entering and Deleting Data ............................................................................................................................. 145

Printing Your Worksheet ................................................................................................................................ 147

Step-By-Step ................................................................................................................................................... 149

Skill Sharpener ............................................................................................................................................... 152

Lesson 3.2: Basic Excel Features ....................................................................................................... 153

What is AutoFill? ........................................................................................................................................... 153

What is AutoSum? .......................................................................................................................................... 156

What is AutoComplete? .................................................................................................................................. 158

Working with Basic Formulas .......................................................................................................................... 159

Step-By-Step ................................................................................................................................................... 161

Skill Sharpener ............................................................................................................................................... 164

Lesson 3.3: Moving your Data ........................................................................................................... 165

Dragging and Dropping Cells ......................................................................................................................... 165

How to Cut, Copy, and Paste Cells .................................................................................................................. 166

How to Cut, Copy, and Paste Multiple Cells and Items ................................................................................... 168

How to Use Paste Special ............................................................................................................................... 170

How to Insert and Delete Cells, Rows, and Columns....................................................................................... 173

Using Undo, Redo, and Repeat ........................................................................................................................ 177

Step-By-Step ................................................................................................................................................... 179

Skill Sharpener ............................................................................................................................................... 183

Lesson 3.4: Smart Tags and Options Buttons .................................................................................. 184

What Are Smart Tags? ................................................................................................................................... 184

The Error Option Button ................................................................................................................................ 185

The AutoFill Option Button .............................................................................................................................. 186

The Paste Option Button ................................................................................................................................ 187

Setting Smart Tag Options ............................................................................................................................... 187

Step-By-Step ................................................................................................................................................... 189

Skill Sharpener ............................................................................................................................................... 192

Lesson 3.5: Editing Tools ................................................................................................................... 193

Using AutoCorrect ......................................................................................................................................... 193

Using Spell Check .......................................................................................................................................... 194

Using Find and Replace ................................................................................................................................. 195

Adding Comments .......................................................................................................................................... 197

Step-By-Step ................................................................................................................................................... 200

Skill Sharpener ............................................................................................................................................... 205

Section 3: Case Study ......................................................................................................................... 206

Section 3: Review Questions .............................................................................................................. 207

Section 4: Editing Your Workbook ........................................................................................... 209

Lesson 4.1: Modifying Cells and Data .............................................................................................. 210

Changing the Size of Rows or Columns ........................................................................................................... 210

Adjusting Cell Alignment ............................................................................................................................... 212

Rotating Text .................................................................................................................................................. 214

Creating Custom Number and Date Formats .................................................................................................. 217

Step-By-Step ................................................................................................................................................... 222

Skill Sharpener ............................................................................................................................................... 226

Lesson 4.2: Cell Formatting ............................................................................................................... 227

Conditional Formatting ................................................................................................................................. 227

The Format Painter ........................................................................................................................................ 234

Cell Merging and AutoFit ............................................................................................................................... 236

Find and Replace Formatting .......................................................................................................................... 237

Step-By-Step ................................................................................................................................................... 241

Skill Sharpener ............................................................................................................................................... 247

Lesson 4.3: Enhancing a Worksheet’s Appearance ......................................................................... 248

Adding Patterns and Colors ............................................................................................................................. 248

Adding Borders .............................................................................................................................................. 252

Working with Styles ........................................................................................................................................ 254

Step-By-Step ................................................................................................................................................... 259

Skill Sharpener ............................................................................................................................................... 266

Lesson 4.4: Working With Charts, Part 1 ........................................................................................ 267

Creating a Chart ............................................................................................................................................ 267

Formatting a Chart ........................................................................................................................................ 269

Modifying Charts with the Layout Tab ............................................................................................................ 276

Manipulating a Chart ..................................................................................................................................... 289

Enhancing a Chart with Shapes and Graphics ................................................................................................ 297

Step-By-Step ................................................................................................................................................... 300

Skill Sharpener ............................................................................................................................................... 307

Lesson 4.5: Working with Charts, Part 2 ......................................................................................... 308

Changing the Type of Chart ............................................................................................................................. 308

Changing the Source Data ............................................................................................................................... 311

Working with the Chart Axis and Data Series ................................................................................................. 314

Saving a Chart as a Template .......................................................................................................................... 322

Step-By-Step ................................................................................................................................................... 324

Skill Sharpener ............................................................................................................................................... 330

Section 4: Case Study ......................................................................................................................... 331

Section 4: Review Questions .............................................................................................................. 332

Section 5: Printing and Viewing your Workbook ..................................................................... 335

Lesson 5.1: Using the View Tab ........................................................................................................ 336

Using Normal View ........................................................................................................................................ 336

Using Full Screen View .................................................................................................................................. 338

Using Page Layout View ................................................................................................................................ 340

Page Break Preview ....................................................................................................................................... 345

Step-By-Step ................................................................................................................................................... 348

Skill Sharpener ............................................................................................................................................... 353

Lesson 5.2: Managing a Single Window ........................................................................................... 354

Creating a New Window ................................................................................................................................ 355

Hiding a Window ........................................................................................................................................... 356

Unhiding a Window ....................................................................................................................................... 357

Freezing a Pane ............................................................................................................................................. 357

Step-By-Step ................................................................................................................................................... 361

Skill Sharpener ............................................................................................................................................... 364

Lesson 5.3: Managing Multiple Windows ........................................................................................ 365

Switching Between Open Workbooks ............................................................................................................... 365

Arranging Workbooks .................................................................................................................................... 366

Comparing Workbooks Side by Side ................................................................................................................ 370

Synchronous Scrolling, Resetting a Window, and Saving a Workspace .......................................................... 371

Step-By-Step ................................................................................................................................................... 373

Skill Sharpener ............................................................................................................................................... 378

Lesson 5.4: Printing your Workbook................................................................................................ 379

Opening Print Preview ................................................................................................................................... 380

Using the Print Preview Tab ............................................................................................................................ 382

Quick Printing ................................................................................................................................................ 385

The Print Dialog ............................................................................................................................................ 386

Using Page Setup ........................................................................................................................................... 388

Step-By-Step ................................................................................................................................................... 392

Skill Sharpener ............................................................................................................................................... 398

Section 5: Case Study ......................................................................................................................... 399

Section 5: Review Questions .............................................................................................................. 400

Index ......................................................................................................................................... 402