For the uninitiated, Sparklines are “data-intense, design-simple, word-sized graphics” according to its inventor Edward Tufte. I always wanted to include them in my trend reports. The challenge: How and Which tool to use? The data came from this report came from a complex query using SQL server and Access that had this format: College Major […]
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 readingIf you do not wish to enter complex formula in Excel and you already have calculated average, count, and variance for your samples(Tip:use a PivotTable), then you can use these user-defined functions to calculate the t-test stat value and degrees of freedom required to do hypothesis testing. Both the functions provide an optional argument for […]
Continue readingIf you want to convert the text to uppercase, use the following code; however, I recommend downloading ASAP Utilities, it has many functionalities, including text conversion. It doesn’t offer source code though. Here’s my code for uppercase conversion:(If you want to convert your text to lowercase, replace Ucase with Lcase function in the code) ‘Will […]
Continue readingBooks on my shelf: Professional Excel Development by Stephen Bullen, Rob Bovey This is by far the most authoritative book on Excel development from Add-ins to APIs. A word of caution though, it is not for the beginners. Excel Advanced Report Development by Timothy Zapawa Ever wondered on using Excel as a report development tool? […]
Continue reading