I need help with excel jobs
I need a proficient developer to 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 algorithm...
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. You...
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 pres...
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 ...
...to work with a seasoned professional who excels in extracting data from multiple websites, specifically Website A, Website B and Website C. Your Major 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 clea...
...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 effec...
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
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 us...
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 ...
I'm looking for a talented and creative writer who can craft a short story for a modern love theme set in a vibrant city environment. The story genre needs to be comedy, bringing...should have the ability to generate hilarious scenarios and dialogues that are realistic and relatable. • Length: This will be a short story. Your skills should include being able to create impactful and engaging tales within limited word counts. • Setting: The story will take place in a city. Experience in creating rich urban settings, with a keen eye for details of city life, is necessary. • Ideal Candidate: This gig is perfect for writers who excel in the comedic genre, can encapsulate the nuances of modern love, and can vividly paint a city landscape. A portfolio of simil...
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 pr...
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.
As a beginner, I am seeking a knowledgeable developer who can guide me on effectively using Google Cloud for Hadoop, Spark, Hive, pig, and MR. The main goal is data processing and analysis. Key Knowledge Areas Needed: - Google Cloud usage for big data management - Relevant functionalities of Hadoop, Spark, Hive, pig, and MR - Best practices for data storage, retrieval, and workflow streamlining Ideal Skills: - Extensive Google Cloud experience - Proficiency in Hadoop, Spark, Hive, Pig, and MR for data processes - Strong teaching abilities for beginners - Demonstrated experience in data processing and analysis.
...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...
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 a...
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.
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 have project need to knkw if it's can be done If you can start now, start your bid with NOW
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. 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 Tick data
I am 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. ...
we are proficient professional who can handle data entry into Excel. Our responsibilities will primarily require: - Working with mixed text and numerical data. - Entering and organizing this data into a tabular format. Our ideal Team possess robust Excel skills, coupled with a attention to every detail. Our ability to process mixed text and numerical data efficiently will be the key to success in this role. We have multiple Prior experience with similar data entry projects and we would be advantageous but is not compulsory. We know that Timeliness, accuracy, and confidentiality are crucial aspects for this job. Looking forward to any data project will be provided to our team for processing.
I require an expert with a solid background in Excel and advanced problem-solving skills. Your tasks will include: - Cleaning and formatting sales, financial, and survey data. Please ensure accuracy and consistency in our data sets. - Calculating relevant statistics and metrics from this data. I entrust your knowledge of appropriate statistical methods to use to bring us meaningful results. - Creating dynamic charts and graphs to visually represent our data. Your ability to present information in an easily understandable manner is crucial. The main goal of the data analysis is to uncover trends and patterns that will enable us to make data-driven decisions. Therefore, strong analytical skills and business acumen are a must. Experience with similar proje...
We are looking for an expert in Substrate and Rust to help us complete our Layer 1 blockchain deployment. Main areas we need help with: 1. Native token supply and minting per block, treasury pallets setup in Proof of Stake 2. Testnet deploy in AWS If you are an expert in these areas we would like to hire you to consult our blockchain dev team, starting today.
I am in need of a Google Sheets expert knowledgeable in creating formulas. I have a google sheets document where I track all my income and expenses. In this sheet there are three sub sheets (tabs) which are called ALL TRANSACTIONS, JOBSITE LIST and CATEGORIES. Column B of the ALL TRANSACTIONS sheet (named jobsite) the input is a dropdown, for which input can be added from column B of the JOBSITE LIST sheet. Column F in the ALL TRANSACTIONS sheet is also a dropdown with data coming from the CATEGORIES sheet. Column I of the ALL TRANSACTIONS sheet is a running balance which is calculated from all income and expense inputs. (columns D and E) Everything works fine so far, but I want to summarize the income and expense for each jobsite in the ...
I'm in need of a professional who can successfully convert my Excel sheet into a stand-alone Windows-compatible program. The key functionalities to be retained from the Excel sheet within the new program are: - The ability to manually input and extract data - Execution of all existing formulas and calculations - the program should be user friendly and can not be copied without special permission - a good design with my company logo is essential Ideal candidates should be experienced programmers with strong knowledge of data management and task automation, as well as an understanding of Excel functionalities. Familiarity with data analysis will also come as an advantage.
I'm seeking a professional who can script a user-friendly interface in PowerBI for my team to manually enter numerical data/ text directly without the need for excel. The main task will be to design and implement a data entry system suitable for a non-technical team. Key responsibilities include: - Setting up this custom data entry system within PowerBI - Ensuring the system allows for manual input of numerical data which is then stored in sharepoint excel - Verifying the accuracy and consistency of the data entered The ideal candidate for this project will have: - Significant experience with PowerBI, Python, and data visualization - Understanding of data management and integrity checks - Proven track record of creating custom data entry forms in PowerBI...
I need highly skilled graphic designers to create an A5, double-sided menu flyer for my cloud kitchen. This is an exciting opportunity for a designer that thrives on clean, modern design styles. Key details about the project include: - Size: The menu flyer must be A5, ensuring a compact but comprehensive layout. - Style: Preference will be given to designers who excel at modern and clean aesthetics, providing a visually delightful and uncluttered experience for my customers. - Pages: The menu flyer should be double-sided, utilising space effectively to present all necessary information without overwhelming readers. Ideal candidates should have significant experience in graphic design, particularly in creating menu flyers or similar materials. Knowledge of modern d...
I'm looking to populate the front sheet of my pricing document using the tabs behind. I need it to look for any populated value, if there is one there, return it. e.g. formula in C25 looks up list in Product List A2:A500 and returns the first value populated. In C26, it should look up the same column of A2:A500 ignore the first value because that's already populated above and return the next value. I cant have it returning row for row as i have limited space. The standard Product should look up Product list tab, Bespoke one should look up the first bespoke tab, Bespoke 2, the second etc. One formula should pretty much work for all, its just what its looking for and how to get it to ignore values that have already been pulled across.
I'm seeking detailed-oriented freelancer(s) with Excel expertise to help me transcribe and organize data into approximately 350 spreadsheets. Key Responsibilities: - Entry of various types of data (text, numbers, and dates) as modelled in the provided sample. - Employing a versatile organizational approach where data types might be handled in more than one column. Timeline: The project should be completed within one month. Ideal Skills: - Proficiency in MS Excel and data management. - Detail-oriented approach and high accuracy in data entry. - Ability to follow instructions and work with varying data arrangements.
I'm in need of a proficient data entry specialist who can help me transfer text, numeric, and date & time data from multiple websites to Excel spreadsheets. - Data Types: The project involves working with a variety of data types including text, numbers, dates, as well as articles, notes, and data in Hindi font. The proficiency in Hindi and ability to handle various data formats is crucial. - Number of Websites: Data has to be scraped and entered from three or more different websites. Experience in web scraping tools is mandatory. - Volume of Data: For each website, you will be dealing with approximately 400 pages. Expertise in data management from high volume websites is a key requirement. Your ability to accurately handle and organise a lar...
I am seeking a freelancer with expertise in data visualization for a graphic design project. Your task will be to create a pie chart that clearly represents ten 'Sectors of Life'. I have chosen Excel or similar so that I can modify the words as needed because I appreciate its simplicity and I want to be able to make edits in the future if required. The skills and experience required for this job are as follows: - Proven experience in data visualization and Excel chart creation - Ability to interpret life sectors and visually represent them in an organized way - Consistent communication for the successful execution of the project I look forward to seeing your bids and working with you on this interesting proje...
As a small business owner, I require an Excel expert who can assist in creating a custom-made Excel file specifically for quotation calculation purposes. This Excel file will primarily perform comparisons of quotation calculations derived from various vendor rate lists. The ideal candidate should possess the following skills and experience: • Expertise in Excel formula calculations, and knowledge of macros will be helpful. • Familiarity with business quotation calculations from various supplier rate lists. • A proven track record of creating tailor-made business tools using Excel. The role's responsibilities include: • Designing and constructing an Excel file suitable for executing complex quotation calcul...
I am promptly looking for an expert capable of converting a VBA script that currently operates on Windows Excel 16 to function on Mac Excel 16. The existing VBA script is primarily used to automate tasks, owing to which, proficient experience in scripting automation and swift task execution is key. - Ideal Skills: Proficiency in Excel VBA, familiarity with both Windows and Mac Excel 16, understanding of task automation via scripting, and the ability to deliver within short timeframes. - Key Ask: The primary function of the script is to automate tasks. While specifics aren't provided, a good grounding in automating generic tasks through VBA scripts will be invaluable. - Timeframe: This job is immediate. I require a swift convers...
I have an Excel 2016 VBA script in need of converting to Mac VBA. The converted script is expected to retain the same functionality. Additionally, I require a video tutorial demonstrating the successful running of this new script. The video duration is flexible and it shows the success of the converted script. I'm urgently looking to complete this project. Ideal freelancer should have: - Experts in VBA scripting, especially Excel 2016. - Proficiency in MAC VBA Scripts. - Experience in creating video tutorials. - An ability to complete tasks on short notice.
We require a VectorWorks, VectorScript plugin built to do some calculations and present results. The following is a brief summary. More details will be supplied to successful candidate. In we need to be able to click in the VW, 4 extents (length of item, start, stop, and width). A popup should show and advises some information. A data table is then referenced (think Excel - VLOOKUP) The object is then measured, labelled, and put into a table on the sheet.
I need a Drupal specialist to craft a sophisticated quiz module for delivering online tests. This should include the following key features: - A facility for multiple choice questions. - A countdown timer for each question. - Random question selection for greater challenge and variation. - user can register and then attempt our quiz - list of Our created quiz will be be display at front end -admin can download quiz attempted user data in excel format I plan to create multiple types of quizzes, each having a unique configuration and targeting different user groups. Knowledgeable freelancers who can demonstrate prior experience in Drupal quiz module creation will have a significant edge here. It's worth mentioning that I will supply all quiz conten...
we are proficient professional who can handle data entry into Excel. Our responsibilities will primarily require: - Working with mixed text and numerical data. - Entering and organizing this data into a tabular format. Our ideal Team possess robust Excel skills, coupled with a attention to every detail. Our ability to process mixed text and numerical data efficiently will be the key to success in this role. We have multiple Prior experience with similar data entry projects and we would be advantageous but is not compulsory. We know that Timeliness, accuracy, and confidentiality are crucial aspects for this job. Looking forward to any data project will be provided to our team for processing.
I require a freelancer to convert our existing Excel estimating spreadsheet into a Cubit estimate template. Key Requirements: - Full conversion of Excel spreadsheet to Cubit. - Maintain key functionalities from our original spreadsheet, including formula calculations and data sorting. - Help us set up Cubit in our office for testing use. Ideal Skills: - Proficiency in Excel and Cubit estimating systems. - Experience in migrating data from Excel to Cubit. - Understanding construction estimating, specifically for modular residential homes, would be advantageous.
I'm in need of a Corel expert able to assist with data feeding task and capable of importing data from an XLSX format Excel workbook into Corel in a certain format . I have attached an excel file which has data of students and a corel file which has format in which the data of all students needs to be filled. (not copy pasting) So this is a school result and it is in excel file and We have a set format in Corel draw. All you have to do is import that data which is in excel file to corel file according to their headings. From class 1-12 there are 4 formats. There would be around 2000 Students. It is very time sensitive task considering results. You won't get much time (hardly 1-2 day max). Key Responsibilities: - Implement and e...
[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Inputs] "" and "". [Output Goal]Copy Excel(.xlsx) data ant paste to Google Docs( not microsoft Word) [Output Example] [Detail]Process Excel tables row by row and paste them into Google Docs. Image data can also be set as necessary.
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule. The data parameters from the spreadsheet that need to be incorporated into the schedule are names and time slots. Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. Skills & Experience: - Strong Excel skills - Excellent organizational abilities - Prior experience in creating schedules or calendars from Excel data Your job will be to carefully transfer the 'Names' and 'Time Slots' from the spreadsheet into the daily calendar format I need. Please ensure ...
