The Company Rocks: Recent Episodes
Danny Rocks
When I train clients locally, this Excel Tip always gets a big round of applause. It is such a time-saver! Frequently, when you receive MS Excel data – from a Main Frame Computer or from a client or colleague, the columns are not in the order that you prefer. So … what is the normal […]
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 […]
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! From some of my recent interactions with […]
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!. One of my clients, VanderCook College of Music, has recently adopted Schoology for their Learning Management System (LMS). This is a robust framework for […]
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 10 Excel YouTube Videos Year-to-Date in 2013 Here are the Top 10 Videos that have been viewed so far (January 1 – […]
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 line of the code – using the F8 Keyboard Shortcut – to examine how the Macro Behaves […]
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 Referencing. Default Setting for Recording Macros – Absolute Cell Referencing In my experience, the first major mistake Excel Users make when […]
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 working with Macros. Here are the “4 Steps to Take Before Recording an Excel Macro:” Add the Developer […]
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 click – to add – a field that contains numeric values, it is automatically placed in the Values Zone of the […]
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 […]
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 Pivot Tables tend to “doubt the numbers” when they see these “empty cells.” What You Will Learn In my video, […]
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 levels as you need. In addition, you can now sort by Cell or Font Colors and also sort using the new […]
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 response. Use a Formula in Data Validation I have identified Data Validation as one of the “Nine Essential Skills in Excel.” […]
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 – they were asking for my help when working with Dates in their Excel workbooks. Here, in this tutorial, I […]
I believe that there are two main reasons to create and use Named Cell Ranges in Excel” They make great Navigational Bookmarks – to quickly move to a specific location in your workbook Using Named Cell Ranges in Excel Formulas make the formula: Easier to Write Easier to Explain – to others Easier to Understand […]
Learning how to select cells – and ranges of cells – efficiently, is an Essential Excel Skill. Here, I demonstrate two tips from my extended length video training resource, “Nine Essential Excel Skills.” On my DVD-ROM, I devote 13:30 minutes and two separate video tutorials to this skill. The entire DVD-ROM is nearly four hours […]
This week, I surveyed the Excel Users in my mailing list. I wanted to find out: Which version of Excel they are currently using at work? Are they using the same verion of Excel at Home as they use at work? Do thy plan to upgrade to a later version of Excel in the Next […]
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 […]
Today, two of my customers posted glowing reviews for my Excel Video Tutorials. Thank you! Thank you! Thank you! “Nine Essential Skills for Excel 2010” “In my opinion the 9 Essential Skills for Excel 2010 , is an outstanding training video. It covers a lot of the required intermediate requirements. One thing that really stands […]
A colleague of mine – who is an experienced Excel user – cannot figure out why he is receiving those ugly #N/A Error Messages when he is using the VLOOKUP Function in Excel. After a quick look at his workbook, I spotted the problem! Use the TRIM() Function to Remove Extra Spaces It turns out, […]
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 Top 10 YouTube Excel Videos Compare Two Excel Lists to Spot the Differences– 5,304 views in September Go to this Blog Post on my […]
In my previous tutorial, I demonstrated how to clear all text formatting from all slides in a PowerPoint Presentation. Several viewers contacted me about publishing a tutorial that demonstrates how to clear formatting from ranges of cells in Excel. Use the Clear Formatting Command From my experience, I had found that a great many Excel […]
One of my clients inherited a “Ransom Note” PowerPoint Presentation. I think that you can visualize what a “Ransom Note” slide looks like: Multiple Fonts at various sizes with multiple colors and effects thrown in for good measure! Ugly and, certainly, not professional. Steps to Clear All Text Formatting In my video tutorial, I demonstrate: […]
I have just published the Excel 2007 version of my latest video training resource, “Nine Essential Excel Skills.” And, I want to offer you the opportunity to watch a complete episode. This is one of the 25 video tutorials included on my video training resource. The complete package contains almost four-hours of focused Excel 2007 […]
I want you to discover the scope of the Excel Training that I offer on my new video tutorial, “9 Essential Excel 2010 Skills.” So, I am offering the PDF of the Step-by-Step Instructional Guide that accompanies the video tutorial. Link to The Company Rocks Free Resources Page Click on this link to begin the […]