Monthly Archives: November 2013


Categorical or Comparative Data Analysis using Excel VBA

Categorical or Comparative Data Analysis is helpful to study the categorical data to understand and compare the metrics between different categories. For example, we can study effect of particular drug in various countries in health care projects. If we consider retail data, we may study POS (Point of Sales) Data, how is the sales in various regions of the country, or how many units are selling from each store or from each department of the supermarket.

By |November 24th, 2013|Data Analysis|3 Comments

Trend Analysis or Longitudinal Data Analysis using Excel VBA

Trend or Longitudinal Data Analysis is helpful to study historical data to understand change in data over particular time frame. Learn more with Examples.
In this topic, you can download example macro tool for Trend Analysis, with explanation of the below topics:

  • Understanding requirement
  • Understanding the Data
  • Design and Planning
  • Cleaning the Data
  • Identifying the variables and creating new variables
  • Plotting the Charts and Tables to understand the Data
  • Providing Interactivity using VBA
  • Providing Help or Guidelines to users
  • Understanding Summarized Data
  • Writing Overall Summary and Insights

By |November 17th, 2013|Data Analysis|1 Comment

Related pages

sql coding interview questionsinterview questions and answers freshershow to merge two columns in excel 2007technical aptitude test questions and answersvlookup vs hlookupvba combobox listindexexcel join cellswhat is ddl dml and dcl in sqlvba excel saveas overwritehow to write insert query in excelmerge worksheets excelminute meetings templatevba excel sheetexcel for beginners tutorialexcel macro insert rowms excel macros tutorialpowerpoint dashboard examplesexcel vba clear autofilterredim array vbavba delete recordsoftware costing templateworkbook methodscountif examplessum if function in excelexcel vba copy data to another workbookcall function in vbaexcel monthly schedule templateexcel vba code if then statementexcel vba saveas file formathow to merge cells excel 2013sumifs function in excelproject costing spreadsheetvlookup vbaexcel concatinationbasic excel macrocoding vbaexcel look for duplicatesunhide workbookarray lookup excelexcel vba backcolorinserting pivot table in excel 2010netezza sql case statementexcel macro introductionprogress bar in excel vbaoutlook vbasort selected cells by last name in ascending orderexcel transfer data between worksheetslookup command in excelwhat is a vlookupamazing excel templatesscripting.filesystemobject opentextfileproject management powerpoint presentation templateexit loop vba excelwhat is sumif in excelhow to unhide all columns in excelvlookup excel 2007 tutorialexcel delete duplicate entriescopy a worksheet to another workbookunlocking password protected excelfind duplicates in a columnrecording meeting minutes templaterename files vbausing vbaexcel vba worksheetfunctioncheckboxes in excel 2007combine multiple sheets into one sheet excelaccess vba find record in tablesimple excel macro exampleworkbook vbaexcel worksheet mergeexcel vba for loop examplevba query accessdebug print vba