Melissa P Esquibel

Outlook 2010, the tool you probably “live in” for a good part of each business day, also gives you the ability to keep up with social media updates. These are called Social Connectors, and you’ll find them in the People Pane.

{ 1 comment }

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.

{ 0 comments }

Learn the difference between SumIf and SumIfs … Dissect formulas in order to fix them … Clean up inconsistent date formats.

{ 0 comments }

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: Navigate to the library that needs this feature. From the Ribbon, click on the Library Settings button. Select Versioning Settings in the General Settings […]

{ 0 comments }

Q. What is OneNote? It’s on all my Ribbons.

{ 4 comments }

Q. Do I need Internet Explorer in order to use SharePoint 2010?

{ 0 comments }

Q. Where’s the old Find/Replace dialog box in Word 2010?

{ 0 comments }

How to Pivot a Pivot

by Melissa P Esquibel 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.

{ 1 comment }

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.

{ 1 comment }

Q. Why can’t I “script” animation in PowerPoint 2010? All I can do is add animation?

{ 0 comments }

Page 16 of 30« First...10...151617...2030...Last »