Browse by Tags

Related Posts
  • Blog Post: Casual Friday: Use OneNote TripBooks to help plan your vacation

    The OneNote team invited 40 travel bloggers to create OneNote documents covering major travel destinations. You can preview them online via SkyDrive and then download local copies to customize in OneNote 2010. Download the free OneNote TripBooks and then make them your own by adding your specific vacation...
  • 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: Formula Watch - Convert numbers to and from Roman numerals

    Once you get past 20 or so, converting Roman numerals to Arabic (or vice versa) can be tricky. But you can save time and improve accuracy with a pair of Excel functions. To convert an Arabic number to its classic Roman numeral, use: =ROMAN(A1) Naturally, you can place a number directly into the parentheses...
  • Blog Post: Add impact to your Word documents with Text Effects

    Have you ever noticed that glowing button on your ribbon in Word 2010? It’s the gateway to a number of Text Effects that you can use to dress up your documents: Let’s say you’re making a flier for the company picnic. A nice bright sunny theme might brighten things up! Select a suitable style (like the...
  • 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: Add more social network connections to Outlook 2010

    Two more social networks have been released for Outlook 2010. You can now add Outlook Social Connector support for Facebook and Windows Live Messenger in addition to the LinkedIn and MySpace plug-ins that were released previously. Once you've entered your credentials for each service, you can quickly...
  • Blog Post: Print Excel table headers on every page

    If you're printing a long spreadsheet in Excel and want to have the same header row across the top of each page, you're in luck. There's a little-known feature tucked away in Excel 2007 and Excel 2010 to do just that. If you're using Excel 2007, go to File , Page Setup and then open the last tab. In...
  • Blog Post: Move paragraphs up and down quickly in Word

    The numbered sort technique is useful when you need to carefully plot the restructuring of a long, complex document. But what if you just want to quickly move a paragraph or two up or down? No problem. First select any paragraphs you want to move, hold down both the Shift and Alt keys and then tap either...
  • Blog Post: Link your PowerPoint presentations to improve flow

    You know that awkward pause during team presentations when one team member hands off to another, and there is much squabbling to bring up the correct presentation? That's because most people don't realize you can easily link slide decks to each other - as long as they're locked down at least a little...
  • Blog Post: Remove formatting, hyperlinks, and comments in Excel

    Clearing out cells of font mismatches, fill colors, hyperlinks, comments, and conditional formatting doesn't have to be tedious. There's a much easier way. First select the cells you want to clear. In Excel 2007, you need to go to the Edit menu and select the Clear command to access Clear Formats . In...
  • Blog Post: Correct mistakes using Print Preview Edit Mode in Word 2010

    If you find you spend a lot of time switching between editing and the default print preview in the Print pane, Word 2010 has a hidden Print Preview Edit Mode you should try. First, you'll need to add it to the Quick Access Toolbar so you can find it quickly when you need it. Click the down arrow next...
  • Blog Post: Make your Excel rows and columns consistent

    As you enter data into cells in your Excel worksheet, you may notice that your rows change height - which can lead to a sloppy presentation if you're sharing the data. Likewise, you may want to adjust your column widths to make them more consistent. There's a quick way to do this. Simply select and right...
  • Blog Post: Casual Friday: Make PowerPoint the life of the party

    Whether you're throwing a company party, wedding, shower, or birthday bash, PowerPoint can add life to the event. Fill a slide deck with photos culled from a year of work events or a lifetime of memorable activities and creatively arrange them in a slide deck. You can even add movies: Just go to the...
  • Blog Post: Formula Watch: Working with week numbers

    There are plenty of scenarios where you'd want to know the week number within a year. Say you are developing a schedule with a time budget, and you need to know how many hours you can commit per week over the course of a project or fiscal year. Or maybe you just want to know how many weeks are left until...
  • Blog Post: Get the new Outlook Hotmail Connector

    If you use the Outlook Hotmail Connector, you may have already been prompted to update to the new version: This version 14.2 update corrects a number of sync issues, improves performance, and turns off the junk mail filter in Outlook in favor or Hotmail's own filtering system. If you've made entries...
  • Blog Post: Casual Friday - Track World Cup soccer in Excel

    This week, I'm introducing a new occasional feature: Casual Friday. In it, I'll share uses for the Office applications that we've all put to such good use being productive at work to enrich our personal lives as well. I recently found just such a use over at the Microsoft Excel blog, where they've released...
  • Blog Post: Customize and backup your Office 2010 ribbons

    If you are a fan of the Office Ribbon, you have an unprecedented amount of control over it in Office 2010. If the default Ribbon doesn't offer up your favorite commands, you can simply create custom tabs and groups to easily access your favorite features. To ensure a base level of consistency, you cannot...
  • 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: Set your own default reminder alert time in Outlook

    If you're like me, you like to be prepared for your meetings. This can mean extra time for reviewing documents, brainstorming ideas, and printing handouts - not to mention travel time. If you're frequently late or unprepared for your appointments, simply change the default reminder. Go into File , Options...
  • Blog Post: Print just one page in Outlook 2010

    Have you ever wanted to print just the first page of an email message? Most of the time, right? You may not realize it, but there is a place to select this in Outlook 2010. Just go to File , Print (or press Ctrl-P) and then click Print Options : Directly below the Print style box, about halfway down...
  • Blog Post: Writing a good Out of Office message (and how to set it)

    When you're on vacation or holiday, it's wise to set an Out of Office message (abbreviated as OOF). Here are some tips to writing a good one: Provide the dates that you are unavailable. If it's only a partial day, provide the time you expect to be back on mail. Describe whether you will have limited...
  • Blog Post: Publisher Has Your Back

    Designing is a tricky business. One forgotten element—like half a logo hanging off the front page of my company newsletter—can be endlessly embarrassing, for me and my company. I’ve learned to double- and triple-check for problems before I distribute a file from Microsoft Office Publisher...
  • Blog Post: Save all open Word documents at once

    The Save All command used to be a hidden feature of Microsoft Word, unlocked by holding the Shift key while selecting the File menu. But this won't work in recent versions of Word. Fortunately, it's easy to add to your Quick Access Toolbar. Go to Word Options ( under the File menu in Word 2010 and the...
  • Blog Post: Changing case in Excel

    If you had to choose a program to use for changing case (UPPERCASE, lowercase, Sentence case, etc.) Microsoft Word works best in most cases. It has several options available, and the changes you make are retained if you copy and paste them. But Excel can be useful at this task too, if you understand...
  • Blog Post: Force recipients to Reply All in Outlook

    Have you ever sent a mail and asked that recipients use Reply All, only to have some people respond just to you? Then YOU have to forward the mail to the rest of the group. Thankfully, there is a way to force Outlook to send replies to a specific list of recipients regardless of whether they click Reply...