Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Amit J. | Elance
 
176985602337900
Last Sign-in: Oct 30, 2014

Amit J.

Excel Expert
   India
  |   Faridabad, Haryana
  |  4:11 pm Local Time

Overview

Minimum Hourly Rate $9

I have 5 years experience in designing user friendly Excel templates, spreadsheet solutions using VBA (Visual Basic for Applications) and preparing Dashboards.

I focus on developing easy to use applications, quality of data & reports by applying checks & validations. I have conducted corporate trainings on Basic & Advanced features of Excel (data entry, data management and analysis). I also specialize in Word documentation, PowerPoint presentations.

Read More »

Portfolio

Skills (7)

Tested
Microsoft Excel
Business Analysis
Budgeting & Forecasting
Computer Skills
Data Entry
Microsoft PowerPoint
Microsoft Word

Service Description

The key skills that I possess include:

1) Design MIS & Reporting Formats - Using advanced Excel (Complex formulas, Macros, VBA Forms)
2) Data Entry, Collation & Cleansing – Formatting, de-duplication, validations, Sorting, Filter
3) Data Analysis – Trend analysis, Pareto analysis, Charts, graphical presentation
4) Automated Reports & Dashboards – Pivot tables, Productivity & Performance Dashboards
5) Budget Management – Monthly & yearly business plan (Revenue, Capex & Opex)
6) Object Linking & Embedding – MS Office Applications (Word, Excel & PowerPoint)
7) MS Word documentation, MS PowerPoint presentation
8) Data Transformation/Conversion - PDF to Excel, Word to Excel, Word to Image

Completed Assignments :-

1. Vocational Training & Placements:

Developed stand-alone application “Student Enrollment System” using MS Excel as Back-end and Visual Basic Form as Front-end.

2. Travel & Tourism:

Designed stand-alone application on Travel & Tourism using advanced features of MS Excel.

Apart from these applications, I have designed Excel templates for Cash Book, Budget management, Trainer utilization, Student attendance, Micro-level Batch Planning and Sending Bulk Emails.

Read More »
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Excel
VBA
Macro
Word
Data
Powerpoint
Analysis
Dashboard
MIS
Report
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
amit-mis
Type
Individual
Member Since
April 2013
Elance URL
Verifications
0
Amit J. | Elance

Amit J.