The Office Tech Pro

If you find yourself looking for the most recent/best presentation from which to make a new one, or pondering the question, “Now, how did I do that last time?” it’s time to get familiar with custom PowerPoint templates. The basic steps are pretty straightforward:
I got this question in a SharePoint class this week: How can I take the email addresses out of an email with a huge “To:” line and create a list for SharePoint? Well, here’s how to do it.

Secondary axis charts in Excel

August 20, 2012 Categorized in: The Office Tech Pro

If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, a secondary axis is useful when you have to display whole numbers and related percentages, like cost, price and profit percentage.

Neat trick with meeting tracking

August 10, 2012 Categorized in: The Office Tech Pro

Are you planning a big meeting with lots of moving pieces: catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data from Outlook to do that? Well here’s how you can.
I recently heard a train-the-trainer presenter refer to all animations and transitions as unnecessary fluff and distractions. While I agree that animation beyond basic slide transitions can be distracting, I do think there is a place for well-placed advanced features in your PowerPoint. Here are my basic guidelines:
You’ve plugged in the values for a PMT (payment) function to determine how much the payment will be only to find that the payment is a bit too much for your budget. You could keep plugging in numbers until you get the right answer, or find out the exact answer in a couple of clicks with one of the “What If” analysis tools in Excel.

Outlook 2010 Quick Steps

June 20, 2012 Categorized in: The Office Tech Pro

Microsoft hit it out of the park with Quick Steps in Outlook 2010. On the Home tab, in the Quick Steps group, you’ll find several out-of-the-box Quick Steps.

SharePoint document workspaces

June 12, 2012 Categorized in: The Office Tech Pro

Are you using SharePoint 2007 or 2010 as a glorified file server? There are many opportunities to make SharePoint do some heavy lifting beyond just keeping your files organized. One such opportunity is the actual creation of a complex document like a procedures manual. Using a template called a Document Workspace in SharePoint.

3 great Excel questions

May 30, 2012 Categorized in: ExcelThe Office Tech Pro

Some people ask why I keep teaching these applications. “Don’t I get bored?” Not with great questions like these! I solved one of the following questions awhile back for my own use. The other two started out as “I don’t know, let’s see…”
I want to right align part of a line. For example, in a résumé the company name might be flush with the left margin, but the dates of employment should be flush with the right. How do I do that?
If you design diagrams with layered objects, especially with animation, it can be a bit frustrating to keep things stacked the way you like as you make changes and add movement. Here are a couple of tips to keep your sanity with layered objects.

Outlook 2010 View Tips

April 24, 2012 Categorized in: The Office Tech Pro

This content requires a subscription. PLEASE LOGIN Email Address: Password:   Forgot Password? | Setup Username/Password Subscribe today to get: The nation’s premier newsletter for administrative professionals Unlimited access to AdminProToday.com — updated daily! Skill-building online training, plus valuable forms, templates, skills assessments and more Expert advice on office technology, business communication, workplace politics and […]
This content requires a subscription. PLEASE LOGIN Email Address: Password:   Forgot Password? | Setup Username/Password Subscribe today to get: The nation’s premier newsletter for administrative professionals Unlimited access to AdminProToday.com — updated daily! Skill-building online training, plus valuable forms, templates, skills assessments and more Expert advice on office technology, business communication, workplace politics and […]