Quickly and efficiently learn the latest version of Office
Are you a visual learner who wants to spend more time working in Microsoft Office than trying to figure out how the programs actually work? Teach Yourself Visually Office offers you a straightforward, visual approach to making your work life more efficient and productive using the latest version of the Microsoft Office suite. Featuring visually rich tutorials and step-by-step instructions that will help you make the most of this power-packed suite of office productivity tools, it covers everything you need to compute, document, graph, chart, present, and organize your way to success in the workplace–from the most basic to the most advanced.
The Microsoft Office suite can be intimidating to the uninitiated, but it doesn’t have to be. Through a series of easy-to-follow, full-color two-page tutorials, you’ll quickly get up and running on working in Word, excelling at Excel, powering through PowerPoint, keeping in touch on Outlook, managing data in Access, and propelling your way through Publisher like a pro!
Highly visual tutorials and step-by-step screenshots make lessons easy to follow and understand Helps you grasp the basic functions of Microsoft Office–and beyond Walks you through Microsoft Office’s new features Demonstrates how to use the Microsoft Office suite to make your work life more streamlined and effective Whether you’re looking to discover what’s new in the latest release of Microsoft Office or don’t know Access from Word, this visual guide makes learning easy!
Title Page Copyright Page Table of Contents Part 1 Microsoft 365 Features Chapter 1 Microsoft 365 Basics Start and Exit Microsoft 365 Apps Explore the App Window Work with Backstage View Change the Color Scheme Search for a Ribbon Command Work with the Ribbon Customize the Quick Access Toolbar Using a Microsoft 365 App with a Touch Screen Chapter 2 Working with Files Create a New File Save a File Open a File Print a File Select Data Chapter 3 Microsoft 365 Graphics Tools Insert a Picture from Your PC Insert an Online Picture Resize and Move Graphic Objects Understanding Graphics Modification Techniques Chapter 4 Working with Microsoft 365 Files Online Microsoft 365 and the Cloud Sign In to Microsoft Share a Document from Microsoft Sign In to OneDrive Using an Online App in OneDrive Open a Document in a Desktop App from OneDrive Upload a Document to OneDrive Share a Document Using OneDrive Part 2 Word Chapter 5 Adding Text Change Word’s Views Type and Edit Text Insert Quick Parts Insert Symbols Chapter 6 Formatting Text Change the Font, Size, and Color Align Text Set Line Spacing Indent Text Set Tabs Set Margins Create Lists Copy Formatting Clear Formatting Format with Styles Using a Template Chapter 7 Adding Extra Touches Insert an Online Video Assign a Theme Add Borders Create Columns Insert a Table Apply Table Styles Insert Table Rows or Columns Add Headers and Footers Insert Footnotes and Endnotes Chapter 8 Reviewing Documents Work in Read Mode View Find and Replace Text Navigate Document Content Check Spelling and Grammar Customize AutoCorrect Using Word’s Thesaurus and Dictionary Translate Text Track and Review Document Changes Lock and Unlock Tracking Combine Reviewers’ Changes Work with Comments Part 3 Excel Chapter 9 Building Spreadsheets Enter Cell Data Select Cells Using AutoFill for Faster Data Entry Turn On Text Wrapping Center Data Across Columns Adjust Cell Alignment Change the Font and Size Change Number Formats Increase or Decrease Decimals Add Cell Borders and Shading Format Data with Styles Apply Conditional Formatting Insert Rows and Columns Resize Columns and Rows Freeze Column and Row Titles On‐Screen Name a Range Clear or Delete Cells Chapter 10 Worksheet Basics Add a Worksheet Rename a Worksheet Change Page Setup Options Move or Copy Worksheets Delete a Worksheet Find and Replace Data Create a Table Filter or Sort Table Information Analyze Data Quickly Understanding Data Analysis Choices Insert a Note Chapter 11 Working with Formulas and Functions Understanding Formulas Create a Formula Apply Absolute and Relative Cell References Understanding Functions Insert a Function Total Cells with AutoSum Chapter 12 Working with Charts Create a Chart Move and Resize Charts Change the Chart Type Change the Chart Style Change the Chart Layout Add Chart Elements Format Chart Elements Change the Chart Data Using Sparklines to View Data Trends Understanding PivotTables Create a PivotTable Create a PivotChart Insert a PivotTable Slicer Part 4 PowerPoint Chapter 13 Creating a Presentation Create a New Presentation Create a Photo Album Presentation Change PowerPoint Views Insert Slides Change the Slide Layout Change the Slide Size Chapter 14 Populating Presentation Slides Add and Edit Slide Text Change the Font, Size, and Color Apply a Theme Set Line Spacing Align Text Add a Text Box to a Slide Add a Table to a Slide Add a Chart to a Slide Add a Video Clip to a Slide Move a Slide Object Resize a Slide Object Chapter 15 Assembling and Presenting a Slideshow Reorganize Slides Reuse a Slide Organize Slides into Sections Define Slide Transitions Add Animation Effects Create a Custom Animation Record Narration Insert a Background Song Create Speaker Notes Rehearse a Slideshow Run a Slideshow Part 5 Access Chapter 16 Database Basics Understanding Database Basics Create a Database Based on a Template Create a Blank Database Create a New Table Change Table Views Add a Field to a Table Delete a Field from a Table Hide a Field in a Table Move a Field in a Table Create a Form Change Form Views Move a Field in a Form Delete a Field in a Form Format Form Fields Chapter 17 Adding, Finding, and Querying Data Add Records to a Table Add a Record Using a Form Navigate Records Using a Form Search for a Record Using a Form Delete a Record from a Table Delete a Record Using a Form Sort Records Filter Records Perform a Simple Query Create a Report Part 6 Outlook Chapter 18 Organizing with Outlook Navigate in Outlook Schedule an Appointment Create a New Contact Create a New Task Add a Note Customize the Navigation Bar Peek at Appointments and Tasks Chapter 19 E-mailing with Outlook Compose and Send a Message Send a File Attachment Read an Incoming Message Reply to or Forward a Message Add a Sender to Your Outlook Contacts Delete a Message Screen Junk E‐Mail Create a Message Rule Index EULA
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.