Ever since I read the book The Visual Display of Quantitative Information, by Edward R. Tufte, I am captivated by the idea of creating good design while doing data analysis or dashboard building. Although Excel 2007 charts are much nicer than its previous births, I have started disliking Excel charts. I am even developing an […]
Continue readingI was trying to enable an add-in for Excel 2007, and I kept getting this error: Access to the VB project is not trusted You can turn this message off by going to Developer tab in the ribbon and then clicking on the Macro security button, and checking the check box for “Trust access to […]
Continue readingCounting text in a range is easy. For example, if you would like count how many times “text” is in a specified range (named data), you can write something like this: =COUNTIF(data,”*text*”) This formula will give you the count of all the cells where Excel found “text” at any place. But let’s say you want […]
Continue readingThis is a new one for me. One good thing working with Excel and Access is the Copy/Paste ease between them. I usually paste data from Excel to Access for these two reasons: Create tables in Access (for small tables) Paste Field names: either in a table or in the import specs form When I […]
Continue readingProblem: When I tried to export a table/query from Access 2007 to Excel 2007, I was getting this annoying error: You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number […]
Continue reading