Microsoft Office

Microsoft® Excel® 2013: Using Power View

• Mar 15, 2013
• In this chapter from Microsoft® Excel® 2013: Building Data Models with PowerPivot, you learn the capabilities of Power View. We are not going to explain all the features in great detail, at least partly because there are plenty of good books and resources where you can learn much more information about Power View. Our goal here is to introduce this new tool and show the most important information about the role it plays in graphical exploration.

Organize Information in Columns and Tables in Microsoft Word 2010

• Jun 2, 2010
• In this chapter from Microsoft Word 2010 Step by Step, you’ll first create and modify columns of text. Then you’ll create a simple tabbed list. Finally, you’ll create tables from scratch and from existing text, and format a table in various ways.

Organizing Your Contacts List in Microsoft Outlook for Mac 2011

• Apr 15, 2011
• This chapter from Microsoft Outlook for Mac 2011 Step by Step shows you how to view and sort contacts, assign categories, organize contacts with folders, search for contacts, and use smart folders.

PowerPivot for Excel and SharePoint

• Apr 14, 2011
• This chapter from Business Intelligence in Microsoft SharePoint 2010 briefly introduces you to PowerPivot for Excel and PowerPivot for SharePoint. It provides guidance on creating a PowerPivot workbook, importing data from various data sources, and mashing them up using DAX. This chapter also demonstrates how to publish a PowerPivot workbook to SharePoint and how to schedule data refreshes, and it explains how IT professionals can manage PowerPivot for SharePoint by using the PowerPivot Management Dashboard.

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.

Selecting Data Using Queries in Microsoft Access 2013

• Mar 15, 2013
• Andrew Couch shows you how to work with Queries in Microsoft Access 2013.

Setting Up Resources in Microsoft Project 2010

• Jun 2, 2010
• Microsoft Project 2010 supports three types of resources. These are work resources, as well as two special-purpose resources: cost and material. In this chapter from Microsoft Project 2010 Step by Step, you will set up work and cost resources.

Successful Project Management: Modifying the Project Schedule

• Mar 15, 2011
• This chapter from Successful Project Management: Applying Best Practices, Proven Methods, and Real-World Techniques with Microsoft Project reviews different alternatives for optimizing your project schedule and how they affect duration, cost, scope, and quality (and whether the people who work on your project ever get to go home).

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.

The OFFSET Function in Microsoft Excel 2010

• Jan 7, 2011
• This chapter from Microsoft Excel 2010 Data Analysis and Business Modeling explains how to use the OFFSET function in Microsoft Excel 2010.

Tracking and Referencing Documents in Microsoft Word 2010

• Aug 12, 2011
• In this chapter from MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, and SharePoint Exams, you'll learn the mechanics for creating different types of reference material for a document, including bibliographies, cross-references, indexes, and tables of authorities (which are used in legal documents).

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 Formulas and Functions

• Jun 15, 2010
• This chapter from Microsoft Excel 2010 Plain & Simple explains the use of formulas and functions in Excel, including creating, editing, and debugging.

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.

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.

Using RSS Feeds in Microsoft Outlook 2010

• Aug 15, 2010
• In this chapter from Microsoft Outlook 2010 Inside Out, learn how to use RSS feeds in Microsoft Outlook 2010, including configuring RSS, adding RSS Feeds to Outlook, using your RSS feeds, adding an OPML file to Outlook, managing Your RSS Feeds, setting RSS properties, and creating rules for RSS feeds.

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.

Working with Macros and Forms in Microsoft Excel 2010

• Aug 12, 2011
• This chapter from MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, and SharePoint Exams shows you how to work with macros and forms in Microsoft Excel.

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.

Working with Special Content in Word

• Jun 24, 2010
• This chapter from Microsoft Office 2010 Plain & Simple talks about cover letter templates, inserting equations, using text boxes to create sidebars and pull quotes, creating watermarks, and working with other special characters and content.