Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.
Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.
Use commands and formulas to make these tasks a breeze
The bigger and uglier your Excel spreadsheet gets, the more you need these tips to handle the data with as little hassle as possible.
Updating your résumé means more than refreshing the information. We'll show you how to use style sheets, shapes, and text boxes to create a modern, professional layout.
Excel can streamline your global activities if you set up functions to convert metric to American Standard, and dollars to euros.
Word makes it easy to create a newsletter using the Page Layout tools. Make columns and multipage layouts, add images and more. Here's how.
PowerPoint 's Photo Albums feature makes creating a slideshow super-easy, with intuitive menus and dialog screens.
This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.
Word's built-in bullet points can give boring reports a bit of bling, but you can do even more by creating custom bullets from an image file. Here's how.
Extracting images from Word is not a simple cut-and-paste proposition. We explain why it's so hard and show you the pros and cons of the workarounds.
DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it. Here's how.
Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.
Duarte's Five Rules is a classic PowerPoint presentation that can make you an instant expert. Study the slides and read these tips to learn more.
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.