book

Office 2016 All-In-One For Dummies

Name: Office 2016 All-In-One For Dummies
Author: Peter Weverka
ISBN: 9781119083122

by Peter Weverka

November 2015

Beginner

792 pages

18h 47m

English

For Dummies

Read now

Unlock full access

Cover
Introduction
About This BookFoolish AssumptionsIcons Used in This BookBeyond the BookWhere to Go from Here
Book I: Common Office Tasks
Chapter 1: Office Nuts and Bolts
A Survey of Office ApplicationsAll about Office 365Finding Your Way Around the Office InterfaceSaving Your FilesNavigating the Save As and Open WindowsOpening and Closing FilesReading and Recording File PropertiesLocking a File with a Password
Chapter 2: Wrestling with the Text
Manipulating the TextChanging the Look of TextQuick Ways to Handle Case, or CapitalizationEntering Symbols and Foreign CharactersCreating Hyperlinks
Chapter 3: Speed Techniques Worth Knowing About
Undoing and Repeating CommandsZooming In, Zooming OutViewing a File Through More Than One WindowCorrecting Typos on the FlyEntering Text Quickly with the AutoCorrect Command
Book II: Word 2016
Chapter 1: Speed Techniques for Using Word
Introducing the Word ScreenCreating a New DocumentGetting a Better Look at Your DocumentsSelecting Text in Speedy WaysMoving Around Quickly in DocumentsInserting a Whole File into a DocumentEntering Information Quickly in a Computerized Form
Chapter 2: Laying Out Text and Pages
Paragraphs and FormattingInserting a Section Break for Formatting PurposesBreaking a LineStarting a New PageSetting Up and Changing the MarginsIndenting Paragraphs and First LinesNumbering the PagesPutting Headers and Footers on PagesAdjusting the Space between LinesAdjusting the Space Between ParagraphsCreating Numbered and Bulleted ListsWorking with TabsHyphenating Text
Chapter 3: Word Styles
All About StylesApplying Styles to Text and ParagraphsCreating a New StyleModifying a StyleCreating and Managing Templates

Chapter 4: Constructing the Perfect Table
Talking Table JargonCreating a TableEntering the Text and NumbersSelecting Different Parts of a TableLaying Out Your TableAligning Text in Columns and RowsMerging and Splitting CellsRepeating Header Rows on Subsequent PagesFormatting Your TableUsing Math Formulas in TablesNeat Table Tricks
Chapter 5: Taking Advantage of the Proofing Tools
Correcting Your Spelling ErrorsChecking for Grammatical Errors in WordGetting a Word DefinitionFinding and Replacing TextResearching a Topic Inside WordFinding the Right Word with the ThesaurusProofing Text Written in a Foreign LanguageTranslating Foreign Language Text
Chapter 6: Desktop Publishing with Word
Experimenting with ThemesSprucing Up Your PagesMaking Use of Charts, Diagrams, Shapes, and PhotosWorking with the Drawing CanvasPositioning and Wrapping Objects Relative to the Page and TextWorking with Text BoxesDropping In a Drop CapWatermarking for the Elegant EffectPutting Newspaper-Style Columns in a DocumentLandscape DocumentsPrinting on Different Size PaperShowing Online Video in a Document
Chapter 7: Getting Word’s Help with Office Chores
Highlighting Parts of a DocumentCommenting on a DocumentTracking Changes to DocumentsPrinting an Address on an EnvelopePrinting a Single Address Label (Or a Page of the Same Label)Churning Out Letters, Envelopes, and Labels for Mass Mailings
Chapter 8: Tools for Reports and Scholarly Papers
Alphabetizing a ListOutlines for Organizing Your WorkCollapsing and Expanding Parts of a DocumentGenerating a Table of ContentsIndexing a DocumentPutting Cross-References in a DocumentPutting Footnotes and Endnotes in DocumentsCompiling a Bibliography
Book III: Excel 2016
Chapter 1: Up and Running with Excel
Creating a New Excel WorkbookGetting Acquainted with ExcelEntering Data in a WorksheetQuickly Entering Lists and Serial Data with the AutoFill CommandFormatting Numbers, Dates, and Time ValuesEstablishing Data-Validation Rules
Chapter 2: Refining Your Worksheet
Editing Worksheet DataMoving Around in a WorksheetGetting a Better Look at the WorksheetComments for Documenting Your WorksheetSelecting Cells in a WorksheetDeleting, Copying, and Moving DataHandling the Worksheets in a WorkbookKeeping Others from Tampering with Worksheets
Chapter 3: Formulas and Functions for Crunching Numbers
How Formulas WorkThe Basics of Entering a FormulaSpeed Techniques for Entering FormulasCopying Formulas from Cell to CellDetecting and Correcting Errors in FormulasWorking with FunctionsA Look at Some Very Useful Functions
Chapter 4: Making a Worksheet Easier to Read and Understand
Laying Out a WorksheetDecorating a Worksheet with Borders and ColorsGetting Ready to Print a Worksheet
Chapter 5: Advanced Techniques for Analyzing Data
Seeing What the Sparklines SayConditional Formats for Calling Attention to DataManaging Information in ListsForecasting with the Goal Seek CommandPerforming What-If Analyses with Data TablesAnalyzing Data with PivotTables
Book IV: PowerPoint 2016
Chapter 1: Getting Started in PowerPoint
Getting Acquainted with PowerPointA Brief Geography LessonA Whirlwind Tour of PowerPointCreating a New PresentationAdvice for Building Persuasive PresentationsCreating New Slides for Your PresentationGetting a Better View of Your WorkHiding and Displaying the SlidesPane and Notes PaneSelecting, Moving, and Deleting SlidesPutting Together a Photo AlbumHidden Slides for All Contingencies
Chapter 2: Fashioning a Look for Your Presentation
Looking at Themes and Slide BackgroundsChoosing a Theme for Your PresentationCreating Slide Backgrounds on Your OwnChanging the Background of a Singleor Handful of SlidesChoosing the Slide SizeUsing Master Slides and Master Styles for a Consistent Design
Chapter 3: Entering the Text
Entering TextFun with Text Boxes and Text Box ShapesControlling How Text Fits in Text Frames and Text BoxesPositioning Text in Frames and Text BoxesHandling Bulleted and Numbered ListsPutting Footers (and Headers) on Slides
Chapter 4: Making Your Presentations Livelier
Suggestions for Enlivening Your PresentationPresenting Information in a TableExploring Transitions and AnimationsMaking Audio Part of Your PresentationPlaying Video on SlidesRecording a Voice Narration for Slides
Chapter 5: Delivering a Presentation
All about NotesRehearsing and Timing Your PresentationShowing Your PresentationTricks for Making Presentations a Little LivelierDelivering a Presentation When You Can’t Be There in Person
Book V: OneNote 2016
Chapter 1: Up and Running with OneNote
Introducing OneNoteFinding Your Way Around the OneNote ScreenUnits for Organizing NotesCreating a NotebookCreating Sections and Section GroupsCreating Pages and SubpagesRenaming and Deleting Groups and PagesGetting from Place to Place in OneNoteChanging Your View of OneNote
Chapter 2: Taking Notes
Entering a Typewritten NoteNotes: The BasicsDrawing on the PageConverting a Handwritten Note to TextWriting a Math Expression in a NoteTaking a Screen-Clipping NoteRecording and Playing Audio NotesAttaching, Copying, and Linking Files to Notes
Chapter 3: Finding and Organizing Your Notes
Finding a Stray NoteTagging Notes for Follow UpColor-Coding Notebooks, Sections, and PagesMerging and Moving Sections, Pages, and Notes
Book VI: Outlook 2016
Chapter 1: Outlook Basics
What Is Outlook, Anyway?Navigating the Outlook FoldersCategorizing ItemsSearching for Stray Folder ItemsDeleting Email Messages, Contacts, Tasks, and Other ItemsFinding and Backing Up Your Outlook FileCleaning Out Your Folders
Chapter 2: Maintaining the Contacts Folder
Maintaining a Happy and Healthy Contacts FolderContact Groups for Sending Messages to GroupsFinding a Contact in the Contacts FolderPrinting the Contacts Folder
Chapter 3: Handling Your Email
Setting Up an Email AccountAddressing and Sending Email MessagesSending Files and PhotosReceiving Email MessagesReading Your Email in the Inbox WindowHandling Files That Were Sent to YouTechniques for Organizing Email MessagesAll about Email FoldersYes, You Can Prevent Junk Mail (Sort of)
Chapter 4: Managing Your Time and Schedule
Introducing the CalendarThe Different Kinds of ActivitiesSeeing Your ScheduleScheduling Appointments and EventsCanceling, Rescheduling, and Altering Activities
Chapter 5: Tasks, Reminders, and Notes
Tasks: Seeing What Needs to Get DoneReminders for Being Alerted to Activities and TasksMaking Notes to Yourself
Book VII: Access 2016
Chapter 1: Introducing Access
What Is a Database, Anyway?Tables, Queries, Forms, and Other ObjectsCreating a Database FileFinding Your Way Around the Navigation PaneDesigning a Database
Chapter 2: Building Your Database Tables
Creating a Database TableOpening and Viewing TablesEntering and Altering Table FieldsField Properties for Making Sure That Data Entries Are AccurateIndexing for Faster Sorts, Searches, and QueriesEstablishing Relationships Between Database Tables
Chapter 3: Entering the Data
The Two Ways to Enter DataEntering the Data in Datasheet ViewEntering the Data in a FormFinding a Missing RecordFinding and Replacing Data
Chapter 4: Sorting, Querying, and Filtering for Data
Sorting Records in a Database TableFiltering to Find InformationQuerying: The BasicsSix Kinds of Queries
Chapter 5: Presenting Data in a Report
Creating a ReportOpening and Viewing ReportsTweaking a Report
Book VIII: Working with Charts and Graphics
Chapter 1: Creating a Chart
The Basics: Creating a ChartChoosing the Right ChartProviding the Raw Data for Your ChartPositioning Your Chart in a Workbook, Page, or SlideChanging a Chart’s AppearanceSaving a Chart as a Template So That You Can Use It AgainChart Tricks for the Daring and HeroicTroubleshooting a Chart
Chapter 2: Making a SmartArt Diagram
The Basics: Creating SmartArt DiagramsCreating the Initial DiagramChanging the Size and Position of a DiagramLaying Out the Diagram ShapesHandling the Text on Diagram ShapesChanging a Diagram’s DirectionChoosing a Look for Your DiagramChanging the Appearance of Diagram ShapesCreating a Diagram from Scratch
Chapter 3: Handling Graphics and Photos
All about Picture File FormatsInserting a Picture in an Office FileTouching Up a PictureCompressing Pictures to Save Disk Space
Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects
The Basics: Drawing Lines, Arrows, and ShapesHandling Lines, Arrows, and ConnectorsHandling Rectangles, Ovals, Stars, and Other ShapesWordArt for Embellishing Letters and WordsManipulating Lines, Shapes, Art, Text Boxes, and Other ObjectsChanging an Object’s Size and ShapeChanging an Object’s Color, Outline Color, and TransparencyMoving and Positioning Objects
Book IX: Office 2016 — One Step Beyond
Chapter 1: Customizing an Office Program
Customizing the RibbonCustomizing the Quick Access ToolbarCustomizing the Status BarChanging the Screen Backgroundand Office ThemeCustomizing Keyboard Shortcuts in Word
Chapter 2: Ways of Distributing Your Work
Printing — the Old StandbyDistributing a File in PDF FormatSending Your File in an Email MessageSaving an Office File as a Web PageBlogging from inside Word
Chapter 3: Working with Publisher
“A Print Shop in a Can”Introducing FramesCreating a PublicationRedesigning a PublicationGetting a Better View of Your WorkEntering Text on the PagesMaking Text Fit in Text FramesMaking Text Wrap around a Frame or GraphicReplacing the Placeholder PicturesInserting, Removing, and Moving PagesMaster Pages for Handling Page BackgroundsRunning the Design CheckerCommercially Printing a Publication
Book X: File Sharing and Collaborating
Chapter 1: Up and Running on OneDrive
Signing In to OneDriveExploring the OneDrive WindowManaging Your OneDrive FoldersUploading Files to a Folder on OneDriveSaving a File from Office 2016 to OneDriveOpening a File from OneDriveDownloading Files from OneDrive to Your Computer
Chapter 2: File Sharing and Collaborating
Sharing Files: The Big PictureSharing Your Files and Folders with OthersSeeing Files and Folders Others Shared with YouInvestigating and Changing How Files and Folders Are Shared
About the Author
Cheat Sheet
Connect with Dummies
End User License Agreement

Overview

The fast and easy way to get things done with Office

Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word—and every application in between—this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more—and make your work and home life easier, more productive, and more streamlined.

Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it—let alone master it. Luckily, Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office's advanced features.

Create customized documents and add graphic elements, proofing, and citations in Word
Build a worksheet, create formulas, and perform basic data analysis in Excel
Create a notebook and organize your thoughts in Notes
Manage messages, tasks, contacts, and calendars in Outlook

Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you'll turn to again and again.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781119083122Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills