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

Excel formula tips: How to troubleshoot by tracing dependents and precedents

In Excel, when you need to debug a complex web of formulas, you need to trace dependent and precedent formulas. Here's how they work.

microsoft excel logo primary

Excel: 5 timesaving power tips

There's no such thing as too fast in Excel. These power tips help with formulas, and filling and fixing spreadsheet data.

microsoft excel logo primary

Excel power tips: 3 handy ways to tame hyperlinks

Excel does its best to handle hyperlinks, even though they're ungainly in spreadsheets. Here are tricks you'll need to keep them under control.

word primary 100025314 large

Word pro tips: Use Wildcards for faster, more accurate search-and-replace results

Wildcards work in Word much like they do in Scrabble or Poker, representing whatever you need to find or change in a document. Here's how the basic wildcard features work and what you can do with them.

microsoft excel logo primary

Excel pro tips: Importing and parsing data

When data dumps into your spreadsheet and it's a big mess, you'll know what to do. Here's how to use text functions to join and separate data at will.

thinkstockphotos 519092565

How to get special characters using Alt key codes or the Word Symbols library

Alt key codes give you access to hundreds of special ASCII characters, from accent marks to tiny icons. We show you how to use the Alt codes and also Word's Symbol library.

microsoft excel logo primary

Excel pro tips: How to create, define, and use Named Ranges

Working with ranges in Excel can speed up your formulas and macros, or help you navigate through your spreadsheets. It’s also a more efficient way to manage processes within your worksheets. Here's how to set them up.

word primary 100025314 large

Word tutorial: Clean up a messy document's formats and styles using macros

You have a long, messy Word document, with a bunch of formats and styles that are just plain wrong. With Word macros, you can fix them all by recording each fix and running them as much as you need. We'll show you how.

microsoft excel logo primary

Excel 2016 charts: How to use the new Pareto, Histogram, and Waterfall formats

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

microsoft excel logo primary

Use INDEX and MATCH for simple database queries in Excel

The bigger your spreadsheet, the more you need INDEX and MATCH functions, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

word primary 100025314 large

Word master class: How to make custom interactive forms

Word uses the Developer tools to make forms and collect the data with ease. Here's how.

microsoft excel logo primary

What to do with Excel 2016's new chart styles: Treemap, Sunburst, and Box & Whisker

Excel 2016 gives you six new chart styles. The three we explore here make it easier to compare data and show hierarchies and other relationships.

microsoft powerpoint logo primary

Check out PowerPoint 2016's best new features: charts, effects and more

Give your slides a new bag of tricks with PowerPoint 2016's changes, which range from subtle to truly cool.

microsoft excel logo primary

Meet Excel 2016: 9 of its best new features, from databases to handwriting tools

Excel 2016 offers a compelling list of new features, from database enhancements to new charts and templates, even a tool for handwriting quations.

word primary 100025314 large

Word timesaving tips: Random text, quick definitions, formatting tricks and more

Make it easier to format and read long Microsoft Word documents (and shorter ones) with these tips.