Hello!

I have been adding new features to my updated website – www.thecompanyrocks.com Here is a link to the latest:

• This page contains links to all of my free Excel Training Video Lessons organized by category

I hope that you enjoy my free video lessons. I invite you to shop for the five DVD s that I offer in “The 50 Best Tips for …” series. (Excel, PowerPoint, Word, Outlook, and Access 2007) 

Click here to begin shopping at The Company Rocks bookstore

I have updated my website – www.thecompanyrocks.com  and I have copied all of my Excel Training videos to the site. All future Excel Training Videos will be posted there.

Here is the link to take you directly to the Excel part of my new website:

http://www.thecompanyrocks.com/category/excel-training/

Thank you!

Danny Rocks
www.thecompanyrocks.com

I invite you to join me on a four minute, seven second video tour of my new instructional DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007.”

This DVD is different. If you want to learn Excel and you are pressed for time (and who isn’t these days?) this is the DVD for you. I give you over 5 1/2 hours of focused video instruction. The average length of each video lesson is 6 1/2 minutes! So you can find the topic that you want, learn it, and put it into practice at home or at work in under 10 minutes!

As an added bonus, I include the 50 Excel worksheets that I used to create and film the video lessons. Now you can practice the tips to master your new Excel skills!

Follow this link if  you want to see the complete list of the 50 video lessons on my DVD.

Are you ready to purchase “The 50 Best Tips for Excel 2007?” Follow this link to enter the online bookstore for The Company Rocks. This is a secure shopping site. And, I guarantee that you will be satisfied with your purchase. If you are not satisfied with your purchase, I will refund you money – no questions asked!

Sincerely,

Danny Rocks

Related Videos

• Video Tour of My DVD – “The 50 Best Tips for PowerPoint 2007″

Note: All new – and existing – Excel Video Lessons are hosted on my main website. Click this link to go directly to the Excel Video Lessons Section of my website.

Here is another request for help from a viewer. How to create a report that shows “the aging” of past due invoices (1 – 30 days past due, etc.).

Here are the Functions that I use in this report:

• =IF()
• =AND()
• =WEEKDAY()

Looking for a specific Excel video? Take advantage of my Index of Excel Video Training Lessons to find the video that you want to watch.

Want to learn the best Tips for Excel? You can purchase my DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007″

Note: All new – and existing – Excel Video Training Lessons are now hosted on my main website. Click this link to go directly to the Excel Video Training Section.

Do you manage Projects? Do you create Project work schedules? Do you need to know how many days were actually worked on your Project?

If so, this Excel video lesson is for you. A viewer asked for my help. He did not want to use MS Project for his work schedules. Rather, he wants to know which Excel Functions to use for his Project work schedules.

In this lesson, I demonstrate how to use two functions included in the Excel “Analysis Tool-Pak”:

• =WORKDAY()
• =NETWORKDAYS()

Search for a specific Excel Training Video Lesson on this website in my Index.

Want to learn how to get the most out of Excel 2007? My DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007″ is available for purchase.

Note: All new – and existing – Excel Training Videos are now hosted on my main website. Click here to go directly to the Excel Training Section.

Here is another response to a viewer request. The letter asks for my help in identifying, counting and totaling the amount of “Past Due” invoices. In the viewer’s letter, she wanted me to use the =NOW() Function. This function returns the current date and time (Hour, Minute, Second) from your computer’s system clock. The =TODAY() Function is similar, but it returns only the current date. Both the =NOW() and =TODAY() Functions are “volatile.” This means that the value that they return will automatically update according to your computer’s system clock. THis makes them excellent reference points in formulas that identify “Past Due” invoices.

In addition to using the =IF() Function to identify the invoices that are “Past Due,” I also demonstrate two other functions: =COUNTIF() to total the number of “Past Due” invoices and =SUMIF() to give me the total dollar amount that is “Past Due.” I recreate these formulas, this time, using “named cell ranges” in the formulas.

Finally, I show you a great new Filtering Feature in Excel 2007 – the ability to filter by time period e.g. “Next Week!”

Check out my new DVD, “The 50 Best Tips, Tricks, and Techniques for Excel 2007.” It contains over 5 1/2 hours of training for Excel 2007. You can locate the specific tip that you want to learn – and in @ 6 minutes, you will have received all of the information that you need to become more productive in this area.

Find the Excel Training Video Lesson that you want in my Index to all Excel Topics

Note: All new – and existing – Excel Training Video Lessons are now hosted on my main website. Click here to go directly to my Excel Training section.

I am working through the special requests that viewers have sent me. In this lesson, I show you how to:

• Use Data – Get External Data – to import a simple delimited text file.
• Use Copy – Paste Special – Transpose – to make a copy of the imported data that is now “vertically oriented.” i.e. The field entries run down the column rather than across the rows.
• Use the Data – Text-to-Columns feature to break an “address block” (City, State, Zip Code) that is one cell into three distinct cells. This is a terrific time saver!

Now available for purchase: My DVD “The 50 Best Tips, Tricks, and Techniques for Excel 2007″

Over 5 1/2 hours of training. Each video lesson focuses on one tip and averages 6 minutes.

Now available from the online store at www.thecompanyrocks.com

Search for the Excel Training Video Lesson that you want in my Index to all Excel topics.

Note: All new – and existing – Excel Training Videos are now hosted on my main website. Click here to go directly to my Excel Training section.

A viewer wants to know how many badges have been claimed and how many have not yet been claimed. In Excel, use the =COUNTIF() Function to get the answer(s) to this question.

If you have ever struggled with using “Nested =IF() functions” you will welcome the =COUNTIF() Function – it is so much easier to use because the arguments for the function follow a logical progression.

My viewer also wanted to see the names of the guests who have claimed or who have not yet claimed their badges. To answer this request, I use a Data Filter – very easy to use and change.

Find the Excel Video Tip that you want – quickly!

The “50 Best Tips for Excel 2007″ DVD - Over 5 1/2 hours of Excel 2007 training on my DVD. Each lesson averages @ 6 minutes.

New! Now available from the online store at www.thecompanyrocks.com

This is every company’s nightmare: You have a list of Customer Names that are entered in multiple worksheets by multiple employees. The (nightmare) result – you have multiple misspellings of the Customer Names! This is GIGO (“Garbage In, Garbage Out”). This is a mess!

This is preventable!

In this Excel Training Video I demonstrate three tips to save you time and help you to maintain consistency when entering long text labels into your worksheets. The Tips:

1. Use Data Validation – Choose from a List
2. Use a Named Constant  – you type =”Shortcut” and get the Customer Name spelled out correctly
3. Use MS Office’s AutoCorrect Option – Create your “Replace and Replace With” in Excel and you can use it in Word and PowerPoint

Here are the steps to follow in this lesson:

1. Enter the list of Customer Names in a worksheet. Highlight the list and type a NAME for this range into the Name Box. Remember to begin your Name with a letter and you can not use a Space in the Name.
2. Tip # 1 – Use Data Validation – Allow – List. You can watch my lesson on Data Validation.
3. Tip # 2 – Create a Named Constant. You can watch my lesson on Named Cells, Ranges & Constants.
4. Tip # 3 – Use MS Office’s AutoCorrect Option – Go to Tools – AutoCorrect Options in any MS Office Program. For the “Replace” entry, type in your “Shortcut.” I like to make my 1st character an”_” so that it is easy to find, edit or replace. For the “Replace with” type in the full Customer Name. Remember to ht the SPACEBAR when you use this in Word & PowerPoint!

It is easy to find the Excel Training Video you want to view – Search my Index of Excel Topics

New! Danny’s DVD Training Series, “The 50 Best Tips for …” is now available at the online store for The Company Rocks

Related Videos

• 3 Reasons to Use Names in Your Formulas
• 3 Ways to Minimize Data Entry Errors

Note: All new – and existing – Excel Training Videos are now hosted on my main website. Click here to go directly to my Excel Training Section.

When I am training a class to use MS Excel, I always get at least one question about performing time calculations. I sense that the person asking the question is frustrated. When I ask, “How many of you are frustrated when you try to perform a calculation to total time periods in Excel?” nearly every hand is raised! And they are right; Excel’s time calculations can cause frustration.

In this video lesson, I will show you how to overcome three common frustrations that you may have when performing time calculations in Excel.

Here are the steps to follow in this Excel Training Video:

1. Format the cell that contains the formula =End_Time – Start_Time) to the Custom Number Format h:mm
2. I encourage you to use this formula instead of a simple formula: =IF(End_Time<Start_Time, End_Time + 1, End_Time)-Start_Time.
3. This will eliminate any possible “Negative times” which result in a cell filled with ######### A Negative Time is frequently the result of “Time Periods that Span Midnight. e.g. Start @ 11:00 PM and End @ 3:00 AM
4. TIP: Use this Formula =MOD(End_Time – Start_Time, 1) This is the MODULUS Function.
5. When you calculate the total number of hours and the result exceeds 24 hours, use this Format [h]:mm

NEW! Download the Excel Practice file that I use in this Video Lesson:

• 3-frustrations-with-time-calculations

Find any Excel Video Training Lessons by Topic – Search My Index of Excel Lessons

New! Danny’s DVD Training Series, “The 50 Best Tips for …” is now available at the online store for The Company Rocks