An article by Stephanie Krieger on creating Document Themesin reference to: Creating Document Themes with the Office Open XML Formats (view on Google Sidewiki)
Tuesday, August 31, 2010
Monday, August 30, 2010
Saturday, August 21, 2010
Friday, August 20, 2010
Thursday, August 19, 2010
Wednesday, August 18, 2010
I like Named Ranges in Excel. They free you from remembering to $A$1 every time you need to refer to an absolute block. And Named Ranges allow you to set up a reference block away from the worksheet that contains the Data Validation in-cell drop down list.
However, one more thing, Named Ranges still don't autoexpand to handle more items added later. Use ranges overlaid onto Lists (Excel 2003) or Tables (Excel 2007 and later). Or use OFFSET and COUNTA formula directly in the Name Manager specification.
Monday, August 16, 2010
Friday, August 13, 2010
Often, in Excel classes, participants ask about Excel functions and formulae. Of course, our job as trainers is to show and tell about functions specifically how to key them in, how to handle keying errors and recover from syntax errors. I tend to tell people that Excel has so many functions (and even more in the Excel 2010 version) that as generalists we don't have the domain intimacy with specific theory used in a function. Easily getting a list of function names in the catalogue is important. Walkenbach has written several Excel books and Excel function books. Here is a listing of the functions, with hyperlinks to the Microsoft Office website.in reference to: The Spreadsheet Page Excel Downloads: Excel 2007 Function List (view on Google Sidewiki)
Monday, August 9, 2010
Interesting. Remember when IT snobs say that Access is lightweight? Not big iron? How about when Access front ends to Windows Azure?in reference to: Access 2010 and SQL Azure - Microsoft Access - Site Home - MSDN Blogs (view on Google Sidewiki)