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.
There's no such thing as too fast in Excel. These power tips help with formulas, and filling and fixing spreadsheet data.
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.
When data dumps into your spreadsheet and it's a big mess, you'll know what to do. Here's how to use text functions to join and separate data at will.
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.
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.
You have a long, messy Word document, with a bunch of formats and styles that are just plain wrong. With Word macros, you can fix them all by recording each fix and running them as much as you need. We'll show you how.
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.
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.
Word uses the Developer tools to make forms and collect the data with ease. Here's how.
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.
Give your slides a new bag of tricks with PowerPoint 2016's changes, which range from subtle to truly cool.
Excel 2016 offers a compelling list of new features, from database enhancements to new charts and templates, even a tool for handwriting quations.
Make it easier to format and read long Microsoft Word documents (and shorter ones) with these tips.