Muutke küpsiste eelistusi

No Stress Tech Guide to Microsoft Works 9 [Pehme köide]

  • Formaat: Paperback / softback, 360 pages, kõrgus x laius x paksus: 235x191x18 mm, kaal: 620 g, 1, black & white illustrations
  • Ilmumisaeg: 01-May-2008
  • Kirjastus: Tolana Publishing
  • ISBN-10: 0977391272
  • ISBN-13: 9780977391271
  • Formaat: Paperback / softback, 360 pages, kõrgus x laius x paksus: 235x191x18 mm, kaal: 620 g, 1, black & white illustrations
  • Ilmumisaeg: 01-May-2008
  • Kirjastus: Tolana Publishing
  • ISBN-10: 0977391272
  • ISBN-13: 9780977391271
This guide is intended for new users of Microsoft Works 9 or for users upgrading from a previous version. Topics are presented with step-by-step instructions in five parts: Works overview, word processing, spreadsheets, databases, and organization. Over 500 screen shots and illustrations illuminate the processes, while the instructions are easy to follow for even the most technologically uninspired student. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

The fastest and easiest way to overcome an obstacle is to have someone who has been there, to be by your side every step of the way. That is the purpose of this book - to be by your side every step of the way through learning Microsoft Works 9. The No Stress Tech Guide To Microsoft Works 9 will lead the novice and intermediate user through the features and applications that are part of Works 9, which will take your skills to the next level. This book is not for Works advanced or power users. After completing the exercises in this book, you will be a Works 9 power user! The table of contents takes the HOW TO approach, which makes it easier to find exactly what you are looking for. At the end of each lesson is a "Test Your Skills" section to further ensure that you are learning the topics that are covered. The exercises in this section allow you to practice what you learned in the lesson. This book will guide you through the highways of Microsoft Works and get you up to speed. Differences between this version and the prior version will also be pointed out, in case you upgraded from the previous version of Works. Microsoft Works is an integrated software package that includes a word processor, spreadsheet, database and other tools. This book is divided into 5 sections - Works Overview, Word Processing, Spreadsheets, Databases and Organization. A hands-on approach is usually the best way to learn most things in life. This book is a visual guide, that has over 500 screen shots that practically eliminate the guess work, which lets you know that you are doing the steps correctly. There are time saving tips, advice and humor to help you get the most out of Works. Works 8 & 8.5, ISBN 978-0-9773912-1-9 is also available.
Section 1 Overview
Introduction to Works 9
1(1)
What's Covered In Each Section Of The Workbook
2(1)
Conventions Used In This Workbook
2(1)
Assumptions
3(1)
How To Check For A Complete Installation
4(1)
Re-Installing Works
4(2)
Major Components Of Works
6(1)
Word Processor
6(1)
Spreadsheets
6(1)
Databases
6(1)
Other Tools That You Can Use
7(1)
Clip Art Gallery
7(1)
Format Gallery
8(1)
Works Terminology
8(1)
How To Create A Shortcut For Works
9(1)
How To Start Works
10(1)
Works Task Launcher
10(1)
A Quick Tour of Microsoft Works
11(2)
Home Page
11(1)
Templates Window
11(1)
Programs Window
12(1)
History Window
12(1)
Other Tools In Works
13
The Calendar
13(1)
The Project Organizer
14(1)
The Portfolio
15(1)
PowerPoint Viewer
16
Getting Started
1(1)
Toolbars
2(1)
Menus
2(1)
Dialog Boxes
3(1)
Text Boxes
3(1)
Option Buttons
3(1)
List Boxes
3(1)
Combo Boxes
4(1)
Check Boxes
4(1)
Command Buttons
4(1)
The Difference Between Save and Save As
4(1)
Keeping Documents Organized
5(1)
How To Create A Folder In Works
5(1)
How To Download The Practice Files to Your Hard Drive
6(1)
Check Your Settings In Works
6(5)
Check Your Word Processor Settings
7(2)
Check Your Spreadsheet Settings
9(1)
Check Your Database Settings
10(1)
The Help System
11(3)
The Task Launcher Help System
11(2)
The Application Help System
13(1)
Backing Up Your Work
14(1)
Other Sources of Help
14
Works Home Page
14(1)
Getting Started File
15(1)
Newsgroups
15
Templates
1(1)
How To Create Mailing Labels
2(5)
Label Setting Options
2(1)
Select The Label Settings
3(1)
Select The Data Source
3(1)
Select The Fields To Print On The Label
4(2)
Save The Label Document
6(1)
Create A Fax Cover Page
7(1)
Modify The Fax Cover Page
7(1)
Save The Fax Cover Page As A Template
8(1)
Create A Half-Fold Brochure
9(1)
Create A Newsletter
9(1)
Create A Weekly Planner
10(1)
Create A Conventional Mortgage Worksheet
10(1)
Create A Monthly Home Budget
11(1)
Create A Video/DVD Collection Database
11
Section 2 Word Processing
Word Processing Basics
1(1)
Word Processing Menus and Toolbars
2(2)
Formatting Toolbar
2(1)
Standard Toolbar
2(2)
Task Pane
4(1)
How To Select Text In a Word Processing Document
4(1)
Changing The Font, Font Size And Margins
4(2)
Using The Bold, Italic And Underline Formatting Options
6(1)
The Undo Command
6(1)
Bullets
7(1)
How To Create A Bulleted List
7(1)
How To Change The Bullet Style
7(1)
The Format Gallery
8(2)
How To Create Your Own Format
8(1)
How To Add Your Format To The Gallery
9(1)
Shrinking The Format Gallery Dialog Box
9(1)
Apply Your Custom Format To Text
10(1)
The Replace Command
10(1)
The Find And Go To Commands
11(1)
The Spell Checker
12(4)
Spell Check Button Options
13(2)
Auto Recover Option
15(1)
Spelling Options
15(1)
Grammar Options
15(1)
Printing Options
16(1)
Print Preview
16(1)
What Is The Difference Between The Print Button And The Print Command?
17(1)
Inserting Page Breaks
17(1)
How To Count Words In A Document
18(1)
Symbols And Special Characters
18(1)
The Dictionary
19(1)
Setting Up Parental Controls
20(1)
The Thesaurus
20(1)
Images
21
Headers, Footers and Other Features
1(1)
Header And Footer Toolbar
2(1)
How To Add Page Numbers To A Document
2(1)
How To Add The Document Name To The Footer
2(1)
How To Add The Date And Time To The Footer
3(1)
Footnotes
4(2)
Footnote Styles
4(1)
How To Create Numbered Footnotes
4(1)
How To Create A Custom Mark Footnote
5(1)
Linking vs Embedding
6(2)
How To Link A Spreadsheet To A Word Processing Document
6(2)
Paste Special Dialog Box Options
8(1)
How To Embed A Spreadsheet In A Word Processing Document
8(1)
How To Create A Link That Uses An Icon
9(1)
How To Add An Icon To A Document Using The Insert Object Option
10(1)
How To Link A Chart To A Word Processing Document
11(1)
How To Resize A Chart
12(1)
How To Move (Drop & Drag) Text
13(1)
How To Set Paragraph Alignment
14(1)
Indent Paragraph Option
14(1)
Paragraph Spacing
15(1)
Line Spacing
15(1)
Before And After Line Spacing Options
16(1)
The Zoom Option
16
Table of Contents, Templates & Hyperlinks
1(1)
How To Create A Table Of Contents
2(2)
Set The Page Number And Footer Options
2(1)
Tab Stops
3(1)
Templates
4(1)
Create A Fax Cover Page Template
4(1)
How To Add A Border Around Text
4(3)
How To Add Shading To Text
5(1)
Save The Document As A Template
6(1)
Using The Template That You Created
6(1)
Turning A Word Processing Document Into A Web Page
7(1)
Adding Hyperlinks To A Word Processing Document
7
Create A Link To A Web Site
7(1)
Create An Email Address Link
8(2)
Create A Link To A File On Your Hard Drive
10(1)
How To Edit A Hyperlink
11
Mail Merge, Labels And Envelopes
1(1)
Mail Merge Basics
2(1)
Create A Mail Merge Letter Using A Database
2(3)
How To Modify The Fields
3(1)
How To Change The Font And Size Of The Fields
3(1)
How To Personalize The Greeting Line
3(2)
Custom Paper Settings
5(1)
Creating A Mail Merge Document With A Filter
5(3)
Create A Personalized Mail Merge Letter
8(3)
Create The Order Amount Filter
8(1)
Personalize The Letter
9(1)
Mail Merge Printing Options
10(1)
How To Insert A Date Field
10(1)
How To Send The Merge Results To A New File
11(1)
Creating Labels
11(4)
Creating Labels With Filters
11(1)
Add Text To A Label
12(1)
Creating A Filter For The Labels
12(1)
Add Clip Art To A Label
13(1)
Select The Print Options
14(1)
How To Create Multiple Copies Of One Label
15(1)
How To Create Envelopes
16(2)
Creating A Filter For Envelopes
17(1)
Sorting Records
18
Advanced Word Processing Techniques
1(1)
How To Create A Table
2(1)
How To Insert A Spreadsheet Into A Word Processing Document
3(1)
Creating Multi-column Documents
4(2)
How To Create Columns In An Existing Document
5(1)
How To Add Clip Art To A Multi-Column Document
5(1)
Wrap Text Around Clip Art
6(1)
Style Options
6(1)
Text Placement Options
6(1)
How To Add A Title To A Multi-Column Document
7(1)
Adding Borders And Shading To Text
8(2)
Adding Borders To Clip Art
10(1)
Adding A Page Border To A Document
11(1)
Creating A Watermark
11(1)
The Auto Correct Option
12
Section 3 Spreadsheets
Spreadsheet Basics
1(1)
Parts Of A Spreadsheet
2(1)
Spreadsheet Toolbar And Menu
2(1)
Change The Size Of The Toolbar
3(1)
Gridlines
4(1)
Zoom Options
4(1)
Select Cells, Rows And Columns
5(1)
Select A Range Of Cells
5(1)
Select Cells Using The Keyboard
5(1)
Create Your First Spreadsheet
6(2)
Change The Column Width
6(1)
Change The Row Height
7(1)
Insert Rows
7(1)
Insert Columns
7(1)
Delete A Column
8(1)
Number Formats
8(2)
Center Text Across Cells
10(1)
Adding Borders And Shading
10(1)
How To Wrap Text In A Cell
11(1)
The Replace Command
11(1)
How To Edit Text Or Data In A Cell
12(1)
Auto Format
12(2)
Copying Cells
14(1)
How To Move Cells
15(1)
Range Names
15(1)
The Go To Command
16(1)
How To Convert Spreadsheet Data To Database Format
17
Formulas And Functions
1(1)
What Are Formulas And Functions?
2(1)
Creating Formulas Manually
2(1)
How To Copy Formulas Using The Fill Right Command
2(1)
Easy Calc Wizard
3(1)
The Auto Sum Option
4(1)
Calculating Averages
5(1)
How To Create A Formula Using A Range Name
6(1)
Viewing Range Names On The Spreadsheet
6(1)
How To View All Formulas On A Spreadsheet
7(1)
Functions
8
Count Function
8(1)
AVG Function
9(1)
MIN Function
9(1)
MAX Function
9(1)
STD Function
10
Spreadsheet Formatting Techniques
1(1)
Auto Fill
2(1)
Fill Series
3(1)
Freezing Columns And Rows
4(3)
How To Remove Frozen Rows Or Columns
6(1)
Hiding Rows And Columns
7(1)
How To Restore Hidden Columns
8(1)
How To Restore Hidden Rows
8(1)
Sorting Data In A Spreadsheet
8(4)
How To Sort On Two Columns
10(1)
How To Sort On Three Columns
11(1)
The Spell Checker
12(1)
Auto-Recover Option
12(1)
Headers And Footers
13(3)
View Header And Footer Information
14(2)
Adding Page Breaks
16(1)
How To Delete A Page Break
17(1)
How To Save A Spreadsheet As A Template
17(1)
Spreadsheet Printing Options
18
Viewing Charts
18(1)
Creating A Print Area
19(1)
How To Remove A Print Area
19
Chart Basics
1(1)
Chart Types
2(2)
Parts Of A Chart
4(1)
Chart Menu And Toolbar
5(1)
Selecting Data To Chart
6(1)
Create A Bar Chart
7(1)
How To Add A Border And Gidlines To The Chart
7(1)
HowTo To Add Another Series Of Data To The Chart
8(1)
How To Add Titles To The Chart
8(1)
Add Legend Labels To The Chart
9(1)
Modify The Fonts On The Chart
10(1)
How To Rename A Chart
11(1)
How To Create A Chart Based On An Existing Chart
12(2)
How To Duplicate A Chart
12(1)
How To Remove Data From A Chart
12(1)
Change The Charts Subtitle
12(1)
Add Data Labels To The Chart
13(1)
Change The Fill Pattern And Colors On The Chart
13(1)
Shading And Color Dialog Box Options Explained
14
Advanced Chart Techniques
1(1)
Create A Pie Chart
2(1)
Advanced Chart Options
2(1)
How To Use Cell Contents As Labels
2(1)
How To Add Data Labels
3(1)
How To Explode A Slice Of The Pie
3(1)
How To Turn The Chart Into A 3-D Chart
4(1)
Create An Area Chart
5(1)
Add Category Labels Across The Bottom Of The Chart
5(1)
How To Create Abbreviated Month Names For A Chart
6(1)
How To Change The Label Frequency
7(1)
How To Add Gridlines To A Chart
8(1)
Create A Line Chart
9(1)
Create A 3-D Line Chart
10(1)
Create A 3-D Bar Chart
11(1)
Create A Combination Chart
11(3)
Change A Line Series To A Bar Series
12(1)
Add Markers To A Chart
12(1)
Add Vertical Gridlines
13(1)
Add Header And Footer Information To A Chart
14(1)
Printing Charts
14
Section 4 Databases
Database Basics
1(1)
What Is A Database?
2(1)
Database Toolbar And Menu
2(1)
Database And Spreadsheet Similarities
2(1)
Database Options
3(1)
Create A Database From Scratch
4(4)
Field Formats Explained
5(1)
How To Create A Default Value For A Field
6(1)
How To Modify A Field Name
7(1)
Changing Field Format Defaults
7(1)
How To Copy Records From One Database To Another
8(1)
How To Enter Records In A Database
9(1)
How To Delete Fields
9(1)
How To Turn Off Field Protection
10(1)
How To Delete Protected Fields
10(1)
How To Rename Fields
11(1)
How To Add Fields
11(1)
How To Modify The Data Entry Form
12(2)
Form Design View
12(1)
How To Insert A Label
13(1)
How To Change The Form Title
14(1)
How To Add Clip Art To A Form
14(1)
How To Modify The Tab Order
15(1)
How To Change The Shading Of A Field
16(1)
The Go To Dialog Box
17
Database Sorting, Filters & Formulas
1(1)
Sorting
2(1)
Sort The Database On One Field
2(1)
Sort The Database On Multiple Fields
2(1)
Filters
3(1)
Create An Easy Filter
3(3)
Formulas
6(1)
Headers And Footers
7(1)
Protecting Fields
8(1)
How To Use Spreadsheet Data In A Database
8(1)
How To Convert Data To Spreadsheet Format
9(1)
Marking Records
9
How To Only Show Marked Records
10(1)
How To Show Unmarked Records
10(1)
How To Print Marked Records
10(1)
How To Unmark All Records
11
Database Report Basics
1(1)
Create A Customers By State Report
2(2)
Add The Title And Select The Page Orientation
2(1)
Select The Fields For The Report
2(1)
Display Options
3(1)
Select The Fields To Sort On
3(1)
Grouping Options
4(1)
Default Filter Options
5(1)
Create A New Filter
5(1)
Select The Summary Information
6(1)
Display Summary Information Options
6(1)
Report Definition Window
7(1)
Modify The Customers In State Order Report
7(3)
Change The Report Margin Settings
9(1)
Modify The Summary Section Of The Report
9(1)
Create The Sales In Nevada Report
10(2)
How To Duplicate A Report
12(1)
How To Center The Title Across The Row
13(1)
Modify The Field Alignment
13(1)
Modify The Report Settings
13
Advanced Report Techniques
1(1)
Create The Products On Order Report
2(1)
Add The Summary Information For The Product Name Field
2(1)
Modify The Products On Order Report
3(2)
How To Add A Border To The Record Row
3(1)
Modify The Summary Section
4(1)
Add Header And Footer Information
4(1)
Create The Orders By Data Report
5(2)
Create The Sales Rep Report
7(2)
Add And Remove Lines On A Report
9
Section 5 Organization
The Calendar
1(1)
Calendar Overview
2(1)
Calendar Views
2(1)
Calendar Toolbar And Menu
3(1)
How To Change The Size Of The Toolbar
4(1)
Calendar Options
4(2)
Rename Your Calendar
5(1)
Change The Color Of The Appointments
5(1)
Appointments Overview
6(1)
Create Your First Appointment
7(1)
View Reminders Dialog Box
8(2)
Create An All Day Event
10(1)
Create A Weekly Recurring Appointment
10(2)
Create A Yearly Recurring Appointment
12(1)
Modifying Recurring Appointments Overview
12(3)
Modify One Occurrence Of A Recurring Appointment
13(1)
Modify A Series Of Recurring Appointments
14(1)
View Appointments On The Home Page
15(1)
View Appointments By Day
15(1)
View Appointments By Week
16(1)
How To Create Another Calendar
16(1)
How To Share And View Shared Appointments
17(1)
View Together Calendar Option
17(1)
Categories
18(2)
Adding Categories
18(1)
Renaming Categories
19(1)
Deleting Categories
19(1)
Viewing Appointments
20(1)
Using The Find Option
20(2)
Find Appointments By Keyword
20(1)
Find Appointments By Time
21(1)
Find Appointments By Category
21(1)
Keyword Search Field
22(1)
Printing Calendars
22(1)
Contacts
23
The Project Organizer
1
Using A Project Organizer Template
2
Overview Of The Project Window
3
Modify Existing Entries In The Project
3
Modify The Project Name
3
Modify The Project Due Date
4
Modify An Existing Task
4
Add Or Edit Information In The Notes Field
5
Add Or Edit The Task Due Date
5
View Project Tasks In The Calendar
6
Remove A Document Associated To A Task
7
Delete A Calendar Reminder For A Task
7
Delete A Project Task From The Calendar
8
How To Create A To Do Item
8
How To Create A Project
9
The Saved Projects Tab
9
How To Delete A Project
10
Printing A Project
10