# EC Analytics

28

Dec'17

### Sort Sheets Alphabetically-Excel VBA

PROBLEM STATEMENT Sort all worksheets in A-Z/Z-A order For Example: In the below screenshot worksheets are not sorted in any …

Read More

27

Dec'17

### Merging Multiple Rows based on Criteria -Excel VBA

PROBLEM STATEMENT Most of the time we deal with duplicate values in excel, same situation we have here. In our …

Read More

21

Dec'17

### EXTRACT NUMBER FROM STRING – UDF

PROBLEM STATEMENT One of my student asked me this question in this weekend class, how can we extract characters from …

Read More

28

Oct'17

### Excel Pareto Add-In

What is Pareto Analysis? The Pareto principle (also known as the 80/20 rule, the law of the vital few, or …

Read More

24

Oct'17

### Online Retail Store Sales Dashboard

In this article, we will visualize one sales dashboard of an online retail store company. This dashboard will help the …

Read More

02

Oct'17

### Quadrant Analysis in Tableau

Let’s talk about tableau corporate training in Delhi NCR. Quadrants are very versatile and they can be designed by keeping different …

Read More

19

Sep'17

### “ONE VARIABLE CORRELATED WITH ANOTHER VARIABLE” – SCATTER PLOT CHART

When we see random(Scatter) things we plan to organize them, and then we think how we can do that in …

Read More

18

Jun'16

### ANOVA (Analysis of Variance)

ANOVA is a statistical method that stands for analysis of variance and it is used to analyze the differences among …

Read More

04

Jun'16

### Learn How to create Normal Distribution Graph in Excel (Gaussian distribution)

In this page, we will talk about what we teach in excel corporate training in Gurgaon. The normal distribution is a …

Read More

28

May'16

### Print Value from Closed workbook

Last week one student sent this question over email, so sharing it now.. Hi, I am a student of Analytix …

Read More

#### Social Media

Address:

NM 23, SECTOR 14, OLD DLF COLONY,
GURGAON (HARYANA)
0124- 4601426

#### ABOUT EC ANALYTICS CONSULTING

EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED

Receive the latest news

## Subscribe To Our Weekly Newsletter

Get notified about new articles