EC Analytics

Welcome to EC Analytics - Data Science | Data Visualization | Training | Solutions

19

Dec'12

How to use Index Function in Excel

Index Function: Index function returns the value from the specific position in a table or range. Syntax of Index Function …

Read More

19

Dec'12

How to Use Match Function in Excel

Match Function: Match function returns the position of a value in an array. Syntax of Match Function =Match(lookup_value, lookup_array, match_type) …

Read More

19

Dec'12

How to Use Index Match function

Most of the excel user prefer to use VLOOKUP as it is straight forward but there are certain cases where …

Read More

22

Oct'12

Create Userform in Excel VBA

Student Enquiry User form in Excel VBA In this example we will create a User form to ask students to …

Read More

25

Sep'12

Quality Control Line Chart in Excel

Control Line Chart Control Charts are generally used in manufacturing environment to control, monitor and improve the process. The Control …

Read More

23

Sep'12

Import Text Files into Excel through VBA

Import Text files through Excel VBA, There are two ways to import data from text file into MS Excel, Here …

Read More

19

Jun'12

Simple Excel Tip – To calculate difference between two time Slots

  A month back, my colleague Mayank Sharma ( Heavy build – Super hero :)) asked me a question “How …

Read More

24

May'12

Histogram Analysis

A histogram is a graphical representation (Vertical Bar Chart) showing a visual impression of the distribution of data. It’s help …

Read More

19

Apr'12

BoxPlot Chart – Amazing Technique to analyze two or more sets of data

Box Plotting is useful technique when comparing two or more sets of data. Boxplot chart provide an instant insight into …

Read More

12

Mar'12

Pareto Analysis

Pareto-Analysis is a statistical technique in decision making that is used for the selection of a limited number of tasks …

Read More

Social Media

facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting

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