MS Excel Certification Archives - Page 3 of 3 - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

Tutorial for creating a Speedometer dial in MS Excel

Posted on July 29, 2016May 23, 2020 by Dexlab

Here in this video tutorial we have discussed in detailed steps, how to create a Speedometer chart in MS Excel. A Speedometer chart is often called as a gauge chart and combines two different type of charts, a pie chart and a doughnut chart.

The Speedometer dial is made with the help of using a Doughnut chart and needle is actually a combination of two types of charts, another doughnut chart and a pie chart.

A speedometer chart or a gauge chart can be created in other data visualization software as well, like for instance in Tableau and is usually easier to create due to availability of better controls and features. It is due to the simplistic nature of these charts which is well adjusted to context of data and is a great use of space in a spreadsheet that charts like these are popular with non-data executives. Usually such non-data personnel do not want to dig deep into the contextual details like an analyst which is why these charts are great for using in a presentation where diverse departmental executives will be participating.

Gauge charts pack in a lot of horsepower and form a sort of ubiquitous symbol when it comes to understanding business metrics from an analytical point of view. So, learn to create these charts with our simple tutorial and for more such interesting lessons on data analysis software, join us every day as we share technical posts based on data on a regular basis.

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.

Let us Revise Regression Analysis

Posted on May 10, 2016August 13, 2018 by Dexlab

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

Posted on January 15, 2016May 23, 2020 by Dexlab

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

Posted on November 20, 2015May 23, 2020 by Dexlab

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

Gurgaon

Kolkata