JD Sartaintech journalist, PCWorld

JD Sartain is a technology journalist from Boston. She writes for PCWorld, Network World, CIO, & several other tech magazines.

microsoft word logo primary resized

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.

microsoft word logo primary resized

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.

wood block type

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

microsoft excel logo primary resized2

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.

microsoft excel logo primary resized2

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.

microsoft excel logo primary resized2

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.

microsoft excel logo primary resized2

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.

adobe photoshop logo resized

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.

percent signs thinkstockphotos 163196995

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.

microsoft excel logo primary resized2

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

microsoft excel logo primary resized2

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

microsoft word logo primary

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

microsoft excel logo primary resized2

Excel macros: Essential rules, tips and tricks

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

microsoft excel logo primary resized2

Excel databases: Creating relational tables

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

spreadsheet pie chart bar chart

Excel charts: Mastering pie charts, bar charts and more

Excel's chart features can turn your spreadsheets into compelling visual ideas. This guide covers the basics and the best tips.