JD SartainPCWorld

J.D. Sartain is a freelance journalist from Boston.

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.

microsoft word logo primary

Word newsletter tutorial: Using page layout features for professional results

Word makes it easy to create a newsletter using the Page Layout tools. Make columns and multipage layouts, add images and more. Here's how.

microsoft powerpoint logo resized

Use PowerPoint Photo Album to chronicle corporate or personal events

PowerPoint 's Photo Albums feature makes creating a slideshow super-easy, with intuitive menus and dialog screens.

microsoft excel logo primary

Excel logical formulas: 8 simple IF statements to get started

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.

word primary 100025314 large

How to make Word custom bullet points to enhance your documents

Word's built-in bullet points can give boring reports a bit of bling, but you can do even more by creating custom bullets from an image file. Here's how.

word primary 100025314 large

Why extracting images from Word is so hard, with 3 decent workarounds

Extracting images from Word is not a simple cut-and-paste proposition. We explain why it's so hard and show you the pros and cons of the workarounds.

microsoft excel logo primary

Meet DATEDIF(), Excel’s secret Date & Time function that's still handy

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it. Here's how.

microsoft excel logo primary

Excel Date and Time functions: WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

microsoft powerpoint logo primary

PowerPoint tips from Duarte's Five Rules Presentation

Duarte's Five Rules is a classic PowerPoint presentation that can make you an instant expert. Study the slides and read these tips to learn more.

microsoft excel logo primary

Excel Date & Time functions tutorial: EDATE, YEARFRAC, EOMONTH, NETWORKDAYS.INTL

We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more.

microsoft powerpoint logo primary

How to create Motion Paths in PowerPoint

Building motion into PowerPoint slideshows makes them come alive like no static images could ever hope to do. Here's our step-by-step guide through all the features and options.

microsoft excel logo primary

Excel tips: 6 slick shortcuts, handy functions and random-number generators

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.

microsoft excel logo primary

Mastering Excel Date & Time: Date, Days, Days360, Time, and Weekday

Excel's Date & Time functions help you calculate a day's serial number, move to a 360-day accounting calendar, and more. We cover Date, Days, Days360, Time, and Weekday

microsoft excel logo primary

Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more

All businesses need to calculate dates and times for payroll, expenses, inventory and more. We show how Excel turns dates into serial numbers for easier calculations, and we discuss Networkdays, Datevalue, and Excel for Mac's 1904 calendar

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.