Home > Articles > Home & Office Computing > Microsoft Applications

Microsoft Applications

RSS Feed Subscribe to this topic  RSS details

205 Items

Sort by Date | Title

Getting Started with Office Sway
By Patrice-Anne Rutledge
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
By Bill Jelen, Michael Alexander
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
By Tracy Syrstad
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 Pictures in PowerPoint 2016
By Echo Swinford
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
By Faithe Wempen
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.
Excel 2016 VBA and Macros: Referring to Ranges
By Bill Jelen, Tracy Syrstad
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
By Bill Jelen
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
By Patrice-Anne Rutledge
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
By Tracy Syrstad
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
By Joe Habraken
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
By Paul McFedries
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
By Paul McFedries
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
By Conrad Carlberg
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).
Video: Predictive Analytics with Excel: Smoothing Constant and Exponentiation
By Conrad Carlberg
Jan 23, 2015
In this excerpt from Predictive Analytics with Excel LiveLessons (Video Training), Downloadable Video: Exponential Smoothing and Autoregression, Conrad Carlberg takes a look a exponential smoothing.
Introduction to Statistical Analysis: Microsoft Excel 2013
By Conrad Carlberg
May 26, 2014
Conrad Carlberg discusses the balance he chose between teaching statistics and Excel in the introduction to his book Statistical Analysis: Microsoft Excel 2013.
Statistical Analysis with Microsoft Excel 2013: About Variables and Values
By Conrad Carlberg
May 20, 2014
Conrad Carlberg explains how variables and values are at the heart of how you represent data in Excel — and how they have implications when performing statistical analysis using Excel.
Enhance Your Pictures in Word 2013
By Katherine Murray
Mar 19, 2014
Word 2013 makes it easy for you to add, edit, and enhance pictures in your document. Katherine Murphy shows you how to tweak your images so your illustrations really pop.
Creating and Sharing Notebooks in OneNote 2013
By Katherine Murray
Mar 10, 2014
OneNote 2013 is the note-taking and sharing utility included in Microsoft Office 2013. This article shows you how to create and share OneNote notebooks easily in the cloud so you and your teammates can capture those million dollar ideas wherever you might be in the world.
Components of Decision Analytics
By Conrad Carlberg
Jan 13, 2014
This chapter provides an overview of the techniques used to classify data according to existing categories and clusters.
Working with Shapes and SmartArt in Microsoft Office 2013
By Patrice-Anne Rutledge
Nov 11, 2013
This chapter shows how to insert, format, and work with basic shapes and, if you need something a little more complex, SmartArt.

Page 1 2 3 4 5 Next >