Vba code excel data analysis jobs
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Offic...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
We are looking for a skill...optimal performance in this setup. Ultimately, we are striving to create a super robust, easy-to-maintain, and cost-efficient boat. The simulations will play a crucial role in helping us make informed decisions about the design. Requirements: - Expertise in CFD & FEA simulations for boat designs - Experience with hull optimization for performance and efficiency - Ability to provide detailed analysis and recommendations based on simulation results - Strong communication skills to explain complex concepts in a clear and concise manner If you have the skills and experience required for this project, please submit your proposal detailing your relevant experience and approach to the project. Feel free to ask any questions you may have about the project...
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I'm seeking a skilled individual to assist with a multi-machine power system dynamics analysis and control. The primary goal of this project is to optimize power flow efficiency. Key Requirements: - Proficiency in power systems dynamics and control analysis - Experience with multi-machine systems - Ability to optimize for voltage levels Your responsibilities will include: - Conducting power system dynamics analysis - Implementing control measures to optimize power flow efficiency - Focusing on voltage levels optimization Ideal candidates should have a strong background in power systems, and be able to work on a multi-machine system. This project will require a good understanding of power flow and voltage levels in order to maximize the efficiency of the system...
I'm in urgent need of a Tableau expert who can assist me with my data visualization and dashboard/reporting needs. Your responsibilities will include: - Crafting effective and visually appealing data visualizations - Developing interactive and insightful dashboards and reports I will provide you with the specific data and objectives for these visualizations and dashboards. The ideal candidate for this position should be proficient in Tableau and have a strong background in data analysis and visualization. Experience in working with sales data would be a plus, although not mandatory. This is an urgent project, so I need someone who can start immediately and complete the work quickly.
I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet files after saving (most run and give results)
...a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately repres...
...tracking, and conversion analysis. - Sales Forecasting: Accurate prediction of sales trends and opportunities based on the CRM data. User Base: - The CRM system will be used by 1-50 users, so it should be user-friendly, scalable, and efficient. Integration: - It's imperative that the CRM can seamlessly integrate with other systems, particularly: - Email Platforms: For streamlined communication and lead nurturing. - Social Media: To enhance customer engagement and acquisition. - Accounting Software: To automate financial data synchronization and reporting. Ideal Freelancer: - Proven experience in CRM development, with a strong portfolio of CRM systems. - Proficiency in integrating CRMs with email platforms, social media, and accounting software. - Under...
...ads for the best results. - Audience engagement: Building and maintaining a relationship with my audience is essential. - Market Analysis and Feasibility Study: You should be able to analyze the market and provide insights for our campaigns. - Ads optimization: Implementing strategies to make our ads more effective. - Potential Costumers Targetting: Identifying and targeting potential customers for my business. The main goal of the campaign is to Increase brand awareness. Ideal candidate: - Proficient with Facebook, Instagram, Snapchat, TikTok, WhatsApp Business - Prior experience in managing social media campaigns - Strong analytical skills for market analysis - Excellent communication and customer service skills - Creative and strategic thinker - Ability to work inde...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
I'm a store owner with a focus on home and lifestyle products. I need skilled and experienced help with running effective Facebook ads to boost my sales. Key Responsibilities: - Develop effective Facebook ad strategies for my store - Drive substantial sales through these ads - Assist with refining my target market Ideal skills: - Strong experience in Facebook ads man...products. I need skilled and experienced help with running effective Facebook ads to boost my sales. Key Responsibilities: - Develop effective Facebook ad strategies for my store - Drive substantial sales through these ads - Assist with refining my target market Ideal skills: - Strong experience in Facebook ads management - Understanding of home and lifestyle industry - Excellent skills in market analysis...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/Ja...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I am in need of a professional who can analyze a 4 hour and 40 minute long voice recording for me. This recording contai...the recording. Key requirements include: - Expertise in audio engineering or related fields - Proven experience in voice and noise analysis - Detail-oriented and can accurately identify and note the female voice in the recording - Ability to deliver completely clear sound quality, removing the noise of the fake snoring without affecting the voice quality - The final output should allow me to clearly understand what is being said throughout the recording An ideal candidate should have a background in forensic audio analysis. Your task is to remove the snoring sounds and bring clarity to the speech. Your work will significantly contribute to my voice ...
I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/Ja...
Job Title: Dating App Specialist Responsibilities: Matchmaking: Curate high-quality matches within our dating app based on user preferences. Profile Evaluation: Ensure profile accuracy and identify potential matches. Engagement: Facilitate connections and encourage interaction between users. Social Media Integration: Funnel matched users to our Instagram platform. Data Analysis: Use analytics to optimize matchmaking and engagement strategies. User Feedback: Gather and communicate user insights for product improvement.
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financia...
Please Sign Up or Login to see details.
I need specialized assistance on visualizing my completed data analysis, encompassing sales data, financial data and customer data. To make this happen, I'm seeking a seasoned Power BI dashboard designer. Expertise required: - Proficient in creating Bar charts, Pie charts, and Line charts in Power BI - Has experience working with diverse datasets especially sales, financial and customer data - Can deliver the project urgently If you can create a comprehensive and visually appealing dashboard to delineate and amplify my data's context, your experience and skills will be indispensable to this project. Let's connect ASAP and bring this to life.
I have collected data using Google Forms in Arabic, and I am looking for a freelancer to perform a statistical analysis using SPSS. Key Deliverables: - Statistical Analysis: The main goal of this project is to conduct a statistical analysis on the data. The analysis should focus primarily on descriptive statistics, so the candidate should be proficient in this area. - Detailed Report: I need a report that delves into the analysis of the data in depth. This report should include detailed tables and charts. Ideal Skills and Experience: - Proficiency in SPSS: The chosen freelancer must be well-versed in using SPSS for statistical analysis. Previous experience working with Arabic data would be a plus. - Data ...
...the strategy's performance. - **Modification Level**: I am open to a comprehensive overhaul of the script in order to provide a long-term, optimal solution. This may involve a significant revision of the code, but it is essential that the original logic and intended results of the strategy are maintained. - **Intended Use**: Once the repainting issue is fixed, I plan to use the corrected Pine Script strategy for my personal trading analysis. Ideal candidates for this project should have: - Strong experience in Pine Script and TradingView platform - Deep understanding of technical analysis and charting - Previous experience in fixing repainting issues in Pine Script would be a significant advantage If you are confident in your ability to comprehensively overh...
...primarily target women. Key requirements include: - A detailed market analysis focusing on the beauty and wellness industry in Lebanon - Competitor analysis to identify key players in the market - A well-thought-out marketing plan to attract our target audience of women - Financial projections and a detailed business model that's realistic and can be used for securing funding - Understanding of the unique cultural and economic aspects of the Lebanese market Ideal candidates for this project should have: - Proven experience in writing successful business plans for the beauty and wellness industry - Thorough knowledge of the Lebanese market and consumer behavior - Excellent research skills and the ability to translate data into actionable insights - Strong fi...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I am looking for an experienced individual to help develop a comprehensive business plan for my service-oriented venture in the beauty industry in Lebanon. This plan will c...comprehensive business plan for my service-oriented venture in the beauty industry in Lebanon. This plan will cater primarily to individuals, so a deep understanding of consumer needs in this sector is needed. Key responsibilities include: - Crafting a business plan tailored specifically for a start-up beauty service targeting individuals - Market research and competitive analysis - Financial projections and risk analysis Ideal candidate should have: - Proven track record in developing successful business plans - Deep understanding of the beauty service industry - Excellent research and financial p...
I'm seeking a writer to compose...correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suited for someone with a background in finance, real estate, and/or sustainability. Experience in writing research reports or white papers would be highly beneficial. It's important that the writer has an understanding of ESG principles and their significance in the real estate sector. A keen eye for detail and the ability to present complex data in an ...
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input
...of books and categories: Here are the suggested titles for the 15 ebooks/scripts on artificial intelligence. If you think something is missing or should be changed, please let me know. Theory Background History of AI Machine Learning and Data Mining Neural Networks Reinforcement Learning Speech-to-Text and Text-to-Speech (and Deep Learning in this Relation) Robotics Limits of AI, Deepfake, and Ethics Practical Guide - Tools ChatGPT for Beginners Image Creation Tools with AI (DALL-E, MidJourney, Assistants - Market Overview) & Computer Vision Data Analysis in Enterprises with AI Python - Introduction and First Overview Additional Books Natural Language Processing (NLP) AI in Healthcare Autonomous Vehicles and AI AI in Finance and Trading Please start your offer...
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15...
I'm seeking an experienced market researcher to delve into significant factors that will help validate a startup idea. Your objective will include: - Analyzing consumer behavior to identify their needs and preferences. - Determ...market researcher to delve into significant factors that will help validate a startup idea. Your objective will include: - Analyzing consumer behavior to identify their needs and preferences. - Determining market demand and potential, focusing on a national perspective. - Conducting a thorough competitor analysis to understand the competitive landscape. Ideally, you will have a strong background in market research, a deep understanding of consumer behavior, trend analysis, and competitor analysis. A strong knowledge of the e-commerce m...
...exceptional AI developer to create a private AI system for my Apple computer that combines enhanced security measures with efficient functionality. This project will require a nuanced understanding of AI and firewall development. The ideal candidate for this project should have experience in: - Implementing AI functionalities: Primarily, the AI system should be capable of calculations and analysis for private search purposes. - Incorporating specific AI functionalities: The private AI system should have a thorough understanding of natural language processing, image recognition, and predictive analytics. - Developing private search capability: I want the AI system to perform encrypted and anonymous search. End-to-end encryption should be ensured while performing any ...
...Negative, or Neutral. The sentiment classification model should be able to accurately and reliably analyze the sentiment of a given customer review. Key requirements include: - Data Source: The data to be analyzed will be sourced exclusively from customer reviews. - Sentiment Detail: The model should identify and categorize the sentiment of reviews into Positive, Negative, or Neutral. Ideally, you should have: - Proven experience in machine learning, particularly in sentiment analysis - A strong understanding of natural language processing and text analytics - Previous experience working with customer review data - A track record of building accurate and efficient classification models - Familiarity with platforms like Python, R, and relevant ML libraries ...
I'm seeking an experienced C++ developer to create a simulation study focused on analyzing system performance. The freelancer should be proficient in: - C++ programming - Building simulation models - System performance analysis The end goal is to have a robust, accurate simulation that can analyze the performance of various systems. Prior experience in similar projects would be highly advantageous.
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to e...
... = color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant is true then parse it as string otherwise leave it as it is now which integer. can i do that only on parser or i need to change the Pojo class as well (colorWsDTO) who can do it in
I need a skilled SPSS expert to help me analyze a dataset and draw conclusions for my research report. Key Requirements: - Data Analysis: I need assistance in analyzing the data, which includes variables like Gender, Education level, pro-environmental behaviour, individual differences, and psychological factors. - Prediction: The primary objective of my research is to predict one variable based on others, so your expertise in predictive analytics is crucial. - Experience: I'm looking for someone with a strong background in data analysis and research, specifically using SPSS. Knowledge of psychology, or sociology is needed. Please note: - The study involves 155 participants, so you should be comfortable working with datasets of this size. - Clear ...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happ...
I need an expert in Python for maintenance tasks on some existing code. Key Tasks: - **Bug Fixing:** This code has some bugs that need to be identified and fixed to ensure its proper functioning. - **Code Optimization:** Your expertise is crucial to streamline and optimize the performance of the existing code. Ideal Candidate: - Proficient in Python - Experienced in code maintenance - Skilled in bug fixing and code optimization.
I'm looking for a seasoned C++ expert to optimize a codebase for improved readability and maintainability. Your primary goal in this project will be to ensure the code is easier to understand and work with in the long run. Key Responsibilities: - Analyzing the existing C++ code and identifying areas for improvement. - Implementing optimization strategies to enhance the code's readability and maintainability. Ideal Qualifications: - Extensive experience in C++ development, specifically in optimizing code. - Proven track record of enhancing code readability and maintainability. - Strong understanding of best practices in C++ development. I'm open to discussing the specifics of the project with the selected expert.
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
...documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurate...
I'm searching for an experienced Python developer to handle data collection and processing in the financial sector. Your tasks will consist of two core elements: - Data Collection: Obtaining data from diverse financial sources, including stock market data, cryptocurrency data, and financial news data. - Data Processing: Once collected, you'll perform various calculations and analyses, including statistical analysis, trend analysis, and calculations with a focus on historical data. Familiarity with these tasks and the financial sector is crucial to delivering the results needed. Your expertise in Python and financial data processing will contribute significantly to the project's success.
