|
|
Get Going with Excel 2000
- Author: Palle Gronbek
- Ref: eW-1 876638 13 3
- AU$12.99
- 64 pages plus cover
- Get Going with Excel 2000 is written for beginners of spreadsheets but will also benefit experienced users of spreadsheets who are interested in honing their skills.
- This book covers the foundation of Excel spreadsheets plus its many useful applications and features.
- Users of earlier or for that matter later versions of Excel spreadsheets will also benefit from the systematic and well illustrated approach this book takes in explaining the
structure and features of Excel spreadsheets.
- Get Going with Excel 2000 is a practical guide for those who need to learn to use Excel spreadsheets quickly and simply.
- Please click here for a view of the Table of Contents of this title on Excel spreadsheets.
- e-Ways text books are readily available through a large number of Australian retail outlets.
In the event that you can't get to a store near you, we offer a mail order service.
e-Ways
Pty Ltd PO Box
3033 Moore Avenue
Lindfield
West NSW
2070 Australia
ABN:
94 086 732 121
Ph: +61 (02) 9499
5676 Fx: +61 (02)
9498 6317 click for
eMail Web:
www.e-Ways.com.au
Table of Contents:
Is This Booklet for You? ........... 4
Technical Language Only for Nerds?................... 4
The structure .......................... 4
Excel the first impression....... 5
General concepts .................. 5
What is a spreadsheet? ........... 5
Inserting text and numbers..... 5
Data types .............................. 6
Creating formulas................. 6
Menus and How You
Use Them........................... 8
Editing .................................. 9
Changing the contents of a
cell....................................... 9
Deleting the contents of a
cell....................................... 9
Undo ...................................... 9
Column width ........................ 9
Data Entry in Columns....... 11
Simple number
formatting ........................ 11
Selecting cells ...................... 12
Copying cells ............................ 13
Summing data..................... 14
Saving a file........................ 15
Help........................................... 16
Household budget .................... 17
Permanent preferences ......... 17
The Household budget ....... 18
Insert rows............................ 19
Inserting and deleting
columns............................. 19
Font and font size................. 20
Fill (series) ................................ 21
Creating your own lists ........ 22
Numbers and formulas in
our budget ................................ 23
Selecting formulas ............... 23
Saving the budget................. 24
Absolute cell references ..... 24
Annual total.......................... 25
Checking your formulas....... 25
Navigation ................................ 27
Formatting ............................... 28
Excel and Windows ................. 29
Toggling formats.................. 29
Viewing the spreadsheet.......... 30
Zoom.................................... 30
Freeze panes......................... 30
The Last Formulas .......... 30
Saving .................................. 30
Summary.................................. 31
Save As ................................ 32
Formatting the household
budget ....................................... 32
AutoFormat.........................32
Manual formatting ..............33
Moving data using the
mouse ................................ 33
Moving data using the
keyboard............................ 33
Updating Formulas............... 34
Borders................................34
Changing a border................ 35
Removing a border............... 35
Removing gridlines.............. 35
Shading and color ...............35
Copying formats................... 36
Printing the budget..............36
Data layout..........................37
Centering headings............... 37
Vertical layout...................... 37
Naming cells ............................. 38
Other advantages of
using names......................38
Entering formulas................. 38
Jumping to named cells........ 39
Names in the Household
budget .............................39
Printing..................................... 40
Margins ................................ 40
Headers and footers.............. 40
Scaling the printout .............. 41
Manual page breaks ............. 41
Repeating headings .............. 42
Print area .............................. 43
Fixed print area .................... 43
Printing named areas............ 43
Toolbars.................................... 44
Customizing toolbars ........... 44
Charts ....................................... 45
The Chart Wizard ...............45
A chart on a new page.......... 45
Updating a chart................... 46
Adjusting the format in a
chart................................... 46
Chart types ........................... 47
3-D perspective .................... 47
Save chart............................. 48
A chart on this sheet............. 48
Printing charts.....................48
Household Budget................ 49
Working with worksheet
tabs............................................ 50
Naming tabs ......................... 50
Deleting a sheet.................... 50
Inserting a sheet ................... 50
Copying sheets..................... 50
Functions .................................. 51
Average................................ 51
Other functions..................... 51
Calculating loan
payments.......................... 51
Naming cells in functions. ... 53
Links ......................................... 54
Sorting & filtering data........... 55
Sorting................................ 55
Filtering.............................. 55
User defined filters............... 56
Where do you want to go
tomorrow? ............................... 57
Read this while the cat
plays with the mouse......... 58
Index:
Absolute cell references, 24
AutoFilter, 55
Autoformat, 32
AutoSum, 14
Borders, 34
Calculating loan payments,
51
Cells, definition, 5
Changing the contents of a
cell, 9
Charts, 45
3-D perspective, 47
adjusting appearance, 46
on a new page, 45
on this sheet, 48
Printing, 49
Save, 48
Selecting data, 48
Types, 47
Column width, 10
Columns, definition, 5
Copying
Cells, 13
Copying using the
keyboard, 13
Copying using the mouse,
14
Formats, 36
Relative references, 13
Sheets, 50
Creating formulas, 6
Creating formulas
Brackets, 7
Formula bar, 7
Formulas, principles, 8
Operators, 6
Order of operations, 6
Customising Excel
Default File Locations, 18
Customizing Excel
Options, 17
Data layout, 37
Data types, 6
Decimals, 11
Deleting a sheet, 50
Deleting rows, 19
Deleting the contents of a
cell, 9
Editing, 9
Changing the contents of a
cell, 9
Column width, 10
Columns, 19
Deleting rows, 19
Deleting the contents of a
cell, 9
Insert rows, 19
Undo, 9
Excel and Windows, 29
File location, 18
Fill (series), 21
Creating your own lists, 22
Fill handle, 14
Filtering, 55
User defined filters, 56
Font, 20
Font size, 20
Format Painter, 36
Formatting, 28
Autoformat, 32
Borders, 34
Centering headings, 37
Copying formats, 36
Data layout, 37
Format Painter, 36
Manual formatting, 33
Shading and color, 35
Toggling formats, 29
Vertical layout, 37
Formula
Absolute cell references,
24
Check your formulas, 25
Linked spreadsheets, 54
Formula bar, 5; 7
Formulas, principles, 8
Functions, 51
Average, 51
FunctionWizard, 51
Loan payment calculations,
51
Naming cells in functions.,
53
Graphs (charts), 45
Headers and footers, 40
Help, 16
TipWizard, 16
Household budget, 17
Insert rows, 19
Insert sheet, 50
Inserting text and numbers, 5
Formula bar, 5
Links, 54
Manual formatting, 33
Margins, 40
Moving around in a
spreadsheet, 27
Moving data using the
keyboard, 33
Moving data using the mouse,
33
Naming cells, 38
Apply name, 39
Entering formulas, 38
Jumping to, 39
Naming tabs, 50
Navigation, 27
New Workbook, 18
Operators, 6
Options, 17
Order of operations, 6
Page breaks, 41
Print
Print Preview, 36
Print area, 43
Print Preview, 36
Printing, 40
Headers and footers, 40
Manual page breaks, 41
Margins, 40
Print area, 43
Repeating headings, 42
Scaling the printout, 41
Relative references, 13
Repeating headings, 42
Rows, definition, 5
Save a file
Save, 15
Save as, 15
Saving a file, 15
Selecting, 12
Selecting formulas, 23
Shading and color, 35
Shortcut keys, summary, 58
Simple number formatting
Decimals, 11
Sorting, 55
Spreadsheets - naming (tabs),
50
Summing data, 14
AutoSum, 14
Undo, 9
Updating formulas, 34
Viewing the spreadsheet, 30
Freeze panes, 30
Zoom, 30
Workbook, 5
|
