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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

How to Lead Meetings that People Want to Attend

Don’t Laugh at the title of this post! It is possible – it is desirable – to learn how to lead meetings that produce results. To learn how to lead a meeting that people want to attend.

This begins by re-thinking your meetings. Stop thinking about the meeting itself. Successful meetings are part of a process – a three-step process – that I walk you through in this video.

Click here to read or download this as a Text Doucment – Published on www.ezinearticles.com

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

You can view, download and subscribe to my podcast – for free! Click here to follow the link to my Podcast at the iTunes store.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn