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: Jul 30, 2015

Excel Business Intelligence

Excel,VBA,SQL,XML,CSV,PDF, data management
   Poland
  |  2:42 pm Local Time

Overview

I am 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 and Visio.

I have a master's degree in project management and a bachelor's degree in finance. I worked as an IT project manager and CIO in various manufacturing, retail, real estate development and marketing companies, with anything from 15 to 20,000 employees, before I started my own business.

Iíve been working on Elance since October 2011, and I...

Read More »
Jun 18, 2013|Event Planning|Private|Completed
Apr 21, 2013|Data Entry|Private|Completed
|
4.8
Feb 6, 2013|Other - Administrative Support|Private|Completed
|
5.0
Feb 6, 2013|Other - Administrative Support|Private|Completed

View All »

Portfolio

Excel Business Intelligence has more then hundred of happy clients. We work with sole...
Excel Business Intelligence. Who is behind the name? How can I create perfect solutions...
About 100 jobs in IT & Programming category completed on Elance. From $20 simple...
https://www.elance.com/s/xlbin/job-history/10183/
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
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
Translation English Russian
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 question you have if you want to know how you can use Excel VBA to improve your business. I understand what businesses need, whether it's a small private business or a large corporation. My list of satisfied clients includes small stores and large retailers, local manufacturers and global manufacturing corporations, airlines with two aircraft and those with 100 aircraft, insurance companies, marketing and financial reporting companies, and many, many more.

To help you improve your business, I can create complex Excel-based applications, with advanced formulas, named tables, pivot tables, charts, dashboards, customized ribbons, user forms and so on.

In my VBA code, I never use unnecessary and slow operations (which are usually created by Excel Macro Recorder). I never use For...Next and other loops where it's possible to use just one operation instead, such as 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 and so on. Thatís how my applications work so quickly, even with large amounts of data.

I work with web services (REST, XML-RPC and so on). I can get any data from the web into Excel, send any data from Excel to the web, manage Internet Explorer from Excel (DOM), send SMSes and faxes from Excel-based applications, and much more.

I use Office 2013 64-bit on Windows 7 64-bit to develop but I still have Office 2010 and Office 2007 32-bit to test my...

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
3
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
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