
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.

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.
Articles by JD Sartain
Older stories