Excel macros data manipulation jobs

Seeking a skilled and experienced Data Analyst to sift through unspecified 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 uncover v...

...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 w...

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

... "Dear All, I would like to sue a company called "Trades with Edge", a prop trading firm, for denying me live account access due to alleged "No manipulation" rule violation. My objective is to contest the firm's decision and seek reinstatement of the live account or compensation for the breach of contract. The "No manipulation" rule is: "All challenge and funded accounts are traded on a demo account so we can manage our risk. Your funded account is connected to a real funded account, which you are paid from. To ensure trades can be copied effectively to the real account we can not tolerate any form of manipulation on any account. Manipulation includes but not limited to: Tick scalping – constantly op...

I'm seeking a talented designer who can make a 3D rendering for my rental units. Your tasks will be: - Create a visualization rendering of individual units. The central focus should be the interiors. - Bring the renderings to life with high attention to det...renderings to life with high attention to detail including lighting, textures, and shadows. Ideal skills: - Strong proficiency in 3D modeling and rendering software. - Demonstrable experience in creating high detailed 3D renderings focused on interiors. - Ability to adhere to a specific design brief and create visually appealing and realistic renderings. This project will be a great fit if you excel in creating lifelike 3D representations and have a keen eye for detail. I look forward to seeing your previous work in ...

...1. Provide a document that lists all relevant terminology for IT Asset Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent 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 i...

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 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 hear from you.

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 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 success of this project.

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 ...

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 automo...

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...

...National Stock Exchange (NSE). • Algorithms: The code must incorporate 'moving averages' and the 'relative strength index (RSI)' into its algorithm to generate trading signals. • Data Sources: The software should leverage both real-time data feeds and historical data obtained from APIs to inform its trades. Programming in Python for algorithmic trading and understanding financial markets, especially the NSE, are essential qualifications. Familiarity with trading algorithms such as moving averages and RSI is also necessary. Knowledge of real-time data feed integration and API manipulation for historical data will be highly appreciated. This is a detailed project, and I'm looking for a freelancer who can ...

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

I need assistance with my Python code. My goal is to automate a specific task: extracting and transferring data from one script to another. - You would have to understand data manipulation through Python, as it's very crucial for the successful execution of this task. - Extensive experience with Python libraries and automation is highly desirable. - Familiarity with data extraction would be beneficial. Ultimately, your job would be to streamline the task in such a way that it becomes completely automated, requiring little to no manual intervention. If you're a proactive problem-solver who can think on your feet, apply now.

...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 it...

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

...meticulous training, the model will develop the capability to identify subtle discrepancies indicative of deepfake manipulation, thereby distinguishing between genuine and fabricated content. Key objectives of the project include enhancing the model's accuracy, efficiency, and versatility in detecting deepfakes across diverse scenarios and contexts. Additionally, the project seeks to implement mechanisms for real-time detection, ensuring timely intervention to mitigate the dissemination of deceptive media. Moreover, the project invites collaborative discussion to explore avenues for further refinement and augmentation. Potential enhancements may involve integrating additional data sources, refining algorithmic architectures, or incorporating novel features to bolste...

I'm seeking a profession...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...

...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 development - Experience in working with financial data and ideally in stock prediction - Creative and resourceful approach to sourcing data - Ability to...

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 point. ...

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 pro...

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 im...

...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...

...delivered digitally, we will subsequently have it printed on canvas to emulate an oil painting. Key Requirements: - The portrait should be 24x36 inches in size - The background of the portrait should be a specific location, such as a home interior or a landmark - The style of the portrait should be classic realism Ideal Skills and Experience: - Proficient in digital art creation and manipulation using existing photographs - Ability to convert real photographs to classic realist oil painting style digitally - Experience in creating large scale portraits - Ability to merge different photographs into one cohesive composition - Understanding of creating backgrounds in a specific location - Strong attention to detail and creativity If you have the skills and experie...

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

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 im...

I need an expert in photoshop or another similar program to manipulate an existing family photo. The end goal is to alter the background, inserting a harmonious garden scene with a timber wall, as if we were standing in front of it. The ideal freelancer will have: - Profound experience with photo editing and manipulation - A flair for natural-looking alterations - Skills to create or source a suitable garden scene with a timber wall This photo is extremely important to me, so attention to detail is crucial. I'm looking forward to seeing how you can help make this photo a cherished centrepiece in our home.

...reflect a recent date due to an urgent personal matter. Key requirements: - Change the date on a scanned document without affecting text or other elements of the note. - Ensure the revised version looks natural and realistic, as it may be scrutinized. - Provide the edited note in a digital format that I can use and print if necessary. Experience: - Proven track record in photo editing and manipulation. - Familiarity with editing medical or official documents would be a plus. - Demonstrate discretion and understanding of the sensitive nature of this task. Communication: - I would prefer to communicate updates and revisions through instant messaging. This will allow for real-time feedback and quicker turnaround. If you have the skills and experience required for this task, I...

I need an image edited to add the neck and suit from 'image 2', to 'image 1'. Please keep the black background on image 1. Key points: - You need to be proficient in photo editing software - Attention to detail is crucial - The final result should look natural and professional Ideal skills for this job: - Proficiency in photo editing software (e.g. Adobe Photoshop) - Experience in image manipulation - Strong attention to detail

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 pro...

I'm in nee...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 the aforementioned com...

...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. * Emphasi...

I'm urgently seeking a skilled Photoshop expert who can quickly adjust and manipulate a PDF file. Key Requirements: - Object Removal: The file needs to have specific objects removed professionally while maintaining image quality. - Object Manipulation: Additionally, I require some objects within the PDF to be edited or manipulated as per my instructions. Ideal Candidate: - Proficient with Photoshop: A strong track record of similar work in Photoshop is essential. - Attention to Detail: The ability to seamlessly remove and manipulate objects without impacting the overall quality of the image is crucial. - Time Management: The urgency of this project means the candidate should be able to work efficiently without compromising on the quality of the edits. Please note that the f...

- 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.

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

I need a skilled statistician/data analyst to assist with imputing missing data in a meta-analysis of clinical trials dataset using SAS or Stata (ideally). I can supply the results of 28 trials (with 15 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) Idea...

I'm looking for a 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 manage...

...professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include password protection, restrictions for specif...

We are in in the search for an experienced Angular Developer, ideally with 3 years or more experience. As an Angular Developer, you will be responsible for developing and implementing u... and HTML. Developing product analysis tasks. Making complex technical and design decisions for AngularJS projects. Developing application codes and unit tests in AngularJS, JavaScript, and Rest Web Services. Requirements: 3+ years of experience as an Angular Developer. Strong expertise with HTML, CSS, and writing cross-browser compatible code. Good understanding of AJAX and JavaScript Dom manipulation Techniques. Experience with RESTful services. Experience in JavaScript build tools like grunt or gulp. Experience in TypeScript is a plus. Experience in JavaScript framework like ReactJS/AngularJS ...

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 im...