How to automate monthly reports in excel jobs
...who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if ...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using ...
I'm looking for an expert in MacroDroid to help me automate some repetitive tasks and customize existing macros. The ideal freelancer for this project should have: - Proficiency in using MacroDroid to automate tasks and customize macros. - Experience in sending automated messages via different platforms. - Ability to understand and enhance existing macros. - Strong problem-solving skills and attention to detail. Key Responsibilities: - Automate sending messages through MacroDroid. - Customize existing macros to suit my needs. - Suggest and implement better ways to automate tasks. Please note that the specific platforms for sending the messages are yet to be determined.
Hello Freelancers, I am looking for an experienced professional who can assist me in extracting specific details from Tally using ODBC. The required data fields include: Purchase date Invoice number Vendor name Product (inventory name) Product quantity Rate Amount SGST CGST IGST Freight charge Gross amount The task involves creating a TDL (Tally Definition Language) or TCP (Tally Compiled Program) file that will facilitate the extraction of this data from the Tally database using ODBC Requirements: Strong knowledge and experience with Tally and its database structure. Proficiency in TDL or TCP file creation. Familiarity with ODBC for database connectivity. Ability to automate the extraction process to ensure seamless and accurate data retrieval. Delive...
As a client, I'm in need of a gifted freelancer who will design an AI chatbot that works hand-in-hand with Google Assistant. This chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information
...can help me automate the process of saving PDF attachments from Outlook emails. Key Requirements: - Extract PDFs based on dates within the PDF text: The PDFs should be saved based on a specific criterion - dates within the PDF text. Your role will be to parse these dates and save the files in a designated folder on my computer. Skills and Experience: - Proficiency in Outlook: A deep understanding of Outlook's email management functionalities is a must for this project. - PDF Parsing: Experience with parsing text within PDFs is essential. - Automation: The ability to create a script or use a tool that can automate the process of saving the PDFs according to the specified criteria. - Efficiency: The project needs to be comple...
...appreciated. Complete, operational, custom web site for drop shipping business. Use whatever language is best suited, we prefer word press (this allows us to do minor modifications inhouse- no programming expertise). Along with the web site, suggest name (search on net and proposed office locations), design logo and compose tagline. All copy by client. Topics covered: Vision, mission, contact, FAQ, terms & Conditions, Returns, Refunds, Shopping from a catalog, Live+Chatbot, order processing, confirmation, tracking, cancellation, payment processing, credit, debit, digital wallets, EFT, (No COD, No Checks)Shipping choices and info, Shopping cart, Days to delivery, Visitor, customer mailing list, Loyalty program, Social media accounts, FB, Whatsapp, Youtube, Instagram, T...
...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical know...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I'm in urgent need of a Tableau expert who can assist me with my data visualization and dashboard/reporting needs. Your responsibilities will include: - Crafting effective and visually appealing data visualizations - Developing interactive and insightful dashboards and reports I will provide you with the specific data and objectives for these visualizations and dashboards. The ideal candidate for this position should be proficient in Tableau and have a strong background in data analysis and visualization. Experience in working with sales data would be a plus, although not mandatory. This is an urgent project, so I need someone who can start immediately and complete the work quickly.
I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage th...
...experienced CRM expert to develop a customer relationship management system tailored for my business needs. Key Functionalities: - Contact Management: In-depth contact organization, segmentation, and efficient communication tracking. - Lead Tracking: Robust lead capture, tracking, and conversion analysis. - Sales Forecasting: Accurate prediction of sales trends and opportunities based on the CRM data. User Base: - The CRM system will be used by 1-50 users, so it should be user-friendly, scalable, and efficient. Integration: - It's imperative that the CRM can seamlessly integrate with other systems, particularly: - Email Platforms: For streamlined communication and lead nurturing. - Social Media: To enhance customer engagement and acquisition. - Accoun...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
Money and all it takes to make it in easy steps even a 14 y/o can deal with
...specifically cater to the financial management and planning needs of small business owners. The app should enhance their capabilities to handle their finances effectively. Key Features: - Comprehensive Financial Management: The app should allow users to input their financial data, including income, expenses, and capital. It should then generate insightful reports and analytics to help them make informed decisions. - Budgeting and Forecasting: The app should have a feature that assists in creating budgets and forecasts to help business owners plan their financial future. - Alerts and Reminders: The app should be able to send alerts and reminders for important financial tasks like tax payments, billings, or loan repayments. - User-...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using ...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
Validation of Sample implementation of One Loan product (Business Loan) created by Transdigital team. - Help Transdigital team in End to end testing of the system after product configuration - Creation of Roles and Users - Generation of Reports - Conducting on the job training for Trasdigital Business Analysts
I'm in need of a debt collector agency with 1-5 years of experience to help me recover outstanding debts across various sectors. I require a set of services including: - Debt collection: Handling overdue payments across different types of debts, such as consumer, business, medical, and government debts. - Skip tracing: Locating the whereabouts of debtors who have gone off the grid, making it difficult to recover owed funds. - Credit reporting: Providing me with updated credit reports of debtors to help assess their current financial status and determine the best approach for debt recovery. Experience in this field is crucial, as it requires a deep understanding of debt collection laws and practices. The ideal agency should have a proven tra...
...sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cur...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.
Please Sign Up or Login to see details.
I am in need of an Android automation expert who is proficient in MacroDroid to help me automate actions within a specific app. Key Requirements: - Automating app actions: The task involves automating complex and advanced actions within an app. This includes extracting data from the app and setting up conditional actions based on the app's content. Please note that this is not a simple open/close app task, but rather more complex interactions within the app itself. Ideal Skills and Experience: - Prior experience with MacroDroid or other automation tools for Android. - Strong understanding of Android app behavior and the ability to extract relevant data. - Experience with setting up conditional actions and advanced automation scenarios. - Ability ...
...data using Google Forms in Arabic, and I am looking for a freelancer to perform a statistical analysis using SPSS. Key Deliverables: - Statistical Analysis: The main goal of this project is to conduct a statistical analysis on the data. The analysis should focus primarily on descriptive statistics, so the candidate should be proficient in this area. - Detailed Report: I need a report that delves into the analysis of the data in depth. This report should include detailed tables and charts. Ideal Skills and Experience: - Proficiency in SPSS: The chosen freelancer must be well-versed in using SPSS for statistical analysis. Previous experience working with Arabic data would be a plus. - Data Analysis: A strong background in sta...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
...seeking a writer to compose a 25-page double-spaced report which delves into the connection between ESG scores and real estate company performance. The main questions I'm looking to address in the study are; - Are real estate companies with high ESG scores more profitable? - Does having a high ESG score increase investor interest in real estate companies? - What is the correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suite...
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
I am looking for an experienced freelancer to help me automate the saving of PDF email attachments from Outlook. I currently use the Outlook Desktop Application and need to save these attachments without having to open each email individually. I have 4,000+ emails to check Key Requirements: - Expertise in Outlook Desktop Application - Proficiency in creating automated systems - Knowledge of PDF handling and saving - Timely and efficient work delivery - A good communicator to understand requirements and provide regular updates The saved PDFs do not need to be organized in any specific manner; they can all be stored in a designated folder. I'm hoping to streamline this process and save time. If you hav...
Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.
As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.
I'm in need of an expert to develop a vendor registration system for my company. This system will automate the entire registration process for vendors interested in doing business with us. Key Features: - Simplified Vendor Onboarding: The system should allow vendors to quickly provide necessary information. - Document Submission: Vendors should be able to upload business registration documents directly onto the platform. - Verification: The system should be able to verify the submitted documents and inform the vendor of their approval status. Data Collection: - The system needs to capture vendor information including their company name, contact details, and specific business registration documents. Registration Details: - Com...
...seguridad y accesibilidad? ¡Te estamos buscando! Are you an expert in website optimization and auditing? Do you have experience in improving SEO, performance, security, and accessibility? We are looking for you! Responsabilidades / Responsibilities: - Realizar auditorías completas de sitios web en SEO, rendimiento, seguridad, accesibilidad y experiencia de usuario. - Provide comprehensive website audits in SEO, performance, security, accessibility, and user experience. - Identificar y reportar problemas y oportunidades de mejora en el sitio web. - Identify and report issues and opportunities for website improvement. - Crear informes detallados con recomendaciones prácticas y priorizadas. - Create detailed reports with practical...
hello I am currently looking for a lawyer who can provide legal help regarding IT. Salary will be provided on a monthly basis and additional details are as follows. -Duties: Creating/editing/reviewing international personal information protection laws and terms of use In addition, legitimacy checks are conducted when operating apps and websites. -Budget: $100/month (Budgets may continue to increase as the company grows in size and sales increase)
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
As a real estate professional, I'm in need of a Certified SEM Expert with extensive experience in Google Ads to help me boost my product sales. Key Responsibilities: - Implement creative and strategic Google Ads campaigns to drive qualified leads - Optimize ad spend and conversions to ensure a high ROI - Monitor and analyze campaign performance and provide regular reports Ideal Candidate: - Proven track record in managing real estate-focused Google Ads campaigns - In-depth understanding of the real estate market - Google Ads certification - Strong analytical and problem-solving skills - Excellent communication and reporting abilities Please include examples of your past work in your proposal, particularly those that hav...
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required e...
I'm in need of a professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the reali...
in general I don't get the Greek characters in the description and all the buttons "complete", "delete" etc. throw this error and the reports are not generated its probabely some issue with the path or smtp notifications. please have a look at the video. i will send you the site and db on chat budget: $15-$20 USD deadline: 20/5
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing
I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes
...automation tester who is proficient in Appium and TestNG framework. - Target Platforms: I need the testing to work for both Android and iOS. This includes setting up the necessary environment for this cross-platform testing. - Types of Tests: I'd like to automate Functional, Regression and Performance tests. The freelancer should have a strong understanding and experience in automating these specific types of tests. - Devices/Emulators: The tests should be performed on any available device. There is no specific device or emulator requirements. Ideal Skills: - Proficiency in Appium and TestNG framework - Experience in cross-platform mobile testing (Android and iOS) - Proven background in automating Functional, Regression an...
...automation tester who is proficient in Appium and TestNG framework. - Target Platforms: I need the testing to work for both Android and iOS. This includes setting up the necessary environment for this cross-platform testing. - Types of Tests: I'd like to automate Functional, Regression and Performance tests. The freelancer should have a strong understanding and experience in automating these specific types of tests. - Devices/Emulators: The tests should be performed on any available device. There is no specific device or emulator requirements. Ideal Skills: - Proficiency in Appium and TestNG framework - Experience in cross-platform mobile testing (Android and iOS) - Proven background in automating Functional, Regression an...
