Vba excel study assignments jobs
I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the s...vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...
This project is research. It does not require technical implementation, but requires technical analysis and solution design with complete documentation. We wish to study and analyze the API of in order to create a new web application that will make use of it, so that a teacher can create educational activities for his students. We want to design a page that gives various options and various settings, which make API calls to teachablemachine.withgoogle.com. These settings can depend on the options the user has to design objects/activities within the teachablemachine. Simply the creations will be done with API Calls from an external application. After selecting the settings, we want, by pressing save, to see on a separate screen the result of these calls according
I'm in need of a comprehensive Chemistry paper to be written. I would like the study to be represented on the cover page. - I need a professional in the field who can capture the essence of the study and present it in a well-structured, comprehensive manner. - The paper should have a detailed analysis with case studies. - The most important part is the representation of the study on the cover page. - I expect a high level of detail and a thorough understanding of scientific writing. Ideal skills and experience include: - Strong background in Chemistry - Previous experience in writing scientific papers - Ability to conduct in-depth research - Proficiency in professional scientific writing - Familiarity with creating case studies in Chemistry - Creative skills...
We have our own ERP...in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you're confident in your ability to handle these tasks, I would ...
I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...
I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets
I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet
Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedback data.
I'm looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and knowledgeable in sports data ana...
as per communication, transfer data from DPF to excel.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
...from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchroni...
I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.
I'm looking for a talented UI/UX designer to help me create an Tutoring App Key Requirements: - UI/UX Design: A clean and intuitive interface that is user-friendly and accessible for a broad audience of students. - Tutors will be shown online and student can pick any tutor - Tutor will show price, skills, experience, ratings - Use STULINK logo or icon in app - Mobile App...Background: I need someone who understands the unique challenges and requirements of designing for educational purposes. Ideal Skills and Experience: - Previous experience in designing Educational Tools. - Proficiency in Mobile App Design. - Understanding of UI/UX principles. Example of tutoring app design i liked - (Tutor-Finding-App)-UIUX-Case-Study/modules/943292723
...understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present in an understandable format. - Knowledge of financial forecasting and prediction methodologies. This project would demand a keen eye for detail, analytical acumen, and ...
...between 50,000 and 100,000 (or near this range so e.g. could be 40,000-120,000 eur/year - in the UK and (ideally separately) in the EU. 3. Average investment amounts (mode, median) by each investor in each category from (1.) above over time and predictions (say 3 years, but flexible according to the data) on all of 1-3 above 5. All of above (1-4) presented in editable charts with editable excel files and all referenced by source of info and date NICE TO HAVE a. Total existing value of savings and investments in the UK and EU by investment media/category. b. total existing value of current accounts (and separately) savings accounts in banks/bldg societies in the UK and (ideally separately) the EU c. Average spend on accommodation of holiday-makers (or by household) vacationing ...
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automations and ...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...
I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting
I'm in need of a detailed, compiled list containing 1000 contact numbers of individuals from the UK who are receiving any form of income benefits. The objective of this collection is for completion of a research study. Accurate data is key to the success of my project, thus, the list must also include the following information: - Full names - Addresses - Date of the last boiler replacement (if this information is accessible) Regardless of the type of income benefits received by the contact – be it Jobseeker's Allowance, Income Support, or Universal Credit – all are relevant and needed. Ideally, the freelancer for this job should have: - Proven experience in data acquisition/research - Familiarity with the UK benefits system and boiler replacement progr...
Set up a Monte Carlo Simulation model to optimize the reduction of fatalities at roadway work zones using Excel with a Monte Carlo simulation add-on. The objective is to reduce crashes involving fatalities. Variables can include work zone speed limit, work area length, duration of work being done, time of day work is done, traffic volumes, work signs/flaggers present, etc. Expert knowledge in Monte Carlo simulations and risk engineering modeling. Limited time available to create model. More information available upon request.
I'm in need of a professional to help complete an assignment on a relatively advanced level of financial accounting. Since the format for completion wasn...accounting. Since the format for completion wasn't expressly specified, the choice of format would be at your discretion. However, it needs to effectively communicate the thoughts and ideas. For this assignment: - Extensive knowledge and understanding in financial accounting is crucial. - The successful candidate must be able to translate high-level information into a comprehensive, digestible study which I can further learn from. - Ideally, experience in financial consulting, corporate finance or a related field would be hugely beneficial. Please provide a brief overview of your experience in financial accounting ...
Develop financial modelling in excel spreadsheets based on information supplied. This may lead to a long-term ongoing assignment(s) depending on your skill level and capabilities
Looking to setup forms in SharePoint (365). The forms will be basic drop down and redial buttons. Answers will need to be collected in a Excel sheet. Approx. 150 forms need to be created to begin with in the next 6 weeks. Possibly ongoing creation, modification and management required.
I'm in need of a professional to design a minimalist and clean flyer for a study abroad company services and offers. The target audience for this advertisement is Fresh Graduate students who complete their betech and Degree, so the design should be stylish and engaging, but keeping a clean and minimalist approach. Ideal skills and experience for this job include: - Proven experience in designing minimalist and clean advertisements - Understanding of target audience (Graduate Students) and how to engage them effectively through design - Creative flair for making a product stand out in a crowded market - Ability to deliver a design that is both sleek and eye-catching - Experience designing for product launches is a plus Please provide samples of your work and explain how yo...
I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. The accounts are currently in digita...
I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly aligned and clearly legible.
I have a project that involves converting text from txt format into an Excel spreadsheet. Key Requirements: - I need someone who is meticulous and efficient at data entry. Your responsibilities: - Convert text from provided txt file into an Excel spreadsheet. - Ensure accuracy and maintain proper formatting. Ideal Skills: - Proficient in Excel. - Strong attention to detail. Sample is attached.
I am in need of an expert in Excel to assist with data entry and organization. The work involves entering both numerical and textual data into Excel, and then organizing it by category. In addition, I require the use of data validation functions to ensure the accuracy and integrity of the data. Key Responsibilities: - Inputting both numerical and textual data into an Excel spreadsheet - Organizing the data by category - Implementing data validation to maintain data quality Ideal Skills: - Proficiency in Excel - Experience with data entry and organization - Familiarity with data validation functions - Strong attention to detail This project is ideal for someone who is meticulous, organized, and has a good understanding of Excel functions.
Hi Quick Website SEO, I noticed your profile and would like to offer you my project. We can discuss any details over chat. We discussed over hat about about the SEO services I need since we worked together in the past.
I'm in need of a well-organized and dynamic statistical study design, with particular focus on essay analysis. To be successful in this task, you should: - Have proven experience in academic writing, particularly in the field of statistics. - Have a keen understanding of statistical study design methodologies. This project may be perfect for those with strong backgrounds in statistical analysis and academic writing. Submit your application detailing your experience in this field.
As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward to receiving your bids.
...Managers up to 60 Projects). Output > Requirement 2 > Overarching Gantt Chart showing all projects to create an easy way for executives to see where projects are at in the stages and when the projects are expected to be complete. Requirement 3 & 4 will provide me with an overarching program/portolio view They should cater to a variety of project information, covering: Requirement 1 (Open to Excel or Word Formatting) Individual Project Reports should 1. Project Name and Brief Description, Project Manager/Lead Name 2. Project Stage and Project Type (i would like to choose from a selection/list ) 2. Status Indicators- Overall, Financial, Schedule, Risk and Issue 3. Risks and Issues Details 4. Critical Dependencies 5. Upcoming Milestones 6. Exceptions 7. Start, Fi...
The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can supply my judgement of the probability of each result i...
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
I require the expertise of a Python developer to convert an excel file for automated task execution. The primary purpose of this project is to automate certain data manipulation tasks, specifically the application of formulas and calculations within the dataset. The chosen freelancer should demonstrate a proficient understanding of both Excel operations and Python programming in order to seamlessly translate the existing manual processes into an autonomous, error-free script. Your application should include any previous experience with similar data manipulation or automation tasks.
...experience in creating modern logos. - Proficient in color theory and can work with a neutral, earthy color palette. - The main element of the logo should be a symbol. The meaning behind it will be discussed further upon project commencement. - Ability to deliver a unique, compelling and memorable logo design that will resonate with our audience. This is an exciting opportunity for creatives who excel in translating brand vision into compelling visual design. Show me your portfolio that showcases your clean and modern design sensibility. Looking forward to seeing your applications! we need a logo for our cushion product used for orthopedic purposes. we have attached a sample logo for reference. we need the source file and all the fonts and elements. If you have any questions p...
...consolidate into a single Excel spreadsheet for my project. The main goal is to have all the information in one place to ease the decision-making process. I'm looking for a freelancer who can help me with this project and provide ideas on how to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consolidation from PDFs and websites. - Experience in ...
I'm seeking a skilled professional who can integrate into our workflow to streamline communication and automate key tasks. Key Tasks: - **Automation:** I'm looking to automate data entry and task assignments. This is crucial for us to optimize our efficiency and reduce manual errors. - **Integrations:** We need to ensure smooth integration of with our existing tool stack. This will help in creating a seamless workflow and avoid any data silos. Ideal Skills: - Proficient in - Experience with is essential. You should be able to configure the system to meet our automation needs. - Workflow Automation - Proven experience in automating tasks within a project management system. - Integration Expertise - Able to connect with other tools seamlessly
I need someone to help me with my Python and PostgreSQL assignments. - Your skills and experience in Python, PostgreSQL and psycopg2 are crucial for this task. - Being familiar with database management, API integration and data analysis is highly valued. - I need the project to be completed as soon as possible. Your responsibility would be to help me get through the tasks swiftly, with accuracy and quality. I am looking for someone who can work efficiently, and give me the best possible solutions with the least amount of time.
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
Hi A bit of fun this one ! The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can supply my judgem...
I am on the search for a professional who has proficiency in Excel. The main task of this project involves automating the process of conditional formatting in Excel based on cell content, which can help streamline and simplify my workflow. Skills and Experience Required: - Strong knowledge of Excel functionalities - Experience in automating conditional formatting - Ability to build scripts based on cell content Your expertise will help me ensure that my data is formatted accurately and consistently, saving me time and increasing efficiency. Please place your bid if you possess the necessary skills and experience, and we can discuss further details.
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.