List of My Most Popular Posts and Pages

Summer – in the Northern Hemisphere – is now behind us. I went back to survey the videos and pages on my website that had the most views during the Summer of 2010. 

Here is a listing of my “Top 10 Video Posts” and my “Top 5 Pages.” Click on the Links for each title to go directly to the Video Lesson or Page.

The “Top 10 Video Posts” on The Company Rocks Website:

  1. Simplify Data Lookups in Excel
  2. Make Excel Come Alive with Visualization Tools
  3. Build an Accounts Receivable Aging Report
  4. Summarize Multiple Excel Worksheets – Consolidate Data by Position
  5. How to Merge Multiple Excel Workbooks into a Master Budget
  6. Use Pivot Tables to Summarize by Year, Quarter and Month
  7. Perform Break Even Analysis with Excel’s Goal Seek Tool
  8. 2 Reasons to Format Cells Before You Enter Data in Excel
  9. Hide and Show Details in Excel Pivot Tables
  10. Use Vlookup Function to Prepare a Payroll Statement

The “Top 5 Pages” Viewed on The Company Rocks Website:

  1. The Excel Home Page
  2. Index to Excel Video Lesson Topics
  3. List of “The 50 Best Tips for Excel 2007”
  4. Excel Training Videos by Category
  5. The 50 Best Tips for PowerPoint 2007

The Danny Rocks Tips and Timesavers Podcast

During the Summer of 2010, I started my own video podcast at the iTunes Store. These podcasts are free of charge. The video resolution is optimized for viewing on an iPad, iPod or other portable media device.

The DannyRocksExcels Channel on YouTube

Over the past two years I have posted 104 video lessons on my “DannyRocksExcels” Channel on YouTube.

The DannyRocksPowerPoint Channel on YouTube

I maintain a separate channel on YouTube – “DannyRocksPowerPoint”– to post my PowerPoint Tips and Narrated PowerPoint Presentations. I invite you to vist my channel to view, download and share these videos with your friends and colleagues. Click here to go to my YouTube Channel.

“The 50 Best Tips for …” series of DVDs

I offer five DVDs for sale on this website. Click here to start your shopping cart. I guarantee your satisfaction. If you are not 100% satisfied with my DVDs, I will refund your purchase with no questions asked!

You can learn how to “Master Excel in Minutes – Not Months!”

Here is a listing of the DVDs that I offer for sale. Click on the link for each title to go to the list of the tips that I offer on each DVD:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Review of My DVD – The 50 Best Tips for PowerPoint

Here is a link to a review of my DVD, “The 50 Best Tips for PowerPoint 2007.”  The review is by PowerPoint MVP, Geetesh Bajaj on the Indezine website.

Indezine Website

Review of my PowerPoint DVD

If you have not yet visited the Indezine website, I encourage you to do so. There are numerous resources available that will help you to produce better slides and to deliver better presentations. You will also find:

  • Interviews with the leading members of the presentations community.
  • Hundreds of PowerPoint Templates.
  • A Blog with great articles to help you to improve your presentations.
  • Links to other websites devoted to presentations.

If you design or deliver presentations, please bookmark the www.indezine.com website.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Watch My Podcast on iTunes

View in iTunes

Tips and Timesavers Podcast

I have just uploaded my 25th video podcast to the iTunes Store. The “Danny Rocks Tips and Timesavers” podcast can be viewed or downloaded for free. Click here to go to my podcast. Or, if you wish, you can copy and paste this link to do this later:

http://itunes.apple.com/podcast/danny-rocks-excel-tips/id374923275

I am pleased to report that I am presently getting over 100 downloads per day for my videos. Thank you!

On average, I upload two new videos per week. The majority of my videos demonstrate tips for getting the most out of MS Office programs (Excel, PowerPoint, etc.) I also include video tips for running productive meetings, setting goals, and other topics related to Business Communications.

Besides viewing my videos on iTunes, you can automatically receive my latest vides by subscribing to my RSS Feed. Simply click one of the RSS Feed buttons here on this post or at the top right corner of my web pages. RSS (Really Simple Syndication) is free and you do not need to provide any personal information except, of course, your e-mail address. If you have never used RSS, I encourage you to give it a try. Let me know what you think of it.

I always welcome your comments, thoughts and suggestions. And, if you enjoy my videos, please forward this post to a friend or colleague.

Sincerely,

Danny Rocks

P.S. You can Learn How to “Master Excel in Minutes – Not Months!” Click this link to get more  information.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Review for My 50 Best PowerPoint 2007 Tips DVD

I was pleasantly surprised to see my DVD, “The 50 Best Tips for PowerPoint 2007” reviewed today by noted author and speaker, Ellen Finkelstein.

Here is a link to Ellen’s review

Notice that the review is part of Ellen’s “PowerPoint Tips Blog.” I encourage you to go to Ellen’s website – www.ellenfinkelstein.com – to read and subscribe to her newsletter and to gather some great tips for improving your presentations. By registering, you can download a free white paper: “From Death by PowerPoint to Life by PowerPoint.” Check out Ellen’s site today.

Danny Rocks

The Company Rocks

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

How to Create Custom PowerPoint Slide Shows

Do you carry around multiple versions of a PowerPoint file – one for each of your five customers? Have you ever carried the wrong version? Have you ever forgotten to update each version with the latest information?

If so, you need to learn how to create and run a PowerPoint Custom Slide Show. You can even hyperlink to custom shows within your main presentation! And, no more File Save As – you only use one file!

You can view this short PowerPoint Video here on my website, download it, or subscribe to my – free – podcast at the iTunes store.

This PowerPoint Training Video Lesson is typical of the tips that I offer on my DVD, “The 50 Best Tips for PowerPoint 2007.” Click here to buy it now.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

How to Animate SmartArt Diagrams in PowerPoint

SmartArt Diagrams were introduced in Office 2007. Using SmartArt on a PowerPoint slide is a great way to present a business concept. They are much more interesting for both the audience and the presenter  – compared to “boring bullet points.”

However, when you want to engage your audience, it helps to apply Custom Animation to the Smart Art so that each part of the diagram appears in the order – and with the timing – that you want.

You can quickly download this five minute video by clicking just below this image. Or, you can get this – and my other Podcast tips – from the iTunes Store by clicking this link.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Tour My 50 Best PowerPoint 2007 Tips DVD

I am proud to announce the release of my 2nd DVD, “The 50 Best Tips for PowerPoint 2007.” There are 2 DVD disks in this package – over 7 hours of step-by-step video instruction. The length of each video tip averages 9 minutes. Each lesson stands on its own – you can watch them in any order – one at a time. Tips are organized by level – Beginning, Intermediate and Advanced. My publisher created an attractive Content Guide to help you pick the video tip that you want, see the run-time for the video, and also see the learning objectives – before you click on the lesson!

Here is a short – 4 minute, 40 seconds –  video tour of what you get when you purchase, “The 50 Best Tips for PowerPoint 2007” DVD:

You can order your own copy of this DVD – as well as my “The 50 Best Tips for Excel 2007” DVD – at my online bookstore. It is a secure site, so you can shop and purchase with confidence. Plus, I guarantee your satisfaction. I will refund your purchase if you are not 100% satisfied with my products!

Related Videos:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

My New DVD – The 50 Best Tips for PowerPoint 2007

Danny's DVD Series "The 50 Best Tips for PowerPoint 2007" I am proud to announce that my latest DVD, “The 50 Best Tips for PowerPoint 2007,” is now available for purchase.

This is a set of two DVD s containing over seven hours of training! Each lesson averages about 10 minutes. So, when you want to work on one specific part of your presentation you can just put the DVD in your computer, locate the lesson and get a focused coaching session – all within the space of less than 15 minutes.

When you want quick answers and a visual guide for the steps involved, this is the DVD for you.

When you want to learn how to use PowerPoint from a professional speaker & trainer and not from a “techie”, this is the DVD for you.

I am also proud to announce that my online bookstore opened this morning. I invite you to visit the bookstore for The Company Rocks. You can also learn about my other DVDs including, “The 50 Best Tips for Excel 2007.”

Thank you for all of your kind words of support as I have built this website over the past year. I wish you a very happy new year in 2010!

Sincerely,

Danny Rocks

danny@thecompanyrocks.com

Add Video of Your Employees to Your Website

danny-playing-the-pianoPeople do business with people that they like – or would like to be like.

Take advantage of this. Shine the (video) spotlight on your employees. Let your customers get to know them better. Let your employees “showcase” their special talents and expertise.

People want to do business with people that they know and trust. Your website gives you a great opportunity to:

  • Include a short video of your employees sharing a tip, a hobby, a piece of trivia
  • Invite your customers to get to know something that they did not know yet …
    • About your business
    • About your product
    • About your employees

Try it!

Here’s an example – I filmed a series of training videos for NAMM – The International Music Products Association.

In this video, you can see – and hear – me playing a little piano music. Now, perhaps, you did not know that I played the piano. Perhaps that makes me more interesting. Perhaps you – the customer – would like to know a little bit about me.

This is an opportunity to start a conversation. Which may lead to a sale. Which will help to establish a connection between your employees, your customer and your business.

Try it – you may like it. And… you may find more customers – who like to business with people that they like – or people that they would like to be like!

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Tools To Control Text On Slides

I want you to reduce the “Visual Clutter” on your PowerPoint Slides. You are not trying to write a “ransom note,” you are attempting to create a professional image.

PowerPoint has a great set of tools that you can use to enforce the Visual Style options that you set. In this video lesson, I demonstrate how to set up the style guides and then how to use PowerPoint’s tools to make the changes that conform to your rules.

Here are the steps to follow for this lesson:

  1. Go to the Tools Men and choose Options and then click the Spelling & Style Tab.
  2. On the Spelling & Style Tab choose Style Options.
  3. You can make your stylistic choices on the “Case & End Punctuation” tab and on the “Visual Clarity” tab. When you have made your choices, click OK.
  4. Back in Normal View, when you click in a Text Place holder, look for the Yellow Light Bulb. Click on it to see your options to conform to the style settings that you set.
  5. Also, look for the AutoFit Options Smart Tag. Choose the best option to change your style.

Search my Index of PowerPoint Video Lessons for the topic of your choice.

News! My DVD, “The 50 Best Tips for PowerPoint 2007” is availabe for purchase. Visit my online store for details.

Related Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn