Training You to Excel
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.)
Write a Contract with Yourself to Reach Goals in Five Steps [ 0:01 ] Play Now | Play in Popup | Download (626)With an Excel Pivot Table you can transform thousand of rows of transactions into a neat summary by month, quarter and year using @ 10 mouse clicks!
I invite you to visit my online shopping site to purchase my DVD “The 50 Best Tips for Excel 2007.
(Note: This is a re-post so that I can send this video to my Podcast on iTunes.)
Follow this link to view or subscribe to my Podcast at iTunes
Learn how to “Quickly Create Pivot Tables and Charts.”
Create Summary by Year, Month, Quarter with 10 Mouse Clicks in Excel Pivot Table Play Now | Play in Popup | Download (722)Excel Pivot Tables can quickly group dates by Month, Quarter and Year. If your company uses a Fiscal Year, then be sure that your source data contains columns to identify the Fiscal Year and the Fiscal Quarter before you create the Pivot Table. Watch how this is done.
(Note: This is a re-post so that I can send this video to my Podcast at the iTunes store.)
Follow this link to view and subscribe to my Tips and Timesavers Podcast on iTunes.
I invite you to visit my online store to learn about my DVD series, “The 50 Best Tips for …”
Learn how to “Quickly Create Excel Pivot Tables.”
This Excel 2007 Training Video could – conservatively – save you at least one hour each month when you need to update your Pivot Tables!
What is that worth to you and your company? $100.00? $500.00? – Multiply that by 12 for each month in the year…
Have I got your attention yet?
Watch this short – 3 minute and 20 second video lesson – and you can thank me – or learn more ways to save time and money by purchasing my DVD – “The 50 Best Tips for Excel 2007”
If you watched this short – 3 minute 20 second video lesson, you can tell that I am excited about this topic. Would you like to trade 3 1/2 minutes to watch this video in order to save hundreds of $$$ each month to get an updated Pivot Table? If your answer is anything other than “Yes!”, please send me an email – I would like to know what I am missing.”
Enjoy this video – and enjoy spending or investing the savings that you reap each month by applying this technique!
Want to save even more money? – Purchase my DVD – “The 50 Best Tips for Excel 2007″ – Click here to shop at my secure website.
Want to find a specific – and FREE – Excel Video Training Lesson? Click here to visit my Index of Excel Video Training Lessons.
You can watch this Excel video on YouTube. I have almost 200 videos on my YouTube channel – DannyRocksExcels
Learn how to “Quickly Create Pivot Tables” in Excel
In this Excel Video Lesson I demonstrate how to show an additional Pivot Table Summary, “Percentage of Total,” alongside a traditional ( Sum of Amount) subtotal. It is easy to do – if you know where to look. In the Field Settings Dialog Box for your Pivot Table, click on the “Show Values As” tab and then select the option that you want from the drop-down listing. In this lesson I use “% of Column.”
Watch me demonstrate how to do this.
If your want to learn the best tips for Excel, I encourage you to purchase my DVD – “The 50 Best Tips for Excel 2007.” Click here to enter my secure shopping site and make your selection. I guarantee your satisfaction 100%. If you are not satisfied, then I will refund your purchase price.
You can view – and download – this video on YouTube. I welcome you to subscribe to my YouTube Channel, DannyRocksExcels
Learn how you can “Quickly Create Pivot Tables” in Excel
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
This is another Excel 2007 Video Lesson that I created in response to a view’s request for help. Excel 2007 makes it quite easy to view two worksheets “side by side,” but there are a couple of “got’cha steps” to be aware of in order to make this work for you.
First, I want to clarify the difference between three similar words that I use in this lesson – “Windows, Workbooks, Worksheets.” We will be opening up multiple Windows in order to compare multiple Worksheets which can be part of one or more Workbooks. “Windows, Workbooks, Worksheets” – Oh My!
It is easier to show you the difference, so let’s view this lesson.
If you enjoyed this Excel Video Lesson, you will enjoy my DVD, “The 50 Best Tips for Excel 2007.” You can purchase it here on my website at my secure storefront. Click here to start shopping!
You can watch this Excel Video Lesson on YouTube – Visit my channel, DannyRocksExcels
Click here to see a Listing of “The 50 Best Tips for Excel 2007”
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:
Search My Index of Excel Video Lessons
This morning, while I was teaching a class to use MS Excel 2003, a young man in the class called out, “I get it!”
I replied, “That’s great, Ian. What did you get?”
“It’s NASCAR!”
“NASCAR?” I replied – somewhat puzzled.
He explained. “In NASCAR Racing, the pit crews save a second here and a quarter of a second there. That’s how they win the race.”
So, there you go – “It’s NASCAR!” Saving a few seconds here and a few seconds there is how you win the business race. Watch this video to see how to save time when creating multiple formulas.
Here are the steps to follow in this video:
