Melissa P Esquibel

Have you ever found a great table of data on the web and then gone through a 90 step process to copy, paste and clean up that data to use in your Excel worksheet? In many cases, you can set up a link to that data that not only keeps the data in the tabular arrangement, but allows you to refresh your data when the web site updates.

{ 0 comments }

Don’t copy/paste data from the web, use Excel’s external data import tools.

{ 0 comments }

There are two view attributes and a shortcut that can make it a snap to navigate around your really large and complex documents. The proper use of heading styles is required for one of these and is always a good idea in complex documents.

{ 0 comments }

Three techniques to navigate complex Word documents.

{ 0 comments }

While animation can be overdone, when used judiciously, it can add punch to your message. This is one example of how to accomplish that goal in 5 steps.

{ 0 comments }

A how-to about PowerPoint animation using SmartArt.

{ 0 comments }

4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.

{ 0 comments }

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.

{ 0 comments }

4 great tips for using Microsoft Word, PowerPoint, Excel and Outlook to help you manage your holiday tasks.

{ 0 comments }

The ability to pivot multiple data ranges seems to have disappeared in Excel 2007-10. But, it’s doable with two cool tools that may unlock a few more secrets for you!

{ 0 comments }

Page 16 of 23« First...1015161720...Last »