YouTube Videos By Danny Rocks | The Company Rocks

Danny October 29, 2013 Leave a Comment

4 Million Views on My YouTube Channel – DannyRocksExcels

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:”

How to Merge Multiple Excel Workbooks into a Master Budget – http://youtu.be/FZD_j3xprhg – 123,382 Views – – Posted May 14, 2010
Compare Two Excel Lists to Spot the Differences – 123,023 Views – https://www.youtube.com/watch?v=pnjcMksnU9U – Posted May 15, 2010
How to Add a Check Box Control to an Excel Form – 120,800 Views –http://youtu.be/8BTrsRFdbY8– Posted September 1, 2012
How to Use Advanced Filters in Excel – 119,955 Views – https://www.youtube.com/watch?v=C_2cjh5Pd8o – Posted on December 27, 2010
Introduction to Excel Pivot Tables – 104,662 Views – https://www.youtube.com/watch?v=1ltAoeJWDnU – Posted on August 19, 2008
How to Use an Excel Data Table for “What-if” Analysis – 103,411 Views – https://www.youtube.com/watch?v=eSRr3g6ptYY – Posted on September 15, 2010
How to Create an Interactive Excel Pivot Chart – 102,033 Views – https://www.youtube.com/watch?v=kQK_bvuEeqM – Posted on May 11, 2011
Use the Built-in Data Form in Excel – 96,079 Views – https://www.youtube.com/watch?v=6cc7lUDLrXE – Posted on December 17, 2010
How to Use the Solver Tool in Excel – 85,452 Views – https://www.youtube.com/watch?v=K4QkLA3sT1o – Posted on September 21, 2011
Import Excel Data in MS Access – 80,824 Views – https://www.youtube.com/watch?v=-aH56dxqLhg – 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 – https://www.youtube.com/DannyRocksExcels. 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 – http://shop.thecompanyrocks.com – to preview the many video training resources that I offer!

Share and Enjoy:

Filed Under: Excel Training, YouTube Videos by Danny Rocks Tagged: "What-if" Analysis in Excel, DannyRocksExcels YouTube Channel, Excel Pivot Tables, Excel Video Training, Video lessons for Excel

Danny March 20, 2013 4 Comments

2.9 Million Views for My YouTube Channel – DannyRocksExcels

This morning, I passed the 2.9 Million views milestone for my DannyRocksExcel’s YouTube Channel!

Thank you to all who have supported my Excel tutorials since I began posting them in August, 2008.

Quickly Improve Your Excel Skills

I have created many Video Tutorial Packages that I offer for sale at my secure online shopping website – http://shop.thecompanyrocks.com I invite you to visit and preview my training resources for MS Excel and the other programs in the Microsoft Office Suite.

The “Special Bundles” of videos are very attractively priced!

Share and Enjoy:

Filed Under: Access Tips and Timesavers, Conditional Formatting, Excel Data Tables and Lists, Excel Forms, Excel Training, Most Viewed Excel Videos, Pivot Tables, What-if Analysis, Work with Multiple Worksheets, YouTube Videos by Danny Rocks Tagged: "What-if" Analysis in Excel, Conditional formatting in Excel, Consolidate Excel data, Excel Form Controls, Excel Pivot Tables, Excel Video Training, MS Excel Training, Video lessons for Excel

Danny December 13, 2012 1 Comment

Excel Pivot Tables Tutorials: My YouTube Playlist

I have been organizing the video tutorials on my YouTube Channel – DannyRocksExcels – into Playlists.

I quickly realized that I have more videos (70 +) that focus on Excel Pivot Tables than on any other topic. So, having a playlist for all 70 (and growing) Pivot Table Tutorials is a great help when you need to learn about Pivot Tables. Or, simply to refresh your memory about how to use a specific Pivot Table Tool.

Scope of My Pivot Table Tutorials

I posted my first Pivot Table Tutorial on YouTube back on August 1, 2008. So far, that 7 minute Introduction to Pivot Tables in Excel 2003 has received over 90,000 views! Since then, I have created Pivot Table videos for Excel 2007 and Excel 2010.

In-Depth Focused Training for Excel Pivot Tables

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to learn about the many training resources that I offer you.

Link to My Excel Pivot Tables Playlist

Follow this link to go to my Excel Pivot Tables playlist on YouTube. If you like this Playlist, I encourage you to share it with your friends and colleagues.

Excel Pivot Tables Playlist on YouTube

Share and Enjoy:

Filed Under: Excel Training, Pivot Tables, YouTube Videos by Danny Rocks Tagged: Calculated Fields in Pivot Tables, DannyRocksExcels YouTube Channel, Excel Pivot Tables, Excel Video Training, Group Dates in Pivot Tables, Hide Details in Pivot Tables, MS Excel Training, Video lessons for Excel

Danny October 12, 2012 1 Comment

Essential Excel Skill #1: Entering Data Efficiently

My latest Excel Video Training Resource is “Nine Essential Excel Skills.” I have published versions for both Excel 2010 and Excel 2007. You can purchase them as either a DVD-ROM that I ship to you; or in a version that you can Download immediately.

Why Nine Essential Excel Skills?

As I created this Excel Video Training Resource, I had two distinct customers in mind:

Everyday Excel users who know that they could get more out of Excel if only they had a structured approach to training that used “real life” business examples.”
Experienced Excel users who want to prepare to take the Microsoft Office Specialist (MOS) 2010 or 2007 Certification Examinations for Excel.

Essential Skill #1 Video Lessons

Essential Excel Skill #1

I have identified Essential Excel Skill # 1 as “Entering Data Efficiently.” In the world of business there is a common acronym – GIGO – which means, “Garbage In delivers Garbage Out.” In order to produce accurate and meaningful reports in Excel, you MUST begin with data that is entered correctly.

Entering Time and Date Values

In my experience, many Excel users incorrectly enter Time values and Date values. Times and Dates are “Numeric Values.” When Time and Date Values are entered correctly, they align to the right-side of the cell. Once they are entered correctly, you can change their formatting to suit your purpose.

Keyboard Shortcuts for Current Date & Time

Ctrl + ; (semi-colon) enters the Current Date into the cell. This creates a “Date Stamp.”
Ctrl + Shift + : (colon) enters the Current Time into the cell. This creates a “Time Stamp.”

AutoFill Options – Weekdays Only

Speed Up Data Entry with AutoFill Options

Use AutoFill to quickly – and accurately – fill in the Months of the Year and the Days of the week. I demonstrate – in detail – how to take advantage of the many AutoFill Options that are available. For example, to AutoFill Weekdays Only! I am confident that you will gain many productivity tips from the video tutorials in this Skills chapter.

Fill Series Dialog Box

Many Excel users have never used the “little gem” that is the Fill Series Dialog Box. As you will learn in the video tutorial, you can quickly fill in a long series of numeric values by using the “Step Value” and “Stop Value” fields in this dialog box.

Download the Complete Step-by-Step Instruction Guide – for Free!

I am so confident that you will want to purchase my video training resource, that I am offering you the opportunity to download – for Free! – the 29 page Instruction Guide that is included in “Nine Essential Excel Skills.” Click on the link to begin to download either version as a PDF:

Learn More About My Video Training Resources

My “Master Excel in Minutes – Not Months” series of video training resources is growing quickly! Follow this link to see the resources that are available now!

Watch My Excel Tutorial in High Definition

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

Watch Video Tutorial Now

Share and Enjoy:

Filed Under: Essential Excel Skills, Excel Basics, Excel Training, Keyboard Shortcuts, YouTube Videos by Danny Rocks Tagged: AutoFill Options, Excel Keyboard Shortcuts, Excel Video Training, Fill Series in Excel, Keyboard Shortcuts in Excel, Learn to use AutoFill in Excel, Video lessons for Excel

Danny October 2, 2012 Leave a Comment

The 10 Most Watched Excel YouTube Videos for September 2012

My YouTube Channel – DannyRocksExcels – had 141,586 individual views during the month of September 2012:

Here is a list – with Hyperlinks – to the 10 Most Watched Excel Videos

Thanks to my 4,500 Subscriber on YouTube!

I extend my heartfelt thanks to my many loyal viewers and subscribers to my Excel video tutorials. Your feedback and requests for solutions have formed the foundation for my Excel Training Videos.

9 Essential Excel 2010 Skills

Learn More About my Extended Length Excel Video Training Resources

I have created a series of Extended Length Video Training Resources in the category of “Master Excel in Minutes.” I invite you to follow this link to learn more about my new series of videos.

Share and Enjoy:

Filed Under: COUNTIF and SUMIF Functions, Excel Data Tables and Lists, Excel Forms, Excel Formulas, Excel Functions, Excel Training, Lookup Functions in Excel, Most Viewed Excel Videos, Pivot Tables, SUMIF and SUMIFS Functions, Workbooks and Worksheets in Excel, YouTube Videos by Danny Rocks Tagged: "What-if" Analysis in Excel, Excel Pivot Charts, Excel Pivot Tables, Excel Video Training, Solver Tool in Excel, Video lessons for Excel

Danny August 17, 2012 1 Comment

DannyRocksExcels on YouTube Recognized as a Top 10 Channel for MS Excel Tutorials

See the Complete List – Top 10 YouTube Channels

Click here to see the list of the Top 10 YouTube Channels for Excel Tutorials. I am honored to be included in this list!

Visit My YouTube Channel – DannyRocksExcels

I invite you to visit my DannyRocksExcels Channel on YouTube.

DannyRocksExcels on YouTube

As of today, I have published 250 Video Tutorials on YouTube. Many of my videos can be viewed in High Definition.

My videos have been viewed nearly 1.9 million times and my list of subscribers is close to 4,000.

My Top 10 Videos – The Last 7 Days

Here is a list of the 10 Most Viewed Excel Tutorials at DannyRocksExcels over the last 7 days – dating back from August 17, 2012. I have created Hyperlinks for each video. Just click on the title that you want to watch on YouTube:

Shop at My Secure Online Website

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to preview all of the Training Resources that I offer you.

Share and Enjoy:

Filed Under: Excel Training, Most Viewed Excel Videos, MS Excel Tips, MS Excel Training, YouTube Videos by Danny Rocks

Danny August 13, 2012 3 Comments

How to Combine 2 Excel Workbooks Using VLOOKUP Function

VLOOKUP Function Arguments

I created this video tutorial to assist one of my viewers. He had 2 Excel Workbooks that he needed to combine. Because he had a MemberID Field in each workbook, I decided that the VLOOKUP() Function would be the fastest way to complete this task for my viewer.

Tips Covered in this Video

Move or Copy a Worksheet to another Excel Workbook
Use a Mixed Cell Reference – e.g. $A4 – so that column “A” reference is “frozen” when copying formula
Create “Named Range” to use as the “Table_Array” argument in VLOOKUP
Use FALSE as 4th (optional) argument in VLOOKUP to produce an “exact match”
Use IFERROR to prevent “error messages” from displaying

Watch this Video in High Definition

Click on this link to watch this Excel Tutorial in High Definition on my YouTube Channel – DannyRocksExcels

Learn About My Training Resources

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to learn about the many training resources that I offer for sale.

Watch Tutorial Now

Share and Enjoy:

Filed Under: Excel Functions, Excel Training, Names for Cells and Ranges, YouTube Videos by Danny Rocks Tagged: Exact Match for VLOOKUP, Excel Keyboard Shortcuts, Excel Video Training, Formula Errors, IFERROR Function, Mixed Cell Reference, Move or Copy Sheet, Named Cell in a formula, Named Cells and Ranges, Video lessons for Excel, VLOOKUP Function

Danny August 9, 2012 1 Comment

How to Use Excel’s Histogram Tool and The 80/20 Rule of Analysis

Excel Histogram Charts

This is the Third – and final – episode in my “Creating Frequency Distribution Reports in Excel” series of tutorials. In this episode, I demonstrate a very powerful – and very easy to use – analysis tool – The Histogram Tool.

Excel’s Analysis ToolPak “Add-in”

This tool is included in the Analysis ToolPak which is an “Add-in” program within Excel. Beginning with Excel 2007, the Analysis ToolPak is automatically included in a basic installation of Excel. However, if you are using an earlier version of Excel or if, somehow, this Add-in has been disabled, I show you how to “activate it.”

Advantages of Using Excel’s Histogram Tool

No Formulas to write
Results are Numeric Values – not Formulas
Chart(s) can be added automatically
Multiple Chart Options
Pareto Chart Option

What is a Pareto Chart?

Pareto Analysis is commonly known as “The 80 / 20 Rule.” A brief explanation is: Roughly 80% of your sales come from only 20% of your customers or 20% of your products. I like to say, “You can focus on the Vital Few and not on the Trivial Many,” when you use Pareto Charts. As you will see in my video, when you choose the Pareto Chart option, the Histogram automatically sorts the Frequency Field in descending order and charts this field.

Links to All Videos in Frequency Report Series

Group by Age Bracket in an Excel Pivot Table
- Watch in High Definition on YouTube
Use an Array Function – Frequency – to Generate Frequency Report
- Watch in High Definition on YouTube
Use Excel’s Histogram Tool to Generate Frequency Report and Chart
- Watch in High Definition on YouTube

Improve your Excel Skills – My Video Tutorials

I invite you to visit my secure online shopping website to see the many training resources that I offer. For example, click here to learn about my best-selling DVD-ROM, “The 50 Best Tips for Excel 2007.”

Follow The Company Rocks on Facebook

You can now follow me on Facebook – www.facebook.com/TheCompanyRocks

Share and Enjoy:

Use the Histogram Tool in Excel [ 7:46 ] Play Now | Play in Popup | Download (2696)

Filed Under: Excel Charts, Excel Training, Podcast Tips & Timesavers, YouTube Videos by Danny Rocks Tagged: Analysis ToolPak for Excel, Bins for Frequency Report, Excel Add-ins, Frequency Report in Excel, Histogram Charts, Histograms in Excel, Pareto Chart in Excel, The 80/20 Rule

Danny August 6, 2012 3 Comments

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

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!

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

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

Share and Enjoy:

Filed Under: Excel Training, Most Viewed Excel Videos, Online Store for The Company Rocks, Video Training Courses, YouTube Videos by Danny Rocks Tagged: "What-if" Analysis in Excel, Advanced filter an Excel data list, Consolidate Excel data, DannyRocksExcels YouTube Channel, Excel Forms, Excel Pivot Tables, Excel Training Videos on YouTube, Lookup Functions in Excel, Top Rated Excel Videos on YouTube, VLOOKUP Function

Danny August 3, 2012 1 Comment

How to Use an Array Function in Excel – Learn How to Use the Frequency Function

In my experience, most of the people who I train have never heard of – let alone use – Array Formulas and Functions in Excel. However, once I demonstrate how they work, they become “hooked” and want to learn more about these “Magic Formulas!” In this tutorial, I demonstrate, “step-by-step” how to use the FREQUENCY() Function in Excel.

Previous Tutorial on The Company Rocks Website

If you watched my previous tutorial, I used the same data set and a Pivot Table to Group these 500 plus Sample Records by Age Bracket. Using a Pivot Table, you can quickly “group” ages into brackets – without writing a single formula! However, on the down side, you must use a consistent “step-value” for these groupings – in this case by 10 years. When you need more flexibility in organizing your Age Brackets, use the Frequency Function in Excel.

How to Use the FREQUENCY() Function in Excel

Create your “Bin Array.” In this example, enter – in ascending order – the ages that you want to find the “frequency of occurrences” between
Select the “Array of Cells” that will contain your FREQUENCY() Function results.
Write the FREQUENCY() Function – 1st argument is the “Data_array”. In this case, I created a Named Cell Range called “Age.” this is mu “Best Practice Tip!”
The 2nd argument is the “Bin_array.” Choose the vertical range of cells that you created in step 1 of this list. Make sure that the “size” of this Array matches the “size” of your Array Formula Selection.
Complete the Array Function with the keyboard combination of “Ctrl + Shift + Enter.” This “CSE” combination is essential when entering all Array Formulas and Functions!

My Secure Shopping Website

I invite you to visit my secure shopping website – http://shop.thecompanyrocks.com – where you can preview all of the training resources that I offer. If you want to learn more about formulas and function, I offer a great resource: “The 50 Best Tips for Excel 2007.” Regardless of the version of Excel that you are currently using, you will pick up many great tips to improve your Excel skills!

Watch Tutorial in High Definition

Follow this link to watch this Excel Tutorial in High Definition on my YouTube Channel – DannyRocksExcels.

View My Tutorial Now on YouTube

Share and Enjoy:

Filed Under: Excel Functions, Excel Training, YouTube Videos by Danny Rocks Tagged: Array Formulas in Excel, Bin Array for Frequency Function, Ctrl + Shift + Enter for Array Formulas, Curly Braces for Array Formulas, Excel Functions, Excel Video Training, FREQUENCY Function in Excel, Video lessons for Excel

Danny Rocks “Training You to Excel”

Follow Danny on Social Media

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

Watch My Excel Tutorials in High Definition on My YouTube Channel

Visit My Secure Online Shopping Website

Top 10 Excel YouTube Videos Year-to-Date in 2013

Quickly Improve Your Excel Skills

Scope of My Pivot Table Tutorials

In-Depth Focused Training for Excel Pivot Tables

Link to My Excel Pivot Tables Playlist

Excel Pivot Tables Playlist on YouTube

Why Nine Essential Excel Skills?

Essential Excel Skill #1

Entering Time and Date Values

Keyboard Shortcuts for Current Date & Time

Speed Up Data Entry with AutoFill Options

Fill Series Dialog Box

Download the Complete Step-by-Step Instruction Guide – for Free!

Learn More About My Video Training Resources

Watch My Excel Tutorial in High Definition

Watch Video Tutorial Now

Top 10 YouTube Excel Videos

Thanks to my 4,500 Subscriber on YouTube!

Learn More About my Extended Length Excel Video Training Resources

See the Complete List – Top 10 YouTube Channels

Visit My YouTube Channel – DannyRocksExcels

My Top 10 Videos – The Last 7 Days

Shop at My Secure Online Website

Tips Covered in this Video

Watch this Video in High Definition

Learn About My Training Resources

Watch Tutorial Now

Excel’s Analysis ToolPak “Add-in”

Advantages of Using Excel’s Histogram Tool

What is a Pareto Chart?

Links to All Videos in Frequency Report Series

Improve your Excel Skills – My Video Tutorials

Follow The Company Rocks on Facebook

Top 10 Most Viewed Videos – January thru July, 2012

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

The 50 Best Tips, Tricks & Techniques Series

100% Satisfaction Guaranteed!

Previous Tutorial on The Company Rocks Website

How to Use the FREQUENCY() Function in Excel

My Secure Shopping Website

Watch Tutorial in High Definition

View My Tutorial Now on YouTube

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