Excel macro csv cells jobs

I have a list of addresses in an Excel file that need to be formatted and transferred to a Word document for printing on generic sheet labels. Specific Requirements: - Use a generic sheet label format. - The list contains between 100 to 500 addresses. - Format the addresses in a single column on the labels. Ideal Skills: - Proficiency in Excel and Word. - Prior experience with label printing. - Attention to detail to ensure all addresses are correctly formatted and transferred.

I'm looking for an experienced app designer with expertise in PowerApps, MS Office 365, and Excel. Key Requirements: - The app should be compatible with Windows, iOS, and Android. - The app should include functionalities such as data visualization with charts and automated workflows. Ideal Skills: - Proficient in PowerApps, MS Office 365, and Excel. - Experience in designing cross-platform apps. - Ability to incorporate data visualization and automated workflows into app design.

...using personal capital. - Conduct in-depth analysis of assets available on , including cost per square foot and typical expense percentages. Data Sources: - You will be provided with brochures from sellers, personal notes and research, as well as country-specific information including taxes and other relevant factors. Ideal Skills and Experience: - Extensive knowledge and experience in Excel financial modeling. - Familiarity with commercial real estate assets preferred but not mandatory. - Ability to learn quickly and understand new assets. - Strong analytical skills and attention to detail. This project requires someone who can not only crunch numbers but also develop a good understanding of the assets being evaluated. Your expertise will be key in determining the most suita...

I need a freelancer to help me transcribe 2-3 pages of my bank statement into an Excel file. Please format the data into separate columns for Date, Description, and Amount. Additionally, I need the balance after each transaction included in the Excel file. Specific Requirements: - The data should be transcribed into columns for Date, Description, and Amount. - The balance after each transaction should be included. Formatting: - The Excel file should use standard grid lines and font. Ideal Skills: - Proficiency in Excel - Attention to detail - Data entry experience

I'm seeking assistance with manual data entry into a Microsoft Excel spreadsheet. The task involves inputting information accurately into a database. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry and database management Please, only apply if you're able to maintain high accuracy while working under deadlines.

This program is to be an unpublished, separate tool for my website for asset valuation: www.maskinvurdering.dk. I have prepared a 6 page description of the project, which I have attached. I am interested in firm bids only. Placeholder bids are not to be considered genuine bids and such bids will not be considered.

...development experience to help build an innovative Battery Management System (BMS) for Lithium-ion batteries. The hardware will be provided by me, and the mobile app development is taken care of by my team. Your key responsibilities will include: - Embedded programming for the BMS system - Creating an API for the BMS system The BMS should be able to: - Display all battery cells on the mobile app. - Identify and highlight damaged cells in real-time. - Monitor and display the battery output performance. - Track and alert for overcharging or undercharging events. - Include standard features typically available in advanced BMS solutions. Communication Protocol: The BMS will use Bluetooth for communication. Real-time Data Metrics: The system needs to monitor and display all...

...Demonstrated skill in conducting comprehensive research on diverse topics such as AI, stock markets, and market trends. • Advanced knowledge and use of Generative AI models such as ChatGPT. • Proficient in managing personal tasks, including booking appointments, organizing family holidays, and developing personal branding initiatives. • High proficiency in Microsoft Office applications (mainly Word, Excel, and PowerPoint), ChatGPT, and familiarity with digital content management systems for maintaining websites (WordPress). • Experience in handling confidential information with the utmost discretion and integrity. • Educational background in business administration, marketing, or related fields is preferred. Working Hours and Duration: • This is a re...

I'm looking for an Excel VBA expert to help me with a local Excel file. The task involves creating a script that will filter data in a pivot table based on specific criteria. Ideal skills and experience: - Proficient in Excel VBA - Experienced in working with pivot tables - Strong understanding of data filtering techniques - Ability to write clean, efficient code

I'm looking for a skilled VBA programmer to create a dynamic filter function for my Excel pivot table. The data source is an Excel workbook and the pivot table is primarily dealing with numeric data. Key Requirements: - Create a VBA code that allows the pivot table to filter numeric data based on custom criteria. - The filter should be dynamic, adjusting as the data changes. Ideal Skills and Experience: - Proficiency in VBA programming with a strong understanding of Excel pivot tables. - Experience in creating dynamic Excel functions. - Ability to understand and implement custom filtering criteria.

I'm seeking a skilled data scientist to create a full Machine Learning model using SVM, GA-SVM (Genetic Algorithm Optimized SVM), and gcForest. The task involves evaluating their performance based on the following metrics: Accuracy, Precision, Recall, F1-Score, and AUC-ROC. The validation method to be employed is Stratified K-Fold Cross-Validation. Key Details - Dataset: Custom dataset in CSV format - Preprocessing: The dataset is already preprocessed, so no additional handling of missing values or feature scaling is necessary. Ideal Skills - Proficient in SVM and gcForest - Experience with Genetic Algorithms - Strong understanding of performance metrics - Familiarity with Stratified K-Fold Cross-Validation Project deadline: 2 weeks (if possible)

...seamlessly appended to the database without overwriting existing records. • Implement deduplication processes to avoid redundant data entries. • Maintain timestamps to indicate when data was last updated. 4. Optimization and User Access • Optimize the database for high-speed querying using indexing, normalization, and caching. • Include features for filtering, sorting, and exporting data (e.g., CSV or Excel formats). • Develop a user-friendly interface (if required) for accessing and analyzing data. • Ensure secure authentication and access control mechanisms. 5. Testing and Maintenance • Conduct thorough testing of the database and web scrapers under multiple scenarios to ensure reliability. • Establish a maintenance plan...

...fillable PDF form incorporating numerical data from Excel. The form will require several advanced functionalities including: - Formulas for calculations: This is crucial as the form needs to carry out certain computations based on the input data. - Conditional formatting: The form should be able to visually represent changes based on different conditions. - Data validation: The form must ensure that the inputs meet certain criteria, helping to maintain the integrity of the data. The integration of the Excel data into the PDF form will be done through manual input. Therefore, the design should facilitate ease of use and accuracy during this process. Ideal skills and experience for this job include: - Proficiency in Adobe Acrobat and Excel - Experience in creatin...

We are working on a project that collects data through surveys aimed at understanding trends, traveler preferences, and satisfaction levels within the tourism sector. Currently, the process involves manual work using Excel, which is time-consuming and inefficient. To address this, we aim to develop a system that automates data preparation, classification, and visualization (using POWER QUERY), thereby enhancing accuracy and decision-making capabilities. The overarching goals of the project are: of Dashboards in Power BI Building interactive dashboard(s) to present various analyses, key questions, and insights, supported by constructed indicators, DAX formulas, and other advanced features. Statistical Indicators Generating descriptive statistical measures (e.g.,

I'm in need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Back Office Support.

...calculation, clarifying the practicality and utility of each element within the model and highlighting the added value it provides. Data Requirements The software will be based on the BTC-USD price history from the past 5 years. The data should be continuously updated, and a daily granularity is recommended. It is preferable to directly implement data retrieval using yfinance, avoiding reliance on a CSV file for management. Feature Engineering The extracted features should include: • ATR (Average True Range) • Bollinger Bands • Moving averages • Logarithmic returns (Additional suggestions and implementations are welcome.) For this specific part, training an LSTM model is advised. Modeling 1. Train a GARCH(1,1) or GARCH(2,1) model on the logarithmic returns ti...

I need to work in a excel doc to do a macro to calculate new prices and add some other information.

*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.

I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.

I'm in need of a skilled professional who can help with the extraction of text from my PDFs. This is an ongoing project with new PDFs coming in regularly. I need the code in a Colab notebook that i can run myself and upload new PDFs to run text extraction. Key Requirements: - Extract all text from multiple PDFs. - Store the extracted data into a CSV or data frame. Ideal Skills: - Proficiency in Python or similar languages for data manipulation. - Previous experience in text extraction from PDFs. - Familiarity with data cleaning and preparing data for analysis. The ability to work on a consistent basis and deliver high-quality work promptly is essential. Please provide examples of similar projects you've completed in your proposal. Example PDF is attached,

...from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

I need to create an output csv file in a template

...from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

...**trading volume** data of the stock. - **Technical indicators**: Create various **technical indicators** for the stock data. For example, **Moving Average (MA)**, **Relative Strength Index (RSI)**, **MACD**, **Bollinger Bands**, etc. - **API Utilization**: To obtain stock data, you can use **Yahoo Finance API**, **Alpha Vantage API**, **Quandl**, etc. to get real-time data, or save data locally as a **CSV file**. ```python import yfinance as yf # Example: 5 years of Apple stock data data = ('AAPL', start='2015-01-01', end='2020-01-01') print(()) ``` ### 3. **Calculating technical indicators** AI basically learns through **technical indicators**. For example, it can calculate indicators such as **Moving Average**, **RSI**, **MACD**, etc. These ind...

Pull all data of each publisher as we discussed + create an excel file as you did in the previous job. Delivery in on january 20th

...website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

I'...need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Key Responsibilities: - Data entry of customer information - Email management - Spreadsheet work, including the use of pivot tables and advanced functions in Excel Ideal Candidate: - Familiar with MS Excel and Outlook - Capable of handling basic to intermediate data entry tasks - Able to manage emails efficiently Please provide your hourly rate, inclusive of all fees. The workload might be ong...

I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.

I have multiple CSV files containing data downloaded from an SAP tool. The primary focus is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons. Your expertise and ...

I have a PDF file containing financial data that needs to be converted into an Excel spreadsheet. The data is structured in tables within the document. Ideal Skills: - Proficiency in Excel - Data conversion from PDF - Attention to detail Experience: - Prior projects involving financial data preferred - Experience with PDF to Excel conversion

I'm seeking an Excel expert to enhance a self-grading Excel sheet for beginner students. The goal is to make it more visually appealing and user-friendly based on an example file I have. Key Requirements: - Quick turnaround time (within 2 hours) - Experience in Excel - Ability to implement visual improvements such as color coding, formatting, and graphical elements - Potential for future projects if work is satisfactory The primary function of the Excel sheet will be visual data representation. Please apply if you can meet the requirements and deliver promptly.

I'm in need of a freelancer who can extract text from a PDF into an Excel Spreadsheet. The job requires basic cleaning and formatting of the data in the spreadsheet. Key Tasks: - Text extraction from PDF - Inputting data into Excel - Basic cleaning and formatting of the data Ideal Skills: - Proficient in Excel - Attention to detail - Previous experience with data extraction from PDF Looking forward to your bids.

Hi there, I need someone to manually copy and paste text and numbers from tables in a 90-page PDF document into an Excel template with five predefined columns. Key Requirements: - Combine split sentences into a single line. - Leave a blank line between paragraphs. - Adhere to specific formatting requirements as per the predefined template. Ideal Skills: - Excellent attention to detail. - Proficient in Excel. - Able to follow specific instructions meticulously. Flat rate 5 NZD Bonus: 5 NZD bonus for error-free, on-time delivery. Deadline - one day i.e. 15 Jan 25 Please start your bid "5NZD" I appreciate you reading my post

I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.

...a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with stakeholders to gather requirements and deliver solutions. Required Skills: Proficiency in Power BI and ...

I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date Clock-in Clock-out ...

...understand: we are not separate from the world’s rhythm; we are its echo. Harmony is not perfection. It is the truth of interconnection. It is the story of life itself."* Scene Descriptions Opening Scene (0–10 seconds): A slow, aerial shot of a vast desert, the sun low on the horizon casting long shadows. The camera pans to reveal a single tree thriving in isolation. Transition (10–20 seconds): A macro shot of dew forming on the edge of a leaf, each droplet trembling before falling. The camera follows the drop as it merges with others in a flowing stream. Middle Scene (20–40 seconds): A montage of natural contrasts: A volcano erupting, its fiery glow mirrored by the calm ocean nearby. A close-up of a lion’s eye, followed by an image of an a...

I'm seeking an expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I ... Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company Name, Email, Mobile Phone, Linkedin acount

I need a visual dashboard created from my Excel financial data. This dashboard will primarily be used by executives, so it needs to clearly display cash flow and ROI information. Key Requirements: - Proficient in Excel and dashboard creation - Ability to visualize complex data simply and effectively - Prior experience working with financial data Ideal Skills: - Data analysis - Financial literacy - Excel expert - Dashboard design

I'm seeking a skilled professional to perform a detailed takeoff from my bluepr...comprehensive material list of quantities and costs breakdown for all trades, including electrical, plumbing, and carpentry. The final output should be an Excel spreadsheet, as I prefer this format for data analysis and budgeting. Key Requirements: - Proficient in reading and interpreting blueprints - Experience with construction material takeoffs - Familiarity with costs associated with various trades - Excel spreadsheet creation and data organization skills I do not have a specific template for you to follow, so creativity and an understanding of how to best structure the data will be key to your success in this project. Please ensure the Excel document is clear, logically organ...

Please Sign Up or Login to see details.

I'm looking for a skilled Excel professional to help automate my spreadsheet, which I've been manually updating with annual measurement data (3D coordinates). The spreadsheet involves regression analysis and generating charts. Key tasks that need automation: - Updating formulas: Currently, I have to re-input the formula to accommodate the new data each year. - Data input: I want it to be as simple as entering the new data and the spreadsheet updates itself. - Chart generation: The spreadsheet produces various charts from the data, which currently requires manual intervention. - Running regression analysis: The spreadsheet includes regression analysis which needs to be automated as well. Ideal skills for this project include: - Proficiency in Excel, especially with...

We have a platform in PHP and MySQL to manage the services we provide but we have never used it. Currently we manage everything with Excel but there are already many records and various people who work on the file. I need to load our excel database into the MySQL database and start using the tool. The excel database has 20.440 rows and 43 columns.

I'm seeking an expert in financial modeling with Excel to help construct a comprehensive analysis model for a retail center development project. This project will involve a construction loan, refinancing, and utilizing land equity from the landowner. Key Requirements: - Develop cash flow projections on a monthly basis. - Include critical financial components such as the Profit and Loss statement and Loan amortization schedule. - Conduct sensitivity analyses for interest rate changes, construction cost variations, and market rental rate fluctuations. Ideal Skills: - Proficiency in Excel, with advanced financial modeling skills. - Experience in retail development project analysis. - Ability to conduct and interpret sensitivity analyses.

I have an Excel sheet containing financial data including income and expense ledgers, as well as indicators of the company's growth. I need someone to transform this data into detailed management accounts. The project requires the creation of clear and insightful charts, as well as the data being presented in an easy-to-read format. Key Requirements: - Bar charts, Pie charts, and Line charts to be created from the data - Focus of the charts on income and expenses - Data presented in a Quarterly comparison format. - profit growth Ideal Skills: - Proficiency in Excel - Experience in financial analysis and creating management accounts - Ability to create clear and insightful charts and graphs - Skills in presenting data in an easy-to-read format.

I'm seeking a skilled Excel developer to enhance my "Employee Attendance Record" template. The purpose of this project is to add specific tracking capabilities to the template. Key Modifications: - Change Calendar View closed dates from Sat,Sun to Sat,Wed. - Add HRs row to List of Employee TAB and display hrs on Calendar View - Track lateness by add to List of Employee TAB, display on Calendar View Ideal Skills: - Proficiency in Excel - Experience with customizing Excel templates - Ability to implement specific tracking features I need someone who's detail-oriented and understands how to improve an Excel template for specific HR tracking needs. Please, provide examples of similar work you've done.

Private Facebook Group Expert Wanted for Consultation and Strategic Guidance Start Date: Within 1–3 days Deadline: Project to be completed within 3 days No-exception Requirement: Must be fluent in English and have 9...automated versus those requiring manual handling. Ideal Candidate Extensive experience managing large, active Facebook groups (preferably 300k+ members). Expertise in Facebook’s tools, analytics, and monetization strategies. Strong understanding of Facebook’s TOC to ensure compliance. Excellent communication skills for clear and actionable recommendations. If this sounds like a project you can excel in, apply now! We’re excited to partner with the right expert to unlock the full potential of our Facebook group. Note: A doc of this job post is...

I need a professional with experience in data conversion to help me transform a mixed content PDF form document into an Excel file. The document contains both text and tables, but the text formatting is simple, consisting of plain text without any complex elements. Key Requirements: - Converting mixed content (text and tables) from PDF to Excel - Maintaining specific formatting from the PDF in the Excel file Ideal Skills: - Proficiency in Excel - Experience with data conversion from PDF to Excel - Attention to detail to ensure accurate formatting

I'm on a journey to become a certified Microsoft Office Specialist in Excel at the Associate level and I need your expertise. Ideal skills: - Proficient in Microsoft Excel - Familiar with GMetrix testing platform - Experience in teaching or coaching - Ability to create a tailored study plan - Knowledge of Microsoft Office Specialist certification process What I need: Someone to do it all for me Your role will be to get me certified and ensure I pass the tests with flying colors.

I'm looking for a data analyst who can dive deep into my transactional data in Excel to understand gender-wise market trends. The primary focus will be on: - Gender-based purchasing patterns - Product preference differences between genders - Profitability analysis based on gender demographics Your expertise in data analysis and familiarity with Excel will be crucial for the success of this project. Please be ready to provide insights that can help shape our marketing strategies and product development.