How to use microsoft excel formulas työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Moi! Etsin 16h takarajalla kykenevää Englanti-Suomi -suomentajaa. Minulla on 1 trellotaulu virtuaalityöpöydällä suomennettavana englannista suomeksi, johon annan kirjautumistiedot, jota ennen lähetän linkin ohjevideoon miten toimia koneella. Macilla Microsoft Remote Desktop toimii, Windowsilla normaali Remote Connection riittää kirjautumiseen. Budjettini on tälle 15€ tuntipalkka. Työpöydällä on ajantrackaussofta jonka kautta maksetaan palkka. Maksan taskista vähintään 50€ vaikka taski veisi vain 2-3h. Jos pystyt tekemään tämän minulle seuraavan 16h sisällä ja haluat taskin, kerro. Laitan sitten 3min kestävän Loom -videon linkin jonka kuvasin...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in breaking down complex information will be favored.
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective customers. Foster lasting relationships to secure repeat business. Educate clients on product benefits and usage. Hustle to meet and exceed sales targets consistently. Provide valuable market insights to improve product offerings. Requirements: A go-getter attitude with a passion for sales. Stellar communication and people skills. Ability to thrive both independently and as part of a team...
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy Bidding! Randhir
I'm in need of a specialist in Microsoft Advertising (formerly Bing Ads) to implement and set up the Universal Event Tracking (UET) tag on my Shopify store. The main aim of this project is to accurately track customer's behaviors, focusing specifically on completed purchases. Ideal Skills and Experience: - Proven experience working with Microsoft Advertising and UET tags. - Comprehensive understanding of Shopify's platform - Strong background in web analytics and tracking customer behaviors. - Practical experience in tracking conversion metrics, specifically for completed purchases.
I need a professional with experience in Power Automate, setting up an automated flow to a SHARED mailbox, saving the files to Dropbox. Potential renaming of these attachments will be an added advantage. Advanced skills with Microsoft 365, Dropbox, and automated flows are imperative for this role.
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
I need a skilled writer who can craft an exceptional resume and cover letter, formatted in Microsoft Word, which aligns my career, work and educational experiences seamlessly. They should be tailored to appeal to hiring managers in the social enterprise sector. Key requirements include: • Experience in HR or recruitment • Strong writing and editing abilities • Proficient in using Microsoft Word • Understanding of the social enterprise world The writer should be able to effectively bridge the gap between my career and educational experiences, making my portfolio attractive to potential employers.
I'm looking for a freelancer who can proficiently create more than 1000 A7 size flashcards from a master Word fi...should include both Word document and PDF formats. - The flashcards should be prepared with the option for double-sided printing. - Ensure to include cut marks on the edges which can be cut away conveniently. - The design of the flashcards should be quite simple, featuring a single color (you can just retain the format it's in now). - See attached document. The front side always starts with a number; the back side always with an "A". Ideal Skills: - Graphic design - Microsoft Word proficiency - PDF creation and editing - Understanding of print design - Automation / data Candidates should have previous experience in similar design projects...
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
...talented and creative graphic designer to restructure and beautify a 160-page Word document I've been working on. Here's a quick overview of the requirements: - Graphic Design Skills: A high proficiency in graphic design is a must, as the project will involve creating minimalist-style infographics and illustrations throughout the text. - Understanding of Minimalist Aesthetics: I'm not going to provide any examples—rather, I'm giving you full creative freedom within the minimalist style. This requires a good understanding and experience within this design field. Show me your creativity! - Proficiency in Microsoft Word: Since the project involves revamping a Word document, being comfortable with this software is crucial. - Attention t...
I am working on a WORD document in Microsoft 365 and require help with adjusting the page numbering format in the header. The task involves changing the existing page numbers to "i, ii, 1, 2, 3, 4, 5,.....". The file is quite sizable, hence requires someone with keen attention to detail who can ensure an efficient and accurate overhaul of the numbering style. Ideal skills and experience: - Proficiency in Microsoft Word particularly Microsoft 365 - Experience in document formatting - Attention to detail - Quick and accurate typing skills. So, if you are organized, detail-oriented, and have extensive experience in using Word 365 software, this job is for you!
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer n...
...over 500 pages that requires retyping to create a fully editable copy. The book was initially typed using Photoshop, making text editing impossible. Here's what I need: - Complete retyping of the entire book in Arabic - No images or graphs need to be replicated; the text is the primary focus. - No proofreading is required. I'm solely needing you to duplicate the text exactly how it is. - A concise Microsoft Word Document that includes the images and text in the pdf. Ideal Skills: - A high level of accuracy and attention to detail - Fluent in Arabic - Fast typing speed - Experience with publishing or pre-publishing processes - Familiarity with translating photoshop documents to text documents. This project requires dedicat...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I am seeking an expert in Google Sheets that is proficient in creating and implementing intermediate level formulas. As a part of the project, you'll be entrusted with the task of creating formulas to pull numeric data from one sheet to another. The formulas will primarily include: - VLOOKUP - COUNTIF The main task you'll frequently be dealing with is pulling matching numeric data from one sheet into another. Though hands-on expertise with VLOOKUP and COUNTIF formulas is crucial, having an understanding of basic data organization will give you an added advantage. In short, I'm looking for someone with: - Intermediate expertise in Google Sheets formulas - Proven experience in managing numerical data - Strong understanding o...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I am currently seeking for a meticulous and professional freelancer capable of handling manual data entry task. The data will be extracted from handwritten notes and must be inputted accurately into a Word documen...seeking for a meticulous and professional freelancer capable of handling manual data entry task. The data will be extracted from handwritten notes and must be inputted accurately into a Word document. Ideal skills and experience: - Proficiency in Microsoft Word with a keen attention to detail - Familiarity with deciphering various handwriting styles - Prior experience in data entry work - An ability to maintain confidentiality as the notes may contain sensitive information. Remember, accuracy is paramount as well as speed. I look forward to recei...
I'm looking for an ex...expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI des...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
As an individual requiring personal assistance with the Etel formula, I have run into some implementation challenges. I'm seeking an advanced expert who can guide me through the implementation process seamlessly. Key resp...implementation issues I'm experiencing with the Etel formula - Provide clear, simple, step-by-step instructions in overcoming these issues and successfully applying the formula Ideal Skills and Experience: - Deep understanding of the Etel formula - Proven experience in teaching or explaining complex mathematical formulas in an understandable manner - High-level problem-solving skills - Adept at troubleshooting and explaining the solutions in a simplified manner. The numbers that are in blue need to be generated automatically when entering ...
I'm looking for a skilled developer with extensive PowerApps and iOS app development experience. The main functionality of the application will be to seamlessly integrate customer data. Key Requirements: - Proficiency with Microsoft PowerApps and iOS app development. - Solid understanding of and experience with data integration. - Demonstrated ability to create customer-related data systems. The freelancer should be able to: - Design and develop a user-friendly iOS app using PowerApps. - Integrate customer data into the PowerApps effectively and methodically. - Ensure the app’s performance and stability. Experience with customer data systems will be highly valued. A successful applicant can deliver a reliable, data-focused PowerApps for iOS.
...With a perpetual commitment to enhancing our client services, we have streamlined our processes to offer comprehensive account management for hosts. As a Customer Support Specialist, you will play a pivotal role in ensuring the smooth functioning of our clients' properties. This role requires individuals with exceptional attention to detail, a collegiate background, proficiency in basic software tools, and the ability to utilize electronic devices effectively. Responsibilities: -Review and rectify any inaccuracies in client property information. -Ensure all property details are up to date and accurately represented on the platform. -Post and advertise client properties on Booking.com. -Utilize our partner marketplace or mobile application t...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors aff...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail....
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...serves to upload and validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User far...
I am seeking a skilled Python developer to spearhead the migration of my company's databases from our local servers to a cloud solution. The specific cloud provider and databases to be migrated were not specified, so I need a professional competent with multiple services such as AWS, GCP, and Microsoft Azure, and with a wide range of databases including MySQL, PostgreSQL, and MongoDB. It's crucial that the freelancer I hire has a clear understanding of high availability, scalability, and data security as these areas were not ruled out as possible requirements during the migration process. Experienced freelancers will know to consider these crucial components as part of the standard database migration strategy to the cloud. Skills and Ex...
...in need of an efficient, experienced professional, to copy type a document for me. The document in question contains simple text, absent of any technical terms, making this task straightforward for those with a strong background in typing tasks. Here's a more detailed breakdown of what I'm looking for: - Skill and Experience: Proficiency in typing, with an excellent grasp of the English language. Previous experience in copy typing is a must. Familiarity with Microsoft Word is also essential. - Task Breakdown: The work involves copy typing from a given document. Clear and accurate typing is vital, with due attention to correct grammar, punctuation, and spelling. - Output Format: The completed transcription should be submitted in a Microsoft Word ...
I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automated dat...
Seeking a highly skilled Network Engineer to effectively handle Infrastructure cleanup, Cloud migration, and Network troubleshooting. Key Tasks: - Clean up our existing network switches and routers. - Manage VM host and streamline all domain names in our infrastructure setup. - Successfully migrate our data from physical servers to cloud platforms; specifically Microsoft Azure and VM Ware. Ideal Skills: - Proven experience in Network Troubleshooting, Network switches, Routers, and VM hosts. - Extensive experience in Cloud Migration, particularly with Microsoft Azure and VM Ware. - Strong ability to handle domain name system complexities. This role requires an expert in systems infrastructure ready for a challenging yet rewarding project.
I'm seeking an organized and diligent virtual assistant who can effectively manage a variety of tasks such as email management, calendar organizing, data entry, and social media handling. The candidate should dedicate 10-20 hours per week to this project. An ideal assistant for this project would possess the following: - Strong proficiency in Microsoft Office Suite and Google Workspace - Excellent time management skills and attention to detail - Ability to work independently and handle various tasks simultaneously - Familiarity with administrative tasks Take on this role if you are detail-oriented, organized, and confident in multitasking in a virtual setting. I will go on more about the job when we talk over a call! Thank you!
I'm in need of a graphic designer who can create a compelling business PowerPoint presentation aimed at potential clients. The successful freelancer will have experience in graphic design in Microsoft Power Point. Key Requirements: - Proven experience in Microsoft PowerPoint - Ability to convey understand concepts in create visually appealing presentation - Deep understanding of how to design presentations from raw text and images The right freelancer will need to demonstrate they can design with the client-audience in mind, ensuring the presentation is persuasive, clear and professional.
I need a qualified developer to produce a mobile application and website (Dashboard template will be provided) that can access data records from my continuously updated local Microsoft SQL Server. Both solutions should allow for real-time data extraction and display. Key Requirements: - Develop a mobile application compatible with the latest smartphones. - Create a responsive website that can be accessed on various devices. - The apps need to accurately access and display data from a Microsoft SQL Server data base. Ideal Skills and Experience: - Proficiency in mobile application development (iOS and Android Operating Systems) - Skilled in web-based programming languages such as HTML, CSS, JavaScript, and PHP. - Strong understanding of database connectivity an...
...experienced WordPress developer to design a 3-4 page consulting website. This includes the necessary pages: a Home page, an About Us page, and a Services page. • Home Page: The Home page will strictly include our latest news or updates, ensuring visitors stay informed about our progress and achievements. • About Us Page: This page will encompass not just our team, but more so the history and mission of our company. Introduction of our individual team members is not necessary for this project. • Services Page: This page will enumerate and explain the consulting services we offer, providing potential clients with a detailed understanding of what we can offer. A Developer with a strong background in Wordpress and a good understanding of UI/UX best practices will ...
...Directory is being implemented primarily to manage user authentication, authorize thousands of users, and provide single sign-on for various applications. I am seeking an expert with extensive experience in Microsoft Azure, particularly in Active Directory. I also require a comprehensive review of our system with specific focus on the following areas: - Identifying potential issues and weaknesses - Enhancing system efficiency and reliability - Scalability assessment and performance optimization Your skills and experience should ideally include: - Advanced knowledge of Azure Active Directory - Proven experience in system review - Expertise in performance optimization - Understanding of security vulnerabilities. Our primary goal for this project is to enhance ou...
...eye for visual design. Technical Skills: Proficient in PHP and Angular or Vue frontend. Experienced with Microsoft SQL Server for database management and Familiar with stored procedures in SQL for database queries Strong understanding of user authentication and authorization (login, validation, management) Adept at CSV file manipulation and validation such as: parsing, data transformation, Aggregation, Joining and Merging, exporting, Find, edit or remove duplicates, Consolidate data, convert data types, clean data, Skilled in error handling and debugging to ensure application stability Experience with UI/UX design principles to create an intuitive user interface Functionality to import and manipulate data from CSV/XLS/XLSX files This role involves buildi...