Thanks to everyone who attended today’s (April 2011) session. As we discussed, the macro in the spreadsheet below is designed for use in a 4.x environment.
- Dynamic Named Ranges… regular and advanced
- Best Practices in spreadsheet design from Ozgrid
- Dates and times by cpearson, Microsoft, or Ozgrid
- Start learning about pivot tables
- Use calculated fields in pivot tables
- Pivot charts and more (from Microsoft)