Finance excel 2007 vba jobs

I require a professional web scraper to collect both text (data points) and images from a long list of web pages about hotels and destinations. - The project involves saving the actual images of ...long list of web pages about hotels and destinations. - The project involves saving the actual images of destinations/hotels —not just their URLs—from every webpage. - As for the text content, I'm particularly interested in several points - The extracted data and saved images should be meticulously organized in an Excel sheet for easy review and reference. Ideally, I'm seeking someone with an extensive background in web scraping and data extraction. Being proficient in Excel would be a significant plus. Accuracy, attention to details, and reliability are...

I'm looking for someone to assist me with entering text-based data into an Excel sheet. The data should be organized into categories, helping to maintain clarity and ease of access. Further, the sheet should incorporate formulas for sum and average calculations. Key responsibilities: - Data entry: Primarily text-based data - Categorization: Organize the data by specific categories - Formula inclusion: Implement sum and average calculations Ideal skillset for this job: - Proficient in Excel: Should be able to use Excel and its various functionalities - Attention to detail: Essential for accurate data entry and categorization - Basic math skills: Needed for the sum and average calculations Your role will be crucial in ensuring that the data is correctly entered, ...

I am trying to address my financial issues, and have previously attempted so...In-depth understanding of financial management techniques, - Proficient in software development, - Strong problem-solving ability, - Experience in developing finance-related software tools. Task details: - Analyse the nature of my financial problem, - Design a software tool that can provide effective solutions. - The software should be user-friendly and efficient in managing finances. - Must be equipped with features like debt management, budget planning, investment planning, etc. This software tool should allow me to track my expenses and efficiently plan for my investments. Please apply if you understand the nature of personal finance and are capable of developing software to enhance fina...

...fixed duties with fixed employees…this helps the manager to enter the data quickly…. Restaurant duties are different – there will be 4 shifts. And 3 halls. Each hall has maximum number of duties…..waiters need to assigned to those duties….and cleaning boys need to be assigned to cleaning duties…..see the “Floor Staff” sheet in the attached excel file. Summary report for floor staff….with total man hours, ots etc….refer the “Floor Staff” sheet in the attached excel file. Need to send sms to present employees and owner on submitting the duty roster. Note: these are tentative requirements as we discuss and develop we get good shape. Ideal Skills and Experience: - Proven experience in web develop...

I need a sophisticated Excel spreadsheet designed and developed for tracking key performance aspects of my dumper truck and excavator rental company. The spreadsheet needs to be well-organized, easy to navigate, and detail-oriented, focusing on the following elements: - Expenses: Detailed tracking of an array of expenses. The ability to enter itemized costs is a must, and other daily expenses (office, car fuel..). Also monthly expenses like rent, salaries, bonuses and truck or excavator maintenance ect. - Income: This should include a breakdown of different revenue sources. - Employee tracking: A system to input and manage each employee's work hours. - Machine rental: Documentation of the equipment rented, including the duration of rental. - Fuel consumption: Dedicated sectio...

I'm looking for a freelancer who can build a dynamic Excel line chart that tracks and compares the performance of two teams over time. - **Metrics:** The chart should reflect team scores. - **Updates:** I need the chart updated within a 10-hour timeframe, to capture the latest performance data. Ideal Skills: - Proficiency in Excel and creating dynamic charts. - Understanding of data visualization and performance tracking. - Ability to automate data updates for real-time reporting.

I'm looking for a skilled Excel expert who can help me create a comprehensive food costing spreadsheet. In particular, I would like the following sections: - **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes. - **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients. - **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs. - Inventory management: - **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels. - **Predict Future Inventory Needs**: an analysis that could help me foresee when I&#...

Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...

I'm seeking a web developer that specializes in business software applications. The project involves creating an intuitive, user-friendly business management software that incorporates both customer relationship management (CRM) and robust detailing of accounting and finance features. Key Requirements: - Expertise in web development, specifically for business applications. - Awareness of CRM features and capabilities. - Proficiency in designing and integrating accounting and finance capabilities. - Excellent usability design skills to ensure the software is easy to navigate. This job requires a developer who has experience in crafting comparable software and a keen understanding of business management functions. The successful candidate will combine these skills to pr...

...that can convert a Marathi excel sheet to English. The application should have the following features and capabilities: - Upload functionality: Users should be able to upload Marathi excel sheets into the application. - Conversion: The application should accurately convert the Marathi data (including names, addresses, phone numbers, gender) to English without any loss of information. - Download functionality: The application should allow users to download the converted English excel sheet. - Volume handling: The Marathi excel sheets may contain around 2000 records, so the application needs to handle this volume efficiently. Ideal skills and experience for this job would include: - Strong proficiency in PHP and web application development. - Experience with...

...and enhance overall quality. - Video Call Backgrounds: Design custom backgrounds for video calls that reflect our corporate identity. - Word Templates and Project Proposals: Create templates for documents and proposals that are user-friendly and visually aligned with our brand. - PowerPoint Templates: Design templates for presentations that are both professional and creative. - Invoice Templates (Excel): Develop invoice templates that are clear, professional, and include custom fields as per our requirements. - Social Media Profile and Cover Photos: Design attractive profile and cover images for our social media that maintain visual coherence. - Corporate Email Signature Design: Create an email signature that elegantly incorporates our logo and contact details. - Corporate Mug De...

I need a spreadsheet expert to enter a significant volume of text data into an Excel sheet. - Skills: Proficiency in Excel, attention to detail, data entry - Work details: Text data has to be entered as simple text. - Post-entry, the entered data needs to be validated for accuracy and consistency - Prior experience in similar projects appreciated. The project will require a keen attention to detail and strong Excel skills. A background in data entry and validation would be ideal.

I am in need of a ...transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high volume of pages and can ensure that no data is lost or incorrectly transcribed in the trans...

I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English

they closed it? collect information from a directory for our event, which lists approximately 2590 partners. The information must be obtained from subpages 1. Logo (embedded in excel and folder) 2. Company Name 3. Stand number/code 4. "Why Visit Our Stand" Section 5. Brands 6. Description 7. Company Activity 8. categories 9. Regions 10. Gallery (embedded in excel and folder) 11. Follow us section (social media links) 12. Website 13. Email(s) 14. Company Address 15. Company phone number

I require a creative designer who can conceptualize and produce an innovative logo for my wealth solution portal which focuses on mutual fund investments and LIC policy distribution. Key aspects: - This logo should evoke feelings ...distribution. Key aspects: - This logo should evoke feelings of trust and approachability,Reliable,experienced, capturing the essence of our portal, which is to offer a comprehensive wealth solution for both indvidual investors and business owners. - It needs to synergize with our mission and branding. - I am since 1988 in this bussiness Ideal Candidate: - Experience in logo design, branding, and finance sector is preferred. - Ability to translate abstract concepts into compelling visual themes. - Capable of working collaboratively and incorporating...

I'm in need of an accountant proficient in tax preparation and financial analysis. My business falls in the medium size category, with 11-50 employees. I am mainly seeking assistance with: - Investment and Financial Planning: Strategies to maximize growth and profitability. - Debt Recovery and Restructuring: Tactics to improve financial health and structure. Ideal candidates will have demonstrable experience within similar sized businesses and considerable tax accounting skills. Experience in strategic planning and financial restructuring is a must.

We are seeking a skilled Android developer to integrate an Excel import feature into our existing app, "Fuel Injection MSI CRDI Charts" (). Scope of Work: Develop a function to import data from Excel files (.xls or .xlsx) into the app. The import functionality should be similar to the existing "Fuel Injection Price List" section within the app. Ensure data integrity and proper handling of potential errors during import. Implement appropriate user interface elements for file selection and import initiation. Skills Required: Android development expertise (Java/Kotlin) Experience with data parsing and Excel file handling libraries Understanding of user interface design principles for Android Strong problem-solving

I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email

I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.

I am seeking a professional Android app developer to create a web application for me. Below are the specific features I want to include in the app: A. App Logo: I have the logo ready; you only need to integrate it into the app. B. Splash Screen Video: I possess the video for the splash screen; your task will be to incorporate it into the app. Screen: I already have a design for the homepage; I will provide you with further details via chat. D. Bottom Menu Navigation: Implement bottom menu navigation for easy access to different panels. Notes for the Developer: 1. App Compliance: Since I intend to publish this app on Google Play Store, it is crucial that the web app is developed in compliance with Google's standards. Additionally, please advise if integrating the web app with Fireb...

...in particular, and previous experience in preparing business plans for obtaining bank financing. Your ability to conduct market research and in-depth understanding of financial forecasting would greatly benefit this project. Demonstrated results in securing bank finances will be a plus. Your task is to produce a comprehensive, detailed and persuasive business plan that can convince a bank to finance this promising venture. Your work will directly contribute to the realization of a radio station designed for adults aged 25-45....

I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.

I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This

I'm in need of a talented content writer to help create professional and informative conten...task will be to promote our products and services in a way that is both engaging and insightful. This will involve: - Crafting compelling narratives that highlight the benefits and uniqueness of our offerings - Ensuring a professional and informative tone throughout the content - Incorporating industry-relevant jargon and insights to showcase our expertise Ideally, you have experience in the finance sector and a strong understanding of stock market dynamics. A background in content writing, particularly for promotional purposes, is also highly desirable. Your ability to write engaging, persuasive content that is also factually accurate and informative will be crucial to the success o...

I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.

I'm keen on gathering a customized list of up to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly thos...or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and valid) - Engagement Ratio - So...

I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tennis. SINGLET AND SKIRT Key Points: - The outfit will consist of a singlet and skirt. The specific fabric for the outfit is yet to be decided. - It shoul...appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fashion sta...

...integration of an intuitive system to store and manage contact information. • Flawless Deal Tracking: A real-time, efficient system to track ongoing deals and future opportunities - very crucial for operations. • Advanced Email Tracking: A system that allows the tracking of sent and received emails, giving real-time updates and promoting efficient communication. In addition, the app should cater to finance, IT and HR operations, to facilitate seamless business activities. Developers adept in CRM software, experienced in multi-functional platform coding, and with a keen understanding of small to medium businesses' operations will be ideal for this project....

I am seeking an AI coder for the development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering

I am seeking an experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be directly ignored as ...

...candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration, data entry, and customer service roles. - Intermediate proficiency in Microsoft Office...

I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.

I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.

...can export the text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results. There will be 901 rows of Ex...

...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of accuracy and organisation. - Good leve...

...compelling cover letter to accompany my application for a mid-level finance role. Key points: - The goal of this letter is to introduce myself and convince the hiring manager why I'm a suitable candidate for the role. - The cover letter must be tailored specifically for the finance industry and a mid-level position. - It should be engaging, concise yet informative, and persuasive. - If you have experience in finance or recruitment, that would be a great advantage. The ideal freelancer for this job should have: - Proven experience in creating effective cover letters, particularly for the finance industry. - Strong writing skills, with the ability to craft engaging, professional content. - Familiarity with what hiring managers in finance typicall...

As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to w...

I'm looking for a freelancer well-versed in finance to conduct case studies on three selected companies. This task is primarily for educational purposes. The final product should be case studies focusing mainly on the financial performance of the companies, presented neatly in PowerPoint format. Ideal freelancers should have significant experience with financial research and PowerPoint presentation creation. Your application should ideally demonstrate your experience in the field. This project requires a deep understanding of finance and expertise in crafting informative presentations.

I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus

I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful compl...

I'm in need of a sophisticated chatbot solution. This chatbot should have the capability to interact with and analyse documents uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap, I'm seek...

I'm on a continuous hunt for an Odoo expert to assist in the enhancement of the Odoo v8 ERP system for our operation. Key tasks would include: * Efficient management of Sales, Inventory, Accounting, and Finance modules. * Customization to modify existing features and creation of new ones, fixing existing bugs for seamless operation. * Keep up with our eCommerce operations and integrate the ERP system with it as needed. To be successful in this project, you should have considerable experience with the Odoo v8 ERP platform, be skilled in customization of its modules, and have a knack for bug fixing. A background in eCommerce would be particularly beneficial. The ability to work proactively and consistently, in line with our operational needs, is a must.

I need a proficient freelancer to assist in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experience handling cus...

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...