Home 2010 Archives for May 2010

Archives for May 2010

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 31, 2010 6 Comments

How to Set Goals in Five Steps

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

You can view or subscribe to my Podcast at the iTunes store, “Danny Rocks Tips and Timesavers” by clicking on this link.

Write a Contract with Yourself to Reach Goals in Five Steps [ 0:01 ] Play Now | Play in Popup | Download (626)
Link to this post!
Filed Under: Business Communications, Career, Goals, Podcast Tips & Timesavers, Training 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: , , , ,
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

Link to this post!
Filed Under: Excel Data Tables and Lists, Excel Training, MS Excel Tips, MS Excel Training, Pivot Tables Tagged: , , , , , , , ,
Next Page »