User:David Biddulph/Sandbox2

Home

Bookmarks

Bookmarks2

WP help

Sandbox 1 2 3

Excel help hints

Newsgroup hints:

• http://www.cpearson.com/excel/HintsAndTipsForNewsgroupUsers.aspx
• http://www.michaelstevenstech.com/outlookexpressnewreader.htm
  • (and http://aumha.org/nntp.htm for list of Microsoft Public newsgroups)
• http://groups.google.com/group/microsoft.public.excel.misc

Numbers to words:

• http://support.microsoft.com/kb/213360
• http://www.xldynamic.com/source/xld.xlFAQ0004.html
• http://www.ozgrid.com/VBA/ValueToWords.htm

Double unary minus:

• http://www.mcgimpsey.com/excel/formulae/doubleneg.html
• http://xldynamic.com/source/xld.SUMPRODUCT.html

Colour functions:

• http://www.cpearson.com/excel/colors.aspx
• http://xldynamic.com/source/xld.ColourCounter.html
• http://www.ozgrid.com/VBA/Sum.htm

Mail merge Excel to Word:

• http://www.mvps.org/dmcritchie/excel/mailmerg.htm
• http://www.mvps.org/word/FAQs/MailMerge
• http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
• http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm
• news:microsoft.public.word.mailmerge.fields

Excel 2007 compatibility pack for Excel 2003 users:

• http://support.microsoft.com/kb/923505
• Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Some hints on 2003 to 2007 command mapping:

• http://office.microsoft.com/en-us/excel/HA101491511033.aspx
• http://www.rondebruin.nl/0307commands.htm
• http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218