Tips And Time Savers | The Company Rocks

Danny September 6, 2010 Leave a Comment

Watch My Podcast on 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:

Filed Under: Business Communications, Communications, Excel Training, How to Lead Effective Meetings, MS PowerPoint 2007, Podcast Tips & Timesavers, Powerpoint Techniques, PowerPoint Video Training, Tips and Time Savers, Video Training Courses Tagged: Danny Rocks Podcast, iTunes Store Podcast, RSS Feeds, Tips and Time Savers

Danny July 28, 2010 3 Comments

Perform Break Even Analysis with Excel’s Goal Seek Tool

As a small business owner or investor, you ask many“what-if?” questions. In preparing to present your business plan to an investor you want to know your “break even” point. Fortunately, Excel has a great tool – Goal Seek – that can save you time by creating multiple scenarios to help you determine your goal – to break even!

You can watch this Excel Video Lesson here – online – or you can download it to watch later, at your convenience. I invite you to subscribe to my podcast, “Danny Rocks Tips and Timesavers” at the iTunes store by clicking this link – this is a free subscription.

Click here to see a listing of “The 50 Best Tips for Excel 2007.”

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

Share and Enjoy:

Perform Break Even Analysis with Excel's Goal Seek Took [ 4:00 ] Play Now | Play in Popup | Download (1352)

Filed Under: Excel Financial Tools, Excel Formulas, Excel Training, Goal Seek in Excel, Podcast Tips & Timesavers, Small Business, Tips and Time Savers, What-if Analysis Tagged: "What-if" Analysis in Excel, Break Even Analysis, Excel Formulas, Excel Video Training, Tips and Time Savers, Video lessons for Excel

Danny May 31, 2010 3 Comments

Dynamically Expand the Source Data for Pivot Tables in Excel 2007

Without question, the new Tables Tools is my favorite feature in Excel 2007 – this feature, alone, is worth the price to upgrade!

When you format a Data Range as a Table in Excel 2007, you can “append” new data to the table and the Table definition automatically expands to incorporate the new cells! If you create Pivot Tables based on a “Named Range” for your source data, this is GREAT NEWS!

Now, after appending the new data to your “Named Table: in Excel 2007, when you refresh your Pivot Table, you automatically get updated data in your Pivot Table report.

This can save you hours each month – at what – $50.00 per hour? $100.00 per hour? Watch these savings add up each month of the year

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

Follow this link, to view and download – for free – the episodes on my Podcast, “Danny Rocks Tips and Timesavers” at the iTunes store.

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

Share and Enjoy:

Save hundreds of dollars each month when you use a Pivot Table Play Now | Play in Popup | Download (902)

Filed Under: Excel Data Tables and Lists, Excel Training, Pivot Tables, Podcast Tips & Timesavers, Tips and Time Savers Tagged: Excel 2007 Tables, Excel Pivot Tables, Excel Video Training, New in Excel 2007, Refresh Pivot Tables, Source Data for Pivot Tables

Danny May 30, 2010 3 Comments

Create a Month, Quarter, Year Report with 10 Mouse Clicks Using Pivot Tables

With an Excel Pivot Table you can transform thousand of rows of transactions into a neat summary by month, quarter and year using @ 10 mouse clicks!

I invite you to visit my online shopping site to purchase my DVD “The 50 Best Tips for Excel 2007.

(Note: This is a re-post so that I can send this video to my Podcast on iTunes.)

Follow this link to view or subscribe to my Podcast at iTunes

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

Share and Enjoy:

Create Summary by Year, Month, Quarter with 10 Mouse Clicks in Excel Pivot Table Play Now | Play in Popup | Download (722)

Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers, Tips and Time Savers Tagged: Excel Pivot Tables, Excel Video Training, Group Dates in Pivot Tables, Tips and Time Savers

Danny May 29, 2010 2 Comments

Five Benefits from Using Tables in Excel 2007

I really enjoy the major changes that Excel 2007 has incorporated into Tables. In this video I demonstrate Five Benefits when you convert your Excel data lists into Tables.

(Note: This is a re-post. I now make many of my videos available as Podcasts and I need to send these videos to the iTunes store.)

Click here if you would like to subscribe to my Podcast at the iTunes store.

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

Share and Enjoy:

Five Benefits from Using Tables in Excel 2007 Play Now | Play in Popup | Download (1181)

Filed Under: Excel Data Tables and Lists, Excel Training, New in Excel 2007, Podcast Tips & Timesavers, Tips and Time Savers Tagged: Excel 2007 Filters, Excel Data Tables, Excel Video Training, FIlter a List in Excel, Named Cells and Ranges, New in Excel 2007

Danny May 29, 2010 3 Comments

How to Merge Multiple Excel Workbooks into a Master Budget

Would you like to know how to merge the work of several individual departments into a master budget workbook in Excel 2007? Watch as I show you how to to do this in a non-networked environment.

(Note: The is a re-post. I am making many of my video lessons available as Podcasts and I need to feed them to the iTunes store.)

Watch Video Tutorial on YouTube

Click on this link to watch this Excel Tutorial on my YouTube Channel – DannyRocksExcel

This is consistently one of my Top 5 Videos that are watched on YouTube!

Subscribe to Free Video Podcast – Danny Rocks Tips and Timesavers – at iTunes

Click here if you would like to subscribe to my Podcast at the iTunes store.

Share and Enjoy:

How to Merge Multiple Excel Workbooks Play Now | Play in Popup | Download (1101)

Filed Under: Excel Financial Tools, Excel Training, Most Viewed Excel Videos, Podcast Tips & Timesavers, Tips and Time Savers, YouTube Videos by Danny Rocks Tagged: Collaboration in Excel, Consolidate Excel data, Excel Video Training, Master Budget, Merge Changes in Excel 2007, Multiple Excel Workbooks, Video lessons for Excel

Danny May 15, 2010 Leave a Comment

I Have Updated My Index of Excel Video Lessons

As part of the process of reorganizing my website, I have updated my “Index of Excel Video Lessons” page. The content of this page will be updated as I add each new Excel Video Training Lesson. So, I suggest that you click here to go to the Video Index and then save the page as one of your “Favorites” if you want to learn how to really get the most out of Excel or to find a quick answer when you are using Excel.

On the Index Page you can see an organized listing of my Excel Videos by Category – e.g. Formulas, Formatting, Pivot Tables “What-if” Analysis, etc. Each lesson is “hyperlinked” so that you can just click on the topic to go directly to the lesson that you are interested in.

I indicate in the title if the lesson is specific to Excel 2007. All my new Excel video lessons are created using Excel 2007.

If there is a topic that you would like me to cover, send me an e-mail message – danny@thecompanyrocks.com

If you enjoy my video instruction, I encourage you to purchase my DVD, “The 50 Best Tips for Excel 2007.” The DVD contains over 5 1/2 hours of Tips, Tricks & Techniques to help you to master the program – and to save a considerable amount of time while working in Excel! Click here to enter my secure shopping site.

Thank you for your support and encouragement!

Danny Rocks

Share and Enjoy:

Filed Under: COUNTIF and SUMIF Functions, Everyday Calculations in Excel, Excel Basics, Excel Data Tables and Lists, Excel Date and Time Functions, Excel Financial Tools, Excel Formulas, Excel Functions, Excel Training, Import Data into Excel, Lookup Functions in Excel, MS Excel 2007 DVD, MS Excel Tips, MS Excel Training, Online Store for The Company Rocks, Pivot Tables, Text Functions, Tips and Time Savers, Training, Video Training Courses, What-if Analysis Tagged: Excel Video Training, MS Excel Training, Tips and Time Savers, Video lessons for Excel

Danny May 14, 2010 2 Comments

How to Combine Changes Made to Multiple Excel Workbooks

Review Changes Commands

Frequently, several people work on an Excel 2007 Workbook. Perhaps to create departmental budgets or to analyze regional sales results. When it is time to combine the work of these individuals into the Master Excel Workbook you do not want to resort to “copy & paste!” Fortunately, you do not have to. Use Excel 2007’s Compare and Merge Tool to do this for us.

However, in order to make this work there are several “gotcha steps” to be aware of. Watch this video lesson to see how to combine the individual work of three colleagues into a “merged workbook” for an upcoming event. I guarantee that this lesson will save you time and aggravation at “budget time” each year.

Subscribe to My Video Podcast on iTunes

This video is available to view and download – for free – as a Podcast at the iTunes store. Click here to go to the Danny Rocks Tips and Timesavers Podcast at iTunes.

(Follow this link to watch this Video Podcast from my website.)

Visit My Secure Online Shopping Website

Watch My Tutorial Now

Visit My Secure Online Shopping Website

If you enjoyed this Excel video lesson, I invite you to visit my online store to purchase my DVD, “The 50 Best Tips for Excel 2007.” It contains over 5 1/2 hours of focused video instruction in Excel 2007 Tips, Tricks & Techniques. Click here to shop using a secure shopping cart.

Watch this Excel Tutorial in High Definition

Do you want to watch this Excel Video Lesson on YouTube? Follow this link to view it on my YouTube channel, DannyRocksExcels

Note: As of September 2012, this video has been viewed over 79,000 times on YouTube!

Share and Enjoy:

Filed Under: Excel Financial Tools, Excel Training, Most popular articles, MS Excel Training, Tips and Time Savers, YouTube Videos by Danny Rocks Tagged: Combine Workbooks in Excel, Consolidate Excel data, Customize Quick Access Toolbar, Excel Video Training, Merge Changes in Excel 2007, Share Excel Workbooks, Video lessons for Excel

Danny May 11, 2010 2 Comments

How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data

This video lesson is in response to a viewer’s request. The information that he gets comes from a mainframe computer and the orientation of the data is horizontal (going left-to-right across columns. He wants to be able to reorganize this data to show it vertically (from top-to-bottom in rows. I use Excel’s Transpose tool to show him how to do this.

I also demonstrate an extremely useful Excel Tool – Text to Columns – to break apart an address block (City, State, Postal Code) into discrete fields – to help you to manage a mail merge or to sort and filter by State or by Postal Code.

(Note: Somehow this lesson “got lost” as I was reorganizing my website. So, I apologize in advance if you already viewed this lesson.)

If you enjoyed this lesson, I invite you to visit my online bookstore to shop for my DVD, “The 50 Best Tips for Excel 2007.” It is on sale now!

You can watch this Excel Video Lesson on YouTube – vist my channel – DannyRocksExcels

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

Danny Rocks “Training You to Excel”

Watch My Podcast on iTunes

Perform Break Even Analysis with Excel’s Goal Seek Tool

Dynamically Expand the Source Data for Pivot Tables in Excel 2007

Five Benefits from Using Tables in Excel 2007

How to Merge Multiple Excel Workbooks into a Master Budget

Watch Video Tutorial on YouTube

Subscribe to Free Video Podcast – Danny Rocks Tips and Timesavers – at iTunes

I Have Updated My Index of Excel Video Lessons

How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data

Related Videos

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

Related Videos

Locate My Video Tutorials by Category

Seach My Website with Keywords

Podcast Feeds

Blogroll

Blogs for Business Writing

Blogs for Excel

Blogs for Presentations

Register or Log In

Danny Rocks “Training You to Excel”

Follow Danny on Social Media

Watch Video Tutorial on YouTube

Subscribe to Free Video Podcast – Danny Rocks Tips and Timesavers – at iTunes

Subscribe to My Video Podcast on iTunes

Visit My Secure Online Shopping Website

Watch My Tutorial Now

Visit My Secure Online Shopping Website

Related Excel Video Lessons:

Watch this Excel Tutorial in High Definition

Related Videos

Related Videos

Locate My Video Tutorials by Category

Seach My Website with Keywords

Podcast Feeds

Blogroll

Blogs for Business Writing

Blogs for Excel

Blogs for Presentations

Register or Log In

Tags