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

delete row excelhow to pull data from another workbook in exceluseful vba codeuse average function in excel 2010how to add command button in excelinteractive charts in excel 2010vb net excel column widthlearn advanced sql programmingspider web chart excelhow do you create a filesystemobjectexcel tutorial charts and graphsaction item log template exceldelete duplicate row in excelunprotect excel workbook without passwordvba status baradodb connection string oraclevbscript if statement with multiple conditionsexcel vba scripthow to create macro button in excelexcel vba usedrangeremove hyperlink from excelexcel formulas pdf with example 2007 in hindistacked pyramid chart excelrun vbaclose userform excel vbaexcel coding for dummieshow do i do a pivot table in excel 2010ascending order and descending order worksheetvba range selectexcel vba addressvlookup rangesql dml ddl dclexcel vba sleepexcel implementation plan templatehow to remove protection from excel sheetvba definerefresh all pivotsforms.comboboxhide columns vbaapplication calculation xlcalculationautomaticword 2010 show developer tabexcel unhide workbooksample meeting minutes template wordexcel formula colorexcel vba clear clipboardexcel vba open word documentcells worksheetdelete row excelexcel greater than formulawhat is an array in vbamessagebox usingcreate button vbavlookup function in excel examplevba object oriented programmingvlookup and hlookup tutorial pdfhow to refresh a pivot tablesendmail subjectexcel hide sheet with passwordshort cut key of excelexcel function hlookupsave workbook in excelexcel remove duplicates from columnfor each in vba excelisna excel formulasample excel macro codeautofilter vba excelcheck for duplicates excelhow to create macros in excel 2003file handling in vbscriptexcel vba active workbookhow to create userform in excel vbaunhide excel worksheet