Excel user defined function jobs

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, specifically any projects rel...

...as bug fixing. This role requires experience in: - Backend development: We need an expert who can work on complex server-side code, solve performance problems, and architectural challenges. - Frontend development: The right candidate should be proficient in developing clean, efficient frontend design, ensuring superb user experience. - Bug fixing: Need a detail-oriented coder to troubleshoot and clear out potential bugs in our website to ensure a smooth, efficient function. Candidates need to have solid experience dealing with Laravel and its intricacies. Although I didn't specify particular Laravel features in this project, having wide-ranging Laravel expertise would be a huge plus. Familiarity with Auth system, Eloquent ORM, Event broadcasting, and other Larave...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of ...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

...local inventory files on demand and update quantities available on eBay accordingly - Order Tracking -- Alert on new orders -- Identify repeat customers -- Pull specific info from buyer note or buyer messages -- Help with fulfillment by pointing to locations inventory is available (i.e. from local files) -- Have a place to store images related to transaction - Buyer Interaction -- Function for sending and interacting with buyer messages integrated in the tool. -- Templated messages with ability to add more If bidding, please demonstrate you've read the brief by mentioning you know the project is about digital goods. Let me know of any experience in developing similar tools or applications. Proficiency in desktop application development is a must. Familiarity ...

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

...create two types of websites for me. For the online store, I require specific features like a payment system, inventory management, and a live chat function. For the corporate site, I'd like a few additional features such as a contact form, service pages, and an image gallery. Ideal Skills: - Proficient in WordPress development - E-commerce website development experience - Familiarity with payment gateways - Excellent UI/UX design capabilities - Ability to create user-friendly admin interfaces for inventory management - Experience with incorporating and customizing live chat features in a website - Strong understanding of modern web design and user experience trends - Proven track record in creating visually appealing and functional corporate websites - A...

I'm looking for an app developer who can create an alumni database application that will run on both iOS and Android platforms. The primary function of the app will be to provide a comprehensive database of our alumni. Our existing alumni database will need to be integrated into the app. This will require a good level of understanding of database management and integration. I'm seeking a developer who has experience in developing apps for both iOS and Android, and who is also comfortable with integrating and managing large databases. Experience with database management systems and good UI/UX design skills are desirable. Skills Required: - Proficiency in app development for both iOS and Android - Experience with database management and integration - UI/UX design expe...

I am in need of a budget-friendly freelancer to assist with uploading my existing education application, developed with Flutter, onto the App Store. While the programming aspect is complete and the app is already successfully submitted in the Google Play Store, some clarification may be needed with regards to the necessary licenses or permissions for the App Store. The function of the app revolves primarily around interactive quizzes. Ideal candidates will: - Have prior experience with Flutter app development and distribution. - Show a good understanding of the App Store’s application process and licensing requirements. - Be able to work within a budget. Looking forward to working with a dedicated and knowledgeable professional who can help bring this application to Appl...

I'm in need of a skilled ...fully responsive. Key Requirements: - E-Commerce Site: The primary function of the site will be to sell products online. - PayPal Integration: I'd like to offer my customers the option to pay with PayPal, so you must be able to integrate this payment method seamlessly. - Mobile Responsiveness: The site must be fully responsive, ensuring that it looks and works great on mobile devices, tablets, and desktops. Ideal Freelancer: - Proficient in HTML and other relevant web development technologies. - Experience in e-commerce site development, ideally with examples of past successful projects. - Familiar with integrating payment gateways, particularly PayPal. - Skilled in responsive design and able to ensure a consistent and user-friendly exp...

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and consis...of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our milkbag character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our milkbag c...

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

...Analyst skills to manage a SaaS B2C software project. The primary goal of this project is to ensure the software meets the needs of the end-users, which involves gathering and validating requirements and writing detailed user stories. Responsibilities: - Lead the process definition for the project - Gather and validate requirements for the SaaS B2C software - Write detailed user stories - Be a bridge between the development team and the business stakeholders Your role will be pivotal in ensuring the smooth development of the SaaS B2C software. Since we currently have no defined process for gathering and validating requirements, your experience in this area will be key. Skills and Experience Required: - Proven experience as a SCRUM Master and Business Analyst - S...

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

...from the competition. We'll develop a sales process that streamlines converting leads into paying clients. I'll create engaging content to showcase your expertise and attract potential clients. We'll also explore social media marketing strategies to build brand awareness and connect with your target audience. Project Deliverables: Competitor analysis report. A clear and concise USP statement. A defined sales process. Content calendar with engaging content ideas. Social media marketing strategy tailored to your target audience. Remember to tailor these descriptions to your specific skills and experience! Here are some additional tips: Highlight your results. Quantify your past achievements with data whenever possible. Use strong action verbs. Words like "de...

...will be to incorporate comprehensive event management features. This will include: - User Registration: The application should allow for the registration of users with social login (google, X, facebook, linkedin) and verification mail. - Standard User profile definition with a set of info (Name, Surname, Photo, Address …..), selection of services thy are able to provide (multichoice from a list) e their availability (multichoice on 10 dates) - Event Registration: The application should allow for the registration of events. - Staff Allocation: The app should provide a mechanism for assigning staff to various events effectively. - Dashboard for Administrator - Creation/Modification/Deletion by Administration User (up to 5) of these Entities: o “Place&rd...

I require an app designer with solid iOS development experience to create a state-of-the-art app featuring my established fitness influencer persona. Ideally, the freelancer has deep understanding of: - Nutrition Planning: The primary function of this app will be providing nutrition advice. A platform for creating, tracking and adjusting individual nutrition plans is thus essential. - Social Engagement: The app needs to foster a fitness community, this requires implementing user profiles and community boards. Any experience in crafting appealing, interactive social platforms is a major advantage. Once completed, this app will become an integral part of my fitness influencer business. Therefore, I’m looking for someone who can deliver high-quality work and is open to ...

I am in need of an application that will download realtime 1 minute stock market data from the New York Stock Exchange (NYSE) and save it to a csv file. The application must be compatible with Windows. Key Features: - **Data Downloading**: The primary function of the application is to download 1 minute stock market data from the any chosen stock exchange in real time. - **Data Saving**: The downloaded data needs to be saved to a csv file. - **Data Filtering Options**: The application should allow for various data filtering options to facilitate data analysis. - **Real-time Alerts**: It should provide real-time alerts triggered by certain market conditions as well as calculated alerts based on oscilator calculation - **Historical Data Access**: The application should also facilitate...

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

...tech company, "Forward Flow". I imagine it to be simple in color, leaning towards a minimalistic style with both an icon and text component. - Would like the design to use two "function - "f" symbols as well as possibly incorporating an arrow for the "Forward Flow" name of the company. Would like the first design to be black and gold. **PLEASE SEE THE FUNCTION SYMBOL. THIS IS A MUST**** Key requirements: - Design a simple color scheme for the logo. (Black + Gold) - Create a logo that is minimalistic in style. - Develop a logo that incorporates both an icon and text. - Would like the design to use two "function - "f" symbols as well as possibly incorporating an arrow for the "Forward Flow" name of the c...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...

I'm looking for a skilled individual to develop a custom Google script spreadsheet to cater for my company's specific needs in the area of sure betting/matched betting and accou...discussion. The successful candidate should be adept in data analysis and Google script. Excellent understanding of betting operations and accounting are also required for seamless execution of this project. Note that no API connection is needed in this task as it's solely designed for internal use. Your responsibility will involve creating the custom function, implementing sure betting/matched betting and accounting operations. Your ability to create user-friendly interfaces and consider future scalability in your development approach would be a plus. Looking forward to discussing...

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

Looking for a CPA from Philippines with strong English skills, multi-years work experience in Xero, QBO, MYOB, Sage for US/Australia/NZ companies. Tax filing experience would be an added skill. Overall engagement would start small but can grow into a full time engagement depending on the quality of work delivered. The role would entail shift working and the work hours will be a function of client requirements. (PH night shift/early morning shift). Only looking at Individual Freelancers with CPA qualification, team bids will be rejected. If this description excites you, happy to chat. Experience in automation in accounting and comfort with writing accounting / finance content preferred. The price range quoted is monthly price range.

...proficiently fill in the gaps of this project: - You may be tasked with an array of responsibilities such as development of smart contracts, network setup and configuration, and chaincode deployment. - It's uncertain at this point whether the goal will be to develop a new Hyperledger Fabric network, join an existing one, or something else. - The exact purpose of the project is not currently defined, but application areas may include supply chain management, financial transactions, or identity management. The ideal freelancer for this project will have proven experience and demonstrated skill in all areas of Hyperledger Fabric, adaptability to evolving project requirements, and the ability to effectively communicate and collaborate within a team environment. This project...

...product catalog. The website's main function is to display a catalog of physical products in a structured and appealing manner. However, I do not require an e-commerce functionality. Customers should be able to browse the products without the ability to purchase them directly from the website. Key features of the website: - Showcasing physical products: Your task will be to create a visually pleasing platform that displays the products effectively. - Search functionality: The website should include a search bar with filters for categories. This will enable users to easily find the products they are looking for. The ideal candidate should have experience in developing interactive websites with a focus on product catalogs. It's crucial that the website is user-f...

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

I'm currently studying at an advanced level in quantum physics and am looking for an experienced tutor who can guide me through unchartered territories. The specific topics I need to cover are not defined yet, hence flexibility and depth of knowledge will be key. Ideal candidate: - Degree in Physics or related field - Extensive experience in advanced quantum physics - Expertise in various quantum physics topics - Proven record of effective tutoring Please note, the deadline for this project is flexible as I'm focusing on comprehensive understanding rather than fast-paced learning. Your availability and commitment to the project will be important. Let's help me dive deeper into the world of quantum physics.

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

...whose main aim is to share pertinent school information to its broad user base. The website should include, but not be limited to: - Regular updates about school news and events, ensuring the school's community remains engaged and well-informed. - Detailed information on the school's curriculum, providing a transparent view on our academic focus and approach. - Bios of our dedicated staff and teachers, so our community can get to know the people who shape our institution. Additionally, the website should possess the following functionalities: - A calendar of events, to help plan and coordinate with the school schedule. - An online registration form, easing the enrollment process for new students. - A search function, for efficient and easy navigation a...

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

I urgently need an app like Lenovo Vantage developed to perform user support assistant functions, such as checking for driver updates from our main site and providing comprehensive device information like processor details, RAM, and hard disk usage. Key Features: - Driver update checker: The tool should easily and effectively check for updated drivers and software from our main site. - Device information display: It should supply full device information, like processor details, RAM stats, and hard disk usage reminiscent of Lenovo Vantage or HP assistant. Compatibility and Timeline: - Platform: The software should be primarily compatible with Windows. - Deadline: As this project is urgent, I am seeking a fast-turnaround, ideally as soon as possible. Ideal Freelancer’s Skill...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including one to two data entry projects you hav...

I'm looking for a skilled Node.js developer who can implement RabbitMQ into my project. The primary function of the system will be message processing. The ideal candidate should be able to: - Implement RabbitMQ into a Node.js project - Set up direct messaging, a publish/subscribe model, and routing with topics - Ensure that the system automatically retries messages in the event of failure The system should be able to handle message failures by automatically retrying them. There are three main aspects of RabbitMQ that I'm interested in utilizing: direct messaging, a publish/subscribe model, and routing with topics. Please only apply if you have prior experience with RabbitMQ and Node.js.

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

I need an experienced developer to finish up an...to: - Imports of large product datasets (50,000 products) - Proper categorization and hierarchical organization of products - Development and implementation of a search function that can promptly and accurately yield results, even with this high number of products. Skills & Experience Required: - Proven track record in setting up and managing high-capacity, e-commerce websites - Proficiency in e-commerce platforms such as WooCommerce, Shopify, or Magento - Experience in data management - Excellent problem-solving capabilities The goal is to have a seamless shopping experience for the user and robust back-end management capabilities for the owner. Let's discuss your previous work and how you pl...

...seek a professional capable of conducting a detailed analysis on fluoride concentrations in portable water sources. The deliverable for this project is a comprehensive report that includes all findings, statistical interpretations, and recommendations based on the findings. The specific requirements are as follows: - **Scope**: The analysis will be conducted on water samples collected from a defined area. - **Timeframe**: I require the project to be completed and the final report delivered within 2 weeks. This is a critical aspect of the project, and I need someone who can work efficiently without compromising the quality of the analysis. - **Format**: The final report should be presented in a Word Document format. You should be experienced in environmental science or chemistry...