Microsoft Office

How to Combine Data from Multiple Sources in Microsoft Excel 2016

• Oct 16, 2015
• This chapter from Microsoft Excel 2016 Step by Step guides you through procedures related to using a workbook as a template for other workbooks, linking to data in other workbooks, and consolidating multiple sets of data into a single workbook.

Provision SharePoint Online Site Collections

• Sep 5, 2015
• Understanding how to configure and manage SharePoint Online site collections is critical for an Office 365 administrator. This chapter from Exam Ref 70-347 Enabling Office 365 Services covers how to configure external user sharing, create SharePoint site collection, and plan a collaboration solution.

How to Store and Retrieve Data in Microsoft Excel for the iPad

• Feb 6, 2015
• Excel provides a practical yet powerful way to store massive amounts of data. This chapter from Microsoft Office for iPad Step by Step guides you through procedures related to creating workbooks and worksheets, managing worksheets and worksheet elements, populating worksheets with text or numeric data, modifying worksheet structure, and formatting data for presentation. It also includes procedures for efficiently displaying, filtering, and sorting data to provide specific information and perspectives.

How to Use OneNote to Store Information in Digital Notebooks on Your iPad

• Feb 6, 2015
• This chapter from Microsoft Office for iPad Step by Step guides you through procedures related to creating and opening notebooks, adding sections to notebooks, adding pages to sections, adding content to pages, managing notebook content, and closing notebooks in OneNote.

Creating Charts and Graphics in Microsoft Excel 2013

• Mar 31, 2014
• In this chapter from Microsoft Excel 2013 Step By Step, you’ll create a chart and customize its elements, find trends in your data, create a dual-axis chart, summarize data by using sparklines, create diagrams by using SmartArt, and create shapes that contain mathematical equations.

Using SharePoint 2013 with Excel and Access

• Aug 15, 2013
• This chapter from Microsoft SharePoint 2013 Step by Step focuses on the integration of SharePoint 2013 with Microsoft Office Excel 2013 and Microsoft Office Access 2013.

Designing and Using Custom Forms in Microsoft Outlook 2013

• Jul 15, 2013
• This chapter from Microsoft Outlook 2013 shows how you can extend the functionality of Outlook 2013 through custom design and programming.

Analyzing Data with Tables and Charts in Microsoft Excel 2013

• Jun 15, 2013
• In this chapter from Microsoft Office Inside Out: 2013 Edition, learn the many options you have for entering, storing, sorting, filtering, cross-tabulating, and summarizing data.

Adding Structure to Your Diagrams in Microsoft Visio 2013

• May 15, 2013
• In this chapter from Microsoft Visio 2013 Step By Step, you will experiment with and learn the value of containers, lists, and callouts in Visio diagrams.

Assigning and Managing Resources in Microsoft® Project 2013

• May 15, 2013
• Ben Howard, author of Microsoft® Project 2013 Plain & Simple, explains how to assign and manage resources in Microsoft Project 2013.

Understanding Access 2013 Databases

• May 15, 2013
• Learn how to work with Microsoft Access 2013 in this chapter from Microsoft Office Professional 2013 Step by Step, including creating a desktop database, importing and exporting data, navigating the user interface, working with data in a datasheet, configuring Access options, linking Access to external data, and compacting, repairing, and encrypting a database.

Using Lync as Your Phone

• May 15, 2013
• Learn how to set up the basic environment for your Lync phone, including adding or editing additional telephone numbers, setting your primary audio device, setting a secondary ringer, checking primary audio device call quality, and setting ringtones and sounds.

Working with Notebooks, Sections, and Pages in Microsoft OneNote Home and Student 2013

• May 15, 2013
• In this chapter from Microsoft Office Home and Student 2013 Step by Step, learn how to work with notebooks, sections, and pages in Microsoft OneNote Home and Student 2013.

Collaborating and Finishing Your Presentation in Microsoft PowerPoint 2013

• Apr 15, 2013
• Katherine Murray discusses the collaboration tools and Presenter View available in Microsoft PowerPoint 2013 in this chapter from Microsoft Office Professional 2013 for Touch Devices Plain & Simple.

Taking Notes to Another Level with Microsoft OneNote 2013

• Apr 15, 2013
• You can do all sorts of things with Microsoft OneNote 2013. In this chapter from Microsoft OneNote 2013 Plain & Simple, learn how to work with handwritten notes, create an outline, insert pictures, take screen clips, and work with audio and video notes.

Using Formulas and Functions in Microsoft Excel 2013

• Apr 15, 2013
• This chapter from Microsoft Excel 2013 Plain & Simple shows you how to work with formulas and functions in Microsoft Excel 2013.

Adjusting Slide Appearance in Microsoft PowerPoint 2013

• Mar 15, 2013
• For Microsoft PowerPoint 2013, you now have several built-in design elements that you can use for your presentations. These design elements, including slide layouts, themes, theme colors, and theme fonts, offer an inherent consistency that comes as a result of a common look and feel. This consistency means that you don’t have to be a graphic designer to prepare an attractive presentation.

Mailing Paper or Pixels with Microsoft Word 2013

• Mar 15, 2013
• In this chapter from Microsoft Word 2013 Plain & Simple, learn how to print envelopes, create mailing labels and business cards, send a document by email, and execute a mail merge.

Managing a Calendar in Microsoft Outlook 2013

• Mar 15, 2013
• In this chapter from Microsoft Outlook 2013 Plain & Simple, Jim Boyce explains everything you need to know about using the Calendar in Microsoft Outlook 2013.

Managing Contact Records in Microsoft Outlook 2013

• Mar 15, 2013
• In this chapter from Microsoft Outlook 2013 Step by Step, learn to organize the contact records into an individual address book, import a fresh set of contact records into a custom address book, and then export a subset of the records, create a contact group and send a message to a subset of the group, locate specific contact records by using the Search feature and the commands available on the new Search tool tab, and finally, personalize the content of an electronic business card.