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

what is vlookup functionms access vba sqlxldown vbaexcel macro string concatenationexcel vba loop untilloop in excel formulaexcel gotovba hide columnsexcel remove duplicates from 2 columnsvb calculator tutorialadvanced excel vlookupmacro workbookexcel consolidate sheetsuseful vb scripts for windows 7unprotect excel spreadsheet 2010vba secondsredim preserve excel vbaexcel macro exitexcel 2010 data validationcreate userform in excel vba using codems access nested iifvlookup definition wikipediaenable developer tab excelvba beginner tutorialexcel macro for beginnersreverse vlookuppastespecial in vbactrl q excelvlookup partial matchmsgbox promptexcel metrics dashboard templatevba programming in excel examplesvba database connectionexcel vba unhide all sheetsvba access database connection examplevba array definitionsas predictive modeling interview questionsuses of pivot table in excel 2007how to find duplicates in excel 2013excel if cell contains stringadvance filter in excelexcel duplicate recordsexcel vba print formshow developer tab in word 2010iferror function in excel 2010math and trig functions in excelusing vbavba usernameexcel isnumberfso create folderdim in excelworksheets sheet1 rangevba insert rowexcel vba redim preserveselect case vba excelinserting dropdown in excelvba hello worldvba coding excelexcel vba data analysissas macros tutorialhide cells excelcreate sql statement from excelprovider msdasqlvba copy to new workbookusedrange vbashortcuts keys for excelvba not equal towhy we use pivot table in excelvba excel cell colorhow to remove duplicate data in excel 2010excel duplicate check formulavba selected rangetwo dimensional array vbasumif in excel