EXPLORE

Data Analytics Data Architecture Excel Photoshop
Profile cover photo
User Avatar

Indika W.

@INDIKAWIC

5.0
1

1.8

1.8

100%

Specialist Excel Functions,Graphs & Data analyzing

$10 USD / Hour

・

Flag of

Sri Lanka (6:18 AM)

・

Joined on October 4, 2014

$10 USD / Hour

・

I am expert for Excel Functions; because during last 15 years I developed more than 1,000 new functions to meet desired goals. For Excel functions, I believe nothing is IMPOSSIBLE. Familiar with DATEDIF, SUBTITUDE,VLOOKUP, HLOOKUP, FIND, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IF , AND, OR , CONCATINATE, INDEX, MATCH LEFT, RIGHT and MID etc. Expert to combine any number of functions during last week I develop new Excel function do FIND and REPLACE for any number of Field using more than 10 substitute function and I can extend this for any amount. Also I am capable to I can create any kind of Chart/Graph Bases on requirement this can generate through my Data Analyzing which currently experience more than last 15 Years working with Excel for Data analyzing. I am familiar with all kind of chart types, last week I manage to develop Wheel graph which Plotted based on the set value and criteria. I am capable enough to analyze information through Pivot chart/Pivot graph. I am Expert for slicers and it help me to present your PIVOT chart or Graph to very presentable manner, Also I can help you to combine few Pivots using one controlling point as well. And also I am expert for matching any no of work sheet or any amount of data and extract final out put according to client requirement. I am graduated as Manufacturing Engineer on 2005 and In 2008 I completed my Manufacturing management Post graduate Degree as well. Currently I am working as group Planning manager and more professional on data analyzing and Integration, because as planning manager I need to understand future according to historical data. Also I am able to compete any project within the set time period and most probably in advance because always I concentrate my projects as my life.

Verifications

On time

100%

On budget

100%

Portfolio

Portfolio

6285248
2384823
2378127
2360985
6285248
2384823
2378127
2360985
5.0 · 1 Review
1 Review
User Avatar
Flag of

Jason S.

5.0

$15 USD

6 years ago

Excel Calc Issue - SUMIFS Not Calculating

fast work thanks

Share

Experience

Planning Manager

Feb, 2014 - Present

•

12 years, 5 months

Penguin Sport ware (Pvt) Ltd

Feb, 2014 - Present

•

12 years, 5 months

Responsibilities Need to hit committed budget for all 4 Plants Make sure to fulfill the all plants Make sure to accuracy of ERP system

Feb, 2014 - Present

•

12 years, 5 months

Education

University of Colombo

2007 - 2008

•

1 year

• Post Graduate Diploma of Manufacturing Management

Flag of

Sri Lanka

2007 - 2008

•

1 year

University of Moratuwa

2000 - 2005

•

5 years

B.Sc. Engineering degree

Flag of

Sri Lanka

2000 - 2005

•

5 years

Qualifications

Effective communication skills

2006

BRITISH COUNCIL

Get train about both Verbal and writing communication skill.

2006

Publications

Project manager in SAP implementation

Textprint Lanka Private Limited

• Lead SAP project during 3 month period of time from 2011 November to 2012 February. • Solve day to day SAP problem and take necessary action to error proof.

Certifications

Freelancer Orientation

Freelancer Orientation

E

Employer Orientation Exam

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)