by Faithe Wempen
Publisher’s Acknowledgments
Acquisitions Editor: Andy Cummings
Project Editor: Christopher Morris
Copy Editor: Christopher Morris
Editorial Assistant: Claire Johnson
Sr. Editorial Assistant: Cherie Case
Project Coordinator: Suresh Srinivasan
Cover Image: Monkey Business Images/Shutterstock
Purchase Now !
Just with Paypal
Just with Paypal
Book Details
Price
|
3.50 |
|---|---|
Pages
| 360 p |
File Size
|
12,082 KB |
File Type
|
PDF format |
ISBN
| 978-1-119-07749-7 (pbk) 978-1-119-07752-7 (ebk) 978-1-119-07738-1 (ebk) |
Copyright©
| 2016 by John Wiley & Sons, Inc |
Faithe Wempen, MA, is a Microsoft Office Master Instructor and the author of more
than 150 books on computer hardware and software, including PowerPoint 2013 Bible
and Office 2013 eLearning Kit For Dummies. She is an adjunct instructor of Computer
Information Technology at Purdue University, and her corporate training courses online
have reached more than a quarter of a million students for clients such as Hewlett-
Packard, Sony, and CNET.
Introduction
Microsoft Office 2016 is by far the most popular suite of productivity applications in
the world, and with good reason. Its applications are powerful enough for business and
professional use, and yet easy enough that a beginner can catch on to the basics with
just a few simple lessons.
If you’re new to Office 2016, this book can help you separate the essential features you
need from the obscure and more sophisticated ones you don’t. For the four major
Office applications I cover in this book — Word, Excel, Outlook, and PowerPoint — I
walk you through the most important and common features, showing you how to put
them to work for projects in your job, everyday life, and home.
About This Book
This book is written specifically for mature people like you, who are relatively new to
using Office applications and want to master the basics. In this book, I tried to take into
account the types of activities that might interest you, such as investment planning,
personal finance, email, and documents and presentations that you might need to
prepare for work, clubs, volunteer opportunities, or other organizations that you participate in.
Table of Contents
of Contents
Cover
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Conventions Used in This Book
Time to Get Started!
Part I: Getting Started with Office 2016
Chapter 1: The Two-Dollar Tour
Start an Office Application
Start a New Document
Explore the Office Ribbon and Tabs
Understand the File Menu (Backstage View)
Create a Document
Type Text
Insert a Picture
Move Around in a Document
Select Content
Zoom In and Out
Change the View
Chapter 2: Exploring the Common Features of Office 2016
Edit Text
Move and Copy Content
Choose Fonts and Font Sizes
Apply Text Formatting
Use the Mini Toolbar
Work with Themes
Check Your Spelling and Grammar
Chapter 3: Opening, Saving, and Printing Files
Save Your Work
Open a Previously Saved File
Change the File Listing View
Email Your Work to Others
Share Your Work in Other Formats
Print Your Work
Recover Lost Work
Part II: Word
Chapter 4: Composing Your Thoughtsin Word
Examine the Word Interface
Move Around and Select Text
Choose Paper Size and Orientation
Set Margins
Select the Right Screen View
Align and Indent Paragraphs
Change Line Spacing
Create Bulleted and Numbered Lists
Chapter 5: Dressing Up Your Documents
Apply Styles and Style Sets
Insert Photos
Size and Format a Picture
Position a Picture
Add a Page Border
Apply a Background Color to a Page
Create Tables
Format a Table
Chapter 6: Taking Word to the Next Level
Number the Pages
Use Headers and Footers
Insert Cover Pages and Other Building Blocks
Print an Envelope
Perform a Mail Merge
Insert the Date and Time
Part III: Excel
Chapter 7: Creating Basic Spreadsheets in Excel
Understand Excel’s Unique Features
Get Familiar with Spreadsheet Structure
Move the Cell Cursor
Select a Range
Type and Edit Cell Contents
Insert and Delete Rows, Columns, and Cells
Work with Worksheets
Chapter 8: Doing the Math: Formulas and Functions
Learn How Formulas Are Structured
Write Formulas That Reference Cells
Move and Copy Cell Content
Reference a Cell on Another Sheet
Understand Functions
Take a Tour of Some Basic Functions
Explore Financial Functions
Chapter 9: Creating Visual Interest with Formatting and Charts
Adjust Row Height and Column Width
Wrap Text in a Cell
Apply Gridlines or Borders
Apply Fill Color
Format Text in Cells
Format the Spreadsheet as a Whole
Create a Basic Chart
Identify the Parts of a Chart
Format a Chart
Chapter 10: Using Excel as a Database
Understand Databases
Prepare a List for a Mail Merge
Store Data in a Table
Sort a Table
Filter Data in a Table
Split a Column’s Content
Merge the Contents of Columns
Part IV: Outlook
Chapter 11: Managing Email with Outlook
Set Up Outlook for the First Time
Set Up Additional Mail Accounts
Troubleshoot Mail Setup Problems
Take a Quick Tour of Outlook’s Mail Feature
Receive and Read Your Mail
View Photos and Other Attachments
Reply to a Message
Compose a Message
Attach a File to a Message
Avoid Frauds, Scams, and Viruses
Chapter 12: Managing the Details: Contacts, Notes, and Tasks
Store Contact Information
Edit and Delete Contacts
Choose How the Contact List Appears
Use the Contacts List
Create Notes
Categorize Notes
Use Tasks and the To-Do List
Update the Status of a Task
Set a Task Reminder
Chapter 13: Your Busy Life: Using the Calendar
View Your Calendar
Create and Delete a Calendar Event
Set an Event to Recur
Configure Event Reminders
Add Holidays
Print a Hard Copy of Your Calendar
Part V: PowerPoint
Chapter 14: Getting Started with PowerPoint
Explore the PowerPoint Interface
Work with PowerPoint Files
Understand PowerPoint Views
Create New Slides
Use Slide Placeholders
Turn Text AutoFit Off or On
Change Slide Layouts
Move or Resize Slide Content
Manually Place Text on a Slide
Navigate and Select Text
Select Content
Chapter 15: Dressing Up Your Presentations
Understand and Apply Themes and Variants
Change the Presentation Colors
Edit Slide Masters
Format Text Boxes and Placeholders
Insert Pictures
Create a Photo Album Presentation
Chapter 16: Adding Movement and Sound
Animate Objects on a Slide
Add Slide Transition Effects
Set Slides to Automatically Advance
Add a Soundtrack
Chapter 17: Presenting the Show
Display a Slide Show Onscreen
Use the Slide Show Tools
Print Copies of a Presentation
Package a Presentation for Distribution
Make a Video of the Presentation
Appendix A: Customizing Office Applications
Customize the Quick Access Toolbar
Customize the Status Bar
Set Program Options
Set Outlook Options
About the Author
Cheat Sheet
Advertisement Page
Connect with Dummies
End User License Agreement
Bookscreen
Time to Get Started!
This is your book; use it how you want. You can start at the beginning and read it
straight through, or you can hop to whatever chapter or topic you want. For those of
you who are pretty new to computers, you might want to start at the beginning. If
you’re new to Office, the beginning part will give you a good foundation on what
features work similarly in all the programs.