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 use audio and video files in PowerPoint
PowerPoint supports a number of common audio and video formats. We'll go through the details and show you how to incorporate audio and video files into your presentation slides.
How to create, edit, and format images in Excel
Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of special effects.
PowerPoint animation tips & advice
Almost any PowerPoint presentation would benefit from clever animation, and the Internet has an endless supply of animated templates
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.
Excel creates most commonly used barcodes, either from free installed fonts, or add-ins for a price. Here's how.
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 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.
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.
How to add music to your PowerPoint presentations
Play background music across all the slides
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
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.
Can PowerPoint speak aloud & read the text in my slideshows?
Yes, with the Speak command (aka Text to Speech feature)
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.
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.
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.
Articles by JD Sartain
Older stories