Vba power query excel 2013 jobs
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
2 excel files with VBA macro as per customer requirement
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm in need of a professional who can help with designing comprehensive power and lighting plans for a commercial building. The project involves: - **Purpose**: The plans will be utilized for a commercial building. - **Scope**: The main focus areas for these plans are a daycare and apartments within the building. - **Equipment**: The plan should account for the use of lighting fixtures and kitchen appliances in the building. The ideal candidate should have: - Experience in designing power and lighting plans for commercial buildings. - Familiarity with codes and standards in commercial building electrical design. - An eye for detail and the ability to incorporate specific area requirements for the daycare and apartments. The lights within the daycare and basement and ...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I am in need of an electrical engineer with a specialization in power systems to help audit and verify the progress of a project in Harare, Zimbabwe. Key Responsibilities: - Audit and verify the quality of workmanship on site. - Ensure that the project is adhering to the stipulated timeline. - Ensure that all work is in compliance with safety regulations. The ideal candidate for this project should possess: - A strong background in electrical engineering, especially in power systems. - Experience in project auditing or verification, particularly in the electrical field. - Familiarity with and adherence to safety regulations within Zimbabwe and the electrical engineering sector. - Excellent communication skills to liaise with the project team and myself efficiently. Please ...
I'm seeking a skilled Power Point designer to craft a visually engaging and creative presentation for a business purpose. The presentation will include text, images, and videos, with a focus on making it interesting and professional to captivate my audience. Key requirements include: - Incorporating a mix of text, images, and videos that are relevant to the business context - Ensuring the design is creative and engaging, rather than overly formal or minimalist - Delivering a polished and professional final product that will help me effectively convey my message to my intended audience Ideal candidates should have: - Proven experience in creating business-focused Power Point presentations - Strong design skills, with a portfolio that demonstrates creativity and engageme...
...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
Looking for a power system expert with dsitribution transformers and Inrush. We are having issue with testing a transformer with high Inrush and we want someone with necessary knowledge on how to remove/handle inrush
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I'm looking for a skilled electrical engineer to help me create medium-scale (industrial) power system drawings, including electrical layouts and details of a switchgear and meter panel. The project requires specific expertise in designing layouts for balanced loads, incorporating both light and heavy machinery. Ideally, you'll have experience within the industrial sector and have a detailed understanding of power systems design for manufacturing environments. Here's what you'll be doing: - Designing electrical layouts - Developing switchgear and meter panel designs - Balancing load distribution between light and heavy machinery Kindly provide examples of previous work when applying.
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
I'm looking for an expert Electronic Engineer with abundant experience in Altium PCBA design. The task centers around the creation of a LM51772 Buck-...to specific requirements. - Output Voltage: Your design must accommodate an output voltage range of 5V - 48V, delivering high efficiency throughout the range. - Maximum Output Current: The design must support a maximum output current of 5A. - PD Type C Output Integration: Complete integration with PD Type C output is a necessity. Ideal candidates should have a sound understanding of power electronics and PCBA design, specifically with Altium. Experience with PD Type C output integration, and broader USB technology is also valuable. To succeed, a strong knowledge base around Buck-Boost Controllers, particularly the LM5...
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
I am seeking an experienced SharePoint developer to create ...both task category and project phase, for easy navigation and maximum efficiency. The significant aspect of this project is not only creating the SharePoint list, but also implementing Power Automate flow for seamless operation. Key Responsibilities: 1. Creation of a new SharePoint site and list 2. Inclusion of team member contact information and task assignments in the SharePoint list 3. Organizing the list by task category and project phase 4. Configuring Power Automate flow for the list Ideal freelancers should demonstrate: * Proficiency in SharePoint and SharePoint Online * Previous experience with Power Automate * Strong understanding of list organization and prioritization * Attention to detail and...
I'm seeking a professional who understands the power of radio advertising to help expand my business. Key Responsibilities: - Develop a comprehensive radio advertising campaign that aligns with the brand and goals of my business - Create engaging and persuasive radio advertisements to attract new customers - Monitor and analyze the effectiveness of the radio campaign to ensure it's meeting set objectives Ideal Skills and Experience: - Proven experience in creating successful radio advertising campaigns - Strong understanding of different radio demographics and how to target them effectively - Excellent copywriting and communication skills - Analytical abilities to track and measure ROI from radio advertising
You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financia...
Unleash the power of AI: create custom AI-powered Flask web appsDo you have a project that requires intelligent automation?I can help you develop custom AI models and seamlessly integrate them into powerful Flask web is what I propose:Tailored AI Solutions: We will work together to understand your needs and create a custom AI model that addresses your specific challenge. (e.g. image recognition, sentiment analysis, predictive modeling)Seamless Flask Integration: I will create a user-friendly Flask web application that uses your AI model, allowing you to interact with its intelligence and options: choose from a range of packages adapted to your budget and the complexity of your project. All packages include basic functionality, with options for advanced
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
Unleash the power of AI: create custom AI-powered Flask web appsDo you have a project that requires intelligent automation?I can help you develop custom AI models and seamlessly integrate them into powerful Flask web is what I propose:Tailored AI Solutions: We will work together to understand your needs and create a custom AI model that addresses your specific challenge. (e.g. image recognition, sentiment analysis, predictive modeling)Seamless Flask Integration: I will create a user-friendly Flask web application that uses your AI model, allowing you to interact with its intelligence and options: choose from a range of packages adapted to your budget and the complexity of your project. All packages include basic functionality, with options for advanced
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
I'm in need of an expert JavaScript game developer to build an engaging, endless runner mobile game themed on a food delivery courier navigating through an urban environment. Key features are: - Character Mechanics: The runner must be able to avoid obstacles, collect power-ups and coins, and swipe left or right to change lanes. - Urban Setting: The game takes place on busy city streets, and should depict a vibrant, setting to enhance engagement. - Integrated Ads: Merchant ads should be integrated into the game as banners on the buildings within the cityscape, to ensure smooth and non-intrusive monetization. Ads will be managed as videos, GIF, or images from the backend. Preferably, you should have prior experience developing endless runner games. A sound understanding of Jav...
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
I am seeking an experienced 3D artist skilled in virtual reality projects for a residential architectural visualization task. The project will involve the creation of a VR architectural visualization for a residential build with a modern aesthetic. Key Requirements: • In-depth knowledge of 3D VR technology...architectural visualization for a residential build with a modern aesthetic. Key Requirements: • In-depth knowledge of 3D VR technology • Proficient in creating VR architectural visualizations • Experience in designing modern residential builds Ideal candidates should have a portfolio of previous work similar to this project. I'm looking for high-quality designs that effectively use the power of VR to create a realistic and immersive view of m...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
...specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financial modeling software - Strong analytical and problem-solving skills - Ability to work independently and meet deadlines Duration and Budget: This mini-project is expected to require approximately 15 to 20 hours. The budget for the task is 200 EUR. How to Apply: Please submit examples of previously created financial models along with your applica...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
As someone who understands the power of social media, I am looking for a freelancer with expertise in developing and executing engaging marketing campaigns specifically on Facebook and Instagram. I need assistance with boosting my business visibility in the age groups of 25-34 and 35-44. Key Responsibilities: • Develop and manage social media marketing campaigns • Target and engage with users aged 25-44 on Facebook and Instagram Ideal skillset: • Vast experience in social media marketing • Excellent knowledge of Facebook and Instagram algorithms • Proven record with target demographics comparable to mine • Understanding of content preference for the target age group Your work will drive the relationship between our brand and audience, so a tactic...
I'm in need of a master in Excel. Your task will include: - Inputting both textual and numerical data into Excel. - The data to be entered is categorized, meaning that you'll need to pay close attention to how and where the data is entered. Ideal candidates have extensive experience with Excel and a sharp eye for detail. Familiarity with categorized data entry is a plus. Please apply if you think you've got these skills.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
We are working on a power converter board and looking for an expert in MCU stm32. We are using the stm32G474ret6 and having several issues that we are not being able to explain . The main issues are : startup state of MCU systick clock for hal_delay non functional Debugger resetting MCU in middle of operation code not stored in memory after powercycle . We are looking for somebody that is very used with stm32 MCU and know about electronic schematics and circuit for mcu integration on PCB .
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content in...multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It prints the original product name, the plural (if found) and the synonym (if found). I am looking for someone to help me create this list. I have the same list in English and French which the same thing needs to be done. Ideal Skills and Experience: - Advanced Excel skills. - Familiarity with implementing plural forms and synonyms. - Ability to ensure data integrity and co...
I am in need of an Excel expert who can assist me with data analysis. The level of complexity I am aiming for is basic sorting and filtering. Crucially, I would like the data analysis to be interactive for users. Key Requirements: - Data analysis in Excel - Proficiency in creating drop-down menus for sorting/filtering - Experience with basic Excel functions and formulas Ideal Skills: - Strong understanding of Excel and its data analysis functions - Ability to create intuitive and user-friendly interfaces with drop-down menus - Excellent communication skills to help with user instructions This project requires someone who can provide a clean, well-structured, and user-friendly Excel file.
Seeking sales enthusiasts ready to make money from the comfort of their homes selling physical products on a full e-commerce platform. Whether you are new to the field or have seasoned experience, join our team to help us broaden our company's online sales. While no experience is required, those with a background or interest in sales could excel in this role, as you will be responsible for maintaining a broad product knowledge of our inventory. Requirements and responsibilities: - Sell a variety of physical products online - Display strong communication skills - Maintain product knowledge - Be reliable and committed Being tech-savvy, having prior experience with eCommerce platforms, or proven sales experience are all a plus but not mandatory. Novices are also welcome to ap...
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.
I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to structure the course. Look...
I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.