Mst Ruma A. Profile

MENJELAJAH

Data Processing

Excel

Excel Macros

Visual Basic for Apps

Web Scraping

4.9

(89 ulasan)

Anda sekarang mengikuti .

Ralat mengikuti pengguna.

Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.

Anda telah mengikuti pengguna ini.

Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.

Berjaya tidak mengikuti pengguna.

Ralat tidak mengikuti pengguna.

Anda berjaya mengesyorkan

Ralat mengesyorkan pengguna.

Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.

E-mel berjaya disahkan.

$25 USD / jam

keraniganj,

bangladesh

$25 USD / jam

Sekarang ini 3:53 PTG di sini

Menyertai pada Januari 27, 2014

6 Syor

Mst Ruma A.

@rumarahman

4.9

(89 ulasan)

5.9

$25 USD / jam

keraniganj,

bangladesh

$25 USD / jam

100%

Pekerjaan Disiapkan

94%

Mengikut Bajet

90%

Tepat Pada Masa

19%

Kadar Upah Semula

| Excel VBA/Macro | Web Scrapping | Python |

I am an Excel Programmer. I know automation of excel/Word (MS Office) tasks. I have 10 years of vast experience on data analyzing and processing. I Do always best quality work in time. I do some special quality Graphic Designs too. I am basically an expert on Visual Basic for Applications (Excel). I do: EXCEL - Excel VBA - Excel Macros - Web scraping (Using Macro, VBA) - Excel formulas of any complexity - Excel spreadsheets formatting - Fixing errors in your Excel macros - Automation on excel spreadsheets - Analyzing Excel data - Creating Data reports - User-forms, User Interfaces (UI's) PYTHON -OPENPYXL Please feel free to contact me or hire me anytime. Thanks.

Lihat semua Excel Experts dalam Bangladesh

Hubungi Mst Ruma A. mengenai pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Item Portfolio

Delete all duplicates in project 1 until it looks exactly like Same UPC qty added (the original file). Add image links to any blank spaces in project 1 but only if SKU is an exact match

Clean up catalog

This is an automation of getting data by various criteria (age, sex, location, weight, sales, ranges etc) from various directory to a single spreedsheet by just one click. The Visual Basic for Apps is amazing tool to do that!!

Automation of Getting Data from Various Directory to Excel

Project Description

I have 2 CSV files that i would like combined into a single XLS and re-formatted. Use the May file for historical data, and then supplement this with the August data i.e. August file only to be used from May-Aug 2017. I would like all columns clear in the XLS e.g., date, time in bed, sleep quality, notes (all notes need to be separated so it's easy to identify notes on each date). In terms of outputs, I would like a simple line chart showing sleep quality over time, and a summary table showing number of days each note was recorded eg how often have i 'worked out', 'drank coffee', etc. Expect this to take 2-3 hours. Main tasks are: 1) text to columns; 2) columns to be displayed are: date, sleep quality, time in bed, bedtime, wake-up time (End), notes (all notes to be separated in separate columns) with ticks for night when they are applicable; 3) hide redundant columns; 4) ensure all dates, numbers correctly formatted

CSV to Excel Re-format

Advanced Excel Formula (Exclusive Use of Formulas, Funtions)

From the list of products, creating a pre-formated Price Quotation (details) for the ordered items.

Creating A Price Quotation from the seleted orders (In VBA)

Scrapping some contact details from a directory. About 4K data has been scrapped.

Scrapping A college directory (USING VBA Codes)

Ulasan

Perubahan disimpan

Menunjukkan 1 - 5 daripada 50+ ulasan

Tapis ulasan mengikut:

5.0

$200.00 USD

simple spreadsheet for basketball stats

Excellent work and delivered on time.

PHP

Data Processing

Excel

Thomas V.

@netgaming2

•

5 hari yang lalu

5.0

₹4,400.00 INR

Calculation in excel, addition and subtraction ( Plus & Minus) in one click

very good, done work on time

Suresh D.

@Dudhalsuresh

•

5 hari yang lalu

5.0

£100.00 GBP

Modify excel macros on existing spread sheets

This Freelancer really knows Excel. She did a great job of understanding some quite complex macros written by someone else and she returned them exactly as requested. She was a pleasure to work with and I am sure I will hire her again in future.

Excel VB Capabilities

Caroline E.

@Carolinexxx

•

1 bulan yang lalu

5.0

$40.00 USD

Clean up catalog

A true excel master. Many freelancers are a Jack of all trades and a master of none. Not Ruma. She advertises herself as an Excel master, and that is what she is. She was able to run complicated matching functions, while dealing with an autoformating issue. She highlighted and presented her work very nicely. She delivered in a reasonable time and offered great value in her services. She is very respectful and always addressed me as sir.