Home Archives for New in Excel 2007
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!”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
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!”

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 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: , ,
February 17, 2009

Will be back posting Excel Video Lessons – Soon!

Hello Friends!

The 50 Best Tips

The 50 Best Tips Series

I have been working on an Excel Training Video project for commercial release – hence, my lack of postings.

This project has required focused attention and research. I have almost completed this project – and I will be back posting additional Excel Video Lessons this week. Thank you for your patience, understanding and continuing patronage.

I have now completed all five of the Microsoft Office 2007 Training DVD-ROMs. You can purchase The 50 Best Tips for – Excel, PowerPoint, Word, Outlook and Access 2007 online using my secure shopping cart. Click here to begin shipping.

Sincerely,

Danny Rocks

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, MS Excel Training, New in Excel 2007, Online Store for The Company Rocks Tagged: , , , , , ,
« Previous Page