Windows 8 & Office 2010 For Dummies eBook Set E-Book

Andy Rathbone

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch
• Veröffentlichungsjahr: 2012

Seitenzahl: 974

Beschreibung

Two complete e-books covering Windows and Office for one low price! This unique value-priced e-book set brings together two bestselling For Dummies books in a single e-book file. Including a comprehensive table of contents and the full text of each book, complete with cover, this e-book set gives you in-depth information on the leading PC productivity tools: Windows 8 and Office 2010. Best of all, you'll pay less than the cost of each book purchased separately. You'll get the complete text of: Windows 8 For Dummies, which covers * The core components of Windows 8, the new Start screen, and how to work with programs and files * Getting online with Internet Explorer, using e-mail and accessing social networks * Playing CDs, music, and movies; working with photos, and customizing Windows * Using Windows 8 on a touchscreen tablet Office 2010 For Dummies, which shows you how to * Use Word, Excel, PowerPoint, Outlook, and Access * Find recently used files and save, open, and close them with Backstage View * Format Word documents and analyze data with Excel * Create PowerPoint presentations with charts, graphics, movies, and sound About the authors Andy Rathbone, author of Windows 8 For Dummies, is an expert on PC operation and repair as well as tablet computing, and is the bestselling author of all editions of Windows For Dummies. Wallace Wang, author of Office 2010 For Dummies, is the bestselling author of several dozen computer books, including Beginning Programming For Dummies.

Leseprobe

Windows® 8 and Office 2010 For Dummies®, 2-eBook Bundle

Windows® 8 For Dummies®

Visit www.dummies.com/cheatsheet/windows8 to view this book's cheat sheet.

Table of Contents

Introduction

About This Book

How to Use This Book

Tablet Owners Aren’t Left Out

And What about You?

How This Book Is Organized

Part I: Windows 8 Stuff Everybody Thinks You Already Know

Part II: Working with Programs, Apps, and Files

Part III: Getting Things Done on the Internet

Part IV: Customizing and Upgrading Windows 8

Part V: Music, Photos, and Movies

Part VI: Help!

Part VII: The Part of Tens

Icons Used in This Book

Where to Go from Here

Part I: Windows 8 Stuff Everybody Thinks You Already Know

Chapter 1: What Is Windows 8?

What Is Windows 8, and Why Are You Using It?

What’s New in Windows 8?

Should I Bother Switching to Windows 8?

Can My Current PC Still Run Windows 8?

The Four Flavors of Windows 8

Chapter 2: The Mysterious New Start Screen

Being Welcomed to the World of Windows 8

Understanding user accounts

Keeping your account private with a password

Signing up for a Microsoft account

Figuring Out the New Start Screen in Windows 8

Launching a Start screen program or app

Viewing or closing your open apps

Finding a Start screen app or program

Adding or removing Start screen items

The Charms bar and its hidden shortcuts

Introducing your free apps

Customizing the Start screen

Exiting from Windows

Temporarily leaving your computer

Leaving your computer for the day

Chapter 3: The Traditional Desktop

Finding the Desktop and the Start Screen

Working with the Desktop

Summoning the Start screen and open apps

Jazzing up the desktop’s background

Snapping an app alongside the desktop

Dumpster diving in the Recycle Bin

Bellying Up to the Taskbar

Shrinking windows to the taskbar and retrieving them

Switching to different tasks from the taskbar’s Jump Lists

Clicking the taskbar’s sensitive areas

Customizing the taskbar

Making Programs Easier to Find

Add five helpful icons to your desktop

Creating taskbar shortcuts for your favorite programs

Chapter 4: Basic Desktop Window Mechanics

Dissecting a Typical Desktop Window

Tugging on a window’s title bar

Navigating folders with a window’s Address Bar

Finding commands on the Ribbon

Quick shortcuts with the Navigation Pane

Moving inside a window with its scroll bar

Boring borders

Maneuvering Windows Around the Desktop

Moving a window to the top of the pile

Moving a window from here to there

Making a window fill the whole screen

Closing a window

Making a window bigger or smaller

Placing two windows side by side

Making windows open to the same darn size

Chapter 5: Storage: Internal, External, and in the Sky

Browsing the File Explorer File Cabinets

Getting the Lowdown on Folders and Libraries

Peering into Your Drives, Folders, and Libraries

Seeing the files on a disk drive

Seeing what’s inside a folder

Managing a library’s folders

Creating a New Folder

Renaming a File or Folder

Selecting Bunches of Files or Folders

Getting Rid of a File or Folder

Copying or Moving Files and Folders

Seeing More Information about Files and Folders

Writing to CDs and DVDs

Buying the right kind of blank CDs and DVDs for burning

Copying files to or from a CD or DVD

Working with Flash Drives and Memory Cards

SkyDrive: Your Cubbyhole in the Clouds

Accessing files with the SkyDrive app

Accessing SkyDrive from the desktop

Part II: Working with Programs, Apps, and Files

Chapter 6: Playing with Programs, Apps, and Documents

Starting a Program or App

Opening a Document

Saving a Document

Choosing Which Program Should Open Which File

Navigating the Windows Store

Adding new apps from the Store app

Uninstalling apps

Updating your apps

Taking the Lazy Way with a Desktop Shortcut

Absolutely Essential Guide to Cutting, Copying, and Pasting

The quick ’n’ dirty guide to cut ’n’ paste

Selecting things to cut or copy

Cutting or copying your selected goods

Pasting information to another place

Chapter 7: Finding the Lost

Finding Currently Running Start Screen Apps

Finding Lost Windows on the Desktop

Locating a Missing App, Program, Setting, or File

Finding a Missing File inside a Desktop Folder

Finding Lost Photos

Finding Other Computers on a Network

Finding Information on the Internet

Chapter 8: Printing Your Work

Printing from a Start Screen App

Printing Your Masterpiece from the Desktop

Adjusting how your work fits on the page

Adjusting your printer’s settings

Canceling a print job

Printing a web page

Troubleshooting your printer

Part III: Getting Things Done on the Internet

Chapter 9: Cruising the Web

What’s an ISP, and Why Do I Need One?

Connecting Wirelessly to the Internet

Browsing Quickly from the Start Screen

Navigating the Web with the Desktop’s Internet Explorer

Moving from one web page to another

Making Internet Explorer open to your favorite site

Revisit favorite places

Finding things on the Internet

The Web Page Says It Needs a Weird Plug-In Thing!

Saving Information from the Internet

Saving a web page

Saving text

Saving a picture

Downloading a program, song, or other type of file

It Doesn’t Work!

Removing Unneeded Plug-Ins

Chapter 10: Being Social: Mail, People, Calendar, and Messaging

Adding Your Social Accounts to Windows 8

Understanding the Mail App

Switching among the Mail app’s views, menus, and accounts

Composing and sending an e-mail

Reading a received e-mail

Sending and receiving files through e-mail

Managing Your Contacts in the People App

Adding contacts

Deleting or editing contacts

Managing Appointments in Calendar

Chatting through Messaging

Chapter 11: Safe Computing

Understanding Those Annoying Permission Messages

Assessing Your Safety in the Action Center

Avoiding Viruses with Windows Defender

Staying Safe on the Internet

Avoiding evil add-ons and hijackers

Avoiding phishing scams

Setting Up Family Safety Controls

Part IV: Customizing and Upgrading Windows 8

Chapter 12: Customizing Windows 8 with the Control Panel

Finding the Right Switch

The Start Screen’s PC Settings Screen

The Big Guns: The Desktop’s Control Panel

System and Security

User Accounts and Family Safety

Network and Internet

Changing the Windows 8 Appearance (Appearance and Personalization)

Changing the desktop background

Choosing a screen saver

Changing the computer’s theme

Changing the screen resolution

Hardware and Sound

Adjusting volume and sounds

Installing or setting up speakers

Adding a Bluetooth gadget

Adding an Xbox 360 game console

Adding a printer

Clock, Language, and Region

Adding or Removing Programs

Removing apps and programs

Installing new programs

Modifying Windows 8 for the Physically Challenged

Chapter 13: Keeping Windows from Breaking

Tuning Up Windows 8 with Built-In Maintenance Tools

Backing up your computer with File History

Finding technical information about your computer

Freeing up space on your hard drive

Empowering your power button

Setting up devices that don’t work (fiddling with drivers)

Chapter 14: Sharing One Computer with Several People

Understanding User Accounts

Changing Your User Account or Adding a New Account

Adding another user to your computer

Changing an existing user’s account

Switching Quickly between Users

Sharing Files among Account Holders

Changing a User Account’s Picture

Setting Up Passwords and Security

Chapter 15: Connecting Computers with a Network

Understanding a Network’s Parts

Setting Up a Small Network

Buying parts for a network

Setting up a wireless router

Setting up Windows 8 to connect to a network

Setting Up or Connecting with a Homegroup

Accessing what others have shared

Sharing a printer on the network

Part V: Music, Photos, and Movies

Chapter 16: Playing and Copying Music in Media Player

Playing Music from the Start Screen

Handing Music-Playing Chores Back to Windows Media Player

Stocking the Windows Media Player Library

Browsing Windows Media Player’s Libraries

Playing Music Files (MP3s and WMAs)

Controlling Your Now Playing Items

Playing CDs

Playing DVDs

Playing Videos and TV Shows

Creating, Saving, and Editing Playlists

Ripping (Copying) CDs to Your PC

Burning (Creating) Music CDs

Chapter 17: Fiddling with Photos (and Movies)

Dumping a Camera’s Photos into your Computer

Taking Photos with the Camera App

Viewing Photos from the Start Screen

Viewing Photos from the Desktop

Browsing your photos from the desktop’s Pictures library

Viewing a slide show

Copying digital photos to a CD or DVD

Part VI: Help!

Chapter 18: The Case of the Broken Window

New Magic Fixes in Windows 8

Refreshing your computer

Remove everything from your computer

Restoring backups with File History

Windows 8 Keeps Asking Me for Permission

I Need to Retrieve Deleted Files

My Settings Are Messed Up

I Forgot My Password

My Computer Is Frozen Solid

Chapter 19: Strange Messages: What You Did Does Not Compute

Could Not Enable File History. The System Cannot Find the Path Specified.

Do You Want to Install This Device Software?

Do You Want to Save Changes?

How Do You Want to Open This Type of File?

Insert Media

Malware Detected: Windows Defender Is Taking Action

Removable Disk: Choose What to Do with Removable Drives

Sign In with a Microsoft Account

Something Went Wrong: Couldn’t Share Photo(s) with Mail

There Is No Email Program Associated to Perform the Requested Action

USB Device Not Recognized

Windows Isn’t Activated

You Don’t Currently Have Permission to Access This Folder

Chapter 20: Moving from an Old PC to a New Windows 8 PC

Choosing How to Transfer Your Old Information

Transferring Information Between Two PCs

Picking and Choosing Files, Folders, and Accounts to Transfer

Chapter 21: Help on the Windows 8 Help System

Consulting a Program’s Built-In Computer Guru

Finding the Information You Need in Windows Help and Support

Summoning the Windows Troubleshooters

Part VII: The Part of Tens

Chapter 22: Ten Things You’ll Hate about Windows 8 (and How to Fix Them)

I Want to Avoid the Start Screen!

Bringing back the Start button

Knowing when the Start screen reappears unexpectedly

I Want to Avoid the Desktop!

Windows Makes Me Sign In All the Time

The Taskbar Keeps Disappearing

I Can’t Line Up Two Windows on the Screen

It Won’t Let Me Do Something Unless I’m an Administrator!

I Don’t Know What Version of Windows I Have

My Print Screen Key Doesn’t Work

Chapter 23: Ten or So Tips for Touchscreen Owners

Switching to Airplane Mode

Connecting to a Wireless Internet Network

Toggling Your Tablet’s Screen Rotation

Choosing What Happens When You Close Your Laptop’s Lid

Adjusting to Different Locations

Backing Up Your Laptop Before Traveling

Cheat Sheet

Office 2010 For Dummies®

Table of Contents

Introduction

Who Should Buy This Book

How This Book Is Organized

Part I: Getting to Know Microsoft Office 2010

Part II: Working with Word

Part III: Playing the Numbers with Excel

Part IV: Making Presentations with PowerPoint

Part V: Getting Organized with Outlook

Part VI: Storing Stuff in Access

Part VII: The Part of Tens

How to Use This Book

Conventions

Icons Used in This Book

Getting Started

Part I: Getting to Know Microsoft Office 2010

Chapter 1: Introducing Microsoft Office 2010

Starting an Office 2010 Program

Introducing the Microsoft Office Backstage View

The File tab

Using the Quick Access Toolbar

Using the Quick Access icons

Adding icons

Removing icons

Moving the Quick Access toolbar

Using the Ribbon

Deciphering Ribbon icons

Identifying Ribbon icons

Displaying dialog boxes

Using Live Preview

Minimizing the Ribbon

Customizing an Office 2010 Program

Changing the file format and default location

Customizing the Ribbon icons

Exiting Office 2010

Chapter 2: Selecting and Editing Data

Adding Data by Pointing

Selecting Data

Selecting data with the mouse

Selecting data with the keyboard

Selecting multiple chunks of data with the mouse and keyboard

Editing Text with the Pop-up Toolbar

Deleting Data

Cutting and Pasting (Moving) Data

Copying and Pasting Data

Using Paste Options

Dragging with the Mouse to Cut, Copy, and Paste

Undo and Redo

Sharing Data with Other Office 2010 Programs

Using the Office Clipboard

Viewing and pasting items off the Office Clipboard

Deleting items from the Office Clipboard

Chapter 3: Modifying Pictures

Adding (And Deleting) Pictures

Manipulating Pictures

Moving a picture

Resizing a picture

Rotating a picture

Enhancing Pictures

Choosing visual effects

Choosing a picture style

Adding a border around a picture

Chapter 4: Getting Help from Office 2010

Browsing the Help Window

Searching in the Help Window

Making the Help Window Easier to Read

Resizing the Help window

Enlarging the text in the Help window

Keeping the Help window visible at all times

Printing the text in the Help window

Viewing the Table of Contents

Part II: Working with Word

Chapter 5: Typing Text in Word

Moving the Cursor with the Mouse

Moving the Cursor with the Keyboard

Viewing a Document

Switching between views

Using Full Screen Reading view

Using Outline view

Navigating through a Document

Navigating with the mouse

Using the Go To command

Finding and Replacing Text

Using the Find command

Searching for text

Customizing text searching

Searching by headings

Browsing through pages

Using the Find and Replace command

Checking Your Spelling

Checking Your Grammar

Chapter 6: Formatting Text

Changing the Font

Changing the Font Size

Changing the Text Style

Changing Colors

Changing the color of text

Highlighting text with color

Using Text Effects

Justifying Text Alignment

Adjusting Line Spacing

Making Lists

Indenting list items

Converting list items back into text

Customizing a list

Renumbering numbered lists

Using the Ruler

Adjusting left and right paragraph margins

Defining indentation with the Ruler

Using Format Painter

Using Styles

Using Templates

Removing Formatting from Text

Chapter 7: Designing Your Pages

Inserting New Pages

Adding (And Deleting) a Cover Page

Inserting Page Breaks

Inserting Headers and Footers

Creating a header (or footer)

Defining which pages to display a header (or footer)

Deleting a header (or footer)

Organizing Text in Tables

Creating a table by highlighting rows and columns

Creating a table with the Insert Table dialog box

Creating a table with the mouse

Creating a table from existing text

Formatting and Coloring a Table

Selecting all or part of a table

Aligning text in a table cell

Picking a table style

Resizing columns and rows

Sorting a Table

Deleting Tables

Deleting an entire table

Deleting rows and columns

Deleting cells

Deleting cell borders

Making Text Look Artistic

Creating drop caps

Creating WordArt

Dividing Text into Columns

Editing columns

Removing columns

Previewing a Document before Printing

Defining page size and orientation

Using Print Preview

Part III: Playing the Numbers with Excel

Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas

Understanding Spreadsheets

Storing Stuff in a Spreadsheet

Typing data into a single cell

Typing data in multiple cells

Typing in sequences with AutoFill

Formatting Numbers and Labels

Formatting numbers

Formatting cells

Navigating a Spreadsheet

Using the mouse to move around in a spreadsheet

Using the keyboard to move around a spreadsheet

Naming cells

Searching a Spreadsheet

Searching for text

Searching for formulas

Editing a Spreadsheet

Editing data in a cell

Changing the size of rows and columns with the mouse

Typing the size of rows and columns

Adding and deleting rows and columns

Adding sheets

Renaming sheets

Rearranging sheets

Deleting a sheet

Clearing Data

Printing Workbooks

Using Page Layout view

Adding a header (or footer)

Printing gridlines

Defining a print area

Inserting (and removing) page breaks

Printing row and column headings

Defining printing margins

Defining paper orientation and size

Printing in Excel

Chapter 9: Playing with Formulas

Creating a Formula

Organizing formulas with parentheses

Copying formulas

Using Functions

Using the AutoSum command

Using recently used functions

Editing a Formula

Conditional Formatting

Comparing data values

Creating conditional formatting rules

Data Validation

Goal Seeking

Creating Multiple Scenarios

Creating a scenario

Viewing a scenario

Editing a scenario

Viewing a scenario summary

Auditing Your Formulas

Finding where a formula gets its data

Finding which formula(s) a cell can change

Checking for Errors

Chapter 10: Charting and Analyzing Data

Understanding the Parts of a Chart

Creating a Chart

Editing a Chart

Moving a chart on a worksheet

Moving a chart to a new sheet

Resizing a chart

Using the Chart Tools

Changing the chart type

Changing the data source

Switching rows and columns

Changing the parts of a chart

Designing the layout of a chart

Deleting a chart

Using Sparklines

Creating a Sparkline

Customizing a Sparkline

Deleting a Sparkline

Organizing Lists in Pivot Tables

Creating a pivot table

Rearranging labels in a pivot table

Modifying a pivot table

Filtering a pivot table

Summing a pivot table

Slicing up a pivot table

Creating PivotCharts

Part IV: Making Presentations with PowerPoint

Chapter 11: Creating a PowerPoint Presentation

Defining the Purpose of Your Presentation

Creating a PowerPoint Presentation

Designing a presentation with Slide view

Designing a presentation with Outline view

Working with Text

Typing text in a text box

Formatting text

Aligning text

Adjusting line spacing

Making numbered and bulleted lists

Making columns

Moving and resizing a text box

Rotating a text box

Chapter 12: Adding Color and Pictures to a Presentation

Applying a Theme

Changing the Background

Choosing a solid color background

Choosing a gradient background

Choosing a picture background

Adding Graphics to a Slide

Placing picture files on a slide

Placing clip art on a slide

Creating WordArt

Capturing screenshots

Resizing, moving, and deleting graphic images

Rotating graphics

Layering objects

Adding Movies to a Slide

Adding an animated cartoon to a slide

Adding a movie to a slide

Trimming a video

Coloring a video

Formatting the shape of a video

Adding Sound to a Slide

Adding an audio file to a presentation

Recording audio

Chapter 13: Showing Off a Presentation

Spell-Checking Your Presentation

Organizing Slides in Sections

Adding a section

Expanding and collapsing a section

Deleting a section

Adding Visual Transitions

Adding slide transitions

Text and graphic transitions

Using the Animation Painter

Adding Hyperlinks

Creating Web page hyperlinks

Creating hyperlinks to external files

Running a program through a hyperlink

Viewing a Presentation

Creating a custom slide show

Hiding a slide

Organizing with Slide Sorter view

Creating Handouts

Part V: Getting Organized with Outlook

Chapter 14: Managing E-Mail with Outlook

Configuring E-Mail Settings

Adding an e-mail account

Creating E-Mail

Creating a new e-mail message

Replying to an e-mail message

Using a stored e-mail address to create a new e-mail message

Attaching Files to Messages

Reading and Organizing E-Mail

Grouping messages into categories

Viewing messages in the conversation view

Retrieving a file attachment from a message

Deleting E-Mail Messages

Chapter 15: Calendars, Contacts, and Tasks

Setting Appointments

Making an appointment

Viewing appointments

Deleting an appointment

Storing Names and Addresses

Adding a name

Viewing names

Searching names

Managing Tasks

Storing a task

Searching tasks

Part VI: Storing Stuff in Access

Chapter 16: Using a Database

Understanding the Basics of a Database

Designing a Database

Editing and Modifying a Database

Naming a field

Adding and deleting a field

Defining the type and size of a field

Typing Data into a Database

Using Datasheet view

Using Form view

Creating a form

Viewing and editing data in a form

Editing a form

Closing and Saving a Database

Closing a database table

Closing a database file

Chapter 17: Searching, Sorting, and Querying a Database

Searching a Database

Searching for a specific record

Filtering a database

Sorting a Database

Querying a Database

Creating a simple query

Creating a crosstab query

Creating a query that finds duplicate field data

Creating an unmatched query

Viewing, renaming, closing, and deleting queries

Chapter 18: Creating a Database Report

Using the Report Wizard

Manipulating the Data in a Report

Switching a report to Layout view

Counting records or values

Sorting a field

Filtering a field

Editing a Report

Resizing fields

Deleting fields

Making Reports Look Pretty

Applying themes

Creating conditional formatting

Deleting a Report

Part VII: The Part of Tens

Chapter 19: Ten Tips for Using Office 2010

Saving Office 2010 Files

Password-Protecting Your Files

Guarding Against Macro Viruses

Customize the Ribbon

Zooming In (And Out) to Avoid Eyestrain

When in Doubt, Right-Click the Mouse

Freezing Row and Column Headings in Excel

Displaying Slides Out of Order in PowerPoint

Reduce Spam in Outlook

Setting up Outlook’s junk e-mail filter

Creating a Safe Senders list

Creating a Blocked Senders list

Using Office Web

Chapter 20: Ten Keystroke Shortcuts

Protecting Yourself with Undo (Ctrl+Z) and Redo (Ctrl+Y)

Cut (Ctrl+X), Copy (Ctrl+C), and Paste (Ctrl+V)

Saving a File (Ctrl+S)

Printing a File (Ctrl+P)

Checking Your Spelling (F7)

Opening a File (Ctrl+O)

Creating a New File (Ctrl+N)

Finding Text (Ctrl+F)

Finding and Replacing Text (Ctrl+H)

Closing a Window (Ctrl+W)

Chapter 21: Almost Ten Ways to Make Office 2010 Easier to Use

Learning Visual Basic for Applications (VBA)

Collaborating with the Review Tab

Using Word’s References Tab

Using Excel’s Data Tab

Saving and Sending Files

Password-Protecting a File

Checking File Compatibility

Ignoring the Silly Office Ribbon

Windows® 8 For Dummies®

Visit www.dummies.com/cheatsheet/windows8 to view this book's cheat sheet.

Table of Contents

Introduction

About This Book

How to Use This Book

Tablet Owners Aren’t Left Out

And What about You?

How This Book Is Organized

Part I: Windows 8 Stuff Everybody Thinks You Already Know

Part II: Working with Programs, Apps, and Files

Part III: Getting Things Done on the Internet

Part IV: Customizing and Upgrading Windows 8

Part V: Music, Photos, and Movies

Part VI: Help!

Part VII: The Part of Tens

Icons Used in This Book

Where to Go from Here

Part I: Windows 8 Stuff Everybody Thinks You Already Know

Chapter 1: What Is Windows 8?

What Is Windows 8, and Why Are You Using It?

What’s New in Windows 8?

Should I Bother Switching to Windows 8?

Can My Current PC Still Run Windows 8?

The Four Flavors of Windows 8

Chapter 2: The Mysterious New Start Screen

Being Welcomed to the World of Windows 8

Understanding user accounts

Keeping your account private with a password

Signing up for a Microsoft account