peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Pain Free Way to Hide Excel Pivot Table Items

Remember to enter the Excel 2010 Future of Productivity Giveaway -- it ends at noon (Eastern time) on Tuesday, June 8th. You could win a copy of Microsoft Office 2010 (with fancy new pivot table features), a Flip video camera, and a Seagate 1TB hard drive.

If you're working with an Excel 2007 pivot table, you might want to temporarily hide one or more of the items in a Row field or Column field. To do that, you probably click the drop down arrow for the Row or Column Labels, then remove the check mark for items you want to remove. That method works, but if the items aren't in ascending or descending order, it can be a pain to find the item you're looking.

Quickly Hide Items

Excel 2007 has enhanced filtering in pivot tables, and this can save you some time. Instead of searching through a long

Continue reading Pain Free Way to Hide Excel Pivot Table Items

Resolve to Stay Safe in Excel

As the storm clouds rolled in yesterday afternoon, I tweeted about saving my Excel files more frequently, as a safety precaution. There were a couple of responses, asking why I didn't use Excel's AutoSave feature, and Jon Peltier reminded me to use AutoSafe -- Jan Karel Pieterse's free add-in.

I mentioned AutoSafe in my Excel New Year's Resolutions 2010 blog post, oh so long ago. Of course, I've kept all my resolutions -- how about you?

And speaking of safety, remember to enter the Excel 2010 Future of Productivity Giveaway. You could win a copy of Microsoft Office 2010, a Flip video camera, and a Seagate 1TB hard drive -- that should keep plenty of your data safely stored!

Installing AutoSafe

Even though I'm a creature of habit, and like to manually save my files, or click my Backup macro button, I decide to install AutoSafe. Good timing too,

Continue reading Resolve to Stay Safe in Excel

Excel 2010 Future of Productivity Giveaway

Have you installed Office 2010 yet? Would you like to win a copy, along with a couple of other great prizes? [for USA residents only]

In this short video, Microsoft employees and customers talk about the benefits of Excel 2010, both for the users and the IT department. Watch carefully -- there will be a test later!

The Future of Productivity Giveaway

The nice people at Ignite Social Media invited me to participate in a giveaway [for USA residents only], as part of the Office 2010 launch. No free stuff for me, but one of you can win a cool prize package. Yes, there's probably a better adjective than "cool" -- at least I didn't say "groovy". ;-)

The Prize Package one (1) copy of Microsoft Office 2010: Home and Business a Flip Ultra HD Camcorder a Seagate FreeAgent Desk Hard Drive (1 TB)

Here's a picture

Continue reading Excel 2010 Future of Productivity Giveaway

Related Posts Plugin for WordPress, Blogger...