Yearly Archives: 2013

Home/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

Chart Styles Layouts and Templates in Excel

Creating Charts in Excel is very easy, we change the look and feel by working with Chart Styles Layouts and Templates in Excel. Chart Styles, Layouts and Templates in Excel help us to change the look and feel of the charts to create rich visualized charts in excel for your data. Working with Styles in

By |September 24th, 2013|Excel|0 Comments

Create Charts in Excel

Well! we have seen some basics of charts in the previous topic. Now, we will see how to create charts in Excel. In this session I will take your through the step by step to create basic charts in Excel. Then we will see the advanced charts options to customize charts in Excel. Getting Started

By |September 22nd, 2013|Excel|0 Comments

Excel Chart Elements and Chart wizard

Many of our readers asking me to post tutorials to understand Excel Chart Elements and Chart wizard. This is the topic for those who wants to understand and getting started with excel charts. In this topic, We will see what are the different objects or elements related to charts, and how to access chart elements

By |September 22nd, 2013|Excel|2 Comments

Introduction to Collections in Excel VBA

Collection is an object contains group of objects having similar characteristics (with same properties and methods). For example,if you want to loop through all worksheets in a workbook, you can refer worksheets collection of the workbook and do whatever you want to do with that particular worksheet.

In this topic:
  • Introduction to Collections?
  • Collections in Excel VBA
  • Examples Macro File On Collections

By |August 25th, 2013|Excel VBA|1 Comment

ListBox in Excel VBA – Adding, Clearing, Multiple Selection Examples

ListBox VBA Excel Example Macros Codes for Adding new Items,Moving all Items, selected Items from ListBox to another ListBox,clearing,Multi selection. VBA ListBox in Excel is one of finest control in the Excel. You can show the list of items in the listbox and user can select any item and do different operations. In this tutorial,

By |August 24th, 2013|Excel VBA|21 Comments

ADO in Excel VBA – Connecting to database using SQL

ADO Stands for ActiveX Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server. ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source. Most of the times OLE DB providers are specific to a particular Data Source Type. However, we have an OLE DB provider for ODBC, it is a general purpose provider with help of this ADO can access any Data source which can understand ODBC.

In this topic:
  • What is ADO?
  • What is Database?
  • What is SQL?
  • Practical Learning: Using ADO and SQL with VBA
  • Example File

Events in Excel VBA

Event programming is the most useful tool which helps to monitor specific user actions within Excel. For example, if the user Opening a Workbook, Selects a Worksheet, enters data into a Cell, or saves a Workbook, these actions are all Excel Events.

In this topic:
  • What Are Events?
  • What Are The Different Types of Events?
  • Practical Learning: Workbook_Open Event
  • Example File: Workbook Events, Worksheet Events and Form Events

By |August 11th, 2013|Excel VBA|6 Comments

Related pages


vlookup and functionexcel vba instr functioncreating drop down menus in excel 2007excel averageif functionrows excel vbavb6 copy fileexcel macro duplicate sheethow to merge fields in excelexample of a vlookup formulaexcel hlookup formulainfosys interview questions and answers for freshersstacked pie chart excelms excel macro programmingunhide column a excel 2010excel advanced macroshow to merge to rows in excelexcel chart headerpivot table excel 2007 examplevba delete a filesimple gantt chart template excel 2010all shortcut keys of excel 2007sumif formula exceltext box controlexcel macro copy pastehlook up examplemost useful formulas in excelexcel vba range cellshow to delete duplicate data in excelexcel carriage returnmacro to delete rowscombobox excel 2013byval vbavbyesno in vbacut and paste methodsas interview questions pdf free downloadhow to hide tabs in excelsql queries for interview pdfvba wordvba programmersexcel vba file pathhow to create combobox in excel 2010delete duplicate data excelhow to remove duplicate data in excel 2010how to hide formula in excel 2007 without protecting sheetexcel vba read onlyvba colour indexmerge excel worksheets into one master worksheetexcel 2007 remove duplicatesmacros in databasedelete range vbaexcel vba cell offsethow to hide cells in excellms excel offsetcopy data from multiple worksheets into oneddl commands in sql serverexcel macro columninterview questions on testing for freshersswitch between sheets excel shortcuthow to check duplicate values in excelcalling functions in vbaexcel pivot table shortcut keyconditional statement in excelvba msgbox vbcriticalvba counta functionexcel vba code libraryexcel macro find last rowhandy excel macrosfrequently asked technical interview questions and answers pdfhow to eliminate duplicate records in excelvba worksheetsmerge cells in excel 2010excel project budget templatewhat is vlookup functionunlock xls passwordvba adodb recordset examplevba excel codingvba excel left function