Excel vba database project jobs

I'm looking to move my MS-Access database to Azure Cloud. It's currently less than 1GB in size. The process will involve a few key aspects: - **Database Migration**: The primary task is to lift-and-shift the existing database to the Azure platform without any data loss or corruption. - **Data Backup and Recovery**: One of the main security requirements is to ensure that data is backed up regularly and that a robust recovery plan is in place. It's worth noting that there aren't any specific Azure services that need to be integrated, nor any special security measures beyond the data backup and recovery. The ideal candidate for this job should have experience in Azure cloud services and database migration. They should also have a good unders...

I'm in need of an Excel expert to process and validate numerical data. The successful candidate should be able to perform basic validation including checking for empty fields and ensuring correct data types. Ideal Skills: - Expertise in Excel and data handling - Proficiency in basic data validation techniques - Solid understanding of numerical data On successful validation, the processed data should be delivered in an Excel format. This project requires a strong attention to detail and accuracy. Prior experience with similar projects would be a plus. Your ability to perform simple but accurate data validation will be key to this role.

I require a skilled Excel expert who can handle and validate textual data for me. Key Responsibilities: - Process a large amount of textual data in Excel - Ensure data is validated accurately Ideal skills for this project: - Proficiency in Excel - Experience in handling textual data Please note that the communication method for updates and feedback can be discussed and agreed upon.

Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and...data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and un...

I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...

I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills

I am aiming to incorporate and enhance my Parent Company's policy and processes on I...Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an excel based GAP analysis of desired Asset Management state vs current, based on Parent Company's expectations and standards. 4. Define a recommended plan for addressing these GAPS in a viable way. The ideal candidate for the project should: - Possess vast experience in IT asset management - Have intricate knowledge of Documentation Process and Workflow diagram - Have proven results in impro...

I am looking for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts...research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record in delivering high-quality B2B leads and can assist with these tasks, I'd like to...

My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.

croatian text below (please translate it in your language if necessary) Mi trazimo freelancer-a koji ce definirati i izvesti tendera u Europi za igradnju jedne kuce sa tri stana i 3 PGM u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje p...u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje ponuda te izrada usporedbe cijena prema pojedinačnim poslovima - Sudjelovanje u pregovorima s ponuđačima i izrada prijedloga za ugovaranje - Sudjelovanje pri odabiru izvođača Format predaje: Dokumentacija u excel...

To create a canvas powerapps screens similar to the Excel provided to Florian.

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale d...can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the su...

My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?

Hello, I'm in need of a developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a ...

I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is...

10k NRI email database of global

We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries...

I require a freelance bookkeeper who can assist me with my accounting needs. - You will primarily be responsible for bookkeeping tasks, ensuring that all financial tra...that all financial transactions are properly recorded in my accounting software. - As a bookkeeper, you should have a keen eye for detail, be organized, and have prior experience in bookkeeping. - Familiarity with popular accounting software like QuickBooks and Excel is a must, as I currently manage my bookkeeping through these platforms. The ideal candidate for this job should have a strong background in accounting, specifically bookkeeping. Relevant certifications or degrees in accounting are a plus. Experience with QuickBooks and Excel is a must. I'm looking for someone who is detail-oriented and c...

I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.

I have a PDF list which contains text and numbers. The list is structured with columns and rows. The task is to convert this list into an Excel sheet. The Excel list should be organized in a sorted manner, either alphabetically or numerically. Ideal Freelancer: - Proficient in data entry and conversion - Experience in handling PDF to Excel conversion - Excellent understanding of sorting data appropriately - Attention to detail is crucial

...experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Profici...

I'm in need of a web scraping expert who can extract daily car rental prices from and deliver this data to me in Excel format. Key Requirements: - Extract car rental prices from - US based locations - Deliver the scraped data in Excel format Ideal Skills and Experience: - Proficient in web scraping - Experience in extracting data from dynamic websites like - Able to automate daily data extraction - Proficient in delivering data in Excel format

I have image form i want to make the form in excel to print it directly

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

I'm seekin...solution. The primary goal of this system is to manage a variety of business activities, such as managing schedules, tracking project progress, and more. Key Features: - **Database Management**: The software should primarily focus on data storage, retrieval, and basic data manipulation. Database Management Functionality: - **Data Reporting and Analytics**: Developing the capability to generate detailed reports and perform basic analytics on the stored data will be crucial. Ideal Skills: - Strong experience in Codeigniter - Proficiency in database management - Understanding of data reporting and analytics - Ability to create user-friendly interfaces This project will be a great fit for you if you're looking to work on an intere...

I'm looking for someone to develop a stock prediction program specifically targeted at the Saudi market. Key Requirements: - Programming Language: You can use any language you're comfortable with, whether it's Python, Java, C++, or another language or excel sheet. - Technical Requirements: The program should be highly accurate, providing predictions with an accuracy rate of over 90%. - Data Sources: The program should utilize a range of data sources to inform its predictions. These should include historical stock data for the Saudi market and any other relevant information that you can source. Be creative with your data sources and demonstrate a strong understanding of the market. Ideal Skills and Experience: - Strong background in programming and algorithm develop...

I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus ...

I am searching for a dynamic Sales Executive well-versed in technology, specifically software solutions, to drive sales in the business sector. Key Responsibilities: - Building and maintaining relationships with business clients ...maintaining relationships with business clients - Presenting and selling software solutions ( web designing and social media marketing and management ) Ideal Profile: - Experience in B2B sales, particularly in technology - Understanding and passion for software solutions - Excellent communication, presentation and negotiation skills. This is a commission-based role offering the opportunity to excel within the tech industry while working closely with businesses. Comession is based on deals you will it is going to be between 8% - 20% on every succe...

I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals wit...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...

...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. What We're Looking For: Technical Expertise: Extensive experience in machine...

I'm looking for someone to assist in transferring data from digital files (mainly PDF and Word) into Excel spreadsheets. Key Responsibilities: - Accurately inputting data from PDFs and Word documents into Excel - Ensuring data integrity and quality is maintained throughout the process Ideal Skills and Experience: - Prior experience with data entry, particularly with Excel - Meticulous attention to detail to ensure accurate data transfer - Proficiency in Excel and ideally some experience with PDF and Word files - Ability to work independently and meet deadlines

As someone deeply invested in the health and wellness sector, I am seeking capable freelancers to compile a comprehensive city-wide mailing list. Key Deliverables: - Locate all disabilit...compile a comprehensive city-wide mailing list. Key Deliverables: - Locate all disability support businesses in the chosen city. - Capture specific details for each business: name, business email. - Record the information systematically on a spreadsheet for easy reference. Ideal Bidder: - Excellent research and data gathering abilities. - Proficient in Google sheets or Excel. - Attention to detail. - Experience in database creation or compiling mailing lists. Please note, I am working on a budget AUD $60 and require the task to be completed within 1-2 days. Thank you in advance for yo...

I have a large PDF file with a mix of text and numbers. It contains over 300 pages, but there are generally less than 10-20 lines of data on each page. I'm looking for a freelancer to convert this data into an Excel spreadsheet. I'm only in need of data entry, not analysis, so the task is straightforward. Ideal Skills: - Proficiency in Adobe Acrobat - Strong knowledge of Excel - Experience in data entry This is a simple but time-consuming job, so please provide a realistic timeframe for completion when bidding. Accuracy is important, as the data will be used for further analysis.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...

...information would be searchable. A lot of this functionality will be in an ATS if we white label it, the questions is how to integrate functionality that is unique to us. It would be useful to have a reporting function, so that recruiters could for example review the average score of all candidates on a test etc. May not be essential for an MVP. All candidate information is exportable (probably to Excel) Invite candidates to the next round - which may take place on or off the platform Search candidates who have created a profile. They would be able to search based on usual criteria for talent pools as well as what type of tests the candidate has taken and what their scores were. Set questions for and records video for asynchronous video interviews Send candidates links to asy...

I'm seeking a skilled web developer who can update a music store. I would like to add an auction page, contract management and generator feature. I have updates to user login and music management. Please have experience with audio players and being able to play music while playing an additional mp3 audio tag at a lower volume. Being familiar with ecommerce and using paypal, and stripe for payments. See the attachment for details. Ask all of your questions in the discussion board so everyone knows the question and answer. Please do not submit a fake bid amount and completion time as that will disqualify you. We can discuss everything in the clarification board. We will communicate in chat after I select you as the winner. Thanks!

I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals wit...

I'm in need of a research professional who can collate and organize details about the Corporate Social Responsibility (CSR) activities of a specified list of 400 companies, together with LinkedIn profile URLs of respective team members. Key Task Requirements: - Research and compilation of CSR project details of the identified companies - Use of Excel for data presentation in an organized manner - Gathering of LinkedIn URLs of team members from each company Ideal Skill Set: - Proficiency in web research - Expertise in data entry and data organization - Familiarity with LinkedIn and its functionalities - Detail-oriented approach - Experience in Corporate Social Responsibility research is a plus. Your job will be instrumental in providing in-depth insights about th...

...customer business card scans into a detailed Excel database. Each card has been scanned using the CamScanner app and they vary widely in design, content, and layout and all of them are different. (90% of the cards are in english, 10% are in urdu and arabic) Objective: Looking for innovative, no-code methods that automate the conversion of these business card images to an Excel sheet with minimal human interaction. The best method should be fast, cost-effective (minimal or zero cost), and capable of handling high variability in card designs without any coding or manual programming. Submission Guidelines: * Propose a no-code solution using online tools or existing software that can intelligently organize varied information into consistent Excel columns. * ...

- Daily Accounts: Should have a mechanism for daily tracking of accounts. - Sales Management: An organized way to manage all sales. - Customer Management: The system must be able to maintain a proper client record. - Purchase Management: Need to keep track of all the purchases. - Supplier Management: Managing interactions with the suppliers effectively. - Database Management: Ability to handle a growing database. - Inventory Management: Keeping up with fish inventory.

Need a Plugin/App to Transfer Google Sheet Data to Database via Webhook URL Description: We are looking for a skilled developer to create a custom plugin or app that seamlessly transfers data from a Google Sheet to our database whenever changes occur. The plugin/app should be able to detect any modifications in the Google Sheet and trigger the transfer process automatically. The data transfer should be facilitated through a webhook URL provided by us. Requirements: 1. Develop a plugin/app compatible with Google Sheets that can monitor changes in real-time. 2. Implement functionality to extract data from the Google Sheet and send it to a specified database via a webhook URL. 3. Ensure the plugin/app is secure, efficient, and scalable. 4. Provide clear documentation and...

I need an experienced Laravel developer to undertake crucial tasks within a large-scale project over a two-week timeline. The Laravel-specific requirements are as follows:- 1. Fix the Home Dashboard to display real data instead of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of t...

I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile

...with missing data) with n events / n total in ACA analysis and n missing in both intervention and control groups (in Excel format) Key Responsibilities: - Impute missing data: The primary task will be to impute missing data in the clinical trial dataset. This is crucial for maintaining the integrity and accuracy of the overall analysis. - Generate ACA, ICA-0, ICA-1, ICA-pc, ICA-pe, ICA-p, ICA-b, ICA-w, Gamble Hollis analysis and IMRO (2/0.5 and 0.5/2) analysis plots - Generate L'Abbe plot(s) (for further details please see attached file) Ideal Skills and Experience: - Proficiency in SAS / Stata: As I specifically prefer to present the data with SAS / Stata for this project, it's essential that you have strong experience and expertise with this statistical softw...

...comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing project manag...

I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases