Excel array formula if jobs
In need of a fast, accurate, and reliable professional to assist with spreadsheet data entry and transcription from written documents. All tasks will be conducted using Microsoft Excel. Key Responsibilities: - Spreadsheet data entry - Data transcription from written documents Ideal candidate should have: - Proficiency in Microsoft Excel - Experience with data transcription from written documents - Meticulous attention to detail - Excellent typing speed with high accuracy rate
I'm in need of a skilled PHP developer who can add new modules to our existing web portal. We are focusing currently on the Admin with RBAC module only. The tasks would include: - Integration of modules related to Mutual Funds, Fixed Deposits (FD), and National Pension Scheme (NPS). - Migrating existing data from excel to Database - Unfortunately, the specific features needed for these modules weren't defined. Hence, I encourage freelancers to ask for more details if necessary. Candidates must have: - Expertise in integrating complex modules into existing systems. - Proficiency in PHP. - Strong understanding of the financial services industry. A successful application should contain: - A comprehensive project proposal detailing how you would tackle this integ...
I'm seeking an expert in Excel for a data entry project. The primary task involves inputting numeric data in a specific column structure. The project will require: - Comprehensive knowledge of Excel - Experience with numeric data entry - Attention to detail, ensuring accuracy - Ability to follow the specified structure - Proven ability to meet deadlines Please only bid if you meet these prerequisites and can commit to delivering high-quality work.
I'm in need of an experienced Excel wizard who can handle tasks involving data analysis and comparison in the most effective way. The aim is to analyze basic tabular customer data, identify trends, assess performance, and make data-driven decisions. Skills and Experience: - Excel expert who has a proven track record of manipulating and analyzing different forms of data. - A strong understanding of basic tabular data structure. - Ability to visualize and communicate complex ideas effectively.
I have a list of 1125 products and i want to list them into 1 product using the bulk upload excel. Project should be quite straightforward for excel experts
I'm looking for a freelancer with strong skills and experience in Corporate Finance, specifically at an intermediate level. This project will focus primarily on analyzing Balance Sheets and conducting ratio comparisons of two specific companies based in India. To excel in this job, you should have: - Excellent Financial Modeling skills - Strong capabilities in Corporate Finance concepts - Deep understanding of India's business environment and its financial regulations - Amazing attention to detail and precision in financial analysis, with added emphasis on Balance Sheets and business ratio comparisons. This project offers a chance to apply and expand your expertise in Corporate Finance within an Indian context.
1. Cost of works ( from backup files) 2. Project claims all PC (from PC files) 3. schedule of documents 4. schedule of payments
I'm in need of a service that uses Excel to send scheduled emails to an assorted list, ideally with a frequency of every 5 minutes. Details: - The operating system I'm using is Windows. - The email service that the application would need to interface with is Outlook. - The application should ideally be able to handle the CSV Excel file format for the email list. Ideal Skills and Experience: The ideal candidate for this project would have experience with Excel, as well as know how to create an application that interfaces with Outlook's email system. Familiarity with Windows is also crucial. Experience with email schedules, and CSV file handling is a big plus.
I require a professional who can automate a data extraction process from a formatted PDF file and fill an Excel template that will be provided. The data includes names, product titles, order details etc.. The extracted data must be structured in separate rows and columns as per the Excel file.
...Required: - Proficiency in data entry techniques and software, including Microsoft Excel and Google Sheets. - Excellent attention to detail and accuracy in data entry. - Strong organizational skills to manage and prioritize tasks effectively. - Ability to work independently and meet project deadlines. - Previous experience in data entry or related fields is preferred but not required. Additional Information: - This project is suitable for individuals with a keen eye for detail and a passion for organizing data effectively. - The project duration and workload will vary depending on the specific tasks assigned. - All applicants must adhere to confidentiality agreements and data protection regulations. How to Apply: If you are interested in this project, please submit yo...
As someone desiring the production of a high-quality academic paper, I am looking for a proficient and experienced typist. This task involves creating a document pertaining to the field of Business Studies. The ideal candid...pertaining to the field of Business Studies. The ideal candidate will: - Have extensive experience in document creation, particularly academic papers. - Possess outstanding typing skills, ensuring accuracy and speed. - Have a comprehensive understanding, or a strong interest in Business Studies, as the paper will delve deeply into this domain. This project is a great opportunity for those who excel in typewriting and have a flair for academic document creation, particularly in the business field. Your expertise will drive the successful completion of thi...
I am seeking an Excel expert, proficient in advanced formula and functions like Index, Match, Vlookups, and Pivot Tables. Here's what I need help with: - Use advanced functions to analyze large datasets - Utilize lookups and other functions to find specific values and match corresponding data - Leverage your expertise in Pivot Tables and other functions to create dynamic reports and dashboards - Automate these processes as much as possible The overall objective is to thoroughly interpret and present data in a intelligible way. Prior experience with complex data analysis and Excel-based report generation is a plus.
In pursuit of a long-term partnership, we are seeking a graphic designer with specific experience in creating TTF (TrueType Font) files. If you have not undertaken such work before, we kindly request that you do not reach out, to save both your time and ours. This assignment involves the creation of six TTF fonts, based on templates provided to us in PDF format, similar to the example shown in the attachment. The fonts must be filled in black on the inside before being converted into TTF format. Should you execute this task efficiently and with high quality, you will find a company ready to offer you a vast array of projects, guaranteeing work for the coming years. However, we expect the work to be done well and swiftly. Thank you for your interest. We look forward to your ...
I'm in need of a dedicated team, proficient in both Excel and PowerPoint. This job's split into two functions 1) financial data documents which focuses on business valuation using an existing excel template. ( estimate 30 minutes per document) 2)Business Summary Documents in PowerPoint est 60 minutes per document. The perfect team should: - Be adept in financial data, specifically in Excel - Accuracy and reliability is essential - Ensure Excel proficiency extends to business valuation calculations - Preparing clear and concise PowerPoint documents based on customer input and a standard powerpoint structure, involving some basic data research and collection/collation. We are looking for a company that can handle a larger volume and has multiple pe...
Hello, it appears I need a freelancer who can handle an unclear project and deliver an excellent solution. With no specific direction indicated for the project, I require a freelancer with a vast array of skills in web development, graphic design, and writing. Key requirements: - Experience in various fields of expertise due to the undefined nature of the project. - Proven track record of handling ambiguous tasks and delivering beyond expectation. - Proposed methodology of execution, to give a clear insight on how you plan to achieve this task. Please, in your application, showcase your past work, overall experience and provide detailed project proposals. I'm looking forward to engaging a creative expert that can turn this undefined project into a masterpiece.
I am in need of 400 top-quality medical dentistry leads specifically from Madrid, Spain. The project factor includes: - Contact Names - Physical Addresses These should be appropriately compiled in an Excel spreadsheet. Successful applicants should include examples of past work related to lead generation to be considered for this project. Exceptional attention to detail and accuracy is extremely critical for this task. Ideal freelancers should have proficiency in Excel and previous experience in the medical or dentistry industry would be a huge plus. Accuracy, punctuality, and confidentiality of the information collected are of paramount importance to this project.
I require a meticulous and diligent professional to handle a large volume of text data entry to an Excel spreadsheet. The project encompasses entering more than 4000 text entries/contacts accurately. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Fast typing speed with a keen eye for detail - Demonstrated experience in large scale data entry . - Fast copy and paste skills Key Responsibilities: - Input more than 4000 text data entries/contacts into Excel - Sustain high levels of accuracy throughout the project - Manages and handles data efficiently within the agreed timescale. - Copy paste contacts - Name, Phone number, company name from a website to excel file.
...create a search tool for my series of Excel spreadsheets. Each spreadsheet stores client records, which consist of: - Name and contact details - Purchase history - Piano Type - Method used to move the piano The search tool should be capable of displaying all these details about each client record. The tool should be designed in a way that it matches any search criteria inserted. This means if any criteria matches with the client's information, that entire record should be displayed. Another key feature is the ranking of the search results. The tool should organize the results alphabetically by the client's name. The ideal freelancer for this job should have a sound understanding of Excel, search algorithms, and UI design. Experience in developing ...
I'm in need of a concise, user-friendly business website developed on GoDaddy. Requirements: - The website should comprise of only 1 to 5 pages, ensuring simplicity yet all-roundedness. - Incorporation of a product catalog is mandatory to showcase our wide array of offerings to prospective clients. - The inclusion of customer testimonials is paramount to establish credibility and build trust with potential customers. - A contact form is needed for seamless communication between customers and the business. Ideal Experience and Skills: - Proven track record of website development on GoDaddy platform. - An eye for aesthetics, ensuring an attractive, easy-to-navigate website. - Knowledgeable in e-commerce functions, especially in relation to product catalogs. - Previous experien...
I am looking for a skilled freelancer with profound expertise in Excel and SQL, particularly on the Mac platform. Key tasks include: - Importation of numeric data from an Excel workbook into Microsoft Azure Data Studio using Python - The data is arranged over multiple worksheets, all of which are interrelated. - Apart from the primary data importation job, the freelancer will be tasked with devising an efficient method of performing this task on a daily basis. Ideal Skills: - Strong Excel and SQL skills with experience in data migration. - Proven ability to handle related datasets spread over multiple worksheets. - Experience with automation, to maintain daily import tasks. - Familiarity with Mac operating systems. Your bid should demonstrate a clear understan...
I am looking for an experienced freelancer with proficiency in excel to develop a streamlined, user-friendly excel sheet for my company. The ideal candidate will be deeply knowledgeable in creating custom formulas, and have tangible experience working with budgeting and accounting. Key requirements: 1. Data Tracking: The excel sheet should be designed to allow for an efficient tracking of Income, Expenses, Sales and Inventory. 2. Formulas: The sheet should incorporate specific formulas for the calculation of Profit Margins, Tax and Budget tracking. 3. Design: A simple and clean layout is expected. The sheet should be easy to navigate, without diverging into unnecessary complexity. Your understanding of financial data and ability to present it in an accessib...
I'm seeking multiple part-time staff members for a chemical industry exhibition. I require individuals who can excel in the following tasks: - Demonstrating product features - Assisting with customer inquiries - Managing booth logistics These roles are required on an hourly basis, making flexibility in availability advantageous. Ideally, prospective candidates will have previous experience in exhibition assistance or related fields within the chemical industry. Exceptional public speaking skills, customer service acumen, and organizational abilities will set successful applicants apart in this dynamic, client-facing role.
I'm seeking someone with a strong background in Excel and VBA programming to automate report generation. Details: - This project entails using VBA/macro to automate financial report generation in Excel. - The reports will be created from financial data with the primary goal to simplify the overall reporting process. - The financial data involved may include expense records, costings, revenue data, among others. Desired Skills & Experience: - Strong Excel VBA programming skills - Prior experience in automation of financial reporting - Proficiency in data processing and analysis is a plus. - Familiarity with financial data and terminology - High attention to detail with a proactive approach towards problem-solving The completion of this project will enhance...
I'm hopi...Responsibilities Will Include: - Performing deep web scraping for sales data. - Compiling the data in an Excel file. - Executing basic data cleaning and minor organization tasks. The Specifics: - The specific data I'm interested in are the names listed in specific directories: Directory A, Directory B and Directory C from each of the mentioned websites. Added Task: - An additional task involves collecting email addresses found on the linked pages of these directories. Ideal Skills and Experience: - Extensive experience with web parsing and data extraction. - Proficiency with Excel and data cleaning procedures. - Familiarity with email address extraction from web links. Please bid on this project if you have the right skills, and are able to de...
...a highly organised and detail-oriented accountant to handle bookkeeping tasks for my company. This predominantly includes maintaining our financial records in Excel. Roles and Responsibilities: - Maintaining our financial transactions. We are a small company with less than 50 transactions per month. The accountant will be responsible for maintaining these records and updating them accurately in Excel. Key skills and Experience: - Proficient in Excel: We currently use Excel for our bookkeeping tasks, so we need someone who is experienced in managing finances in Excel. - Experience with bookkeeping: I'm not looking for just an Excel whiz, but someone who truly understands bookkeeping and can organise our finances effectively. - Attention t...
I need a client facing template to show the following metrics for Google Ads branded with , spot to put clients name and logo. Metrics for Google Ads I need to show - Cost Per Click, Total Cost, Cost Per Conversion and Conversion Rate SEO - Conversions, session, users, top pages etc and keyword ranks
...Listing: The website should have a professional, easy-to-navigate page displaying our wide array of products. - Shopping Cart: Seamless integration of a shopping cart to facilitate a smooth shopping experience for potential clients is mandatory. - Customer Reviews: The website should foster a sense of community and encourage customers to share their experiences by including a review section. Ideal Skills: The ideal freelancer would have a strong command of e-commerce websites and hold prior experience with creating similar websites. They must be able to deliver quality work promptly as this project is urgent and must be completed as soon as possible. Remember, time is of the essence here, so only bid if you're ready to hit the ground running. I look forward to seei...
I require a well-structured Excel spreadsheet for comprehensively tracking a school fundraiser. The requirements are as follows: - Track the number of participants involved in the fundraiser. - Tabulate the amount of money raised in each fundraising event. - Generate separate pages for each grade contributing towards the fundraiser. - Provide both individual student and total grade contribution summaries on each of the aforementioned grade pages. - Sum up all individual amounts raised to compute the final tally. - Finally, a page dedicated to showing the final tally, the amount owed, along with the collective amount raised. - Selling 5 items to keep track of totals for each grade & a final total Ideal Skills: - Advanced knowledge of Excel to create a user-friendly, c...
I need a skilled developer to create a file explorer for Windows that's not only more advanced aesthetically, but also significantly faster and easier to use than Microsoft's current version. Key improvements I'm looking for include: - Increased speed to locate files - Enhanced aesthetic design - Superior navigation I mainly work with Document formats (such as Word, Excel, and PDF and also DWG, DXF) and Image formats (like JPG, PNG). Therefore, these file types should be prioritized in the design and functionality. Ideal freelancers for this project should have extensive knowledge in software development, a keen eye for modern aesthetics, and a deep understanding of end-user experiences. Prior experience in creating file explorers or similar applications is high...
I'm seeking the aid of a skilled photoshop artist, specifically one who excels in photo editing. The primary task will revolve around performing simple object removals from an array of images. Experience in similar projects and an understanding of color correction is a bonus. Key Responsibilities: - Photo editing, focusing on removing simple objects. - Adequately handling colors and maintaining visual balance within images. Ideal Skills: - Proficiency in Photoshop - Experience with object removal and color correction - Excellent eye for detail and strong visual skills. Please provide examples of your previous work that illustrate your aptitude for image editing and especially object removal.
I am looking for someone who can help me export Instagram followers from a public account to an Excel file. The data needed is solely the usernames of each follower, no additional information required. The ideal candidate for this job is tech-savvy, detail-oriented, and comfortable with data extraction and Excel. Experience with social media APIs, especially Instagram, and Excel data handling will be crucial for successfully completing this project. Key Responsibilities: - Extract usernames from a public Instagram account - Import the data to an Excel file - Ensure accurate capture of information No particular organization or formatting in the Excel file is needed. Let's keep this straightforward and simple. Your primary goal is efficiency and...
details will be share on chat minimal budget will be prioritise max time few hours it's a small job
I have a predefined dataset in an Excel file. The data features the names of different regions or cities, which are neatly organized with each location listed in separate columns. The task is to fill out the missing data for the distance between these locations or cities. Ideal Skills and Experience: - Proficient in Excel - Experience in data entry - Excellent attention to detail - Ability to work accurately and efficiently - Knowledge about using online distance estimator tools would be favorable The successful freelancer should also demonstrate the ability to source and apply the most accurate distance data where needed.
We have an array in which the availability of an accommodation for 6 months is stored. Under ‘a’ is the availability Under ‘c’ is the minimum stay The PHP script should check if the minimum stay is longer than a free period. If the minimum stay on one day is longer, then the output should be “Check minimum stay on date xx”. Furthermore, it should be checked whether there is a ‘2’ on the first day of a gap. If not, then output “Check arrival days on date xx”. Example JSON FILE: jQuery18209612825557121774_1710055437905([{"date":"2024-02-01T11:00:00.000Z","d":[{"a":1,"b":3,"c":1,"f":0},{"a":1,"b":3,"c"...
...someone experienced in Excel transcription to create a spreadsheet for me from a scanned PDF contact list. The critical points here are: Requested Skills: - Excel transcription - Data accuracy and organization Project Details: - Please transcribe the non-crossed out contacts data from the scanned PDF (20240305_214525 ) into a digital spreadsheet.* - Follow the column and header structure found in the file - The final spreadsheet must be organized according to the "Customer Name" column. - The final file format should be in Microsoft Excel. *Some contacts have data partially crossed-out. These contacts should be in the final spreadsheet, just without the crossed-out portions. Lastly, ensure that no fully crossed-out data is included in the final Exc...
...advice and specifications for a solar pole mounted array. The array dimensions are based on length and width of array in the air mounted on a pipe the installation will be located in an area with low wind loading and rocky soil, so I need to do a ballasted mount that might just be setting on the ground, The picture attached is what 3 of the pole mounted array's look like,, in the picture they are dug into the ground 8 feet and a concrete solotube and concrete was used,, I need to know how much concrete is needed to do a ballasted mount and what size sch40 steel pipe is needed . it is imperative for the freelancer to consider these aspects for the accurate calculation of concrete usage required. Key Skills and Experience - Solar array installat...
I'm in need of an Excel Expert proficient in the French language. The task revolves around a large product database for my existing business. The database, currently in CSV format, contains approximately 3534 product titles that need to be matched with their correct categories. Additionally, product descriptions need to be created and added for each title. The product titles also need minimization, ensuring they are concise whilst retaining essential information. The ideal freelancer should possess: - Proficiency in Excel - Good command of French language - Experience with data matching and cataloging - Ability to work with CSV files - Skills in writing succinct, meaningful descriptions Please make sure your proposal accurately portrays your skills in tackling this p...
I am working on an Excel sheet that performs operations for structuring and analyzing data. However, it's not providing accurate results which is hindering my data analysis. Key Requirements: - Revise existing formulas to correct data return issues. - Make the sheet versatile enough to accurately analyze different sets of data that I will input. Skillset: - Proficiency in Excel and its data analysis functionalities - Strong understanding of data structure - Ability to debug and correct Excel formulas
I'm looking for an experienced Tableau expert to build us daily reports from CSV/Excel files. This will include: - Creating Sales reports - Setting up Financial reports - Designing Marketing reports We are seeking candidates who have a strong background in data analysis, specifically having worked with CSV/Excel files for data sourcing. Key skills and aptitudes: - Extensive knowledge of Tableau and its functionalities - Proficiency with CSV/Excel files - The ability to keep the reports updated daily - Strong attention to detail - Prior experience in creating financial, marketing and sales reports.
I'm looking for a content writer who can breathe life into my e-commerce website that caters to both genders. - The website focuses on a wide array of lifestyle products, so the perfect candidate should have a flair for crafting vibrant, intriguing, and engaging descriptions for such items. - If your descriptions can make the product come alive, then you're the person I'm looking for. We also use AI to be quicker in our work. - A background in writing for e-commerce and working with AI would be advantageous. Skills and experience that are needed: - Proficiency in French (writing) - Previous e-commerce writing experience if possible - Mastering chatGPT4 - Ability to write exciting and engaging content.
Excel web query to extract data into Excel spreadsheet from also extract Live odds comparison table from Currently, these 2 tables are not showing up using Excel web query
I have project need to knkw if it's can be done If you can start now, start your bid with NOW
I require a skilled content writer and designer for an engaging catalogue featuring a range of food products. As the core purpose of this project, the catalogue will showcase our offerings vividly to potential buyers. Key tasks: - Creating and designing a 10-20 pages catalogue - Crafting product descriptions for a wide array of food items - Appropriating the corporate brand voice and aesthetic into the catalogue design Ideal qualifications: - Proven experience in catalogue design - Excellent writing abilities, particularly in product descriptions - A strong understanding and execution of brand coherence across marketing materials.
I have project need to knkw if it's can be done If you can start now, start your bid with NOW
I am in search of a highly capable copywriter who possesses a diverse array of skills. Key qualifications include: • Expertise in crafting compelling blogs, website content, and product descriptions. • Ability to adhere to an informative, conversational tone throughout all projects. • Experience and fluency in developing content catered towards both general and technical audiences. Your bid should reflect your experience in these specific areas. I look forward to collaborating on an array of diverse and engaging content.
I require a keen, detail-oriented individual to transcribe text data from a physical copy into an Excel file. Key Tasks: - Typing text data accurately from a hard paper copy - Efficiently organizing typed data into a neat and easily readable format in Excel Ideal Candidate: - Demonstrates excellent typing skills - Proficient in Excel - creating and manipulating spreadsheets is a must - Possesses fabulous attention to details - Past experience with data entry projects is highly valued Your task will purely be concerned with data entry. Understanding of the written content won't be necessary. But precision in transcription and ability to deliver on time are crucial.
I require a keen, detail-oriented individual to transcribe text data from a physical copy into an Excel file. Key Tasks: - Typing text data accurately from a hard paper copy - Efficiently organizing typed data into a neat and easily readable format in Excel Ideal Candidate: - Demonstrates excellent typing skills - Proficient in Excel - creating and manipulating spreadsheets is a must - Possesses fabulous attention to details - Past experience with data entry projects is highly valued Your task will purely be concerned with data entry. Understanding of the written content won't be necessary. But precision in transcription and ability to deliver on time are crucial.
I am seeking an experienced data scientist with expertise in forex trading. Your tasks will encompass: - Analyzing datasets related to historical forex market data, economic indicators, and news sentiment. - Developing predictive models to anticipate currency trends based on analysis. Experienc...Developing predictive models to anticipate currency trends based on analysis. Experience in forex trading, predictive modelling, and data analysis is ideal. Also, you must have skill in cross-checking daylight saving times against these datasets. Please demonstrate your ability to handle these tasks in your proposal. - Data will be for 15 years worth between tick data and 1M prices. Very large Excel file which has over 500k to 1Million rows per tab / year depending on 1minute or...
...in need of a highly skilled Excel expert who can efficiently create two dashboards from a database of 5-7 columns. These dashboards will be used mainly for visualization reporting purposes. The built dashboards should be able to handle and present mixed data, made up of both numerical and textual information. Since data will be updated on a weekly basis, the dashboards should be designed with this frequency in mind to facilitate seamless updates. Key Skills Required: • Advanced Excel knowledge and experience. • Understands data visualization best practices. • Proven experience in creating interactive dashboards. • Ability to manage and present mixed data types. • Capable of setting up dashboards for weekly data updates. This is a great opport...
