How to use microsoft excel 2016 jobs
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Po...
I'm in need of a seasoned Mechanical Engineer with specific expertise in heat transfer, fluid dynamics, and thermodynamic cycle analysis to assist in the development of a revolutionary solar thermal engine patent prototype. Key Requirements: - Conducting in-depth thermodynamic cycle analysis for the solar thermal engine. - Designing the engine layout and key components to optimize its performance. - Understanding and managing the behaviors of steam vapor and condensate. - Proficiency in analyzing fluid flow, power, and pressure drop. - Knowledge of steam hammer and heat pipe behavior for this application. - Experience with developing engines within the 1-5 kW power output range is essential. Ideal Skills: - Proficiency in CAD software, such as SolidWorks. -...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquir...
...looking for a professional to help me set up Audiocodes with Microsoft Azure Direct Route to integrate with a PBX system. Key Requirements: - Extensive experience with configuring Audiocodes for call routing - Proven track record in setting up SIP trunking - In-depth understanding of Microsoft Azure, particularly with Direct Route - Ability to seamlessly integrate Audiocodes with a PBX system The primary goal of this project is to ensure that the Audiocodes system works efficiently and effectively with the Microsoft Azure Direct Route, specifically for integration with a PBX system. You should have a solid grasp of SIP trunking and the ability to deliver a setup that guarantees optimal call routing within the integrated system. ...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in G...
...terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will create in Microsoft...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and a...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Pre...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
I need assistance with a data entry project where handwritten documents need to be accurately typed into Microsoft Word. Key Requirements: - Data entry: The task primarily involves typing data from handwritten documents into Microsoft Word. Accuracy is crucial. - Time efficiency: The project has a deadline, so the freelancer should be able to complete the task within the given timeframe. - Formatting: The final data needs to be well-structured and presented in a clean manner. Ideal Skills: - Proficiency in Microsoft Word. - Excellent typing speed and accuracy. - Previous experience in data entry, especially with handwritten documents, would be a plus. - Attention to detail and ability to maintain formatting consistency. This proje...
I'm in need of a skilled and experienced Microsoft Project specialist to create a comprehensive project plan for my upcoming project. Key Deliverables: - The primary requirement is to focus on the Requirements Gathering phase. This should be treated with utmost attention and detail. Goal of the Project Plan: - The main objective of the project plan is to outline the project's timelines. This is crucial for our team to have a clear understanding of the deadlines and the flow of the project. Desired Level of Detail: - The project timeline should be detailed and broken down by week. This will allow for a more structured and easily trackable plan. Ideal Skill Set: - An expert in MS Project tool is a must. - Strong project planning and schedulin...
...English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the requir...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
...of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for r...
I'm looking for a skilled artist who can create a replica of an existing image in a cartoonish style. The replication should closely resemble the original but with...image will be used for digital purposes, such as on websites and social media. Key Requirements: - Replicate an existing image in a cartoonish style - Maintain a close copy of the original with altered elements - Ensure the final output is suitable for digital use Ideal Skills and Experience: - Proficient in digital art and illustration - Strong understanding of proportions, details, and shapes - Experience in creating cartoonish art - Ability to replicate existing images while adding a unique touch - Understanding of digital use and design principles Please provide examples of your previous cartoo...
I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable wo...
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
i need to get the services of a developer who understands PHP & Java to correct and update some open source software. I have access to raw code and git hub library. Programs work, but needs some adjustments to get them to operate properly. There is not a lot of parts of the the different software that needs correcting and so i would not expect it to take too long, as most of the features work fine, but there are some features that are not working in correct manner. I want to start off with one application fix. Then if work fine, we can work together to add extra features.
I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacua...
St...with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries wi...
I'm seeking an architectural draftsman proficient in creating a professional drawing of my mixed-use building purchased in 1973. Unfortunately, the DOB and HPD don't have an original layout drawing of my property, which is hindering my process of applying for a Letter of No Objection (LNO) and obtaining a Certificate of Occupancy (CO). The preferred freelancer will have: - A track record in architectural drawing and a deep understanding of building standards prior to 1938. - Proficiency in making comprehensive drawings without original blueprints or plans as a reference. - Broad experience in designing detailed plans that are acceptable for DOB and HPD procedures. - Ability to deliver work within an agreed timeline, as speediness is crucial for this projec...
...appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquiries Content Management: Stay updated on crypto news and investment projects by monitoring relevant Telegram channels and other sources. Respond to community messages, YouTube comments, and inquiries from followers. Email Newsletter Preparation: Prepare a weekly email newsletter based on the latest market news and developments. Ensure that newsl...
I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.
...freelancer to code for an Industrial Automation System specifically focusing on manufacturing process control. Key Tasks: - Develop efficient code for my Industrial Automation System. - The code should aim at automating the manufacturing process control. - Testing the code for effectiveness and making necessary improvements. Skills and Experience: - Strong experience with IoT devices, especially industrial automation systems. - Exceptional coding skills, particularly in an industrial background. - Experience in manufacturing process control. - Ability to work quickly and effectively, as the project is needed ASAP. Experienced with Microsoft Azure Timeframe: The project should be completed as soon as possible. Applicants should have immediate availability and ...
I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.
...professional, I am in need of an experienced appointment setter to handle my scheduling needs. Key Responsibilities: - Scheduling property showings and client meetings - Ensuring more than 20 appointments are scheduled per week - Management of my personal Google Calendar and Microsoft Outlook accounts to avoid conflicts Skills and Experience: - Previous experience in appointment setting, particularly in the real estate industry, is highly desired - Proficient with Google Calendar and Microsoft Outlook - Ability to bring & handle a high volume of appointments in a fast-paced environment - Excellent communication and organizational skills are a must. I am looking for someone who can handle this task efficiently, with exceptional attention to...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB...
I'm in need of a skilled photo editor to work on a batch of 10 raw images initially. If the initial batch is to my satisfaction, I have more photos that will need editing. The photos are of jewellery (earrings, necklaces, bracelets), so the metal and stone colour should be clear. Requirements: - Expertise in working with RAW format (NEF to be precise) - Ability to edit photos in a natural and subtle style - Proficient in cropping and grading images The edited photos will be used for online publication, so it's important that the quality be top-notch. If this goes well, I will have more work for you in the future.
I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English
I'm in need of someone with excellent typing skills to format my business reports. This project is about making my reports look sharp and professional in Microsoft Word (.docx) format. Key requirements: - Excellent typing skills are key, as the reports will need to be retyped into the desired format. - Experience with business documents is a must. Formatting needs to be polished and consistent. - Proficiency in Microsoft Word (.docx) is essential, as this will be the final format of the reports. This is a straightforward job for someone with the right skills, and I'm looking to complete it in a very timely manner.
I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced ...
...we chatted about: I have a large Word document (57 pages / 8,046 words) that requires a meticulous conversion to HTML. It's imperative that this conversion maintains the document's original presentation. Key aspects for this project include: - The HTML output must mimic the original Word document's structuring and formatting. - Special attention has to be given to making it match exactly to the Word document. This includes font type, size and spacing. note there are images as well to be included. - It will need to be mobile friendly as such. - An excellent understanding of HTML, CSS and Microsoft Word is vital. - Strong experience in converting documents from Word to HTML is desired. Applicants should ...
I have a Word documen...consistency of fonts, font sizes, and styles - Reformatting the document structure for better readability and flow - Modernizing images and layout to give a fresh, updated look - Creating new branding guidelines and applying them to the document Ideal Skills & Experience: - Proven experience in comprehensive editing, copy editing, and document formatting - Strong understanding of branding and design principles - Proficiency in Microsoft Word and Adobe Creative Suite - Excellent eye for detail and ability to maintain consistency throughout the document - Understanding of branding guidelines and ability to create new ones The ideal candidate should be able to deliver a polished, professional document with updated brandin...
...with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be required to manage key client accounts, upload new content on Amazon listings, work with design, sales and other Lezzat team members to...
I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.
I'm seeking an Azure expert to guide me through the AZ-104: Microsoft Azure Administrator certification. Key Tasks: - **Guidance on Key Topics**: I need support in understanding and mastering the crucial concepts covered in the certification. This includes both theoretical and practical aspects of Azure administration. - **Online Sessions**: Regular online meetings would be ideal to discuss questions, share insights, and track my progress. Ideal Candidate: - **Azure Proficiency**: You should have a deep understanding of Azure and practical experience working with the platform. - **Teaching Ability**: Prior experience in tutoring or mentoring would be beneficial. - **Good Communication Skills**: As I'm relying on online sessions, clear and effective commun...
...Consultant with knowledge in Microsoft Dynamics 365 F&O and expertise in Power Platform. Key Project Requirements: - **Dynamics 365 F&O Modules**: I need assistance in integrating Dynamics 365 F&O with Power Platform, particularly focusing on Financial Management and Supply Chain Management. - **Power Platform Integrations**: Require your support in: * Data integration: Ensuring seamless data exchange between the two systems. * Workflow automation: Developing and implementing automated workflows for various business processes. - **Vendor Invoice Creation**: The vendor invoice creation process should include: * Auto-population of vendor details: Ensure vendor information is correctly filled in. Ideal Skills and Experience: - Strong background in Microsoft...
I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to...
I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.
I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It...
We are seeking a skilled AI and Machine Learning Engineer and Software Developer to develop and train machine learning models for chatbot functionalities, integrate AI components, and implement NLP techniques. Additionally, I'm looking for a talented Software Developer proficient in Python, Java, JavaScript, and C#, who has experience in chatbot development, both Front-End and Back-End Development, and API Integration. Ideal Skills: - Proficiency in Python, Java, JavaScript, and C# - Experience in Front-End and Back-End Development - Familiarity with Dialogflow and Microsoft Bot Framework - Strong knowledge in AI, Machine Learning, and NLP - Previous experience in chatbot development Roles and Responsibilities: - Develop and train machine learning models for ...
