An add-in puts the coming Excel 2010 feature into Excel 2007, 2003 and XP. As we’ve already noted, the Excel 2010 feature Sparklines isn’t a new idea. The idea of small graphs next to the numbers it was originally named by Edward Tufte. If you like the idea of Sparklines you don’t necessarily need to […]
A primer on measuring data variance in Excel. by David Goodmanson Let’s continue our look at the basic statistics functions in Excel. In our first article we looked at statistical functions that measured central tendency or averages. Most people understand Average or Mean though Median is often misused. Now lets look at a more difficult […]
Looks at importing Excel data to Access databases. Q: Graham Alison has two Excel workbooks, and when he imports them into an Access database, he just gets the data, not the formats that make the spreadsheets work. A: Data is all you will get when importing from Excel. If you need special formatting or calculations, […]
Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and found that the Word procedure […]
How to create an Excel timesheet, and export data from an Access timesheet. Q: Maurice writes that he needs to export Access timesheet data to an Excel worksheet for distribution, since some users don’t have Access, so he can’t just create an Access report. Is there a way to do this? A: I made a […]