Vba excel accounting systemmunkák

I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of ut...

We need a professional to integrate a star rating and comment-based review system into our existing website. This new functionality will give our website visitors the capability to rate our products/services and also leave comments. Primary Functionality required: - Star Ratings - Comment-based Reviews Secondary Functionalities: - Replies to Reviews: An essential aspect of this project is the ability for our administrative team to reply to any reviews. We want to foster a transparent communication culture, and this functionality is crucial. Ideal Skills Required: - Proven expertise in building/integrating review and rating systems. - Good understanding of user interfaces. - Experience in crafting interactive and engaging online environments. - Strong grasp on fostering online co...

I'm seeking an experienced PHP developer with exceptional MySQL knowledge for a unique project. The task requires setting up cron jobs for data fetching, which should run routinely in the background. This data pertains to 'user information', 'ranking system,' . Ideal Skills: - Expertise in PHP & MySQL - Experience in server-side crontabs jobs - Ability to setup a rewards system -json Additionally, the system should enable rewarding bonus points for successful data fetching. The number of bonus points to be awarded will be communicated later. However, you must have experience in developing such points-based rewards systems. Your creative ideas to implement this feature are welcome as well. In summary, I seek someone who can make these pr...

I'm looking for an individual proficient in data entry, email management, online research, and making phone calls. Your daily tasks will primarily involve: - Performing data entry tasks using Microsoft Excel - Managing email communications effectively and promptly - Conducting online research as required - Making certain phone calls when necessary -Schedule is 9am-3pm CST (Monday-Friday) In addition, experience with project management software 'Click Up' will be highly favored. A strong work ethic, attention to detail, and excellent communication skills are fundamental for this role. The selected candidate will be expected to perform these tasks on a daily basis. Your ability to meet deadlines and work independently will contribute significantly to the smooth operat...

...Tally System for our small business operations. It is a standard Tally setup SILVER Single user edition For Standalone PCs perpetual licensing. This system should be compatible with Windows and and or ChromeOS include the following features: 1. Inventory Management: Efficient tracking and management of resources to prevent overstock and outages. ALso to track history of items. 2. Sales Tracking: Recording and evaluation of sales data to assess performance and project trends. 3. Tracking of expenses:Tracking of expenses including billables, 4. Financial Reporting: Basic financial reports to aid in decision-making and ensure legal compliance. 5. System must be ready to be integrated local authority invoicing compliance (Zambia Revenue Authority Smart Invoice) Addit...

...symbolic, embodying the spirit of the deck rather than focusing on our brand name or a product-related visual. The ideal candidate for this role should have strong experience in graphic design, particularly in modern design and abstract logo creation. They should be innovative, with the ability to transform a classic item into something new and fashionable. If this sounds like a project you'd excel in, I'd love to hear from you. Please note that the design should consider Arabic and English...

I need a excel data sheet typist frequent in basic as well as skillful skills. There's no error in the formats and also professionally done with great effort.

I'm a fresher working on a Workday implementation project. I need a consultant to help me clear my doubts and provide insights regarding Financial Accounting, Business Assets, and Procure-to-Pay (P2P) areas. Key Requirements: - Ability to explain complex Workday Finance concepts in an understandable manner for a beginner - Experience with Workday implementation projects - Strong understanding of Financial Accounting, Business Assets, and P2P modules Communication: I prefer to communicate through instant messaging. Ideal applicants will have: - Experience as a consultant in Workday - Experience working specifically with Financial Accounting, Business Assets, and P2P modules. Please share your experience in Workday and how you can guide a newcomer through the...

Hey! I have experties on statistical analysis.

I am in need of a fully capable Employee Time Tracking System. This should include: - A time clock for clocking in and out. - A feature for employee scheduling. - Payroll integration for simplified financial management. - Each Employee will have their own profile within the system. This system should cater to more than 50 employees. I would prefer a text-based (classic) user interface that prioritizes functionality and ease of use over visual flair. Experience with time tracking or payroll systems will be ideal for accomplishing this task. Furthermore, I require full rights to this system once uploaded to my server. This is not just a job of installation, but the provision and setup of the system itself. Therefore, freelance developers with a background...

We are looking for a freelancer to scrape product information from Website and organize it in an Excel spreadsheet. Key Requirements: - The script should extract all text content and images displayed on the homepage need be add to excel file

I am seeking a professional with expertise in HVAC design for a medium-sized chu...with expertise in HVAC design for a medium-sized church. The design should predominantly and effectively enhance the indoor air quality. Key responsibilities will include: - Creating an HVAC design that ensures optimal indoor air quality - Providing a design that abides by all guidelines and standards for public buildings - Considering various factors including occupancy level, room layout, and system efficiency Ideal candidates should: - Possess significant experience in HVAC design for public spaces, churches preferably - Showcase proficiency with industry-grade design software - Have a deep understanding of air purity management within HVAC design - Show a commitment to timely and professional...

...configurators in one system. A separate configurator for each product. 2. Only display configurator after entering a customer number. Configuration is not possible without a customer number. 3. Use customer number to recognise which configurators / products are available. 4. Do not display prices on the website, no direct sales. 5. The preview image of the product should be constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are added and finally sent to the customer. A second ...

IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracker Employee Attendance Tracker and Payroll Exce...

I'm looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. - Strong communication skills and a proactive approach to project management. I'...

I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel: The freelancer should have excellent skills in using Excel for data cleaning...

In need of a detailed-oriented freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entry position will be highly regarded.

I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you find are high quality and in either JPG or SVG formats. Your work will be integral in the creation...

I'm looking for a PowerBI expert to set up a dashboard for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - Resource Allocation: Demonstrating how resources a...

I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.

I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is preferable.

We are looking to collect the current prices for 5 specific procedures from local clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up on the caller ID. Start immediately. Pay is $250. Do not bid higher, as we will not...

I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.

I need to Upgrade Year 2012 develeoped CakePHP Portal with addition of new feature and system. The portal was developed with some feature a year ago need some more development Those with experise in Cake Php and have worked on earlier version may respond

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.

I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear an...

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear an...

I am looking for a professional who can design and develop advanced-level course content focused on the Microsoft server system. Key Details: - The course should entail topics such as installation and configuration, security and administration, and troubleshooting and maintenance. - The target audience for the course is those with advanced expertise in the domain. - I prefer the content to be primarily delivered in the format of slide presentations as well as in document format Ideal Skills: - Well-versed with Microsoft server system with hands-on skills in the Microsoft Azure environment - Experience in designing educational content - Proven ability to present complex technical information in a clear and comprehensible manner - Proficient in creating engaging slide prese...

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management proces...

...three-pronged job involving: 1. Entering Contact Information: You will input a myriad of contact details into an Excel spreadsheet. Accuracy is paramount. 2. Updating Databases: You'll be responsible for ensuring that all existing data is up-to-date. If a discrepancy is noticed, you will correct it. 3. Transcribing Documents: Transcription services are required. You need to accurately transcribe information from diverse documents. In addition to the aforementioned tasks, this job involves email verification for all entries; without exception. Needless to say, your keen attention to detail would be required to spot and correct any errors. The ideal candidate would have past experience with Excel spreadsheets, database management, and transcription. Excellent typing ...

...analysis. Achieve monthly targets of 150 salons signed and 3,000 app downloads to qualify for performance bonuses. Provide real-time geolocation updates during field movements. Candidate Requirements: Minimum 2 years of experience in B2B sales, preferably within the beauty, wellness, or tech industries. Strong understanding of sales strategies and customer relationship management. Proficient in Excel and capable of managing basic sales data analysis. Exceptional communication and interpersonal skills. Ability to commit to BookBook's unique brand and sales approaches. Must be organized, self-motivated, and capable of working under pressure to meet sales targets. Compensation and Incentives: Monthly salary of £2,000 after taxes. Promising £4,000 compensation follow...

I need help s...up a monitoring system using APC NetBotz to ensure the conditions in my server room are maintained. The system should be configured to send me email alerts when the set thresholds are exceeded. Key requirements: - Configure the APC NetBotz system to continuously monitor the temperature and humidity in my server room. - Set up alert thresholds for temperature and humidity that align with the recommended operating conditions for servers. - Ensure that when these thresholds are exceeded, the system automatically sends an email notification to me. Skills and experience needed: - Prior experience setting up APC NetBotz monitoring systems. - Proficiency in configuring alert thresholds for temperature and humidity. - Ability to integrate email notific...

As a business, we are seeking a competent full-stack developer with expertise in JavaScript, PHP, Node.js and MySQL. Key Requirements: - In-depth knowledge of JavaScript and PHP as the primary coding languages, complemented with MySQL for the database management and Node.js for backend services. - Experience in integrating and working with APIs. The project demands the incorporation of Amazon Comprehend and OpenAI. So, the ideal candidate must be well-versed with these. - The ability to work with little to no guidance and have a problem-solving attitude. - Proven record of past successful projects involving similar stacks and APIs would certainly be advantageous. This job is more suited for someone eager to explore and learn while contributing positively to the project. As an agile te...

I'm in need of a Python Engineer with experience in TensorFlow to develop a Desktop application Stock Analysis System. The system is intended to perform real-time stock data analysis and would utilize an AI-driven stock selection algorithm, derived from Indexes, Sectors, ETF's, and subsections. Key requirements include: - Implementation of real-time stock data analysis capabilities - Development of an AI-driven stock selection algorithm - Proficiency in Python, with a strong preference for TensorFlow - Experience in creating Desktop applications Ideal candidates for this project should have a solid background in machine learning, particularly in using TensorFlow for AI applications, as well as a strong understanding of stock market principles. They should ...

I am looking for a skilled HVAC professional to help me design a central air conditioning system for my new 3264 s.f. one-story house, plus creating a hot and cold water plumbing layout. Key Requirements: - System must be designed with energy efficiency and cost-effectiveness in mind - Incorporate Smart Thermostat Integration - Include Zoned Temperature Control Ideal Skills and Experience: - Previous experience in designing HVAC systems for residential properties - Familiarity with the latest technology, particularly in the area of Smart Thermostats - Ability to incorporate zoned temperature control into the design This is a key part of the comfort and energy efficiency strategy of my new home, so a thoughtful and experienced approach is crucial. Thank you.

I am seeking a proficient expert to craft 3 interactive system overview diagrams. one for the backend communication of the system one for the on device functions of the system one for the overall system overview. All of them should be annimated

...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...

Estoy buscando un asistente virtual y administrativo para realizar las siguientes actividades operativas en un negocio: Revisar y agregar datos en documentos de Excel. Elaborar reportes en Excel. Gestionar la agenda de proyectos. Revisar y agregar tareas de proyectos en el calendario. Redactar minutas y resúmenes de juntas. Establecer prioridades de actividades. Registrar datos generales como facturas, órdenes y proveedores en el sistema ERP. Crear manuales de procedimientos en Word. Herramientas de manejo: Excel a nivel avanzado. Loop o Notion. Conocimiento de los procesos de un ERP. OneDrive (administración y manejo de archivos). OneNote y Word.

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

...timeline to keep visitors updated about the company's history and progress. - Integration with Microsoft Exchange, - SEO ( ✔ SEO - Get a #1 Ranking on Google. ✔ Result Oriented work ✔ Provide Guaranteed improvements ✔ Customer support after completion of the project ✔ Transparency and Performance Monitoring) Upmost, the unique feature that should be added is a comprehensive School Information System (SIS) to manage different facets of our educational establishment digitally. That will underpin the whole functionality of the website and bridge the gap between the school administration, educators, students, and parents. Ideal candidates for this project should have extensive experience in corporate website development, client-server architecture, real-time chat functionality...

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more d...

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project is to ob...