Video Lessons For Excel | The Company Rocks

Danny June 23, 2010 1 Comment

Show Percentage of Calculations in Pivot Tables

Most people are content to let a Pivot Table Sum, Average, or Count their Values Fields. But what if you want to see individual Products as a percentage of all products sold in a Region – this is a standard request for Excel. And … it is easy to perform this calculation in a Pivot Table. Let me show you how to do this.

Follow this link to subscribe to the Danny Rocks “Tips and Timesavers” Podcast at the iTunes Store.

Learn how to “Quickly Create Pivot Tables and Charts in Excel.”

How to Show Percentage of Calculations in Pivot Tables Play Now | Play in Popup | Download (627)

Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers Tagged: Danny Rocks Podcast, Excel Pivot Tables, Excel Video Training, Percentage of Calculations, Pivot Table Calculations, Video lessons for Excel

Danny May 29, 2010 3 Comments

How to Merge Multiple Excel Workbooks into a Master Budget

Would you like to know how to merge the work of several individual departments into a master budget workbook in Excel 2007? Watch as I show you how to to do this in a non-networked environment.

(Note: The is a re-post. I am making many of my video lessons available as Podcasts and I need to feed them to the iTunes store.)

Watch Video Tutorial on YouTube

Click on this link to watch this Excel Tutorial on my YouTube Channel – DannyRocksExcel

This is consistently one of my Top 5 Videos that are watched on YouTube!

Subscribe to Free Video Podcast – Danny Rocks Tips and Timesavers – at iTunes

Click here if you would like to subscribe to my Podcast at the iTunes store.

How to Merge Multiple Excel Workbooks Play Now | Play in Popup | Download (1101)

Filed Under: Excel Financial Tools, Excel Training, Most Viewed Excel Videos, Podcast Tips & Timesavers, Tips and Time Savers, YouTube Videos by Danny Rocks Tagged: Collaboration in Excel, Consolidate Excel data, Excel Video Training, Master Budget, Merge Changes in Excel 2007, Multiple Excel Workbooks, Video lessons for Excel

admin May 26, 2010 2 Comments

Danny Rocks Tips and Timesavers

Many people would like to know how to create Pivot Tables in Excel, but they are afraid to try them because they fear that they will “harm the data”in the source worksheet. Here is the good news! With a Pivot Table, you cannot possibly harm or even change the source data!

Watch as I show you how to create a Pivot Table – you will be amazed at how easy they are to create, and even more amazed at how powerful they are in helping you to analyze your data.

(Note: This is a repost. I am now making many of my video lessons available – for free – as Podcasts and I need to feed them to the iTunes store.)

Click here to go to my Podcast at the iTunes store

Intro to Pivot Tables Play Now | Play in Popup | Download (410)

Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers, Video Training Courses Tagged: Excel Pivot Tables, Excel Video Training, New in Excel 2007, Tips and Time Savers, Video lessons for Excel

Danny May 24, 2010 Leave a Comment

How to Save Hours Updating Pivot Tables in Excel 2007

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

Filed Under: Excel Data Tables and Lists, Excel Training, MS Excel Tips, MS Excel Training, Pivot Tables Tagged: Append Data, Excel 2007 Tables, Excel Pivot Tables, Excel Video Training, productivity, Save Time in Excel 2007, Tips and Time Savers, Update Pivot Table Source Data, Video lessons for Excel

Danny May 21, 2010 Leave a Comment

How to Take Advantage of Excel 2007 Tables

One of the major improvements in Excel 2007 is working with Tables. In this lesson I demonstrate Five Benefits for Working with Excel 2007 Tables:

Automatically expand in size to add Columns (Fields) and Rows (Records)
Use Natural Language Formulas – Copied down the column automatically!
Total Rows Tool – great for seeing the results in filtered lists
Easy to use Filters for Dates (Last Week, Next Quarter, etc.), Text and Numbers (Above Average, Top 10, etc.)
Improved Formatting – Use Live Preview to see what style options look like before you select them

You can view and download this Excel video lesson – for free – on iTunes. Click here to visit my Podcast, Danny Rocks Tips and Timesavers at the iTunes store.

If you enjoyed this Excel Video Lesson, I invite you to purchase my DVD, “The 50 Best Tips for Excel 2007” – You can shop with confidence at my secure web store.

I help you to find the Excel Training Video Lesson that you want – Visit my Index of Excel Video Lessons

You can watch – and download – this Excel Video Training Lesson on You Tube. Subscribe to my YouTube Channel – DannyRocksExcels

Learn how to “Quickly Create Pivot Tables in Excel”

Filed Under: Excel Data Tables and Lists, Excel Formulas, Excel Training, MS Excel Tips Tagged: Excel 2007 Tables, Excel Video Training, Filter by Time Period, New in Excel 2007, Top 10 Filter, Video lessons for Excel

Danny May 20, 2010 1 Comment

Changing Pivot Table Summaries in Excel 2007

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.

Additional Resources

Extended Length – 90 Minutes – Video Tutorials for Excel Pivot Tables now available – Download or on DVD-ROM

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

How to Compare Two Excel Lists for Differences

Lists, lists, lists … It sometime seems that I am swimming in a sea of lists. Lists of customers, updated lists of customers, sales by week, sales for the current week, book lists, revised lists of books, etc. Lists seem to beget more lists and both beget problems – How to compare pairs of lists to avoid duplicates and redundancies!

If you can relate to this scenario, I know that you will enjoy this Excel Video Lesson.

Three Techniques Used in My Tutorial

1) Use the =MATCH() Function

2) Use the =VLOOKUP() Function

3) Use a Pivot Table in Excel 2007

Shop at My Secure Online Shopping Site

If you enjoyed this Excel Video Lesson, I am confident that you will enjoy the lessons on my DVD-ROM, “The 50 Best Tips for Excel 2007.” Click on this link to visit my secure online shopping website.

You can watch this Excel Video Lesson on YouTube – Subscribe to my YouTube Channel – DannyRocksExcels

Watch My Video Now

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

Filed Under: COUNTIF and SUMIF Functions, Everyday Calculations in Excel, Excel Basics, Excel Data Tables and Lists, Excel Date and Time Functions, Excel Financial Tools, Excel Formulas, Excel Functions, Excel Training, Import Data into Excel, Lookup Functions in Excel, MS Excel 2007 DVD, MS Excel Tips, MS Excel Training, Online Store for The Company Rocks, Pivot Tables, Text Functions, Tips and Time Savers, Training, Video Training Courses, What-if Analysis Tagged: Excel Video Training, MS Excel Training, Tips and Time Savers, Video lessons for Excel

Danny May 14, 2010 2 Comments

How to Combine Changes Made to Multiple Excel Workbooks

Review Changes Commands

Frequently, several people work on an Excel 2007 Workbook. Perhaps to create departmental budgets or to analyze regional sales results. When it is time to combine the work of these individuals into the Master Excel Workbook you do not want to resort to “copy & paste!” Fortunately, you do not have to. Use Excel 2007’s Compare and Merge Tool to do this for us.

However, in order to make this work there are several “gotcha steps” to be aware of. Watch this video lesson to see how to combine the individual work of three colleagues into a “merged workbook” for an upcoming event. I guarantee that this lesson will save you time and aggravation at “budget time” each year.

Subscribe to My Video Podcast on iTunes

This video is available to view and download – for free – as a Podcast at the iTunes store. Click here to go to the Danny Rocks Tips and Timesavers Podcast at iTunes.

(Follow this link to watch this Video Podcast from my website.)

Visit My Secure Online Shopping Website

Watch My Tutorial Now

Visit My Secure Online Shopping Website

If you enjoyed this Excel video lesson, I invite you to visit my online store to purchase my DVD, “The 50 Best Tips for Excel 2007.” It contains over 5 1/2 hours of focused video instruction in Excel 2007 Tips, Tricks & Techniques. Click here to shop using a secure shopping cart.

Watch this Excel Tutorial in High Definition

Do you want to watch this Excel Video Lesson on YouTube? Follow this link to view it on my YouTube channel, DannyRocksExcels

Note: As of September 2012, this video has been viewed over 79,000 times on YouTube!

Filed Under: Excel Financial Tools, Excel Training, Most popular articles, MS Excel Training, Tips and Time Savers, YouTube Videos by Danny Rocks Tagged: Combine Workbooks in Excel, Consolidate Excel data, Customize Quick Access Toolbar, Excel Video Training, Merge Changes in Excel 2007, Share Excel Workbooks, Video lessons for Excel

Danny May 11, 2010 2 Comments

How to Use Excel’s Transpose and Text to Columns Tools to Reorganize Your Data

This video lesson is in response to a viewer’s request. The information that he gets comes from a mainframe computer and the orientation of the data is horizontal (going left-to-right across columns. He wants to be able to reorganize this data to show it vertically (from top-to-bottom in rows. I use Excel’s Transpose tool to show him how to do this.

I also demonstrate an extremely useful Excel Tool – Text to Columns – to break apart an address block (City, State, Postal Code) into discrete fields – to help you to manage a mail merge or to sort and filter by State or by Postal Code.

(Note: Somehow this lesson “got lost” as I was reorganizing my website. So, I apologize in advance if you already viewed this lesson.)

If you enjoyed this lesson, I invite you to visit my online bookstore to shop for my DVD, “The 50 Best Tips for Excel 2007.” It is on sale now!

You can watch this Excel Video Lesson on YouTube – vist my channel – DannyRocksExcels

Danny Rocks “Training You to Excel”

Show Percentage of Calculations in Pivot Tables