Write data excel database macro jobs

I need a reliable system that automates a process, doing a couple of specific tasks: 1. Reading specific data captured in Excel files. 2. Automatically sending texts via SMS when there's a data match in a particular column of the Excel file. This task will require programming skills, particularly with Excel and automation tools API. Experience with SMS gateway integration is a huge plus. You will be required to advise on appropriate SMS gateways if you have prior experience. The matching data column in the Excel file should be the trigger initiating the text sending automation. The target of this automation is to streamline and expedite our communication process, reducing manual effort involved in sending periodic SMS updates. If ...

I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database

WHAT’S NEEDED: Uccello Designs is looking for a freelancer to input data from the provided PDF’s into the provided Microsoft Excel sheet. WHAT’S PROVIDED: We have designed the sheet to include all relevant headings that are important to the data entry project. Within each PDF are multiple files that need extracted and added to the sheet. ABOUT THE PROJECT: These documents cover our customers registering the products they have purchased. The 3 products are the Uccello Kettle, Muggi and Uccello Grip Mat. With the excel doc there are 2 tabs, one is solely for the Uccello Kettle and the second is called the accessory registration tab where we ask that you include the Muggi and Grip Mat. NON-DISCLOSURE AGREEMENT: The information that you are bein...

Require a form that submits the form data in a mySQL database table. Once the form is completed and submitted it should email the user a PDF certificate that includes all the information submitted in the form. The certificate should also display the end of warranty date which is one year from the purchased date entered in the form. If possible the emailed pdf should have a QR code that contains all the information submitted in the form.

I'm looking for a freelancer with a strong comprehension of formal, strict language and knowledge in copyright law. The project's objective is to draft compelling copyright notices explicitly for m...draft compelling copyright notices explicitly for my business partners. The ideal candidate should possess: - Exceptional writing abilities - Familiarity with copyright laws and documentation - Experience in developing policies or legal documents with a formal and strict tone - Proficiency in Excel for organization and template creation Your tasks include: - Understanding my business and its partners - Writing strict and formal copyright notices - Organizing these notices in a user-friendly Excel format Quality, accuracy, and adherence to the formal tone are key...

I have text data stored in a MySQL database that needs to be cleaned and formatted in Excel. Key Tasks: - Identify and correct errors in the data - Eliminate irrelevant information - Standardize data for consistency - Ensure data integrity and quality Key Skills: - Proficiency in MySQL database management - Strong experience in data cleaning and manipulation - Expertise in Excel for data formatting - Attention to detail for identifying anomalies and inconsistencies - Ability to ensure data quality and integrity We need a freelancer with a keen eye for detail and strong data management skills to take on this task. A background in data science or analysis would be highly beneficial. Please include ...

...automated Excel Workbook specialized in the area of cost reporting. Key components I need are: - Calculation Formulas: Enable the workbook to calculate various financial metrics automatically. Should include revenue, expenses, and profit calculations. - Analytical Charts: The workbook should be able to visually represent the data and calculations such as revenue, expense, and profit trend lines. - Advanced Analysis: In addition to basic calculation formulas, the workbook should be able to analyze profit margins and handle cost variance analysis. It should have the functionality to run scenario analysis based on different inputs. Ideal candidates should have strong skills and experience in advanced Excel, particularly in creating automated workbooks, delivery of ...

As a healthcare company, we are in need of a financially savvy individual for financial forecasting, budgeting and planning tasks. Your ...comprehensive financial model that compares leasing and selling machines Identify key variables and assumptions for the model, such as machine costs, consumable prices, and operating expenses Determine the potential profit margins for both leasing and selling scenarios Provide recommendations based on the financial analysis findings Project Scope The project will include the following activities: Data gathering and analysis of machine costs, consumable prices, and operating expenses Development of a financial model using Microsoft Exce Testing and validation of the model to ensure accuracy Creation of a report summarizing the findings and recom...

I am in need of an expert researcher to build an email l...and Tax and Audit Firms operating within Germany. The primary purpose of this email list is for implementing a marketing campaign centred around our SEO service offerings. Ideal Skills: - Proficient in online research - Proven experience in data collection and management - Background in marketing or business development preferable - Excellent proficiency in English and some understanding of German language would be beneficial. Outcome: - An accurate email list with verifiable contacts - Must be formatted in a clear, organized manner (Excel CSV preferred) This is a venture that requires a good understanding of the targeted industry. With your expertise, we hope to successfully reach out to our prospective cl...

I'm looking to have a realtime database created which would serve the sole purpose of storing and retrieving user profile data in real-time. The operation speed should be top notch, with the least possible delays in data retrieval. Key Requirements: - Experience in designing realtime databases - Expert knowledge of user profile data handling - Basic user authentication implementation for accessing the database Data security is of utmost importance. The developer will be required to include basic user authentication to ensure that access to the data is controlled and secured. The right freelancer will have prior experience in creating similar databases and be able to demonstrate a good understanding of user profile data handl...

I'm looking to integrate real-time Firebase database functionality into my existing Django application specifically for capturing and storing transaction records. Key Project Requirements: - Expertise in Django and real-time Firebase integration - Experience in handling transactional data Transactional Record Components: The transaction records to be stored should include a unique identifier that I refer to as 'Lab bacterias'. Your task would include creating an efficient way to store and retrieve this particular information. If you have experience building out similar database integrations, please feel free to bid with your proposed timeline and rate. A successful project execution will likely lead to additional phases of development on the same a...

Job Title: Sales Outreacher Company: KT Studio About Us: KT Studio specializes in growing personal brands and businesses, focusing on YouTubers and influencers aiming to enhance their growth and efficiency. Role: Sales Outreacher...outliers) Experience: 1 month to 2 years (training provided for beginners) Application Process: If you are driven by success and ready to seize this exciting opportunity, send a DM with the word "outreacher" along with your cover letter and resume showcasing your sales experience and why you are the perfect fit for this role. Highlight any achievements or skills that demonstrate your ability to excel in sales and client relations. We are seeking a standout candidate to join our elite team, and exceptional performers will enjoy a rewarding career...

I am seeking an Excel expert capable of calculating First in First out (FIFO) for tech stocks that I own. Your responsibilities will include: - Taking provided data including purchase date, purchase price, stock ticker symbol, stock splits, the number of shares purchased, the number of shares sold and the respective dates - Arranging and analyzing these data accurately in an Excel document utilizing the FIFO methodology - Assessing if the stock sale is subject to tax due to the tax exemption for holding the stock for longer than 3 years The ideal freelancer would have: - Extensive experience with Excel - Familiarity with the FIFO method - Strong understanding of tech stocks This job will require attention to detail and precision. It's crucial t...

I'm in need of a skilled copy typer to assist me with converting a variety of documents into a digital format. The documents I need typed are a mixture of printed and scanned materials. Key Requirements: - Copy typing experience, particularly with printed and scanned documents - Accurate replication of the original content - Ability to match formatting to the original document Copy required in excel

I'm urgently in need of a proficient freelancer who can help with a crucial data entry task. Unfortunately, I skipped some questions, so I'll provide more context. The task is a one-time project, but the data type to be entered is not fixed yet, it could be either numerical data, textual data or a mix of both. Ideal Skills Needed: - Efficient in Excel Data Entry - Experience with Online Form Filling - Proficient in Copy-Pasting Data This project requires some urgency so a quick turn around will be highly appreciated.

I'm in need of an expert in data entry, particularly in Microsoft Excel. The task revolves around basic data entry, which includes names, email addresses, and other related simple information. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Previous experience in basic data entry - Strong attention to detail - Ability to handle repetitive tasks accurately and efficiently Your primary responsibility will be to accurately transcribe and input the data provided into the Excel spreadsheet. Your attention to detail will be crucial, as even small errors could have significant repercussions. Please make sure you are comfortable with the given task before placing a bid.

I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.

I'm looking for a versatile individual who can handle a mix of Excel tasks, accounting responsibilities, and policy making. Key Responsibilities: - Excel Data Entry and Analysis: The successful candidate will be responsible for data entry and analysis in Excel. Experience with data visualization is a plus. - Accounting Tasks: I need assistance with bookkeeping and financial statement preparation. - Policy Making and Problem Solving: The ideal candidate should be able to think critically and solve problems effectively. Ideal Skills: - Proficiency in Excel and data analysis tools - Experience in bookkeeping and financial statement preparation - Strong analytical and problem solving skills - Knowledge of policy making This role...

I'm looking for a skilled professional to install and configure Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c on a Windows Server 2022. The primary purpose of this installation is managing databases, so the main focus should be on optimal database functionality. Key Tasks: - Installation of Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Configuring Oracle DB with a high availability setup and performance tuning - Setting Windows environment variables for Java files - Copying 3 applications and 3 URLs from another server running Windows Server 2012 Ideal Skills and Experience: - Proven experience with Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Strong background in managing databases...

I need a freelancer who can assist me with moving data from Excel to an Oracle database. Responsibilities: - Copy data accurately from Excel to the database - Ensure all data is consistent and properly formatted Ideal Skills and Experience: - Proficiency in Excel - Experience with Oracle databases - Detail-oriented - Proven track record handling data migration tasks

I'm in need of a professional who's seasoned in Oddo database upgrade. The task involves updating my Oddo database from its current version 14 to 17. - Updating the current version to the latest one with all data carried over ** Please provide some proven exprinance on this area **

I am looking for an expert data entry freelancer who can efficiently and accurately transfer text data into a Microsoft Excel format. - The final delivery should be in a Microsoft Excel file format. - The preferred data structure in the Excel file should be row-wise. - Excellent attention to detail and proficiency in Excel is a must for this job to ensure data is entered correctly. I look forward to working with someone who respects deadlines, has a solid understanding of data entry requirements, and values quality service. This project could lead to long term engagement if successfully completed.

I am currently using MySQL as my database management system which holds a small-sized database. I require an experienced and skilled freelancer to migrate this database to my new EC2 WordPress installation. Ideal Skills and Experience: - Expertise in MySQL and AWS EC2 - Proficiency in handling WordPress installations - Experience in migrating small-sized databases Please note that a backup of the current database is available and must be effectively utilized to perform this project. Expectations include high-quality work with no loss of database data and minimal interruption in service.

I'm looking for a Python developer to create an automation tool for excel report generation Key Requirements: - The tool should automatically process the data and generate excel reports - The reports should be generated in a user-friendly format Ideal Skills: - Proficiency in Python programming - Good understanding of data processing and report generation

I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production dat...

I'm in need of a system that can transform my existing PDF into word file. - The first needs to be a Word document, containing a...Word document, containing a fillable form. This form should encompass text fields, check boxes and date fields, mirroring those found in the original PDF. - The second is an Excel spreadsheet, which is to be linked directly to the Word form. This link should enable automated data transfer between the two, minimising the need for manual data input processes. Proficiency in Word, Excel, PDF conversions and data automation would be ideal for this project. Understanding of complex form creation and Excel-to-Word data linking is also crucial. This endeavour requires precision and a strong attention to detai...

I have 73 PDFs that I need to be converted into separate Excel sheets. The Excel sheets need to follow a specific format, which is in table form with specific columns. Key Requirements: - Convert 73 PDFs into rows of an Excel sheet - The Excel needs to follow a pre-defined format, which I will provide. - The pre-defined format is in the form of tables with specific columns The Excel sheets should contain all the data as shown in the template with a separate summary tab with the following: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard ...

...help me convert a bulk of my purchase invoices from PDF format to Excel. - The PDF invoices are all Text-based and thus, the conversion can be automated. - The original scanned PDF will also be provided if needed. - The Excel sheet should have the following fields: - Vendor information, Invoice number, Invoice date, Purchase details (Product Name, Uom, Qty, Rate, VAT, Total) - I prefer all the invoices to be organized in a single sheet in the Excel file. Ideal skills for this job include proficiency in data extraction, PDF to Excel automation, and a keen eye for detail when it comes to organizing data. A background in finance or accounting would be a plus, as it will help in ensuring the accuracy of the extracted data. Automate /...

I'm searching for a highly skilled Web3 designer to build and launch a Web3 website. This individual should excel in user interface design, creating visually pleasing and intuitive designs for a seamless user experience. Key responsibilities will include: - Developing a user-friendly Web3 website design - Incorporating decentralized identity feature in the website Expertise and Skills required: - Proficiency in Web3 designing - Previous experience with decentralized identity - Solid understanding of Blockchain - Proficiency in user interface design Ideally, you should have an impressive portfolio of previous Web3 design work. Looking forward to a designer who can deliver a high-quality user interface and contribute innovative ideas for site features.

...comprehensive fitness sheets. These should contain detailed information in four key areas: 1. Exercise Descriptions: Detailed information about strength training exercises, including diagrams or images, written instructions, and any necessary safety advisories. 2. Diet Plans: Nutrition recommendations and daily diet plans tailored to support strength training. These may include recommended meals, macro or calorie counts, and advice on supplements if necessary. 3. Progress Trackers: A system for tracking training progress, such as weight lifts, cardio fitness levels, and body measurements. A visually appealing, easy-to-understand format is important. 4. Daily Macros/Calories Checks: A straightforward way for clients to track their calorie intake and macronutrient ratios, which...

As a company, we're currently in need of a seasoned Power BI expert, well-versed in creating engaging dashboards and detailed reports....engaging dashboards and detailed reports. Key Responsibilities: - Develop and design interactive dashboards and reports - Generate in-depth, data-driven reports - Provide data analysis and insights Key Requirements: - Proficiency in Power BI - Strong experience in creating interactive dashboards and detailed reports - Skilled in data analysis and providing insights The project will involve connecting to data sources primarily from Excel spreadsheets. The main audience for the dashboards and reports will be our data analysts. To ensure that you're the right fit for this project, please provide exampl...

...expertise in data handling specifically relating to Excel spreadsheets. The ideal candidate will be responsible for: - Sorting the data to make it more organized and user-friendly. - Cleaning the data. This may entail tasks such as detecting and correcting errors, and potentially removing any duplicates (however, a clear plan on handling this aspect will be shared later in the project, since the specific data cleaning operations were not predefined). - Separating the data as requested. This is a time-sensitive project requiring completion as soon as possible. Therefore, the individual needs to be adept at working under pressure and towards tight deadlines. The perfect fit would be someone with a proven track record handling similar tasks, demo...

I'm looking for an AWS Glue expert to handle my large MySQL database, over 10GB, and write it to S3. You will need to have: - A strong understanding and experience in handling large databases. - Proficiency in using AWS Glue for data ETL processes. - Knowledge in determining the best strategy to quickly load large amounts of data. - Experience working with Parquet output format. The database gets updated daily, so a fast and efficient process is required to ensure optimal performance. Please detail your experience with similar projects when making your bid.

I will do enlisted task. Renovation Brands needs an analytical assistant to support our FP&A department in a variety of tasks. The ideal candidate will have experience with Excel and running/modifying SQL (no need to have experience writing it). Tasks will include things such as downloading data from ERP or SQL, Refreshing files and validating refresh worked, troubleshooting errors in execution, etc.

Investment decision model excel

I'm looking for someone with a solid understanding of the market and strong research skills to help identify multi-brand women's clothing retailers in the UK and USA. The project involves finding both online and physical retailers that also have an online presence. Th...presence. The ideal candidate will have experience in market research, preferably within the fashion or clothing industry, and possess excellent analytical skills. Knowledge of the retail sector is crucial, and having access to premium market research tools would be a plus. Please include details of your experience and your research approach in your proposal. Note that we will provide an Excel sheet for the data, and we are offering $50 for every 1000 records. Please apply only if the budget is ac...

I need a talented statistician to help determine if there is an association between gender and different types of admission sources from the Emergency Department (ED). The analysis will not be limited to a particular admission source. The data for the project will be supplied in an Excel file format. Freelancers are required to have proficiency in Excel and a deep understanding of statistical tests, particularly Chi-Squared tests. In your application, please include: - Your past work relating to statistical analysis - How you plan to execute this project utilizing the Chi-Squared Test - An estimated timeline for completion I look forward to working with you on this exciting project!

I've compiled an Arabic-Chinese dictionary in an Excel file and I'm seeking a skilled developer to convert this into a user-friendly software. This software will be exclusively for laptop or computer use, and should operate offline. Key requirements: - Experience with software development for Windows and Mac operating systems - Proficient in programming languages suitable for offline software - Ability to create a user-friendly interface The ideal freelancer will have experience in developing functional and user-friendly software. I would like this project completed within a month, so I'm looking for someone who can work efficiently, while also maintaining high-quality standards.

We are seeking a highly organized and proactive Web Assistan...stakeholders to discuss updates and resolve issues. Utilize Microsoft Office tools to create and manage content, reports, and presentations. Coordinate with team members to ensure smooth execution of web projects. Manage email correspondence and ensure timely and effective communication. Qualifications: Excellent command of English, both written and verbal. Proficiency in Microsoft Office (Word, Excel, PowerPoint, Outlook). Strong interpersonal skills and the ability to communicate effectively with various stakeholders. Previous managerial experience is highly desirable. Ability to work independently and in a team-oriented environment. Must be organized, attentive to detail, and capable of handling multiple tasks simul...

I'm in need of a freelancer with an eye for detail and proficiency in Excel for a data sorting project. The task involves the following: - Sorting of a large Excel dataset - Understanding of sorting methods with Excel is crucial - Experience in data management would be a big advantage Completion of the project within the next three days is essential. The efficient and quick turnaround is a prime requirement. Let's discuss if you thrive in fast-paced environments.

I need a professional to create a dual-platform dashboard in both MS Excel and Power BI. The primary objective of these dashboards is to monitor the status of multiple projects. Key responsibilities include: - Setup and design of interactive dashboards that display project status in a user-friendly manner. - In MS Excel, the dashboard should efficiently track and report project status. - For Power BI, the focus will be on analyzing project status. Ideal freelancer will have: - Proficiency in MS Excel and Power BI. - Proven experience in creating versatile dashboards. - Strong understanding of project management principles. - Knowledge of data analysis and reporting.

I need an Excel spreadsheet created to store and display information for 200 products. The project involves: - Entering product name, product description, and price for each item - Embedding images for each product in the spreadsheet - Receiving product information and images in a text document Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail - Ability to work with and embed images in Excel - Familiarity with data entry and handling product information Looking forward to working with a skilled freelancer on this task.

As the client, I am looking for an AI-powered scraper engine and database that can efficiently collect data from global small business listings. The project's focus will be on PitchBook Data primarily, and secondary sources may include Crunch Base and CB Insights. Key Requirements: 1. Data Extraction: The scraper should collect information such as Revenue, EBITDA, net profits along with contact information including email, LinkedIn profile and website. 2. Designing AI Database: A smart AI database should be constructed to filter and predict the Revenue, EBITDA, net profits. 3. Prioritization: Initially, the focus should be on extracting data from PitchBook Data. Though, it would be beneficial to later expand this to other platfo...

I'm seeking a knowledgeable individual who can teach beginner-level tutorials focusing on GPT-4 training and the implementation of AI techniques. Since I did not specify any programming languages o...proficient in teaching complex concepts in an easy-to-understand manner. We are looking create a knowledge base within our business that will help us embrace AI moving forwards and enable us to create GPT’s, mainly to extrapolate / merge / compare / reformat data from excel files. We would like to train 3 staff members with the knowledge of how to ultimately create GPT’s to take multiple workbooks of data, extract the relevant information, using GPT to identify and present the specific required information, then maybe reworking that data into a ...

I need an excel spreadsheet developed that can compare my actual expenses against my budgeted expenses and display the variance in currency value. The project is quite urgent and I need it to be completed ASAP. Key Requirements: - Create a tabular representation of my actual expenses vs the... - Develop a similar tabular representation for my budgeted expenses - Calculate the variance between the two in currency value - Display the variance in a clear and visually appealing manner - be able to toggle between different cost centres - be able to select data from different months Ideal Skills and Experience: - Advanced Excel skills and experience in creating financial spreadsheets - Familiarity with financial data analysis and budgeting - Attention to detail and ...

1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.

...have a stack of physical documents that need to be input into an Excel spreadsheet. Your task will be to transfer this information accurately and efficiently. Key Requirements: - Proficiency in Excel: You will need to have a good working knowledge of this software, and be able to use it to create a well-organized database from the information provided. - Attention to Detail: While I don't expect perfection, I do need the data input to be mostly error-free. Accuracy is key. - Physical Document Handling: As I will be sending you hard copies of the documents, you will need to be able to handle and return them safely. This project is great for those with a good amount of data entry experience, and who are confident in their Excel skills. The...

I'm looking for a skilled data visualization expert to create a comprehensive dashboard in Excel based on the following criteria: - Data Visualization: The dashboard should primarily feature line graphs and pie charts to represent the sales data of various organizations. The design should be clean, intuitive and should effectively communicate the insights from the data. - Data Organization: The data should be organized by category, making it easy for the user to understand the performance of different organizations segmented by different categories. I expect the freelancer to have experience in data visualization, specifically in Excel, and should be able to design a dashboard that is not only visually appealing but als...

I'm looking to enhance my Microsoft Excel skills, focusing on data analysis, pivot tables, and macros, to efficiently manage project construction data and create insightful reports. Key Responsibilities: - Advanced Data Analysis: Interpret project construction data effectively. - Pivot Tables Mastery: Create complex reports with dynamic pivot tables. - Macro Proficiency: Automate repetitive data analysis and report generation tasks, boosting efficiency. Ideal Skills: - Proven expertise in Excel, particularly in data analysis, pivot tables, and macros. - Experience with project construction data, financial data or similar. - Strong analytical and problem-solving abilities. - Excellent attention to detail to...

...have a stack of physical documents that need to be input into an Excel spreadsheet. Your task will be to transfer this information accurately and efficiently. Key Requirements: - Proficiency in Excel: You will need to have a good working knowledge of this software, and be able to use it to create a well-organized database from the information provided. - Attention to Detail: While I don't expect perfection, I do need the data input to be mostly error-free. Accuracy is key. - Physical Document Handling: As I will be sending you hard copies of the documents, you will need to be able to handle and return them safely. This project is great for those with a good amount of data entry experience, and who are confident in their Excel skills. The...