...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
I'm in need of someone experienced in dealing with Latex templates. My current thesis template with Latex is running into a few problems and I need the proper fixes made. Major issues to be resolved include: - Spacing issues: Both paragraph and line spacing inconsistencies are present. Page spacings (inner, outer, etc.) also need proper adjustments. - Formatting errors: My thesis shows incorrect font styles and sizes, which aren't in line with university requirements and general readability. - Extension of title lengths: The titles for my list of figures, contents, and references need to be extended or modified to properly fit the content. Ideal skills would, of course, include proficiency with Latex, especially when handling document templates. A good gr...
...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
...external links to reputable sources to enhance credibility and provide additional context. Image Optimization: Include relevant images, infographics, and visuals to supplement the text and enhance the reader experience. Optimize image file names, alt tags, and descriptions with appropriate keywords to improve accessibility and SEO. SEO Tools and Plugins: Utilize SEO plugins such as Yoast SEO or Rank Math to optimize on-page elements, including meta tags, headings, and readability. Conduct regular SEO audits using tools like Google Search Console to identify and address any technical SEO issues. Content Management System (CMS) Guidelines: Adhere to specific guidelines and formatting requirements dictated by the chosen CMS (e.g., WordPress, Joomla) to ensure seamless integration an...
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is extr...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.
I'm in need of proficient individuals well-versed in Probability, Calculus, and Data Analysis. Your expertise will aid in achieving three key aspects of this project: Data Visualization, Statistical Modeling, and the creation of Educational Tutorials. Requirements: - Ability to work with a variety of data types: Survey data, Financial data, and Experimental data. - High proficiency in Probability and Calculus for the statistical modeling aspect of the project. - Strong skills in Data Analysis for the purpose of data visualization and tutorial creation. Ideal skills and experience: - Advanced knowledge of Probability and Calculus. - Extensive experience with data analysis, particularly on diverse datasets. - Previous work in statistical modeling and/or educational content creation w...
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding o...
...chiamati su un oggetto. 9. Gestione delle eccezioni La gestione delle eccezioni è un modo per gestire errori e situazioni impreviste durante l'esecuzione di un programma. ``` try: x = 10 / 0 except ZeroDivisionError: print("Errore: divisione per zero") ``` 10. Importare moduli Python offre una vasta libreria standard che include moduli e pacchetti per una varietà di scopi. ``` import math print((16)) # Stampa la radice quadrata di 16 ``` Questo è solo un'introduzione alla programmazione in Python. Con il tempo e la pratica, potrai approfondire i concetti e diventare un programmatore Python esperto. Buon divertimento a programmare!...
I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped ...customization should be advanced, allowing me to set up metrics and views according to my preferences. I'm looking for a skilled Excel expert who has experience in creating similar systems, particularly in the workshop or inventory management domain. You should be proficient in creating complex formulas and functions in Excel, as well as designing user-friendly interfaces and dashboards. Experience with VBA programming would also be a huge plus. Please provide examples of previous similar ...
I'm seeking an expert who is proficient in electrical math to assist me with various tasks. Key responsibilities will involve: - Calculating circuit parameters. - Solving electrical equations. - Analyzing circuit behavior. The ideal candidate should be familiar with different kinds of electrical systems or circuits, including: - Power distribution systems. - Circuit design. - Control systems. Preference will be given to those who are adept at using MATLAB, Python, or Simulink for electrical math tasks. A strong understanding of these tools can come in handy for managing the complexity of the tasks. If this sounds like you, consider submitting a bid for this project. Thanks!
...external links to reputable sources to enhance credibility and provide additional context. Image Optimization: Include relevant images, infographics, and visuals to supplement the text and enhance the reader experience. Optimize image file names, alt tags, and descriptions with appropriate keywords to improve accessibility and SEO. SEO Tools and Plugins: Utilize SEO plugins such as Yoast SEO or Rank Math to optimize on-page elements, including meta tags, headings, and readability. Conduct regular SEO audits using tools like Google Search Console to identify and address any technical SEO issues. Content Management System (CMS) Guidelines: Adhere to specific guidelines and formatting requirements dictated by the chosen CMS (e.g., WordPress, Joomla) to ensure seamless integration an...
...goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is essential. Thank you for your interest, and I look forwar...
1. Hi, please apply if you have PhD or equivalent knowledge or have written AI,math,physics academic paper before! 2. Do you think you can find the answer to this question below? If you can find the answer, I think you have the ability to think through the math. 3. [Removed by Freelancer.com Admin] 4. If you read until here, please include links to your papers in the beginning of your proposal!
I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks depending on the initi...
I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.
As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal ...of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs, I'...
I'm seeking a proficient Mathematics tutor specializing in Number Theory to conduct online one-on-one lessons for a beginner student in India. Key Responsibilities: - Plan and deliver engaging, effective online lessons on Number Theory catering to a beginner level student. - Assess student's under...questions and seek clarification. Ideal Skills and Experience: - Strong background in Mathematics, particularly in Number Theory. - Prior experience in teaching or tutoring, especially online. - Ability to simplify complex concepts for a beginner. - Excellent communication and interpersonal skills. - Patience and empathy in teaching individual students. If you are a passionate and experienced Math teacher who's adept at simplifying Number Theory for beginners, I look ...
I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I need help with solving 40 college-level math problems. The topics include coordinates and basis, diagonalization, eigenvectors and eigenvalues, introduction of linear transformation, row column and null space, the characteristic equation, vector space and subspaces. It's not a crazy assignment, just a bunch of problems that I don't have time to solve. Ideal Skills & Experience: - Proficiency in College-level Math - Understanding of coordinates and basis, diagonalization, eigenvectors and eigenvalues, introduction of linear transformation, row column and null space, the characteristic equation, vector space and subspaces. - Ability to provide correct, concise answers without detailed explanations. - Familiarity with various mathematical notations.
...year olds using characters created for our existing children’s books. The primary focus of the app is adventure based and might incorporate so early learning like Numbers and Basic Math, Shapes and Colors. Key Requirements: - Development: The ideal candidate should be experienced in developing kid-friendly, intuitive, and interactive mobile games for iOS and Android. - Design: Strong design skills are crucial to ensure the app is visually appealing and engaging for the target age group. - Educational Content: A good understanding of early childhood education, particularly in the areas of Numbers and Basic Math, and Shapes and Colors, is essential. - User Experience: The app should be easy to navigate, with appropriate feedback and reward systems to encourage learnin...
I'm looking for a skilled professional to help me generate leads for my tutoring services. I focus on tutoring students from Year 1 to 10 in Math and English. Key Requirements: - Lead Generation: The candidate should have a proven track record in generating leads in the education sector for franchises. - Since I currently generate few of my leads through social media, I need someone who is proficient in providing alternate channels other than social media to generate leads - Understanding of Education Sector: An understanding of the education sector and the specific needs of students in Year 1 to 10 will be an added advantage. If you have experience in lead generation,, and a good understanding of the education sector, I'd like to hear from you. Let me know about si...
I need a professional resume writer to write IT resume using LaTex. Key Requirements: - Experience in writing resumes for IT professionals - Expertise in using LaTex to design and format resumes - Capability to provide 3 to 4 different resume designs, all condensed in a maximum of 2 pages each - Need editable final LaTeX files delivered - Proven track record of success in crafting resumes tailored to various IT specialties, including but not limited to software development, cybersecurity, network engineering, and data analysis. - Familiarity with ATS (Applicant Tracking Systems) and the ability to optimize resumes to increase the likelihood of passing through these systems. - Flexible and responsive to client feedback, with a commitment to refining and revising resum...
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel
...from front running by zee business. Headline "Should you trust are TV Channel Analysts". Link will be provided - Change Youtube layout to horizontal instead of vertical (add youtube & twitter feed into website also) - Make twitter/facebook/instagram layout horizontal with last 4/5 posts visible only. In main website - Setup SEARCH console for google analytics etc via Rank Math SEO for both websites. Remove all duplicates - so that only one property is there for each website. - I expect the freelancer to integrate this content seamlessly into the current design, whilst keeping page layout professional and clean. 2. Website Speed Improvement: - Identifying factors causing slow load times. - Implement solutions to significantly improve site speed (reference vs curren...
I'm seeking a skilled ML Engineer to create a Mobile application based on AI/ML technologies. The final product will be targeted towards the general public. Responsibilities: - Design...towards the general public. Responsibilities: - Design and develop machine learning and deep learning systems - Run machine learning tests and experiments - Implement appropriate ML algorithms - Analyze and improve existing models Requirements: - Proven experience as an AI/ML Developer or similar role - Understanding of data structures, data modeling, and software architecture - Deep knowledge of math, probability, statistics, and algorithms - Ability to write robust code in Python, Java, or R - Excellent communication skills Compensation: Salary details will be discussed during the inte...
I am in immediate need of a freelancer skilled in VBA & .net for the development of a yet disclosed project. The ideal candidate must be proficient in all aspects of VBA and have the ability to deliver quickly given the urgency of this project. Key Requirements Include: - An in-depth understanding of VBA - Proven track record of successful projects - Ability to work under tight deadlines Completion of the project needs to be as soon as possible. If you have extensive VBA experience and can work in a fast-paced environment, I enthusiastically encourage you to bid on this project.
...and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previ...
...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 data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if f...
Se realizará un script de python el cual permitirá automatizar un proceso de creación de libros de excel de acuerdo al flujo existente de unas macros, adicionalmente el programa debe ser capaz de ofuscar el código de vba e impedir la edición del mismo, El proyecto se realizará en google colab, de forma que pueda ser ejecutado desde cualquier dispositivo con conexión a internet y cuente con acceso al programa.
I need a skilled marketer to help me increase sales of my K-8 educational publications. Key Points: - **Target Audience**: The primary target audience for the K-8 publications we produce are teachers and school administrators. Experience in educational marketing would be a huge plus. - **Subjects Covered**: The publications cover Math, Science, Language arts and History. Experience in marketing these subjects is a plus. - **Main Objective**: The main goal is to increase sales outside of the current schools that already purchase our materials. We are a national, nonprofit organization with a staff of 25 employees that has been successful to date with advertising our materials on our website, including making many of our publications available for free download, as well as by sendin...
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.
Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and accuracy.
My website URL Headline is displaying as domain_name<dot>in I want to display my company name rather than the domain name. I use WordPress and RankMath. I have edited it in RankMath but didn't fix the problem. I want any WordPress expert to rename the domain name to a Custom Company Name. The Task must be done via Anydesk. The budget is Rs.1000/-.
I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the pro...
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding - Strong unders...
To win this contest you will need to have 5 selected design related to "Zero-Knowledge Proof" or "ZK Proof" concept which is a Blockchain and Cryptography and Math related topic. So feel free to be creative and not just stick to simple typography. I am willing to purchase as many as 60 designs at the same rate, so we might get multiple winners or I will deal with you after the contest ends. Capitalisation: either "Zero-Knowledge Proof" or "ZERO-KNOWLEDGE PROOF" Here are the quotes you can choose from: Zero-Knowledge Proof: Because my secrets are too good to share. I'm like a Zero-Knowledge Proof — complex, mysterious, and verifiable Trust me, I'm a Zero-Knowledge Proof expert. No further questions, please. Zero-Knowledge ...
Develop VBA code to meet your requirements
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I&...
I'm in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the macros ...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
