Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Satish Phalke | Elance
 
176985602337900
Last Sign-in: Nov 17, 2017

Satish Phalke

MS Excel Expert VBA,Automation,VA
   India
  |   New Mumbai, Maharashtra
  |  4:09 pm Local Time

Verified Freelancer

Satish Phalke's identity has been verified.  Learn More

Overview

Minimum Hourly Rate $5

I am FULL TIME FREELANCER with 8 Yrs of Exp in building advanced EXCEL using formulas,Pivot Tables,Graphs,Charts, VBA ,Data Validation, Conditional Formatting & many more advance Functions in Excel .I am available for more than 40 hrs in a week.By qualification, I am a MBA in Finance & worked with the largest & most respected Organisations in India.My Excel and Accounting skills are tested out in the TOP 10% of all eLance users.If you need excellent Excel spreadsheet,Reports,Analysis,Reconciliation of complex and large data...

Read More »
Dec 28, 2015|Data Entry|$25|Completed
|
4.9
Dec 11, 2015|Virtual Assistant|$14|Completed
Nov 4, 2015|Transcription|$2,000|Completed
Nov 4, 2015|Transcription|$1,675|Completed

View All »

Portfolio

By Date ranges to update Graphs,Tables on clicking Excel Button created using VBA/Macro
Automated Calendar by Date,Time and Name for Different Phases of Business Meetings...
Excel Tax Return Template created using various formulas for more than 250 Tabs
Automated Charge Sheet /Bill with Summary for Different Price Ranges using combination...
Microsoft Word Template Design and Formatting
Research on Advertising Agencies in Australia to find Website,Address,Client...
60,000 Corporate Contact List Extracted with use of Import from web function and Macro...
Converting PDF to Excel/Word/PPT/Text to change data into usable business information

Skills (6)

Tested
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
Microsoft Word 2007 Test
My Score
avg
Accounting Principles Test
My Score
avg
Computer Skills Test
My Score
avg

Service Description

• Building Advanced Excel Spreadsheets & Dashboard Reports.
• Data Cleansing,Analysis,Reconciliation of Complex & Large Data Sets
• Management & Performance Reporting
• Graph,Charts,Tables,Pivot Tables And Pivot Charts Generation
• Automation Of Spreadsheet Reports Using Advance Functions
• Expert In Vlookup,Hlookup, If, And, Or, Index/Match, Sumif(S), 
• Countif(S),Trim,Len,Concatenate,Mid Etc
• Data Validation,Conditional Formatting,Consolidation,What-If Analysis
• Vba (Excel Macros)
• Financial Reporting In Excel
• Bookkeeping,Bank Reconciliation,Ledger Scrutiny
• Internet Research To Extract Email,Phone,LinkedIn
• Data Extraction From Website To Excel
• PDF To Excel/Word Conversion 
• Excel Data Entry And Web Data Entry

Read More »

Employment

Times Of India Group
Manager
2007 - 2013
Accounting,MIS and Reconciliations.

Education

ICFAI
MBA in Finance
-
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

MS Excel
MS Word
Data Entry
Data Mining
Research
Data Cleansing
Reconciliation
Reports
Pivot
Graphs
Charts
Tables
Formulas
Accounts
Bookkeeping
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
satishphalke
Type
Individual
Member Since
January 2014
Elance URL
Verifications
0
Groups
Satish Phalke | Elance

Satish Phalke