Update excel sheet using sql query jobs

I'm seeking a skilled web developer to UPLIFT an eCommerce store via SQUARESPACE for selling physical products. This store will sell customizable jewelry. The website is already created but we need to: 1. Update the style/colour/formatting and design of the front end. I am not happy with my colour schemes and font choice. Please help me improve the design. 2. Optimise my website for mobile 3. Improve functionality, spacing, and formatting using code. There is ~25 design and functionality changes that need to be changed e.g. Add pop up at checkout for ring size guide. Logo, media, text etc will all be provided.

I’m looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects your ability to fulfill the...

I'm looking to revamp and update content on my WordPress based website, www.Maiyuri.com. The work involves several tasks such as: - Text Changes: This would involve editing the 'About Us' page, updating our product descriptions, and modifying our contact information. It is important that the words and language used captures our brand voice and aligns with our business goal. - Image Updates: We need some fresh images to appeal to our audience. Appropriate creativity to make the website more appealing is appreciated. For the product descriptions, I want you to create the new content based on the information currently present on the site. It should be more detailed and compelling to the site visitors. Looking for a freelancer with a strong background in content c...

I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.

Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this project....

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I have a 7-page spreadsheet that needs consistent formatting and customization to reflect my school's brand identity. The system should be able to easily add and delete rows/columns via right-click menu options. Key Requirements: - Format and make...needs consistent formatting and customization to reflect my school's brand identity. The system should be able to easily add and delete rows/columns via right-click menu options. Key Requirements: - Format and make consistent a 7-page spreadsheet. - Implement school branding elements. - Enable easy addition and deletion of rows/columns via right-click menu options. Ideal Skills: - Proficiency in Excel formatting and customization. - Graphic design skills for incorporating branding elements. - Experience in creating user-fr...

I'm looking for an accomplished WordPress expert to revamp my website (). Key focus areas are speed optimization, SEO friendliness and design update. The goal is to enhance my site's online presence significantly, increase sales, and improve our brand awareness. Here's what I'm seeking: - WordPress speed optimization: Fast-loading sites are crucial for higher conversion rates and improved user experience. - SEO-friendly updates: It's essential to make our site appear on top of search engine results. Possessing SEO skills is critical. - Design changes: I'm open to a new layout, color scheme, and font selection ideas that can make our site more appealing and user-friendly. Also, my website must: - Generate leads: The design and content should be engagi...

We are looking for an experienced supporter who can manage and update our Typo3 installation with different webpages: Please also have good knowledge about Typo3 updates to the latest versions (v13).

The fonts listed, when selected, the "Sample Text" should change to show the appropriate look of the selected 'font style' please fix and update with the font names shown in their font style (as now, only "Pacifico" font works properly) >>> Please use all font listed at <<< for font list

I have a simple one page website at that has three bugs: 1) The footer's color is not working. The CSS attempts to set the footer color, but it shows up as white all the time. Could be a...to set the footer color, but it shows up as white all the time. Could be a html tag issue or a css issue. 2) The Dark Mode / Light Mode selector in the footer mostly works, but the CSS based animation of the toggle switch no longer works. This stopped working the same time bug number one appeared, so they are probably the same bug. 3) Clicking the Dark Mode / Light Mode selector does not always update the cat gif image. Sometimes it works, sometimes it doesn't work. Probably a JS issue. I would like to get these three bugs fixed now. Please only bid if you can fix these right now.

I'm in need of an experienced Flutter Developer who can craft a comprehensive mobile application. The app should be compatible with both Android and iOS systems. Requirements: - Develop a logistics and delivery app: The project focuses on creating a comprehensive software that can manage delivery services. It should include features such as route optimization, real-time tracking, delivery scheduling, and scanning capabilities. Skills & Experience: - Proficiency in Flutter: The candidate should be well-versed in Flutter development to ensure a seamless and efficient app. - Previous Experience: An ideal candidate should have a strong track record of developing similar applications. - Strong understanding of logistics: Knowledge of logistics and delivery processes is a plus as it w...

I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to produce...

I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.

I'm seeking a WordPress and Elementor specialist to undertake a content update on my website. Your responsibilities will primarily be: 1. Homepage Setup: The homepage requires a professional touch. However, the user skipped the question about their preference for layout and design. Flexibility and a knack for enhancing site appeal are crucial. 2. Campaign Banner Update: A thorough update or replacement of the existing campaign banner is required. Your creativity and eye for detail will be essential here. 3. Countdown Timer Update: The timer isn't fully responsive across all devices and needs fixing. Experience in creating and managing responsive site designs will be crucial. Ideal skills and experience: • Expertise in WordPress and Elemento...

I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.

I have a small business and am seeking a skilled web designer to cre...for me. I've chosen a color scheme (blue and white) and know exactly what I want on the page. The main function of this landing page is to display my business information. It should be clean, simple, and easy to navigate. I'm looking for a design that's professional and has a modern touch. I'd like the landing page to include: - A brief description of my business - Just use random text I will update it - A color scheme that's mainly blue and white I really appreciate a freelancer who has experience working with Wordpress and is skilled in creating effective, eye-catching landing pages. A good eye for design and attention to detail are key. I'm open to discussing any other suggest...

Seeking an experienced QA tester based in Thailand to perform functiona... It is very important that you are able to work in the daytime starting between 11:00 to 13:00 and ending between 15:00 to 16:00. This is a remote work job inside Thailand. But if you live near True Digital Park in Bangkok that is a bonus for in-person meetings. We are somewhat flexible but we need the Goalprize developers to watch your testing in real time via Skype and our online testing sheet to interact with you and quickly verify real bugs and eliminate non-bugs. The developers speak English (not Thai) but we also work with many Thai people and also want to hire a Thai CTO or full-stack developer very soon. Please contact me as soon as possible to discuss. We can start you immediately if we are a g...

...ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservices development in Java (Spring Boot or equivalent framework) Proficient at building intelligent solutions to complex problems. Experience using source control tools such as GIT Proficient at Performa...

I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - A...need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as ...

After the latest WordPress update, my website has been plagued with various issues that impede its functionality and user experience. Key Responsibilities: - Rectify the broken links and error messages - Ensure the proper functionality of pictures and sliders - Install an SSL certificate to bolster site security If you're adept at mitigating such post-update problems and are knowledgeable in SSL installation, please bid. Deep understanding of WordPress and experience dealing with similar issues is highly advantageous.

Please Sign Up or Login to see details.

I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

...for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal Skills: - Proficiency in chatbot development. - Experience with integration with Mikrowisp or similar systems. - Proficiency in backend system development fo...

...skillful PHP/Laravel developer with proven proficiency in , Vite, and Tailwind CSS, and Github I'm seeking a professional to assist in the creation of a high-performing Payment Portal Management System with a deadline of May 14, 2024. Candidate must be competent in Github and have fluent communication skills in either English or Chinese. All user and transaction data will be generated using random data for development purposes. The existing database structure and design are mostly completed, and the current source code will be provided to facilitate seamless continuation of development. Project Details: Payment Management Portal The project entails the development of a comprehensive payment management portal with three key roles: User: Users can have multiple companies, a...

I'm looking to create an application using NoCode development tools, specifically Bubble and FlutterFlow. The core features I need developed are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skille...

I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.

I'm experiencing an issue with my email that was linked to Google Wo...working. Now whenever I try to send an email, even though Google permits my login, I'm encountered with an error message (This is the message i receive now: 550 5.1.1 : Recipient address rejected: undeliverable address: host [private/dovecot-lmtp] said: 550 5.1.1 User doesn't exist: xxx@xxx (in reply to RCPT TO command) I don't know how to verify if my DNS settings update is aligned with the new website hosting. I need urgent assistance from an experienced individual to amend this issue. Ideal Skills: - Experience in troubleshooting Google Workspace email issues. - Proficiency in DNS settings and have experience in website transfer. - Experience in diagnosing and fixing email sending erro...

I'm looking for an experienced iOS developer to create a straightforward app for me. There will be several simple features that need to be implemented: - Manual Signal Updating: The app should allow me to manually update the signals for 7 fx pairs, Bitcoin and the SPY. - Signal Icons Display: The app should have different icons (e.g., arrow up, arrow down) for each type of signal (buy, sell, NA). - Custom Photo Integration: I have some photos I'd like to incorporate into the app, either as decoration or background. Your role will be primarily focused on the development and implementation of these features. The design of the app should be minimalistic, with the photos I provide integrated seamlessly. Ideal skills for this project include: - Proficiency in iOS developme...

I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Ex...

I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.

I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.

The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms ...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extr...in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like...

Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.

I am looking for a skilled web developer who can help me with customizing the Motors Theme in a way that will enhance the user's experience, particularly with the payment process. Your main tasks will include updating the Payments page and journeys. The specific focus of the payment changes should be to simplify the checkout process. Key tasks: - Update the payment process steps to simplify the checkout process Ideal skills: - Proficient in working with Wordpress themes, particularly Motors Theme by Stylemix - Experience in customizing payment gateways and checkout processes - Able to enhance user experience through design and functionality This project is perfect for you if you have a knack for web development and are keen on improving user experiences. Please include ex...

I require an experienced TradingView developer to update an existing indicator. The task involves adding multiple lines to the indicator in a specific manner. These lines should be plotted above or below the existing lines. Ideal candidates for this project should have: - Strong experience in TradingView indicator development - Proficiency in Pine Script - A keen eye for detail to ensure accurate line placement - Previous experience with custom line plotting in TradingView Please include your previous work and any experience related to this project in your proposal.

I am looking for a skilled web develope...create an informational website targeted towards businesses. This project requires a website that can easily be updated with regular product/service updates, since it'll be a platform to educate our audience about our offerings. Key requirements for this job: - Comprehensive web design and development expertise - Proven experience integrating a content management system (CMS) for easy content update - Knowledge in creating a user-friendly layout for businesses - Strong understanding of SEO strategies to help us reach our target audience effectively Please provide samples of similar websites you have developed, especially ones targeted towards businesses. Candidates with previous experience in building informational websites will hav...

I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

Please Sign Up or Login to see details.

I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-dep...

...excellent telephone manner, and perfect spoken French. Italian also highly desirable as second language. - A strong and verifiable track record of generating leads and working to targets. - Excellent communication and persuasion skills. Your task will be to introduce the business/service to potential leads, record information accurately and keep a comprehensive database of contacts, which you will update on our shared worksheets. There is potential to make this an ongoing job for the right Freelancer that can achieve daily and weekly targets. Daily minimum goal is to deliver 20 high quality qualified leads (name, email address, direct contact number) The job pays €60 per day in arrears on delivery and verification of leads. PLEASE NOTE THAT THE JOB IS TO DELIVER A MINIMUM...

...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...

Excel task to do the task t0 d0

I'm looking for a skilled website designer and developer to help me revamp my existing site. The main goals are to: - Redesign the layout: The site needs a fresh look that is both modern and user-friendly. Aesthetics are important, but so is functionality. - Update the content: The website's content is outdated and needs to be refreshed. This includes text, images, videos, and any other media. - Improve the navigation: The site's navigation is currently not as intuitive as I'd like. I want visitors to easily find what they need. The main purpose of the website is to showcase my products/services. Therefore, the redesign should be tailored towards this end. Also, I prefer a color scheme that is warm and welcoming, in line with the type of products and services...

I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce projects would be a s...