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

project scope template excelvba cell addressuse of vlookup and hlookup in excelmaster sheet excelexamples of sumifmacro dialog boxproject status report template powerpointif formulas in excel 2007how to copy entire row in excelduplicate check excelfso.movefile overwriteexcel button in cellwhat is vba macro codehow unprotect excel sheet without passwordcapacity planning excel template freevba pivotapplication.worksheetfunction.countamove worksheet to another workbookms access vba run sqlexcel consolidateshortcut keys on excelsimple excel gantt chart templaterefresh excel sheetdelete entire row vbavba trim stringhow do i find duplicates in excelms excel 2010 password protectworksheet in excel definitiondynamic chart in excelvba promptvba function subhow to insert hyperlinks in excelexcel if cell containsexcel unhide sheetmicrosoft excel 2007 vbaauto alphabetize in excelshortcut to switch between excel workbookshlookhow to unhide column in excel 2007insert combo box excelmacros programming in excellearn vba for excelinputbox in vbahow to highlight duplicate rows in excelspecialcells vbaextract hyperlink excelexcel sql commandsvlookup explained in simple termssample meeting minutes template wordexcel hard returnmerge text files in excelexcel 2013 developer tabcreate button vbaadvanced vlookup excelremove blanks in excelexcel insert tick boxdata analysis tab in excel 2007power vbaprotect vba codev look up exampleshortcut keys for excel formulasisna vlookupcosting model excelunprotect excel file 2010sql conditional statementsexcel vba msgbox variablevba sql selectvba xlsbeginners guide to vbahow to select multiple rows in excelquestions for interview for freshers