Đã hoàn thành

MS Excel - identify and conditional format pricing anomalies

This is a really simple and fast job for anyone who knows Excel well. I have an Excel spreadsheet that contains information on about 10,000 real estate properties. Each property has 20 years of tax assessment prices, broken down separately for the land and for the building so there are two values for each year. So there is a total of 40 columns, year by year in the pattern: land building land building land building land building

I need to identify the outliers - any properties that had abnormal changes in either the land or building value. It's that simple, just using one of the Excel commands to find the outliers.

Kĩ năng: Excel, Xử lí dữ liệu, Nhập liệu, Phân tích tài chính, Phân tích thống kê

Xem nhiều hơn: format change excel showing previous format, excel changes date format csv, excel macro paste format, excel help label format, excel csv datum format, excel csv windows format, vba excel word preserving format, excel vba date format days, excel 2003 conditional formatting, excel changes date format saving csv, excel vba csv format, excel vba build format report, excel cidr number format address, change excel php column format number, php excel export money format, free uae companies database ms excel format, we need to create a bill format in MS Excel for the patrol pump, \ LISTING PRINTING\ This is a company that provides PRINTING SERVICES to the REAL ESTATE INDUSTRY. Real Estate industry agents, \ LISTING PRINTING\ This is a company that provides PRINTING SERVICES to the REAL ESTATE INDUSTRY. Real Estate industry agen, \ LISTING PRINTING\ This is a company that provides PRINTING SERVICES to the REAL ESTATE INDUSTRY. Real Estate industry agent

Về Bên Thuê:
( 0 nhận xét ) Victoria, Canada

ID dự án: #31922504

Được trao cho:

AAGGMM

Hello sir I am Ahmed, a data analytic with very good skills in Excel and SQL, also in data cleansing, organization, and integrity. So, I can achieve this task perfectly. If you are interested in my offer, please feel Thêm

$12 CAD trong 1 ngày
(15 Đánh Giá)
4.2

49 freelancer chào giá trung bình$22 cho công việc này

(463 Nhận xét)
8.4
(314 Nhận xét)
7.4
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Thêm

$30 CAD trong 1 ngày
(166 Nhận xét)
7.0
ibrahimanjum330

Hi, I am Ibrahim, and I am a data scientist, I can help you with the outlier identification, do you want it per column, divided into building and land, or an overall evaluation in conditional formatting. Regards, Ibr Thêm

$50 CAD trong 3 ngày
(119 Nhận xét)
6.5
hamidr2020

Hi, I am an Excel expert. I have read the project details and I can help you identify the outliers. . You can check my reviews and repeat hire rate for quality of work and client satisfaction. Looking forward to workin Thêm

$30 CAD trong 1 ngày
(37 Nhận xét)
5.3
chetandc

Hey there, I see you’re looking for someone for MS Excel - identify and conditional format pricing anomalies I have years of experience in Excel, Data Entry, Statistical Analysis, Financial Analysis and Data Processin Thêm

$15 CAD trong 1 ngày
(38 Nhận xét)
5.2
yadavexpert53

Dear Employers, I can assist you in “identify and conditional format pricing anomalies” the best way & according to your project need. I am an expert and professional in MS Excel Formulas & VBA (Automation by macros). Thêm

$30 CAD trong 1 ngày
(47 Nhận xét)
4.9
SazH319

Hi! Project Director I'm not new to this marketplace, but I have been working in other marketplaces for a long time and I can give you proof of that. I am accustomed to doing such projects regularly. I have something Thêm

$25 CAD trong 2 ngày
(21 Nhận xét)
4.6
varimaxanalytic

Hi! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete Thêm

$30 CAD trong 2 ngày
(5 Nhận xét)
3.7
ACCASpogmai

"Sir, I am an ADVANCE LEVEL FINANCIAL and EXCEL EXPERT. This task is very easy ,I will complete this task with 100 % Accuracy , I have over 6 years of rich experience in ACCOUNTING, BALANCE SHEET, INCOME STATEMENT, C Thêm

$10 CAD trong 1 ngày
(11 Nhận xét)
3.1
Scientifictech

Hello My name is Abbas Hamdani.I'm a Microsoft Certified Excel Expert having 6+ Years’ experience, I can help you with any kind of task as follows: Cell function (Custom or Excel's) VBA/MACRO User forms Charts Pivot T Thêm

$12 CAD trong 2 ngày
(2 Nhận xét)
2.7
SoufianeAch

Hi, My name is Soufiane. I'm an engineer from CentraleSupelec, a top french engineering school. I have two and half years experience in consulting, and worked on developping cost models for regulated services. I have p Thêm

$25 CAD trong 1 ngày
(6 Nhận xét)
2.7
torrikress2

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic, Data Processi Thêm

$20 CAD trong 1 ngày
(2 Nhận xét)
1.6
(2 Nhận xét)
1.3
joylibrea

Hi there, I’m writing to express my interest in open position you have available. I am very keen to take new responsibilities with bigger operations and high challenges. I am fast learner and can adapt to new situati Thêm

$20 CAD trong 7 ngày
(2 Nhận xét)
0.8
oshishahin

Hello , it's a one simple equation to calculate the internal quartile (IQR) then using the conditional formatting we could highlight the outliers , we should use the boundary Q1-1.5 IQR and Q2+1.5 IQR , just that sim Thêm

$20 CAD trong 1 ngày
(2 Nhận xét)
0.8
perfectwriter002

MS Excel - identify and conditional format pricing anomalies Hello Client? I have gone through your project and clearly understood it. I am interested in this project and I am confident I can do the job. I always conce Thêm

$10 CAD trong 1 ngày
(0 Nhận xét)
0.0
Huzaifakamran1

Hey I’m bidding on your project as I know excel very well and I can do this in a great manner and I also have experience working with excel and sql together so I know how to deal with this kinda project.

$25 CAD trong 2 ngày
(0 Nhận xét)
0.0
Romspublicity

Hola buen día mi nombre es Ivan Rodriguez CEO de RomsPublicity eh leído por completo tu solicitud y estoy interesado en poder trabajar para ti, somos los indicados para hacer tu proyecto, ya henos hecho trabajos de es Thêm

$20 CAD trong 7 ngày
(0 Nhận xét)
0.0
jbhatter29

I have the skill what you are looking for, i can finish the work in record time and submit it with you

$20 CAD trong 7 ngày
(0 Nhận xét)
0.0