Office Technology

4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.
I’m not sure whether it was intentional, but there seems to be something missing from the Create Pivot Table dialog box in Excel 2007 and 2010.

Putting web pieces together

November 24, 2010 Categorized in: InternetOrganizing

Store scattered pieces of information in one place with these online tools: 1. Strategically store web content with Springpad. 2. Organize a batch of business cards. ScanBizCards, WorldCard Mobile or CamCard keep business cards from disappearing in a messy drawer.
Steer clear of “oversharing” when it comes to out-of-office messages sent to the rest of the office. For example: “I’ll be leaving the office at 4 p.m. today. I’m taking my daughter to the dentist. Please send any urgent requests to Pam.” Does the message really need to explain where the sender is going?

LinkedIn: 35 connections and counting

November 15, 2010 Categorized in: AdvancementInternet

With its workaday reputation, LinkedIn is still the go-to social-media site for anyone trying to ramp up a career. Krista Canfield, a LinkedIn spokeswoman, says that to reap the social-networking benefits of the site, you need at least 35 connections. Here’s how to best use the web site:
I have the opportunity in my teaching travels to witness many people hunting for the proverbial needle in the haystack, a.k.a. their Outlook® inbox. Like many of you who are technically inclined, I have to resist the urge to grab their mouse and keyboard and “show ‘em how it’s done.” Most of us don’t find that helpful at all, just intrusive. Instead, I thought I’d cover it here on my blog. There are 3 easy ways to quickly find what you’re looking for.

Quick Excel Tip

November 10, 2010 Categorized in: Excel

Duplicate a style you’ve created in one MS Excel workbook in another workbook. Here’s how:
Become an effective networker even if you’re an introvert, writes Devora Zack, author of Networking for People Who Hate Networking … Know when to use—and when to skip—skycaps while traveling … Track your personal spending with two free online tools … Give your “audience”—the people around you—a new, great story.
If you work with currency data and percentages, you have likely had an argument with that darned penny! You have flawlessly crafted your worksheet, expertly constructed formulas and can’t reconcile the penny that results when your calculations round up.
Columns are easy in Word 2007 and Word 2010! On the Page Layout tab, in the Page Setup group you’ll find a button called Columns. There are 5 default selections and a More columns selection to customize your column layout.

Web-based productivity tools

October 18, 2010 Categorized in: InternetOrganizingTime Management

Everyone has a preferred method of organizing to-dos and notes. Your computer monitor may be littered with Post-its, or you may use your e-mail software to track action items. Increasingly, though, people are turning to web-based tools. The benefit? To access these “cloud-based” tools, you don’t need to be on a particular computer, network or browser. A few suggestions:
Start with a simple circle and experiment with the new powerful graphics tools in PowerPoint® 2007/2010. Very soon, you’ll find yourself forgetting all about hours of working in custom graphics packages, painstakingly crafting creative objects to enhance your presentations.

Coming soon: a smooth street view

September 29, 2010 Categorized in: InternetTravel

Microsoft is working on a new technology, dubbed Street Slide. And from the looks of the demo, it would revolutionize online maps. The new technology allows users to “slide” along a street—rather than jump from snapshot to snapshot, as in Google Street View.