Essential Excel Skill #2: Selecting Cells Efficiently

Essential Excel Skill #2

Essential Excel Skill #2

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 in length and it contains 25 individual video tutorials.

Selecting Cells Efficiently in Excel

For a contiguous range of cells, you can use these methods:

  • Ctrl + A to select all of the cells in the current range.
  • Ctrl + Shift + Directional Arrow to select all of the cells that contain data moving in that direction.
  • Hold down the Shift Key while you tap the directional arrow keys.
  • Press the F8 Key to enter “Extend Mode” and tap the directional arrow keys.

Selecting Cells by Type of Content

One of the most valuable – if underused – tools in Excel is the Go To Special Dialog Box. In this lesson, I demonstrate how to use the Go To Special commands to, first, select all of the cells that contain Numeric Formulas and then all of the cells that contain numeric constants.

As a Best Practice, I always use the Go To Special Dialog Box whenever a  client sends me an Excel Workbook. In my opinion, this is the easiest way to “inspect” an Excel worksheet. I most frequently use Go To Special to find cells that contain:

  • Types of Formulas (Numbers, Text, Logical, Etc.)
  • Types of Constants (Numbers, Text, etc.)
  • Data Validation
  • Conditional Formatting
  • Blanks

Secure Online Shopping Website

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

Watch My Video in High Definition

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

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

How to Use Lookup Functions in Excel – Take a Free Lesson from My Latest Video Training Resource

Video Lesson - Lookup Functions in Excel 2007

Video Lesson – Lookup Functions in Excel 2007

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 Training.

Lookup Functions in Excel 2007

Watch this complete 11 minutes and 30 second lesson, as I demonstrate how to use both the VLOOKUP() and HLOOKUP() Functions in Excel. I demonstrate how to return an “exact” match as well as how to return an “approximate” match. I use “plain language” to describe how to use Lookup Functions.

Learn More About My Video Training Resources

Here are the links to the specific product information pages for my latest video training resources:

Download My Step-by-Step Instructional Guide – for Free!

You can download a PDF of my Step-by-Step Instructional Guide for the “9 Essential Excel 2007 Skills” video training resource. I am offering this for free so that you can see the scope and detail of the training that I offer on my 4-hour video. Click on this link to begin the downloading process for my free Instructional Guide.

Watch this Lesson in High Definition

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

Watch Tutorial Now

 

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

How to Animate SmartArt Diagrams in PowerPoint

SmartArt Diagrams were introduced in Office 2007. Using SmartArt on a PowerPoint slide is a great way to present a business concept. They are much more interesting for both the audience and the presenter  – compared to “boring bullet points.”

However, when you want to engage your audience, it helps to apply Custom Animation to the Smart Art so that each part of the diagram appears in the order – and with the timing – that you want.

You can quickly download this five minute video by clicking just below this image. Or, you can get this – and my other Podcast tips – from the iTunes Store by clicking this link.

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

How to Set Goals in Five Steps

Many people create goals – but few of those goals are ever reached. In this video I show you how to write a contact with yourself to reach your goal in five structured steps.

(Note: This is a re-post so that I can feed this video to my free Podcast on iTunes.)

You can view or subscribe to my Podcast at the iTunes store, “Danny Rocks Tips and Timesavers” by clicking on this link.

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

I Have Updated My Index of Excel Video Lessons

As part of the process of reorganizing my website, I have updated my “Index of Excel Video Lessons” page. The content of this page will be updated as I add each new Excel Video Training Lesson. So, I suggest that you click here to go to the Video Index and then save the page as one of your “Favorites” if you want to learn how to really get the most out of Excel or to find a quick answer when you are using Excel.

On the Index Page you can see an organized listing of my Excel Videos by Category – e.g. Formulas, Formatting, Pivot Tables “What-if” Analysis, etc. Each lesson is “hyperlinked” so that you can just click on the topic to go directly to the lesson that you are interested in.

I indicate in the title if the lesson is specific to Excel 2007.  All my new Excel video lessons are created using Excel 2007.

If there is a topic that you would like me to cover, send me an e-mail message – danny@thecompanyrocks.com

If you enjoy my video instruction, I encourage you to purchase my DVD, “The 50 Best Tips for Excel 2007.” The DVD contains over 5 1/2 hours of Tips, Tricks & Techniques to help you to master the program – and to save a considerable amount of time while working in Excel! Click here to enter my secure shopping site.

Thank you for your support and encouragement!

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

Speak at a comfortable rate during your presentation

I just recorded a new video PowerPoint Presentation for one of my websites. Since I intended to post this video on the website, I wanted to be sure that the total length did not exceed 4 minutes. In Internet-time, that can seem like an eternity!

I had a story to tell – promoting my services as a trainer. So I wanted to make it interesting. I want viewers to watch the entire video – it comes in at 3 1/2 minutes. And, of course, I wanted to conclude the video with a strong “call to action” – contact me to discuss my training services.

Here are the steps that I followed to create and record the PowerPoint video:

  1. I wrote a short story board – Opening slide, Introduce me, What I do, How I do it, etc.
  2. This came out to 8 slides. I then created them in PowerPoint.
  3. I made sure that I followed the “Four-by-Four” rule with my bullet points. Only 3 of the 8 slides contain bullet points.
  4. I wrote my script. This was an easy step since I had been writing my script “in my head” as I created the PowerPoint slides.
  5. The script come in at 570 words. I read it aloud several times and then I timed it.
  6. My first reading – at performance level – came in at 3 1/2 minutes. That is a speaking rate of 163 words-per-minute (wpm). A little fast – but it felt comfortable to me.
  7. I made a test (audio) recording and I was happy with the script. I made a few changes – where I stumbled over a word or two.
  8. Now it was time to record the PowerPoint presentation (video & audio together.) I added “Heading 2” styles to my script at each point where I was to advance the slide.
  9. I had 2 false starts. Because I had written my script and rehearsed prior to the recording, I finished the project in just 2 takes.

Give me your feedback after watching the video. What do you think? Did I speak too fast? Was my story clear? etc.

Add your comments below.

And, yes, you can contact me if you want to engage my services!

danny@thecompanyrocks.com

News! My new DVD, “The 50 Best Tips for PowerPoint 2007” is available for purchase. Visit my online store for details.

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

Watch My Excel Training Videos on YouTube

I have now joined the YouTube community by uploading several of my Excel Training Videos. Here is the link:

http://www.youtube.com/DannyRocksExcels

YouTube offers a unique opportunity for viewers worldwide to access and share video content with their friends and other members of their community. I want to be able to offer my Excel Video Training resources to them – the way that they want to access and share them.

The video experience that I offer on my The Company Rocks Excels website is quite different from the YouTube experience. Let us celebrate the difference!

News! My new DVD, “The 50 Best Tips for PowerPoint 2007” is available for purchase. Visit my online store for details.

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

Now You Can Watch My Excel Training Videos on YouTube

I have loaded many of my Excel Training Videos to YouTube. Here is the link:

http://www.youtube.com/DannyRocksExcels

YouTube is a powerful resource with a very wide reach. Many viewers enjoy being able to access and share YouTube content with their friends and other members of their community. I want to give them the opportunity to view and share my Excel Training videos the way the they like to do so.

There video experience on my The Company Rocks Excels site and on my YouTube site are different. Let’s celebrate the difference!

Let me know what you think. Take a minute to add cour 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

Can customers find you when they need you?

Can customers find you when they need you? When you have a toothache, you call your dentist? Right? When your drain won’t drain, you call your plumber? Correct?

But what if you don’t have a dentist or a plumber? Who would you call? Why would you call them? How would you know if they were reputable? That they could do the job?

Would you call a friend and ask for a recommendation? Would you consult an on-line service such as Craig’s list or Angie’s List?

If you have the time, yes. But if your tooth aches badly enough…? Or if your drain is overflowing and you are knee-deep in…?

Who you gonna call? Ghostbusters?

Seth Godin has, as always, a very good post on this topic – “My tooth doesn’t hurt.”

Plumbers and dentists usually don’t have trouble attracting customers – as long as there are lots of “aching teeth” and “overflowing drains.”

“…On one hand, dentists have no trouble whatsoever getting business from people with toothaches. They hardly have to try. Just show up, I’ll find you. On the other hand, when my teeth don’t hurt, you’re invisible. No amount of signs, service and wonderful marketing is going to get me to pay you to drill my teeth when they don’t hurt. ” – Seth Godin

 

Increase your visibility

Are you invisible? If you sell a product or offer a service, how do you gain visibility? How do you let potential clients know about you and what you offer?

  • How do you gain “top of mind share” with your target audience?
  • How do find ways to stay in front of customers and clients when they don’t need you?

If you are visible enough, you will increase your value.  And the probability that customers will call you when they need you. But… your visibilty must offer value. Visibility, alone, is not sufficient.

  • Billboards and radio ads? – Not enough value. Recognition, perhaps.
  • Yellow Page ads? I doubt it. I throw mine into the recycle bin as soon as they are delivered.

Can you create new products or services – for those times when your customer’s teeth don’t ache? Or when their drains drain? Seth Godin cites the “Teeth Whitening” services that dentists now offer. 

What additional services can you offer? 

What services can you offer? How can you get clients to come into your store or to visit your website? At times when they don’t need your products or services?

Blogs are one way – to get customers to learn more about you. And for you to offer something of value to your customers and potential customers.

As I develop my training and speaking business, I am finding that offering short, free, and focused video lessons is a great way to build awareness of what I offer – and how I offer it. I have also started posting these Excel video lessons on YouTube. I’ll also open up MySpace and Facebook sites soon.

People ask me, “Why are you giving away something for free?” Because I believe that by doing something good to others (offering something of value with no expectation of repayment) you will end up doing good for yourself.

Increase your value. Increase your visibility!

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

A lifetime learning

“It’s what you learn after you know it all that counts.”

– John Wooden

I remember my mother telling me, “You have to go to college. You need to acquire the knowledge that will last you for your lifetime.”

That’s the way it used to be. When you left school, you stopped learning. You started to work. And you worked for the same company until you retired. And then you _____.

Not today.

Learning for a lifetime will not equip us to remain vital – and employed. Rather, we need to invest in ourselves – committing to a lifetime of learning. Well, at least a significant part of our lifetime!

But – here’s the key – learning doesn’t stop. We can decide to stop learning. But economic forces, a global economy and a rapidly changing world demand that we continue to learn new skills. To reinvent ourselves periodically. To adapt to change.

I have been devoting some time to developing my new website – filming short video lessons of MS Excel tipsand time savers. During development, I have asked several friends and colleagues to review the videos and to give me feedback. Many write back to say:

“Wow! I didn’t realize that you could do that. I’ve been wasting a lot of time doing it the wrong way.”

“If only I knew this sooner. I could have saved two hours preparing my last report.”

“I didn’t realize what I didn’t know.”

“I knew that I needed to improve my Excel skills, but I didn’t know where to begin.”

I gain a lot of satisfaction from my career as a trainer and speaker. I love to see someone in my class have an “A ha!” moment. I love to see the light bulb of learning flash on. I enjoy helping people to learn.

And… I enjoy learning. I try to live my lifetime learning – and growing.

How about you? What are your thoughts on the topic of continuing education and professional development?

Please share your comments with our readers. Add a few words in the comment box below. I no longer require you to be registered in order to add your comments.

 

 

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