Q. Do I need to create a separate SharePoint area for each team? Or can I have one SharePoint site grant access to each area?
Q. Is document co-authoring enabled by default?
Q. Can you limit who is able to restore during versioning?
Say Yes to Archive! When the Archive prompt comes up, just say Yes! You probably don’t realize it, but when Outlook archives an email, it just goes to a separate file structure which is still accessible from the Navigation Pane. This process keeps your Inbox and regular folders clean, neat and current, while still allowing you to easily access your older ones.
In Excel, when you have a 0-first digit zip code, it usually shows up as only the last four digits. So, take a Massachusetts zip code like 02201. If you just type that into an Excel cell it comes up 2201. You could type an apostrophe in front of it, but then it would appear left justified like all other text. There are several alternatives.
Q. How do I make a 0 show up as a blank on the screen, but still have the value 0 in the cell? I need the zero for other formulas.
Here is the problem … You are trying to filter using multiple AND and OR criteria in Microsoft Excel or one or more columns in your list have more than 10,000 unique items (think employee numbers, serial numbers, transactions).
Especially effective for videos you create from your PowerPoint presentations, rolling titles are easy to add with a little bit of know-how.
Q. I want to show 3 different types of filtering on the same worksheet, depending upon who’s using it. Can I do that?
The answers to two questions offer tips on making sure your slides don’t become eyesores.