Home Archives for 2009

Archives for 2009

March 9, 2009 1 Comment

What is an Interactive Excel Workbook? Please Vote

I created this short video for two reasons:

1)  To demonstrate what an “Interactive Excel Workbook” looks like. Interactive Excel files are “published” to an Internet or Intranet browser. You save an Excel Workbook as a “Web Page.” Adding “interactivity” is an option that you can select.

Notice that there are no Menus and there is only one toolbar. Also, you activate the other worksheets in a different way.

I am happy to make these Practice files available to you – if there is sufficient interest.

2) Please signify your level of interest by taking the POLL on the sidebar of this page. It is fast and easy – there is only one question; and only one choice, “Yes” or “No.”

I hope to hear from you!

Go to my new page to download the Interactive Excel Practice Files
Thanks in advance!

Danny Rocks

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, MS Excel Training Tagged: , ,
March 9, 2009 Leave a Comment

Are You Interested in Subscribing to a Podcast?

Update: My Video Podcast, “Danny Rocks Tips and Timesavers” is now available – free of charge – on iTunes. I add at least three episodes per week. Follow this link to view, comment, or subscribe to my Podcast.

Based on the positive response to my recent post, “Statistics Do Not Tell the Complete Story,” I am planning to initiate a podcast.

Initially, I am planning to produce two podcasts per month. The subject area is” improving communications skills.”

Are you interested in subscribing? Or do you need more information? Do you presently subscribe to podcasts?

I would like to hear from you on this topic. Please take a moment to “vote” on this topic – I have added a poll  to the right sidebar of this page. (the poll is in the middle of the sidebar.)

Thanks in advance for voting on this topic!

Sincerely,

 Danny

Link to this post!
Filed Under: Business Communications, Communications, Podcast Tips & Timesavers Tagged: , , , ,
March 9, 2009 Leave a Comment

Do You Want Copies of My Excel Workbooks?

I have a question for you?

I just added an “interactive copy” of my Excel Workbook for my video lesson – “Rearrange Your Columns – Sort from Left to Right”

Here is the link to the workbook.

My question is: Should I go back and add links to the Excel Workbooks for earlier lessons? To make it easy for you to respond, I have included a quick poll to the right sidebar on this page (at the bottom of the sidebar).

Thanks in advance for your response!

Danny

Sorry, there are no polls available at the moment.

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Interactive Webpages, MS Excel Training Tagged: , ,
March 7, 2009 2 Comments

Rearrange Your Columns – Sort from Left to Right

Did you know that you can sort data from Left to Right in Excel? In my experience, most people do not realize that you can.

Have you ever been asked  – or wanted – to rearrange your columns in Excel? Probably, yes. This is a fairly common request. And, if you are like most Excel users, you insert a blank column and then “Cut and Paste” to arrange your columns the way that you want them.

STOP!

There is an easier way to rearrange your columns of data – Learn to “Sort Across Columns.” Sort your data from Left to Right.

Watch this short Excel Video Lesson to learn how:

Here are the steps to follow in this lesson:

  1. Insert a blank “dummy row” above your Column Headers Row (if necessary).
  2. Place a number (1, 2, 3, etc.) in each cell in the “dummy row.” This will indicate the order you want to rearrange your columns in from Left to Right.
  3. Select a cell in your data set. Select Data – Sort.
  4. Check, “MY Data Range has NO Headers.”
  5. Click, OPTIONS and select “Sort from Left to Right.” Click OK and Click OK.

Looking for help with a specific Excel problem? Search my Index of Excel Video Lessons by Category or by Keyword.

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

NEW! Download The Excel Workbook used in this video lesson:

rearrange-columns


Link to this post!
Filed Under: Excel Data Tables and Lists, Excel Training Tagged: , ,
February 28, 2009

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.
Link to this post!
Filed Under: Business Communications, Communications, Persuasion, Presentations, Public Speaking, Words per Minute Tagged: , , , , ,
February 28, 2009 4 Comments

Simplify Data Lookups in Excel

In this Excel Video Lesson I demonstrate a great tip that dramatically simplifies data lookups!

Yes, learning how to use the Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX) is important. But, there is an easier way to answer some simple questions about you data.

In this video, I show you how to use the combination of “Named Ranges” and the “Intersection Operator” – the SPACE – to return the value at the intersection of a specific column and specific row. This “tip” is guaranteed to save you time and simplify your data lookups!

Here are the steps to follow in this lesson:

  1. Create “Named Ranges” for your data set.
  2. Use the “Intersection Operator” – the SPACE – in your formula. e.g. =Region_2 Week_16
  3. It’s that simple!

NEW! Download the Excel file that I used in this video lesson:

simplify-data-lookups

Looking for the answer to your Excel Questions? Use my Index of Excel Topics to find the right video

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Link to this post!
Filed Under: Excel Functions, Excel Training, Lookup Functions in Excel Tagged: , , , ,
February 24, 2009 2 Comments

Using =COUNTIF() Function to Validate Data

It is great to be back posting on The Company Rocks Excels. Thank you for your patience as I have worked to complete a series of Excel 2007 Training Videos to be published this Spring.

Here are two ways to use the =COUNTIF() Function. First to count the number of employees in each department. And then, as a Formula in Data Valadation to ensure that employee numbers entered in a column are unique values.

Here are the steps to follow in this lesson:

  1. Use the =COUNTIF() Function to count the number of values in a Range that match the Criteria that you set.
  2. We have already named the Range $A$2: $B$27 as “Department.” Let’s use the F3 (Paste Names) Shortcut to select this for our Range Argument.
  3. For the Criteria, point and click the cell in Column D that contains the label for our first department (Accounting) and Click OK.
  4. You can now copy the formula down to the other cells in Column E – This gives you a “Head Count” by Department.
  5. For our second example, we are going to use DATA – VALIDATION to ensure that only “unique values” will be accepted in Column A – The “Employee Number” Column.
  6. On the SELECT tab “Allow” drop-down, click “Custom.” Enter this formula in cell A2:
  7. =COUNTIF($A$2:$A$27, A2)=1 This ensures that only unique values will be accepted. Note the use of “Absolute” and “Relative” references in the formula. The “Range” is stated as an “Absolute” $A2:$A$27
  8. You will need to  copy the Data Validation from cell A2 down to this rest of the cells in the range that you wish to validate. In this video I use Paste Special – Validation.

Find the Excel Training Video that you want in the Index of Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Link to this post!
Filed Under: Excel Functions, Excel Training Tagged: , ,
February 17, 2009

Will be back posting Excel Video Lessons – Soon!

Hello Friends!

The 50 Best Tips

The 50 Best Tips Series

I have been working on an Excel Training Video project for commercial release – hence, my lack of postings.

This project has required focused attention and research. I have almost completed this project – and I will be back posting additional Excel Video Lessons this week. Thank you for your patience, understanding and continuing patronage.

I have now completed all five of the Microsoft Office 2007 Training DVD-ROMs. You can purchase The 50 Best Tips for – Excel, PowerPoint, Word, Outlook and Access 2007 online using my secure shopping cart. Click here to begin shipping.

Sincerely,

Danny Rocks

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, MS Excel Training, New in Excel 2007, Online Store for The Company Rocks Tagged: , , , , , ,
« Previous Page