Home Archives for Source Data for Pivot Tables
July 10, 2011 Leave a Comment

My Two Most Popular Excel Tutorials on YouTube

YouTube Logo

YouTube - DannyRocksExcels

Three years ago – in 2008 – I started to create Excel Video Tutorials, both for this website and, also, for my YouTube Channel – DannyRocksExcels.

Looking back, I am amazed to see that two of my earliest postings have been viewed over 50,000 times on YouTube!

Most Viewed Excel Videos  on YouTube

  1. The Basics of Excel 2003 – Entering Data – has been viewed 64,725 times to date! Click on this link to watch it on YouTube
  2. Introduction to Pivot Tables in Excel 2003 – has been viewed 50,477 times to date! – Click here to watch this video on my YouTube Channel

Improved Production Values Since 2008

While I may sometimes “cringe” at my production value choices from 2008, I must say that the content of each of these two viewo tutorials holds up nicely!

What I Offer Today!

I have come a long way since 2008 – both in my knowledge of Excel and How to present the Excel Training Options that you can benefit from.

Re: Excel Pivot Tables – Paradoxically, Pivot Tables are BOTH the most powerful tool in Excel AND also, one of the easiest tools to use to analyze and present the information hidden inside your data!

Here is a link to the Excel Video Tutorial Recordings that you can download for only $9.95 USD. I have customized each recording for Excel 2003, Excel 2007 and Excel 2010!

Get my DVD-ROM – “The 50 Best Tips for Excel 2007” for only $29.97!

 

Let me know what you think!

Danny Rocks

The Company Rocks

 

Link to this post!
Filed Under: Excel Basics, Excel Training, Pivot Tables, WebEx Recordings & Webinars, YouTube Videos by Danny Rocks Tagged: , , , ,
November 29, 2010 1 Comment

My Most Viewed and Downloaded Videos for Excel and PowerPoint

My iTunes Podcast

Danny on iTunes

I began to post my videos as podcasts at the iTunes store this past summer. Since then, my video lessons for Excel and PowerPoint have been viewed and downloaded many times. I am thirlled. And, I thank you for your support and encouragement.

Here are the links – on my website – to the most popular video episodes. I have organized them by category in the order of their popularity. You can click on any link to view or download that video from my website. Or, you can go to my video Podcast by clicking on this link – “Danny Rocks Tips and Timesavers” Podcast on iTunes.

Merging and Consolidating Excel Worksheets

 PowerPoint Presentations

Data Visualizations

What-If Analysis in Excel

Importing Data From Other Programs

Pivot Tables

Excel Tables

Social Media

Formula Errors

Please add your comments below – or on my iTunes Channel. I welcome your feedback.

You can learn how to “Master Excel in Minutes – Not Months!”

Sincerely,

Danny Rocks

Link to this post!
Filed Under: Consolidate Excel Data, Excel Data Tables and Lists, Excel Functions, Excel Training, Goal Seek in Excel, Import Data into Excel, Integrating MS Office Programs, Most Viewed Excel Videos, MS Excel Training, New in Excel 2007, Pivot Tables, Podcast Tips & Timesavers, Powerpoint Techniques, Presentations, Public Speaking, What-if Analysis Tagged: , , , , , , , , , , , ,
May 31, 2010 3 Comments

Dynamically Expand the Source Data for Pivot Tables in Excel 2007

Without question, the new Tables Tools is my favorite feature  in Excel 2007 – this feature, alone, is worth the price to upgrade!

When you format a Data Range as a Table in Excel 2007, you can “append” new data to the table and the Table definition automatically expands to incorporate the new cells! If you create Pivot Tables based on a “Named Range” for your source data, this is GREAT NEWS!

Now, after appending the new data to your “Named Table: in Excel 2007, when you refresh your Pivot Table, you automatically get updated data in your Pivot Table report.

This can save you hours each month – at what – $50.00 per hour? $100.00 per hour? Watch these savings add up each month of the year

(Note: This is a re-post so that I can feed this video to my Podcast at the iTunes store.)

Follow this link, to view and download – for free – the episodes on my Podcast, “Danny Rocks Tips and Timesavers” at the iTunes store.

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

Save hundreds of dollars each month when you use a Pivot Table Play Now | Play in Popup | Download (902)
Link to this post!
Filed Under: Excel Data Tables and Lists, Excel Training, Pivot Tables, Podcast Tips & Timesavers, Tips and Time Savers Tagged: , , , , ,