Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Wednesday, March 31, 2010 – Permalink –

Sparklines

Hail Tufte

New for Excel 2010






See all Topics

Labels: , , ,


<Doug Klippert@ 3:57 AM

Comments: Post a Comment

  Wednesday, March 24, 2010 – Permalink –

Short Menu Change

In context

Right clicking an object can display a shortcut menu.
Here are some instructions about how to write a macro that will edit that menu.

Changing the Shortcut Menu
Right Click



See all Topics

Labels: , , , ,


<Doug Klippert@ 3:42 AM

Comments: Post a Comment

  Tuesday, March 16, 2010 – Permalink –

Conditional Formatting

If, then

Jon Peltier offers a number of ways to format conditional charts.
PeltierTech.com






See all Topics

Labels: , , ,


<Doug Klippert@ 3:22 AM

Comments: Post a Comment

  Saturday, March 13, 2010 – Permalink –

This blog has moved


This blog is now located at http://unofficialexcelstuff.blogspot.com/.
You will be automatically redirected in 30 seconds, or you may click here.

For feed subscribers, please update your feed subscriptions to
http://unofficialexcelstuff.blogspot.com/feeds/posts/default.

<Doug Klippert@ 10:08 AM

Comments: Post a Comment

  Wednesday, March 03, 2010 – Permalink –

Mail Excel

VBA + sample

Excel Guru Ron de Bruin has put together the VBA code needed to send Excel via email.
He has also included the sample workbooks for those that are not VBA literate.

Also:
". . . a new add-in named RDBMail for Excel/Outlook 2007-2010
http://www.rondebruin.nl/mail/add-in.htm

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."



Code to send mail from Excel




See all Topics

Labels: ,


<Doug Klippert@ 3:43 AM

Comments: Post a Comment

  Monday, March 01, 2010 – Permalink –

Video Tutorials

What you see


"MIStupid.com is The Online Knowledge Magazine that publishes information that everyone should know, wants to know, or forgot.
MIStupid.com was created in 2001 by Greg Renza with the desire to eradicate the world's stupidity."
A few of the lessons include:
  • Concatenating Cells
  • Conditional Formatting
  • Subtotals
  • Data Sorting
  • Formulas and Named Cells
  • Create Graphs and Charts
MIStupid.com




See all Topics

Labels:


<Doug Klippert@ 3:42 AM

Comments: Post a Comment