Generate automatic graphs excel macro 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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for an Excel expert to create a mark sheet for me. This mark sheet will be used to record student test scores and will automatically assign grades based on a custom scale I've provided. The sheet should have: - A column for Student Name - A column for Test Score - A column for Grade (to be calculated based on the score and the custom scale) The grade allocation should be as follows: - Score of 1: Grade E - Score of 2: Grade D - Score of 3: Grade C - Score of 4: Grade B - Score of 5: Grade A I do not require any additional calculations to be performed beyond the grade allocation based on the score. Ideal Skills: - Proficiency in Excel - Experience in creating automated grading systems - Background in academic assessment would be a plus Please let m...
I'm seeking a proficient Excel expert to create an interactive mark sheet specifically designed for student use. Key Features: - Implementation of essential calculation formulas: This will include automated calculations for grades, averages, and other relevant metrics. Delivery: - The final sheet is expected to be shared through a link to an online version that can be edited. This will ensure easy access for students and real-time updates as needed. Ideal Candidate: - Proficient in Excel and experienced in creating interactive and user-friendly sheets. - Knowledgeable about education-related metrics and formulas. - Ability to deliver a reliable online version for easy access and editing. Please note that the primary users of this mark sheet will be students, so sim...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
...skilled web developer to create a fully interactive website for a university project. Key Features: - Discussion Forums: The website should have a user-friendly and secure discussion forum feature where students can interact with one another, engage in academic discussions, and receive support. - Online Quizzes: The platform needs to offer online quizzes. This includes a user-friendly interface, automatic grading, and a progress tracking system for students. Target Audience: The main users of this website will be students. The website should be appealing and engaging to this demographic. Ideal Skills: - Proficient in web development with experience in creating interactive websites. - Knowledge of discussion forum and online quiz functionalities. - Prior experience in creating...
...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...
I'm in need of a thorough and reliable freelancer who can assist me with typing 1-5 columns of text-based data into an Excel sheet. Data will be provided in a digital format, like PDF or Word. Key Requirements: - Proficiency in Excel: You should be well-versed in using Excel, particularly in data entry tasks. - Accuracy: Attention to detail is crucial as any errors could affect the quality and integrity of the data. - Typing Speed: A fast and accurate typist will be highly preferred to get the task done efficiently. - Reliability: I'm looking for someone who can commit to delivering the work on time, as per the agreed-upon schedule. Please note that this project will be an ongoing one, with the possibility of more work if this initial task is completed succ...
I am a jazz singer, and I'm looking for a digital marketing expert to boost my online presence and generate leads. This ad is for a 6-month project plan and management. Specifically targeting the audience; - Engaged couples (wedding booking) - Those searching for occasion events (birthdays, corporate event booking) - Eateries, bars, restaurants Geographically based - Shropshire, Cheshire, Staffordshire, Greater Manchester, Yorkshire, other areas in Central England. Looking for the following services; - Social Management (FB, Insta, TikTok) posting, optimising for audience & geography - Content direction - for socials. A plan here and I can film what's needed - Paid Ads on Socials/Google (FB, Insta, TikTok, Google Ads) - SEO The overall goal = Lead Generation &a...
I'm looking for a PyG expert to help me predict links in my e-commerce heterogeneous graphs. The main goal of the project is to predict links in the e-commerce data graphs. This task is essential for understanding and predicting customer behavior in my online store, which is crucial for improving services and increasing sales. Ideal skills and experience for the job include: - Expert proficiency in PyG (PyTorch Geometric) - Prior experience with link prediction on heterogeneous graphs - Strong understanding of e-commerce data and its characteristics Your role in the project will involve working closely with the e-commerce data, understanding the underlying patterns and relationships, and building a robust link prediction model that can be utilized to make in...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I am looking for a talented content producer to craft diverse content for Facebook and Instagram. You ideally have experience in generating text-based posts, image-based content, and video content with a focus to increase brand awareness, generate leads, and drive sales. Key requirements: - Expertise in content creation for Facebook and Instagram - Proven ability to create text, image, and video content - Able to produce creative content that boosts brand visibility, lead generation, and sales - Strong knowledge of social media marketing strategies.
I am seeking an AI-proficient freelancer. This document has the AI prompts which I'm trying to optimise. Features I am seeking: - Combine multiple AI prompts into a single prompt & it should generate the desired output. (OR) - Find an AI tool which can provide long responses. Presently , I have to repeat prompts in STEP 3: Get subtopics, STEP 4 Multiple times for each topic in the curriculum generated from step 1. EG: Instead I am looking for a tool or a prompt Which reduces the manual effort.
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.
I'm looking to leverage Facebook's advertising platform to monetize my video content and remove restrictions. The primary purpose of this project is to generate revenue through displaying ads on my videos. Key Requirements: - Experience with Facebook ad management, especially in the context of video content monetization - Understanding of the Facebook ad policies and guidelines - Ability to target and engage with the adult audience (25-54) effectively Ideal Skills and Experience: - Proven track record of successfully implementing Facebook ad monetization strategies - Proficient in creating engaging video content - Understanding of audience segmentation and targeting on Facebook - Strong knowledge of digital marketing and social media trends Please provide examples of s...
I am in need of a talented and experienced content writer to generate professional blog articles that delve into the realm of technology. Key Requirements: - Understanding and capacity to write detailed blog content on various aspects of technology. Creativity when it comes to making complex tech-related topics engaging for a wide audience is central to this project. - Ability to adhere to a professional tone of voice throughout all blog articles. Desired Skills and Experience: - Proven track record in writing about technology. - Strong ability to write in a professional tone. - Fluency in English and excellent proofreading skills. This project requires the combination of technical understanding and exemplary writing skills to create informative, professional, and engaging...
I'm in need of a talented email marketer to help me create an engaging email sales pitch. The goal is to generate leads among business professionals. Key Responsibilities: 1. Crafting a strong subject line that captures attention and encourages opening. 2. Writing a compelling, conversational email body that drives interest. 3. Ensuring the email is not only engaging but also persuasive. Skills and Experience: - Proven track record in email marketing, particularly in lead generation. - Excellent copywriting skills with the ability to adapt tone as needed. - Understanding of best practices for email marketing in B2B contexts. - Knowledge and experience of A/B testing methods will be a plus.
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I'm seeking a Google Ads Expert, specialising in PPC campaigns to generate high-quality leads. My main focus is on targeting UK customers. Your responsibilities: - Setup, manage, and optimise our Google Ads. - Develop strategies to increase high-quality leads and ROI. Ideal Freelancer: - Proven experience in similar projects. - Understand UK market. - Certified Google Ads Professional. - Strong understanding of lead generation strategies. This role isn't just about getting more site traffic; it's about gaining high-quality leads. Your experience and skills matter as much as your strategy. Note: This is long term project, if project will success.
I'm in need of an experienced telemarketer and lead generator to...Generating leads and setting appointments for further negotiation - Managing data and documenting sales prospects Your Skills: - Proven experience in telemarketing and lead generation - Excellent communication and negotiation skills - Familiarity with the home textiles industry - Ability to maintain a positive attitude in a high-pressure environment. I'm looking for someone who is not only able to generate leads, but also has the ability to close deals. The ideal candidate will be comfortable working with targets and deadlines, and have a dynamic, results-oriented approach. Experience with export-oriented telemarketing or the home textiles industry is an added advantage. Please share any relevant exper...
I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry is highly preferred....
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
...Overlay: Brief instructions on how the tarot reading process works. - User Input: Users begin by typing a personal question they seek guidance for. - Card Selection: Users will select a tarot card from a virtual deck rendered in 3D. - API Integration: Once a card is selected, the app will use an API to connect with ChatGPT. Based on the card selected and the user’s question, ChatGPT will generate a personalized reading. - Result Display: The reading will be displayed to the user, providing insight based on the chosen tarot card. - Deck Selection: Premium users can choose from various deck designs before making a question. - Multiple Reading Masters: Premium Users can choose their preferred reading master from three options: a default master, a romantic mas...
I'm looking for an experienced SEO expert to help improve my website's visibility, increase traffic, and generate more leads and sales. I'm open to different types of SEO approaches, including on-page, off-page, and technical SEO. Ideal skills and experience: - Proven track record in SEO with a focus on improving website traffic, search engine rankings, and lead/sales generation. - Extensive experience in on-page, off-page, and technical SEO implementation. - Ability to provide a detailed project proposal outlining how they can achieve the desired results. Please avoid generic applications and instead, provide a detailed plan on how you would tackle this project.
I'm in need of a skilled social media expert to manage and optimize a Facebook and Instagram advertising campaign to work with me on a contract basis , if shown exceptional work, we will be hiring too. Key Responsibilities: - Set up and manage ad campaigns across Facebook and Instagram - Generate leads through the campaign - Monitor campaign performance, optimize and tweak as necessary Ideal Skills and Experience: - Proven track record in managing successful Facebook and Instagram ad campaigns - Demonstrate expertise in the lead generation domain - Ability to analyze data and make data-driven decisions - Understanding of audience segmentation and targeting Please submit your proposal if you have the necessary skills and experience to help me achieve my marketing objectives ...
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough unders...
Job Description: We are seeking a motivated and results-driven individual to join our team as a Social Media Sales Representative. As a commission-based role, you will be responsible for reaching out to potential clients on Instagram and securing orders for our social media services. Your primary goal will be to generate leads, build relationships, and close deals. Responsibilities: 1. Identify and reach out to potential clients on Instagram who may benefit from our social media services. 2. Present our services in a compelling manner to effectively communicate the value proposition. 3. Build and maintain strong relationships with clients to foster repeat business and referrals. 4. Negotiate pricing and terms to close sales and achieve revenue targets. 5. Provide excellent custom...
...determine the most effective elements for maximizing viewer attraction and retention. 4. Extend analytics review and optimization strategies to other digital platforms where video content is shared, ensuring a cohesive and effective cross-platform presence. 5. Collaborate with content creators and the marketing team to suggest content adjustments or enhancements based on analytics insights. 6. Generate regular reports on analytics trends, optimization efforts, and the performance impact of implemented strategies, providing actionable insights and recommendations for future content development. Qualifications: 1. Proven experience in digital content analytics, with a strong emphasis on YouTube analytics. 2. Familiarity with YouTube's content policies, SEO strategies, and an...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
I'm looking for an innovative and creative content creator to help generate videos for my YouTube channel. The content will primarily focus on funny animal-related themes for children, teens and adults - Content type: The creator should be capable of making vlogs, tutorials, and comedy sketches focusing on humorous scenarios or facts around animals. - Main Channel Theme: The theme of the channel is Funny Animals. Any content developed should align with this central theme and be suitable for children. - Target Audience: The content should be engaging, fun, edutaining (educational + entertaining), and suitable for children. Ideal skills and experience: - Experience in content creation, specifically for YouTube. - Demonstrable knowledge in creating kid-friendly content. - Fa...
I need a professional to generate leads in the field of recruitment. The main focus is on telemarketing positions. - Industry: Recruitment - Specific roles: Telemarketing - Geographical targeting: Poland The ideal candidate should have dome experience in lead generation or sales customer services related , particularly for telemarketing roles. Additionally, knowledge of the specified region and its market would be an advantage. A broad understanding of the recruitment sector as a whole would also be beneficial. Those without a direct experience but having passion to learn and perform may also apply.
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I am looking for a skilled social media manager for my project. This project requires attention to three major social media platforms: Facebook, Instagram and Twitter. Even though I have not specified the main goal, you should have the ability to drive brand awareness, website traffic and generate leads, as the ultimate goal is to significantly boost our online presence. Ideal Skills: - Social media management - Branding - Website traffic growth - Lead generation Even though I haven't provided a strict timeline, you should be able to manage your time efficiently and deliver high-quality work within a reasonable timeframe. Good communication is also paramount, so please keep in touch and provide regular updates on the project's progress. Please ensure to include past ...
I am looking for a telemarketing expert to help me with a B2B telemarketing campaign. The ideal candidate will have experience in B2B telemarketing and be able to effectively communicate product information to potential clients.(Greek Language is mandatory) Key points to be communicated in the telemarketing call include product information. The goal of the campaign is to generate leads and promote our products to potential business clients. I have a rough script that needs polishing, so the candidate should be able to review and refine the script to ensure it is effective in conveying the key points and generating interest in our products. Skills and experience required: - Strong telemarketing skills, particularly in B2B settings - Excellent communication skills and ability to ef...
