Vba excel expense sheet jobs
I'm looking for an expert in Excel to assist me with creating Excel-based solutions.
I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.
I'm in the process of applying for a business loan and I need an experienced financial consultant to help me prepare my application. This involves reviewing my balance sheet, optimizing the application for approval, and identifying any missing or incorrect entries. Key Tasks: - Review my balance sheet for accuracy - Optimize the application to increase chances of loan approval - Identify any missing or incorrect entries Ideal Skills: - Experience with business loan applications - Proficiency in reviewing financial statements - Understanding of banking requirements I would like to discuss how we can streamline this process together.
...they are aligned with quality standards (the order is in the right subfolder, requirements, technical documentation) - update this list of routine and on-demand routine Support for HR is required - Recruiting on online platforms - Opening jobs, - making interview and tests ( We will share a technical test to be done), - first selection - Payments and follow up document template creation (Word, Excel), Marketing material, like power point presentation, brochures, business proposal lead verification and generation from Linkedin, mail and follow feedbacks Required skills - SELF SUFFICIENCY in completing required technical tasks. - Confidentiality: you will work in close contact with CEO, this means you will have access to private and sometimes confidential information, both person...
I'm looking for a talented video ed...$5/5 short 2 min videos,, we will need more than 500 such a video work, so I hope you can be working for a long-term with us. The explainer video should be 2-20 minutes long.. Budget is not negotiable, until we get enough customers to our website and/or monetized our YouTube channel by that mean I will need at least 1M subs and/or 1M views in each of the video ---- Please check in this google sheet, send me draft version of video 24 edited video according to the step in tab 'Standard Guideline', if you can do it accordingly, then I will send award to you for the rest of the other videos : ; ----------
I need assistance in renaming a set of JPG image files based on an Excel spreadsheet. Key Details: - The current naming of the image files is arbitrary, with names consisting of random numbers and letters. - I have a specific Excel spreadsheet that outlines the desired new names for these files. The ideal freelancer for this project should have: - Experience in file management and renaming tasks - Proficiency in using Excel - Attention to detail to ensure every file is renamed accurately.
I need 12 pages of mixed data (text and numbers) from a handwritten document entered into a specific A3 Excel template. Time is of the essence, as I need this completed within the next 2 hours. Requirements: - Proficient in data entry, particularly with mixed data. - Ability to accurately follow a template and specific formatting requirements. - Experience with Excel, particularly A3 layouts. Please note, I will provide the A3 Excel template that needs to be used. The data needs to be entered into specific columns and rows.
We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.
I am looking for assistance in automating the process of generating metrics to minimize human interaction and increase efficiency. My current approach involves the use of Excel Query, but I am open to exploring other Excel-based solutions if they offer better automation.
I am looking for assistance in automating the process of generating metrics to minimize human interaction and increase efficiency. My current approach involves the use of Excel Query, but I am open to exploring other Excel-based solutions if they offer better automation.
Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.
Project Overview We want to create a complete mechanical design for a mini tractor utilizing a 7 HP diesel engine. The project deliverables will include conceptual sketches, 3D CAD models, engineering drawings, bill of materials (BOM), and detailed instructions for fabrication....consolidated list of materials, standard parts, fasteners, bearings, etc. Provide potential vendor/supplier references (if known). Assembly Instructions Outline step-by-step assembly instructions (text + diagrams/screenshots). Include notes on safety, best practices, and recommended tools. Deliverables (Milestone 4) Detailed 2D Fabrication Drawings (PDF + native CAD format). Complete BOM (Excel or CSV) with part numbers, material specs, approximate costs. Assembly & Fabrication Guide (PDF/Word)...
I'm seeking a skilled software developer to create a tailored softw...Letter, Acceptance Letter, Engagement Letter, Management Representation Letter, NOC of previous auditor, Staff KYC, Etc. - Robust reporting and analytics capabilities - Automation of email notifications, data entry, scheduling, and other statutory records Integration: - Seamless integration with Excel sheets for reporting and analytics Ideal Skills & Experience: - Proficient in software development with a focus on analytics - Experience with task automation software - Strong understanding of Excel and data integration - Excellent communication skills for understanding office needs This project will significantly enhance our office efficiency and data management, making it a crucial investment fo...
I'm in need of a proficient MS Excel professional who can assist me with complex formulas and functions, as well as creating charts and visuals. The primary goal of these tasks is to aid in financial modeling using sales data. Key Responsibilities: - Apply complex Excel formulas and functions for financial modeling. - Create detailed and informative charts and visuals based on sales data. Ideal Skills: - Advanced expertise in MS Excel. - Proficient in financial modeling and data interpretation. - Capable of creating professional charts and visuals.
Generate Leads of driving Schools in USA Deliver in Excel Sheet
I need an Excel expert who can help me analyze our sales data and identify trends. The main objective is to leverage Excel formulas and tools for data analysis. I have a considerable amount of sales data that needs to be examined. The ideal candidate for this project should be proficient in Excel, with a strong background in data analysis. Experience with analyzing sales data specifically will be a plus. Key tasks will include: - Utilizing Excel's advanced features for data analysis - Identifying and interpreting trends within the sales data - Providing clear, concise insights based on the analysis Please bid if you can help me find trends in my sales data using Excel.
I'm looking for an Excel expert to create an energy dashboard for me. The dashboard will need to display: - Electricity consumption - Renewable energy production - Water consumption - BTU consumption The data will be sourced from CSV files, and I would like the visualizations to consist of line charts. Ideal skills and experience for this job include: - Proficiency in Excel, particularly with data visualization - Experience in creating dashboards - Ability to work with CSV files - Understanding of energy data would be advantageous
I'm looking for a professional to create a Gantt Chart in Excel for our project. The chart should include all project milestones, and be formatted using our company branding colors. Ideal Skills: - Proficiency in Excel - Experience with project management tools - Attention to detail Please note, the level of detail for task descriptions hasn't been specified yet, so some flexibility may be required.
I need a modern styled Excel spreadsheet quote template. The template should incorporate: - My company name - My company logo - My company stamp The design should be sleek and professional, in line with a contemporary business aesthetic. The ideal freelancer for this project will have strong skills in Excel and graphic design, with a keen understanding of modern design principles.
Sorry Islamul, I have been really busy and clean forgot to take care of this, I am doing it now. Please accept my apologies
...spreadsheet-like format. • Includes filtering and search functionality. • Editable Cells: • Customer data and analysis results can be edited in real-time. • Edit Logs: • Automatically save all modification history. • Logs include data before and after modification, along with timestamps. 4. Excel/CSV Export • Download grid-based data as Excel or CSV files. 5. Compressed File Processing • Automatically extract files when compressed files are uploaded to the server. 6. Selective Export • Export visible data on the grid as Excel or CSV. • Options to export only selected data. Automated Process Workflow 1. Data Upload and Email Attachment Saving • Store data through email attachments and file uploads. 2. Analysis...
...Responsibilities: Upload new products to the seller account. Create replenishment shipments as needed. Analyze return reasons and determine necessary actions to prevent future returns. Dispute returns with Takealot if they are a result of a Takealot error. Compare shipment sent items with purchase invoices to ensure accuracy. Requirements: Basic proficiency in English and Urdu is mandatory. Familiarity with Excel is important. Previous experience with e-commerce platforms such as , Amazon, or similar is a plus but not required. A willingness to find and watch instructional YouTube videos to enhance learning about e-commerce practices. Additional Notes: You will be granted access to my PC via TeamViewer to explore the seller portal and learn. We are looking for individuals wh...
I'm looking for an experienced Excel user to assist with creating a formula that sums a range of cells based on text matching criteria. Key Requirements: - Proficient in Excel with a strong understanding of creating and modifying formulas - Experience with conditional summing based on specific criteria - Ability to interpret and implement text matching criteria for the sum If you have the exemplary skills and experience for this task, please place your bid.
I'm looking for a skilled Excel expert to create formulas for data analysis. The focus will be on descriptive statistics, specifically calculating the mean and median from my dataset. Ideal skills for the project: - Advanced Excel knowledge - Data analysis expertise - Familiarity with descriptive statistics
I'm seeking brilliant minds for a thrilling task that tests intelligence and problem-solving abilities to the max! If you are an analytical thinker with exceptional cognitive skills and a strong desire to succeed, this is your chance. Your task will be to excel in Cognitive Aptitude Analysis, demonstrating your reasoning and critical thinking abilities; proving your Mathematics Mastery through complex numerical challenges; showcasing your English Proficiency with advanced comprehension and communication skills; and leveraging AI & Machine Learning in Education to transform contemporary learning strategies. - Task: Completing a trial exam + five challenging online exams in Mathematics and English - Difficulty: Questions rated 10/10 - Time: Extremely limited - Integrity: Che...
Looking for someone to redesign the primary board for a play school . 35 *7 feet
I'm seeking a skilled UI designer to create an engaging and user-friendly interface for a Fintech web app focused on personal finance management. Key Features: - Budget Tracking: The UI should facilitate easy navigation and interaction with budget tracking tools. - Expense Categorization: The design needs to include intuitive elements for categorizing expenses. - Financial Goal Setting: The interface should effectively support users in setting and tracking their financial goals. Ideal Skills: - Proven experience in UI design, preferably for Fintech or personal finance apps. - Strong understanding of user-centric design principles. - Ability to create engaging and intuitive interfaces.
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
1). I have a trading backtesting software, wherein I need to change n number of parameters for different instruments and different trade times and run the backtest. 2). Any parameter if I need to change, I spend lot of time in changing those parameters for all; quite a repetitive task. 3). It would have been great if the whole portfolio could be exported in excel format, so that changes could be done via batch edit much faster and imported back. 4). Unfortunately presently export import is via some port file, which is encoded/encrypted and can't be read or batch edited. Requesting any developer to help with this and also some additional features later. Thank you
I'm looking for a skilled developer to create a comprehensive invoicing app akin to Easy Expense, with cross-platform support (iOS and Android). The app should include all functionalities of Easy Expense and seamlessly integrate with Quick Books and xero. Key Features: - All features present in Easy Expense - Cross-platform compatibility (iOS and Android) - Integration with Quick Books and xero for accounting Ideal Skills: - Proficiency in mobile app development for both iOS and Android - Experience with creating finance-related applications - Prior work integrating apps with Quick Books and xero - Understanding of features and functionalities of Easy Expense Please provide relevant examples of your work.
A web-based Customer Record Lookup tool our staff to use, could be built on a CRM platform, but is very simple. The application consists of two main interfaces: Admin Interface: - User management functionality (add/edit/delete users) - CSV file upload for customer reco...on readability - Color-coded search results for quick identification - Design with optimized layouts for desktop / laptop use Files Provided 'Customer ' - This is the export from our ERP. - File will be uploaded to the app you develop weekly by our staff. - New data will replace old data (removing any data not overwritten by new file). 'THCSD Customer Account ' - This is an excel based solution that we created internally. - Use this as a reference for front-end Column Names and Data View of e...
i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.
Hi there, we are looking for somebody which creates the following with all Tools, Servers if need it, API, Connections etc. Development of Software and Workflows for Automated Campaigns Campaign A: Step 1 – Data Collection and Analysis of Potential Customers Input: A URL is entered into a Google Sheet. Website Analysis: The entire website is scanned to create an overview of all subpages. AI-Powered Analysis: Relevant content is identified using AI, such as ChatGPT. Website content is scraped and stored in Google Sheets. Extraction via AI: Email addresses and, if possible, contact persons are identified. The company’s fields of activity are determined. Personalized Email Creation: Based on the extracted information, the AI generates a personalized email explaining...
...press environment, I offer the following services: - Typing and document formatting using Microsoft Word - Data organization and spreadsheet creation in Microsoft Excel - Desktop publishing with Adobe PageMaker - Image editing and design with Adobe Photoshop I am dedicated, detail-oriented, and committed to delivering high-quality work that meets your specific needs. Ideal projects would involve typing, document creation and formatting, spreadsheet management, desktop publishing, or image editing. Skills and Experience: - Fluent in English with excellent typing speed (40 WPM) - Profound knowledge of Microsoft Office Suite (Word, Excel) - Proficient with Adobe PageMaker and Photoshop - A proven track record of 10 years in computer work related to printing press operation...
The project involves creating a mobile application for both Android and iOS platforms. The primary function of this app is to enable users to capture multiple photos in a single session, tag them with product SKU and quantity, and subsequently export this data into Excel and PDF formats. The app should also support date-wise search functionality to track the captured data over time. Key features include: - A user-friendly interface for capturing and tagging photos - Seamless integration with Excel and PDF for data export - Date-wise search capability Ideal candidates for this project should have: - Previous experience in mobile application development, particularly for Android and iOS - A strong understanding of data export functionalities - Excellent UI/UX design skills...
I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios...
I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing ...
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
Budget $25 I'm looking for a Python expert who can write a script for me. The script will open a list of URLs from an Excel spreadsheet and check for specific content. Requirements: - The script needs to check for text on the URLs. - If the content exists, it should create a new column in the spreadsheet with the status of each URL. Skills required: - Proficiency in Python programming. - Experience with working on Excel files. - Knowledge in web scraping techniques. - Ability to understand and implement URL content checking. Please only apply if you can demonstrate your ability to complete this task successfully -
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium). Prov...
I need an experienced Pocketsmith user to set up my budget categories for personal expenses. The specific areas I want to track include: - Groceries - Entertainment - Utilities The categories should be set up with moderate detail, similar to splitting 'Groceries' by store type. The ideal freelancer for this project should have a good understanding of Pocketsmith and personal finance, and be able to create a system that is both comprehensive and easy to use.
I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new ...for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Required Functionalities: - Automated Calculations: To reduce manual input and errors - Data Visualization: Charts and graphs to provide visual insights into the data - Summary Sheet: A separate sheet that auto-populates with a summary of all data Ideal Skills: - Proficiency in Excel or Google Sheets - Experience with sales reporting - Skills in data visualization and analytics I plan to update this spreads...
...camera to scan and upload receipts directly into the app. The app automatically reads and categorizes the receipt details (e.g., date, amount, vendor) and matches them with your transactions. • Cloud Document Storage: All scanned receipts, invoices, and tax-related documents are stored securely in the cloud, easily accessible when you need them for filing or audits. 6. Expense Tracker for Deductions • Automatic Expense Tracking: For freelancers, gig workers, or small business owners, TaxBuddy tracks your business expenses (mileage, supplies, software subscriptions) and matches them with your income, providing detailed summaries to maximize deductions. • Mileage Tracking: If you drive for work or business, the app can automatically track and calcu...
- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us
...tools such as SmartScout and Keepa (training provided if needed). Enter brand and product data into a basic spreadsheet with accuracy and consistency. Follow clear guidelines to meet weekly and monthly sourcing targets. Requirements: Familiarity with SmartScout and Keepa is a plus but not required; training will be provided. Strong attention to detail and accuracy in data entry. Basic knowledge of Excel or Google Sheets. Ability to work independently and meet deadlines. A positive attitude and willingness to learn new skills. What We Offer: Flexible working hours. Competitive pay structure. Weekly and monthly performance bonuses for meeting targets. Hands-on training and support to ensure your success. A straightforward workflow with no direct communication with suppliers or br...
1. Please fix the Stock Performance tab with Top 20 & Bottom 20. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab + others mentioned in Skype too, thanks
I'm looking for an expert who can transform my Excel sheet into a web-based calculator. The calculator needs to handle basic arithmetic operations like addition, subtraction, multiplication, and division. Key Features: - Data Input Options: The calculator should incorporate user-friendly data input options such as dropdowns and checkboxes. - Graphical Representation: A vital part of the project is the ability to visually represent results graphically. Ideal Skills: - Proficient in Excel and web development - Experience creating interactive web-based calculators - Ability to integrate graphical representations into a web platform Please provide examples of similar projects you have completed.
Please use necessary flash cards and highlighting of sheet music here. Thanks!