Advanced excel course in gurgaon Archives - Page 2 of 2 - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

Let us Revise Regression Analysis

Let us revise regression analysis

By now every business owner and manager is aware of the latest megatrend related to data analysis and knows that they should make data-driven decisions only at work. Gut feeling and winging it are now practices outdates as they have proved time and again that they fail. But the problem still remains in the know-how of parsing through all the layers of data streaming into your systems. Do you have the requisite know how?

Luckily for you, you may not be the one to crunch all the numbers (phew!). You pay other robotic data analytics personnel to do that for you. But you must correctly understand the analysis report that is handed over to you for interpretation after your colleagues are done with all the heavy lifting. A common practice is the realm of data analysis is regression analysis. Continue reading “Let us Revise Regression Analysis”

Gain Expertise in MS Excel with DexLab Analytics


MS Excel needs no introduction as spreadsheet program. As part of the MS Office suite it has been a regular software skill expected from employees across the globe regardless their roles or levels. But the utility of MS Excel in the world of Big Data is not so widely acknowledged due to the lack of awareness. But that does not rob it of any of its sting as a Big Data tool to advanced Excel users.

So if you are keen to know more about the emerging technology that elite techies cannot stop raving about, a solid grounding in MS Excel will serve you well. Accordingly DexLab Analytics has scheduled a symposium on the topic of Designing MS Excel Dashboards as an introduction to the Big Data capabilities of Big Data to aspiring data analystand data scientists. The symposium is going to be MS Excel Experts who also instruct students of DexLab Analytics most of whom have been advanced users of MS Excel for more than a decade.

How to Create a Macro With MS Excel – @Dexlabanalytics.

The main speaker of the symposium is an industry expert who is currently attached with a leading Multi-National Company for over 5 years. He will bring with himself invaluable information regarding the latest developments in data science. We will cover the following topics in the meet scheduled to be held on the 26th of January:

  •  MS Excel functions overview like V Look Up, Match, H Look Up, Address, Match, Countlfs, Indirect, Sumlfs amongst many others.
  •  Introducing the world of recording macros and building VBA.
  • Introducing Advanced Excel with abilities in Dynamic Referencing and pivot.
  • Hot to make use of Excel and VBA in order to generate KPI dashboards.

The interactive session with industry professionals with many years of experience and help you acquire invaluable exposure to the basics of MS Excel so that you get a foretaste of what lies in store for you in this new and exciting world called Big Data.

Note: It is assumed that the participants of this event have a basic understanding of the rudiments of statistics.

Looking for an Advanced excel training in Gurgaon? Drop by DexLab Analytics – their Excel dashboards training is unparalleled!


Interested in a career in Data Analyst?

To learn more about Data Analyst with Advanced excel course – Enrol Now.
To learn more about Data Analyst with R Course – Enrol Now.
To learn more about Big Data Course – Enrol Now.

To learn more about Machine Learning Using Python and Spark – Enrol Now.
To learn more about Data Analyst with SAS Course – Enrol Now.
To learn more about Data Analyst with Apache Spark Course – Enrol Now.
To learn more about Data Analyst with Market Risk Analytics and Modelling Course – Enrol Now.

Ms Excel VBA May Be Used To Predict Sales

banner 11

MS Excel VBA has uses in various facets of day to day activities of businesses. But it is a little known factthat this tool may also be used to carry out advanced functions like predicting future sales. This blogpost will try to represent in as an illustrative way as possible how it manages to do the same with thelimitations imposed by the format of this text based post.Suppose we have sales data of two sets for 24 periods within the time range of January 2013 to the December of 2014.

What we are trying to do is to utilize the function LINEST in order to predict sales for the year 2015 by making use of method of least squares as well as regression analysis. The elementary knowledge of this function suggests that it is worth sharing. In the lines that follow we will try to examine the rudiments of this function and the formula that we will put into use in the calculations we make.

The use of the LINEST function lies in regression analysis in order to make calculations about a line that uses the least squares method and return a straight line that is best fitted to the data that you input and outputs an array that serves as a description of the particular line.


The equation that represents the line is: y = mx + b


Here m stands for the slope, x represents the period of time dealt with the data and b is the y intercept.It is to be noted that there is necessity of having a column that indicates the period number of the existing as well as future sales. It should also be noted that while you use the LINEST function so that you may calculate the values of the Y- Intercept along with that of the slope those cells need to reside side by side.

So, what one has to do is to highlight the two cells that you want to use in order to make calculations of the Y-Intercept and the Slope before typing in the LINEST function. In such cases all that is needed is to include the “y”s that are already known. It is up to you whether you want to provide other arguments as they are optional. Then all you need to do is press Ctrl+Shift+Enter and you get the Y-Intercept and the Slope.

The magic that takes place in the background is basically this, by making use of the Slope and the Y-Intercept Excel does its crystal ball gazing and takes the last sales data of the precious 24 months and creates a straight-line that forecasts the trend that is likely to persist in the coming 12 months.


What Excel actually does is that it takes the actual values and manipulates them slightly to that is able to come up with a straight-line that serves as the trend line that extends out to the periods of forecast and thus the actual values and the values of the forecast have trends that are similar.This is the basics of crystal ball gazing through the use of MS Excel.


Want to shine bright in MS Excel? Visit DexLab Analytics – their Advanced Excel course is truly remarkable. Enrol for Advanced Excel training today.


Interested in a career in Data Analyst?

To learn more about Machine Learning Using Python and Spark – click here.
To learn more about Data Analyst with Advanced excel course – click here.
To learn more about Data Analyst with SAS Course – click here.
To learn more about Data Analyst with R Course – click here.
To learn more about Big Data Course – click here.

Call us to know more