Browse by Tags

Related Posts
  • Blog Post: Publish your Access database to SharePoint

    If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services. If you don't already have a database, you can quickly create one from a template. In Access 2010...
  • Blog Post: Restrict data entry in Excel with lists

    I recently shared how you can restrict data input in Excel to certain number ranges , such as whole number percentages. But what if you're dealing with a strict set of values, like product names, and you don't want users to be able to create any new variations when entering data? That's easy to do too...
  • Blog Post: Compare and merge slides in PowerPoint 2010

    One of the little trumpeted but extremely valuable features in PowerPoint 2010 is the ability to compare and merge slides from separate decks. To use this feature, first open your main presentation file and go to the Review tab. Click the Compare button: Select the file you wish to compare it with and...
  • Blog Post: Restrict style changes in Word

    If you want to limit the use of styles and themes in a Word document that you and your teammates are collaborating on, there's a tucked away feature that does just that - and it works in both Word 2007 and Word 2010. First, click the tiny launcher button below the Change Styles button on your Home tab...
  • Blog Post: Office 365 public beta is now available

    The cloud-based version of Microsoft Office and related services, called Office 365, is now in public beta. This means you can sign up to try the subscription service, which offers your favorite Office applications plus SharePoint, Exchange, and Lync services via the Web using most devices. This delivers...
  • Blog Post: Restrict data input in Excel

    We all enter bad data into Excel from time to time. Maybe you're rushing, or someone distracts you, or you've just been doing it too long without a break. And when you open a document up to colleagues to help maintain, your data is only as good as their level of training and attention to detail. Fortunately...
  • Blog Post: Save time when reviewing tracked changes in Word

    If you review and Accept / Reject changes regularly, here's a quick tip to add some time back to your week and reduce wear and tear on your clicking finger. Don't accept any changes as you read through the feedback from your stakeholders, just reject the ones you don't want. Then click the arrow under...
  • Blog Post: Outlook Rules That Rule - Forward mails based on keywords

    I keep a lookout for useful Outlook rules (and anything else that keeps my Inbox manageable) and recently stumbled across a great, practical one. If you receive mails from customers or other sources that require a response or action and have team members who are subject matter experts to help you deal...
  • Blog Post: Use OneNote to collaborate on PowerPoint presentations

    If you're working on a team PowerPoint presentation, you could just use the built-in comments feature. But coupling PowerPoint with OneNote adds the ability to quickly notate and even draw on slides with your collaborators! The quickest way to do this is to use the Print feature in either PowerPoint...
  • Blog Post: Word to the wise: Using the Insert Comment feature in Word

    Today, we have a guest blogger. Elyssa is an editor and project manager at Brainstorm, a leading provider of online and onsite software training and one of our partners that provides customized content for your Productivity Hub. ---- For my job, I review other people's written work quite a bit, making...
  • Blog Post: Use Smart Tags to collaborate with colleagues - right from your documents

    I am sitting in training where I just learned the coolest thing. Our Unified Communications product manager just showed us how we can see presence information within our Office documents. This is useful if you ever need to collaborate on a document – say a proposal, presentation, business strategy, budget...
  • Blog Post: Create a Calendar Group in Outlook 2010

    If your team always seems to be out-of-sync, create a Calendar Group to quickly pull up everyone's schedule in one view. First, go to Calendar in Outlook 2010, click Calendar Groups , and Create New Calendar Group : Give it a name and then select all of the people you want to add from the address book...
  • Blog Post: Make large slide decks more manageable in PowerPoint 2010

    If you're a power user of PowerPoint, you've no doubt run into some of these scenarios: Collaborating on a slide presentation with one or more colleagues Creating a master deck to generate smaller presentation decks customized for specific audiences Moving slides around to different sections, organized...
  • Blog Post: Review changes by author in OneNote 2010

    If you work in shared notebooks, it can be helpful to see what changes have been made by your collaborators. If it's not enabled, go to the Share menu in OneNote 2010 and turn off Hide Authors : This will reveal vertical lines with initials next to any changes that have been made since you last reviewed...
  • Blog Post: Mark finished documents as final in Office 2010

    Locking down Office documents isn't new, but Office 2010 offers a quicker, more informal method to discourage editing once a document is finished: You can mark it as final. This does away with the need to create and remember a password or set complicated permissions. It won't prevent editing or copying...
  • Blog Post: Collaborate with difficult people the Crabby way

    If you haven't read any Crabby Office Lady articles or posts, you really should. I’m going to be lazy today – the Lazy Office Lady – and invite you to read Crabby's excellent column on how to collaborate without ever having to see anyone. She covers Meeting Workspaces, Document Workspaces, Live Meeting...