Home Archives for Danny
April 26, 2010 3 Comments

Introducing Pivot Tables in Excel 2007

If you are already familiar with Pivot Tables, Excel 2007 makes Pivot Tables easier to create – you do not have to drag fields onto the template with the mouse! There are other improvements as well – and I cover the highlights in this lesson.

If you have never created Pivot Tables – or if you gave up in frustration – then this short, 9 minute and 48 second lesson will get you started. I explain that Pivot Tables help you to get answers about your data.

Let’s get started to create a Pivot Table in Excel 2007!

You can view and download this Excel video lesson – for free – as a Podcast. Click here to visit my Podcast, Danny Rocks Tips and TImesavers, at the iTunes store.

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

You can watch this Excel Training Video on YouTube

Related Excel Video Lessons:

Link to this post!
Filed Under: Excel Training, Pivot Tables Tagged: , , ,
April 25, 2010 1 Comment

Using the Go To Special Command in Excel 2007 to Spot Formula Errors

The “Go To Special” Commands is one of my favorites. And, Excel 2007 places it in a prominent position on the Home Tab of the Ribbon.

I use Go To Special to quickly highlight all of the cells that contain Formulas. This way I can see if someone has accidentally “hard-coded” a Constant Value in a cell that should contain a Formula.

In this short video lesson I also show you another way that I use Go To Special – to reuse a Budget Worksheet or a worksheet for Expense Account Reports.

I you enjoy this tip and my style of training, I invite you to visit my online bookstore. It is a secure shopping site where I sell my “The 50 Best Tips for Excel 2007” DVD as well as DVD s for PowerPoint 2007, Outlook  2007,  and Word 2007.

Click here to watch this Excel Video Lesson on YouTube.

Related Excel Videos:

Link to this post!
Filed Under: Excel Formulas, Excel Functions, Excel Training Tagged: , , ,
April 24, 2010 1 Comment

Preventing Formula Errors from Displaying

Formula Errors in Excel – e.g. #DIV/0! or #NULL! – are ugly! And, when you send a spreadsheet that contains formula errors to your client or to your boss … Well, that is not good.

It plants the seed of doubt in the minds of your client or your boss that you have not thoroughly checked the accuracy of your assumptions. Why are there errors showing? What else is missing?

Excel 2007 makes it easy to prevent these formula errors from displaying. We have a new Function in Excel 2007 – The =IFERROR() function and it only requires two arguments. Be warned, however, that if you share your Excel 2007 worksheet with colleagues who are using earlier versions of Excel, this new function will not – well, function! (I could not resist using this pun)

Watch this video to learn how to use the new =IFERROR() function and also the nested =ISERROR() function that is required for people who use Excel 2003 or older versions.

If you enjoyed this Excel tip and my style of training, I invite you to visit my online store to shop securely for my DVD, “The 50 Best Tips for Excel 2007.”

Click here to watch this Excel Video Lesson on YouTube

You can view and download this video – for free – as a Podcast from the iTunes store. Follow this link to my Podcast, Danny Rocks Tips and Timesavers at the iTunes store.

Related Video Lessons:

Link to this post!
Filed Under: Excel Functions, Excel Training Tagged: , , , , ,
April 24, 2010 Leave a Comment

Visualizing Your Data in Excel 2007

Excel 2007 makes it easy to “visualize” your data – directly in the cells of your worksheet! You do not need to take the time and effort to create a chart to visually represent your information.

You just take advantage of the tools in the newly-engineered Conditional Formatting command in Excel 2007. In this lesson I show you how to visualize your data as:

  • Data Bars – you get the equivalent of a Bar Chart drawn inside the data cells.
  • Icon Sets – pick from groups of 3, 4 or 5 Icon sets – for example, to show the data in the top third of your data range.
  • Color Scales – to add gradations of colors as numbers increase or decrease.

If you liked this tip and my style of Excel training, I invite you to visit my online store to purchase my DVD, “The 50 Best Tips for Excel 2007.”

You can view and download this Excel video lesson – for free – as a Podcast. Follow this link to visit my Podcast, Danny Rocks Tips and Timesavers” at the iTunes store.

You can also watch this Excel video lesson on YouTube.

Related Excel Videos:

Link to this post!
Filed Under: Excel Training Tagged: , , , ,
March 4, 2010 1 Comment

How to Lead a Meeting People Enjoy Attending

Don’t laugh, you can learn how to lead meetings that people really look forward to attending!

This 7 minute and 19 second video appears in my March, 2010 newsletter, The Catalyst. Please take a moment to join my mailing list if you would like to receive my newsletter each month. You can sign up right here on this page.

Successful meetings follow a process. In this video you will learn the three-step process for successful meetings:

  1. Prepare for the Meeting – Determine the purpose for the meeting and prepare an action agenda and invite the proper participants to the meeting.
  2. Run the meeting skillfully – Run the meeting in support of the action agenda and ensure full participation for each person invited to the meeting.
  3. Follow-up – Assign roles and responsibilities during the meeting. Ensure acceptance of these assignment. You are already preparing for your next meeting – to follow-up on the decisions and information from this meeting.

If you would like to learn the techniques that I used to create the PowerPoint presentation I used in this video, I invite you to visit my online store to get details about my DVD, “The 50 Best Tips for PowerPoint 2007.”

Related Posts

Link to this post!
Filed Under: Business Communications, Business Practices, Communications, Managing, Presentations Tagged: , , , , , , ,
February 13, 2010 Leave a Comment

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:

Link to this post!
Filed Under: Powerpoint Techniques, PowerPoint Video Training Tagged: , , , , ,
February 11, 2010 2 Comments

Video Tour My DVD – The 50 Best Tips for Excel 2007

I invite you to join me on a four minute, seven second video tour of my new instructional DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007.”

This DVD is different. If you want to learn Excel and you are pressed for time (and who isn’t these days?) this is the DVD for you. I give you over 5 1/2 hours of focused video instruction. The average length of each video lesson is 6 1/2 minutes! So you can find the topic that you want, learn it, and put it into practice at home or at work in under 10 minutes!

As a bonus, I include the 50 Excel worksheets that I used to create and film the video lessons. Now you can practice the tips to master your new Excel skills!

Follow this link if  you want to see the complete list of the 50 video lessons on my DVD.

Are you ready to purchase “The 50 Best Tips for Excel 2007?” Follow this link to enter the online bookstore for The Company Rocks. This is a secure shopping site. And, I guarantee that you will be satisfied with your purchase. If you are not satisfied with your purchase, I will refund you money – no questions asked!

Sincerely,

Danny Rocks

Related Videos

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, MS Excel Tips, Online Store for The Company Rocks, Tips and Time Savers, Video Training Courses Tagged: , , , , , , , , , , ,
February 3, 2010 Leave a Comment

Setting Goals in Five Steps

This video appears in the February, 2010 edition of my e-Newsletter, “The Catalyst.” I invite you to sign up to receive each new issue as it is published.

I adapted this lesson from a presentation that I delivered at The NAMM Show in Anaheim, CA last month. I have had great success when I use this process in my training classes for Time Management and Team-building.

I encourage you to view the other articles and videos that I have posted on my websites. You can click to go to a site that contains Excel video lessons. Want to improve your PowerPoint skills, I have a website for that also. And, now, you can purchase my instructional DVDs from my online store.

You can view and download this video as a Podcast – for free! Follow this link to visit my Podcast channel, Danny Rocks Tips and Timesavers, at the iTunes store.

Link to this post!
Filed Under: Business Communications, Goals Tagged: , ,
December 30, 2009 Leave a Comment

Announcing the Online Store for The Company Rocks

Danny's DVDs "The 50 Best Tips" Series Available in Online StoreToday, I launched my new online bookstore for The Company Rocks. I am offering my Instructional DVDs for sale individually or as a set at attractive prices. Follow this link to enter the store to learn more about the DVDs in “The 50 Best Tips for …” Series.

“The 50 Best Tips for Excel 2007” contains over 5 1/2 hours of training. Each video lesson lasts @ 6 – 7 minutes. Each lesson focuses on one productivity tip. So you can get an answer quickly when you need it. I follow a step-by-step approach to teach you how to be more productive when you use Excel 2007. You can see how to enter and edit the formulas because I use an innovative “pan-in / pan-out” camera technique to focus your attention.

And, as a bonus: The actual spreadsheets that I use for each lesson are included on the DVD!

“The 50 Best Tips for PowerPoint 2007” packs over seven hours of training onto two DVDs! Unlike many instructional packages the teach you PowerPoint from a technical angle, I teach you how to incorporate PowerPoint into your total presentation. I am a professional speaker and trainer. I am not a “techie.” You will learn the technical side of PowerPoint 2007 – but only as it helps you to be more effective in presenting your ideas or products. I think that you will enjoy this difference!

The focus of each DVD is on the Intermediate to Advanced user of Excel or PowerPoint. The focus is on helping you to save time and take advantage of the great presentation elements in both programs. There are 10 videos each at the Beginning Level and at the Advanced Level. There are 30 videos for the Intermediate Level user.

Please visit my new online bookstore to learn more about each DVD. I welcome your feedback!

Thank you for your kind words of support as I have built my business these past three years. I wish you a very happy new year in 2010!

Danny Rocks

danny@thecompanyrocks.com

Link to this post!
Filed Under: Business Communications, Online Store for The Company Rocks, PowerPoint Video Training, Video Training Courses Tagged: , , , , , , , , ,
December 30, 2009 Leave a Comment

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

Link to this post!
Filed Under: Online Store for The Company Rocks, Powerpoint Techniques, PowerPoint Video Training Tagged: , , , ,
« Previous Page
Next Page »