- Getting Started with Office Sway
- Jan 7, 2016
- In this chapter from My Office Sway, you discover how to create a free Sway account, create and import Sways, and explore Sway navigation.
|
- Customizing a Pivot Table in Excel 2016
- Jan 5, 2016
- This chapter from Excel 2016 Pivot Table Data Crunching covers how you can use many powerful settings to tweak pivot tables. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table.
|
- The Next Step Beyond the Macro Recorder in VBA Programming
- Jan 5, 2016
- Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, co-author of Excel 2016 VBA and Macros, provides 10 macro recorder tips that will take your VBA programming skills up a level or two.
|
- Working with Notebooks in OneNote 2016
- Jan 1, 2016
- This chapter from My OneNote 2016 explains how notebooks work in OneNote, including how to start new notebooks as well as remove old notebooks you no longer use.
|
- Working with Pictures in PowerPoint 2016
- Dec 31, 2015
- In this chapter from My PowerPoint 2016, learn how to insert and format pictures in PowerPoint 2016. Specific topics in this chapter include inserting pictures, cropping and resizing pictures, formatting pictures, compressing pictures, and creating a photo album.
|
- Working with Fields and Forms in Word 2016
- Dec 22, 2015
- This chapter from Word 2016 In Depth delves into the technical nitty-gritty details that govern fields and shows you how you can select, insert, modify, and format fields to accomplish a variety of document-creation and formatting tasks. Even if you don’t end up working manually with fields very often, this is not wasted study! The more you understand about how fields really work, the better you will be able to troubleshoot problems that may occur, or to tweak an individual field’s options to fit an unusual formatting need.
|
- Adding Pictures and Graphics in Publisher 2016
- Dec 11, 2015
- In this chapter from My Publisher 2016, you learn how to add and work with visual elements such as photos, WordArt, borders, and accents.
|
- Excel 2016 VBA and Macros: Referring to Ranges
- Dec 11, 2015
- This chapter from Excel 2016 VBA and Macros shows you different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.
|
- Customizing Excel 2016
- Dec 9, 2015
- This chapter from Excel 2016 In Depth walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.
|
- Working with Text in a Microsoft Office Application
- Dec 2, 2015
- This chapter from Easy Office 2016 shows you how to add text to any Office application, including the option to select a font style and size; change text color; or apply bold, italic, and underlining to your text.
|
- Sorting Data in Microsoft Excel 2016
- Nov 30, 2015
- You’ll often need to sort your data in Excel, whether it be numerically, alphabetically, by color, or by icon. In this chapter from My Excel 2016, you’ll learn the various ways of sorting data, allowing you to view data from least to greatest, greatest to least, and even by color.
|
- Managing and Sharing Office Files
- Nov 24, 2015
- In this chapter from Office 2016 In Depth, you'll learn about the Office file formats used in each of the Office applications. You'll also learn your options for managing and sharing files.
|
- Customizing the Office 2016 Applications
- Nov 23, 2015
- In this chapter from My Office 2016, you learn about customizing the Office 2016 applications, including working with the application options and customizing the interface.
|
- Building Basic Formulas in Excel 2016
- Nov 11, 2015
- This chapter from Excel 2016 Formulas and Functions takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.
|
- Predictive Analytics with Microsoft Excel: Working with Seasonal Time Series
- Oct 1, 2015
- This chapter from More Predictive Analytics: Microsoft Excel takes a look at how to decompose a time series so that you can see how its seasonality operates apart from its trend (if any).
|
- Getting Started with Google Apps
- Jul 1, 2015
- Gmail, Calendar, Drive, Docs, Sheets, Slides, Hangouts, Sites, Vault and more make up the Google Apps universe. In this chapter from My Google Apps, 2nd Edition, the authors tell you what the apps are and what they can do for you. After you’ve decided Google Apps is right for you, signing up is easy and fast.
|
- Importing Your Photos Using Photos for Mac
- Jun 15, 2015
- This chapter from My Photos for Mac explains the ways you can import your pictures from various devices, including your digital camera; an iPhone, iPod touch, and iPad; and folders on your computer.
|
- Understanding Themes in Microsoft Office (At Last!)
- Jun 11, 2015
- Faithe Wempen, author of Word 2013 In Depth, shows you how to crack open the mystery of the Themes feature in Office and use themes to apply consistent color, font, and graphic effect formatting across documents and applications.
|
- Desktop Publishing with Word Text Boxes
- Jun 10, 2015
- Desktop publishing software uses movable frames to give you precise control over a layout, but did you know that Microsoft Word can do basically the same thing? Faithe Wempen, author of Word 2013 In Depth, shows you how to use Word’s Text Box feature to create simple DTP layouts.
|
- Research Paper Citations Made Easy with Microsoft Word
- Jun 2, 2015
- Do you panic when you hear the words “research paper”? Faithe Wempen, author of Word 2013 In Depth, explains how Microsoft Word’s Citations feature makes it easy to create correctly formatted bibliographic entries in whatever format you need.
|