DOWNLOAD COURSE
Table of Contents
Getting started with Excel........................................................................................ 4
What is Excel? .................................................................................................................... 4
The Excel 2007 window ...................................................................................................... 4
Starting Excel ...................................................................................................................... 5
Closing Excel ...................................................................................................................... 6
Navigating within a worksheet ............................................................................................ 6
Selecting cells ..................................................................................................................... 7
Selecting rows or columns .................................................................................................. 7
Entering data ............................................................................................................. 8
First you need a workbook.................................................................................................. 8
Overview of data types........................................................................................................ 8
Data entry cell by cell.......................................................................................................... 9
Deleting data ....................................................................................................................... 9
Moving data......................................................................................................................... 9
Copying data ....................................................................................................................... 9
Using Autofill ..................................................................................................................... 10
Saving a workbook............................................................................................................ 10
Editing data.............................................................................................................. 11
Editing cell contents .......................................................................................................... 11
Inserting or deleting cells .................................................................................................. 11
Inserting or deleting rows.................................................................................................. 12
Inserting or deleting columns ............................................................................................ 12
Inserting or deleting a worksheet ...................................................................................... 12
Moving or copying a worksheet ........................................................................................ 13
Renaming a worksheet ..................................................................................................... 13
Formatting data....................................................................................................... 14
Cell formatting ................................................................................................................... 14
Formatting rows and columns........................................................................................... 14
Hiding rows and columns.................................................................................................. 15
Keeping row and column headings in view....................................................................... 16
Creating a formula............................................................................................................. 17
How formulas are evaluated ............................................................................................. 18
Relative cell referencing.................................................................................................... 18
Absolute cell referencing................................................................................................... 18
Functions................................................................................................................. 21
Using AutoSum ................................................................................................................. 21
Basic functions .................................................................................................................. 21
The IF() function................................................................................................................ 23
Nested functions ............................................................................................................... 23
Printing..................................................................................................................... 24
Print preview ..................................................................................................................... 24
Preparing to print............................................................................................................... 24
Printing a worksheet.......................................................................................................... 25
Charts....................................................................................................................... 26
Creating a chart................................................................................................................. 26
Modifying a chart............................................................................................................... 27
Inserting graphics in a worksheet ..................................................................................... 27
Data manipulation................................................................................................... 28
Sort.................................................................................................................................... 28
Filter .................................................................................................................................. 28
Subtotals ........................................................................................................................... 29
Introduction to MS Excel 2007 3
2009 Centre for Educational Technology, University of Cape Town
MS Excel Task Sheet .............................................................................................. 31
0 comentarios:
Publicar un comentario