Ever felt the need of creating different sheets based on the distinct values of a column. For example, in your data, you have a column called STATE, and you would like to create a separate sheet for each state with all the data from that state. Here’s your solution then:(Note: you’ll need to add a […]
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 readingYears ago I conducted an Excel training session for Ohio Association for Institutional Research and Planning (OAIRP) and I used the following material for that Excel training: Exercise file for Excel training Excel Formulae Excel training handout
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