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

Create Excel Alerts, then write a macro to email them

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

microsoft excel logo primary resized2

How Excel creates barcodes

Excel creates most commonly used barcodes, either from free installed fonts, or add-ins for a price. Here's how.

microsoft excel logo primary resized2

How to create, filter, and format tables in Excel

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

microsoft word logo primary resized

Microsoft Word reads to you: How to use the Speak and Read Aloud commands

Can Microsoft Word read to you? Yes, it can. The Speak feature was incorporated into Microsoft Office back in version 2003. Here's how it works.

microsoft word logo primary resized

How Word translates text between languages

Microsoft Word can translate a word, sentence, paragraph, or an entire document into 62 languages with a few clicks. Here's how.

pcw ppt primary

How to add music to your PowerPoint presentations

Play background music across all the slides

microsoft excel logo primary resized2

Can Excel convert currency? Using the EUROTOOL.XLAM Excel Add-in

Excel can convert currency given the right tools. Here's how to use the Excel Add-In called EUROTOOL.XLAM 

microsoft excel logo primary resized2

Can Excel show the column headers on every screen? How to freeze panes and split screens

Can Excel show the column headers on every screen? Yes: Here's how to freeze and unfreeze columns and rows.

pcw ppt primary

Can PowerPoint speak aloud & read the text in my slideshows?

Yes, with the Speak command (aka Text to Speech feature)

microsoft excel logo primary resized2

Can Excel track changes? How to add Track Changes to the Ribbon menu

Can Excel track changes? Yes, similarly to how Word does it. Here's how to add Track Changes to the Ribbon menu and use it with your spreadsheets.

microsoft excel logo primary resized2

Can Excel Sort by Color? How to Fill Color and use Sort & Filter's Custom Sort

Excel can sort by cell color, font color, cell icon, and values. Here's how.

microsoft excel logo primary resized2

Excel Stylesheets: Cell Styles and Smart Art, Drawing, Graphics, Picture and Chart Tools

You may have used Excel for years without delving into Styles (or stylesheets). We’re going to cover Cell Styles, and Smart Art, Drawing, Graphics, Picture, and Chart Tools.

microsoft excel logo primary resized2

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.

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.