book

Office 2016 In Depth

Name: Office 2016 In Depth
Author: Joe Habraken
ISBN: 9780134273761

by Joe Habraken

October 2015

Intermediate to advanced

1008 pages

32h 45m

English

Que

Read now

Unlock full access

About This eBook
Title Page
Copyright Page
Contents at a Glance
Contents
About the Author
Dedication
Acknowledgments
We Want to Hear from You!
Reader Services

Introduction
Who Should Buy This BookHow This Book Is OrganizedConventions Used in This BookKey CombinationsSpecial ElementsCross-References
I: Introduction to the Office 2016 Application Suite
1. Getting Oriented to the Office 2016 Applications
Introducing Office 2016New Features and Tools in Office 2016Saving and Sharing Files in the CloudEditing Adobe Acrobat FilesOther Office 2016 Improvements and UpdatesThe Office 2016 Suite ApplicationsThe Different Versions of the Office 2016 SuiteHardware and Software Requirements for Office 2016Installing Office 2016Getting Help in the Office Applications
2. Navigating and Customizing the Office Interface
Getting Familiar with the Office InterfaceGalleriesContextual TabsOverview of the Office Application WindowNavigating the Office ApplicationsWorking with the RibbonWorking in the BackstageCustomizing an Application InterfaceCustomizing the RibbonCustomizing the Quick Access ToolbarCustomizing the Status BarConfiguring Application OptionsAdvanced Option SettingsAdd-InsUsing Office Add-insUsing the Trust CenterTrusted PublishersTrusted Locations
3. Managing and Sharing Office Files
Understanding Office File FormatsSaving Files as Different File TypesConverting Files to Different File TypesConfiguring Save File OptionsCreating and Managing FilesManaging FilesCreating a New FolderCreating a New LibraryViewing File Versions in an ApplicationSearching for Office FilesSharing Files Using HomegroupProtecting an Office FilePrepare a File for Sharing
4. Using and Creating Graphics
The Office 2016 Options for Graphics and PicturesWorking with SmartArt GraphicsInserting SmartArt GraphicsModifying SmartArt GraphicsWorking with Your Digital PicturesInserting PicturesAdjusting PicturesCropping an ImageUsing the Background Removal ToolInserting Online PicturesInserting Bing Image Search ResultsInserting Facebook ImagesInserting Flickr.com ImagesInserting Images from Your OneDriveUsing Shapes and the Office Drawing ToolsAdding and Combining Multiple ShapesFormatting a Shape with the Drawing ToolsUsing the Screenshot FeatureUsing WordArt
5. Using the Office Apps
What the Online Apps Can DoWhere the Online Apps LiveSaving Office Application Files to the CloudSaving a File to OneDrive or OneDrive for BusinessSharing a File Saved to the CloudUsing the Word Online appThe Word Online App’s File TabThe Word Online App’s Home TabThe Word Online App’s Insert TabThe Word Online App’s Review TabThe Word Online App’s View TabUsing Excel OnlineThe Excel Online App’s File TabWorking in the Excel Online AppInserting Functions and Charts in the Excel Online AppUsing PowerPoint OnlineWorking with SlidesAdding Pictures and SmartArtThe Windows 10 Mobile Office AppsThe Word Mobile AppThe Excel Mobile App
II: Word
6. Requisite Word: Essential Features
Introducing Word 2016The Word 2016 InterfaceNew Features and ImprovementsOptions for Creating a New Word DocumentUsing TemplatesCreating a TemplateAttaching a TemplateNavigating a Word DocumentMoving Around a Document with the MouseMoving Around a Document with the KeyboardSelecting TextUnderstanding Document FormattingCharacter Formatting Versus Paragraph FormattingManual Formatting Versus Styles and ThemesWorking with Fonts and Text FormattingFormatting TextWorking with Paragraph FormattingSetting Paragraph AlignmentChanging Line SpacingSetting Line and Page BreaksSetting IndentsWorking with TabsRevealing Format SettingsPage Layout: Margins and Page OptionsChanging MarginsChanging Page Orientation and Paper SizeInserting Page BreaksPrinting Documents
7. Enhancing Word Documents
Creating Better DocumentsCreating Bulleted and Numbered ListsBulleted ListsNumbered ListsMultilevel ListsWorking with Borders and ShadingFormatting with ThemesCreating Headers and FootersInserting Headers and FootersThe Header and Footer ToolsWorking with Page NumberingInserting Pictures, Clip Art, and ChartsInserting PicturesInserting Online Pictures and Clip ArtInserting a ChartIntegrating Text and ImagesChanging the Document DisplayUsing the Navigation PaneUsing the Outline ViewSplitting the Document WindowUsing the Review ToolsRunning Spelling and GrammarUsing the ThesaurusUsing the Insights CommandWorking with Quick PartsCreating and Inserting an AutoText EntryCreating and Inserting Building BlocksConfiguring AutoCorrectUnderstanding StylesUsing the Styles GalleryCreating StylesEditing StylesManaging Styles
8. Working with Tables, Columns, and Sections
Options for Adding a TableInserting a TableDrawing a TableConverting Text to a TableEntering and Deleting Text and Navigating a TableSelecting and Positioning a TableFormatting TablesAdjusting Columns and RowsFormatting CellsUsing Table StylesSorting Table DataUsing Formulas in TablesAdding Columns to a DocumentUnderstanding SectionsAdding and Removing Section BreaksFormatting Page Attributes in a Section
9. Managing Mailings and Forms
Options for Mail-Related DocumentsCreating an EnvelopeCreating a Label or LabelsUnderstanding Mass MailingsPerforming a Mail MergeUsing the Mail Merge CommandsUnderstanding Recipient ListsCreating a Recipient ListEditing and Manipulating a Recipient ListUsing Merge FieldsUsing Merge RulesPreviewing Merge ResultsCompleting the MergeCreating Merged Envelopes and LabelsUnderstanding Word FieldsBuilding a Form with Form Controls
10. Creating Special Documents
Options for Large DocumentsCreating a Table of ContentsCreating a Table of Contents with Built-in StylesCreating a Table of Contents with Your Own StylesAdding Entries and Updating the TOCBuilding a TOC with Field CodesWorking with Captions and Tables of FiguresInserting a CaptionInserting a Table of FiguresUsing Cross-ReferencesGenerating an IndexMarking Index EntriesInserting the IndexWorking with Citations and BibliographiesCreating CitationsManaging CitationsInserting the BibliographyInserting Footnotes and EndnotesTracking Document ChangesOptions for Viewing ChangesReviewing ChangesComparing DocumentsBuilding a Better “Big” DocumentCreating BookmarksInserting CommentsCreating a Master DocumentWorking in Outline ViewCreating Subdocuments from ScratchInserting Existing Document Files into a Master Document OutlineManipulating the Master Document
III: Excel
11. Requisite Excel: Essential Features
Introducing Excel 2016Navigating the Excel WorkspaceThe Excel RibbonMoving Around a WorksheetCreating Workbooks and WorksheetsUsing Office.com TemplatesInserting and Rearranging WorksheetsManaging Excel WorkbooksProtecting Workbooks and WorksheetsLocking CellsSpecifying Edit RangesPreparing a Workbook for SharingManaging VersionsEntering Data in a WorksheetEntering LabelsEntering ValuesUsing AutoCompleteFilling and Entering SeriesUsing the Fill HandleCreating Custom Fill ListsCreating Custom SeriesUsing Flash FillCopying, Moving, and Deleting Cell ContentsUsing the Paste Special Dialog BoxMoving Cells and RangesClearing and Deleting CellsEditing Cell ContentViewing WorksheetsPrinting WorksheetsUsing the Page Layout CommandsSetting a Print AreaInserting Page BreaksSetting Print TitlesWorking on the Print PageInserting Headers and Footers
12. Worksheet Formatting and Management
Formatting Text EntriesAccessing the Format Cells Dialog BoxChanging Text OrientationFormatting ValuesUsing the Format Cells Dialog BoxCreating Custom Number FormatsAdding Comments to CellsFormatting Comment TextDeleting and Viewing CommentsUsing ThemesFormatting Cells Using Borders and ColorAdding Cell BordersUsing Background ColorsUsing Cell Styles and the Format PainterCreating a Cell StyleUsing the Format PainterUsing Conditional FormattingUsing Highlight Cell RulesUsing Top/Bottom RulesUsing Data BarsUsing Color ScalesUsing Icon SetsCreating Conditional Formatting RulesManipulating Cells and Cell ContentInserting CellsMerging Cells and Wrapping TextFinding and Replacing Cell ItemsWorking with Columns and RowsChanging Column Width and Row HeightInserting Columns and RowsDeleting Columns and RowsHiding Columns and RowsWorking with WorksheetsFreezing Rows and ColumnsSplitting WorksheetsHiding WorksheetsNaming RangesCreating Range Names from SelectionsManaging Range NamesAdding Images and Graphics to Worksheets
13. Getting the Most from Formulas and Functions
Performing Calculations in Excel WorksheetsRelative Versus Absolute ReferencingCreating and Editing FormulasUnderstanding Operator PrecedenceEntering FormulasEditing FormulasWorking with Excel FunctionsEntering a Function in a CellUsing AutoSumUsing the Status Bar Statistical FunctionsUsing the Insert Function Dialog BoxUsing the Function LibraryUsing Range Names in Formulas and FunctionsInserting a Range Name into a FormulaInserting a Range Name into a FunctionReferencing Cells or Ranges on Other WorksheetsCopying and Moving Formulas and FunctionsChoosing the Right FunctionFinancial FunctionsLogical FunctionsStatistical FunctionsLookup & Reference FunctionsDate & Time FunctionsText FunctionsOther Function CategoriesProofing Your Formulas and FunctionsCommon Error MessagesUsing the Auditing ToolsUsing the Watch Window
14. Enhancing Worksheets with Charts
Understanding Excel ChartsChart TerminologyUsing Different Chart TypesCreating ChartsInserting a Chart from the RibbonSelecting a Recommended ChartInserting Charts with the Quick Analysis GalleryTools for Quickly Customizing a ChartMoving, Copying, or Deleting a ChartModifying a ChartChanging Chart Type or Chart DataSelecting Chart Layouts and StylesWorking with Chart ElementsModifying Titles and Data LabelsWorking with the Legend and Data PointsManipulating Axes and GridlinesAdding Trendlines, Drop Lines, and Bars to a ChartCreating a Combination ChartWorking with a Pie of Pie ChartCreating a Custom Combination ChartUsing SparklinesCreating SparklinesModifying Sparklines
15. Using Excel Tables and Pivottables
Excel and DatabasesDefining a Table RangeCreating a Table Using StylesUsing the Table ToolsSorting Table DataHow Excel Sorts DataUsing the Sort Dialog BoxFiltering Table DataUsing the AutoFilter Search BoxCreating Custom AutoFiltersFiltering Tables with SlicersCreating Advanced FiltersUsing the Data FormCreating Outlines and SubtotalsWorking with External DataImporting Data from AccessImporting a Web TableImporting Text FilesConnecting to Other Data SourcesUsing Microsoft QueryViewing and Refreshing ConnectionsWorking with PivotTablesUsing the Recommended PivotTables CommandCreating a PivotTableWorking with the PivotTable ToolsUsing Slicers
16. Validating and Analyzing Worksheet Data
Taking Advantage of Data ValidationSpecifying Validation CriteriaConfiguring Input Messages and Error AlertsCircling Invalid DataPerforming a What-If AnalysisCreating a Data TableCreating ScenariosViewing Scenarios and Creating ReportsUsing Goal Seek and SolverWorking with Goal SeekWorking with Solver
IV: PowerPoint
17. Requisite Powerpoint: Essential Features
PowerPoint 2016Options for Creating a New PresentationUsing TemplatesUsing a Theme to Create a New PresentationCreating a Presentation from an Existing PresentationInserting Slides from the Reuse Slides Task PanePublishing Slides to a LibraryCreating a TemplateInserting New SlidesEntering TextInserting Slides from a Word OutlineInserting Other Object ContentModifying a Slide’s LayoutWorking with Slides in Different ViewsZooming In and OutRulers, Gridlines, and GuidesColor/Grayscale CommandsOpening a New Presentation WindowRearranging and Deleting SlidesModifying Bulleted ListsUsing Numbered ListsViewing a Presentation During Editing
18. Advanced Presentation Formatting, Themes, and Masters
Working with Text Boxes and FormattingInserting a Text BoxBasic Text FormattingFormatting a Text Box with the Drawing ToolsSelecting Quick Styles and Shape AttributesShape Fill, Outline, and EffectsUsing WordArt Styles and Text SettingsArranging Text in TablesInserting a Table on an Existing SlideFormatting a TableTable Layout CommandsWorking with ThemesApplying ThemesApplying Theme VariantsCreating a Custom ThemeUsing Headers and FootersUnderstanding MastersAltering and Creating Master SlidesCreating Layout MastersUsing Slide Sections
19. Better Slides with Clip Art, Pictures, and SmartArt
Using Graphics to Enhance SlidesInserting a PictureAdding Online Images to SlidesCreating a Photo AlbumAdjusting Picture SettingsConfiguring Album Layout SettingsWorking with ShapesUsing SmartArt GraphicsInserting a SmartArt GraphicConverting Text to a SmartArt GraphicUsing the SmartArt ToolsAdding Charts to SlidesInserting a Chart onto a SlideModifying and Formatting a ChartWorking with Slide ObjectsGrouping ObjectsLayering ObjectsAdding Hyperlinks to Slides
20. Enhancing Slides with Animation, Transitions, and Multimedia
Animations versus TransitionsAssigning Animation to a Slide ObjectAccessing Additional Animation EffectsUsing Motion PathsAdvanced Animation TechniquesChanging Effect OptionsAdding Additional AnimationsUsing the Animation PainterIncluding Sound Effects with AnimationsSetting Timings for AnimationsManaging Slide AnimationsAdding Transitions to SlidesModifying TransitionsAdding Sound to a SlideEditing Sound OptionsAdding Video to a SlideInserting Online VideoInserting a Video FileModifying Your Video Clips
21. Delivering a Presentation and Creating Support Materials
Planning Your PresentationChecking the Presentation for Spelling and Grammar ErrorsRunning Through a Completed PresentationUsing the Presenter ViewUsing Hidden SlidesCreating a Custom Slide ShowCreating a Self-Running PresentationSetting Up a Slide ShowRehearsing TimingsRecording a Slide ShowCreating an Interactive PresentationPresenting a Slide Show OnlinePresenting Online with Skype for BusinessPresenting Online with the Office Presentation ServiceWorking with the Notes and Handout MastersSetting Handout Master OptionsSetting Notes Master OptionsPrinting Presentations, Notes, and HandoutsExporting a PresentationSharing Your Presentation
V: Outlook
22. Requisite Outlook: Configuration and Essential Features
Introducing Outlook 2016Outlook and Email AccountsExchange ActiveSyncOutlook.com EmailInternet EmailConfiguring Outlook at First StartUnderstanding Outlook ProfilesCreating a New ProfileManaging ProfilesLoading ProfilesUnderstanding Outlook Data FilesConfiguring Outlook for Microsoft Exchange ServerCreating Personal Folders FilesRepairing Outlook Data FilesImporting and Exporting DataImporting DataExporting DataNavigating the Outlook WorkspaceAccessing Outlook Items Using the Navigation BarWorking with Views in OutlookCategorizing Outlook ItemsSearching for Outlook ItemsUsing Advanced FindUsing Search FoldersPrinting Outlook Items
23. Managing Email in Outlook
Working in the Mail FolderCreating an Email MessageUsing the Outlook Address BookSetting Message OptionsSpecifying Email FormatSetting Message Flags, Importance, and SensitivityConfiguring Voting Buttons, Receipts, and Delivery OptionsThe Message Options/Properties Dialog BoxAttaching Files and Items to a MessageAttaching a Business CardAttaching a CalendarUsing Themes and Email StationeryAdding a SignatureSending MailRecalling a MessageWorking with Received EmailOrganizing Messages in the InboxShowing Messages as ConversationsFiltering EmailManaging EmailUsing Quick StepsAnswering a MessageForwarding a MessageSaving an AttachmentDeleting MessagesPrinting MailMoving EmailManaging Email AccountsEditing Email Account SettingsAdding an Email AccountAdding an Outlook.com Mail AccountSetting Outlook Mail Options
24. Using the Calendar for Appointments and Tasks
Navigating the CalendarChanging the Calendar ViewChange the Time Scale and Time ZoneScheduling an AppointmentScheduling a Recurring AppointmentScheduling an EventEditing and Managing AppointmentsSearching the CalendarSharing CalendarsCreating a Calendar Share InvitationOpening a Shared CalendarViewing Multiple CalendarsEmailing a CalendarPublishing a Calendar OnlineSetting Calendar OptionsWorking with TasksUsing the Task FolderCreating a New Task from the Task FolderCreating a Recurring TaskAssigning and Accepting TasksViewing and Managing TasksManaging TasksSetting Tasks Options
25. Working with Contacts and Planning Meetings
Navigating the Contacts ListCreating a New ContactEntering Contact DetailsAdding Fields for a ContactEditing Contact InformationEditing a Business CardTagging Contacts with Flags and CategoriesMapping a Contact’s AddressSearching the Contacts FolderOrganizing Contacts with GroupsForwarding and Sharing ContactsForwarding ContactsSharing ContactsAccessing Contacts on Social NetworksCommunicating with ContactsContact ActionsPrinting Contact InformationSetting Contact OptionsScheduling MeetingsSelecting the Meeting LocationUsing the Scheduling AssistantViewing and Editing Meeting InformationResponding to Meeting Requests
26. Using the Journal and Notes
Using the Outlook JournalCreating a New Journal EntryUsing the Journal TimerAdding Tags and Names to a Journal EntryAdding Outlook Items and Inserting FilesJournal ActionsViewing the JournalManipulating the Journal ViewUsing Search to Filter Journal EntriesWorking with NotesViewing and Managing NotesCreating Appointments and Tasks from Notes
27. Securing and Maintaining Outlook
Security OverviewMalware and Antivirus SoftwareStrong Password ProtectionConfiguring Outlook Security SettingsEncrypting Email and Using Digital SignaturesOptions for Encrypting EmailDigitally Signing EmailsThe Perils of HTML EmailDealing with Message AttachmentsCoping with Junk EmailWorking with the Junk Email CommandsSetting Junk Email OptionsCreating Email RulesCreating a Quick Rule for a Specific SenderCreating Complex RulesThe Rule WizardManaging RulesArchiving Outlook ItemsConfiguring AutoArchive SettingsSetting AutoArchive Options for a FolderArchiving ManuallyConfiguring an Autoreply Message
VI: Publisher
28. Requisite Publisher: Essential Features
Introducing Publisher 2016Planning Your PublicationWorking with Publication TemplatesCreating a New PublicationUsing a TemplateUsing Blank SizesCreating a New TemplateNavigating the Publisher WorkspaceUsing the Rulers and GuidesOptions for Viewing the PublicationCreating a Business Information SetCreating a New Business Information SetCreating Additional Business Information SetsWorking with TextEditing Text in a Text BoxCreating Your Own Text BoxesFormatting Text BoxesLinking Text BoxesInserting a Text FileInserting IllustrationsOptions for Inserting PicturesFormatting a PictureInserting Clip ArtInserting ShapesUsing Building BlocksPrinting Publications
29. Advanced Publisher Features
Adding Pages to a PublicationConfiguring Page SettingsChanging the Current TemplateWorking with Master PagesPlacing Objects on the Master PageInserting Headers and FootersCreating Master PagesUsing Tables in PublicationsTable Design CommandsTable Layout CommandsManipulating Publication ObjectsGrouping ObjectsLayering ObjectsSwapping ImagesMerging Data into a PublicationPerforming a Mail MergePerforming a Catalog MergeFine-tuning Your PublicationsThe Spelling FeatureHyphenationDesign Checker
VII: OneNote
30. Requisite OneNote: Essential Features
Introducing OneNoteHow OneNote Notebooks Are OrganizedNavigating the OneNote WorkspaceThe OneNote RibbonThe Notebook PaneCreating a NotebookModifying Notebook PropertiesSharing a NotebookViewing the Sync StatusWorking with SectionsCreating or Deleting a SectionModifying SectionsMerging a SectionCreating a Section GroupWorking with PagesCreating Pages Using TemplatesCreating SubpagesRestoring Sections and Pages from the Notebook Recycle BinInserting and Formatting NotesUsing TagsFinding Tagged NotesUsing Tables to Store Information
31. Working with Notebook Pages
Managing PagesUsing the Move or Copy Pages Dialog BoxMaking More Space Available on a PageModifying the Page Setup and ViewViewing Page VersionsViewing Recent EditsViewing Changes by AuthorAdding Objects to Notebook PagesAdding PicturesRecording AudioRecording VideoAdding Drawings to OneNote PagesPrinting Notebook Pages
32. Integrating OneNote with Other Office Applications
Taking Linked NotesUsing File PrintoutAdding LinksAttaching FilesInserting Screen ClipsIntegrating OneNote and OutlookAdding Outlook TasksEmailing a Notebook PageInserting Meeting Details
VIII: Appendix
A. Office Application Integration
Sharing Application DataUnderstanding Object Linking and EmbeddingChoosing Between Linking and EmbeddingLinking ObjectsLinking with Paste SpecialLinking with the Paste Options GalleryLinking Using the Object CommandUpdating and Breaking LinksEditing Linked ObjectsEmbedding ObjectsEmbedding with Paste SpecialEmbedding Using the Object CommandEmbedding New ObjectsEditing Embedded ObjectsSharing Data with Outlook Using Actions
B. Office Macros
Macros and Office 2016Adding the Developer Tab to the RibbonEnabling Macros in the Trust CenterCreating Macro-Enabled Office FilesUnderstanding MacrosCreating a MacroRecording a MacroAssigning a Macro Button to the Quick Access ToolbarRunning MacrosEditing Recorded MacrosExploring the VBA EditorStepping Through a MacroDigitally Signing Macros
Index
Code Snippets

Content preview from Office 2016 In Depth

Code Snippets

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: 9780134273761Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Office 2016 In Depth

by Joe Habraken

Code Snippets

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.