JD Sartaintech journalist, PCWorld
JD Sartain is a technology journalist from Boston. She writes for PCWorld, Network World, CIO, & several other tech magazines.
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.
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.
Articles by JD Sartain
Older stories