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

Use Excel's DATE, WEEKDAY, IF, and IF/OR to make weekly schedules by task, event and team member

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.

microsoft excel logo primary resized2

How to export PDF files from Acrobat to Excel, and Excel to Acrobat

You have just a few choices when working with PDFs and Microsoft Excel. We'll show you how to export PDFs from Excel to Acrobat, and export from Acrobat to Excel.

microsoft powerpoint logo resized

How to export PDF files from Acrobat to PowerPoint, and PowerPoint to Acrobat

You have just a few choices when working with PDFs and Microsoft PowerPoint. We'll show you how to export PDFs from PowerPoint to Acrobat, and export from Acrobat to PowerPoint.

microsoft word logo primary resized

How to edit PDFs in Microsoft Word

For light PDF users, everything you need is in a tool you use every day.

microsoft excel logo primary resized2

Excel’s top 12 most popular formulas with examples

Excel has over 475 formulas in its Functions Library, but we've selected the 12 most popular to make sure you have them all, from date and time functions to mathematics and simple data manipulation.

microsoft word logo primary resized

How to create and use custom forms in Word

It’s a lot easier to create custom forms in Word than it used to be. This article covers six Content Controls, pre-programmed tools for adding and customizing interactive content in your Word forms, templates, documents, and web pages.

microsoft excel logo primary resized2

Excel Add-Ins: How to find and use them

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

microsoft word logo primary resized

How to create and share custom Style Sheets in Word and PowerPoint

Make your Microsoft Word and PowerPoint documents stand out by creating your own one-click formatting with Style Sheets (formerly known as style sets).

outlook logo

5 ways to manage emails and control spam in Outlook

Blocking senders, setting rules, and other ways to keep the email pile safe as well as sane.

microsoft excel logo primary resized2

Excel: How to create simple and dependent drop-down lists

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

microsoft word logo primary resized

Microsoft Word: How to open or import other file formats

Microsoft Word can accommodate a surprising number of file formats, and even take in Excel and PowerPoint data, though it might look funny. Here's how.

microsoft word logo primary resized

How to use, modify, and create templates in Word

Word templates provide the design consistency that any organization (or individual) needs to look professional. Here's how to use pre-made templates or create your own.

wood block type

How to use fonts in Word, Excel, Powerpoint, and more

How to locate, download, install, & manage your fonts in Microsoft Office (including Word, PowerPoint, Excel, Outlook, etc.)

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.