Converting lotus 123 macros excel macros jobs

I need someone to extract data from my invoices and enter it into Microsoft Excel and then into both a desktop and a cloud-based application. Key Tasks: - Extract data from invoices - Paste data into Excel - Enter data into a desktop app and a cloud app Ideal Candidate: - Familiarity with data extraction and Microsoft Excel - Experience with both desktop and cloud-based applications - Attention to detail to ensure data is entered accurately

I'm looking for a skilled Excel expert who can transform my investment portfolio data into a user-friendly, dynamic spreadsheet. Key Requirements: 1. Create a comprehensive, dynamic Excel table capturing all of the client's investment positions. 2. Organize information into dedicated columns for each data point (e.g., ISIN, Name, Price, etc.) 3. Utilize advanced graphic design skills to present the data in an intuitive and visually appealing manner. The aim is to create a UX-friendly information table suitable for individual investors. 4. Include a dedicated column with links to Yahoo Finance or Investing.com. Each link should correspond to the historical chart data of each investment position. Ideal Skills: - Proficient in Microsoft Excel - Strong data an...

I'm looking for a professional who can proficiently analyze data using Excel, specifically looking at descriptive statistics. In addition, I need assistance with managing and strategizing my social media ad campaigns. Ideal candidates should have: - Strong expertise in Excel, particularly in data analysis - Experience in working with descriptive statistics - Proven track record in managing social media ad campaigns - Skills in creating compelling ad content - Ability to interpret data and adjust campaigns accordingly Please provide examples of your previous work related to this project.

I need a freelancer to scrape 30,000 records of contact information from a provided URL within 48 hours. The information will specifically consist of names, email addresses, phone numbers, and mailing addresses. The final output should be in an Excel format. Ideal skills and experience for the job include: - Proficiency in web scraping - Experience with Excel - Attention to detail - Ability to meet tight deadlines

Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!

I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creating billing or...

...seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to identi...

I'm seeking a skilled Android & iOS developer to create an event registrati...Management: -Display event schedules with session details (title, speakers, time, location). -Add sessions to a personal calendar or create a custom agenda. - Real-time updates to agenda (push notifications for changes). 3. Lead Scanner: QR code scanning for exchanging contact information between users (attendees, exhibitors, and organizers). Store scanned leads in a dedicated section. Export leads to Excel or other formats. The app should have a manual form entry system for event registration. The ideal candidate for this project should have a strong background in iOS development, experience with integrating payment gateways and implementing push notifications, and a knack for creating user-fri...

I'm in need of a professional who can extract data from a corporate website and compile it into an Excel spreadsheet. Key Requirements: - Extract data from a corporate site. - Data includes: Shopping Centre Name, Street Address, Suburb, State, and Post Code. - Focus on all store locations in New South Wales (NSW). - Use web scraping techniques for data extraction. Ideal Skills: - Proficiency in web scraping. - Experience with data extraction from corporate sites. - Excel spreadsheet management skills. - Familiarity with New South Wales geography is a plus.

I need a proficient Excel expert to help me with a VLOOKUP task involving my inventory data. Specific task: - The VLOOKUP function needs to match exact quantities within my inventory. Ideal Skills: - Advanced proficiency in Excel, particularly in using VLOOKUP. - Prior experience in inventory management is a plus.

I'm in need of a proficient freel...companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the requirements, kindly refrain from...

I need a professional to convert my PNG logo to an SVG format without any alterations to the original design. I need the logo without any background. The logo will be used primarily for print materials, so it is crucial that the conversion maintains the integrity of ...to an SVG format without any alterations to the original design. I need the logo without any background. The logo will be used primarily for print materials, so it is crucial that the conversion maintains the integrity of the original design. Ideal skills and experience for this project include: - Proficient in graphic design software such as Adobe Illustrator or Inkscape. - Experienced in converting PNG files to SVG. - Attention to detail to ensure the logo remains unchanged. - Understanding of print design req...

I'm looking for an expert in financial modelling to create a comprehensive Excel model for my new business. The model will be used primarily for an investor presentation, so it needs to be robust and compelling. Key Requirements: - Inclusion of all essential financial statements: Income statement, Balance sheet, and Cash flow statement. - Projections covering a period of 5 years. Ideal Skills: - Expertise in financial modelling and Excel. - Experience with investor-focused financial presentations. - Ability to create clear and precise financial statements.

I'm in search of an extensive Indian Grocery Items Database suitable for an online app and website. The database needs to be in Excel format, and must include: - UPC, Bar code - Product Name - Product description - Unit - MRP - Multiple high resolution images The database should cover all branded standard grocery items across the following categories: 1. Fruits 2. Vegetables 3. Grocery & Staples 4. Breakfast & Dairy 5. Biscuits & Snacks 6. Beverages 7. Personal Care 8. Home Care Ideal Skills: - Database Management - Data Entry - Research Please note: - The data should be free from copyright restrictions and not sourced directly from Google. - I will need an initial sample to assess the quality of the information and images. - Data needs to be structured in a ...

I need an Excel file containing my bank transactions converted into a QFX file, which can be imported into Quicken. Ideal Skills and Experience: - Strong proficiency in Excel - Experience with file conversion to QFX - Familiarity with Quicken software - Attention to detail to ensure all transactions are accurately converted.

I have an Excel file that contains crucial customer information. I need it organized correctly to facilitate better understanding and accessibility. Requirements: - Primary focus on organizing Names and Contact Details. - Each contact's item should be in its own column: Name, Email, Street, City, State, Post Code, and Country. Ideal Skills and Experience: - Proficiency in Excel - Experience in data organization - Attention to detail

I'm in need of a comprehensive operating and financial model in Excel for a new venture. The model should encompass an operations section, a financing component (balancing both Debt and Equity), and generating complete Profit & Loss and Balance Sheet outputs. Key Requirements: - Detailed representation of production costs, sales volume, employee expenses, and capital costs in the operations section. - Consideration of daily hire rates, income from asset disposal, build period expenses, and utilisation metrics. - The financing section should adequately reflect a mixture of Debt and Equity. - Major sensitivities to be clearly presented within the model. Ideal Skills and Experience: - Proficiency in Excel with a strong background in financial modelling. - Previous ex...

I'm looking for a seasoned social media marketer with a focus on Facebook to help increase traffic and sales for my existing Shopify dropshipping niche site, Christian t-shirts. Key Responsibilities: - Create and manage engaging advertisements on Facebook aimed at driving traffic to the site and converting visits into sales. - Website redesign as needed to increase aesthetics, which might convert sales -- site look and feel plus functionality - SEO to drive traffic and sales Ideal Skills: - Proven experience in e-commerce and dropshipping marketing - Expertise in Facebook advertising - Strong understanding of Shopify platform - Excellent content creation and copywriting skills - Data analysis skills to track campaign success and adjust strategies accordingly.

I need an Excel dashboard created to track H2S material limits. The primary data source will be Excel Spreadsheets. The dashboard should allow me to monitor: - Material Suggestions I would like the data to be visualized using Pivot charts. Attached file has some created dashboard but they do not provide accurate data. Need to modify it and make more accurate. Ideal skills for this job include Excel proficiency, data visualization, and experience with dashboard creation.

I'm in need of an Excel expert who can help me build a comprehensive workbook to capture end of shift data from multiple locations. Key categories to include: - Delays OS&D - Scanning/PLS Cube Outs - Equipment Issues - Driver Issues - Safety Crucial categories for reporting: - Delays OS&D Specifics for managing Delays OS&D: - I need to be able to list specific delays Ideal skills and experience: - Proficient in Excel - Data management experience - Ability to create user-friendly and efficient workbooks.

...working on a personal project and need assistance with Microsoft Excel and PowerPoint. Microsoft Excel: - Data Entry & Formatting: I have a lot of data that needs to be entered and formatted correctly in Excel. - Creating Formulas & Functions: I need someone who is skilled in Excel to create appropriate formulas and functions to manage my data. - Data Analysis & Visualization: The project will require some data analysis and I would appreciate help visualizing the data using Excel tools. Microsoft PowerPoint: - Creating a Presentation: I need a PowerPoint presentation to accompany this project, so experience in creating engaging and clear presentations is a must. Ideal candidates should have: - Advanced skills in Microsoft Excel an...

I need assistance with an Excel spreadsheet. The task involves adjusting column D to ensure all wrapped text is readable. - Number of Rows: The column contains between 100 and 500 rows. - Software: The file is in Microsoft Excel. - Specifics: Only column D needs to be adjusted, not the entire spreadsheet. Ideal skills for this project include proficiency in Microsoft Excel, attention to detail, and experience with data manipulation and formatting in spreadsheets.

...existing GitHub project that is not ours. The repository can be found here: Based on its current functionality, we want to add the following features: OpenAI Realtime API Support the OpenAI Realtime API and Azure channel integration. /v1/messages Endpoint Provide support for the /v1/messages endpoint, ensuring compatibility with the OpenAI channel by converting data into Claude format. High Performance Optimization Optimize the system for certain scenarios to improve resource utilization and significantly reduce latency under high concurrency. Detection Prevention Implement measures to prevent upstream detection of OpenAI relaying; any erroneous responses should be handled by “duckagi.” Airwallex and Cryptocurrency Payments Integrate Airwallex payment

I'm looking for an Excel expert to help me with a task related to tracking revenue. The primary focus will be on creating projections based on available market growth data. Key Responsibilities: - Analyze market growth data to create revenue projections - Use advanced Excel skills to apply necessary equations and techniques Ideal Skills: - Proficient in Excel, particularly with financial equations - Experience in revenue tracking and forecasting - Strong analytical skills to interpret market data

I'm looking for an Excel expert to help me create a comprehensive inventory management spreadsheet for my business. Key Requirements: - Inclusion of all our supplier's items that we sell - Categorization of items by product type The ideal freelancer for this project should have extensive experience with Excel and inventory management systems. They should be able to create a user-friendly, efficient, and organized spreadsheet that meets these requirements.

I'm seeking a software developer to create a Windows-compatible solution for managing estimates, sales/purchase orders, and invoices for our dealer network. Key Requirements: - Create a user-friendly interface for managing estimates, sales orders, purchase orders, and invoices. - Design the software with a primary focus on generating estimates. - Incorporate customizable templates for the estimates, ensuring they can be tailored to specific needs. - Ensure compatibility with the Windows operating system. The ideal candidate will have: - Extensive experience in software development, particularly for Windows. - Proven skills in designing user-friendly interfaces. - Prior experience in developing software for managing sales and purchase orders, and invoices. - Ability to create customi...

...expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard creation and management - Experience in d...

I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatting and stylin...

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.

...complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (70+). Look for inspiration online around jokes, puns, irony, repartee, sarcasm, memes, idioms, brainy-...

I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.

I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format ...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to long term Please feel free to propose what you think wo...

...functionality. As a dynamic and growing organization, we're always looking for talented individuals to join our team. If you're passionate about delivering excellence and want to be part of a company that values its employees, we'd love to hear from you. Key Responsibilities ● Meet Sales Targets: Achieve monthly, quarterly, and annual sales targets by generating new business leads and converting them into sales. ● Identify New Business Opportunities: Research and identify potential customers, and develop strategies to approach them. ● Maintain Customer Relationships: Develop strong relationships with customers to ensure customer satisfaction and loyalty. ● Negotiate Sales Deals: Negotiate prices, terms, and conditions of sales with customers. ● Design...

I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.

I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments

I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.

I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, the final output should...

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. T...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think wo...

I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating interactiv...

Emerging Market Bond Data Extraction Project overview Extraction of trading data for sovereign bonds from specified countries over the last 30 trading days, replicating the structure of an example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of transactions in monetary units at par, volume of trans...

I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.

I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so ...assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded ...

I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas

...am seeking a freelancer to compile content from a 28-page PDF into editable PowerPoint, Word, and LaTeX documents. The PDF can be easily converted to text and equations using appropriate tools. While the exact font matching is not required, the text and equations must be accurate, editable, and properly formatted. ### **Scope of Work:** 1. **Conversion:** - Extract content from the PDF, converting text and equations into editable formats. - Ensure all equations are rendered correctly in PowerPoint, Word, and LaTeX. 2. **Deliverables:** - Editable PowerPoint slides with properly formatted equations. - A Word document with all content rendered accurately, including equations. - A LaTeX document ensuring correctness of equations and appropriate formatting....

I need a professional to convert my PSD/PSB logo into Adobe Illustrator's vector format. The logo needs to be pure vector and saved in 3 lay...layers. Details: - No modifications to the logo are required, just a straight conversion. - The primary use for the logo will be on digital platforms, so it should be optimized for that. - I want to retain the original colors of the logo, so no additional color versions are needed. Ideal candidates for this project are professionals with extensive experience in graphic design, specifically in converting files to vector format. Proficiency in Adobe Photoshop and Illustrator is a must. This should take an experienced person only a few minutes. Logo is in the below link

I have over ten Excel files containing sales figures organized by product. All these files have the same format, making them straightforward to merge. I'm seeking a freelancer who can expertly consolidate these files into one comprehensive total sheet. Ideal Skills: - Proficient in Excel - Data Analysis - Attention to Detail - Experience with Data Consolidation

I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creating billing or...

I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills