Vba excel 2016 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...
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.
Viiden blogitekstin kirjoittaminen
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.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
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 have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I'm looking for an expert who can build an interactive excel tracker tailored for Sales, Marketing, and Finance departments. In addition, I need a 30-60-90 days plan template to help with our digital transformation process. Key Responsibilities: - Develop an interactive excel tracker for Sales, Marketing, and Finance departments - Create a 30-60-90 days plan template for our digital transformation - Ensure the tracker is user-friendly and the plan is adaptable to our specific needs Ideal Skills & Experience: - Proven expertise in developing interactive excel trackers - Background in digital transformation is a strong plus - Strong understanding of Sales, Marketing, and Finance processes - Familiarity with creating strategic 30-60-90 days plans - Excellent c...
I require a skilled and detail-oriented freelancer to assist me in organizing electronic corr...relevant to the case. - Data Input: The extracted messages should be input into a spreadsheet and organized by topic/subject. - Spreadsheet Creation: The spreadsheet should include the following fields: Date, Message Content, and Attachments and also print and file all correspondence in date order etc. Ideal Skills and Experience: - Experience in data entry and organization. - Proficiency in using Excel/Spreadsheet software. - Familiarity with legal terminology and document handling (an added advantage). - Excellent attention to detail and organizational skills. More details will be provided to the selected freelancer. Please provide examples of similar projects you've completed in...
I am looking for an experienced Data Analyst who can focus on identifying patterns and making data-driven decisions. I have several types of data to analyze. I require an expert who is versatile and adaptable, capable of handling different types of data sets. I have yet to determine the specific data types to be analyzed. Skills and Experience Required: - Extensive experience in data analysis - Familiarity with various data types - Ability to make data-driven decisions - Expertise in spotting patterns in data sets - Versatility in handling different data sets
I am in urgent need of a professional well versed with Excel Operations to help typify a vast array of data into an Excel sheet. The data includes: - Text - Dates - Numbers A key part of this project involves adhering to specific formatting requirements, which include: - The application of currency formatting - Utilizing bold or italic text when necessary - Highlighting certain cells This is a time-sensitive project that requires immediate attention, therefore the ideal candidate should be able to commence work ASAP. Your experience with Excel, data entry, and attention to detail will be highly beneficial in executing this project.
I'm looking for a freelancer who can download pictures from an excel list that will be provided (see 2 attachments). Following are the specific project requirements: We need those pictures in 2 separate folders (f.e. zip or rar file), one for each excel list. All pictures must be saved with Superaction excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a
I require a professional with proficiency in Data Entry and Excel. Your task will be to type data that includes text, numbers, and dates into an Excel sheet that has more than 500 rows and columns. It's crucial for the selected freelancer to have acute attention to detail, to maintain the accuracy of the data. Experience in dealing with sizable Excel projects will be favored. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Experience in handling large data sets - Strong attention to detail - Good understanding of different data types such as text, numbers, and dates.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I am looking for a professional with expertise in data entry a...conversion of my text-based PDFs into a spreadsheet format. Accuracy is essential in this task. Ideal Skills: • Proficiency in data entry • Experience with converting PDFs to excel or similar formats • Meticulous attention to detail ensuring 100% accuracy Responsibilities: • Convert text-based data from PDFs to spreadsheets error-free • Maintain record consistency, structure, and format during conversion • Verify the converted data for accuracy The successful candidate will have ample experience with data entry and PDF conversion, boasting a track record of impeccable accuracy. Knowledge of spreadsheet software like Excel is a must. Each transaction listed on one line, a templ...
I am in need of an individual to assist in extracting email addresses of all child care centers and compiling them into an Excel spreadsheet. Key project details: - Purpose: The extracted email addresses will be used as part of a contact database. - Usage: The contact database will primarily be used to offer services or products to these child care centers. Ideal skills and experience: - Proficient in data extraction and Excel spreadsheet handling. - Ethical data practices - the extraction must be legal and compliant with GDPR and any other relevant regulations. - Previous experience in email extraction or database creation would be a definite plus. This project will require a keen attention to detail and the ability to ensure accuracy in the data extracted.
I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.
I'm in need of a top-notch data entry freelancer who can accurately input data into Microsoft Excel. Working primarily with text and numeric data, the project simply requires a keen eye for detail, a high level of accuracy, and exceptional Excel skills. It's crucial to note that there will be minimal data cleansing involved - the data should just be entered as it is. This job will suit someone who: * Has proven experience in data entry * Is proficient in using Microsoft Excel * Office365 online documents editing * Can ensure accuracy with minimal supervision * Extreme organised * Perfect English written and spoken.
I need assistance with EXCEL- Working with Multiple Worksheets and Workbooks The task is quite urgent, so I need someone who can start right away and complete the project in a timely manner.
I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )
I need an Excel expert to review and make suggestions for how they would improve a register workbook which I have already created for tracking Quality System Document and Record Control. The register is a template which my quality systems consulting customers use to track procedures, policies, and work instructions, as well as active and archived records. I expect the expert to have a strong understanding of Excel, formulas, functions, and design of excel workbooks so that they look professionally made and are also easy to use (and perhaps also customise if required). The final product should look professional and offer an effortless way to track quality system document controls as well as support the managers and users of the system. Proficiency in Excel and ba...
I need a web-based application that can automate the swapping of tags with data from an Excel sheet. Key Requirements: - The application should be accessible online and be compatible with major browsers. - It should provide an interface where I can upload an Excel sheet with the necessary data. - The application must be able to recognize specific tags in a template and replace them with corresponding data from the Excel sheet. - should work with PDF , Word document - Document / Arrangement Formatting MUST be maintained - Able to export into doc or pdf Experience and Skills Required: - Proficiency in web development, particularly in creating online applications. - Strong experience in working with Excel files and data extraction. - Knowledge of automation techn...
We are currently seeking a highly skilled Senior Web Designer to join our team on a freelance basis, with a potential pathway to full-time employment. Ideal candidates will hav...Key Requirements: Proven experience in designing sophisticated websites at a senior level. Expert knowledge of UX/UI principles, responsive design, and current web technologies. Ability to collaborate closely with our development team to ensure seamless implementation of designs. Strong communication skills and a proven track record of meeting deadlines. This role is suited for individuals who excel in a dynamic, fast-paced setting and are open to transitioning from freelance to a full-time role. We are excited to offer this opportunity to tackle engaging challenges and advance at the cutting edge of web t...
I am seeking an experienced photo editor who can help elevate my personal photos. The tasks required include: - Basic retouching to improve overall image quality. - Background removal to highlight the photo's main subject matter. - Lighting adjustment to amplify the mood of the image. Knowledge of JPEG format is necessary as all images come in this format. ...Knowledge of JPEG format is necessary as all images come in this format. Ideal candidates will have a keen eye for detail and the ability to enhance images in a tasteful manner. A sensitivity to personal photography and an understanding of image composition will also be highly regarded. The aim here is to ensure every image conveys the story beautifully. If this sounds like a project you'd excel in, I would lo...
I'm in need of a professional's help to create static line graphs in Microsoft Excel for scientific data presentations. Ideal Skills and Experience: - Proficiency in using Microsoft Excel to create line graphs - Experience with scientific data visualization - Understanding of best practices in graph creation Additional notes: - The data for the graphs will be provided to you - The graphs are expected to be clear, accurate and visually appealing - Familiarity with scientific terminology is a plus, but not strictly required.
Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.
I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...
I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills
I'm seeking a talented designer who can make a 3D rendering for my rental units. Your tasks will be: - Create a visualization rendering of individual units. The central focus should be the interiors. - Bring the renderings to life with high attention to det...renderings to life with high attention to detail including lighting, textures, and shadows. Ideal skills: - Strong proficiency in 3D modeling and rendering software. - Demonstrable experience in creating high detailed 3D renderings focused on interiors. - Ability to adhere to a specific design brief and create visually appealing and realistic renderings. This project will be a great fit if you excel in creating lifelike 3D representations and have a keen eye for detail. I look forward to seeing your previous work in ...
...Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an excel based GAP analysis of desired Asset Management state vs current, based on Parent Company's expectations and standards. 4. Define a recommended plan for addressing these GAPS in a viable way. The ideal candidate for the project should: - Possess vast experience in IT asset management - Have intricate knowledge of Documentation Process and Workflow diagram - Have proven...
I am looking for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts...research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record in delivering high-quality B2B leads and can assist with these tasks, I'd like to...
My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.
croatian text below (please translate it in your language if necessary) Mi trazimo freelancer-a koji ce definirati i izvesti tendera u Europi za igradnju jedne kuce sa tri stana i 3 PGM u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje p...u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje ponuda te izrada usporedbe cijena prema pojedinačnim poslovima - Sudjelovanje u pregovorima s ponuđačima i izrada prijedloga za ugovaranje - Sudjelovanje pri odabiru izvođača Format predaje: Dokumentacija u excel...
To create a canvas powerapps screens similar to the Excel provided to Florian.
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.
My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?
...developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a reasonable rate. Thank you in advance fo...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is automo...
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
