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

 Subscribe to our RSS Feed

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

 Subscribe to our RSS Feed

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″

 Subscribe to our RSS Feed

I am proud to announce that my online store for The Company Rocks is now open!

You can now purchase my two DVDs without leaving my website.

“The 50 Best Tips for Excel 2007″ contains over 5 1/2 hours of training. Each video lesson focuses on one tip and you can learn it in @ 6 minutes! The tips range from Beginning Level to the Advanced level. The majority of Tips (30 tips) are at the Intermediate level. If you enjoy the lessons that I post here, now you can own a DVD of the 50 Best Tips – now for Excel 2007!

“The 50 Best Tips for PowerPoint 2007″ contains over 7 hours of training on two DVDs! I put a lot of effort into producing this DVD – and the customers who have already purchased it tell me that has immediately improved their presentation skills.

This DVD is unique!

Because, I do not teach PowerPoint as a “techie.” Rather, I am a professional speaker and trainer and I show you how to use PowerPoint as a tool to use during your presentations. Of course I show you how to create animations and how to create custom PowerPoint shows. But, significantly, I demonstrate how best to use custom animations and why you should prepare Custom PowerPoint shows. If you think you know PowerPoint, think again. I guarantee that you will learn new techniques for PowerPoint and … you will learn how to take advantage of the many great new graphic features available in PowerPoint 2007.

I invite you to visit my online store. The DVDs are in stock and attractively priced. I know that you will learn new tips and refine your skills in PowerPoint and Excel when you watch one of my lessons.

• Invest 10 minutes to learn a new productivity tip – and, save yourself hours of frustration and avoid having to rekey data entries in Excel 2007.
• Invest 10 minutes to learn a new presentation tip – and, learn how to deliver presentations using PowerPoint 2007 that get you the sale or get your audience to take action.
• Invest 10 minutes and learn how to use the new Office 2007 interface. I show you how to always have your favorite commands right at your fingertips.

Finally, let me wish you a very Happy New Year in 2010!

Sincerely,

Danny Rocks

danny@thecompanyrocks.com

 Subscribe to our RSS Feed

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″

 Subscribe to our RSS Feed

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.

 Subscribe to our RSS Feed

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

 Subscribe to our RSS Feed

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.

 Subscribe to our RSS Feed

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

 Subscribe to our RSS Feed

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

Do you ever have one of those “A-ha” moments? You know – those moments when everything falls into place. When everything becomes crystal clear. When you finally “get it!”

Well, here is your opportunity to experience 50  “A-ha” moments. Here is a great way for you to learn “The 50 Best TIps, Tricks, and Techniques for Microsoft Excel 2007.”

I spent almost three months filming these short Excel training videos. I worked hard to create this DVD in order to make it easy for you to learn how to remain productive at work while learning to use the new Excel 2007 interface.

And, the Excel 2007 interface is really quite different.

So different, that many long-time Excel users just give up on it and return to the tried and true Excel 2003 program.

And that is too bad. Because, Excel 2007 allows you to perform so many business tasks faster and better. But … first, you must get over “the initial learning curve” to understand how to navigate in Excel 2007.

This DVD makes it easy for you to learn how to use Microsoft Excel 2007 - guaranteed!

In selecting the 50 Best Tips for Excel 2007, I wanted to include tricks that all Excel users could put to use – now! I include tips at the Introductory, Intermediate and Advanced levels.

Each lesson is short – five to six minutes on average – and focused on just one topic. Each lesson on the DVD is self-contained – I teach you how to solve one problem per lesson.Overall, the DVD contains 5 1/2 hours of training on Excel 2007!

This DVD is available exclusively from the SkillPath Seminars bookstore. They are offering it for sale at the introductory price of $49.95 Here is a link to the demonstration / order now page.

I am proud of this product. I know that you will gain some new insights into how to get the most out of Excel 2007. I welcome  your feedback. Please drop me a note  – danny@thecompanyrocks.com Or … add your comments below for all readers to share.

Thank you for your support!

Danny Rocks

 Subscribe to our RSS Feed