Microsoft Excel Macro Freelancers

Clear all filters
  1. Mohammad Shahadat Hossain

    Mohammad Shahadat Hossain

    VBA Programmer & Microsoft Excel VBA (Macro) GURU

    Bangladesh - Last active: 8 days ago - Tests: 8 - Portfolio: 15

    Do you want automation in Excel? Are you tired of making same reports every day? Do you want your job/project get done effectively and efficiently? Being an Expert of Microsoft Excel (VBA), I can help you out from those tedious circumstances that trouble you most. Since I got 6 years of extensive experience in designing and coding complex Excel based Application. A wide range of small utility software or program has been developed through the use of Excel VBA (portfolios attached). I believe my capabilities are perfect for building any excel related projects. Besides, I have got very good control over using different software and methods of VBA which allow me to migrate or scrub data from PDF to Excel, Word, PowerPoint, Access and Vice Versa and to scrape or mine required data from web too.

    $14.44 /hr
    314 hours
    5.00
  2. Michael John Verano

    System Analyst/Programmer

    Philippines - Last active: 20 days ago - Tests: 1

    I am a Computer Engineering graduate mastering and enhancing my system and web development skills for over 4 years since I graduated. I am currently the System Analyst/Programmer of Geo-Surveys & Mapping, Inc. (GSMI), a company that provides customized applications with GIS capability here in the Philippines. Most of our clients are Local Government Units. I have a comprehensive experience in Visual Basic, Visual Basic .Net, ASP .Net, Crystal Reports, AJAX, Javascript, JQuery and XML. As backend, I have extensive experience in Oracle 9i/10g, MS SQL Server 2000/2005 MS Access and MySQL. I am also an experienced GIS programmer using PCI Geomatics’ Geomatica and Supermap GIS.

    $25.00 /hr
    169 hours
    5.00
  3. Iho Tea

    Iho Tea

    Python & Django programmer, Web developer

    Ukraine - Last active: 17 days ago - Portfolio: 2

    Hi, Looking for an experienced, reliable, positive, full stack programmer? You're in the right place :) I'm a web programmer for over 15 years now. Have experience of making web projects from the scratch to deploying into production and support, solely. Work in team as well :) Professional in web development, web project administration. Prefer web developing in Python, especially Django framework. Configure web servers based on Nginx, full-text search in SphinxSearch, Administer Postgresql and Mysql databases. Administer web projects in Ubuntu and FreeBSD servers. Experienced in Celery, JavaScript, JQuery, html, CSS, SCSS, Gulp, GIT.. Build projects with Bootstrap, Zurb Foundation frameworks. Also experiences in Microsoft Excel macro programming. Have a project to be solved timely? Please, do not hesitate to contact me, you are welcome.

    $25.00 /hr
    0 hours
    0.00
  4. Slawomir D.

    Slawomir D.

    Excel, VBA, Web scrapping Specialist

    Poland - Last active: 13 hours ago - Tests: 9 - Portfolio: 8

    Specializing in Excel and VBA macro development, and using effective spreadsheet design to automate monotonous tasks and improve efficiencies. I benefit from 12 years experience in creating and using advanced spreadsheets to help with everything from generating customized reporting to aiding the running of a large operations department. I have worked on a great many large and small projects in the past, for both small businesses and large corporations. I am an experienced project manager, having overseen a great number of projects from conception to completion. I determine what is needed to complete each project by examining the most efficient course of achieving the objective. This often includes the incorporation of VBA programming to relieve the user from many tedious tasks. Projects I’ve worked on include invoice generators, P/O generators, quote generators, reporting generators, data entry forms, call centre aids, project management solutions, complex reporting, and data analysis, among many others.

    $15.00 /hr
    285 hours
    4.85
  5. Shreedhar H.

    Shreedhar H.

    microsoft excel expert / macro expert

    India - Last active: 6 days ago - Tests: 1 - Portfolio: 5

    Hello, I am good in Microsoft Excel - Automation , Dashboard , graphics . data visualization , etc. I have made more than 43 excel templates for various non upworks clients.Few of them I have attached with my portfolio. My skills in Excel listed below.  • Can make fusion of formulas to deliver desired results Recording and Running Macros  • Recording Macros • Adding Macros to the Quick Access Toolbar • Editing a Macro • Start the Vba Editor  • Absolute and Relative Recording  • Macro Storage Locations  • Running macros from toolbars, menus or worksheet buttons  Calculating Data with Advanced Formulas • Using Logical Functions • Understanding of Sumifs and Countifs Function • Dealing with one and multiple conditions • Summing values in a range which has error values (without sorting/filtering/deleting) • Summing values (based on one/multiple conditions) from another workbook • Using Statistical Functions • Using Date Functions o Converting non dates to dates o Displaying non dates as dates o Retaining date/number formatting when concatenating with data in cells • Using VLOOKUP o Making the column index in a VLOOKUP() function dynamic formula when new rows get added o Looking up data within upper and lower limits o Performing lookup in a range where there are multiple occurrences of a string. o How to make Column Index Dynamic in Vlookup Function. o How to provide a good error message Instead of “#N/A” in Vlookup. • Using HLOOKUP • INDEX AND MATCH FUNCTION • ARRAY FUNCTION Analyzing Data Using Pivot Tables and Pivot Charts  • Performing calculation in pivot tables What to be careful about when working with pivot tables Resolving problems when grouping numeric data / dates in a pivot Addressing issues when writing formulas within pivot tables Use Slicer to filter Pivot Table data to Excel 2010.Using External Data Sources  • Multiple consolidation ranges • Pivot table advance options • Creating a PivotTable Report • Analyzing and Modifying a PivotTable • Creating Pivot Charts and Dashboard • Sorting and Filtering Worksheet or Table Data • Using Database Function • Applying Data Validation to a Worksheet Basics of graphing and nuances  • Creating 2 y axis charts • Dealing with dates in the x-axis • How to create Interactive Charts Using Excel Objects? • Customising data labels on charts • Presenting data in “Bar of Pie” and “Doughnut charts” • Getting total labels in stacked column charts • Use of XML and its mapping in excel • Using form controls in charts

    $5.50 /hr
    0 hours
    0.00
  6. Pavel K.

    Pavel K.

    Google Apps Script Expert Developer, JIRA Expert, SharePoint Expert

    Russia - Last active: 1 day ago - Tests: 10 - Portfolio: 2

    I have excellent skills in Google Apps Script developing. Also I have very good skills in SQL, Java and C++ programming. My experience in programming for more than 15 years allows me to bring exceptional value to my clients. My areas of expertise: - Google integration and Google APIs - Google Apps Script - Google Spreadsheet automation - Google Analytics - Google+ - Atlassian JIRA tuning and administration - In-depth JIRA programming with help of Groovy scripts/Java add-ons. - MS SharePoint tuning and administration. - SQL tuning. - Twilio API Also I hold MCITP: SharePoint Administrator 2010 certification. My key principles for job execution: 1) Honesty: I will not take a task if I am not sure I can complete it. 2) Availability: I can be accessed by Skype and phone. 3) Client satisfaction: My goal is to make you happy with my work. 4) Quality: I will create a fast and well organized code, which can be easily supported in the future.

    Groups: Coding Champs

    $30.00 /hr
    326 hours
    4.99
  7. Anatol Druzhinin

    Anatol Druzhinin

    VBA macro developer

    Russia - Last active: 6 days ago - Tests: 3

    VBA expert at your service! I have 15 years expertise in MS Office apps and VBA-automating and integrating them to build user-friendly applications. I am experienced in: - data analysis and visualisation in Excel, - building databases in Access and Excel, - creating corporate automated templates in Word, - designing clear presentations in PowerPoint, - automaticaly sending emails with data via Outlook from other Office apps. I graduated from the Novosibirsk State University, Mathematics & Mechanics dept and qualified as mathematician and IT-specialist. I am interested in complex and non-typical works.

    $20.00 /hr
    28 hours
    5.00
  8. Igor Zekov

    Igor Zekov

    Delphi|C++|Access| Excel|VBA

    Ukraine - Last active: 11 days ago - Tests: 4

    Over the last 8 years, I have developed several desktop applications using Delphi. That was applications for working with databases through ADO mechanisms, working with GSM modem using AT commands, sound proccessing, etc. I am seeking opportunities to build applications for you or your business. Have developed and worked with Access databases with more than 1 million+ records, handled big data arrays in Excel, proccessing it with Excel formulas or VBA, importing/exporting to Access. I also have experience in the following areas: C++, PHP, JavaScript, SQL, Excel VBA, MS Access, Photoshop, 3dsmax, OpenGL.

    $10.00 /hr
    57 hours
    5.00
  9. Mark Skilling

    Mark Skilling

    Expert Microsoft Excel VBA scripting and customisation

    United Kingdom - Last active: 1 day ago - Tests: 3 - Portfolio: 1

    I have over 10 years experience building custom excel scripts and plugins within a blue chip organisation and have built many data analysis tools with custom user interfaces. If it can be done in Excel then I will build it for you. I can complete your excel scripting requirements fast and with great quality. I have now worked with a number of clients on Odesk providing a wide range of skills, from extraction of data from html web pages, working with the ebay api to automate ebay tasks, to creating from scratch a home finance budget planner and report tool in excel.

    $30.00 /hr
    314 hours
    4.84
  10. Chris H.

    Chris H.

    Web Developer (ASP.NET | MVC | AngularJS)

    United Kingdom - Last active: 13 hours ago - Tests: 6 - Portfolio: 6

    Microsoft Certified Solutions Developer with over three years’ programming experience using .NET framework to deliver web and desktop applications. I’m a passionate C# developer with extensive knowledge and experience with: - ASP.NET back and frontend development, including WebAPI 2, MVC 5 - Client side scripting, JavaScript, jQuerry, AngularJS, Knockout - Clean and SEO-Friendly HTML5 and CSS - Task automation using Poweshell scripting and C# applications Committed to designing up to spec, reliable and extendable solutions. Focused on delivering quality work on time and within budget. Always open for communication. Highly flexible, independent contractor that will get the job done for you.

    $20.00 /hr
    197 hours
    5.00