John B. Profile

4.9

(5条评论)

您正在关注

关注用户错误。

该用户不允许他人关注他们。

您已经关注了这个用户。

您的会员计划仅允许0个关注。升级在此。

成功取消关注

取消关注用户错误

您已成功推荐

推荐用户错误。

出问题了，请刷新页面并重新尝试。

电子邮箱已成功验证。

$40 USD / 小时

eastbourne,

united kingdom

$40 USD / 小时

目前这里是6:05 上午

五月 20, 2015已加入

0 推荐

John B.

@JohnBoothby

4.9

(5条评论)

3.0

100%

$40 USD / 小时

eastbourne,

united kingdom

$40 USD / 小时

100%

工作已完成

44%

在预算内

44%

按时

不适用

重复雇用率

Expert in Excel, VBA, Data Analysis and Automation

A analytical professional with outstanding academic pedigree and more than five years of experience working in business analysis and improvement. Author of hundreds of VBA Tools, many working in tandem with complex SQL queries, performing functions as varied as sales forecasting, order calculation and placement, web scraping and automation, complex data analysis and KPI dashboard production. I have worked extensively on a variety of projects and contracts outside of this platform: references and examples of previous work are available on request. All Projects will be quoted on an individual basis.

查看所有Excel Experts在United Kingdom

联系John B.询问您的工作详情

登录并通过聊天讨论所有细节。

文件夹

The focus of this project was to produce a professional and pleasing UI, but seamlessly weave in lookup and activex functionality.

Excel Freelancer-Invoice Template

Snips from a presentation to a CEO and CFO on the projected impact of a no-deal Brexit in terms of inbound tarriffs, outbound tariffs, and the risk of delay to production based on significant customs delays.

Analysis involved significant data crunching on key spend categories, sales classifications, and designing a tool to project the impact of delivery failures on a component-by-component basis.

(Sensitive Information has been blacked out)

Brexit Impact Analysis

A simple excel workbook to present raw order information in a specified dashboard format.

Users select what data they wish to see using a simple interface and drop-down boxes.

Running the macro updates the source data from an external database, analyses it against known shipment addresses, and summarises it in a easy-to-use format, that allows quick analysis of direct vs drop-shipments.

Live Sales Dashboard from Raw Data

4786692

Recursive Order Availability Checker for Multi-BOM items

Excel Freelancer-Invoice Template

Brexit Impact Analysis

Live Sales Dashboard from Raw Data

4786692

Recursive Order Availability Checker for Multi-BOM items

变更已保存

展示5中的1-5条评论

筛选评论规则：

5.0

$30.00 USD

Create a unique Excel Invoice Template for freelancers

John is the quite professional freelancer, especially on Excel and VBA. I highly recommend him to hire to be sure your work will finish on time with strong communication. I hired him again cause you can access him easly and can explain what you need.

Tulay V.

@someka2

•

5 年前

5.0

$30.00 USD

Need an Excel wizard to create automated macro helping me with data update -- 3

Amazing freelancer, no doubts my best experience on Freelancer ever. Excellent communication, fantastic understanding project requirements and delivery within budget and within few hours from starting the project. Would highly recommend, true Excel wizard!!! :)

Visual Basic

Excel

Visual Basic for Apps

Daniel G.

@dangorka

•

5 年前

4.8

$180.00 USD

War Dragons Breeding Guide

John has been a great delight to work with. I have spent a couple of years trying to complete this project with a little bit of help, here and there, but John truly went above and beyond to complete it. He is a very thorough and dedicated professional that never gave up and spent more time than was necessary to satisfy my needs. I highly recommend him and would be more than pleased to have his help for any future projects.

Data Processing

Excel

Donovan C.

@donovancullum316

•

5 年前

5.0

$30.00 USD

Help import data into Excel spreadsheet from other spreadsheets

John was a pleasure to work with and had helpful additional suggestions for our Excel needs that we hired him for.

Derek H.

@shshshshs

•

5 年前

5.0

$50.00 USD

Looking for VBA coder to update an excel sheet and duplicate one

Excellent work . Awesome Personality. Will hire again for sure. Thank you John.

Techweb S.

@techwebsam

•

5 年前

经验

Market Leading Manufacturer

9月 2015 - 现在

Working with a broad remit to improve business processes and provide improved analytical support across the business - in the course of my time at Paxton I have authored in excess of 100 VBA macros; designed processes used on daily basis for activities as varied as forecasting, materials purchasing and control, dashboard production and customer experience tracking. I take responsibility for a wide range of analytical reporting functions including quality, OTD and supplier KPIs.

Multi-national Telecommunications Company

9月 2014 - 8月 2015 (11 个月, 1 天)

Continuous Improvement Team-lead. Simplifying reporting and summarising data using excel macros to drive savings, efficiencies and direct team efforts towards high-value accounts.