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

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.

microsoft word logo primary

Word 2016: A guide to its desktop publishing tools

Better graphics, better features, more options

adobe photoshop logo resized

Photoshop fonts: Creating swashes, swirls and flourishes

Photoshop lets you make any font fancier with swashes, swirls and other flourishes. Here's how.

adobe photoshop logo resized

Photoshop fonts: Using Text Type and Text Editing to transform fonts

Adobe Photoshop's Text Type and Text Editing tools let you manipulate standard fonts for greater visual impact.

microsoft excel logo primary resized

How to use Microsoft Excel's Conditional Formatting

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

microsoft excel logo primary resized

Excel tutorial: How to import and parse complicated data

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

microsoft excel logo primary resized

Create custom email addresses & extract domain names from URLs

Use commands and formulas to make these tasks a breeze

microsoft excel logo primary resized

7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more

The bigger and uglier your Excel spreadsheet gets, the more you need these tips to handle the data with as little hassle as possible.

microsoft word logo primary

Word resume tips: Using style sheets, shapes and text boxes for a professional look

Updating your résumé means more than refreshing the information. We'll show you how to use style sheets, shapes, and text boxes to create a modern, professional layout.

microsoft excel logo primary

How Excel can help with metric and American Standard conversions

Excel can streamline your global activities if you set up functions to convert metric to American Standard, and dollars to euros.