Excel vba calling code workbook jobs
I'm looking for an expert in Microsoft and Visual Basic for Applications (VBA) to streamline my repetitive financial data entry tasks. Key Tasks: - Develop a VBA script to automate the entry of financial transactions Ideal Profile: - Proficiency in programming with Microsoft and VBA - Previous experience in automating data entry, preferably financial transactions - Strong attention to detail to ensure accuracy in data entry automation - Basic understanding of financial transactions for effective development of the automation system The successful freelancer will create a simplified and efficient data entry process that eliminates the manual input of financial transactions. Attention to detail, speed, and efficiency are vitally important for this project.
I'm in need of a multi-talented individual with experience in three distinct areas: sales, graphic design, and virtual assistance, to help streamline my business operations. English fluency is paramount as effective communication is at the heart of this role. Key Responsibilities: - Implement and manage sales strategy (as no lead generation or cold calling will be required in this position, a profound understanding of sales systems and strategy development is essential) - Design eye-catching logos for brand reinforcement - Provide virtual assistance in various business operations Ideal Candidate: - Experienced individual in sales system and strategy management - Proficient in logo and graphic design - Reliable virtual assistant with strong organizational skills Application...
Milestone 1: Using Python implement a machine learning algorithm (multiple linear regression) to predict startup profits (). The following steps should be done and need to be explain the code using # comments 1. Read the dataset from the csv file and put input data in X and output data in Y. 2. Deal with missing and categorical data (Data cleansing, even if there are no missing data) . 3. Divide data into four subsets (X_training, Y_training, X_test, and Y_test). 4. Train the learning model using (Linear regression algorithm) 5. Make a list of predictions Y_pred and compare it with Y_test. Explain what do you remark? 6. Make a prediction for a given data sample. 7. Without using "predefined functions" Find the following: 7.1. Total deviation of the regression line 7.2....
I am looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.
I'm in need of a specialist who can build a cloud-based SMS and calling platform augmented with a Customer Relationship Management (CRM) solution. This platform will chiefly be utilized for sales and lead generation activities. Key features of the CRM should include: - Contact Management: Able to organize and centralize contact details effectively. - Sales Pipeline Management: Enables tracking of prospective customers throughout the sales process. Ideal candidates should have extensive experience in cloud-based software development, CRM systems, and telecommunication technology. Strong familiarity with sales and lead generation applications will be highly considered. Having the ability to provide ongoing maintenance and support will be highly advantageous.
I'm seeking a skilled Excel specialist to develop an efficient reporting system derived from our Core Banking System. Key Responsibilities: - Enable data extraction, both manual and automatic, for maximum flexibility. - Integrate fundamentals like Financial and Regulatory reports. - Incorporate functionality for Ad hoc reports based on unique user requirements. - Ensure the system is adept to update the aforementioned data on a daily basis. The freelancer best suited for this task will have exceptional skills in Excel, and experience developing similar banking or financial reporting systems. Appreciation for detail and understanding of financial and regulatory protocols are also desired.
...timeframe For 15m timeframe display fractals on the 1h timeframe For 1h timeframe display fractals on the 4h timeframe For 4h timeframe display fractals on the D timeframe For D timeframe display fractals on the W timeframe For W timeframe display fractals on the M timeframe For M timeframe display fractals on the 3M timeframe For 3M timeframe display fractals on the 12M timeframe Existing code for basic fractal indicator //@version=3 study("Fractals - Custom Periods", overlay=true) fractalPeriods = input(title="Fractal Periods", defval=2, minval=1, type=integer) bullFractal = pivothigh(fractalPeriods, fractalPeriods) bearFractal = pivotlow(fractalPeriods, fractalPeriods) plotchar(bullFractal?true:na, title="Bull Fractal", location=, offset=-...
I am in search of a skilled sales officer to join our team at Yes Bank, specifically within the ...clients to our credit card services. - Sales Target Achievement: Meeting and surpassing outlined sales targets regularly. The perfect fit for this role is an individual with the following qualifications and experience: - Sales Experience: Proven track record in a sales environment. - Excellent Communication Skills: Ability to engage effectively with potential customers. - Microsoft Excel: Proficient in using Excel for data management and reporting purposes. This role offers the opportunity to work in a dynamic and fast-paced environment, providing measurable results towards the company's success. If you meet the above requirements and thrive in a sales position, we would ...
I need an expert typist to input assorted data - text, numbers, and dates - into a multi-columned Excel sheet. Key Tasks: - Manually enter a vast amount of structured data, extending over 50 columns and rows - Ensure accuracy as the consistent structure should be maintained across all filled cells Ideal Candidate: - Proven experience with high-volume Excel projects - Exceptional attention to detail for accuracy - Ability to follow a strict data structure - Familiarity with varied data types - specifically text, numbers, and dates.
As a growing brand in the cosmetics market, I need a striking packaging design that appeals to a universal audience. My products are not confined to any particular age group, thus the design should be attractive to teens, adults, and seniors alike. The scope of this project is the packaging design only. A design brief will be provided upon project commencement. To excel in this job, you should ideally have: - Proficiency in Adobe Creative Suite, especially Illustrator and Photoshop. - Prior experience in packaging design, specifically for cosmetics. - An understanding of global trends and demographics. - A knack for creating designs that are both trend-forward and timeless. Your portfolio should demonstrate your versatility and ability to design for a contemporary, universal au...
I am looking for a skilled Virtual Assistant geared towards lead generation for my IT Managed Services company. This person would be responsible for generating approximately 50-100 leads per week from tech companies, healthcare providers, and financial institutions. Responsibilities: - Extensive lead generation from specific industries - Cold emailing/calling potential leads - Utilizing preferred tools or software for lead generation Qualifications: - Experience in lead generation and cold outreach - Knowledgeable in IT Managed Service offerings - Outstanding communication skills Ideal Leads: - Companies with comprehensive IT infrastructure needing management. I look forward to finding an individual with significant experience in lead generation and a thorough understanding o...
...can create any offline service with dynamic form so admin can create unlimited service IT service- 1. Website design (Show portfolio) 2. Graphics 3. Google reviews 4. Social media handling 5. Android/ios app 6. Facebook / instagram like increase Wallet: 1- Recharge (with payment gateway / offline method) 2- Transition Reports 1. Download all reports (excel/pdf) Commission Phase 3- Developer Mode 1. Developer add any new page or change menu 2. Add new graphics 3. Add training videos 4. Update script to latest version if changes anything 5. Server status 6. Change theme color 7. Change Google AdSense 8. Change any users password 9. Google analytics/ webmaster add 10. Download backup automatic daily or manual Announcement role 1. Add ...
...site and various social media platforms. The goal is to develop an AI solution that can: - Generate engaging Articles, text, video (with subtitles and voiceovers), and image content. - Perform automatic content posting (with editing option before distribution) My objective it to: 1. Create a blog Article/post on my site though: A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a 900 -1300 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) ✔Check point 1 : Option to edit the article (on wordpress), after article approval: the article w...
Hi Sophia B., Please go over Excel and make sure that English and Ukrainian are attached. SLA is Tuesday, March 19th. Thank you, G
I am looking for a professional who can efficiently extract and copy all information from an Airtable sheet to Excel. Key responsibilities: - Copy/Extract all data from the Airtable sheet: - Copy data to Excel without any modifications
I'm in need of professional assistance to create a 12 months sales projection forecast excel spreadsheet for my events management business. I'm particularly interested in a comprehensive understanding of the industry trends impacting these forecasts. Ideal candidates for this job would have: - Previous experience in building forecast sheets in events management industry - A deep understanding of industry trends Your task will include: - Analyzing my forecasted sales data - Highlighting key industry trends - Providing detailed findings which relate these trends with sales forecasts. Please note your experience with events management and data analysis in your bid!
I'm in need of a simple and effective floor plan for a 600sqfeet farmhouse. I'll be investing 3000 Rs in this project and anticipate efficient use of space and practical designs. This home has three major areas: - Living room - Bedroom - Kitchen Although separate, the living room and kitchen should flow smoothly into each other -- I'm looking for an open concept layout. Additionally, I'm calling for an incorporation of traditional elements into the design. This will help convey a look and feel that's comforting, homely, and in line with farmhouses of old. Ideal skills and experience: - Knowledge of architectural drafting and space planning - Experience in traditional and farmhouse design - Ability to incorporate the open concept effectively Hope to...
I am in need of a proficient Excel Expert for data filtering and formatting. You must exhibit exceptional skills in the mentioned areas: - Filtering: Your role will include filtering my data sheets as per specific conditions. Mastery in this area is a must. - Formatting: I need my numbers formatted in a general fashion for proper import. Therefore, a comprehensive understanding of number formatting is necessary. This project requires advanced working knowledge of Excel and a meticulous eye for detail. For successful completion, you need to display exceptional proficiency in Excel's data filtering and a deep understanding of general number formatting.
I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.
Seeking an experienced Android developer to assist with setting up Android application source code on a development platform. With the initial job focusing solely on setting up the code without any customizations, the ideal candidate should demonstrate proficiency in the following: - Efficiently working with Android platform - Debugging for potential issues during setup - Knowledgeable in working with a range of development environments No customization or extra modification is required from your end at this stage. The goal of this project is a functional, ready to go Android app based on the provided source code. Kindly ensure your experience aligns with the skills detailed above. Your previous experience setting up Android apps will be strongly advantageous.
This project is about creating a professional yet creative business profile (information memorandum) for a business brokerage, powered by an easily updatable Excel back-end. I'm looking for someone with strong document design and spreadsheet expertise. At the moment we have the attached document that is both out of date (design wise) and requires 100% data input from staff. I am wanting a document that answers can be imported directly from excel. The generated profile will be about 20-25 pages long and include approximately 60 distinct data fields, these fields will be collected from each client and answers stored in an excel sheet. The idea being - we need a beautiful document that can have easily duplicated merge fields. - Company name and summary - Address...
...communicate candidate information with GSS Team Attend (Phone and online meetings) update meetings Expansive Search Skills Writing thorough, clear, and concise synopsis of candidate's screenings, interviews Work-Life balance. You will with your own schedule. What You'll need to do! You are responsible for providing your own tools and technology to recruit the candidates. There will be no cold calling for clients. You will be provided with Job Requisitions. No business development or sales. You will provide candidates using whatever tools you use. Once you have identified the perfect candidates, you will submit and we (SCS) shortlist the candidates based on their resumes and additional findings from your phone/video interview/screens. Requirements About you: You are a...
Can you help me out with a small code snippet please? I noticed somehow a few image thumbnail sizes are missing for some images on my sites. So I‘d need a small snippet to put in to display the full size image as a fallback when the requested thumbnail size is not found. Sample this is not found, so in this case it should use: So it should use this should apply to any thumbnail size. Can you please help me with that? A working code snippet will get the job.
I'm seeking a talented graduate graphic designer capable of creating an appealing, bright, and colorful...And for version two upload it to a standard free media player so subscribers can get it into email. This needs to be print ready and i need fast turn around with few if any back and forth questioning. - Strong grasp on modern design principles and decisiveness - Ability to translate both informal and professional tones visually - Ability to engage with a young, professional demographic To excel in this task, ideally you will have: - Prior experience in designing for print media especially newspapers - Ability to deliver innovative and playful layouts minimalistically - Fluency in Adobe Creative Suite or similar tools I look forward to seeing your fresh, dynamic, and ...
...who can swiftly identify and fix the unidentified errors plaguing our code. While we are currently unsure of the specific errors, you should be prepared for a range of issues, including but not limited to compiler errors, segmentation faults, and undefined behavior. Your role will be debugging our existing code to ensure optimal performance. Since our objective and error details remain unclear, freelancers who can provide comprehensive approaches and solutions will get our attention. While presenting your proposal, please include: - Personnel experience troubleshooting C/C++ errors. - Examples of past work related to error detection and solution. - Your detailed plan for unraveling and resolving the issues in our code. Remember, quick turnaround is critical for u...
I need an expert to modify my existing Excel spreadsheet and transform it into a fillable PDF form. The interactive form will contain a description field, checkboxes, date field, price fields, perhaps one calculation but that isn't necessary. I have attached a sample of the excel file. There may be a few changes. Does this sound like something you can do? Here's what I'm looking for: - Ideal Skills: Extensive experience with Excel and PDF form creation is a must. - Experience working with custom fonts and graphics that will need to be duplicated onto the form -Experience: Please include any previous work involving the conversion of an Excel file into a fillable PDF form. Please note that the data that needs to be captured in the form is b...
Looking for a professional financial analyst adept in scrutinizing balance sheets. - Your primary task will be financial statement analysis, specifically focusing on the balance sheet. - Proficiency with Excel spreadsheets is crucial as all data will be provided in this format. Ideal Skills: - Comprehensive knowledge of financial statement analysis - Expertise in Excel - Proven experience in financial analysis, particularly balance sheets. The perfect freelancer will have a keen eye for detail and the ability to draw insights from financial data. Budget is 50$
I need assistance in creating a VLookup formula in Excel to fetch matching data from another worksheet. Having already identified the columns, the formula should be designed to fetch data from the specified columns. Freelancers with extensive experience in Excel formulas and in particular, the creation of VLookup functions, are highly preferred. Knowledge, skill, and proficiency in Excel spreadsheet manipulation are essential.
Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet
I require a tool or script that can effectively convert my checking account bank statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter should be de...
I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.
I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.
I need a talented freelancer who can turn my module descriptor engineering document into a 50-100 page workbook for elementary school students. Each page should be filled with engaging and educational content. * The Activities: The workbook should contain puzzles and games, practical experiments, and interactive quizzes that directly correlate with the material presented in the document. * Expertise required: An understanding of elementary level education and engineering concepts is necessary. Previous experience designing similar educational resources is a plus. * Final Deliverable: A PDF version of the workbook, ensuring all activities are clearly presented and instructions are easy to follow. The freelancer chosen for this project will need to exhibit creativi...
I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.
I am in need of an expert who can effectively import complex Excel sheets into MS PSA Project Service for a more consolidated and efficient approach to data management. Key Deliverables: 1. Importation of Excel Sheets: - This includes financial data, project tasks, and resource allocation. Your experience in managing and handling these types of data is crucial. 2. Data Structure: - I require all Excel sheets to be consolidated into a single worksheet. Your knowledge in navigating MS PSA Project Services and Excel will be important to ensure that the data will be structured correctly and in a user-friendly way. 3. Permissions: - Every group should have full control over the project's MS PSA, including viewing, editing, and deleting capabilities. Your u...
I am seeking a freelancer who excels in using Excel to manage large data sets. You will need to perform specific tasks, including: - Data Filtering: Skilled in using various Excel functions to sort and filter large amounts of data. - Basic Arithmetic Operations: Proficient in performing addition operations on the data set. - Statistical Analysis: Capable of conducting descriptive statistical analysis on the data provided. The ideal candidate possesses an excellent command of Excel, and a strong background in statistical methodologies.
...and be able to delete the account so that the account may not longer have access to the app if necessary. the second part of the interface will be a csv file uploader. there will need to be a button for the administrator to upload a csv file that contains contact information. the csv file will contain the following parameters: first name, last name, phone number, email, address, city, state, zip code. whenever a csv file is uploaded it creates contact information in a contact database stored within the application. the contact database will be used by the application to make automated calls. when a csv file is uploaded, the app needs to check the new csv file against existing contacts in the contact database and omit duplicate contacts, so that only new contact information is ...
...through a series of updates, featuring prominently the implementation of In-App Purchases (IAP). Adeptness in handling Apple Store submissions and approval process is a prerequisite. Key Responsibilities: - Execute IAP implementation favoring a "single tier subscription" model. Understanding the specifics and subtleties of subscription-based purchases will be vital for this. - Update the existing code to ensure smooth functionality and enhance user experience. -making Change to IAP -publishing to app store and meeting all requirements for ios release Ideal Candidate: - Proficient in React Native - Proficient in iOS submission and approval process - Familiarity with implementing IAP - Previous experience with subscription-based applications Let's work together ...
I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael
I am looking for a dedicated and skilled professional to fill the role of a virtual voice and messaging assistant. Key Responsibilities: - Primarily, you will be tasked with answering customer queries with clarity and precision. - Additionally, you should be able to carry out typing tasks with a quick turnaround time. Required Skills & Experience: - To excel in this role, you should have a strong background in customer service, with exceptional verbal and written communication skills in Spanish. - Experience in related roles, especially as a virtual assistant, is highly desirable. This role will require a firm understanding of my business and the ability to represent it effectively to our clients. If you can handle these tasks competently and professionally, I am eager to he...
I have to create an exe which contains data in gridview and the data also contains the path of the image. And all the images are saved inside the folder. Whose path is given in the database record. So I have to export excel from gridview. I have attached the files as an example, you can prefer that.
I am looking for a dedicated individual who has strong research skills to find companies on the inte...include: - Identifying such companies - Gathering specific information about them including sales revenue, company name - Collecting their contact details: name, phone number, and email address Ideal candidates for this task will possess the following skills: - Strong research and data entry capabilities - Sound understanding of e-commerce, retail, and manufacturing industries - Proficient in MS Excel or similar data management tools - Exceptional attention to detail to ensure accuracy of gathered data - Excellent communication to report findings promptly. This job requires devoted attention and precision. Please bid if you consider yourself an astute researcher with an eye f...
I am in need of an accounting expert with a minimum of 3 years experience to handle bookkeeping, accounts receivable and accounts payable tasks. The ideal candidate should have excellent proficiency in Excel, Microsoft Access and Netsuite. Your responsibility will include: - Maintaining and updating financial records, invoices and receipts - Performing accounts receivable/payable duties - Handling any other task that involves Excel, Microsoft Access or Netsuite. Strong attention to detail, problem-solving skills and knowledge of accounting principles and laws are required.
As an experienced user of AutoCAD bricksCAD, I am looking for an Autolisp programmer adept with the creation of tailor-made commands to enhance my workflow. Key tasks form the scope of this assignment: 1. Creating a basic electrical single line diagrams using interaction between excel data and predefined blocks in bricksCAD such as transformer, breaker, main switch board, distribution board, busbars,other electrical components.
...thrives on getting everything in order and has the ability to make Excel sing. As an experienced data entry individual, you will be tasked with the following: - Sorting and organizing data into meaningful, easily navigable formats - Mastery in crafting complex formulas to make excel work its magic - Examining and validating data meticulously to ensure cleanliness and accuracy Your extensive experience with handling numerical data, specifically sourced from online platforms, is crucial for this project. Mention your proven track record and provide specific examples of past projects in your application. Show your competence with handling online-sourced data and how you leveraged it to create insightful and efficient Excel documents. Prove to me you can take comman...
We are seeking an experienced freelancer proficient in process management and organizational workflows to develop an enhanced new hire onboarding process template in an easy to edit format (Excel, canvas, powerpoint) with a focus on optimizing the HR team's roles. Key Responsibilities: Design and implement a comprehensive workflow that streamlines the new hire onboarding process, specifically addressing the tasks performed by the HR team across different stages. Department Talent Acquisition Team: Screen Candidates Manage the Interview Process Extend Offers Manage Pre-Screening Process Provide First Day Instructions Initiate Pre-Onboarding Packets for Candidate Completion Monitor Completion of New Hire Paperwork Monitor I-9 Section 1 & 2 Completion on First Day Candidat...