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|10 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