JD Sartaintech journalist, PCWorld
JD Sartain is a technology journalist from Boston. She writes for PCWorld, Network World, CIO, & several other tech magazines.
How to create Excel macros and automate your spreadsheets
Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.
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.
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.
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.
How to edit PDFs in Microsoft Word
For light PDF users, everything you need is in a tool you use every day.
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.
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.
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.
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).
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.
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: 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.
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.
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.)
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.
Articles by JD Sartain
Older stories