Excel power query parameters 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.

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

We are actively searching for a skilled and detail-oriented Meta Ads Specialist to join our team as a key contributor to our digital marketing efforts. In this role, you will play a crucial part in optimizing our online presence through managing Meta Ads campaigns for maximum visibil...campaign click-thru rates, conversion rates, and bid management - Campaign performance against target KPI’s. - Profit margin on campaigns Qualifications: - BA or BS degree in Business, Marketing or related field of study - 3+ years’ managing conversion-focused digital advertising campaigns with ROI related metrics - 2+ years’ of managing Meta ads - Highly proficient in Facebook’s Ads Manager and/or Power editor - Comfortable with A/B testing tools and methods to prove and rep...

My project revolves around creating an effective and engaging sight word tutorial for children aged between five to seven. The tutorial's main output format should be a Word document, making it easily editable and adaptable for future needs. Here's what I'm particularly looking for: - A tutorial for intermediate level sight words, intuitively designed to cater to most young learners' grasping power. - Imitative creativity in developing a sight words list. I don't have one presently, allowing you full room for scholarly discretion. Ideal candidates will have a strong grasp of early childhood education principles, excellent skills in Microsoft Word, and previous experience creating teaching resources. Your ability to present complex information in an easy-to...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

This project requires an expert in Power BI for the main purpose of creating sophisticated and streamlined data visualizations. The data source for this project will be SharePoint, so advanced experience handling and processing data from SharePoint is a must. Key requirements and responsibilities include: - Design and implement charts and graphs for relevant and accurate data representation. - Ensure data visualizations are simplistic yet detailed to engage targeted audience. - Streamline and manage data from SharePoint effectively. - Problem-solving with agility based on data-driven evidence. Skills and experience necessary: - Extensive knowledge in Power BI and SharePoint. - Proven experience designing charts and graphs. - Demonstrated ability to translate data into c...

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...

Looking for a skilled designer experienced in creating minimalistic illustrations for my wellness journals. The journals revolve around various themes like health & fitness, mindfulness, meditation and holistic wellness inspired by yoga and modern science. Key Project Needs: - A...experience with minimalistic design and illustration. - An understanding of wellness concepts, in particular holistic wellness, yoga and mindfulness. - Proven ability to integrate diverse themes into visually cohesive designs. - Attention to detail and an aptitude for conveying complex ideas through illustrations. Please include examples of previous design work, especially any that fall within the parameters of this project. Looking forward to working with an artist who can bring my wellness jou...

Looking for a skilled designer experienced in creating minimalistic illustrations for my wellness journals. The journals revolve around various themes like health & fitness, mindfulness, meditation and holistic wellness inspired by yoga and modern science. Key Project Needs: - A...experience with minimalistic design and illustration. - An understanding of wellness concepts, in particular holistic wellness, yoga and mindfulness. - Proven ability to integrate diverse themes into visually cohesive designs. - Attention to detail and an aptitude for conveying complex ideas through illustrations. Please include examples of previous design work, especially any that fall within the parameters of this project. Looking forward to working with an artist who can bring my wellness jou...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

I'm seeking a digital marketing professional adept at harnessing the power of social media marketing and pay-per-click advertising. Key tasks: - Develop and manage creative marketing strategies on Facebook and Instagram. - Implement PPC campaigns to drive website traffic and generate leads. The ideal candidate should have: - Solid experience in both social media management and PPC advertising. - Proven ability to engage and attract the 18-24 demographic. Your success will be measured by the increase in our audience engagement, jump in website traffic, and ultimately the leads generated.

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

...our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring ou...

As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security...

I'm seeking a skilled Web Developer experienced in WooCommerce who can help me customize the "Add to Cart" functionality on my online store. Due to the lack of specific parameters or features on the project, you should be comfortable with uncertainty, able to think creatively, and approach challenges proactively. Responsibilities may include but are not limited to: - Add multiple size variation in same time - Custom product with module - Add to cart all product in same time

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

...moment. And through this journey, we come to understand the profound beauty of existence. Will you join us in this remarkable and incredible endeavor? Your contribution, no matter how modest, will make a profound difference in Martin's life. Together, let's create a legacy of love that reverberates through generations. Thank you for your kindness, your generosity, and your unwavering belief in the power of love and family. Your support brings us closer to welcoming a precious new life into our hearts, our family, and our home. Together, let's make Martin's dream of fatherhood a beautiful reality....

Access Points setup. Provision (x3 Test Devices) for now using the Software Management Tool. License/Registration only. Possible SSID, Security Settings, Guest/Staff SSIDs and other Wireless parameters if we need anything. The main thing is get them configured locally with the most basic setup and a Client Connection before we proceed to next steps on more devices. Omada Controller and Licenses available to manage the devices. Please only get in touch if you've set these up before. Unfortunately, I don't have enough time to start interviewing people. If you're confident enough then please get in touch. Immediate start.

I'm looking to create a fault detection and current limitation system using MATLAB for power systems with 3 or 14 buses during short circuits. I need the system to: - Detect faults in real-time - Identify fault currents - Suggest or implement mechanisms to limit these currents such as circuit breakers - Ensure system safety and reliability - Provide guidance on how best to limit these fault currents during short circuits.

I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...

I'm in need of a proficient freelancer who can help create new Crystal reports for my SAGE 100 system, focusing on inventory data. Key Responsibilities: - Develop new, insightful inventory-related Crystal reports from scratch, ensuring they seamlessly integrate with the SAGE 100 system. - Implement the necessary filters and parameters within the reports to ensure they are intuitive and user-friendly. Skills and Experience: - Extensive experience with SAGE 100 and Crystal Reports is a must. Please provide examples of your previous work in this area. - Strong understanding of inventory management and the data relevant to this field. - Adept at communication, as I prefer to receive project updates via video calls. This also allows for a more interactive approach, ensuring that ...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

...be a significant plus. - Strong organisational skills: The ability to organise and categorise information in a clear and efficient manner. - Experience with automations using Outlook rules and/or Power Automate and Copilot - strong English language proficiency (Australian English is used locally) This role will require a high level of confidentiality, good communication skills and efficiency as you will be working with me to organise thousands of emails from my last five years of use. Important that you have experience in the use of Outlook rules and familiarity or experience with power automate and CoPilot (365 business version). Responsibilities include setting up rules for email categorisation, creating automated workflows, and ideally working with me as to how ...

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

As the owner of an Ayurvedic beauty wellness company, I'm looking for someone to launch and manage my brand's YouTube channel. The intention is to promote my catalog of herbal products, hence increasing sales while also educating both male and female audiences about their benefits. Here's what I'm looking for: - Experience in launching and managing YouTube c...female audiences with content. - An understanding of YouTube's algorithm and how to optimize our channel and its content for more views and subscriptions. Your ultimate goal will be to harness this platform to boost product sales by ensuring our brand's values and products are effectively communicated. This is an opportunity for someone who is passionate about beauty wellness and believes in the p...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

We are looking for someone who is specialized in building/fine-tunning Openai Whisper mod...or fine tunning models for special dialects. Please provide a clear milestone that illustraate the work procedure. - The purpose of this project is to have full knowledge about building/fune-tunning Openai Whisper models. - The freelancer should be capable of answering and clarifying all the questions/concerns related to selected choice (model details such as number of layers and other model parameters). - The freelancer should be capable of justifying the reasons behind the selection between fine-tunnnig or building a model from scratch based on the required task (audio transcription). - Define all the requirements needed for dataset preparations such as feature normalization, data paddi...

...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

We require an FMEA expert. Our focus is on electrical and mechanical hardware systems like circuit boards, power supply, control systems, and communication systems. Your role requires you to create a detailed questionnaire and out of it to create a comprehensive analysis document for managuing risks. The ideal candidate must posess: - Proven experience conducting multiple FMEA activities in the past 24 months (provide evidence) - Specialised knowledge on electrical/ mechanical hardware analysis - Proficiency in examining circuit boards, power supply units, and control systems Kindly note that those without proof of previous FMEA execution need not apply. We seek someone who can help us entirely avoid or reduce risk. Your proficiency in identifying, analysing, and mitigati...

I'm eager to find an accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated...

I am looking for a skilled developer to implement a feature on my WordPress site. Specifically, users should be redirected to another website once they click the 'Process Order' button. Along with this, certain order details need to be transferred to this redirected site too. The deli...of a redirect action at the 'Process Order' button click, leading users to a different website - Transfer of specific order details to the redirected site. The details to be transferred include the item name, quantity...... and store name Ideal candidates will have experience in WordPress development, and have previously worked on similar redirect functions. Familiarity with transferring site parameters is also preferable. The developer must ensure the proper functioning and secu...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.