Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel Business Intelligence | Elance
 
176985602337900
Last Sign-in: Mar 28, 2015

Excel Business Intelligence

Excel,VBA,VB.NET,XML,SQL,CSV,PDF, data management
   Poland
  |  8:32 am Local Time

Overview

I'm an experienced Excel VBA developer as well as a business consultant. I create advanced Excel based tools for SMEs and large corporations.

I also work with Access, Word, Outlook, PowerPoint, Visio.

VBA is my "native language".

I have Master's degree in project management and Bachelor's degree in finance. Worked as IT project manager and CIO in manufacturing, retail, real estate development and marketing companies with from 15 to 20000 employees before started my own business.

I work on Elance since October 2011. Have happy clients...

Read More »
Mar 24, 2015|Software Application|Private|Working
Mar 17, 2015|Other - Data Science|Private|Working
Mar 15, 2015|Web Programming|Private|Working
Mar 4, 2015|Software Application|Private|Completed
|
5.0

View All »

Portfolio

Excel Business Intelligence has more then hundred of happy clients. We work with sole...
Multiple jobs in Admin Support category completed on Elance. Amazing feedbacks with 5.0...
https://www.elance.com/s/xlbin/job-history/10179/?t=1
https://www.elance.com/s/xlbin/job-history/10186/?t=1
About 100 jobs in IT & Programming category completed on Elance. From $20 simple...
https://www.elance.com/s/xlbin/job-history/10183/
PDF presentation of Excel Business Intelligence
In large and complex VBA projects I use my own centralized error handling system. Error...
In all my Excel projects if any macro works more then just a moment I use Progress Bar...
Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code...
More than two months of full time work. Thousands of VBA code rows. New worker was...
Advanced Excel VBA forms and VBA code created for existing tool. Multiple tabs,...
Excel VBA tool to parse multiple large OCRed PDF documents into CSV files. SQL queries...
Ribbon button with menu buttons: 1) to apply formatting to selection, active sheet or...
https://www.elance.com/j/excel-plug/30911450/
Months of full time word. Thousands of VBA code rows. Advanced tool for wooden windows...
Excel VBA tool created to get financial reports from specific password protected web...
The tool checks if images listed on Excel sheet exist on web site. Multithreading used...
Excel based tool for income, expenditures, assets etc. structure analysis. The...
Form to filter data from large Excel database by multiple fields. SQL queries used to...
Microsoft Word VBA program to parse multiple Word documents (reports) with similar (but...
Access VBA tool for transport optimization created. The tool uses third party DLL...
Access VBA functions created to send SMS via web bulk service as well as sample form to...
PDF file OCRed by FineReader 11, then excel formulas and VBA macro used to split data...
Excel VBA tool to get data from multiple Excel files, process it and create multiple...
Excel VBA tool created to generate PDF files for each record in Excel database and...
Excel based tool to generate XML files of specific structure with data provided in...
Monte Carlo algorithm implemented.

Skills (14)

Tested
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
VBA
VBA
My Score
avg
Data Management
Project Management
English-Russian Translation
English To Russian Translation Skills Test
My Score
avg
Passed
Microsoft Word
Microsoft Word
My Score
avg
MySQL Programming
MySQL
My Score
avg
Passed
Microsoft SQL Server Programming
Microsoft SQL Server
My Score
avg
Passed
Microsoft Access
SQL Programming
SQL
My Score
avg
Passed
Microsoft Project
Microsoft PowerPoint
Google AdWords
Knowledge of Google AdWords Test
My Score
avg
Microsoft Access Programming

Service Description

First of all I can answer any your question which sounds like "How I can use Excel VBA to improve my business?". I understand what businesses need, doesn't matter it's a small private business or a large corporation. My list of happy clients include small stores and large retailers, local manufacturers and global manufacturing corporations, airlines with 2 and with 100 aircrafts, insurance companies, marketing and financial reporting companies etc. etc.

To improve your business I create complex Excel based applications with advanced formulas, named tables, pivot tables, charts, dashboards, customized ribbons, user forms etc.

In my VBA code I do not use any unnecessary and slow operations (usually created by Excel Macro Recorder). I do not use For...Next and other loops where it's possible to use just one operation i.e. just one SQL query. I use SQL queries to work with Excel data as well as to work with Microsoft SQL, MySQL, Access databases, CSV, text files etc.

That is how my applications can work fast even with large amounts of data.

I work with web services (REST, XML-RPC etc.). I can get any data from web into Excel, send any data from Excel to web, manage Internet Explorer from Excel (DOM), send SMSs and faxes from Excel based application etc.

I can use VB.NET. I use Office 2013 64 bit on Windows 7 64 bit to develop but i still have Office 2010 64 bit and Office 2007 32 bit (on Windows XP) to test my code. I work with Excel since Excel 97 but I do not support...

Read More »

Keywords

Excel
VBA
macro
Visual Basic for Applications
Add-In
spreadsheet
workbook
XML
CSV
Word
Outlook
PowerPoint
xml-rpc
duplicate removing
fuzzy comparison
formula
graphs
charts
PDF
Company Snapshot
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
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
xlbin
Type
Company
Member Since
July 2011
Elance URL
Verifications
0
Groups
Excel Business Intelligence | Elance

Excel Business Intelligence