Don't-Miss Productivity Software Stories

microsoft excel logo primary

Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more

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

microsoft excel logo primary

Excel formula tips: How to troubleshoot by tracing dependents and precedents

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.

microsoft excel logo primary

Excel power tips: 3 handy ways to tame hyperlinks

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.

word primary 100025314 large

Word pro tips: Use Wildcards for faster, more accurate search-and-replace results

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.

thinkstockphotos 519092565

How to get special characters using Alt key codes or the Word Symbols library

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.

microsoft excel logo primary

How Excel counts business days, holidays and more

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.

microsoft excel logo primary

Excel pro tips: How to create, define, and use Named Ranges

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.

microsoft excel logo primary

Excel 2016 charts: How to use the new Pareto, Histogram, and Waterfall formats

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.

google drive logo

3 tips and tools for saving web content to Google Drive

With a little ingenuity, Drive can be a repository for all the articles, images, and other content you find online.

microsoft excel logo primary

Use INDEX and MATCH for simple database queries in Excel

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.

thinkstockphotos 482101323

3 note-taking app alternatives to Evernote and OneNote

Simplenote, Google Keep, and Apple Notes are simple apps that offer more productivity power than you'd think.

microsoft onenote logo primary

Onetastic add-in for OneNote puts your notes in a calendar

Onetastic's OneCalendar is a great way to view your notes organized by date.

microsoft excel logo primary

What to do with Excel 2016's new chart styles: Treemap, Sunburst, and Box & Whisker

Excel 2016 gives you six new chart styles. The three we explore here make it easier to compare data and show hierarchies and other relationships.

officelogo

How to turn Google Chrome into a Microsoft Office-loving browser

A Chrome extension from Microsoft makes life easier for Office Online users.

evernote searches primary

Manage your time, tasks, and life goals with these Evernote apps

These three third-party apps leverage the power of Evernote to organize all facets of your busy life.