Monthly Archives: February 2013


Record Macro in Excel

The Macro Recorder is a very useful tool available in Microsoft Excel, you can Record Macro in Excel if you want to automate any repetitive task. It helps to save the process time and avoid the human errors. In this section you will learn how to record a macro to automate repetitive task.

By |February 17th, 2013|Excel VBA|1 Comment

Select Cell Range in Excel VBA

We select cell range in Excel VBA to do particular task with the selection. For example we may want to change the background color of a range and we may want to change the font to Bold. In this case we do not required to loop each and every cell of the range to change the background color and font.

By |February 15th, 2013|Excel VBA|12 Comments

Introduction to SAS

In this topic I am giving an Introduction to SAS, explaining the basics about SAS in brief. This is for beginners who are just getting started learning SAS. You will find the learning path for Beginners and Advanced Users. Introduction to SAS - What is SAS? SAS stands for Statistical Analysis System or Software, a

By |February 14th, 2013|Data Analysis|8 Comments

SQL Commands for Data Analysis

SQL Commands will help Analyst to create database,creating new tables and views, update or deleting the existing data. SQL commands help to fetch the data from the database and format it to required standards and summarize to perform analysis.

By |February 13th, 2013|SQL|1 Comment

Change Background Color of Cell Range in Excel VBA

Description: It is an interesting feature in excel, we can change background color of Cell, Range in Excel VBA. Specially, while preparing reports or dashboards, we change the backgrounds to make it clean and get the professional look to our projects. Change Background Color of Cell Range in Excel VBA - Solution(s): We can use

By |February 9th, 2013|Excel VBA|2 Comments

Related pages

excel vba select cellssimple macro excelsample vbaadvanced filter criteria rangevba protect workbookaccess vba sql selectexcel advancedfilterddl commands in sql server 2008 with examplescount vba excelprogress bar vba excel 2010unhide a row in excelvba delete cell contentsexcel vba format cellshade cells in excelexcel vba booleanexcel vba refresh all pivot tablesworksheet function in vbahow to unprotect an excel workbookexcel formula coloruse sumif in excelwhat are dml commandshow to create a dashboard in excel 2007vba inputbox cancelexcel macro dimuse average function in excel 2010simple vlookup in excel 2010excel dim as rangeexcel dashboard designshiding cells in excelhow to change excel columns to rowsexcel substitute functionvba excel macroshow can i merge cells in excelexcel adjust row heightcommand button click vbaexcel macro programhow to select different rows in excelvba chart typesworkbooks.saveexcel templates project managementwhat is meant by vlookupvba active workbookprogrammer interview questions and answersexcel deduplicateadvance excel formulasuserform in vbahow to unhide columns on excellocking cells in excel 2007sumif function excelhlookup samplesample vbscript programsvba tutorial accessuseful macros in excelexcel vba beginnerexcel macro delete rowscolor code vbaexcel vba delete columnsexcel vba code sampleshow to unhide column a in excel 2010vba export to csvwhat are activex controls in wordexcel 2010 match functionvba code to open a filevlookups in excel 2010unhide hidden columns in excel 2010tracking sheet excel templateopen excel file using vbaexcel create macroremove duplicates from column in excelvba activex controlsvba lessonsexcel sendmailautosave excel 2007trim formula excelhow many chart types does excel offerexcel pivot graphsql interview questions and answers for freshers