Don't-Miss Productivity Software Stories
We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more.
Building motion into PowerPoint slideshows makes them come alive like no static images could ever hope to do. Here's our step-by-step guide through all the features and options.
You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.
Excel's Date & Time functions help you calculate a day's serial number, move to a 360-day accounting calendar, and more. We cover Date, Days, Days360, Time, and Weekday
All businesses need to calculate dates and times for payroll, expenses, inventory and more. We show how Excel turns dates into serial numbers for easier calculations, and we discuss Networkdays, Datevalue, and Excel for Mac's 1904 calendar
In Excel, when you need to debug a complex web of formulas, you need to trace dependent and precedent formulas. Here's how they work.
Excel does its best to handle hyperlinks, even though they're ungainly in spreadsheets. Here are tricks you'll need to keep them under control.
Wildcards work in Word much like they do in Scrabble or Poker, representing whatever you need to find or change in a document. Here's how the basic wildcard features work and what you can do with them.
Alt key codes give you access to hundreds of special ASCII characters, from accent marks to tiny icons. We show you how to use the Alt codes and also Word's Symbol library.
Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.
Working with ranges in Excel can speed up your formulas and macros, or help you navigate through your spreadsheets. It’s also a more efficient way to manage processes within your worksheets. Here's how to set them up.
Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.
With a little ingenuity, Drive can be a repository for all the articles, images, and other content you find online.
The bigger your spreadsheet, the more you need INDEX and MATCH functions, which you can combine with SUM, AVERAGE, and MAX to refine your searches.
Simplenote, Google Keep, and Apple Notes are simple apps that offer more productivity power than you'd think.