Basic Excel Handbook

29

5 48

2

7

1 0

1 3

1

Basic Excel Handbook

Version 3.6 May 6, 2008

Contents

Contents ................................................................................................. 1

Part I: Background Information ..............................................3

About This Handbook .................................................................................. 4 Excel Terminology...................................................................................... 5 Excel Terminology (cont.) ............................................................................ 6 Tips and Tricks.......................................................................................... 7

Part II: Excel 101........................................................................8

Excel Window Overview ............................................................................... 9 What is a Cell? .........................................................................................10 What Is A Column and A Row? .......................................................................11 Insert a Column ........................................................................................12 Delete a Column.......................................................................................13 Insert a Row ............................................................................................15 Delete A Row...........................................................................................16 Delete Multiple Rows..................................................................................18 Move Data Using Drag & Drop. ......................................................................19

Part III: Making Your Report Beautiful...................................21

Select Fonts and Sizes ................................................................................22 Color Fonts .............................................................................................23 Shade or Put Patterns In Cell(s).....................................................................24 Print Gridlines .........................................................................................27 Create Borders.........................................................................................29 Delete a Border ........................................................................................31 Merge & Center Cells .................................................................................32 Wrap Text ..............................................................................................33 Vertical Text ...........................................................................................35 Resize Columns ........................................................................................37

Part IV: Saving Money and Working Smart .........................38

Cumulative Fall and Spring Grade Point Averages - Using the Average Function ...........39

Basic Excel Handbook ? Page 1

Sort Alpha Data ........................................................................................43 Sort Numeric Data.....................................................................................45 Insert Date at the Top of Worksheet ...............................................................47 Insert Page Number at the Bottom Page ..........................................................51 Print the Top Row on Each Page ....................................................................55 Print the Worksheet Horizontally ...................................................................59 Print the Worksheet on One Page ..................................................................62 Preview Worksheet Without Printing...............................................................65

Basic Excel Handbook ? Page 2

Part I:

Background Information

Basic Excel Handbook ? Page 3

About This Handbook

This handbook was created by Angela Bolick as reference material for users who will view and print reports. It will be used during the Introductory Excel class. The handbook is divided into four sections:

? Part I provides shortcuts and basic Excel terminology. ? Part II describes Excel 101 tasks. ? Part III describes how to make you excel report cosmetically

appealing. ? Part IV has tips for working smart and saving money. Names used in the documentation are fictitious.

Basic Excel Handbook ? Page 4

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download