Excel macros manipulate internet jobs
...Vendor/contractor database for outsourced maintenance or repairs. • Assign tasks to staff/vendors and track progress/costs. 8. Advanced Analytics • Occupancy trends, vacancy patterns over time. • Maintenance cost analysis (by property/unit). • Potential for predictive insights (rent forecasting, AI-driven maintenance). 9. Import/Export & Data Migration • CSV/Excel bulk-import for existing records (properties, tenants, etc.). • CSV/Excel export for accounting, sharing with partners, or offline analysis. • Simple data migration tools to ease transition from legacy systems. 10. Security & Compliance • Role-based access control, encrypted credentials, and secure endpoints. • Audit logging (track who edited what ...
I need a UAT tracker created in Microsoft Excel based on provided user test scripts. The tracker should include a Summary Dashboard and categorize test scripts by module. Key Requirements: - Create a UAT tracker and Reporting Tool in Microsoft Excel. - Include a Summary Dashboard. - Categorize test scripts by module. Ideal Skills: - Proficient in Microsoft Excel. - Experience with User Acceptance Testing (UAT). - Ability to create comprehensive dashboards.
IPLS is a company specializing in Purchasing, Logistics, and Consulting, based in Bucharest, Romania, with a subsidiary in Paris, France. Purchasing Activities: Sourcing and Qualification of Partners Operational Management of Purchasing Categories (purchases on behalf of clients) Monitoring and Surveillance of Suppliers Definition and Structuring of Needs and Specifications Organization and Transformation of the Function Management and Optimization of Expenses Definition and Implementation of Dedicated Purchasing Platforms Delivery of Embedded Services Management of Specific Projects Expediting of Purchase Contracts Logistics Activities: Design of specific solutions for all types of Packaging Purchase and supply of standard and specific Packaging Study of flow and logistics organizatio...
...[Specify the data fields you need, e.g., Seasons, Matchday, Results, Match Summary, Opta Points, Match Details, Venue, Attendance, Referee, date, Goal Assist, Cards, Cross ,Foul won, Foul conceded, Goal/Own Goal, Interception ,Offside, Pass, Penalty (Won, Conceded and Taken), Shot, Shot on target, Shot off target, Tackle, Save, Penalty Save] 3. The data should be delivered in [desired format, Excel, CSV]. 4. Ensure the script is reusable for future updates and scraping. 5. Follow best practices for web scraping, including respecting the website's terms of use. **Skills Required:** - Web scraping (e.g., Python with BeautifulSoup, Selenium, Scrapy). - Data cleaning and formatting. - Automation and script optimization. Deadline: [31-1-2025]....
...something more in the future, i want to start off with IOS and android. Key Features: • QR Code Scanning: Users can scan QR codes on gym machines to access relevant workout details. • Device Independence: The app should not be restricted to only IOS/Android - but for now: IOS/android phones. • Offline Mode: The app should store essential data locally, allowing users to log workouts without an internet connection. Logged sessions should sync automatically when the device goes online. • Deep Linking & Universal Links: QR codes should open the correct section within the app, even if the user is redirected from an external source. • User-friendly UI: A simple and intuitive interface for scanning QR codes, viewing workout details, and tracking progr...
...all inter-account transfers are accounted for without duplication. Provide a detailed ledger of categorized transactions for easy reference. Output Requirements: An Excel file with clearly labeled sheets for raw data, matched transfers, unmatched transactions, and categorized summaries. A summary report highlighting key insights and any discrepancies. Skills Required: Advanced proficiency in Excel (including formulas, pivot tables, and lookups). Experience in financial data analysis and reconciliation. Strong attention to detail and ability to work with confidential information. Deliverables: A consolidated and reconciled Excel workbook. A summary report with key findings and recommendations. Additional Information: I will provide the raw transaction data from al...
I'm in need of an Excel expert to assist with various financial tasks. This includes: - Creating budget spreadsheets - Analyzing staffing costs - Generating financial reports I will also require some custom Excel formulas to be created. The level of automation needed is basic, primarily using standard formulas. Ideal candidates for this project should have: - Extensive experience with Excel - Proficiency in creating budget spreadsheets and analyzing financial data - Ability to create custom Excel formulas - Basic understanding of automation using Excel formulas
Need some one to quickly edit and format our googel docs. add some relevent images from internet change colours heading add images in googel docs to make it look good. Google docs expert can do in few hrs Need it urgent exper google docs exper needed will share google docs once you confirm
I have a 30-page document containing text and numbers that needs to be converted into a basic Excel table. The table should be structured with rows and columns, following predefined headers from the document itself. Ideal Skills: - Proficient in Excel - Experienced in OCR technology - Attention to detail - Ability to follow specific instructions Please note, the document will likely present some challenges for OCR due to its complexity. Therefore, a freelancer with strong problem-solving skills and patience will be highly valued.
...skilled data analyst and visualization expert to create an interactive dashboard to track and analyze my online sales data. The dashboard should connect to a variety of data sources, primarily my sales database. Key Responsibilities: - Use complex parameters to drill down in the worksheet and customize using filters and slicers. - Create connections, join new tables, and perform calculations to manipulate data and enable user-driven parameters for visualizations. - Use different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicer, etc.) The primary purpose of this dashboard is to track sales performance. Therefore, it is crucial to include and highlight the following sales metrics: - Tota...
...and categorizing customer reviews into: Positive remarks (what customers like) Negative remarks (what customers dislike) Additional Data Points: Product name Price Availability (in stock/out of stock) Retailer name & website URL Product specifications Customer ratings (e.g., average rating, number of reviews) 2. Data Processing & Output: Output the review remarks in a structured format (CSV, Excel, or JSON) Categorize review feedback (e.g., common positive and negative themes) Optionally provide sentiment analysis (if possible) Skills Required: Web scraping (BeautifulSoup, Scrapy, Selenium, or other tools) Data analysis (Natural Language Processing for review classification is a plus) Handling e-commerce website structures and anti-bot measures Delivery Time & Pr...
...into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: Data must be entered in Excel - Accuracy Standards: High level of accuracy is required - Deadlines: Timely completion of the project - Specific Software: ...
...researcher. The book has received excellent reviews and has the potential to reach a wide audience. Key Responsibilities: - Utilize various social media platforms including Facebook, Instagram, TikTok, and others to promote the book creatively. - Identify and engage with online influencers who would be interested in introducing the book to their networks. - Explore and implement other innovative internet marketing strategies to drive sales. Ideal Candidate: - Proven experience in digital marketing, particularly in promoting books or similar products. - Excellent understanding of social media platforms and influencer marketing. - Creative and resourceful, with a knack for out-of-the-box thinking. - Ability to drive book sales, with a commission structure of 20% of book sales. Y...
Please show ...create a dashboard for visualizing user analytics in a comprehensive and engaging way. Key Requirements: - Use of React framework to build a responsive and interactive dashboard, Visualization of data through charts and graphs. - Select, upload excel in UI and work all Excel Formulas like Lookups, Aggregates, Database Tables, to display tabular and tiles, widgets - Integration of user demographic and usage pattern data into the dashboard. Requirement is in Two pages, I will share with those you have already worked on the React Dashboards with Excel Integrations. Ideal Skills: - Proven experience in React development, preferably with dashboard creation. - Strong understanding of user analytics and data visualization techniques. - Ability to design in...
...*************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. It cannot be "done using AI" . Please do not waste your valuable time trying to do either. The task: There are Some handwritten notes with approximately 1000 records. These are student data for a school in India. Your task is to neatly organise and write the data into an Excel worksheet. You will create 1 separate worksheet for each class, e.g., : 1. Nursery Section A 2. Nursery Section B 3. Clas...
I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
...content is critical. This will aid in building a community and providing feedback for businesses. - Attorneys Profile Pages: Each attorney should have a dedicated page containing pivotal information. - Map: Integration of a mapping system to guide users to physical locations. - Offline Access: Some business profiles should be accessible offline, enabling users to view information without needing internet connectivity. - We need two sign in/log in interfaces, one for users and one for the attorneys. - High Security - Multi language feature - Both Android and iOS - Need quote app only, and quoted for website + app - Confidential and copyrights agreement is a must Ideal candidate for this project should have substantial experience in mobile app development, particularly in creat...
I'm in need of assistance with document creation and editing in Microsoft Word, specifically for creating and editing reports. The ideal candidate should have a strong proficiency in Microsoft Office applications, particularly Word, Excel, and PowerPoint. Key Responsibilities: - Assist in the creation and editing of reports - Incorporate images and tables into the reports Ideal Skills: - Proficiency in Microsoft Word for document creation and editing - Experience in creating and editing reports - Ability to incorporate images and tables into documents - Strong attention to detail - Excellent communication skills
I'm looking for a web-based system that detects sports betting arbitrage and positive EV opportunities (both pre-match and live) across all sports and every betting market, on the betting sites I am attaching in an Excel sheet. The layout should be similar to that of , see picture attached. I have 647€ in my freelancer account, that is my maximum budget for this project. I have a Linux VPS server subscription, the system should run on that server. Key Features: - Web-based platform: The system should be accessible and fully functional on the web. - Comprehensive sports coverage: The system must cover every sport, not just football, basketball, and tennis. - All betting markets: The system should be able to identify opportunities in every betting market, including match r...
...looking for a talented graphic designer to create bold, nostalgic Y2K and retro-inspired designs for a print-on-demand apparel and accessories brand. The designs will be used on t-shirts, hoodies, tote bags, and phone cases. Design Style & Inspiration: Your designs should capture the vibrant and nostalgic aesthetic of the early 2000s internet era, including: ✅ Bright neon colors (hot pink, lime green, electric blue, purple). ✅ Pixelated text and retro internet graphics (AIM chat bubbles, MySpace, dial-up modems). ✅ Cybercore & Vaporwave aesthetics (checkered patterns, glitch effects, 3D wireframes). ✅ 90s/early 2000s pop culture references (flip phones, Tamagotchis, low-res graphics). Sample Phrases for Designs (Typography Focused): ? "BRB, Dial-Up In Progre...
...Develop and deliver comprehensive reports and interactive dashboards. Data Sources: The dashboard will need to pull data from a variety of sources, including: - Excel files - Tenica - HubSpot - BCI - PDF - CRM Database - Workflow - POAP/Project on a page/XL Integration Requirements: The following data sources need to be integrated into the Power BI dashboard: - Excel files - HubSpot - CRM Database Skills and Experience: - Proven experience with Power BI is a must. - Data visualization and analysis skills are crucial. - Prior experience integrating various data sources into Power BI is highly preferred. - Proficiency in handling Excel files, HubSpot, and CRM databases. - Strong understanding of finance and sales data will be an added advantage. Please provide exa...
I need a 600-page pdf written in Microsoft Excel for record-keeping, specifically for inventory data. The document must include: - Item names and quantities No formulas or complex Excel functions are required. This project is ideal for freelancers with excellent attention to detail and experience in data entry and inventory management.
I'm in need of a reliable and efficient data scraper who can pull order details from my Aliexpress account into an Excel file. The scraper should allow me to manually set a date range for the data I want to extract. -Data Requirements: I will provide a template for the data. - Frequency of Task: I would like the scraper to be user-friendly enough so that I can set a start and end date for future data scraping tasks each time I run the scrapper. Ideal skills for this project include experience with web scraping, familiarity with Aliexpress, and proficiency in Excel. A good understanding of data handling and the ability to create a user-friendly interface will be an added advantage. I have attached below a sample of output file
I need a flyer for an event I'm hosting, a social gathering or party. I have all the necessary details and a few logos to be incorporated into the design. One of the...gathering or party. I have all the necessary details and a few logos to be incorporated into the design. One of the logos will need to be adjusted to have a clear background. The desired style for this flyer is 'casual and fun'. The perfect freelancer for this job should have: - Experience in graphic design, particularly flyer creation - Proficiency in design software - Ability to adjust and manipulate logos as needed - A keen understanding of creating designs that fit a specific theme or style. I'm looking for a creative professional who can transform the event details and logos into an engag...
...skilled data analyst and visualization expert to create an interactive dashboard to track and analyze my online sales data. The dashboard should connect to a variety of data sources, primarily my sales database. Key Responsibilities: - Use complex parameters to drill down in the worksheet and customize using filters and slicers. - Create connections, join new tables, and perform calculations to manipulate data and enable user-driven parameters for visualizations. - Use different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicer, etc.) The primary purpose of this dashboard is to track sales performance. Therefore, it is crucial to include and highlight the following sales metrics: - Tota...
My Excel sheet requires some urgent formatting adjustments to properly calculate and display the gross profit (GP) of items. Key Issues: - Formatting problems predominantly in the cells and tables Necessary Skills: - Advanced Excel expertise - Experience with data validation and conditional formatting - Attention to detail to ensure accurate GP calculations Your role will be to troubleshoot and rectify the formatting issues to ensure the sheet operates correctly and efficiently. Your expertise will allow for the implementation of necessary data validation and conditional formatting to improve the functionality of the sheet.
I need a straightforward travel calculator focused solely on air travel. This tool should be built in Excel and utilize a simple user form with concealed tables that house the necessary data sets. Key Features: - The calculator should handle only air travel. - It should factor in flight distance and also calculate frequent flyer points based on the journey. - The user input form needs to encompass departure and arrival locations, class of service, and booking class. Ideal Skills: - Proficiency in Excel, particularly in creating interactive user forms and concealed data tables. - Understanding of air travel metrics and frequent flyer point systems. - Ability to create a user-friendly, simple yet effective travel calculator.
I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!
I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)
I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included
...subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales Navigator - Proficiency in Excel - Ability to work independently and manage time effectively Please note the list will provide a link to the LinkedIn page which will make it quicker to...
I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.
I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED
I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail
...Recognition (OCR) on the display and store the results in a text file. - The whole system needs to function without any internet access. Web Interface: - A web page hosted on the Raspberry Pi will be used for testing and adjusting parameters. This includes tweaking OCR settings and viewing logs. - The application should also allow me to start and stop the video stream from the web interface. Ideal Skills and Experience: - Strong proficiency in Python, particularly with video processing and OCR libraries. - Experience in developing applications for Raspberry Pi. - Understanding of setting up a local web server on Raspberry Pi. - Familiarity with working without internet access. The goal of this project is to create a reliable and efficient system to track and record weig...
I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experience with Excel, particularly...
I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.
...as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs) should be organised in folders and linked to their corresponding rows in the spreadsheet. 3. Requirements: • Ensure data accuracy and completeness. • Follow ethical web scraping practices (only scrape publicly accessible data). • Avoid causing disruption to the website’s operations. Deliverables: • A completed dataset in Excel/CSV format. • A folder containing all associated images/files. • A brief summary of the process and any challenges encou...
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.
As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.
I'm seeking a dedicated individual for a remote Customer Relations Manager role. This position involves responding to clients using pr...is perfect for anyone with a few spare hours each day, looking to combine part-time work with studies, a primary job, or other activities. It's an excellent opportunity for school students, university students, and adults who are ready to work. Your earnings will depend on your efforts. Requirements: - Proficient written communication skills - Responsibility and attentiveness - Access to the internet Conditions: - Remote work from any location - Flexible schedule - Stable payments without delays This is a straightforward job, with no deceit or hidden schemes. If you're ready to work, please contact us at the number below! (Removed...
Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.
We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken languages. The documents in question inv...
I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.
