Vba excel sql projectsJobs

I require the expertise of a Power BI maestro who is proficient in creating dynamic, interactive and visually appealing reports from sales data. This project specifically involves: - Analyzing sales data I will provide in Excel format. - Constructing and designing a Power BI matrix table for reporting purposes The ideal candidate is proficient in Power BI and Excel with an in-depth understanding of sales data reporting. You should be able to translate complex data into informative visuals & interactive reports. Producing accurate, error-free analysis within arranged timeline is critical for the success of this project.

I am in need of a professional to help me create a toolbar plugin for PowerPoint 365. Key Requirements: - Must be able to translate an already created toolbar with VBA code into a comprehensive PPT add-in package. - Must be ready to review the existing codes and functionality I have developed so far. Ideal Skills: - Familiarity with PowerPoint 365 and its functionalities. - Proficiency in VBA scripting and creating PowerPoint add-ins. - Strong knowledge in plugin development and toolbar customization. Please note your experience in similar projects in your bid, and any ideas you have to enhance the toolbar based on your experience will also be appreciated.

pasar informacion a excel. pasar informacion a excel

Simple task I have a .CSV file and I want a program that translates it to .SQL with the existing database

As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing mapping functions...

...Retool Engineer to join our team for a 2-month contract position. The ideal candidate will have a minimum of 2 years of experience in software engineering, with specific expertise in Retool and SQL. This individual will play a key role in developing, maintaining, and optimizing Retool applications to meet the needs of our clients. Responsibilities: Collaborate with cross-functional teams to understand business requirements and translate them into functional Retool applications. Design, develop, and implement custom Retool solutions to streamline processes and improve efficiency. Write complex SQL queries to extract, manipulate, and analyze data from various databases. Troubleshoot and debug issues in existing Retool applications, ensuring smooth functionality. Conduct re...

...you looking for a great opportunity to start working part time and eventually get a full time remote job from home? We’ll that’s what you’ll get with World Kwest! Requirements • Develop and maintain our database system using PHP and SQL. • Optimize database performance for efficiency and scalability. • Collaborate with the development team to implement new features and functionality. • Troubleshoot and resolve database issues in a timely manner. • Stay updated on industry best practices and technologies. ROLE RESPONSIBILITIES : • Proficiency in PHP and SQL is essential. • Experience with HTML, JavaScript, and/or React is a plus. • Strong problem-solving skills and attention to detail. • Excellent communicat...

As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...

I am currently seeking a highly qualified candidate with robust experience in developing web applications and designing database structures. The location of operation will be Hyderabad, and preference will be given to local candidates. Key responsibilities: - Development of both in...local candidates. Key responsibilities: - Development of both interactive and informational web applications - Designing suitable database structures To perform efficiently in these tasks, the candidate should ideally have: - A minimum qualification of graduation - At least 9 years of relevant experience, which should reflect in their seniority level - Expertise in C#, ASP.NET, .NET COO, and SQL databases For your bid to be considered, please ensure your profile aligns with the aforementioned req...

I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in these areas ar...

I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split...split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should h...

I urgently need an experienced ASP.NET developer to perfor...The specific bugs are not defined yet but it involves issues that usually occur in ASP.NET applications. - Freelancers applying should specifically include details about their experience in ASP.NET development. - Although specific skills or knowledge weren't mentioned, an understanding of general ASP.NET development processes and troubleshooting errors is crucial. - Familiarity with .NET Core, SQL Server, and Entity Framework would be a plus. Your job will be to pinpoint the sources of these issues and resolve them. Ideally, your bid will reflect an understanding of the volatility of bug fixing, where some issues may be quick fixes while others may present more of a challenge. Please include relevant examples of ...

I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project brief: -...

As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

I am seeking an experienced data entry clerk for the task of entering data offline into a Microsoft SQL Server database system. Key Tasks: - Entering large amounts of data consistently and accurately - Ensuring all offline data is represented accurately in our SQL Server system Ideal Skills and Experience: - Proven offline data entry experience; accuracy and attention to detail are crucial - Hands-on experience with Microsoft SQL Server - Knowledge of database structure and data principles - Excellent time management skills to meet deadlines. Prior experience with large databases is highly beneficial. The successful candidate should be familiar with SQL Server, familiar with offline data entry, and have a keen eye for detail.

I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macr...

I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...

I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...

I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make an inf...

I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...

I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.

I am in need of a sea...My existing database resides on SQL Server 2022 and I am aiming to migrate it to Oracle 19c. - The size of my SQL Server database is small, amounting to under 1 GB, but there are around 450 procedures and functions which have to be migrated - Experience with handling similar sized databases and an in-depth understanding of SQL Server 2022 and Oracle 19c is a must. - Proficiency in SQL and database migrations are critical, along with a problem-solving attitude. - The freelancer must ensure smooth transition with no data loss and optimal functionality post migration. - An established process, clear communication and deadline adherence are necessary. This is a challenging role requiring high expertise. Prior experience and strong feedback ...

I am seeking a proficient freelancer with solid Excel skills who can help me populate my Excel sheets. While no specific type of data is mentioned, good typing skills and attention to detail will be beneficial due to the nature of the project. The work would require timely and accurate typing of any kind of information whether it's text, numbers, or dates into Excel sheets. Since no further specific details were provided, showing an array of competencies, from past experience to detailed project proposals, in your application would set you apart. Ultimately, the main intent here is to organize information effectively without a specific analytical or reporting goal in mind.

we are looking for a senior PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - **must be an independent developer, not an agency! - must be able to work on github - proficient in converting figma design to html/bootstrap - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform Must be knowleadble in updating designs as well when needed.u ar ******* DO NOT BID if you are an agency, if you are a marketing person or proje...

I'm looking for a proficient freelancer who can design and implement customised, interactive charts, graphs on a Superset dashboard. Here's more about what I need: - Creation of bar a...interactive charts, graphs on a Superset dashboard. Here's more about what I need: - Creation of bar and line charts primarily. Your creative judgment in presenting information would be valued. - The ability to connect to a MySQL database from the dashboard is essential. - I expect you to have strong SQL skills, to accurately translate data into valuable, visual insights. Ideal skills and experience include: - In-depth knowledge of chart creation in Apache Superset - Sound experience with SQL operations and MySQL databases - Ability to interpret data and present it vis...

I have a .XML file but I want this information in .SQL. So that means that it should be make fit for my website. I want a program that takes all the information and translates them to a .sql format

...) Login, logout, roles (ACL if available in build) 2.) Users section with list, add, edit, delete, active and inactive user. Use ajex to check duplicate user email while adding and updating user. 3.) Categories and sub-categories 4.) Blogs (List, add, edit, delete, active and inactive), Meta title, Meta keywords, Meta description 5.) Page Manager 6.) Contact us list (With email) 8.) Export an excel having blog title, number of views, date created, user name columns and in last total of columns. Front-end: 1.) Landing page showing featured blogs and having menu of categories and sub-categories. 2.) Categories list page showing number of sub-categories of that category with categories. Sub category wies page showing number of blogs in that sub category. 3.) Blog list page (Cate...

...on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A portfolio demonstrating your previous works will also be very much appreciated. id like something that looks neat/more professional. I look forward to collaborating with a p...

I need virtual assistant, easy work just copy paste. More discusse with freelance chat...

...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. -...

I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...

My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.

...in gathering emails of a list of companies I already have at hand. The job entails the following: - Extracting emails of the listed companies. Key job requirements include: - Proven experience in web scraping, data mining and Excel - High attention to detail and accuracy - Familiarity with email gathering processes The purpose of these emails is for sales and marketing purposes; thus, discretion and adherence to GDPR and other privacy laws are of utmost importance. The list I'll provide is in Excel format, therefore a good understanding and efficiency in Excel would be greatly beneficial. Please note that the turnaround time for this project is also very crucial, so your ability to work effectively within a given time frame is key. Please only bid if ...

I have a registration system where players sign up for a sports event. These entries are in Wordpress and when they register the data gets pushed to a different system. There are about 200 records that did not sync and I need someone to manually go through and resync these. I'll provide an Excel file of the records that need to be resynced. To do this: 1. Login to Wordpress 2. Go to: Forms > Entries > Choose 'Spring 2024 Flag Football Registration' 3. Search for the players last name 4. Hover over their entry and click 'Resend' 5. Wait for it to process, then do the next one 6. Here is a video of the process: 7. You need to wait for each to finish to start the next, but you can 'resync' multiple at a time

As a novice in the Power BI field, I am seeking an accomplished coach who can proficiently guide me through building interactiv...Here's what I hope to delve into: - Building Interactive Dashboards: Help me design, develop and evaluate data-driven dashboards for more insightful management. - Data Visualization Best Practices: Teach me tips and tricks for effectively presenting complex data in an easy-to-understand format. - Data Modeling and Query Optimization: Educate me on creating efficient data models and optimizing my SQL queries for better performance. As this is a beginner level project, a patient and clear coach, skilled in Power BI and experienced in teaching beginners, would be my ideal choice. Previous experience working with business and finance data is also hi...

I'm planning to start a business and need an extensive research to be completed. I need data from US cities to be gathered, analyzed and published so the public can learn. Key Deliverables: - Collection of various data points such as population demographics, crime...the source, etc. - Starting point will be surveys published that will be provided to you on topics such as "Best place to retire in the US." Ideal freelancers for this project should have: - Experience in market research and data analysis. - Understanding of the U.S. regions and cities. - Ability to meet strict deadlines. - Clear and concise reporting skills. - Provide your research in an MS Excel document This project will require a keen eye for detail and the ability to present data in an understand...

We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...

Hi Webbook Studio, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Need an excel expert for an assignment

Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...

...video data efficiently. Media Servers: Familiarity with setting up and configuring media servers for streaming. Natural language processing AI and NLP Skills: Natural Language Processing (NLP): Security and Privacy Skills: Web Security: Protect user data, especially webcam streams. Authentication and Authorization: Secure user sessions and validate tokens. Data Sanitization: Prevent SQL injection and other vulnerabilities. Project management Project Management and Communication Skills: Planning and Organization: Break down tasks, set milestones, and manage timelines. Effective Communication: Coordinate with team members, freelancers, and stakeholders. Agile Methodologies: Understand agile practices for iterative development. Creativity Creativity and Ga...

I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.

I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.

We are currently looking for experienced writers to produce high-quality articles on Python programming. We are shari...for experienced writers to produce high-quality articles on Python programming. We are sharing a few topics that we would like you to write about. Not less than 1500 words, with sample code and screenshots if necessary, with grammarly and plagiarism checks done. Each article should be in Word document. Per article, INR 500. versus Python Key differences Python certificates 3..SQL versus Python , which one to learn Libraries for Datascience 5.10 Python Tips and Tricks Every Developer Should Know with Databases in python Python Functions of Iron python Python in C# Applications Giants that use python

I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.

If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid

I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be com...

Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."