Simply Office 2010. Wiley

by Kate Shoup

Publisher’s Acknowledgements

Editorial and Production

VP Consumer and Technology Publishing
Director: Michelle Leete
Associate Director – Book Content
Management: Martin Tribe
Associate Publisher: Chris Webb
Executive Commissioning Editor: Birgit Gruber
Publishing Assistant: Ellie Scott
Production Manager: Amie Jackowski Tibble
Project Editor: Juliet Booker
Development Editor: Shena Deuchars

Composition Services:

Layout: Andrea Hornberger
Indexer: Potomac Indexing, LLC
Series Designer: Patrick Cunningham


Senior Marketing Manager: Louise Breinholt
Marketing Executive: Chloe Tunnicliffe

e-books shop
Simply Office 2010

About the Author
Freelance writer/editor Kate Shoup has authored 20 books and edited scores more. Recent titles include Windows 7 Digital Classroom, Teach Yourself VISUALLY Outlook 2007, Office 2007: Top 100 Simplified Tips & Tricks and Internet Visual Quick Tips. When not working, Kate loves to ski (she was once nationally ranked), read and ride her motorcycle – and she plays a mean game of nine-ball. Kate lives in Indianapolis with her daughter and their dog.

How to Use This Book
Do you look at the pictures in a book or magazine before
anything else? Would you rather be shown instead of
read about how to do something? Then this book is for
you. Opening Simply Office 2010 allows you to read less
and learn more about the Windows operating system.

Who Needs This Book
This book is for a reader who has never used this
particular technology or application. It is also for more
computer literate individuals who want to expand their
knowledge of the different features that Windows has to offer.
Using the Mouse
This book uses the following conventions to describe the
actions you perform when using the mouse:
Press your left mouse button once. You generally click
your mouse on something to select something on the screen.
Press your left mouse button twice. Double-clicking
something on the computer screen generally opens
whatever item you have double-clicked.
Press your right mouse button. When you right-click
anything on the computer screen, the program displays
a shortcut menu containing commands specific to the selected item.
Click and Drag, and Release the Mouse
Move your mouse pointer and hover it over an item on
the screen. Press and hold down the left mouse button.
Now, move the mouse to where you want to place the
item and then release the button. You use this method to
move an item from one area of the computer screen to another.

The Conventions in This Book
A number of typographic and layout styles have been
used throughout Simply Office 2010 to distinguish
different types of information.
Bold type represents the names of commands and
options that you interact with. Bold type also indicates
text and numbers that you must type into a dialog box or window.
Italic words introduce a new term and are followed by a definition.
Numbered Steps
You must perform the instructions in numbered steps in
order to successfully complete a section and achieve the final results.
Bulleted Steps
These steps point out various optional features. You
do not have to perform these steps; they simply give
additional information about a feature. Steps without
bullets tell you what the program does in response to
your following a numbered step. For example, if you click
a menu command, a dialog box may appear or a window
may open. The step text may also tell you what the final
result is when you follow a set of numbered steps.
Notes give additional information. They may describe
special conditions that may occur during an operation.
They may warn you of a situation that you want to
avoid – for example, the loss of data. A note may also
cross reference a related area of the book. A cross
reference may guide you to another chapter or another
section within the current chapter.
Icons and buttons
Icons and buttons are graphical representations within the
text. They show you exactly what you need to click to perform a step.

You can easily identify the tips or warnings in any section
by looking for the Tip and Warning icons. Tips offer
additional information, including tips, hints, and tricks. You
can use the tip information to go beyond what you have
learned in the steps. Warnings tell you about solutions to
common problems and general pitfalls to avoid.

Table of Contents

Chapter 1: Office Basics
4 Start and Exit Office Applications
6 Navigate the Program Windows
8 Work with the Ribbon
10 Customise the Quick Access Toolbar
12 Get Help with Office
Chapter 2: Working with Files
14 Create a New File
16 Save a File
18 Open a File
20 Print a File
22 Select Data
24 Cut, Copy and Paste Data
Chapter 3: Office Graphics Tools
26 Insert a Picture or Clip Art
28 Resize and Move Objects
30 Rotate and Flip Objects
32 Crop a Picture
34 Change a Picture

Chapter 4: Adding Text
38 Change Word’s Views
40 Type and Edit Text
42 Insert Symbols and Special Characters
Chapter 5: Formatting Text
44 Change the Font, Size and Colour
46 Align Text
47 Set Line Spacing
48 Indent Text
50 Set Tabs
52 Set Margins
54 Copy Formatting
55 Clear Formatting
56 Format with Styles
58 Apply a Template
Chapter 6: Adding Extra Touches
60 Create Columns
62 Insert a Table
64 Use Headers, Footers and Footnotes
66 Insert Page Numbers and Page Breaks
68 Create an Index
70 Create a Table of Contents
Chapter 7: Reviewing Documents
72 Find and Replace Text
74 Check Spelling and Grammar
76 Work with AutoCorrect
78 Track and Review Document Changes

Chapter 8: Building Spreadsheets
82 Enter Cell Data
84 Select Cells
86 Faster Data Entry with AutoFill
88 Change the Font and Size
89 Change Number Formats
90 Apply Conditional Formatting
92 Add Columns and Rows
94 Freeze a Column or Row
95 Name a Range
96 Delete Data or Cells
Chapter 9: Worksheet Basics
98 Add a Worksheet
99 Name a Worksheet
100 Change Page Setup Options
102 Move and Copy Worksheets
103 Delete a Worksheet
104 Find and Replace Data
106 Sort Data
108 Filter Data
Chapter 10: Working with Formulas and Functions
110 Create a Formula
112 Apply Absolute and Relative Cell References
114 Understanding Functions
116 Apply a Function
118 Total Cells with AutoSum
119 Audit a Worksheet for Errors
120 Create a Chart

Chapter 11: Creating a Presentation
124 Create a Photo Album Presentation
126 Create a Presentation with a Template
127 Build a Blank Presentation
128 Change PowerPoint Views
130 Insert Slides
131 Change the Slide Layout
Chapter 12: Populating Presentation Slides
132 Add and Edit Slide Text
134 Change the Font, Size and Colour
138 Set Line Spacing
139 Add a Text Box to a Slide
140 Add Other Objects to a Slide
142 Move a Slide Object
143 Resize a Slide Object
Chapter 13: Assembling and Presenting a Slide Show
144 Reorganise Slides
146 Record Narration
147 Set Up a Slide Show
148 Run a Slide Show

Chapter 14: Database Basics
152 Create a Database Based on a Template
154 Create a Blank Database
156 Create a New Table
158 Change Table Views
160 Add or Move a Field in a Table
161 Delete or Hide a Field in a Table
162 Create a Form
164 Change Form Views
165 Move or Delete a Field in a Form
Chapter 15: Adding, Finding and Querying Data
166 Add a Record to a Table
168 Add a Record to a Form
170 Navigate Records in a Form
171 Search for a Record in a Form
172 Sort Records
174 Filter Records
176 Use Conditional Formatting
178 Perform a Simple Query
180 Create a Report

Chapter 16: Organising with Outlook
186 View Outlook Components
188 Schedule an Appointment
190 Schedule an Event
192 Create a New Contact
194 Create a New Task
Chapter 17: E-mailing with Outlook
196 Compose and Send a Message
198 Send a File Attachment
199 Read an Incoming Message
200 Reply To or Forward a Message
202 Add a Sender to Your Outlook Contacts
203 Delete a Message
204 View Conversations
206 Screen Junk E-mail



e-books shop

Purchase Now !
Just with Paypal

Product details
 2.00 USD
 226 p
 File Size
 14,778 KB
 File Type
 PDF format
 2010 by Wiley Publishing, Inc 

═════ ═════

Loading... Protection Status