Simply Office 2010 - Kate Shoup - E-Book

Simply Office 2010 E-Book

Kate Shoup

0,0
9,99 €

-100%
Sammeln Sie Punkte in unserem Gutscheinprogramm und kaufen Sie E-Books und Hörbücher mit bis zu 100% Rabatt.

Mehr erfahren.
Beschreibung

Wanting to make the most of Microsoft Office 2010? But not sure exactly what is has to offer?

Then look no further as this clear, concise guide is the ideal companion for fast and efficient learning. Simply Office 2010 runs you through the main features of the Office applications with simple, step-by-step instructions that show you how to tackle dozens of Microsoft Office tasks, whilst offering practical examples and advice.

The simple, yet elegant design features a multitude of images as well as tips & tricks to make this a perfect reference for all ages and abilities. If you are new to Microsoft Office you will find the gentle approach to the software provides a non-intimidating and easy to follow resource that helps you to get to grips with the application quickly - just follow all instructions on screen at your own speed.

Each application in the Office suite is covered, including:

  • Word
  • Excel
  • Outlook
  • Publisher
  • PowerPoint
  • Using Office Internet and graphics tools

Packed with advice and screen shots, this full-colour visual tutorial is excellent value for money. Learn something new today – read it, try it and become your own expert with Simply Office 2010!

Sie lesen das E-Book in den Legimi-Apps auf:

Android
iOS
von Legimi
zertifizierten E-Readern

Seitenzahl: 182

Veröffentlichungsjahr: 2011

Bewertungen
0,0
0
0
0
0
0
Mehr Informationen
Mehr Informationen
Legimi prüft nicht, ob Rezensionen von Nutzern stammen, die den betreffenden Titel tatsächlich gekauft oder gelesen/gehört haben. Wir entfernen aber gefälschte Rezensionen.



Simply Office 2010

Table of Contents

Chapter 1: Office Basics
Start and Exit Office Applications
Start an Office Application
Exit an Office Application
Create a Shortcut Icon for an Office Application
Navigate the Program Windows
Work with the Ribbon
Use the Ribbon
Minimise the Ribbon
Keep the Ribbon Minimised
Customise the Quick Access Toolbar
Get Help with Office
Chapter 2: Working with Files
Create a New File
Create a New Word, Excel, PowerPoint, Access or Publisher File
Create a New Outlook Item
Save a File
Open a File
Print a File
Select Data
Click and Drag to Select Data
Select Text with a Mouse
Select Text from the Margin
Cut, Copy and Paste Data
Drag and Drop Data
Cut and Copy Data
Chapter 3: Office Graphics Tools
Insert a Picture or Clip Art
Search for Clip Art
Resize and Move Objects
Resize an Object
Move an Object
Wrap Text Around an Object
Rotate and Flip Objects
Rotate an Object
Flip an Object
Crop a Picture
Crop Objects into Predefined Shapes
Change a Picture
Make Image Corrections
Make Colour Adjustments
Apply Artistic Effects
Apply a Picture Effect
Chapter 4: Adding Text
Change Word’s Views
Use the Zoom Tool
Switch Layout Views
Type and Edit Text
Type Text
Edit Text
Add a Quick Parts Entry
Insert a Quick Part Entry
Insert Symbols and Special Characters
Insert a Symbol
Insert a Special Character
Chapter 5: Formatting Text
Change the Font, Size and Colour
Change the Font
Change the Size
Change the Colour
Use the Font Dialog Box
Align Text
Set Line Spacing
Indent Text
Set Quick Indents
Set Precise Indents
Set Tabs
Set Quick Tabs
Set Precise Tabs
Set Margins
Set Margins Using Page Layout Tools
Set a Custom Margin
Copy Formatting
Clear Formatting
Format with Styles
Create a New Quick Style
Apply a Quick Style
Apply a Template
Chapter 6: Adding Extra Touches
Create Columns
Create Quick Columns
Create Custom Columns
Insert a Table
Insert a Table
Insert a Quick Table
Apply Table Styles
Insert an Excel Spreadsheet
Use Headers, Footers and Footnotes
Add a Header or Footer
Insert a Footnote
Insert Page Numbers and Page Breaks
Insert Page Numbers
Insert Page Breaks
Create an Index
Mark a Word or Phrase
Generate an Index
Create a Table of Contents
Style Text as Headers
Generate a Table of Contents
Create a TOC from Custom Styles
Chapter 7: Reviewing Documents
Find and Replace Text
Find Text
Replace Text
Check Spelling and Grammar
Correct a Mistake
Run the Spell-Checker
Turn Off Automatic Spelling and Grammar
Work with AutoCorrect
Track and Review Document Changes
Turn On Tracking
Review Changes
Chapter 8: Building Spreadsheets
Enter Cell Data
Type into a Cell
Type in the Formula Bar
Select Cells
Select a Range of Cells
Select a Column or Row
Faster Data Entry with AutoFill
AutoFill a Text Series
AutoFill a Number Series
Create a Custom List
Change the Font and Size
Change the Font
Change the Font Size
Change Number Formats
Apply Conditional Formatting
Apply a Conditional Rule
Apply a Colour Scale
Add Columns and Rows
Add a Column
Add a Row
Freeze a Column or Row
Name a Range
Delete Data or Cells
Delete Data
Delete Cells
Chapter 9: Worksheet Basics
Add a Worksheet
Name a Worksheet
Change Page Setup Options
Change the Page Orientation
Insert a Page Break
Move and Copy Worksheets
Delete a Worksheet
Find and Replace Data
Find Data
Replace Data
Sort Data
Perform a Quick Sort
Perform a Custom Sort
Filter Data
Customise a Filter
Chapter 10: Working with Formulas and Functions
Create a Formula
Apply Absolute and Relative Cell References
Assign an Absolute Reference
Assign a Relative Reference
Understanding Functions
Apply a Function
Total Cells with AutoSum
Audit a Worksheet for Errors
Create a Chart
Chapter 11: Creating a Presentation
Create a Photo Album Presentation
Create a Presentation with a Template
Build a Blank Presentation
Change PowerPoint Views
Use Outline View
Use Slides View
Use Slide Sorter View
Use Normal View
Insert Slides
Change the Slide Layout
Chapter 12: Populating Presentation Slides
Add and Edit Slide Text
Add Slide Text
Edit Slide Text
Add Text using the Outline Tab
Change the Font, Size and Colour
Change the Font
Change the Size
Choose a Coordinating Colour
Open the Colors Dialog Box
Set a Custom Colour
Set Line Spacing
Add a Text Box to a Slide
Add Other Objects to a Slide
Add a Picture
Add a Video Clip
Add a Table
Add a Chart
Move a Slide Object
Resize a Slide Object
Chapter 13: Assembling and Presenting a Slide Show
Reorganise Slides
Move Slides in Normal View
Move Slides in Slide Sorter View
Record Narration
Set Up a Slide Show
Run a Slide Show
Draw on Slides While Presenting the Show
Chapter 14: Database Basics
Create a Database Based on a Template
Create a Blank Database
Create a New Table
Change Table Views
Switch to Design View
Switch to Datasheet View
Add or Move a Field in a Table
Add a Field
Move a Field
Delete or Hide a Field in a Table
Delete a Field
Hide a Field
Create a Form
Change Form Views
Switch to Design View
Switch to Layout View
Move or Delete a Field in a Form
Move a Field
Delete a Field
Chapter 15: Adding, Finding and Querying Data
Add a Record to a Table
Add a Record to a Form
Navigate Records in a Form
Search for a Record in a Form
Sort Records
Sort a Table
Sort Using a Form
Filter Records
Apply a Simple Filter
Filter by Form
Use Conditional Formatting
Remove Conditional Formatting
Perform a Simple Query
Create a Query
Add Criteria to the Query
Create a Report
Create a Simple Report
Create a Custom Report
Chapter 16: Organising with Outlook
View Outlook Components
Schedule an Appointment
Schedule an Event
Create a New Contact
Create a New Task
Add a Note
Chapter 17: E-mailing with Outlook
Compose and Send a Message
Send a File Attachment
Read an Incoming Message
Reply To or Forward a Message
Reply To a Message
Forward a Message
Add a Sender to Your Outlook Contacts
Delete a Message
View Conversations
Clean Up a Conversation
Ignore a Conversation
Screen Junk E-mail
Create a Message Rule
View Junk E-mail Options
Designate a Message as Junk

Simply Office 2010

by Kate Shoup

First published under the title Office 2010 Simplified, ISBN 978-0-470-57194-1 by Wiley Publishing, Inc. 10475 Crosspoint Boulevard, Indianapolis, IN 46256

Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana

This edition first published 2010.

Copyright © 2010 for the EMEA adaptation: John Wiley & Sons, Ltd.

Registered office

John Wiley & Sons Ltd, The Atrium, Southern Gate, Chichester, West Sussex, PO19 8SQ, United Kingdom

For details of our global editorial offices, for customer services and for information about how to apply for permission to reuse the copyright material in this book please see our website at www.wiley.com.

The right of the author to be identified as the author of this work has been asserted in accordance with the Copyright, Designs and Patents Act 1988.

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, except as permitted by the UK Copyright, Designs and Patents Act 1988, without the prior permission of the publisher.

Microsoft product screenshots reprinted with permission from Microsoft Corporation.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.

Designations used by companies to distinguish their products are often claimed as trademarks. All brand names and product names used in this book are trade names, service marks, trademarks or registered trademarks of their respective owners. The publisher is not associated with any product or vendor mentioned in this book. This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. It is sold on the understanding that the publisher is not engaged in rendering professional services. If professional advice or other expert assistance is required, the services of a competent professional should be sought.

All prices correct at time of going to press. Please check appropriate website for current details.

All website information was correct at the time of going to press. Websites do constantly update their privacy settings and policies. Please check the relevant website homepage to find their current policies.

ISBN: 978-0-470-71129-3

A catalogue record for this book is available from the British Library.

Printed in Italy by Printer Trento

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

Marketing:

Senior Marketing Manager: Louise Breinholt

Marketing Executive: Chloe Tunnicliffe

Composition Services:

Layout: Andrea Hornberger

Indexer: Potomac Indexing, LLC

Series Designer: Patrick Cunningham

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:

Click

Press your left mouse button once. You generally click your mouse on something to select something on the screen.

Double-click

Press your left mouse button twice. Double-clicking something on the computer screen generally opens whatever item you have double-clicked.

Right-click

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

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.

Italics

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. Youdo 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

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.

Please note that some special symbols used in this eBook may not display properly on all eReader devices. If you have trouble determining any symbol, please call Wiley Product Technical Support at 800-762-2974. Outside of the United States, please call 317-572-3993. You can also contact Wiley Product Technical Support at www.wiley.com/techsupport.

Part I: Office Features

In Office 2010, the applications share a common look and feel. You can find many of the same features in each program, such as the Ribbon, the Quick Access toolbar, various program window controls and the File tab. Many of the tasks you perform in Office, such as creating new files, opening existing files, working with text and data in files, saving files, printing files and executing commands, involve similar processes and features throughout the Office suite. In this part, you learn how to navigate the common Office features and perform basic Office tasks.

Chapter 1Office Basics

Chapter 2Working with Files

Chapter 3Office Graphics Tools

Chapter 1: Office Basics

Start and Exit Office Applications

Before you can begin working with a Microsoft Office application, also called a program, you must open the application.

There are a few ways to start an application. One is to launch it from the Start menu, as described in this task. Another is to double-click the program’s shortcut icon on the desktop.

When you finish your work, you can close the program. If applicable, you can save your work before exiting a program completely.

Start an Office Application

1 Click Start.

2 Click AllPrograms.

Note: The All Programs menu option changes to a Back menu option.

3 Click Microsoft Office.

4 Click the name of the program that you want to open.

A The program that you selected opens in a new window.

Note: See the next section to learn how to identify different areas of the program window.

Exit an Office Application

1 Click the Close button ().

A You can also click the File tab and then click Exit.

If you have not yet saved your work, the program prompts you to do so before exiting.

2 Click Save.

The program window closes.

B If you click Don’t Save, the program closes without saving your data.

C If you click Cancel, the program window remains open.

Create a Shortcut Icon for an Office Application

1 Right-click a blank area of the desktop and click New and then Shortcut.

The Create Shortcut dialog box appears.

2 Click Browse, navigate to the Office program, click the filename and click OK.

3 Click Next.

4 Type a name for the shortcut.

5 Click Finish.

The new shortcut icon appears on the desktop.

Navigate the Program Windows

All Office programs share a common appearance and many of the same features. These features include a Ribbon, which appears instead of the menus and toolbars found in previous versions of Microsoft Office; a Quick Launch toolbar, which features a customisable set of frequently used commands; and scroll bars, which you can use to navigate an open file in a program window. When you learn how to navigate one Office program, you can use the same skills to navigate the others. If you are new to Office, you should take a moment to familiarise yourself with the suite’s various on-screen elements.

A Title Bar

Displays the name of the open file and the Office program.

B Quick Access Toolbar

Displays quick access buttons to the Save, Undo and Redo commands.

C File Tab Menu

Displays a menu of file commands, such as New and Open.

D Ribbon

Displays groups of related commands in tabs. Each tab offers buttons for performing common tasks.

E Status Bar

Displays information about the current worksheet or file.

F Program Window Controls

Displays buttons to minimise the program window, restore the window to full size and close the window.

A Formula Bar

This appears only in Excel. Use this bar to type and edit formulas and perform calculations on your worksheet data.

B Work Area

The area where you add and work with data in a program. Depending on the Office program, the work area may be a document, a worksheet or a slide.

C Document Window Controls

Use these buttons to minimise or restore the current document within the program window.

D Zoom Controls

Use this feature to zoom your view of a document.

E Scroll Bars

Use the vertical and horizontal scroll bars to scroll through the item shown in the work area.

Work with the Ribbon

Instead of the menus and toolbars found in earlier versions of Office, Office 2010 features the Ribbon, which offers an intuitive way to locate and execute commands.

The Ribbon is grouped into tabs, each containing groups of related commands. For example, the Home tab in Microsoft Word contains commands for changing the font, setting text alignment, indenting text and so on. Some tabs appear only when needed, such as when you are working with a table or picture in a document.

The Ribbon is maximised by default, but you can minimise it to view more of your program window.

Use the Ribbon

1 Click a tab.

The tab organises related tasks and commands into logical groups.

2 Click a button to activate a command or feature.

A Buttons with arrows display additional commands.

B With some groups of commands, you can click the corner group button () to display a dialog box of additional settings.

When you position the mouse pointer over Live Preview options on the Ribbon, you see the results in the document before applying the command.

Minimise the Ribbon

1 Double-click a tab name.

The Ribbon is minimised.

2 Double-click the tab name again to maximise the Ribbon.

Keep the Ribbon Minimised

1 Right-click a tab on the Ribbon.

2 Click Minimize the Ribbon.

The program’s Ribbon is minimised at the top of the screen.

To use a Ribbon while it is minimised, simply click the tab containing the tools that you want to access.

Customise the Quick Access Toolbar

The Quick Access toolbar, which appears on-screen regardless of what tab is currently shown in the Ribbon, offers quick access to the Save, Undo and Redo commands.

You can customise this toolbar to include other commands, such as the Quick Print command or another command you use often. Alternatively, you might customise the toolbar to omit commands that appear by default.

By default, the Quick Access toolbar appears in the top left corner of the program window, above the Ribbon. You can choose to display the toolbar below the Ribbon instead.

1 Click the Customize Quick Access Toolbar button ().

2 Click More Commands.

A You can click any of the common commands to add them to the toolbar.

B You can click Show Below the Ribbon if you want to display the toolbar below the Ribbon.

The Options dialog box opens with the options to customise the Quick Access Toolbarshown.

3 Click the Choose commands from.

4 Click a command group.

5 Click the command that you want to add to the toolbar.

6 Click the Add button.

C Office adds the command.

You can repeat Steps 3 to 6 to move additional buttons to the toolbar.

7 Click OK.

D The new command appears on the Quick Access toolbar.

To remove a button from the Quick Access toolbar, open the Options dialog box, click the command name in the list box on the right, click the Remove button and click OK. The button no longer appears on the toolbar.

You can add commands to the toolbar directly from the Ribbon. Simply click the tab containing the command that you want to add, right-click the command and then click Add to Quick Access Toolbar. The command is immediately added as a button on the toolbar.

Get Help with Office

You can use Office Help to assist you when you run into a problem or need more information about how to complete a particular task.

The Help window offers tools that enable you to search for topics that you want to learn more about. For example, if you want to learn how to print an Office document, you can type Print in the Help window to locate articles on that topic. Alternatively, you can browse for articles by category. If you are connected to the Internet, you can access Microsoft’s online help files for even more comprehensive information.

1 Click the Help button ().

The Help window opens.

2 Type a word or phrase that you want to learn more about.

3 Click the Search button.

You can also press to start the search.

Note: You must be connected to the Internet to access Microsoft’s online help files.

The results window displays a list of possible matches.

4 Click a link to learn more about a topic.

The Help window displays the article, enabling you to read more about the topic.

A You can use the Back and Forward buttons ( and ) to move back and forth between help topics.

B You can click the Print button () to print the information.

5 Click to close the window.

You can access the help files that are installed with Office if you are offline. However, the online resources offer you more help topics, as well as links to demos and other help tools.

To display a table of contents for the help files for the Office program that you are using, click the Home button (