Category Archive: MSEXcel

Interesting Things to Do With Microsoft Excel

Microsoft Excel, whenever you hear this term, you visualise calculations, graphs, tables, formulas and what not – stuffs normally used to arrange and analyse data making pie charts, and countless related gimmicks.

Gaining proficiency in this specific software appears to be a common matter of concern for aspiring professionals from whatever field, they belongs to – and not just the ones who hail from a finance, accounts or IT background.

MS Excel Online training in Delhi

But do you know that MS Excel can be used for other interesting stuffs, apart from regular work-related things, like gaming and art? I guess not.

Leaf through a set of amazing projects completed with Microsoft Excel, which will surely knock you off your feet. So, are you ready?


How to Create a Macro With MS Excel

Did you know that with Excel you can now automate tasks by writing so called programs macros. In this tutorial, we will learn how do so, by learning to create a simple macro, which will executable after clicking a command button. To begin you must first turn on the developer tab:

How to Create a Macro With MS Excel

Developer tab:

Do the following steps to turn the developer tab on:


  1. First right click anywhere on the ribbon, and then click on Customize the Ribbon.



Tutorial for creating a Speedometer dial in MS Excel

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.

 Tutorial for creating a Speedometer dial in MS Excel

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.


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?


Let us revise regression analysis


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.


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.

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.


Using Hadoop Analyse Retail Wifi Log File

Since a long time we are providing Big Data Hadoop training in Gurgaon to aspirant seeking a career in this domain.So, here our Hadoop experts are going to share a big data Hadoop case study.Think of the wider perspective, as various sensors produce data. Considering a real store we listed out these sensors- free WiFi access points, customer frequency counters located at the doors, smells, the cashier system, temperature, background music and video capturing etc.

big data hadoop

While many of the sensors required hardware and software, a few sensor options are around for the same. Our experts found out that WiFi points provide the most amazing sensor data that do not need any additional software or hardware. Many visitors have Wi- Fi-enabled smart phones. With these Wifi log files, we can easily find out the following-

  • Unique visits
  • Average duration of customer visit
  • Total number of customer visits
  • New visitors

We know that getting answers through the Big Data methodology will involve a new person called data scientist. Well, the answer is quite straightforward if we consider a high level architecture. A database management system is required with ingest, store and process capability.

With the Hadoop approach, a data scientist, without any programming language will be able to answer above questions.

Following setup was used:

  • 2 WiFi points to simulate 2 different stores
  • A virtual machine working as central daemon collecting all the log messages.
  • Flume was used to transfer all WIFI log messages to HDFS.
  • A 5 node CDH4 cluster of virtual machines (2 GB RAM ,200 GB HDD,
  • CentOS ).
  • Pentaho DI graphical designer for data filtering, parsing,
  • transformation along with loading data to the warehouse.
  • Hive as a data warehouse system over Hadoop to plan structure of data
  • Impala for querying data in Hive
  • Excel to visualize the results for better understanding.

To collect sample data we turned on the two Wi-Fi routers for a period of five days.Once Impala can execute the CREATE table query statement , a data scientist will have the access of all data from their analysis, reporting tools and BI. You can get more details of Hadoop architecture by getting enrolled in a reputed  Big Data Hadoop Training institute in Gurgaon. You can go through various use cases to understand the big data management in Hadoop.

This is the latest solution around and having a good knowledge in this simply means better opportunities knocking at your doorstep for a great career. Go get enrolled, analyse case studies and sharpen your skills!!!


Ms Excel VBA May Be Used To Predict Sales

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.

banner 11