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

unshare a workbookhow to eliminate rows in excelexcel macro collectionpie charts excel 2010excel 2010 hlookupqlikview delete rowsdelete repeated rows in excelcells vba excelrecordset vba excelexcel hide rowsvba advanced programmingexcel eliminate duplicate rowsusing if statements in excellearn to write vba code for excelmerge sheets excelplanner excel templateexcel vba tricksvba typesprovider msdasqlworksheet vba excelvba code open filexml vba excelexcel if clauseexport excel to txtrun macro when excel opensvba adodb recordsetlearn macrossql basics for beginnershow do i unhide in exceldemographic pie chartexcel userform data validationwriting vba functionspractice pivot tablesaccess vba insert recordset into tableexcel 2010 how to merge cellsworkbooks.activatecase is vbaselecting a sheet in vbahow to delete hidden rows in excelvba thisworkbookunlock spreadsheetexcel vba cells offsetexcel vba user formhow to make tick boxes in excelexcel vba copy formularun vba in excelexcel dashboard creationcreating drop down menus in excel 2007sumif function examplesmerge multiple rows in excelexcel userform exampleshow to merge columns in excel 2007vba excel colorindexlogical formulas in excelunprotecting an excel worksheethow to use pivot chart in excel 2007excel hlookup formulavba select case truevba userform codeexcel duplicate rowexcel array tutorialexcel protect workbookexcel col_index_nummacro in ms exceltime phased budget templatevba databasedo while loop excelpassword spreadsheet templatehow to create stacked bar chart in excel 2010excel goto vbanested vlookupvlookup syntax in excelexcel macro select columnhow to find the duplicate rows in excelexcel spreadsheet project plan templateexcel vba delete blank rowshow to find duplicates in a column in excelexcel 2007 all formulas with examplescombine worksheets