Excel VBA Series – Post – 2 – [ How to enable the Excel VBA Editor]

Excel VBA Editor

How to enable the excel VBA editor ? If developer tab is not already enabled,  follow the below process to enable the developer tab. Right click on the menu bar and click on customize the ribbon.   In the customize the ribbon section , click on the check box developer tab and click ok.   Go to the developer tab and click on the visual basic editor, Right click on the project and insert a new module to write the VB program. Now you can write the subroutine or function you…

Apache Hadoop Series – Post 2 – [ What is Big Data ]

Hadoop

To understand the need for Hadoop, we need to understand what is Big data? Big data came into existence as the collection of data is increasing at an exponential rate. For example, NASA is collecting ~1.73 GB data/second, which is very huge. Different types of data are collected on a daily basis – video , audio , text , pictures, etc So we have a need for high volume of data which has a high variety and needs to be processed at a high velocity. For example : Google needs…

Excel VBA series – Post -1 – [ Excel VBA – Importance and Need ]

excel vba

This is a tutorial series for programming macros using Excel VBA . VBA is otherwise called as “Visual basic for applications” , a programming model used for automating tasks in Excel. Why we need Excel VBA? Formulas and equations written directly in the excel cell ,  has their own limitations. Hard-coded formulas/equations in formula bar at excel cell level can be modified unknowingly. Readability and understanding of formulas/equations in the formula bar becomes increasing difficult for larger analysis of data sets. Analysis on large sets of data within an excel sheet…

Apache Hadoop Series – Post -1 – [ Introduction on Apache Hadoop ]

Hadoop

Organizations all around the world have been storing data for years. Now , Organizations wants to use this data , To understand and analyze existing problems To seize new opportunities and To create more revenue , attain more profitability and to cut down the loses. The study and analysis of these vast volumes of data has given birth to the term – Big Data. The first file system which was introduced to store and process large volumes of data was invented by google called the google file system, otherwise known…