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.

Selecting Data Using Queries in Microsoft Access 2013

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

Analyzing Your Excel 2013 Data

• Feb 15, 2013
• Learn how you can use Excel to analyze and share the data you’re gathering. You can use features such as sparklines and conditional formatting to show in an instant how the data trends look, or you can construct formulas by using Excel’s functions to perform simple or complex calculations with your numeric data. Excel also makes it easy to report on and share your data via Power View Reports and PivotTables.

Cube Functions in Microsoft Excel 2010

• Dec 22, 2011
• This chapter from Microsoft Excel 2010 Formulas and Functions Inside Out covers cube functions in Microsoft Excel 2010.

How to Schedule Meetings So They Are Convenient, Effective, and Fun

• Sep 26, 2011
• This chapter from Effective Time Management: Using Microsoft Outlook to Organize Your Work and Personal Life gives you tips on how to quickly and effectively prepare meetings with Outlook and Microsoft SharePoint, and exchange data and documents for review as a team to save you and your colleagues precious time and achieve better results.

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).

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.

Administering Your Enterprise Project Management Solution in Microsoft Project 2010

• May 15, 2011
• This chapter from Microsoft Project 2010 Inside Out covers setup and administrative procedures performed by the project server administrator after the server equipment and software are in place, including the operating system, database, and client applications.

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.

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).

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.

Create Compelling SmartArt Diagrams and Charts in Microsoft Word 2010

• Oct 8, 2010
• In this chapter from Microsoft Word 2010, you learn about SmartArt, the diagramming tool that is included as part of Word 2010, and find out how to add and enhance charts in your Word document. What’s more, the charts you add interact easily with Excel 2010, so you can use simple worksheet sections or complex calculations as part of the charts you create.

Microsoft PowerPivot for Excel 2010: Date Calculations in DAX

• Oct 5, 2010
• In this chapter from Microsoft PowerPivot for Excel 2010: Give Your Data Meaning, learn how to create a Dates table for a PowerPivot model and how to use that table to support several types of calculations: number of working days, aggregation and comparison over time, and closing balance over time.

Inside OneNote 2010

• Sep 27, 2010
• OneNote really is a digital replacement for a traditional loose-leaf notebook in which you can save class notes, academic research, meeting minutes, or just about anything else you might be tempted to put on a piece of paper. In this chapter from Microsoft Office 2010 Inside Out, learn about the features and capabilities of OneNote 2010.

Analyzing Microsoft Excel 2010 Data with PivotTable Reports

• Aug 31, 2010
• This chapter from Microsoft Excel 2010 Inside Out introduces PivotTables in Excel 2010, explaining everything from their creation to formatting to grouping and charting.

How to Change Workbook Appearance in Microsoft Excel 2010

• Aug 25, 2010
• In this chapter from Microsoft Office Professional 2010 Step by Step, you'll learn how to change the appearance of data, apply existing formats to data, make numbers easier to read, change data's appearance based on its value, and add images to worksheets in Microsoft Excel 2010.

Automating a Client Application Using Macros in Microsoft Access 2010

• Aug 15, 2010
• With this chapter from Microsoft Access 2010 Inside Out, you'll learn about user interface macros — various types of actions you can define in macros, building both simple macros and macro with multiple defined actions, managing macros and creating submacros, using embedded and temporary macros, debugging macros, and understanding un-trusted actions.

Customizing and Securing Microsoft Word 2010

• Aug 15, 2010
• Katherine Murray discusses the customization and security features of Microsoft Word 2010, in this chapter from Microsoft Word 2010 Plain & Simple.

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.