Vba excel expense sheet일자리
...this project, I leveraged the full potential of Microsoft Office to streamline business operations and enhance productivity. My expertise in MS Office applications, including Word, Excel, PowerPoint, and Outlook, allowed me to deliver high-quality results tailored to meet specific client needs. Key Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visualize trends. Utilized formulas, pivot tables, and charts to provide actionable insights and support decisi...
If you you bid to consider, please send me in message .. a sample infographic/chart based on the excel file I am attaching here: _____________________ I'm in need of a freelancer skilled in database analysis and Microsoft Excel. The project involves analyzing demographic data from an Excel spreadsheet. Key Responsibilities: - Conduct descriptive analysis on provided demographic data. - Create charts and infographics to illustrate findings. Freelancer Requirements: - Proficiency in Microsoft Excel. - Experience in data analysis, particularly with demographic data. - Ability to create visual representations of data (charts, infographics).
I need a professional to conduct regression analysis, ANOVA tests, and write a brief report on their findings. Key Requirements: - Perform regression analysis (exact type to be determined) and ANOVA tests - Write a concise report detailing the findings - Deliver the report in an Excel file Ideal Skills: - Proficiency in statistical analysis and software - Experience in writing analytical reports - Strong understanding of ANOVA and regression techniques
I'm looking for an experienced graphic designer who can also help me analyze financial data to identify trends. Key Responsibilities: - Utilize Photoshop and CorelDRAW to create engaging graphic designs - Use MS Excel to analyze financial data - Present findings in an appealing way using MS Powerpoint Ideal Skills: - Proficiency in Graphic Design software (Photoshop, CorelDRAW) - Advanced skills in MS Excel and PowerPoint - Experience in analyzing financial data - Strong ability to identify trends from data - Excellent graphic design skills Your main task will be to help me visualize the data trends through compelling graphic design and presentations.
I'm looking for a task management system specifically designed for real estate agents. This system should facilitate the management of tasks related to property closings. Key Features: - Automated reminders to...- Knowledge of real estate processes - Proficiency in Web and iOS app development Please only bid if you can deliver a system that meets these requirements. I want to keep track of real estate closings. There are approx. 6-7 tasks that are accomplished one by one in about a 60 day time frame. I have 10 to 20 closings happening at any given time. I want to see the big picture in a spread sheet that is graphically pleasing and nimble. I want it to expand to see more detail on certain tasks - then collapse to keep seeing big picture. I want colors used so it...
Need this recreated and add deals you can find for 2024 (leave the metrics to me) Need the PPT, and set up additional rows for 2024. So this turns into two pages probably. Then also need an excel backup thanks of the same data.
I'm seeking a researcher for writing a paper on "Role of ESG Criteria in inf..."Role of ESG Criteria in influencing Financial Decision-making". The paper already has introduction written and sources collected. The final wordcount should be more than 10,000 words. Key Requirements: - Mixed-methods research approach, with a focus on academic journals. - Emphasis on all aspects of ESG criteria: environmental impact, social responsibility, and governance. - Data collection and Excel calculations as necessary. Prefer someone with a background in economics or finance. The project is low-stress with a requirement of around 1500 words per week. note, strict adherence to NO AI use mandatory. Minimal use of AI for guidance is acceptable, but no AI-generated content sho...
I need assistance in recovering a deleted Excel spreadsheet file from my external hard drive. Ideal skills for this job: - Expertise in data recovery - Familiarity with external hard drive recovery processes - Proficiency with Excel and understanding of spreadsheet structures - Ability to work with urgency and confidentiality The project is time-sensitive as I need the file for an ongoing task. Please only apply if you have proven experience in file recovery.
I'm seeking a UX/UI designer to create a full design setup for a minimalist, mobile-optimized asset management app. The primary function of this application is to track asset values in real time. It should also manage all expenditures associated with these assets and make recommendations for mutual funds and other potential investments. Key project requirements: - Expense Management: Users can log daily expenses with custom categories. Analytics Dashboard: Visual insights using charts/graphs to track spending trends. Payment Integration: APIs for GPay and PhonePe to facilitate payments directly from the app. Budget Tracking: Users can set monthly budgets and receive alerts when nearing limits. UX/UI Design: Full design setup needed, focusing on a minimalist aesthetic. -...
I'm seeking a skilled developer to create a personal finance application tailored for individual investors. This app should incorporate the following key functionalities: - Expense Tracking: Users should be able to monitor and categorize their expenses in real-time. - Budget Planning: The app should assist users in creating, maintaining, and adjusting their budgets. - Financial Goal Setting: Users should be able to set, track, and achieve their personal financial goals. Ideal candidates for this project should have a strong background in financial software development and UX/UI design, with a proven track record of creating user-friendly applications for individual investors. Understanding of personal finance principles will be a significant advantage. Please provide example...
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
I'm seeking an experienced accountant for comprehensive financial reporting. This project involves the creation of key financial documents, specifically a balance sheet, income statement, and cash flow statement. Ideal Skills: - Proficiency in SAP - Extensive experience in financial reporting - Ability to create and interpret complex financial documents Please note that the use of SAP is essential for this project, so familiarity with this software is a must. I look forward to your proposals.
I'm in need of a skilled professional who can compile Data from a Website for me. Ideal Skills: - Proficiency in data collection and analysis - Familiarity with Food Delivery Platforms - Competence in using Excel proficiently The final product should be delivered as an Excel spreadsheet that I will provide. Please ensure the data is well-organised and easy to navigate. NOTE: THIS PROJECT HAS A FIX PRICE OF **INR 600**, ONLY APPLY IF YOU´RE OKAY WITH THAT. Please, start your Bid with "I Can Do It"
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm looking for a skilled professional who can integrate Telegram's API with Excel. The goal is to download real-time data regarding Bitcoin trades from a specific channel, focusing primarily on market analysis. Key Requirements: - Set up a system to download market analysis related to Bitcoin trades in real-time from Telegram. - Ensure the data is properly formatted and easily readable in Excel. - Implement error handling and data validation to ensure the integrity of the downloaded data. Ideal Skills and Experience: - Extensive experience with Excel, including knowledge of advanced functions and data manipulation techniques. - Proven track record of working with Telegram's API. - Strong programming skills, particularly in languages commonly...
Tagline: "Professional Logo for Tube Fittings, Valves, and Accessories" Project Description: We are seeking a talented logo designer to create a professional and eye-catching logo for our website, Excel Flow Control. Our company specializes in providing high-quality tube fittings, valves, and accessories for various industries. The logo should reflect our expertise and commitment to excellence in the flow control solutions industry. Key Requirements: Brand Name: Excel Flow Control Industry: Industrial and Engineering – Tube fittings, valves, and accessories Design Style: Modern, sleek, and professional with a hint of industrial elements to reflect our niche. Color Scheme: Preferably shades of blue, gray, or metallic tones, but we are open to creati...
I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data
Help me to create our business profile Company name - Pooja Plywood Established - 1992 We are authorised distributors of Greenlam laminates Everset plywood Greenpanel mdf We also deal in all kind of interior products like plywood Veneer Laminate Veneers Hardware decoratives Charcol Wpvc louvers Mdf carved sheet Exterior Panelling solutions Restroom cubcials We 3 generation sucessfully running this family business. Please help me to create our business profile With images.
I'm in ...The primary focus will be on pinpointing individuals and organizations that would be beneficial to the exhibition. Ideal Skills and Experience: - Market research - Making a Database of potential delegates - Ability to search social media platforms, websites, online databases and online B2B marketplaces - Delegate sourcing to build up a database of potential delegates with contact details in excel as per approved fields - Fields required, First Name, Last Name, Email, Phone Number, Company Name, Fields related to addresses - All the data should be verified Payment shall be made on the basis of each verified data of each contact person Data has to be collected from India and from the specific industry only. Please ensure to provide previous examples of similar wo...
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
I'm seeking an Excel expert to help me manage and visualize performance grades. The project involves: - Creating tables to breakdown grades according to different units and ranks - Interlinking multiple Excel sheets for live updates - Utilizing formulas and functions for these live updates Ideal Skills: - Advanced Excel skills, particularly with formulas and functions - Experience in data visualization - Ability to interlink Excel sheets I'm looking for someone who can transform this data into a comprehensive and interactive overview of performance grades.
I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling
I am in need of a Tableau expert to develop a project that visualizes our employee hierarchy and access levels. The project should include the following: 1. A "Top Office" table that encompasses all higher management i...them; supervisors and managers can see their respective employees; and employees can only see their immediate boss. 3. Access control settings that allow for 'Editable for specific roles'. This means that only designated individuals can edit certain parts of the project. Data for this project will be sourced from Excel spreadsheets. It is critical that the freelancer has profound experience with Tableau and is able to create a comprehensive and clear visualization. Familiarity with Excel and understanding of hierarchical structures in a ...
Subject: Requirement for Advanced Freight Management Excel Dashboard Dear I hope this message finds you well. I am looking for an advanced Excel solution for our freight forwarding operations. Below are the specific requirements: 1. Data Entry Form: A user-friendly dashboard to enter shipment details, such as: Arrival and departure times. HBL and CFS manifest details. Railing status, delivery order status. BL (Telex/Original) status. Each shipment should create a unique job number automatically. 2. Centralized Database: All data should be stored in a master Excel sheet, capturing all shipment details. 3. Search and Filter Functionality: Ability to search by job number, BL number, or other fields. Upon searching, display all related details for...
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling
...understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if it's not that easy since you need t...
... Email Creatives: - Creating engaging visuals and layouts for email campaigns. - Ensuring designs align with brand identity and resonate with our target audience. E-commerce Listings: - Assisting in creating and updating product listings with optimized visuals. - Ensuring images and descriptions are consistent across platforms (e.g., WooCommerce, eBay, and Google Shopping). Requirements: To excel in this role, you’ll need: - Proficiency in Photoshop or similar design tools. - A strong portfolio showcasing creative design skills, particularly in e-commerce or digital marketing. - Familiarity with social media ad design best practices (especially Facebook/Instagram). - Experience with e-commerce platforms (WooCommerce, eBay) is a plus. - Excellent attention to detail and t...
I'm seeking a freelancer with robust XLS and data analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to i...analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to identify trends in customer satisfaction. - Pinpoint the most common complaints from the feedback. - Extract suggestions for improvement from the customer feedback. - Create a compelling and clear presentation from the analysis. Ideal Skills: - Proficient in Excel for data analysis. - Experienced in creating presentations in PowerPoint. - Strong analytical skills to interpret customer feedback data. - Ability to present data in a clear and e...
I'm in need of a skilled developer to scrape phone numbers from www.yellowpages.com.au. The data should be categorized into Plumbers, Electricians, HVAC companies, Roofers, and other trades. Key Requirements: - Delivering the data in an Excel spreadsheet - Including the Company name and Website URL along with the phone numbers - Formatting the phone numbers in International format for easy dialing Ideal Skills: - Proficient in web scraping and data collection - Experienced in using Excel for data organization - Knowledgeable in categorizing trade-related companies
I am in need of an experienced Excel specialist who can create a financial modeling matrix for me. The matrix should be capable of performing ROI calculations and Net Present Value (NPV) calculations. Ideal skills and experience for the job: - Proficiency in Excel, particularly in creating complex models - Experience in financial modeling - Ability to incorporate specific financial formulas into the matrix - Understanding of ROI and NPV calculations. I WILL PAY $30 TO FULLY COMPLETE MY MATRIX AFTER YOU SUCCEED THE FIRST STAGE PLUS A BONUS WHEN I GET PERSONAL GUARANTEE PLUS UNLIMITED REVISIONS
I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. I am attempting to create and fill a WORD template by completing a form in Microsoft Lists....am attempting to create and fill a WORD template by completing a form in Microsoft Lists. The form must then be changed to a PDF and emailed. I am presently using a Plumsail action but would like to get rid of it. One of the flows is the same as previously stated but fills an Excel template instead. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and recti...
Please create the sell sheet as per the project brief provided.
Step 1: Key Variables Include the following inputs and calculations: Dates: Check-Out and Check-In Pricing: Daily, Weekly, Monthly, 3-Month Rates Charges: Fuel Surcharge, Damages, Cancellation Fee Mileage: Allowance, Actual Mileage, Excess Mileage Charge Payment: Deposit, Payment Amount, Card Fee Outputs: Total Cost, Refund/Outstanding Amount Step 2: Excel Layout Design an Excel sheet with the following structure: Description Input Formula/Explanation Check-Out Date 01/10/2025 User input Check-In Date 01/25/2025 User input Rental Duration (Days) =B3-B2 Rental Type Daily/Weekly/Monthly/3-Month Dropdown using Data Validation Daily Rate $50 User input Weekly Rate $300 User input Monthly Rate $1,000 User input 3-Month Rate $2,800 User input Rental Cost Formula depends ...
I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data
...to assist with text creation. Daily Targets: Successfully post a minimum of 160 links across the internet each day. Important: Only links that remain live and online will count toward your daily target. Links that are removed, deleted, or flagged will not be considered. Tracking and Reporting: Maintain a well-organized record of all links posted. Submit proof of work at the end of each day in Excel format, listing all successfully posted links. Work Schedule: Days: Monday to Friday Hours: 8 hours per day Skills & Requirements: Attention to Detail: Accurately track posted links and ensure they stay live. Efficiency: Achieve the daily target of 160 live links consistently. Online Familiarity: Ability to navigate various websites, forums, directories, and communities. Writin...
Found the Selected Data from One Excel file on the Other File. Both files are provided for reference. "Scores" sheet, find the same song on the
I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of employee shifts.
We are seeking a versatile Data Analyst to support multiple companies across different industries. The ideal candidate will excel in transforming raw data into actionable insights using various visualization tools and will be adept at managing and querying databases.
I need a freelancer to convert a 3-page PDF document into an Excel file. The Excel layout should mirror the PDF exactly. The PDF contains primarily text and numbers. Key Requirements: - Convert data from the PDF into Excel, maintaining the original layout. - Utilize your judgement to handle any ambiguities or potential errors in the PDF. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to make educated guesses when faced with uncertainties in the source material.
...have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day. I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly. Specific Requirements: - The new tab should be formatted as a simple table - The project is in E...
I'm seeking an experienced industrial designer to refine a metal bracket design for a curtain/blind accessory. The aim is to make the bracket easy to install, while optimising it for sheet metal folding manufacturing. Key Requirements: - The bracket should be no bigger than 100mm by 50mm and ideally will be one piece with folds. - The primary goal for the design refinement is to enhance the ease of installation. Ideal Skills & Experience: - Proven experience in industrial design, specifically with metal and small-scale products. - Familiarity with sheet metal folding manufacturing process. - Strong understanding of user-friendly design principles.
I'm in need of an Excel wizard to create a Monthly Sales MIS Report for me. This report needs to focus exclusively on sales data and perform a trend analysis. Key Responsibilities: - Collect and analyse sales data on a monthly basis. - Identify and illustrate trends in the sales data. Ideal Skills and Experience: - Proficiency in Excel, including the use of advanced functions and features. - Previous experience in creating MIS reports. - Strong analytical skills with a focus on trend analysis. - Excellent attention to detail.
Chemical Engineer Needed for Creating Industrial Chemical Datasheets and Catalogs **Description:** We are looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and cata...looking for a freelance Chemical Engineer with expertise in industrial chemicals to create professional datasheets and catalogs for our products. **Requirements:** - Research and compile technical specifications and industry applications. - Prepare datasheets and catalogs in editable formats (Word, Excel, and PDF). - Ensure the output is professional, accurate, and visually appealing. **Skills Required:** - Strong knowledge of industrial chemicals. - Proficiency in Microsoft Word, Excel, and PDF tools. - Excellent research an...
...functionality for our business needs. Scope of Work: Installation and Initial Setup: Install the Frezka salon management system on our server. Configure the system to operate under our brand name, Lotus Flower. Ensure proper integration and functionality for multiple branches. Customization Requirements: Expense Management: Add a module to track and manage expenses for each salon branch separately. The module should: Allow branch managers to input daily/weekly/monthly expenses. Provide expense reporting for each branch. Stock Management System: Enhance the system to track service-related stock usage. The module should: Maintain a stock inventory for each branch. Automatically deduct stock quantities after a service is completed and billed (e.g., deduct 200 mg of protein...
I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.
I'm looking for an experienced freelancer to design an automated system that captures data from Google Forms and generates a well-formatted PDF document. The project involves integrating Google Forms with a Google Sheet, cleaning and structuring the data, and creating a customizable PDF template. The primary goal of this automated system is to streamline the process of data collection and archiving. The system should be capable of: - Structuring the data from Google Forms into a Google Sheet with predefined headers and columns. - Performing essential data cleaning tasks, which include removing duplicates, standardizing formats (e.g., dates, text), and validating data entries. - Creating a customizable PDF template to present the data in a clear and professional manner....
I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!
I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.
I have a project to be completed in Financial Modelling througn excel.