EC Analytics

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

03

Feb'13

Waterfall Analysis in Excel

Waterfall Analysis Waterfall is a form of data visualization, which shows how a value increases or decreases to come to …

Read More

17

Jan'13

Combine multiple excel workbooks into one worksheet of new workbook

This is very common situation where user have long list of excel files and want to combine all file into …

Read More

30

Dec'12

Doughnut & Pie are Mom and Dad of Speedo Meter Chart

How to Create Speedometer in Excel? Speedometers Charts are easy to understand (you can see them in your driving vehicle), …

Read More

30

Dec'12

Doughnut & Pie are Mom and Dad of Speedo Meter Chart

How to Create Speedometer in Excel? Speedometers Charts are easy to understand (you can see them in your driving vehicle), …

Read More

19

Dec'12

How to use Vlookup

Vlookup stands for vertically lookup from the leftmost column of the table, its look for the data in the same …

Read More

19

Dec'12

How to Use Offset Function

Offset Function Offset function returns the reference to a range that is a given number of rows and columns from …

Read More

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

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.

Social Media

ECAnalytics-facebookECAnalytics_Linkedin

Address:

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

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED