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.
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.
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.
Articles by JD SartainNext Page