Excel connect to sql server query jobs

...tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filteri...

...developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing func...

...in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity w...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they h...

I'm in need of a freelancer skilled in Windows server administration and virtualization technology, specifically VMware. Your task will be to set up a VPN server on my existing Windows virtual machine. Key tasks include: - Installing and configuring OpenVPN on the Windows server - Ensuring the VPN setup is secure and functions properly You should have deep knowledge and experience with Windows Server, VMware, and OpenVPN protocols. I'm expecting the project to be done efficiently and timeously without compromising on the server's security measures.

I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid proposal.

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I run an existing business, , that focuses on weddings. I'm eager to expand our digital footprint by launching an Android and iOS app. This application needs to exude a modern and minimalistic design aligning with our current brand aesthetic. Here are the essential features I need to be included: - RSVP Management: To assist in tracking who will be attending the events. - Guest List Management: To ensure smooth coordination and organization of attendees. - Wedding Day Timeline: For easy day-of planning and scheduling. - Photo Sharing: A space for guests to share their cherished moments. And also we have to promote different vendors categories ...maybe this option is good idea to connect with the categories of our weddi...

...seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to...

...for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of th...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required ...

I am seeking a social media marketing guru who can amplify my brand's visibility on Facebook and Instagram. Key tasks include: - Develop and impl...implement a strategic social media plan that increases brand presence and engages with young adults. Skills & Experience: - Proficient in using Facebook and Instagram for brand marketing. - Proven track record in creating engaging content tailored to a young adult audience. - Understands and can use social media analytics to track campaign success and inform decisions. - Background in boosting brand awareness, preferably within a similar audience demographic. The end goal of this collaborative effort is to connect with, and make my brand more visible to, young adults. Solid experience with other...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

1) Integrate Xproxy Server into the prebuilt web dashboard as discussed. 2) Admin N Customer dashboard 3) Load demo $ in the customer account and he buys the proxy Proxy gets assigned to the customer from the server with details like http, socks and user pass , and option to change auth from user?ass to IP auth With API button, he can change the user?ass from his dashboard.

...data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build...

I am seeking a talented UI/UX designer to create a modern and visually appealing design for a new real estate website. The website will showcase our property listings, connect potential buyers and sellers, and establish our brand identity in the real estate market. Target Audience: Our target audience includes both property buyers and sellers. Buyers: Individuals, families, and investors looking for residential or commercial properties. Sellers: Homeowners, real estate agents, and developers looking to sell their properties. Website Features Property Listings: A user-friendly interface to browse properties by location, type, price range, and other relevant filters. Property Details: Detailed property pages with high-quality photos, virtual tours (optional), ...

I need a Notion API expert to customize my Notion pages for a smoother workflow and integration with other apps. Key requirements: - Integration with other apps: I'm looking to connect my Notion pages with an email client, specifically Microsoft Outlook. The goal is to automatically create draft emails in Outlook whenever new orders are created in Notion. - Automation of tasks: The freelancer will need to create a system that automates the email creation process. This should be seamless and require minimal manual intervention. - Email drafts customization: The only specific requirement for the email drafts will be the Email body. Ideal skills and experience: - Strong knowledge of the Notion API - Experience with integrating Notion with external a...

...for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

...experienced Android app developer to create a robust and aesthetic dental care plateform The successful applicant will have: -Expertise in Android app development -Proven experience in creating dental health care apps Primary Function of App: - Establish a user-friendly interface for purchasing and asking disease problem using cam scanner on chatboard frome home or from anywhere we want. -If user want to connect with dentist urgently, for that thing first pay online 50₹ to the dentist and connect with them urgently. - Ensure secure online payment options after contact with dentist. - Effective things categorization for easy user navigation - Provide options for user reviews and feedback Your commitment to timely delivery and clear comm...

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products ...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

We are urgently developing a comprehensive marketing analytics tool designed to integrate data from various advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Desig...

Face-to-Face (In person) Language Tutor & Coach Needed North & North West Tasmania - Australia I'm searching for an experienced language trainer to help enhance language skills. From the initial stages of learning a new language, for the total beginner, requiring a skilled tutor who can guide through the more complex aspects of the language Adaptation and versatility with teaching methods would be beneficial. Skills & Experience: - Proven experience as a language tutor. - Patience and excellent communication skills. - Ability to create a diverse and inclusive learning environment. - Capacity to tailor lessons to my unique learning style. **Requirements:** - You should have an established record of successful language teaching. ...

I'm in need of a skilled 3D illustrator, specifically someone well-versed in creating cartoon-like characters. The project consists of creating an engaging scene depicting a South Indian family enjoying their meal....cartoon-like characters. The project consists of creating an engaging scene depicting a South Indian family enjoying their meal. The expressions and postures of the characters should primarily focus on cooking and serving. The aim is to use this illustration as a colorful and vibrant representation of South Indian culture in a pamplet for food product promotion. Experience or familiarity with Indian culture would be highly appreciable, but visual creativity is paramount. If you believe you can bring these characters to life with your artistic skills, I'...

...a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interes...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.

...need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail ...

I need a windows or online php application , whatever you do prefer that i will be able to : Connect multiple Bybit API keys *Add Key/Account - Remove Key/Account *Add notes for each API KEY *Have a check button that when i click it will get the available USDT balance from all connected accounts.

I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and ea...

Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.

Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

Create Financial Project on Excel

Hello! I'm looking for an experienced Person who can build the mobile device management (MDM) Server for iPhone device. Specifically, I need someone with expertise who can create a custom MDM solution. This solution must be capable of advanced user access control, including full control of devices, remote wipe capabilities, and more. The MDM functionality I need is for iPhone device enrollment and management. I do not have an existing solution that needs to be integrated, so will require a new solution to be built from scratch. Before showing interest on this job, Please read the below link and then you can bid for this job FYI: The ideal candidate has extensive experience developing mobile device management

...peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work collaboratively and exp...

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you

I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.

...Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - ...

In dire need of a proficient individual who can assist in JSON data entry tasks. I require the handling, entering, and managing of JSON data sourced from a database. The focus is on three specific fields - customer data, product information, and sales recor...require the handling, entering, and managing of JSON data sourced from a database. The focus is on three specific fields - customer data, product information, and sales records. Ideal candidate should exhibit: - Strong experience in JSON data entry - Precise attention to details especially with customer data, product information, and sales records - Superior organizational and multitasking abilities Your rigorous approach to data accuracy and your dedication to meeting deadlines will ensure success in this proj...

...looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work...

I'm in need of an experienced and creative mobile app developer to craft an innovative mobile application for me. The mobile app should serve the general public and combine some specific features to make a user's experience convenient and enjoyable. Key functionalities should include: - Social media integration, allowing users to connect the app with their various social media accounts - In-app messaging, enabling users to communicate with each other within the app - Push notifications, informing users about important updates or messages even when they are not actively using the app Timing is crucial for this project as I'm looking to have it completed within a month. Ideal candidates should have: - Proven experience in mobile a...

I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.

I'm on the lookout for a skilled graphic designer to create a modern styled logo for my brand. I'm aiming for a design that speaks volumes but in a subtle, neutral, and soft color scheme. Ideal Skills and Experience: - Profound experience in Logo Design. - Adept at delivering a Modern design style. - An understanding of color theory and its application, particularly in creating soft and neutral color schemes. If this aligns with your skills, let's connect!

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

As the owner of a start-up aiming to connect individuals, I'm seeking a professional app developer to bring my vision to life. The platform should be available on both iOS and Android. Key Features: - Messaging: A secure, user-friendly messaging system is essential for users to communicate effectively. - Profile Customization: The ability for users to personalize their profiles with images, information and preferences is key for building a social identity. - Friend Request System: A seamless system for users to connect with others is crucial. It's important that both existing and new connections can be made with ease. Skills and Experience: - Demonstrable experience in developing and launching social apps, with a portfolio...

...looking for a skilled Wordpress developer to create a sophisticated, user-friendly birthday invitation system. I need talent Wordpress can create system to manage all users created birthday invitions , I need to send my customer link . with some fields he need to choose from some options . example : name, age , address, every option have some drop list text he can choose for the format . and then after he finish . he click created order birthday . then I need approve this . after approve . he can share the invite birthday to friends and family . the design of the birthday page is full wide on screen. open only on mobile ! can't open on desktop . Can edit the invite birthday from admin . I want also later to connect...