English
Search

Danny Rocks Excels
Guru
DannyRocksExcels
Style: Educational
Joined: August 05, 2008
Last Sign In: 1 month ago
Videos Watched: 197
Subscribers: 172
Channel Views: 4,596
I train executives, individuals and groups to improve their skills in MS Excel, PowerPoint and Word.

My training is focused on improving your productivity and effectiveness - not on learning every "bell & whistle" that these programs offer.

To see all of my video lessons and to learn more about my training services, I invite you to visit my website:

http://thecompanyrocks.com/...
Name: Danny
I speak to, train, and consult with individuals, groups, organizations, and associations throughout the world.

I established The Company Rocks in 2006. After a distinguished 30-year career as an executive in the music products industry, I wanted the freedom to expand my service offerings to other industries. I love training and my enthusiasm for teaching helps to produce positive results for my clients.

In an earlier career, I played piano for and conducted Broadway shows in NYC.
City: Los Angeles
Hometown: Philadelphia
Country: United States
Occupation: Training, Speaking, Consulting
Companies: The Company Rocks
Interests and Hobbies: Playing the Piano, Reading, Leisure Travel
Music: The Great American Songbook (Gershwin, Kern, Rodgers and Hart, Porter, etc.)
Website: http://www.thecompanyrocks.com
Connect with DannyRocksExcels
Send MessageSend Message
Add CommentAdd Comment
Share ChannelShare Channel
Add to iGoogle
http://www.youtube.com/DannyRocksExcels
Embed This Channel:
<script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=DannyRocksExcels&amp;container=youtube&amp;w=320&amp;h=390&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"></script>
Recent Activity  
DannyRocksExcels uploaded a new video (3 months ago)
Have you ever asked five people to enter a list of your Customers into a...   more
 
 
DannyRocksExcels commented on Group Months into Quarters ... (3 months ago)
"Thank you for your comments Jeremy. I will check out the site that you m..."   more
 
 
DannyRocksExcels uploaded a new video (3 months ago)
Calculated Items in Excel Pivot Tables can produce incorrect results in ...   more
 
 
DannyRocksExcels subscribed to JPX2Consulting (3 months ago)
 
 
DannyRocksExcels uploaded a new video (3 months ago)
It is easy to create new fields in a Pivot Table. In this video lesson I...   more
 
Playlists
Excel Pivot Table Videos
6 videos
Excel Pivot Table Videos 6 Videos
I have collected all of my video lessons on Pivot Tables here. Pivot tables are one of Excel's most powerful features - and they are very easy to learn how to use!
Play All Share
Excel 2003 Basics
2 videos
Excel 2003 Basics 2 Videos
The videos in this Playlist focus on helping you with "The Basics" of MS Excel 2003.

How to enter and format data in your spreadsheet. How to write formulas. How to find the proper function to produce the results that you are looking for.

Everthing that you need to move forward with Excel
Play All Share
What-if Analysis in Excel
5 videos
What-if Analysis in Excel 5 Videos
Want to find out your monthly payment on a loan if the interest rate changes? Want to be completely prepared with 3 alternatives before you finance your next car loan?

What if you know the answer - that you want - but you are not sure how to structure in formula?

Let's play "What-If" in Excel!

I invite you to visit my website to view all of my Excel training videos -
http://thecompanyrocks.com/excels
Play All Share
Subscribe to DannyRocksExcels's videos
Videos (66)
What-if Analysis in Excel with a 2-input data table
4:15
[TRANSLATED] What-if Analysis in Excel with a...
[TRANSLATED] What-if Analysis in Excel with a 2-input data table
Create as many "what-if" analysis scenarios as you wish - with just one formula! ...
11 months ago 4,644 views DannyRocksExcels
Use Excel's VLOOKUP Function to Build an Invoice
5:11
[TRANSLATED] Use Excel's VLOOKUP Function to ...
[TRANSLATED] Use Excel's VLOOKUP Function to Build an Invoice
Vertical Lookup (vlookup) functions are a part of every day business life. It is h...
11 months ago 2,275 views DannyRocksExcels
The =SUMIF() Function in Excel
4:31
[TRANSLATED] The =SUMIF() Function in Excel
[TRANSLATED] The =SUMIF() Function in Excel
What if? What if sales are less than expected? What is my exposure? The =SUMIF(...
11 months ago 1,533 views DannyRocksExcels
3 Reasons to Use Audting Tools in Excel 2003
5:55
[TRANSLATED] 3 Reasons to Use Audting Tools i...
[TRANSLATED] 3 Reasons to Use Audting Tools in Excel 2003
Reason #1 - To discover all of the cells that feed in and out from your formulas. ...
10 months ago 690 views DannyRocksExcels
3 Reasons to Use Named Cells in Your Excel Formulas
6:24
[TRANSLATED] 3 Reasons to Use Named Cells in ...
[TRANSLATED] 3 Reasons to Use Named Cells in Your Excel Formulas
Reason #1 - They make your formulas easier to explain and understand Reason #2 - ...
10 months ago 757 views DannyRocksExcels
Introduction to Excel Pivot Tables
7:00
[TRANSLATED] Introduction to Excel Pivot Tables
[TRANSLATED] Introduction to Excel Pivot Tables
Are you curious about Pivot Tables? But... you are a little intimidated by the tho...
10 months ago 5,480 views DannyRocksExcels
Use Goal Seek in Excel to Structure Your Loan
5:12
[TRANSLATED] Use Goal Seek in Excel to Struct...
[TRANSLATED] Use Goal Seek in Excel to Structure Your Loan
You calculated your loan payment only to find out that it is more than your budget...
11 months ago 1,507 views DannyRocksExcels
Paste Special Options in Excel Save You Time!
7:28
[TRANSLATED] Paste Special Options in Excel S...
[TRANSLATED] Paste Special Options in Excel Save You Time!
I love the time-saving options available in the "Paste Special" dialog box! In thi...
10 months ago 553 views DannyRocksExcels
Create an Excel Chart with One Keystroke!
4:01
[TRANSLATED] Create an Excel Chart with One K...
[TRANSLATED] Create an Excel Chart with One Keystroke!
Excel makes it easy to create charts that graphically represent your data. So easy...
9 months ago 346 views DannyRocksExcels
Functions to Manipulate Text Strings
How to catch text hiding as a number in Excel
August 25, 2008, 06:20 PM
You want to avoid "GIGO" - Garbage in, Garbage Out. You also want to avoid mistating revenue or sales or investment returns. Whenever I am given data from a source that I have not verified, I perform two quick audit tasks. Watch this short video to see how to catch te...

Permalink
2:33
Added: 11 months ago
From: DannyRocksExcels
Comments: 0
Views: 215
Rate this video

1 ratings
Please sign in to rate this video.
Excel's TRIM function removes extra spaces in cells
August 25, 2008, 06:20 PM
Use the =TRIM() Function to remove extra spaces in your cells. How did you get those extra spaces? Possibly, when you combined multiple text strings into a combined cell. Does it matter? You just want to remove the unwanted extra spaces. Watch this video lesson to lea...

Permalink
4:20
Added: 11 months ago
From: DannyRocksExcels
Comments: 1
Views: 707
Rate this video

0 ratings
Be the first one to rate this video!
Subscribe To Favorites
Favorites (5)
How to Create Custom Shows in PowerPoint
3:21
[TRANSLATED] How to Create Custom Shows in Po...
[TRANSLATED] How to Create Custom Shows in PowerPoint
The custom show feature allows you to create multiple, customized PowerPoint shows...
no rating 10 months ago 208 views DannyRocksPowerPoint no rating
Microsoft Excel - Automatically color alternating rows
9:27
[TRANSLATED] Microsoft Excel - Automatically ...
[TRANSLATED] Microsoft Excel - Automatically color alternating rows
http://Excelopedia.com presents a tutorial describing how to use Microsoft Excel's...
1 year ago 19,982 views Excelopedia
Tony Melendez, english subtitles, vd.selfip.com
6:01
[TRANSLATED] Tony Melendez, english subtitles...
[TRANSLATED] Tony Melendez, english subtitles, vd.selfip.com
Tony Melendez, english subtitles. Please, send any comments, demands, etc, in my i...
1 year ago 1,324,331 views juvdm
Summarize by Year, Quarter & Month with Pivot Tables
5:42
[TRANSLATED] Summarize by Year, Quarter & Mon...
[TRANSLATED] Summarize by Year, Quarter & Month with Pivot Tables
Would you like to make sense out of a long list of daily sales records? Of cour...
no rating 10 months ago 583 views DannyRocksExcels no rating
Excel's Conditional Formatting Dynamically Highlights Data
5:30
[TRANSLATED] Excel's Conditional Formatting D...
[TRANSLATED] Excel's Conditional Formatting Dynamically Highlights Data
I like to use Excel's Conditional Formatting to: 1) Dynamically highlight the cel...
10 months ago 1,222 views DannyRocksExcels
Channel Comments (2)
DannyRocksExcels (3 months ago)
Thank you for your kind comments. I appreciate you taking the time to write to me.

Danny Rocks
www.thecompanyrocks.com
tirathmistry (3 months ago)
Dear Danny
Thanks so much for your kind effort for making such a valuable excel tutorial videos on youtube
Love to your tutorial Videos
You are Awesome tutor also