My Most Viewed and Downloaded Videos for Excel and PowerPoint

My iTunes Podcast

Danny on iTunes

I began to post my videos as podcasts at the iTunes store this past summer. Since then, my video lessons for Excel and PowerPoint have been viewed and downloaded many times. I am thirlled. And, I thank you for your support and encouragement.

Here are the links – on my website – to the most popular video episodes. I have organized them by category in the order of their popularity. You can click on any link to view or download that video from my website. Or, you can go to my video Podcast by clicking on this link – “Danny Rocks Tips and Timesavers” Podcast on iTunes.

Merging and Consolidating Excel Worksheets

 PowerPoint Presentations

Data Visualizations

What-If Analysis in Excel

Importing Data From Other Programs

Pivot Tables

Excel Tables

Social Media

Formula Errors

Please add your comments below – or on my iTunes Channel. I welcome your feedback.

You can learn how to “Master Excel in Minutes – Not Months!”

Sincerely,

Danny Rocks

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

My Published Articles Available on Ezine Articles

I am proud to announe that I currently have six articles published on the Ezine Articles Website. As you can see, I have earned the title, “Expert Author.” Simply click on the “Icon” below to go directly to my author page. Or, you can click this link to go to my main page.


Danny Rocks, EzineArticles.com Basic Author

I will be publishing one article each week on the Ezine Articles website, so check back frequently to see what I am writing about. You can download the articles and you can also forward them to a friend.

Here are the direct links to the individual articles that you can read right now:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Statistics Do Not Tell Complete Story

Recently, I was asked to contribute an article on persuasion to another blog. It is a text article. And, I like the way that it turned out.

Here, is a video presentation of that article. Increasingly, I am inclined to contribute video blogs – in addition to traditional text blogging. Both forms of blogging are attractive and each attracts its own audience.

I am interested in hearing your thoughts on both: the topic of video vs. text blogging and on the content of this blog on persuasion.

Here are the Words per Minute Statistics for this article.

  • @475 words.
  • Length is 3:27 minutes
  • WPM Count = 136 – This is slower than my “normal” WPM count of 160.
Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

An experiment – do you prefer the written article or the spoken PowerPoint?

The Written Word

Yesterday, I published an article – “How Many Words per Minute (WPM) Do You Speak?”

The Spoken Word

Today, I recorded a PowerPoint presentation based on that article – “Did I Get My WPM Count Just Right?

Both postings discuss the same topic – How fast or slow do you speak? What is your spoken words-per-minute (WPM) count. Each posting offers a different experience.

I had a different experience while creating and recording the PowerPoint presentation. I needed to add extra words to assist the viewer. Both the video and the article are designed to “stand alone.” However, I felt that the video “needed more explanation.” I had to remember that the viewer could hit the “back button control” on their web browser at any moment!

Write Your Presentations / Practice Speaking Your Words

Perhaps it was just the experience of speaking my written words aloud. A practice that I recommend that all writers and editors try at least occasionally. Perhaps it was just me “wishing that I had taken more time in editing yesterday’s article.” A case of “writer’s remorse?

I hope that you will take some time to read the article AND to view the PowerPoint presentation. I welcome your feedback. Which medium did you prefer – and why? What would you like to see more of? Less of?

Please add your comments below. Or you can email your comments to me – danny@thecompanyrocks.com

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

It takes a lot of practice to become a natural speaker

There is a very unflattering picture of Sen. John McCain in this morning’s edition of The New York Times.

Before you jump to any conclusions … This is not a political blog. And the picture in the paper was chosen intentionally – to illustrate a specific point:

Sen. McCain is not a natural orator. His speaking technique is below average. He should avoid standing behind a lectern whenever he delivers a speech.

His “off-the-cuff” candor when speaking is a closed setting was enough to get him to this point in the campaign.

His stiff, under rehearsed, forced style of speaking in larger settings will not get him to where he wants to go – to be elected President.

In my opinion.

The NY Times article by Mark Leibovich is an excellent case study about the realities of speaking in public today – in the real world of “YouTube” moments. A world where every mistep and every malaprop is monitored, magnified, and memorialized.

What is a candidate to do? What should you do – to minimize the possibility of a “YouTube moment” sabotageing your career?

Practice, practice, practice!

“Every great shot you hit, you’ve already hit a bunch of times in practice.” – Martina Navratilova

Make you mistakes during your practice sessions. Speak your key phrases aloud. Over and over again. To the point that you, personally,  can no longer stand listening to your speech. That’s how much you have to practice if:

  • you want to become a natural speaker
  • you want your audience to respond favorably to your speech
  • you want to avoid a “YouTube” moment like the one that Sen. McCain created for himself

To quote from Mark Leibovich’s NYT article:

“But when Mr. McCain, the presumptive Republican presidential nominee, came to the intended sound bite of his speech — the part about reducing America’s dependence on foreign oil — he hit a slick.

“I have set before the American people an energy plan, the Lex-eegton Project,” Mr. McCain said, drawing a quick breath and correcting himself. “The Lex-ing-ton Proj-ect,” he said slowly. “The Lexington Project,” he repeated. “Remember that name.”

In a town meeting in Cincinnati the next day, Mr. McCain would again slip up on the name of the Massachusetts town, where, he noted, “Americans asserted their independence once before.” He called it “the Lexiggdon Project” and twice tried to fix his error before flipping the name (“Project Lexington”) in subsequent references.

Mr. McCain’s battle of Lexington is part of a struggle he is engaged in every day. A politician who has thrived in the give-and-take settings of campaign buses, late-night TV couches and town meetings, he now is trying to meet the more formal speaking demands of a general election campaign.”

Unless Sen. McCain seriously commits himself to a program to improve his public speaking … Well, let’s just remind him of how President George W. Bush’s continued  mispronunciation of the word “nuclear” has solidified his image – and it is not a image that I would want for myself.

Practice is not fun. Nor is it fun to watch or listen to a recording littered with “awkward speaking moments.”

Especially, when you are the one who did the speaking!

Related Articles:

“Practice your responses” 

“Why do politicians fumble Q & A sessions?”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Introducing My PowerPoints Blog!

As I continue to develop content for The Company Rocks I am creating specialized blogs to meet your specialized needs.

Introducing the new PowerPoints blog – http://www.thecompanyrocks.com/powerpoints

The focus for this blog is to offer tips that help you to improve your communications skills.

Yes, I will share tips and techniques to help you get the most our of MS PowerPoint. But, this is not a blog that is limited to MS PowerPoint.

MS PowerPoint is just one tool that you may use to help you craft and deliver a powerful message.

Remember these PowerPoints:

Your MS PowerPoint slides are not your message

MS PowerPoint does not deliver your message. You do!

Therefore, the tips and techniques that I share with you to get the most out of MS PowerPoint have a unified message:

“How will this tip help me to make a Powerful Point?”

Click here to visit the PowerPoints blog.

I have posted my first video lesson on the blog. Check back frequently for new articles and video demonstrations.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

A "Reversible Raincoat" – What a great term!

“Ask not what your country can do for you. Ask, what you can do for your counrty.”

– John F. Kennedy

By now, you must realize that I love to collect quotations. I use them often in my writing and public speaking. I like the “rhythm” of certain quotes.  Expescially those that juxtapose a key word. For example, the quote from President Kennedy’s Inaugural address that open up this posting.

Here is another example from President Kennedy:

“Let us never negotiate out of fear but let us never fear to negotiate.” – John F. Kennedy

Now, I find out that speechwriters have coined a term to describe this type of literary device. They call it the “reversible raincoat.” I love it! It is so descriptive.

And when it is used judiciously, this device vividly describes a concept. For example:

  • “People never care how much you know until they know how much you care.” – John C. Maxwell
  • “An optimist sees an opportunity in every calamity; a pessimist sees a calamity in every opportunity.” – Winston Churchill

So how did I discover this rich term – the “reversible raincoat?” In the current issue of Business Week magazine, columnist Carmine Gallo uses some exceprts from Theodore Sorenson’s new book, Counselor as the basis for his article. Sorenson was President Kennedy speechwriter. Read Carmine’s article it is a good one!

I admit to reading a few excerpts from this book but had never discovered the “reversible raincoat” terminology. Now I must buy the book! I need to know more about this term and I want to gather some more “insider” information.

In doing some research on the Internet I came across this article. The formal term to describe this literary device is “Chiasmus.” Yes, that is a descriptive term. But it paints a different picture in my mind. One involving a visit to my physician.

I prefer the “reversible raincoat.”

And now I have another story to share with my audience. Thank you Messers. Sorensen and Gallo!

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Learn to control your finger pointing

Bill CLinton Finger PointingDon’t point your finger at me! I don’t like it. I especially don’t like it when you “wiggle”your finger” in my face.

Most people share my feelings. Who likes to be publicly scolded?

Why do I  – and others – have such a strong reaction to this gesture? According to Carol Kinsey Goman in “The Nonverbal Advantage: Secrets of Body Language at Work,”

“… I’ve often seen politicians and executives use this gesture in meetings, negotiations, or interviews for emphasis or to show dominance. The problem is that rather than being a sign of authority, aggressive finger pointing (with one or four fingers) suggests that the person is losing control of the situation, and it smacks of playground bullying.”

  • Losing control of the situation
  • Smacks of playground bullying

These are hardly signs of strength and authority! Certainly not what the speaker intended. What about the “finger-pointer-in-chief” – former President Bill Clinton? What is he actually communicating, non-verbally – when he wags his index finger at a reporter or at someone in the audience?

That he is losing control of the situation. That he is trying to be overly aggressive; trying to intimidate; trying to regain control of a situation that is quickly deteriorating.

It is not a gesture of strength. And… once we realize what this nonverbal communication is really telling us, how do we feel about the speaker who is wagging their finger at us?

Well, what did the playground bully do once you called him or her on their actions? They immediately backed down. They demonstrated that they had lost control and that they never had the power to intimidate you.

Unfortunately, most of us never call a “powerful” politician or business executive on their actions. Why not? Perhaps this is because (unfortunately) few of us ever called a schoolyard bully on their actions.

We may suspect that this is just a “fit of anger.” That is just an “act.”

It is an act – an act of desperation!

Once we understand and learn to correctly interpret a person’s “body language” we can turn this “acting” to our advantage. We can gain leverage during our negotiations. We can gain the “nonverbal advantage!”

Of course, we must look at the context of the gesture. An isolated instance of finger pointing does not signal “losing control.” However, combined with a flushed face and an elevation in the pitch of the voice and the use of deliberate language… Now that is telling us something about the “finger pointer.” It is quite revealling about their real feelings. About their loss of control. About their bullying behavior.

Certainly, he is not the only “finger-pointer,” but why doesn’t former President Clinton take steps to minimize his finger-pointing?  Why doesn’t one of his close aides or family members “point this out” to him? (Pun intended!)

Why do playground bullies persist? Why do business executives seem to get away with this kind of behavior? Why do so many parents lose control of a situation when talking with their children?

Why?

Now that you have gained some insight into how to interpret this angry gesture, will you react differently the next time?

Maybe yes. Maybe no. Even if you do not react differently – by calling them on their finger pointing, at least you now know that “finger pointing” is just a mask for someone losing control of the situation. Someone who is possibly hiding something. Someone who is afraid.  If you react properly, you can turn this to your advantage. You can gain the upper hand – not just the fingers!

To read a related article that I published on this subject, click here.

Please share your comments about “finger pointing” with our readers. Add your comments below.

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Practice your responses

“Practice doesn’t make perfect, nor is it supposed to. Practice is about increasing your repertoire of ways to recover from your mistakes.”

– Joan Gutin

Mistakes happen. And… they will continue to happen in the future. But… it is a huge mistake if you fail to learn from your mistakes. Especially in the way that you respond to your mistakes.

What can you anticipate? What is likely to occur? How will you respond when it does occur?

Have you thought about your response? Have you practiced your response? If not, why not?

Originally, I planned this post as a follow-up to my previous one – “Why do politicians fumble Q & A sessions?  But then, I thought about this in a broader sense. I am constantly amazed to observe the number of people who:

  • Fail to anticipate sales objections – and to prepare their response.
  • Fail to address risk factors for their projects – and lack a Plan “B” to go forward when they do occur.
  • Fail to offer coaching and feedback to their staff – and wonder why they don’t achieve better results.

It is one thing to anticipate events and to prepare a plan to address to address them. It is quite another to actually practice the words that you will say during your response. To articulate them. To speak them aloud – and with confidence and conviction!

Words alone are insufficient in getting your message across. How you speak the words – your tone of voice – is the key to how your words are received and acted upon.

When I hear a politician – or any speaker – stumble over their words during a Q& A Session, I question their sincerity. I question their truthfullness. I question them.

Why? Because I get the feeling that they are “making it up as they go along.” That their response will be different the next time that they are asked this same question.

It is not what you say but, rather, how you say it that counts.

Let me give you an example. I am a musician. I can play a piece of music on the piano – hitting all of the correct notes. But, my performance will be flat and uninspired if I have not practiced – and internalized – my interpretaion of those notes. I need to practice not just hitting the correct notes, but also striking the right tone – for that piece and for my audience.

Speaking is no different. Sales is no different. Asking your staff to change is no different.

Learn how you can be different. Practice your responses!

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Why do politicians fumble Q & A sessions?

Senator Hillary Clinton does it. Senator Barack Obama does it. Many people – not just politicians – do it.

What do they do? They stumble and fumble their answers during debates and Question & Answer (Q & A) sessions.

Why? Well, one easy answer is that they fail to make time to:

  1. Anticipate the questions that they will be asked.
  2. Formulate their answers to these questions – especially the “sticky” ones – the ones that will be repeatedly played on the 24-hour cable news stations and on the Social Media internet channels.
  3. Practice their answers – articulate them – speak them – master them – comunicate them.

As I write this, I have been packing my suitcase and listening to MSNBC repeatedly replaying Sen. Clinton’s crude, clumsy, possibly inflammatory response, ina USA Today interview, as to why she appeals to a broad-based coalition of voters. I lost count of the number of “Ahs,” “Ers,” and “Uhs” in her response.  (Click here to read the interview and also access the audio portion.) Why? Is this the image she really wants to project?

And, Sen. Obama also deserves criticism – why doesn’t he put more time into preparing for his debate performance? Why does he come across as “defensive” or “offended” when he is questioned about his core beliefs? Why does he find it so difficult to articulate his response to difficult questions? (Click here for a linkto an excellent video analysis of Sen. Obama’s weak spots during questioning.)

Surely, Sen. Obama knows that these questions are coming. Why doesn’t he put more time into preparing for them?

Surely, Sen. Clinton must know that her answers will be replayed constantly on TV, on YouTube, on the radio. Why doesn’t she put more time into crafting her response?

Why do they continue to fumble and stumble with their answers during Q & A?

It makes me uncomfortable when I listen to their answers. I have to turn away from the “train-wreck” that is about to occur during the debates – I see their blank stares forming, I feel their cold sweat soaking their shirts and blouses… Why? Why? Why?

Why do they make me feel so uncomfortable during their Q & A sessions? Why do I doubt what they say? Why do I question their core beliefs?

Which candidate am I to believe? The candidate who masterfully delivers their stump speech? Or the candidate who appears completely lost and confused when answering a direct question?

It’s the stumbling and fumbling that they go through trying to get the words out that causes me to feel so uncomfortable. And… I do not think that I am the only one who feels this way. How do you react?

Why don’t their trusted advisors take them aside and say, “Senator, it is time to prepare your responses. It’s time to rehearse. It’s time to practice voicing your answers- forming the words and speaking them out loud.”

Don’t fall into this trap! 

  • Anticipate the questions that you expect to be asked; especially the difficult ones!
  • Gather your thoughts and formulate your response. Put it in writing first if necessary.
  • Practice articulating your response. Say the words – speak them aloud. Record your response if at all possible.
  • Ensure that you have reserved enough time for these practice sessions.
  • Work with a speech coach or a trusted advisor.

Q & A usually comes at the end of a presentation. Make your last impression a favorable one. You never get a second chance to re-do your LAST impression. Make your LAST impression a positive, LASTING impression!

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn