Archives for October 2013

4 Million Views on My YouTube Channel – DannyRocksExcels

DannyRocksExcels has 4 Million Views

Danny Rocks has 4 Million Views on YouTube!

I am honored and humbled to realize that my Excel Video Tutorials have been viewed more than 4 Million times!

Thank you to my 10,000 plus loyal subscribers!

I enjoy receiving your comments and requests. I try my best to respond as quickly as I can to each individual comment.

Interesting to note: My Top 10 “All Time Most Visited Videos “on my YouTube channel represented 26% of my total views!

Obviously, These statistics are “skewed” by longevity – how long have they been up on YouTube, etc. Nevertheless, I can use this information to determine which commercial products that I need to produce – ASAP!

Here is the listing of  my Top 10 – “All Time Most Viewed Excel Video Tutorials:”

  1. How to Merge Multiple Excel Workbooks into a Master Budget – – 123,382 Views –  – Posted May 14, 2010
  2. Compare Two Excel Lists to Spot the Differences – 123,023 Views – – Posted May 15, 2010
  3. How to Add a Check Box Control to an Excel Form – 120,800 Views –– Posted September 1, 2012
  4. How to Use Advanced Filters in Excel – 119,955  Views – – Posted on December 27, 2010
  5. Introduction to Excel Pivot Tables – 104,662 Views – – Posted on August 19, 2008
  6. How to Use an Excel Data Table for “What-if” Analysis – 103,411 Views – – Posted on September 15, 2010
  7. How to Create an Interactive Excel Pivot Chart – 102,033 Views – – Posted on May 11, 2011
  8. Use the Built-in Data Form in Excel – 96,079 Views – – Posted on December 17, 2010
  9. How to Use the Solver Tool in Excel – 85,452 Views – – Posted on September 21, 2011
  10. Import Excel Data in MS Access – 80,824 Views – – Posted on January 2, 2011

Watch My Excel Tutorials in High Definition on My YouTube Channel

Here is the link to my DannyRocksExcels Channel on YouTube – The majority of my videos are produced in High Definition. Obviously, my older videos were posted before the High Definition Option was available on YouTube.

Visit My Secure Online Shopping Website

I invite you to visit my secure online shopping website – – to preview the many video training resources that I offer!



Working with Worksheets in Excel Workbooks – Part 1

I have been quite busy this year teaching several “continuing education” courses online for colleges here in the USA. One of the benefits – for me as the instructor – is that I get “real time” feedback from my students when they submit their assignments. I like this!

Objectives for Lesson - Working w Worksheets Part 1

Working with Excel Worksheets in Excel Workbooks

From some of my recent interactions with my students, I realize that I need to reinforce the concept of working with Excel Worksheets inside an Excel Workbook.

In this Excel Tutorial, I address these three concepts:

  1. 1) Working in “Group Mode” to place content and corrections in multiple Excel Worksheets.
  2. 2) The Advantages of using Color-Coding for each Excel Worksheet Tab.
  3. 3) Using the Keyboard Combinations of Ctrl + Page Up and Ctrl + Page Down to navigate – and “activate” individual Excel Worksheets inside an Excel Workbook.

Watch this Video in High Definition  on My YouTube Channel – DannyRocksExcels

Here is the link to watch this video on my YouTube Channel

Watch My Video Now in High Definition on YouTube


How to Copy and Paste Cell Formatting Only in Excel

For the past several months, I have been teaching MS Excel online for the Continuing Education Courses at several major colleges here in the USA. It has been a great experience!.

Splash Page for Excel with ExcelOne of my clients, VanderCook College of Music, has recently adopted Schoology for their Learning Management System (LMS). This is a robust framework for presenting course work and interacting with my students!

Now, when I assign my weekly assignments to my class, I can quickly spot the common “stumbling blocks” or questions that many student have.

While I was grading my Week #1 assignments, I found that many students were unfamiliar with Excel’s AutoFill Option for “Filling the Formatting Only” in a contiguous range of cells. So, as a start to a class discussion, I created this YouTube Excel Tutorial where I demonstrate three ways to “Paste the Formatting Only” from one location to multiple locations in an Excel Worksheet.

Before I presented my course work for Week #1, I surveyed my class and realized that the majority of students were either novice or “rusty” users of Excel. Nevertheless, I find that Excel users at all levels of experience will benefit from this @ 7 minute video tutorial.

I invite you to visit my secure online shopping website – – to discover the many resources that I offer you!

Watch this Excel Video Tutorial in High Definition on my YouTube Channel – DannyRocksExcels!

Click below to watch this video now on YouTube!