My Top 10 Most Viewed Excel Tutorials on YouTube Year-to-Date in 2012

DannyRocksExcels on YouTube

DannyRocksExcels on YouTube

Later this month, my YouTube Channel – DannyRocksExcels – will surpass 1.8 million views! Thanks to everyone who has visited, watched, and commented on my Excel video tutorials these past four years!

Top 10 Most Viewed Videos – January thru July, 2012

According to my YouTube statistics, these are the 10 most viewed Excel video tutorials on my channel. Click on the Links to watch any video on YouTube :

  1. How to Merge Multiple Excel Workbooks to a Master Budget – views year-to-date 39,338
  2. How to Use Advanced Filters in Excel – views year-to-date 29,700
  3. How to Use an Excel Data Table for “What-if” Analysis – views year-to-date 27,301
  4. How to Add a Check Box Control to an Excel Form – views year-to-date 27,171
  5. Consolidating Data from Multiple Excel Worksheets by Position – views year-to-date 26,517
  6. How to Create an Interactive Pivot Chart – views year-to-date 24,858
  7. Compare Two Excel Lists to Spot the Differences – views year-to-date 23,826
  8. Create Interactive Excel Forms by Including Option Boxes – views year-to-date 20,665
  9. How to Use the VLOOKUP Function in Excel – views year-to-date 20,574
  10. Import Excel Data Into MS Access – views year-to-date 18,288

Learn More Tips, Tricks, and Techniques for MS Office Programs

The 50 Best Tips DVD-ROMs

The 50 Best Tips Series of DVD-ROM’s

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – where you can purchase my video training resources.

The 50 Best Tips, Tricks & Techniques Series

Click on the link to go directly to the information page for each title. You will see a list of the 50 Tips and Ru Times for each title:

100% Satisfaction Guaranteed!

I stand 100% behind the quality of my products. I will refund your purchase price if, for any reason, you are not 100% satisfied – with no questions asked!

Thank you for your support through the years!

Danny Rocks

The Company Rocks

How to Add a Check Box Control to an Excel Form

Judging by the comments that I get from many clients, adding a “Check Box Control” to and Excel Form is not as easy as it appears at first glance.

And, I agree! I, too, struggled with adding Form Controls in Excel. Most of the explanations that I read seemed to add more confusion than clarification!

Spin Buttons in Excel

Spin Button Controls

That is why I created this Excel Training Video: to  lead you through the process; to save you some time and to ease your frustration.

Key Points to Remember:

  1. In Excel 2007, be sure to display the “Developer Tab” on the Ribbon in order to to Insert any Form Control.
  2. Choose the Controls in the “Forms Controls” and NOT in the Active X Controls.
  3. After you “draw” the Control Box on your Form, be sure to select a “Cell Link” to enable the Check Box Control.
  4. Remember that a Check Box Control can only be applied when the result of the Formula or Option is a Logical Value – either a result of  “True or False.”

Don’t be scared off! I find that this is an Excel concept that is better presented “visually.” I struggled for some time when I “read” how to add form controls.

So … I welcome your thoughts – “True or False.” Did I make this easy for you to understand?

Please feel free to add your comments below!

Watch My Video on YouTube

Follow this link to watch my tutorial on my YouTube Channel – DannyRocksExcels

Watch Video Now

 

Master Excel in Minutes Training Resources

I have created a series of extended length Excel Training Videos. I invite you to visit my secure online shopping site to:

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