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

vba excel examplemerge tabs excelvba tutoriavba sort excelduplicate rows excelvba excel workbooks.openvba excel basicsvba concatenatehow to delete duplicate values in excelexcel saveas fileformatremove password from excel workbookvbcr vbams excel shortcuts keys listexcel vba substitutetick box excelunlock password excel fileexcel activeworkbook.saveasvba arrays excelmsgbox vbyesnoexcel vba delete duplicate rowshow to learn vba in excelvba macro buttonsortable columns excelvba create graphhow to password protect excel 2013vba excel find character in stringhow to create data entry form in excel 2007create hyperlink in excelexcel macro close excelpaste special transposegantt project planner excel templateproject management dashboard template excelvb coding for excelexcel userform vbahow to cut and paste in exceladvanced excel dashboardsexcel vba new worksheetunhide excel columnhow do you remove duplicate rows in excelconcatenate excel formulasmerging cells in excel 2010timevalue in excellogical formulas in excel 2007 with examplesmicrosoft excel macro programmingvba code to close excel filecolor by code worksheetsvba sortingresource allocation template excelexcel macro programming tutorialvba access recordsethow to delete extra rows in excelsql query interview questions for freshersexcel formula sortsql questions and answers for written testsingle vbavlookup alternativecount vbavlookup meaning in excelexit loop vba excelinterview question on c language with answers pdfautofit in excelexcel test for finance interviewwhat is the use of vlookupdelete duplicate recordsstart vbaexcel hyperlink cellexcel sql queriesgoto in vbacsv to xml excelvba msgbox variableshortcut keys for excel 2007