Excel automating pivot tablesJobs
...produktfeed-import til Excel via Make Projektbeskrivelse: Vi er på udkig efter en dygtig freelancer med erfaring i automatisering og databehandling, som kan hjælpe os med at automatisere importen af forskellige produktfeeds fra flere leverandører direkte ind i et Excel-ark ved brug af automatiseringstjenesten Make (tidligere Integromat). Opgaver: Opsætning i Make: Opsætte automatiserede workflows i Make, der importerer produkter baseret på specifikke EAN numre fra en liste, vi har tilgængelig i en særskilt fane i Excel-arket. Dataselektion: Sikre, at kun produkter, der matcher EAN-numrene på vores liste, bliver importeret. Dataimport: Automatisk import af følgende produktdetaljer til Excel: ...
Hej, Jeg har behov for en Expert, som kan udvikle en kalender for mig. Jeg har et rengøringsselskab, hvor vi få udleveret et kalender fra vores kunder. Alle kunder har forskellige fridag, men de fleste har helligedage som lukkede også er der enkelte der har ekstra feriedage, så de skal også indtastes. Herudover vil jeg indtaste, hvor menge timer medarbejderne har enkelte dage, så jeg kan beregne hvor timer der skal udbetales. Eksempelsvis har en kunde 20 arbejdsdage, hvor medarbejderen arbejder dagligt 10 timer, så i alt skal der udbetales 200timers løn.
I have an invoice template, i need to add a second page to it that have instead of the columns Beskrivning Antal Enhet à pris Moms Moms kr Belopp should have 10 columns. I have attached the invoice template. So i need a second description page to this template.
Design or formulate the financial analysis for a self storage project in order to ascertain its viability.
Jeg har brug for en ny hjemmeside Bare bygge den Internetbutik Skal sælge gavekort på min webshop på shopify og have betalingsmodul fra pensopay på samt 4 API opkoplinger diverse social media integration samt adwords og trustpilot, Excel fil fra bestilling skal sendes til produktionssted
Jeg skal ha lavet et database program hvor jeg kan indføre forskellige data hver dag. Skal helst kunne køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og væ...køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og være meget nemt at gå til Der skal være en backend, hvor man selv kan tilføje og rette i de ting der skal indtastes. Der skal ikke være begrænsninger for hvor mange indtastninger man kan lave Alt skal kunne konverteres og udskrives i pdf ...
Skal have lavet en opgave i Regnskab. Skal laves på excel.
Indtastning af ordre - faktura - følgesedler - indkøbsordre. Lave pivot, så tingene kører automatisk.
På side 1. (ark – ’kontobevægelser’) er der i kolonne D indsat beløb (kr.), - pkt. C Værdien i pkt. C (side 1) ønskes overført til pkt. C (side 2) - arket ’2017’. Der skal indsættes en formel i pkt. C, arket ’2017’ (side 2) som overfører værdien fra pkt. C (side 1) til pkt. C (side 2). Dette gøres ved: • Det aktuelle ark som værdien i pkt. C (side 1) skal overføres til findes ud fra datoen i pkt. B (side 1). Værdier fra kalenderår 2017 overføres til arket ’2017’. Værdier fra øvrige kalenderår eksporteres til de respektive ark/kalenderår. Dvs. værdier for kalenderåret 2016 indsættes i ark &r...
Vi har brug for hjælp til at opbygge i MS Excel rapport, som via Jetreport henter debitor / salgs data fra Microsoft Dynamics NAV 2009 R2 - SQL database.
Hej, Jeg leder efter nogen til at løse et par matematikopgaver. Opgaverne er vedhæftet og mit budget fremgår af dette projekt. Opgaverne skal løses i et regneark (gerne Microsoft Excel). Deadline er 5 dage efter projektet er uddelt. Se nedenstående vedhæftninger.
Hej, jeg søger en som kan lave et design til et træningsprogram. Jeg har et design som I kan gå udfra, når I kontakter mig på mail. Håber i kan hjælpe. Mvh. Martin Nielsen
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
project for dangersystem dangersystem dangersystem
Jeg har vedblivende arbejde relateret til vores tidligere projekt 'Application that can upload excel sheet to sql table'
Solve excel problem using excel solver
Jeg skal lave en prissammenligningsside. Jeg har samlet alle priser hos en forhandler og skal nu have fundet de samme produkter hos andre forhandlere. Jeg har lavet et excel ark hvor jeg liste alle URLs til den primære forhandler. Det er så jeres opgave at gå ind og finde det tilsvarende produkt hos de andre forhandlere og indsætte links i Excel arket. For at produkterne er de samme skal I tjekke at billedet er ens. Hvis I ikke kan finde det pågældende produkt skal der bare skrives 0 i cellen. Se vedhæftede fil for hvordan templaten ser ud. Det drejer sig cirka om 1000 produkter og 10 forhandlere, der skal tjekkes
Jeg har vedvarende arbejde relateret til vores tidligere projekt ' Looking for a user-interface for Excel'
Take excel spreadsheet & upload via talend to REST service. Might have to work via multiple sheets. Rory to pass on details.
I need an advanced Excel wizard to craft a spreadsheet consisting of 1-5 sheets handling participant demographic data. The spreadsheet must be capable of: - Data Analysis: Analyzing and interpreting patterns for more effective decisions. - Automated Calculations: Creating mathematical formulas to execute automatic calculations. - Conditional Formatting: Highlighting specific data points based on pre-set conditions. Preferred attributes: - Strong analytical skills - Proven experience in Excel - Data interpretation ability - Solid understanding of data privacy standards. Also instructions on how can I replicate what was done, so I can be prepared to answer any questions needed. There are two spreadsheets one for asmp and one for SIR. I don’t need complex things done.
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
...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...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
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 ...
...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. Experience in similar projects is a big plus. Unique fonts ...
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
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...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
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...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The par...VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering principles. The efficiency and accuracy of the VBA code will be crucial in ensuring the successful automation of...
I'm in need of an experienced individual who can assist me in creating a system to prefill application forms on a website. Here are the specifics: - You'll be working on automating the prefilling of the application forms. The form type in question are specifically application forms. - The prefilled information will be sourced from user inputs on a previous page. This is essential for seamless user experience. Ideal candidates for this project will have: - Proficiency in web development and form automation - Experience in working with application forms prefills - A keen attention to detail for accuracy in prefilling - Excellent problem solving skills to address any unforeseen issues Please reach out if you're confident in your abilities to deliver on this project.
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
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...
