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

excel 2010 password protecthow to create if statements in excelhow to find duplicate rows in excel 2010vba multiplicationcustomer management excel templatetrim in vbaexcel vba color indexundo macro excelunmergesample project timeline excelvba excel remove duplicateswhat is an embedded chart in excelexcel vba sample projectsvba getting startedmeeting minute templatecombine multiple worksheets into one excelsas stands forexcel formula data validationtrend analysis template excelhow to add developer tab in excel 2010open a workbook in excel vbavlookup uses examplesduplicate excel worksheetlistbox excelrange in vbavba userform controlspassword worksheetunhide columns excelexcel interactive tutorialcombine multiple sheets into one sheet excelfunctions in vba exceltask planner templatevba operatorhow to learn vba for excelvba checkboxvba vlookup codemicrosoft vba tutorialvb array lengthif statement in excel 2007excel vba usesexcel combine data from multiple sheetsexcel coding for dummiesadodb recordset vba excelprotected sheet excelchange data source for all pivot tablesmerge and center cells excel 2007vb6 mysql connection stringsales dashboard examplescountif formulasexcel vba adodb connection string sql serverexcel unhide tabsexcel hide sheet with passwordoffset command excelmonthly schedule template excelhow to use sumif formula in excel 2010ms excel password protectexcel template schedule plannervba create access databasems excel vbaexcel vba macros tutorialmicrosoft excel basics tutorialexcel 2007 create drop down listexcel lock sheetinteractive excel dashboardsexcel delete row vbaremove duplicate vbaexcel command buttonsaccess vba updateexcel unhide all rowslearning excel macrosvba excel find character in string