Convert excel sql select jobs

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I need a C# .NET programmer to integrate UPS API functionalities into an existing .NET website. UPS is switching over from their current API to OAUTH 2.0. Everything works as it should now, but in June the current API will...The core of the project is implementing UPS API functionalities. You will need to handle package tracking, calculate shipping rates, and create shipments through the UPS API with OAUTH 2.0 Ideally, you should have experience with C# and .NET, as well as UPS API integration. Previous work with this is ideal and would like to see examples. I will provide the Visual Studio project as well as a MS SQL database for you to test with locally. I also have the keys that will be needed from UPS. If you're confident in your ability to handle this project, pleas...

I am seeking a proficient web scraper to extract specific data from The data I need includes venue details and contact information. I require the end product to be delivered as a well-organised Excel file. Key aspects to focus on: * Meticulous detail on venue data * Comprehensive contact information * High level data formatting skills The ideal candidate has demonstrated experience in web scraping, data management and Excel. A background in music or event-based data is a plus. Efficiency, precision and respect for the source website's terms of service are crucial for this project.

I’m in need of an Excel specialist who is adept at enhancing operational efficiency through the automation of repetitive tasks, namely the creation of reports utilizing sales and operational data. Key Requirements: - Creating a system for report generation on Excel, extracting key insights from extensive datasets. - Reports should conveniently display revenue, profit margins, sales growth, as well as production metrics and efficiency metrics. Ideal skills: - Proficiency in Excel and data analysis - Experience with big data and automating report generation - Strong attention to detail and the ability to make data actionable.

Description: We are seeking a talented freelance writer...requirements for the list. Requirements: Proven experience in researching, content writing, and data entry, preferably in a business or professional setting. Excellent attention to detail and accuracy in data collection and entry. Strong organizational skills with the ability to manage multiple tasks and deadlines effectively. Proficiency in using online research tools, databases, and Microsoft Excel or Google Sheets. Exceptional written communication skills with the ability to craft clear and compelling content. Preferred Qualifications: Previous experience working in business consulting or a related industry. Familiarity with CRM systems or other data management software. Knowledge of business terminology and industries i...

Hello, I have a set of data of various roadways and their extents in excel each with the following primary fields (as well as other fields but not pertinent to this): Roadway Name, Roadway From, Roadway To (For example Name: Mission Avenue / From: Main Street / To: Broadway). I also have a larger polyine shapefile with the same fields as the excel however, the excel From and To extend beyond a single polyine in the shapefile. For Example in the excel the fields would say: Name: Mission Avenue / From: Main Street / To: Broadway In the Shapefile this would encompass multiple segments (ie multiple rows of data) for example: Name: Mission Avenue / From: Main Street / To: 1st Ave , Mission Avenue / From: 1st Ave / To: 2nd St, Name: Mission Avenue / From: 2nd St ...

...Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). We need fast, accurate and specialized members. It is mandatory to pass a short trial test / finish a task, that could last between 2-4 hours, with the possibility of extension to up to 1 week, if the candidate is involved in other projects, or not available to start immediately....

...to create a comprehensive and highly interactive dashboard that will help track and analyze market data more efficiently. It is important that the dashboard connects to Excel spreadsheets and other Power BI resources to provide an all-round perspective of the metrics. Ideal skills and experience: - Proficient in Power BI - Excellent knowledge of Excel - Deep understanding of retail market data analysis - Excellent in crunching and interpreting numbers - Strong attention to detail Responsibilities: - Gather and interpret market data - Create a user-friendly and highly interactive dashboard - Connect the dashboard to Excel spreadsheets and Power BI resources - Regularly update the dashboard with relevant market data - Identify trends and patterns based on the data...

I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.

I'm seeking a skilled developer to convert the existing FFMpeg code I have to be used in Python Currently my FFMpeg is in Java for Android, but I need it for to FFMpeg with Python. The primary reason for this conversion is to enable additional functionality. The Python version of FFMpeg will be primarily used on Linux. The major task would be integrating an overlay drawtext functionality, which is capable of displaying both dynamic timestamps and user input text. In summary, the key components of the project include: Here is the Java code we're using and it works. But we need to use this code in python - Converting FFMpeg from Java to Python for use on Linux - Implementing overlay drawtext with dynamic

I am seeking a skilled professional who can help me convert a Google Sheet data file into a JSON schema. This project has a dual objective: to enable data integration with other systems, and to enhance data accessibility. To provide a sense of scale, the Google Sheet data file consists of 25-35 parameters (Columns) for 950 different items (Rows). Key Requirements: - Although there are 2-5 sheets (tabs) in the Google Sheet file, I believe only one (with the scale described above) may need to be converted. - I am not sure about the exact JSON structure needed for the output. Therefore, I'm looking for a freelancer who can provide guidance on this and deliver a structure that suits the purpose of the data integration and accessibility. Ideal Skills and Experience: - Proficiency ...

... and their ability to use software in the Web3 world, which is currently completely unavailable. Key requirements: - Experience with successful Indiegogo or Kickstarter campaigns, preferably in the social cause space. You must be able to point me to at least one successfully completed campaign you have been involved in and describe your role in it. - Strong understanding of how to engage and convert the general public into backers - Ability to craft compelling video content, image and graphics, and written stories that resonate with a wide audience - Proficiency with digital marketing and social media strategies to drive traffic to the campaign Ideal freelancer will be able to: - Strategize and structure the campaign for maximum impact - Create high-quality, engaging multimedia...

I'm seeking an artist with a knack for digital painting to create a portrait for me. The goal is to transform a particular photo into an Impressionist style artwork. Key Point...this style is essential. - It is important to create a realistic looking portrait. Ideal Skills and Experience: - Proficiency in digital painting, ideally with a portfolio showcasing similar work. - Prior experience working in an Impressionist style. - Attention to detail and the ability to capture the essence of a photo in a painting. - Strong understanding of color theory, as you may need to select a color palette that complements the impressionist style. If you're confident in your digital painting skills and your ability to create an Impressionist artwork, I'd love to see your portfol...

I'm looking for an experienced coder to convert MATLAB code into Octave code. And also Build it into a exe file

I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.

I need a professional lead generation specialist to help me target the dental industry, specifically focusing on dental implants and orthodontics...verified and up to date. Target: 10k leads. Fixed price. Keywords will be provided in communications. Ideal candidates should have: - Proven experience in lead generation, especially in the dental industry - Strong understanding of online marketing and lead generation tactics - Ability to target and generate leads internationally - Excellent communication skills to effectively follow up and convert leads - A track record of delivering high-quality leads to increase business revenue If you have a successful history of generating leads in the dental field and you can help me tap into the international market, I'd like to...

I need an experienced developer who can modify a TypeScript code from Github in order to suit our website's requirements. This initiative is fueled by SEO needs, and your tasks will specifically involve: - Mastery in TypeSc...fueled by SEO needs, and your tasks will specifically involve: - Mastery in TypeScript as you'll be working with pre-existing TypeScript code. - Updating the code to include meta tags, as recommended by our SEO team. It's important that your skills include intimate knowledge of SEO principles, specifically in the context of meta tags. - Application of this update on every page of our site, not just select pages. Your ability to understand and apply SEO concepts to programming is integral, as is your proficiency in TypeScript. Quick, value-dri...

I require a skilled freelance developer experienced in JavaScript coding. The project is to create a simple drop down box where you pick a starting end ending month. You return an average monthly rent based on a simple calculation. Key aspects of the job: - Capability to select a move-in month . - Capability to select a move-out month. - An interface where a box displays the monthly average. Specific project requirements: Must provide us with the code fragment that we can embed in an existing Wix landing page. This is a simple project that should only take a few hours. We are looking to have this completed in 24 - 48 hours. This is not a full site or page. This is just some code to create to add to a Wix page. When all is done we will want you to help integrate the code i...

I'm in need of a professional who can accurately convert my PDF logo into a DWG or DXF file, without compromising the logo's details and elements. This is aimed at using the file with AutoCAD design software and implementing it on an injection moulding tool. Key Requirements: - Logo file conversion from PDF to DWG or DXF - Must retain high level precision and every detail of the logo in the converted file - The resulting AutoCAD file should be both viewable and editable Ideal Skills: - Expertise in AutoCAD software and File Conversion - Strong attention to detail - Proficient in digital design, specifically logos - Familiarity with injection moulding tool designs is a plus

Convert the provided PDF file into MS Word format

I am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel. - Ability to understand and...

I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial...

I need help with Excel It is advance level so please be careful when you apply. Thanks.

I'm in need of an expert to help me with a critical issue I'm facing on my WordPress site. - The problem I'm experiencing is that the drop down selections, particularly the Category drop down and the work availability drop downs, are not saving after a few days. This is causing inconveniences as users have to re-select their choices repeatedly. The ideal freelancer for this project should: - Have a strong understanding of WordPress and how it stores and retrieves data. - Be proficient in debugging and resolving issues with WordPress widgets. - Have experience in working with Category Widget, Dropdown Widget, and Custom Widget in WordPress. I'm looking for a professional who can quickly identify the root cause of the problem and provide a permanent solution to ...

Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.

As an individual seeking to promote my unique message, I'm in need for an HTML expert to help convert my design into RESPONSIVE HTML page (TEXT inputs). The successful bidder should have experience in crafting such emails and be adept at blending text, images, and clickable links to optimize engagement. Key requirements: - The ability to translate my custom design into a HTML email message. - Exceptional skills in HTML, CSS, and responsive email design. - Strong understanding of email client compatibility issues and ways to work around them. - Experience in copywriting or visual communication is a plus, as you'll need to integrate text, images, and links into the design cohesively. ** FINAL DESIGN ATTACHED DELIVERY - VERY URGENT Delivery model: HTML CODE I ...

...that's used by 25-30 employees. Each employee has an individual login and there are several pages containing dropdown boxes with different work shift options. I need a developer to implement a system where the selections in these dropdown boxes will save for each employee until they are manually changed again. This is a critical feature since it will save time for the employees by not having to re-select their work shift every time they log in. Key requirements: - Implement a mechanism to save the dropdown selections for each employee individually. - Ensure that the saved selections remain intact until the employee changes them manually. The ideal developer for this project should have: - Proven experience in developing user-specific features in web applications - Prof...

Hi Do you have experience with both mulesoft and salesforce? It iş sql and salesforce integration using mulesoft For now my task is to solve this error so let see how many hours it takes us and for the new project we will discuss the time per week I need indian time tomorrow morning 7:30 am This support will be on zoom meeting which we will provide u and u will connect with my consultant for support

I need someone to convert 16 pages of printed text into a Word document. Skill in typing and attention to detail is a requirement as accuracy is paramount for the success of this project. The final document should be in plain text without any formatting requirements, just a straight forward transcription. Ideal candidate will have demonstrable experience in similar projects. Your task will include: - Typing of printed text verbatim without any errors - Providing the final document in Word format Experience with transcription projects or data entry will be highly appreciated.

Extract the industry data from the IBIS reports and populate the Excel template

Implementation of checkboxes is required in all filters, allowing the user to select and deselect options according to their preference. Additionally, a 'Clear Filters' button is needed that resets all filters to their original state.

I have a whiteboard diagram that I've used for explaining market ecosystem and a few slides. I need to have this converted into a digital format, ideally usable on Powerpoint or Canva later. Key Requirements: - Conversion: The primary task is to convert the existing whiteboard diagram into a digital format. - Create matching deck format to match logo colors etc. - Usability: The digital presentation should be user-friendly and easily navigable. - Timeliness: I need this task completed ASAP. Additional Notes: - I do not require interactive elements as a priority. However, if they can be added without compromising the usability, I can consider this option. - The digital presentation should be suitable for the purpose of information sharing or reporting.

I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal freelancer ...

I'm in need of a skilled Flutter developer to swiftly convert my 6-10 screen Figma designs into a mobile application. The project is on a tight deadline, with completion expected within a week. Key Requirements: - Proficient in Flutter: It's crucial that you have a strong working knowledge of Flutter. Previous experience in developing mobile applications using this framework is a must. - Figma Expertise: You should be proficient in extracting design assets from Figma and implementing them accurately in the app. - Time Management: This is an urgent project, so excellent time management skills and the ability to work efficiently under pressure are essential. The successful candidate will have a keen eye for detail and be able to deliver high-quality work within the given t...

Looking to convert a Laravel PHP CRM into a multi tenant SAAS system to onboard multiple clients at single instalation with subscription plans and billing. Demo of the CRM at E-Mail Address: admin@ Password: concord-demo More details on the requirements and onboard flow is aa follow 1. Create a landing page in WordPress to show subscription packages and registration/login page 2. On Registration page, need add all customer and business related details along with subdomain. 3. On Registration client is taken to on-boarding screen/loading screen , during the time his instance is getting ready/setup 4. Each new customer/tenant will have a seperate database ( preferred) to isolate the daata from each other. Single database multi tenant also can

I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.

I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the daily updates. I am o...

I'm looking for a talented animator who can take a simple splash screen designed in Figma and convert it to an animated Lottie JSON file. This animation will be used in a mobile app, and it should be engaging, appealing, and have a smooth transition. Key Requirements: - Transforming a simple Figma splash screen into a Lottie JSON file - Ensuring the animation is optimized for mobile app use - Delivering a final product that requires no user interaction Ideal Skills and Experience: - Proficiency in Figma for asset extraction and animation design - Experience in creating Lottie JSON files - Familiarity with mobile app animation guidelines and best practices - Strong attention to detail to ensure the animation is visually appealing and seamless. Please include examples of your ...

I'm looking for a professional who can help me enhance my web system () using Laravel. Please refer my document. If you can do my task and budget is fullfill then we can chat it Add function as follows: User/ Vendor: - User Receipt Upload: Users can upload their receipts and key in some data from the receipt such as Date, Amount, and select receipt category. - Point Tracking: Implement a feature that enables users to view their total points and pending points upon logging in and update point when redeem. - user can redeem receipt using point and print out real voucher. (Voucher inside must include exp date, company name, vendor address, Discount what kind product category, voucher id that vendor set.) -user can do voucher sorting like state, point, Vendor - can view

I am actively seeking an API development expert, specifically for SSO and SAML integration. Let's dive into what I am specifically envisioning for this project: - Proficiency: I will need someone who is familiar with SSO, SAML, React, Node.js and SQL. Your past experience in similar projects will be highly valuable. - Functionality: A primary objective for this task is to develop an API that has Single Sign-On (SSO) and Security Assertion Markup Language (SAML) functionality. - Purpose: The purpose of the API development is to integrate SSO and SAML for user authentication in my system. Maintaining security, ease of use, and adaptability is crucial. In conclusion, your task primarily revolves around strengthening authentication methods via respective API development.

I'm looking for a sales professional who can reach out to our leads and convert them into registrations for our online school. The product we offer is the Full English National Curriculum to teenagers aged 11 - 18. It's crucial that the sales professional is fluent in English as they will be representing our school and handling potential students' inquiries. Ideal candidates for this position should have the following: - Proven track record in sales, particularly in an education-related field - Excellent communication and negotiation skills - Strong understanding of the education sector and the English curriculum - Experience in dealing with teenagers and their parents - Ability to work independently and meet targets - Proficiency in English The job is all about...

...and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job link in an Excel sheet so that it is organized properly. You will add resume's link in the same excel sheet, you could upload resume in folders on google drive. Is this task doable for you? Below is a sample job description -: "Position: Site Reliability/Observability Engineer (SREs). Location: Johnston, RI or Phoenix, AZ (4 - 5 days onsite). Duration: FTE Objectives of this role: Run the production environment ...

We are searching for a long term Expert AutoCAD drafter. This is for a long term partnership. We will be evaluating a few freelancers to determine best fit. Need to have architectural experience specially working on cabinets. Critical Criteria: AutoCAD Proficient Fluent in English 40 hours a week minimum Familiar with Casework & shop drawings Task: Convert architectural drawings into fabrication/installation drawings. Current Projects open: 20 elevations 140 elevations 35 elevations Pay: Based on experience on average its $15 per elevation. Time Frame: as soon as possible

...to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding of automation...

I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.

...button from the home page and menu with a simple white band with two dedicated options A) Schedule a call, B) WhatsApp us 3. Blogs based on Keywords and SEO 4. Update About Us section to something precise and much more interactive and interesting with better design. 5. A live chat option on the website for a smoother experience which helps the visitor with a few queries and helps the visitor to select the perfect plan for him/her. 6. Better Testimonial Page 7. Move the scroll bar from the right side to the top of website for immersive and wide viewing of the website 8. Increase the speed of the website with quicker but sleek loader. 9. Footer needs a design update as well. 10. Cache management, google analytics, meta tags, backlinks (inbound and external) along with everything th...

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid proposal should reflect yo...

I am in need of a leaflet that captures the essence of my product's features and benefits, crafted specifically for a distinct age demographic - ages 30 - 60. The leaflet should be compelling, informative, and engaging - encouraging action from the reader - a phone call when their policy is du...thick, matt card. Take a look at my website - for additional information Key details: - Directly and creatively highlight product features and benefits - Visibly place contact information for customer reach-out - Incorporate a compelling call to action to engage youth demographic Ideal skills and experience: - Strong graphic design skills - Ability to convert product features into relatable benefits - Proven track record of creating effective calls to action.

I'm looking to convert my WordPress website to Advanced Custom Fields (ACF) editable content. Key Points: - I need help converting the current WordPress layout to ACF editable format. This includes converting the header, navigation, footer, and content sections. - The main reason for this conversion is to have more flexibility and control over my website's content.