• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+
The Office Tech Pro

The Office Tech Pro

A Microsoft® Certified Trainer, Melissa Esquibel combines her 25+ years experience in information technology with a background in training, technical writing and business risk analysis. Her goal: To take you from “No, how?” to “Know how!”

Page 3 of 912345...Last »
We all manage projects of one type of another. Some of us have the advantage of sophisticated software to manage resources, timelines and scheduling. For those of us who don’t, you may be using Excel to manage lists and tasks, Word to generate status reports and PowerPoint to provide information outside the team to customers or vendors. Meeting notes, communications, other artifacts each live in their respective places. Wouldn’t it be nice to have it all in one place, neatly organized, searchable and shareable? Well you can do that in OneNote.
We all manage projects of one type of another. Some of us have the advantage of sophisticated software to manage resources, timelines and scheduling. For those of us who don’t, you may be using Excel to manage lists and tasks, Word to generate status reports and PowerPoint to provide information outside the team to customers or vendors. Meeting notes, communications, other artifacts each live in their respective places. Wouldn’t it be nice to have it all in one place, neatly organized, searchable and shareable? Well you can do that in OneNote.
SharePoint has never been more accessible than it is today with the Office 365 offerings from Microsoft. Is it right for you? Well, here are a few more questions to ask to answer that one.
It is three days before the event. You are frantically trying to gather attendee lists, catering orders, room arrangements, speaker itineraries, agendas, presentation slides and meeting notes. Some are in documents on your hard drive. Other information is available on a website. Countless documents and notes are in your email inbox, somewhere. Sound familiar? You may have an application already installed on your desktop that can rescue you from all that insanity. It’s called OneNote.
The Navigation Pane, Find/Highlight tool, and Bookmarks will have you manuevering around your text and adding polish to it in no time.
There are some powerful math features in Excel that can help you with your date data. First, let's take a look at how Excel interprets dates ...
PDFs can be deconstructed relatively easily. If you have a legitimate reason to edit PDF content in another application, there are some tools you should know about.
A successful SharePoint implementation has three characteristics, while other approaches to the project of making it your company's intranet solution can end in doom. Here's how to make SharePoint work for users and teams.
When most people think about creating handouts for a PowerPoint presentation, they think simply about printing copies of their slides, 1, 2 or 3 per page with note-taking lines. There are other options for creating handouts. Consider one or more of these suggestions.
There are plenty of groups for geeks, but what about end users of Microsoft Office tools? Well, it turns out there are lots of groups around where Microsoft Office users network and get help from one another, both online on platforms like LinkedIn and in person.
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.

How to Pivot a Pivot

by on October 15, 2012 11:52am
in The Office Tech Pro

For those with nice clean simple datasets to work with, this might seem like a silly thing to want to do. For those of us who deal with some monster-sized data exports, this could solve so many problems. 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!

Page 3 of 912345...Last »