JD Sartaintech journalist, PCWorld

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

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.

microsoft excel logo primary

Excel Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR

Boolean logical operators in Excel formulas make searching easier, and you can apply the same methods in Internet or database searches.

microsoft powerpoint logo primary

Powerpoint background tips: How to customize the images, colors and borders

PowerPoint's built-in templates are convenient, but everyone knows what they look like, and you look unoriginal if that's all you use. Try these tips to make something unique that will help your presentation stand out.

adobe photoshop logo

Photoshop editing tips for portraits: How to make a snapshot look professional

Photoshop's editing tools can help you transform your snapshots into studio-like portraits. We'll show you how to use the Magic Wand, the Lasso, and other features to clean up images.

word primary 100025314 large

Word macros: Three examples to automate your documents

Use these step-by-instructions to turn complex procedures into one-click wonders.

microsoft excel logo primary

Bet you didn't know Excel could do: graph paper, address labels, award certificates

Excel does just as well as Word in creating and customizing these useful office supplies. Here's how.