Find Jobs
Hire Freelancers

MS Excel - identify and conditional format pricing anomalies

$10-30 CAD

Tamamlandı
İlan edilme: 2 yıldan fazla önce

$10-30 CAD

Teslimde ödenir
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.
Proje No: 31922504

Proje hakkında

46 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 2 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
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 free to contact me to discuss the details. Regards Ahmed
$12 CAD 1 gün içinde
5,0 (134 değerlendirme)
6,1
6,1
46 freelancers are bidding on average $22 CAD for this job
Kullanıcı Avatarı
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 Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.
$30 CAD 1 gün içinde
4,8 (284 değerlendirme)
7,4
7,4
Kullanıcı Avatarı
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 working with you. Thanks, Hamid
$30 CAD 1 gün içinde
5,0 (115 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
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, Ibrahim Anjum
$50 CAD 3 gün içinde
4,6 (137 değerlendirme)
6,8
6,8
Kullanıcı Avatarı
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 Processing, etc. I can also edit product images if required and I am well aware of how a Brand works in the Market and what are the needs for it. I'm interested in your project, Message me so we can discuss details further. Regards. Chetan C.
$15 CAD 1 gün içinde
5,0 (85 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
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). Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, User forms, Shapes variation etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, it includes extracting information from text files, websites, transferring info in to excel, Data analysis etc. For more info. You can see my profile before awarding me your project. https://www.freelancer.com/u/yadavexpert53 Thanks and Regards, Mohit
$30 CAD 1 gün içinde
5,0 (89 değerlendirme)
5,5
5,5
Kullanıcı Avatarı
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 to know about this project. I'm ready to work with you at any cost considering my qualifications. Give me a chance to prove my skills or talents. Petitioner SM
$25 CAD 2 gün içinde
4,9 (23 değerlendirme)
4,8
4,8
Kullanıcı Avatarı
"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, CASHFLOWS, MANAGEMENT ACCOUNTING, ACCUNTNG and AUDIT work I have completed similar projects with five stars reviews from client, you can check my profile.. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Please be my Client and get any type of 'Accountancy', 'Excel', 'QuickBooks', Balance Sheet', 'Income Statement', 'Cashflows' and auditing related work with quality, efficiency and on reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Spogmai Kakar "
$10 CAD 1 gün içinde
5,0 (34 değerlendirme)
4,4
4,4
Kullanıcı Avatarı
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 your project on time and your will experience great satisfaction with me. I’m well versed in R, python, SPSS, Stata, Excel etc I have rich experienced in Data Processing, Financial Analysis, Excel, Statistical Analysis and Data Entry. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thank you!
$30 CAD 2 gün içinde
4,7 (10 değerlendirme)
4,2
4,2
Kullanıcı Avatarı
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 Processing. Your satisfaction with the project is my top priority! If you give me a chance to work with you, I will do my best to reach your requirements. I'm waiting for your kind response. Please send message over chat. Let's go. I will do my best for you. Best Regards.
$20 CAD 1 gün içinde
5,0 (8 değerlendirme)
3,6
3,6
Kullanıcı Avatarı
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 concern myself about the quality output for client satisfaction; with me excellent job is a guarantee. Excellent work for a cheaper cost, conduct me on a chat for more details Thank you.
$10 CAD 1 gün içinde
4,0 (6 değerlendirme)
3,2
3,2
Kullanıcı Avatarı
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 Table Excel Dashboard Apply formulas/Advance Filter  Vlookup / Hlookup Countif / Countifs Sumif / Sumifs Data Validation Conditioning Formatting Dropdowns Google Sheets That's just a limited summary, anything can be done using Excel.
$12 CAD 2 gün içinde
4,8 (2 değerlendirme)
2,6
2,6
Kullanıcı Avatarı
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 performed this kind of analysis many time throughout the projects I worked on for regulators, or big companies. I look forward to hearing from you. Kind regards, Soufiane
$25 CAD 1 gün içinde
5,0 (6 değerlendirme)
2,7
2,7
Kullanıcı Avatarı
I have very good experience in this field, I worked for 11 years in Accounting & Finance in addition to getting Master & Doctorate Degree in Finance from Cairo University, also i'm preparing my CPA, so I see myself moving on the right way and having the practical and theoretical experience required for this job.
$20 CAD 7 gün içinde
5,0 (1 değerlendirme)
2,2
2,2
Kullanıcı Avatarı
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 simple send me the file and get your sheet in 10 min.
$20 CAD 1 gün içinde
5,0 (2 değerlendirme)
0,8
0,8
Kullanıcı Avatarı
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 2 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 este tipo y podemos ayudarte con tu proyecto. cree en nosotros
$20 CAD 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I have the skill what you are looking for, i can finish the work in record time and submit it with you
$20 CAD 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I read your project and understand your requirements. I am already doing tax files for the company I work for and I am proficient in Excel well I will do the job well I have enough experience in this field. I will complete your task on time. I can save your time and money
$20 CAD 2 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I am a hard-working professional who has been consistently praised as detail-oriented by my co-workers and manager.
$20 CAD 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I will identify the outliers and display it on a new tab. Also, I can let the spreadsheet read for new data input. With my experience dealing with excel data I can manage to finish this job in a couple of hours.
$20 CAD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   CANADA bayrağı
Victoria, Canada
5,0
2
Ödeme yöntemi onaylandı
Şub 23, 2020 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.