Thecompanyrocks - thecompanyrocks.com - The Company Rocks
General Information:
Latest News:
2.9 Million Views for My YouTube Channel – DannyRocksExcels 20 Mar 2013 | 09:08 pm
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. Top ...
How to Edit an Excel Macro that You Recorded 13 Feb 2013 | 02:07 am
This is Part 3 in my series, “How to Record, Run, and Edit Macros in Excel.” In this episode, I demonstrate how to open up the VBA (Visual Basic for Applications) Code window and then: Step Into each ...
Excel Macros: When to Use Relative Cell Referencing When Recording 6 Feb 2013 | 10:22 pm
This is Part 2 of my new series of Excel Tutorials: “Recording, Running, and Editing Excel Macros.” In this episode, I demonstrate how and when to use either Relative Cell Referencing or Absolute Cell...
The 4 Steps to Take Before Recording an Excel Macro 5 Feb 2013 | 01:54 am
With this video tutorial, I begin a new series – “How to Record, Run, and Edit a Macro in Microsoft Excel. I’ve designed this series to introduce Intermediate Level Excel Users to the “ins and out” of...
How to Work with Numeric Values in an Excel Pivot Table 4 Jan 2013 | 07:21 pm
One of my clients contacted me with a question about Excel Pivot Tables. Specifically, about how to control a field – Employee ID – that contains numeric values. Beginning with Excel 2007, when you cl...
Excel Pivot Tables Tutorials: My YouTube Playlist 13 Dec 2012 | 08:15 pm
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 oth...
How to Prevent Empty Cells from Displaying in a Pivot Table 12 Dec 2012 | 04:59 am
In response to one of my viewers, I demonstrate how to prevent “empty cells” from displaying in a Pivot Table Report. In my experience, I have found that clients and colleagues who are unfamiliar with...
How to Use Multiple Sorting Options in Excel 21 Nov 2012 | 08:56 pm
Beginning with Excel 2007, the Sorting Commands gained several new features and became much more powerful. For example, you are no longer limited to three levels of sorting. You can sort using as many...
How to Use a Data Validation Formula When Creating a Budget 4 Nov 2012 | 03:02 pm
Recently, one of my viewers wanted to know which formula he could use to prevent an end-user from imputing a value that would exceed his budget. I created this video tutorial to demonstrate my respons...
Learn How Excel Stores and Formats Dates 28 Oct 2012 | 06:30 am
In my experience, a high percentage of Excel users run into problems when working with Dates – and Times! In fact, I estimate that, during the past two weeks, I received 25 questions from viewers – th...
