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.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

I need a training manual created from a series of PowerPoint sli...Requirements: - Design a moderately detailed cover for the manual that reflects its training purpose. The design should be visually appealing and professional. - The manual should be a clear and easily accessible guide to the training content. - No interactive elements are required. Skills and Experience: - Experience with graphic design, particularly in creating book or manual covers. - Proficiency in Microsoft PowerPoint and the ability to convert slides into a cohesive document. - Understanding of instructional design and the ability to create a logical and user-friendly structure for the manual. The ideal freelancer will be able to translate the content from the slides into a well-designed, print-ready traini...

I'm seeking a skilled PowerPoint designer who can transform two JPEG diagrams into visually engaging PowerPoint slides (Or maybe Microsoft word) The goal is to make presenting information more impactful and striking. I have attached both the images that I require to be update/remade. These are the only copies that I have in png file types. - Modernisation: Though I'd like the new diagrams to reflect a revised color palette as the originals, I am keen for an updated, fresher look to make the overall presentation contemporary. I am also happy to used new/revised people icons. - Simplicity: I do not require any interactive elements like hyperlinks or animations, just a clean, aesthetically pleasing design that can effectively communicate the information. Ideal freelance...

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

Seeking an expert Access Developer to undertake some key aspects of a l...database for our office team. Tasks include: - Database Design and Development: Plan and construct a robust relational database incorporating more than 20 tables. - Form Creation and Customization: Create and customize user-friendly forms for data input and manipulation. - Report Generation and Analysis: Design analytical reports that will aid our decision making. Ideal skills: Proficiency in Microsoft Access, understanding of relational database theory and form design, experience with report generation and analysis. Prior experience working on large-scale databases would be a plus. This project offers a challenge but also a great opportunity for you to showcase your expertise and abilities as an Access ...

...small scale of not more than one hundred websites each day. ******* TESTING ******* You must test your script on Linux Mint 21.3 Cinnamon Edition to ensure that it runs properly on Python 3.10.12, on the current stable version of Google Chrome, on Linux Mint 21.3 Cinnamon Edition. I do not care if your script runs on any other operating systems or any other browsers. If you typically use Microsoft Windows, please consider setting up a virtual machine to install Linux Mint 21.3 Cinnamon Edition so you can test your code properly. In particular, if I were to send you a bug report, I would not like to receive a reply from you like, “The script works 100% perfectly for me on Google Chrome on Windows 11. Because I am a 100% perfect engineer, who always ships code that is 10...

...these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood...

I'm in need of a professional who can assist with a PERT analysis for my project scheduling needs. - The focus of this job is on project scheduling - I would require the PERT analysis to be at a small task level; a detailed task breakdown is not necessary - You will need to integrate the PERT analysis with Microsoft Project This project would be most suitable for a freelancer with: - Proficiency in PERT analysis - Experience with project scheduling - Knowledge of Microsoft Project or similar tools

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ...Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...

...seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repr...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...

I'm looking for a professional who can breathe life into a 20-page Microsoft Word document (no need for you to research, I need just your creativity to adjust the document). Here's what I'm after: • Use of custom fonts for a unique look • Development of a color scheme that permeates the document • Designing an interesting yet professional header and footer and unique cover page On top of this, I need someone with proficiency in inserting tables and graphs into the document, making it more interactive and engaging. The attached document will give you an idea about what I am looking for (DON'T make it as same the attachment, just I need something similar to it) Ideal Skills for this project: Microsoft Word, Graphic Design, Typography. Exp...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

Looking to integrate advanced custom indicators into Pine Editor. Scope: - Creation of 2 complex custom indicators - I have urgent requirement, with a deadline of just 2 days. Ideal freelancer: - Proficiency in integration of advanced mathematical formulas - In-depth knowledge and practical experience with Pine Editor - The ability to work under tight deadlines to deliver high-quality work. This project requires a deep understanding of trading systems and preferably previous experience with similar projects. If you possess these skills and can deliver within the defined timeline, I would like to hear from you.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

...technical Products here in Europe and search a solution for Productbrochure and Productcatalog as PDF output. I have worked before with Microsoft Publisher, but I search a solution for 2 Catalogs. First Catalog with small products and easy products with photos, details, part number, price for automatic publishing via a Excel File and the second Version is a Catalog which i must make with a software manuell/self, because very strong products, which are not possible to create via excel, only a catalog as information and .... have you a easy and good solution for us, that we can change weekly the products because we add every week 10-50 new products in our excel / erp / website and in the brochure than. But we need a easy software which we can edit self very e...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I'm in a project to migrate Windows devices to new Microsoft 365 Tenant. The devices are registered in Intune in the current tenant and users are using their Microsoft work Account to log in to Windows. After I retire the device from Intune Portal (Source Tenant) ...and try to add a new work account (that is the user account in the destination tenant) I got the following error message: "the work or school account couldn't be found. check the account name and try again" The user is signing in successfully to Services like Outlook, OneDrive,

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I'm looking to collaborate with local job providers who can work in Serbian. I've successfully completed a Microsoft course and passed the certification in just two months. I'm particularly interested in working on tasks like document creation and editing in Word, creating and editing Power Point presentations, working with Excel sheets, as well as translation and proofreading in Serbian. Key Responsibilities: - Document creation and editing in Word - Creating and editing Power Point presentations - Working with Excel sheets - Translation and proofreading in Serbian Ideal candidates should have: - Proficiency in Microsoft Office tools - Excellent command of Serbian language - Strong attention to detail - Prior experience in translation and proof...

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I'm looking for a versatile software developer who knows his way around Microsoft Visual Studio. Your task will be programming a Windows application in C#. Key deliverables: 1. Design and create a Windows application; good understanding of data management is a prerequisite. 2. Integration of file management, user authentication, and database functionalities. Skills and Experience: - Proficient in developing Windows applications in C# - Comprehensive understanding of Microsoft Visual Studio - Proven experience in integrating file management, database capabilities, and user authentication into an application. Your application should include your past work portfolio, your relevant experiences, and a detailed proposal for the project. This position demands creativity, t...

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

...easily, link, and deploy across all users. - An active countdown clock feature within the signature. - Compatibility with Microsoft Outlook, our primary email client. Additional Requirements: - While not essential, the ability to track interactions (clicks) on the email signature elements would be a nice to have. Ideal Skills and Experience: - Strong graphic design skills with a portfolio of visually appealing email signature designs. - Proficiency in HTML and CSS for email signature creation. - Experience in incorporating rotating banners and countdown clocks in email signatures. - Familiarity with QR code generation and usage. - Previous work with Microsoft Outlook email signatures is highly desired. - Familiarity with tools for tracking email signature in...

Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I have a Microsoft Word document that I need converted to PDF. The process involves converting the content of the Word doc into a PDF file while preserving all the images within the document. Ideal Skills and Experience: - Proficiency in Microsoft Word and PDF conversion - Attention to detail to maintain original document layout - Experience with image preservation during document conversion - Familiarity with different formatting requirements between Word and PDF

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically...