convention

Hi all, Wondering if there is a standard/recommended approach to naming - Ranges - Tables - Graphs - Worksheets - Workbooks etc I've seen table with 'f' and 'dim' before the table name. Just looking for the better way to go about it. Thank you

Hello, I'm sure this is fairly straightforward, but I ended up doing a manual workaround that I'm keen to avoid in the future. I have three columns of data. I want to know what the exposure was over each day, where the 'To' and 'From' dates are inclusive. For example, on the 3 January, the...

Trying to compare cumulative interest paid on a loan using different day count convention - I've used CUMIPMT but not sure what the defaut day count convention it uses or if I can change it. Any suggestions?

I have a form that is linked to our CONTACT table on a SQL server. The ID field is Short Text, though it follows a numeric convention 0000001 0000002 0000003 I am trying to create a default value for new entries which is the next in sequence "0000004", Is this possible?

I am using Office 2007 Excel and have been trying to determine the convention for linking an xlam library to an xlsm application. Suppose a.xlsm references b.xlam. Furthermore suppose we have 3 directories in our share: Xdir, Ydir and Zdir. Suppose a is in Ydir. Now let's imagine a two...