JD Sartaintech journalist, PCWorld

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

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.

microsoft excel logo primary resized2

Excel Workbooks: Three-dimensional workbooks and other number-crunching powers

We'll dive deep into Excel workbooks in this guide, starting with the basics and diving straight into powerful three-dimensional workbooks.

microsoft excel logo primary resized2

Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions

Excel spreadsheets do so much. This guide starts with the basics and will add more Excel tips over time, so you'll always be in the know.

microsoft excel logo primary resized2

Microsoft Excel: Why your spreadsheet is so slow

When Microsoft Excel complains it "cannot complete this task with available resources," or it's "Out of memory," here's what to do.