There are many good reasons to reverse engineer an Excel workbook. Let’s take a look at how to decode the structure of a workbook. Then, we’ll see how to demystify tricky formulas. Finally, we’ll take a peek at how to reveal workbook linkage to other workbooks.
Q. What is the best way to let people know about an update to a list or library?
Is there a better way to make comments in reply email text other than different font colors?
When I send documents to people, they turn track changes off. What can I do to prevent this? Since Word can edit pdfs now, what can I do to prevent changes to my Word doc when I send it to someone?
Duplicate data in Excel can throw a monkey wrench into your information processing works. Here are three solutions for handling it.
Trying to collaborate in email is always a challenge. However, if you have Outlook, you can make your comments stand out using an option on, of all things, Stationery.
Permissions can become confusing in SharePoint. A few basic principles help clear the mist a little. The more complex you allow your permissions structure to become, the less secure and, ultimately, the bigger nightmare it is to administer.
One of the exercises to do while preparing for a SharePoint rollout is to think about how it can be used to answer questions that would otherwise fill up email or voice mail. A well-built company-facing team site should be a reliable resource for frequently asked questions. With a few tweaks, the Issues List app (or list template in 2010) can serve two functions: a place to record open issues or questions, and, when answered, an FAQ.
Word Online is a perfectly acceptable tool for run-of-the-mill document editing. Some tools are unavailable in the Online version, while others are either different or limited. Here’s an overview of what works where.
Q. OneNote on my iPad and iPhone doesn’t look the same as it does on my PC. How can I get the same tools on my iPad as I have on my PC?