JD Sartaintech journalist, PCWorld
JD Sartain is a technology journalist from Boston. She writes for PCWorld, Network World, CIO, & several other tech magazines.
How to create and share custom Style Sheets in Word and PowerPoint
Make your Microsoft Word and PowerPoint documents stand out by creating your own one-click formatting with Style Sheets (formerly known as style sets).
5 ways to manage emails and control spam in Outlook
Blocking senders, setting rules, and other ways to keep the email pile safe as well as sane.
Excel: How to create simple and dependent drop-down lists
Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.
Microsoft Word: How to open or import other file formats
Microsoft Word can accommodate a surprising number of file formats, and even take in Excel and PowerPoint data, though it might look funny. Here's how.
How to use, modify, and create templates in Word
Word templates provide the design consistency that any organization (or individual) needs to look professional. Here's how to use pre-made templates or create your own.
How to use fonts in Word, Excel, Powerpoint, and more
How to locate, download, install, & manage your fonts in Microsoft Office (including Word, PowerPoint, Excel, Outlook, etc.)
Create Excel reports from multiple spreadsheets with Multi-file Pivot Tables
The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.
Excel filters: How to use number, text and date filters to extract only the data you need
Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.
How to create custom Input & Error Messages In Excel
In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Here's how to set them up in a spreadsheet.
How to customize Excel Conditional Formatting
Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.
Photoshop Text Effects: Adding Styles to fonts
Photoshop Text Effects, also called Styles, are an essential skill for adding splashes of color, texture and more to fonts on a page. Here's how to do it.
Excel percentage formulas: Percentage of total, percent increase or decrease, sales tax and more
Excel percentage formulas can get you through problems large and small every day. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase, or decrease.
Excel Pivot Tables: How to create better reports
The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables
Excel functions: 7 ways to use Text functions to manage data
How to replace words; extract first and last words, matched or a specific words in a string of text
How to use Word to create holiday cards and other projects
Use Microsoft Word to design your holiday cards or other graphic projects for your celebrations. We'll show you how Shapes, Fonts, and
Articles by JD Sartain
Older stories