Home Archives for Excel Video Training
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)
Link to this post!
Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers Tagged: , , , , ,
June 5, 2010 Leave a Comment

How to Import Text and Database Files in Excel 2007

When you need to import a Word document or an Access database file in Excel, resist the temptation to simply “open” the file with Office Button (File) – Open. Rather, follow the steps to “Get External Data” from the Data Tab on the Ribbon. This is how you can control the data type of each field that you import – especially important for formatting fields that contain dates. You also can control – and preview – who Excel will distribute the data into individual columns before you import the file.

Watch as I demonstrate these steps – this tip will save you a lot of time and avoid frustration.

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

Follow this link to view or subscribe to the “Danny Rocks Tips and Timesavers” podcast at the iTunes store.

Learn how to “Master Excel in Minutes – Not Months!”

How to Import Files from Other Programs in Excel 2007 Play Now | Play in Popup | Download (679)
Link to this post!
Filed Under: Excel Training, Import Data into Excel, Podcast Tips & Timesavers, Video Response to Viewers 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: , , , , ,
May 30, 2010 3 Comments

Create a Month, Quarter, Year Report with 10 Mouse Clicks Using Pivot Tables

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)
Link to this post!
Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers, Tips and Time Savers Tagged: , , ,
May 30, 2010 1 Comment

Summarize Fiscal Year by Month and Quarter with a Pivot Table

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.”

Summarize Fiscal Year, Months, Quarters with Pivot Tables Play Now | Play in Popup | Download (630)
Link to this post!
Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers Tagged: , , , ,
May 29, 2010 2 Comments

Five Benefits from Using Tables in Excel 2007

I really enjoy the major changes that Excel 2007 has incorporated into Tables. In this video I demonstrate Five Benefits when you convert your Excel data lists into Tables.

(Note: This is a re-post. I now make many of my videos available as Podcasts and I need to send these videos to the iTunes store.)

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

Learn how to “Master Excel in Minutes – Not Months!”

Five Benefits from Using Tables in Excel 2007 Play Now | Play in Popup | Download (1181)
Link to this post!
Filed Under: Excel Data Tables and Lists, Excel Training, New in Excel 2007, Podcast Tips & Timesavers, Tips and Time Savers Tagged: , , , , ,
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)
Link to this post!
Filed Under: Excel Financial Tools, Excel Training, Most Viewed Excel Videos, Podcast Tips & Timesavers, Tips and Time Savers, YouTube Videos by Danny Rocks Tagged: , , , , , ,
May 28, 2010 1 Comment

Tell Excel 2007 Not to Display a Formula Error in a Cell

Excel 2007 introduces a brand new Function – the =IFERROR() Function which is a great way to “hide” any potential Formula Error Messages from displaying. You know these error messages – #DIV/0!, #NULL – They are ugly to look at and they can harm your professional reputation.

Watch how you can use =IFERROR() in Excel 2007. Or, if you are using Excel 2003, I show you how to accomplish the same goal but with a few more steps using the =ISERROR() Function nested inside an =IF() Function.

(Note: This is a repost. I now have a Podcast on iTunes and I need to feed this video to the iTunes Store.)

You can subscribe to my iTunes Podcast by clicking on this link.

Learn how to “Master Excel in Minutes – Not Months!”

Excel 2007 Introduces a New Function to Hide Formula Error Messages Play Now | Play in Popup | Download (707)
Link to this post!
Filed Under: Excel Functions, Excel Training, New in Excel 2007, Podcast Tips & Timesavers Tagged: , , , ,
May 28, 2010 3 Comments

Make Excel Data Come Alive with Visualization Tools

Excel 2007 has added great new Data Visualization Tools. Now, you can place a Bar Chart directly in the cells that contain your values. Wow! There is no need to create a separate chart to “paint the picture” for your audience.

You can add Data Bars, Color Scales and Icon Sets to help your data to come alive from the Conditional Formatting Command on the Home Tab of the Ribbon in Excel 2007. Watch this short video to see how it is done!
(Note: This is a repost so that I can send this video as a Podcast to the iTunes Store.)

You can subscribe to this Podcast at iTunes by clicking this link.

Learn how to “Master Excel in Minutes – Not Months!”

Make Excel Data Come Alive with Visualization Tools Play Now | Play in Popup | Download (1069)
Link to this post!
Filed Under: Conditional Formatting, Excel Training, New in Excel 2007, Podcast Tips & Timesavers Tagged: , ,
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.)
Intro to Pivot Tables Play Now | Play in Popup | Download (410)
Link to this post!
Filed Under: Excel Training, Pivot Tables, Podcast Tips & Timesavers, Video Training Courses Tagged: , , , ,
« Previous Page
Next Page »