PDF Basic Excel 3.5 - San Diego Unified School District
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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf introduction to microsoft excel 2016
- pdf microsoft excel tips tricks queen s university
- pdf excel 2016 charts colorado state university
- pdf microsoft office 2016 step by step
- pdf about the tutorial current affairs 2018 apache commons
- pdf basic excel 3 5 san diego unified school district
- pdf microsoft excel 2013 a beginners guide
- pdf 5 1 introduction to microsoft excel lesson plan
- pdf excel 2016 quick reference
- pdf excel 2016 tips tricks colorado state university
Related searches
- los angeles unified school district website
- kansas unified school district map
- davis unified school district calendar
- stockton unified school district directory
- clovis unified school district calendar 2021
- riverside unified school district jobs
- stockton unified school district office
- unified school district jobs
- clovis unified school district calendar 2020
- stockton unified school district email
- chico unified school district calendar
- central unified school district calendar