
Closed
Posted
Paid on delivery
I need an Excel expert to create several formulas for a spreadsheet. Essential Requirements: - Ability to perform mathematical calculations, including basic arithmetic, statistical functions, and financial calculations. - Experience with text manipulation functions. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong analytical skills - Experience with complex formulas and functions - Attention to detail Please provide examples of previous work.
Project ID: 40750482
122 proposals
Remote project
Active 8 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
122 freelancers are bidding on average £321 GBP for this job

With my extensive background in data analysis and management, I can confidently say I am the precise choice for your Excel formula project. Not only am I well-versed in mathematical calculations of all kinds, but my skills also extend beyond the basics to include complex formulas and even financial calculations. I guarantee flawless formulas and a streamlined spreadsheet, ensuring that you get the most out of your data. In addition to my proficiency in Microsoft Excel, I have a keen eye for detail that is an absolute necessity when dealing with formulas and functions. My advanced analytical skills enable me to approach problems from different angles, providing not just a solution but an optimal one for your unique needs. Lastly, I encourage you to check out my examples of previous work to gain a better understanding of my capabilities. Whether it's web scraping or data mining, product listing or AI SEO, I have consistently delivered high-quality results u
£250 GBP in 1 day
7.7
7.7

Hello, I can help you with writing Excel formulas in a spreadsheet. I have extensive experience with similar projects, including approximately 250 previous ones. You can find some examples of my work at the following links: https://www.freelancer.com/projects/excel/Need-very-experienced-Excel-expert https://www.freelancer.com/projects/excel/Excel-expert-33829779 https://www.freelancer.com/projects/excel/create-excel-formula-31735012 My time zone is GMT+7, which is 7 hours ahead. If you are interested, please send me a private message. Best regards, Hoang
£250 GBP in 7 days
7.6
7.6

Hello, I trust you're doing well. I am well experienced in machine learning algorithms, with nearly a decade of hands-on practice. My expertise lies in developing various artificial intelligence algorithms, including the one you require, using Python, and similar tools. I have worked with pytorch, and tensorflow to develop DL models, .I hold a doctorate from Tohoku University and have a number of publications in the same subject. My portfolio, which showcases my past work, is available for your review. Your project piqued my interest, and I would be delighted to be part of it. Let's connect to discuss in detail. Warm regards. please check my portfolio link: https://www.freelancer.com/u/sajjadtaghvaeifr
£500 GBP in 7 days
7.8
7.8

As a dedicated data enthusiast and certified Excel specialist, I am confident I possess the skills necessary to not just execute on this project efficiently, but significantly improve your spreadsheet's capabilities. Over my career, I have honed my mathematical proficiency by performing basic arithmetic calculations to more complex statistical and financial analysis for various companies. So, rest assured, your mathematical calculations are in safe hands with me. What distinguishes me from the competition is my expertise in text manipulation functions like concatenation, LEFT/RIGHT/MID strings extraction, and advanced text analysis. By integrating these functions into your spreadsheet, I can maximize its utility to perform data-rich tasks, streamline your workflow, and provide helpful insights. To validate myself further, I encourage you to check out my expansive portfolio. It showcases various projects where I've constructed complex formulas and utilized advanced Excel functions that delivered significant value to my clients' businesses. As an Excel data maestro with a keen eye for detail and strong analytical skills, picking me for this task is choosing quality work and guaranteed satisfaction. Let's get started today!
£250 GBP in 1 day
7.1
7.1

Hi there, I understand you need accurate Excel formulas that combine mathematical, statistical, financial and text-based calculations, with the flexibility to handle more complex logic as the spreadsheet develops. I’m confident I can build the formulas cleanly and transparently so the workbook produces reliable results without unnecessary complexity. My approach is to first review the existing sheet structure, input fields and expected outputs so each formula matches the actual business logic. Then, I’ll build and validate the required arithmetic, statistical, financial and text functions, using combinations of formulas where needed rather than hard-coded results. Next, I’ll test the formulas against sample and edge-case values to catch calculation, formatting and reference errors. If repetitive logic is involved, I can also use Excel VBA/macros where automation provides a clear benefit. You’ll receive tested Excel formulas, validated calculations, clean cell references and documentation/explanation of the key formulas. Could you share the spreadsheet or a few examples of the required calculations so I can confirm the formula logic and scope? Let’s turn the spreadsheet logic into formulas you can trust. Warm Regards, Aneesa.
£250 GBP in 2 days
7.2
7.2

Dear client, I have an expertise in all Excel functions including VBA and macros. This is my field of expertise and I can start immediately. Thanks!
£250 GBP in 1 day
6.8
6.8

Hi, I can create and test the required formulas for your spreadsheet, covering arithmetic, statistical functions, financial calculations, and text manipulation. I will first review the sheet structure and expected results, then build clear formulas that are easy to maintain and check with sample values. My Data Processing experience helps me spot calculation issues, while Excel and Microsoft tools support a clean and practical solution. If automation is useful, Excel VBA can also be considered, but I will keep the workbook simple unless it genuinely saves time. I can share relevant examples of previous spreadsheet formula work. Could you share the workbook structure, sample input and expected output for each formula, including any formulas that currently give incorrect results? I will check the formulas carefully and provide clear notes so you can use them confidently.
£425 GBP in 4 days
6.5
6.5

Hi, I can help you create and implement the required Excel formulas, including mathematical, statistical, financial, and text manipulation functions. I’m comfortable working with complex formulas and will make sure everything is accurate and easy to use. I can also review the spreadsheet, test the formulas, and make any necessary adjustments. I’m ready to get started.
£300 GBP in 2 days
6.8
6.8

Hello there, I am a Data Analyst by profession, and by using Excel, I can help you uncover insights from your data. I run both quantitative and qualitative analyses professionally. I am proficient in data cleaning, transformation, and formatting to ensure accuracy and consistency while handling missing data, outliers, and data quality issues. I apply appropriate statistical techniques to make recommendations, utilizing advanced regression models, clustering, classification, and other relevant methods. I provide detailed reports that summarize the data analysis findings, presenting key insights, trends, and recommendations clearly and understandably. I deliver visualizations, tables, and charts to support the analysis and enhance comprehension. Please get in touch so we can proceed with the project.
£250 GBP in 2 days
6.5
6.5

Hello, I went through your project description and understand you need several reliable Excel formulas covering mathematical calculations, statistical analysis, financial calculations, and text manipulation. I will review your spreadsheet structure and requirements first, then create formulas using appropriate Excel functions such as XLOOKUP, INDEX/MATCH, IF/IFS, SUMIFS, COUNTIFS, TEXT functions, and statistical or financial functions where required. I will ensure formulas are accurate, scalable, and easy to maintain, while keeping the workbook organized and compatible with your existing data. I will also test the calculations against sample values and check edge cases to prevent incorrect results or unexpected errors. If VBA or macros are necessary for any part of the workflow, I will recommend and implement them only where they provide a clear benefit. Within 24–48 hours of being awarded, I will share a project blueprint outlining the required formulas, logic, testing approach, and delivery steps. To scope this accurately, can you share the spreadsheet or a few examples of the calculations you need? Best Regards, Imran
£250 GBP in 2 days
5.6
5.6

You need working formulas in your spreadsheet for calculations, statistics, financial figures and text cleanup, each one correct on your real data. Send the sheet and the first formulas are back within 24 hours. A few examples of the kind of formulas I write: Loan payment per month: =PMT(B2/12, B3*12, -B1) Average that skips error cells: =AGGREGATE(1, 6, C2:C500) Lookup with a clear fallback: =XLOOKUP(A2, Data!A:A, Data!D:D, "Not found") First name from " john SMITH ": =PROPER(TEXTBEFORE(TRIM(A2), " ")) How I will work: 1. List each formula you need with one input and the result you expect, so we agree on the target first. 2. Build the formulas in your sheet, with no hard-coded numbers and errors handled (IFERROR or AGGREGATE), so they keep working as rows are added. 3. Test each one against edge cases: blanks, zeros, text in number cells, extra spaces. 4. Add a short notes tab that explains each formula in plain words, so you can change it later. Timeline: 2 days, first formulas within 24 hours, and fixes for 7 days after delivery. Two questions: Which Excel version do you use? Newer functions like XLOOKUP and TEXTBEFORE need Microsoft 365 or Excel 2024, and I will use older equivalents if needed. Roughly how many formulas, and can you share the sheet with sample data? Thanks, Srinichal
£340 GBP in 2 days
5.4
5.4

I understand you're looking for an Excel expert to build robust formulas for your spreadsheet, similar to how I've previously automated complex data aggregation and reporting in Excel for clients, saving them significant manual effort. My approach will involve leveraging a combination of lookup functions (VLOOKUP/XLOOKUP, INDEX/MATCH), conditional logic (IF, IFS), and text manipulation (LEFT, RIGHT, MID, FIND, SUBSTITUTE) to precisely extract and process your data. I'll prioritize creating dynamic, error-resistant formulas that are easily auditable, potentially employing helper columns where necessary for clarity and performance. To ensure the formulas perfectly meet your needs, could you clarify the exact data structure and the specific outcomes you're aiming for with each calculation? I'm eager to discuss your project in more detail.
£523 GBP in 21 days
4.8
4.8

Hi, I can build these formulas for you, and I'm happy to start right away. I work daily with data and calculations as a data engineer (Python, SQL, Databricks), and Excel formulas are a regular part of that work. That includes arithmetic and statistics (SUMIFS, AVERAGEIFS, STDEV, PERCENTILE), financial functions (PMT, NPV, IRR, XNPV), lookups (XLOOKUP, INDEX/MATCH), and text handling (TEXTSPLIT, TEXTJOIN, LEFT/MID/FIND, SUBSTITUTE, TRIM). Here's a quick example. To pull a domain from an email address and total sales per domain: =TEXTAFTER(A2,"@") → =SUMIFS(C:C,B:B,E2) Every formula I deliver comes with error handling (IFERROR), checks against edge cases, and a short note explaining what it does, so you can maintain it yourself. If you share the sheet (dummy data is fine) and a list of the outputs you need, I'll confirm a fixed price and turnaround within the hour. I can also do the first formula free so you can check the quality before committing.
£500 GBP in 7 days
4.9
4.9

Hi, I’m an experienced Excel analyst with a strong background in building complex financial models and custom formula solutions. I can create the required arithmetic, statistical, and text‑manipulation formulas, ensuring they are robust, well‑documented, and easy to maintain. Could you share a sample of the spreadsheet and clarify whether you need any dynamic dashboards or automated updates alongside the formulas? I look forward to delivering precise, error‑free results quickly.
£289.71 GBP in 4 days
5.1
5.1

Hi, I can build and test the calculation and text-cleaning formulas in your existing workbook, including blanks, invalid inputs and divide-by-zero cases. I will keep the formulas compatible with your Excel version and add short explanations so you can maintain them. My preliminary price is £250 with a 3-day turnaround for an agreed formula list; I need a sample and expected outputs to confirm the scope. I do not have a public comparable workbook to attach. Which Excel version do you use, and roughly how many formulas are needed?
£250 GBP in 3 days
4.5
4.5

Hi, I can build these formulas for you. This is the Excel work I do every day. I would add each formula in the cells where you need results, whether totals and averages, loan or interest calculations, or splitting and combining text like names or codes. Each would reference your existing columns so results update as data changes, and I would check the output against rows worked out by hand. Could you send the spreadsheet or a sample with a note on what each formula should calculate? Let me know if you have any questions at all. Thank you, David
£250 GBP in 2 days
4.7
4.7

Greetings! I can create the Excel formulas your spreadsheet needs, covering basic arithmetic, statistical and financial calculations, plus text manipulation functions. I will build them carefully so they work reliably and are easy to adjust as your data changes. Attention to detail and clean, accurate formulas throughout. Thanks, Revival
£250 GBP in 7 days
4.1
4.1

Hello, You likely need more than formulas that merely calculate, you need a spreadsheet that remains reliable when text, financial inputs, and statistical assumptions change. I can build and validate the required Excel formulas for arithmetic, statistical analysis, financial calculations, and text manipulation, with careful handling of blanks, errors, and edge cases. My background in Analytics and Data Processing supports clear, auditable spreadsheet logic; I can also use Visual Basic where light automation would make the workbook easier to maintain, including practical Artificial Intelligence-assisted workflows when appropriate. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Please share the workbook structure, sample inputs, and expected outputs so we can finalize the formulas collaboratively. Should the formulas remain worksheet-only, or may I add Visual Basic automation for validation and repeatable calculations? Thanks, Asad
£250 GBP in 10 days
3.8
3.8

Hello, As a result of reviewing your requirements, I understand you need reliable Excel formulas covering mathematical, statistical, financial, and text-based calculations. I’m available to start immediately. I can build the formulas using the most appropriate Excel functions while keeping the workbook clear, maintainable, and easy to audit. Where calculations are more complex, I’ll structure them carefully rather than relying on unnecessarily complicated formulas, and I can use VBA/macros only if they genuinely improve the workflow. In my opinion, the key is to confirm the expected result for each calculation first, then test the formulas against sample and edge-case data to ensure accuracy. I have a couple of quick questions. • Can you share the spreadsheet and indicate which columns/results need formulas? • Are you using Microsoft 365/modern Excel, or does the workbook need compatibility with an older Excel version? I would be glad to review the file and can start immediately. Best regards, Carlos.
£250 GBP in 10 days
4.0
4.0

Need a bit more on your data setup before locking formulas, is this one sheet or pulling from multiple tabs, and do you need VBA macros or will native functions cover it? I can build with array formulas or INDEX/MATCH depending on your Excel version. Can start now, done within 2 to 3 days. Budget and timeline here are rough based on the post, we'll firm them up once I see the actual data. Want to send over the file so I can take a look?
£450 GBP in 3 days
3.6
3.6

Bedford, United Kingdom
Member since Oct 5, 2026
$10-30 USD
₹750-1250 INR / hour
min $50 USD / hour
₹600-1500 INR
$250-750 USD
$30-250 USD
₹6000-8000 INR
$10-30 USD
₹750-1250 INR / hour
£250-750 GBP
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹1500-12500 INR
₹750-1250 INR / hour
$750-1500 AUD
₹100-400 INR / hour
$250-750 USD
£20-250 GBP
$250-750 USD