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

create sheet vbaexcel vba uppercaseexcel formulas with examplesglobal variables in vbausing lookup function in excelvba replace methodvlookup excel templateunprotect excel 2010vba concatenate functionautomation testing interview questions and answers pdfappend excelhow to make pivot tables in excel 2010excel vba copy data to another workbookexcel vba pivot table filterexcel vba columnwidthvba selection endexcel macro copyexcel vba controls collectionmessage box in vbausing vlookup function in excelexcel if cell containsexcel remove empty rowsinsert chart title excelfind and delete duplicates in excelsearch duplicate in exceldim rs as recordsetexamples for vlookup in excelaccess vba while loopmicrosoft excel chart tutorialexcel advancedfilterbox plot excel 2010 templateunlock excel 2010 password protected fileconverting excel to xmllearn to write macros in excelformula in excel vbadatevalue vbaactivesheetexcel find duplicates and deletedemographic chart templatevbyesno msgboxvba isnaexcel 2010 delete duplicatesexcel 2007 shortcut keyhow to unlock an excel spreadsheetarrays excel vbapowerpoint vbasql pivot tutorialexcel conditional rangeunhide cellsuserforms in excel 2010excel vba activecell.addressexcel userform examplesexcel vba open excel fileexcel formatting cellsvba integer to stringuserform vbamaximum number of sheets in excel 2007ifcount excelhow to change the height of a row in excelinsert a check box in excelproject management spreadsheet excelinput in vbamerge rows excelexcel delete duplicates in columnsql vba accesslistbox controlselect case statement vbaexcel delete duplicate linesoutlook attachment vbaworkbook worksheetsvb clear listboxmicrosoft excel charts tutorialvba savecbo box officeexcell lookup