Monthly Archives: June 2013


Data Analysis – An Introduction

Data Analysis is important to every organization to survive in this competitive world. In recent years every one wants make use of data available to understand their business to take effective decisions. I spent around 10 years in analyzing the data. And played different roles to help my clients to take effective decisions. In this topic I am going to discuss the basics of data analysis to give an overall idea about Data Analysis.

In this topic:
  • What is Data Analysis?
  • Why do we need Data Analysis?
  • Approach to do Data Analysis
  • Different kinds of Data Analysis - By Request
  • Different kinds of Data Analysis - By Domain
  • Useful Links for Data Analysis

Interacting with Other Applications using VBA

We can interact with the other applications using VBA - with the MS Office Applications like Word, PowerPoint,Outlook,etc... and other applications like Internet Explorer, SAS,etc.

In this Section:
  • Introduction?
  • How to interact with MS Word? - Late Binding
  • How to interact with MS Word? - Early Binding
  • How to interact with PowerPoint? - Early Binding
  • How to interact with Outlook? - Late Binding
  • Example File

VBA Security in Excel

It is important to understand the macro security if you are dealing with the Macro Enabled Files. It helps to protect your data from the malicious programs and helps to know how to run the macros when its required.

In this Section:
  • Understanding VBA Security
  • What are the different Levels of the Security in VBA?
  • How to Enable or Disable the Macros?
  • How To Protect VBA Code?

Related pages

underline fontssql aptitude questions with answers pdfvba connect to access databaseusing vba in excel 2007excel vba pivotexcel hyperlink to cellsumif and or functionexcel vba textboxhow to unprotect workbook in excel 2007unhide rows in excel 2010vba filenamehow many rows and columns in excel 2007excel macro variableresource planning spreadsheet templatevba range syntaxexcel 2013 data validationexcel bubble chartsvba option button selectedexcel combo boxvba dropdownddl dml dcl tcl commands sql servercombining chart types in excelvlookup excel 2010 examplevba chartdatediff vba excelstatic vbacheckbox excellast cell in excelcreating macro in excelvba code to open excel filedata definition language commandsvba code to insert data into access tablevba create databasevba nested loopscombine sheets in excelvba sqrt functionsas macro interview questionslogical functions in excel 2007resource capacity planning template excelexcel vba lastrowvba code for yes no message boxpm templates for excelvba excel tutorial for beginnerspaste special values macromerge 2 columns in excelshortcut formula in excelhow to delete lines in excelaverageif functioninsert multiple rows excel 2010excel vba lookup value in arrayhow to create macros in excel 2007format excel vbaworkbooks vbacreating charts in excelexcel vba tabexcel delete duplicate linesvba name rangehow do you sort columns in excelexcel vba sheet referenceconvert excel to csv comma delimitedhow to autofit in excel 2010access vba input boxexcel shortcut edit formulaif na vlookupexcel vba rows.countvb 6.0 interview questions and answersvlookup example excel 2010vba count rowsrows vbaprompt vbacopy a worksheet in excelvlookup in excel 2003 with exampleexcel remove duplicate rowhow to convert xls to xml formatvba declare variablesadodb connection example