Excel vba for finance professionals jobs

I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.

...OctoberCms to create a comprehensive hospital directory website. The site will serve as an important tool for patients, healthcare professionals, and the general public to find relevant information, connect with doctors, and explore hospital services. Key Features: - Doctor Profiles: A robust database of doctors' profiles. - Treatment Information: Detailed information about various treatments offered by the hospital. - Speciality Search: An intuitive search functionality for patients to find doctors based on their speciality. - Online Forms: Online forms for appointment booking and other requests. Key Objectives: - Provide Information: The website should serve as a reliable source of information for all visitors. - Booking Appointments: Enable ...

In search of a female English speaking content creator. The ideal candidate should have a professional demeanor and be able to create engaging social media reels / short videos related to finance. Skills and experience required: - Fluent in both English and Hindi - Can wear professional clothing (blazers, shirts etc) - Experience in creating engaging content - Must be expressive - Must have mic, camera, green screen & lighting Each week we will be needing 12 videos (45 second each) related to the given topics. This is a long term project and will be active for a minimum of 24 weeks.

...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF docume...

...dataset to be used for reporting and analysis. Key Responsibilities: - Cleaning up all the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deli...

I am looking for a personal mentor who can help me improve my understanding of Microsoft Dynamic365 finance and operation, specifically in the area of financial management. As a beginner in this field, I need someone who can guide me through the basics and help me gain confidence in navigating and using the software effectively. Ideal Skills and Experience: - Strong knowledge of Microsoft Dynamic365 finance and operation, with a focus on financial management - Previous experience mentoring beginners in this field - Excellent communication and interpersonal skills - Ability to provide clear explanations and step-by-step guidance Mentoring Sessions: - Twice or more a week - In-depth discussions and hands-on practice - Assistance with specific tasks and challenges - Reg...

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and fun...

I'm searching for a proficient mail developer who can accomplish the following tasks: - Write engaging email copy. - Create a Zimbra mailer using either SOAP API or EWS. You must have experience with all mentioned platforms, namely Zimbra, SOAP API, and EWS (Exchange Web Services). The developed Zimbra mailer needs to have the functionality to send emails. Kindly bid if you have the necessary skills and experience. Look forward to working with professionals in this area.

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.

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 starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing...

...with writing website content and product descriptions. The content should be tailored towards business professionals. Key Requirements: - Creation of engaging, informative and professional website content - Crafting SEO-friendly product descriptions Ideal Skills: - Proven experience in writing compelling website content and product descriptions - Understanding of SEO principles and practices - Knowledge of the tone and style suitable for business professionals This job requires high quality, engaging content that resonates with business professionals. The writer should be able to efficiently communicate information about our services and products, while also ensuring it's optimized for search engines. Experience with similar projects or a portf...

I'm in search of an experienced video editor who can create professional and clean YouTube thumbnails and custom content videos that extend beyond 10 minutes. - The ideal candidate must have a knack for minimalistic yet appealing visuals. I'm particularly interested in those with a keen eye for detail that can convey the essence of my videos effectively via the thumbnails. - As my videos are custom and relatively extended content, I'm looking for someone who can creatively break down the gist while maintaining the allure, ensuring the viewers stay engaged and find the content insightful. Skills and Experience: - Proficient in video editing software such as Adobe Premiere Pro, Final Cut Pro etc. - Experience in creating engaging YouTube Thumbnails -...

I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regarded.

I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - O...

...focused heavily on photos. I have attached some examples below as well as our company name and graphic to possibly be included on posts. We would like to have an overall theme for every post. Key Elements: - Despite the user not selecting any specific template designs, your creative acumen to propose a diverse mix of templates is welcome. - The templates should effectively communicate our company's values and mission, depict the benefits of our products and services, and provide industry insights and education. - Keep in mind that these templates need to cater to a varied audience; general public, industry professionals, and potential clients/customers. Ideal Skills and Experience: - Strong graphic design skills - Familiarity with Instagram's style and format -...

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with t...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I'm seeking a professional with experience in the music industry and digital c...upcoming artist. Your job will involve: - Distributing a press release to music industry blogs and across various social media platforms. - The press release will need to encompass key elements such as background information about the artist, details about upcoming projects and releases, as well as any noteworthy achievements and awards. - The target audience for this communication piece includes music fans, industry professionals, and the general public. Ideally, you should have: - Proven experience in public relations or press release distribution. - A comprehensive understanding, and established networks, within the music industry. - Strong communication skills and familiarity with s...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing...

...responsiveness: Ensuring the game runs smoothly on ANY browser (desktop or mobile) and without any issues is crucial. - Enhance the website's completeness and social media integration: The game should be fully integrated into the website and connected well with social media. - Improve the architecture to allow for future features: The game should be in a state that it can be easily expanded upon and updated in the future. - Provide suggestions for future development: I'm also looking for someone with creative vision who can suggest what aspects of the game to work on next. Ideal skills and experience: - Previous experience in web game development is a must. - Proficiency in graphic design and animation. - Strong problem-solving skills to handle bug fixes ...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and cha...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skills in data out...

I need a modern logo and business card design template for my business "Peak Point Branding". - I prefer the colors blue, green, and white for both the logo and the business card. I like light shades of these colors. - The style and theme of the design should be modern. - The target audience for my business are professionals. Ideal Skills and Experience: - Graphic Design: You should have experience in designing modern, professional logos and business cards. - Understanding of Color Psychology: Knowledge of how different colors can influence the audience is a plus. - Branding Experience: Experience designing for professional target audiences will be highly valued. Please make sure to provide a portfolio of your design work, particularly any...

business profit loss reporting excel(Jan, Feb & March)

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis ...

Being familiar with grocery industry finances, I need an expert to conduct a detailed analysis regarding a store's annual profitability. This involves but is not confined to: - Breaking down costs and expen...and understanding profit margins The ideal professional must have experience in financial data analysis with exquisite accuracy. Favorably, knowledge or background within the grocery retail sector is advantageous. The final analysis report should be delivered in a well-structured PowerPoint presentation that encompasses all key findings. It's important for the report to be clear, and easy to understand for non-finance personnel. I am open for any approaches or suggestions, as long as they fulfill the core objective of this project: gaining relevan...

...search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previous WPJM Plugin and Smyles Plugin Projects you have previously worked...

SEI Membership Club, the leading international company, is home to exceptional high-net-worth individuals who are self-made, often billionaires, entrepreneurs, nobility, high-level professionals, and elite members. The company needs talented artists who are abstract and landscape watercolor and oil paint experts

I am seeking a freelancer to assist me in establishing connections with businesses and medical professionals across the USA. The site is You're tasked with the following: - Identifying and reaching out to potential prospects from these sectors in the USA. - Facilitating initial contact and engagement with these prospects. - Providing regular updates and reports on the progress and insights from these interactions. I am open to suggestions on the best strategies to achieve this, be that through marketing, sales, or networking. Your expertise in these areas would be invaluable. Please provide some details on your relevant experience and how you plan to approach this project.

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I'm seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists and or private equity. This document should include detail...specifically aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial information, such as: - Revenue projections - Profit and loss statement - Balance sheet - Adopt government statistics - Market & Industry Analysis - Design funding models The ideal candidate for this job should have a solid background in finance, business analysis, and experience in creating successful Information Memorandums for the Australian market. They should be able to present complex financial data in a clear and concise manner ...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm seeking knowledgeable professionals to provide accurate structural calculations and plans for a vast commercial warehouse exceeding 10,000 square feet. The project demands vast knowledge and experience in large-scale commercial building design conforming to local building codes and standards. You should have: - Proven expertise in commercial building design, particularly warehouses and racking system - Strong understanding of building codes and standards. - Ability to communicate effectively and provide clear, comprehensive plans. Your responsibility will be: - Developing structural calculations that adhere to safety and local building codes. - Creating detailed plans for the entire warehouse structure.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis ...

I'm developing an educational keynote presentation intended for professionals in the field. It will be centered on notes on leadership. The end goal is to provide insightful content that sparks thought and discussion within this audience. Key Points: - The delivery medium will be an iPad. - The presentation will contain a mix of videos, stills, and text. Ideal Skills: - Excellent command over presentation design. - Ability to integrate multimedia elements seamlessly. - Familiarity with the use of iPads to deliver presentations. - Excellent communication skills and the ability to interpret my notes for compelling storytelling. I'm looking forward to collaboration to make this presentation impactful and engaging.

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% How...

...developed that will serve as a platform for my healthcare company. The site will have a three-pronged approach to content, focusing on: - **Services Offered**: I want to showcase the range of services we provide. This section should be clear, concise, and informative. - **About Us**: This is where I want to introduce the visitors to our company - our values, mission, and vision. It should be detailed yet engaging. - **Contact Information**: I need a clear and easily accessible way for potential clients or partners to reach out to us. The target audience for this website will be varied, including: - **Patients**: I want the site to be easily navigable for patients seeking our services. - **Healthcare Professionals**: This section should speak to ...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, p...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I'm looking for a talented app designer to create an app that will serve as a job portal in the movie industry. The app will be available on both iOS and Android platforms. Key Features: - User Profiles: Users should be able to create and maintain profiles showcasing their work and experience in the movie industry. - Push Notifications: The app should feature push notifications to keep users informed about job opportunities and industry news. - Search Functionality: A robust search functionality is crucial for users to easily find relevant job postings. Ideal candidates should have experience in app design, particularly in developing user-centric and intuitive interfaces. Knowledge of job portals, or similar platforms, will be an added advantage. Your work will directl...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...