Archives for June 2010

Show Percentage of Calculations in Pivot Tables

Most people are content to let a Pivot Table Sum, Average, or Count their Values Fields. But what if you want to see individual Products as a percentage of all products sold in a Region – this is a standard request for Excel. And … it is easy to perform this calculation in a Pivot Table. Let me show you how to do this.

Follow this link to subscribe to the Danny Rocks “Tips and Timesavers” Podcast at the iTunes Store.

Learn how to “Quickly Create Pivot Tables and Charts in Excel.”

How to Import Text and Database Files in Excel 2007

When you need to import a Word document or an Access database file in Excel, resist the temptation to simply “open” the file with Office Button (File) – Open. Rather, follow the steps to “Get External Data” from the Data Tab on the Ribbon. This is how you can control the data type of each field that you import – especially important for formatting fields that contain dates. You also can control – and preview – who Excel will distribute the data into individual columns before you import the file.

Watch as I demonstrate these steps – this tip will save you a lot of time and avoid frustration.

(Note: This is a re-posting so that I can feed this video lesson to my Podcast at the iTunes store.)

Follow this link to view or subscribe to the “Danny Rocks Tips and Timesavers” podcast at the iTunes store.

Learn how to “Master Excel in Minutes – Not Months!”

How to Lead Meetings that People Want to Attend

Don’t Laugh at the title of this post! It is possible – it is desirable – to learn how to lead meetings that produce results. To learn how to lead a meeting that people want to attend.

This begins by re-thinking your meetings. Stop thinking about the meeting itself. Successful meetings are part of a process – a three-step process – that I walk you through in this video.

Click here to read or download this as a Text Doucment – Published on

(Note: This is a re-post so that I can feed this to my Podcast at the iTunes store.)

You can view, download and subscribe to my podcast – for free! Click here to follow the link to my Podcast at the iTunes store.