Nikhil L. - Microsoft Excel Developer

Nikhil L.

Microsoft Excel Developer

India | Asia/Kolkata (USD)

$58/hr
Part-time:10-30 hrs/week
1, Followers

ABOUT ME

Testimonials (Upwork) ---------------------------------------------- "Our only regret is that we didn't find Nikhil sooner! " "He's skilled, patient and reliable. " "Always timely, courteous and professional. He's our go-to-guy. " "Very punctual and pays perfect attention to detail." Microsoft Excel ---------------------------------------------- ✓ Data Consolidation, Manipulation, and Re-Organization ✓ Excel to PDF Conversion ✓ Automated Emails through Outlook ✓ User Defined Functions/Formulas. ✓ Formatting and Conditional Formatting ✓ Data Filtering, Sorting, Validation, and Cleanup ✓ Excel Formulas - Basic and Advanced ✓ Charts (Static and Dynamic) - 4-Quadrant, Box, Temperature, Waterfall, Gauge etc. ✓ External Data Import (Text, Database, URL) ✓ Tables, Pivot Tables and Pivot Charts Professional experiences: ------------------------------- I've acquired the following experiences (that cuts across multiple roles and capacities) with organizations, that have employee bases as large as 150,000: -- Customer Support -- Software Application Administration -- Software Development -- Software Application Testing -- Market Research -- Business Analysis -- Data Analysis -- Pre-Sales Consulting Given the foundation I've built during my career, I believe I will add superior value to my clients and of course, myself.

SKILLS

EMPLOYMENT HISTORY OUTSIDE OF TOOGIT

Trainee Programmer

IBM - Aug, 2007 to Nov, 2007, Bangalore

Siebel Administrator & Support Analyst

IBM - Dec, 2007 to Jul, 2009, Bangalore

Siebel Application Developer

IBM - Aug, 2009 to Jul, 2010, Bangalore

Marketing Assistant Intern

Videocon - May, 2011 to Jun, 2011, Mumbai

Associate Consultant

Infosys - Jun, 2012 to Jan, 2016, Pune

Freelance Excel Developer

Upwork - Feb, 2016 to present, Nalgonda

Excel Developer

Excel Rescue - Feb, 2018 to present, Nalgonda

EDUCATION HISTORY

B.Tech, Electronics and Communications Engineering

(2003 - 2007) Swami Ramananda Tirtha Institute of Science and Technology

MBA, Operations and Marketing

(2010 - 2012) Indian Institute of Technology Roorkee
The idea is to use Microsoft Excel to plot employees of a fictitious organization, based on their corresponding performances across two axes - Skills and Attitude, both on a scale of 1 to 10. Accordingly, all the employees can be categorized as below: Upper Right Quadrant -- To Reward Upper Left Quadrant -- To Coach Lower Right Quadrant -- Dangerous Lower Left Quadrant -- To Fire
This task was accomplished using Microsoft Excel's Text-based Formulas, that needed little or no manual intervention in dividing a list of about 900 Full Names into corresponding First and Last Names. The sample that was converted, is attached herewith.
This job involves me making an automatic Gantt Chart - based on Excel Formulas and Conditional Formatting. This will take the Start and End dates for a particular stage of a project, and will accordingly produce visual timelines for each stage.

RATINGS AND RECOMMENDATIONS ON TOOGIT

Excel spreadsheet needed to automate repetitive work

No feedback given

4
XLS conversion required using automation

Great work

5
Further Excel Macro VBA Customization

I continue to use Nikhil because of his speed, fluency and accuracy. Awesome work!! A+

5
VBA Page Breaking

Excellent and brilliant with excel, macros, logic and speaks perfect English.

5
VBA Page Breaking

Very prompt, excellent at following directions, and patient with a few changes I needed!

5
Excel Macro's

Grat Job, Great Communications and Finished product above expectations

5
Excel formula to extract first names from email addresses (e.g. "Billy" in billyhoffman@x.com)

Nikhil coded an Excel macro for me that intelligently recognizes and extracts first names from email addresses by comparing strings with a given list of typical first names. Communication was excellent, and turnaround time was quick. I can recommend Nikhil for any type of Excel macro tasks.

5
Need Excel Document Expert for Script to Replace Placeholder data per row across multiple sheets

Quick work on a project of immediate need and perfect results!

5
Excel to Gantt Chart

No feedback given

Formatting Excel Tables

great

5