Category: The Office Tech Pro

Microsoft has announced Microsoft® Office for Android® and IOS devices. The release, targeted for the 1st quarter of 2013, will finally allow you to read and work with your Office files on your Droid device.

Delete Fearlessly! Sort by sender, subject or organize by conversation. Delete those that are purely social. Even if you spend 5 minutes a day until the end of the year on this task alone, you will probably end up with hundreds of messages you can feel confident about deleting.

Can I hide documents that have a status other than approved in a document library? In fact it’s just a couple of clicks to set this up in an existing library:

While you can’t EXACTLY pivot a pivot, in Excel 2010 you can create a data subset with a Pivot Table that can be copied, pasted and “re-pivoted” in just a few clicks.

Multiple Duplicate Worksheets

Click on the first worksheet tab and hold down the Shift key. Keeping the Shift key down, click on the last worksheet. They should all appear white, rather than gray. Now, just start typing. What you do on one sheet will also be on the remaining selected worksheets.

The Clear Formats Button Did you ever inherit a badly formatted document just wish you could start over? Use Ctrl+A to select all the text and on the Home tab, in the Font group, click the Clear Format button. Now, put in your own formatting!

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.

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.

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.