Excel-guide.pdf
(
1707 KB
)
Pobierz
Microsoft Word - Beginning Excel.doc
Creating Excel Worksheets
Microsoft Excel 2003
Reference Guide
University Technology Services
Computer Training
Microsoft
Excel 2003
Copyright Notice
Copyright
2003 EBook Publishing. All rights reserved. No part of this publication may be reproduced, transmitted, or
translated into any language, in any form or by any means, electronically or mechanical, including photocopying,
recording, storage in a database or retrieval system, or otherwise, without the prior written permission of EBook
Publishing.
Disclaimer
We take great care to ensure the accuracy of these materials; however, EBook Publishing makes no warranty, express or
implies, including without limitation any warranty concerning the adequacy, accuracy or completeness of such information
or material or the results to be obtained from using such information or material. EBook Publishing reserves the right to
revise this publication and to make changes in its content at any time, without obligation to notify any person or entity of
such revisions or changes.
Microsoft
Excel 2003
TABLE OF CONTENTS
GETTING STARTED ........................................................................................ 1
Creating an Excel 2003 Workbook........................................................................................... 2
How to Start Excel 2003 ..................................................................................................... 2
How to Create a New Default Excel Workbook .................................................................. 3
Getting Familiar with the Excel 2003 Screen .......................................................................... 4
Moving Around Your Cursor .................................................................................................... 6
How to Activate a Cell Using the Mouse............................................................................. 6
How to Move to a Cell Using Keyboard .............................................................................. 7
How to Move to Other Sheets within a Workbook .............................................................. 8
Selecting Cells Range in Workbook ........................................................................................ 9
How to Select a Single Cell............................................................................................... 10
How to Select a Range of Cells ........................................................................................ 10
How to Select a Range Of Cells Using <Shift>................................................................. 10
How to Select the Entire Column ...................................................................................... 11
How to Select the Entire Row ........................................................................................... 11
How to Select the Entire Worksheet ................................................................................. 11
How to Select Non-Adjacent Ranges................................................................................ 12
How to Select Multiple Worksheets .................................................................................. 12
Entering Data into Worksheet ................................................................................................ 13
How to Enter Text (Label) Into a Cell................................................................................ 13
How to Edit Cell Contents ................................................................................................. 13
How to Edit Contents Using Formula Bar ......................................................................... 14
How to Replace Contents in a Cell ................................................................................... 14
How to Delete Contents in a Cell ...................................................................................... 14
How to Undo and Redo..................................................................................................... 15
How to Enter a Number as a Value into a Cell ................................................................. 16
How to Enter a Number as a Label into a Cell.................................................................. 17
How to Enter Date into a Cell............................................................................................ 18
How to Use AutoFill to Enter Text..................................................................................... 19
How to Use AutoFill Options ............................................................................................. 20
How to Use AutoFill to Enter Sequence Numbers............................................................ 21
How to Save a Workbook for the First Time ..................................................................... 22
How to Save Another Copy Using `Save As’ .................................................................... 22
How to Close the Current Workbook ................................................................................ 23
How to Open a Workbook ................................................................................................. 24
How to Exit Excel 2003 ..................................................................................................... 24
PERFORMING CALCULATIONS .................................................................. 25
Using Simple Formula............................................................................................................. 26
How to Enter a Formula Using Keyboard ......................................................................... 28
How to Enter a Cell or a Range Reference Using Mouse ................................................ 28
How to Use AutoSum to Calculate Total Quickly.............................................................. 29
How to Use Relative References ...................................................................................... 30
How to Use Absolute References ..................................................................................... 31
Using Simple Functions..........................................................................................................33
MANAGING WORKSHEET AND WORKBOOK INFORMATION.................. 35
Managing Worksheet Information.......................................................................................... 36
How to Move Information Using Cut and Paste................................................................ 36
How to Move Information Using Drag and Drop ............................................................... 37
Microsoft
Excel 2003
TABLE OF CONTENTS
How to Copy Information Using Copy and Paste ............................................................. 38
How to Use Paste Options................................................................................................ 39
How to Copy Information Using Drag and Drop ............................................................... 40
How to Insert a New Row ................................................................................................. 41
How to Insert Multiple Rows ............................................................................................. 42
How to Delete Rows.......................................................................................................... 43
How to Insert a New Column ............................................................................................ 44
How to Insert Multiple Columns ........................................................................................ 45
How to Delete Columns .................................................................................................... 46
How to Insert a Cell........................................................................................................... 47
Managing Workbook Information .......................................................................................... 48
How to Rename Worksheet .............................................................................................. 49
How to Add New Worksheet ............................................................................................. 50
How to Rearrange Worksheet........................................................................................... 51
How to Copy Worksheet ................................................................................................... 51
How to Format Worksheet Tab ......................................................................................... 52
How to Add Worksheet Background ................................................................................. 53
How to Delete Worksheet ................................................................................................. 54
FORMATTING WORKSHEET........................................................................ 55
Adjusting Column Width / Row Height.................................................................................. 56
How to Adjust Column Width Using Mouse ...................................................................... 57
How to Adjust Column Width Using Menu ........................................................................ 58
How to Adjust Row Height Using Mouse .......................................................................... 59
How to Adjust Row Height Using Menu ............................................................................ 60
How to Hide / Unhide Rows / Columns............................................................................. 61
How to Freeze a Column / a Row ..................................................................................... 62
How to Split a Worksheet in Panes................................................................................... 63
Formatting Cell Using Toolbar ............................................................................................... 64
How to Change Font ......................................................................................................... 64
How to Change Font Size ................................................................................................. 65
How to Bold....................................................................................................................... 65
How to Italic....................................................................................................................... 65
How to Underline............................................................................................................... 65
How to Change Font Color ............................................................................................... 66
How to Align Data in a Cell ............................................................................................... 67
How to Indent Data in a Cell ............................................................................................. 68
How to Merge Cells and Center Data ............................................................................... 69
How to Change Number to Percentage ............................................................................ 70
How to Increase/ Decrease Decimal Points ..................................................................... 71
How to Copy Format Using Format Painter ...................................................................... 72
Formatting Cell Using Menu Options .................................................................................... 73
How to Double Underline Using Menu Option .................................................................. 74
How to Align Vertically ...................................................................................................... 75
How to Change Text Orientation....................................................................................... 77
How to Wrap Text in a Cell ............................................................................................... 78
How to Format Numbers ................................................................................................... 79
How to Format Date .......................................................................................................... 80
How to Change Cell Background Color ............................................................................ 81
How to Add Outline Border ............................................................................................... 82
How to Add Double Line Border ....................................................................................... 83
Microsoft
Excel 2003
TABLE OF CONTENTS
How to Format Table Using AutoFormat .......................................................................... 84
SETTING UP PAGE AND PRINT................................................................... 85
Setting Up Page ....................................................................................................................... 86
How to Insert and Remove Page Break............................................................................ 87
How to Set and Clear Print Area....................................................................................... 88
How to Change Page Orientation ..................................................................................... 89
How to Change Scaling .................................................................................................... 89
How to Change Paper Size............................................................................................... 90
How to Change Page Margin............................................................................................ 90
How to Align to Center Of Page........................................................................................ 91
How to Add Header / Footer ............................................................................................. 92
Previewing and Printing.......................................................................................................... 94
How to Print Preview......................................................................................................... 95
How to Print Active Sheets ............................................................................................... 96
How to Print Selected Cells .............................................................................................. 97
How to Print Multiple Copies............................................................................................. 98
Plik z chomika:
p.lulewicz
Inne pliki z tego folderu:
Javascript-1-4.pdf
(1848 KB)
Research-Based-Web-Design-Usability-Guidelines.pdf
(21138 KB)
Windows-7-100-Most-Asked-Questions-Edition-2009.pdf
(1259 KB)
Learn-How-to-Repair-Computers-Get-Certified-in-15-Weeks.pdf
(2351 KB)
Eloquent-Javascript.pdf
(1425 KB)
Inne foldery tego chomika:
Dokumenty
Galeria
Personal Skills
Project Management
Prywatne
Zgłoś jeśli
naruszono regulamin