Projects to learn excel jobs

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

We are looking for an experienced AI/ML development team or agency to build a fully functional AI Voice Assistant tailored for dental clinics. This AI should answer patient calls, book/reschedule appointments, integrate with major dental management software, and port our existing business phone number to a VoIP system. ? This is an urgent project with a hard deadline of 2 weeks. Only apply if you have pre-built AI voice solutions or the ability to execute this quickly. ? How to Apply ? Submit your proposal with: ✅ A working demo or past AI voice assistant project. ✅ Your approach to integrating with dental software (Curve Hero, Dentrix, Open Dental, etc.). ✅ Your VoIP experience & how you will handle number porting. ✅ Estimated timeline & milest...

...Ecommerce Assistant Are you passionate about e-commerce and digital marketing? Do you have previous experience in managing Amazon accounts? We are a leading organisation in the industry, seeking a dynamic and results-driven individual to join their team as an Amazon Ecommerce Assistant. As the Amazon Account Executive, you will play a crucial role in supporting the management and development of our business relationship with Amazon. Your main focus will be to optimise content, manage the product catalogue, and implement effective promotional plans. If you are ready to take on this exciting challenge and work with a team of driven professionals, then this is the perfect opportunity for you! Responsibilities: • Support the writing and publication of optimise...

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

Looking for a Designer to Create Anime/Manga-Themed Images I’m looking for a creative designer who has at least a basic understanding of anime. Experience is not required but will be a plus. Task: Create eye-catching images for videos about anime/manga. You can check examples of the desired style here: Types of Images: Full-Screen Image: The main character and background fill the entire workspace. The character and background are generated, and additional elements (like portals, magic, etc.) are added to the scene. The goal is to create vibrant, attention-grabbing images featuring magical elements and "systems" (e.g., portals or neon panels symbolizing transportation to another dimension). Split Image (Two Parts): The first part shows the ...

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

I am seeking a highly qualified virtual assistant for a long-term engagement to efficiently handle daily IT consulting project opportunities and scheduling tasks. As an integral part of my team, you will play a crucial role in managing project inquiries, responding to questions, and ensuring the seamless scheduling of consulting jobs. The role involves working with a variety of IT topics, including infrastructure, applications, security, and generative AI. Responsibilities: -- Review and respond to daily IT consulting project opportunities sent via email. --Respond to opportunities within the 12 AM - 2 PM PST timeframe, --Receive training on completing project forms and stay updated on new topics in IT consulting. --Schedule consulting jobs by reviewing Calend...

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.

We’re looking for a skilled Business Development Specialist to help us acquire freelancing projects in web development. Your role will include finding and bidding on projects, communicating with clients, and closing deals on platforms like Upwork, Freelancer, Fiverr, and Bark. Responsibilities: Identify and bid on relevant projects. Communicate with clients to understand their needs. Create winning proposals and close deals. Report progress regularly. Skills Needed: Experience with freelancing platforms (Upwork, Fiverr, etc.). Strong communication and negotiation skills. Familiarity with web development services (especially WordPress). Compensation: This is a commission-based role: 10%-20% of the project value, depending on the size of ...

Looking for an experienced marketing professional with proven track record in freelanci...marketing professional with proven track record in freelancing platforms (Fiverr, Upwork, Freelancer, Clutch) to secure AI and software development projects. The ideal candidate should have demonstrated success in bid writing, project acquisition, and client communication for technical projects, particularly in AI/ML, chatbots, web development, and data analytics. Our company, an established AI solutions provider with 25+ professionals, offers multiple successful AI products and strong government/enterprise client portfolio. We're offering competitive compensation (base + commission) for someone who can expand our presence across freelancing platforms and secure high-value ...

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

I'm lookin...our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Abi...

I need an expert to help set up my Asana for managing consulting projects. Key aspects of the setup will include: - Creating projects and tasks specifically tailored to consulting - Designing project templates for efficiency - Setting up tasks for client onboarding and management - Scheduling and appointment setting - Report generation and reviews The ideal candidate should have significant experience with Asana, particularly in setting up projects and tasks. Experience in the consulting field would be an advantage. Excellent organizational skills and attention to detail are essential.

...for Gym Setup, Project Management, and Administrative Support Job Description I am looking for a detail-oriented and proactive Virtual Assistant to help me manage multiple projects related to the launch of a new outdoor gym on the beach in Belize and assist with other business initiatives. If you're organized, tech-savvy, and great at keeping tasks on track, I’d love to hear from you! Your Responsibilities 1. Gym Setup & Operations: Manage the development of a professional website that accepts online payments. Research and recommend a point-of-sale system for an outdoor, beachside setup. Assist with equipment research and project management to ensure gym construction stays on track. Help source and coordinate with contractors, design...

...Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow a...

Project Summary: Request Management System Objective: Develop a simple, user-friendly online request management system to handle different types of requests, such as maintenance and purchase requests. The system should include role-based access control, approval workflows, and basic analytics. Key Functionalities: User Management & Authentication: Users can register and log in with roles: Requester (can submit requests) Department Manager (can approve/reject requests) Engineering Manager (final approval and assignment) Passwords should be securely stored (hashed). Session-based authentication to restrict access. Request Submission: Dynamic form with the following fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (per department...

...Keeping the story about the animals, fun facts, nature and mission to learn how to protect the animals. The goal of the book is to teach kids about the environment, animals, and nature in the Mobile-Tensaw Delta regions in South Alabama. The story is about Captain Steve teaching Brody and Samantha about the nature in their own backyards and finding two fishermen torturing the resident gator Hooks by catching him on the fishing line. They did it on purpose, but no one wanted to fess up to it. Along the way they find herons and do some heron Thai Chi or Yoga and participate in the Shellfish Shimmy with some animals. There are a couple things that I really would like to stay in the story like some lines that Captain Steve needs to sa...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets

More details: What is the primary focus of the business analysis? - Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk m...

...content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets m...

I need a professional who can help me extract data fro...system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is es...

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

...Analyst to assist in managing budgeting, forecasting, cash flow analysis, and cash management for our real estate and contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who c...

I'm looking for a professional tester to conduct thorough testing on my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for proj...

...the refinery and chemical industries, specializing in mega-projects. As a cost estimation engineer, I am looking to leverage AI, machine learning, and data science to enhance our workflows and optimize our processes. About Us: We maintain a database of over 300 Mega projects (about 10 million dollar tic budget per each Project), containing detailed information on material costs, labor costs, and project-specific details. Our proprietary software integrates a global database of services, instruments, equipment, and associated costs, functioning as a comprehensive calculator for cost estimation. What We Need: We are seeking an experienced AI and machine learning professional to: Propose innovative AI/ML-based solutions tailored to our cost esti...

I'm looking for a skilled professional who can teach me how to create a cartoonish tree for a 2D animation video using Adobe Photoshop. The tree should have branches with leaves and fruit. Key requirements for the project include: - Proficiency in Adobe Photoshop - Experience with 2D animation - Ability to teach and explain concepts clearly - Experience creating cartoon style animations I want to learn how to conceptualize and design a cartoonish tree, including the various elements that make it visually appealing and dynamic for animation. The ideal candidate will be patient, clear in their instructions, and able to provide constructive feedback on my progress.

I'm a 14-year-old looking to edit gaming videos. The primary editing tasks will involve cutting and trimming footage. I'm seeking guidance and mentorship to improve my editing skills and learn how to produce engaging content. Please provide a brief description of your experience and past projects.

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands on...product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

...knack for finding opportunities? We’re looking for an Appointment Setter to join our growing Website Design Agency team. Your role will be to: Research & Identify Leads: Find businesses without websites or those with outdated/bad websites. Reach Out to Leads: Use personalized messages, emails, or calls to introduce our services and highlight the value of having a professionally designed website. Set Appointments: Once leads express interest, book them for a call with our team. What We Offer: Commission-Based Earnings: Earn 10% commission on every deal closed from the leads you bring in. For example, if a deal is worth $5,000, you earn $500! Growth Opportunities: As our agency expands, there’s potential for you to move into a more...

I'm looking for an expert to develop an automation API that bridges Zoho Books and Zoho Projects. The API should facilitate: - Project setup: Specifically, creating project milestones/tasks - Defining project milestones based on project phases described in the proposal. - automate invoice generation in Books rom timesheets entered in zoho projects This project requires a deep understanding of both Zoho Books and Zoho Projects, as well as proven experience in API development. The goal is to streamline our workflow, reduce manual input and increase efficiency. Please only apply if you have relevant experience and can provide examples of similar work.

...Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ecosystem—this includes knowing how to optimize visuals to...

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of ...

...Mosque & Muslim-Based NGO Data with Detailed Documentation ________________________________________ Job Description: I am looking for a skilled automation expert to build a workflow that scrapes Google for global contact details of mosques and Muslim-based NGOs. The workflow must allow for targeted searches by category (e.g., society, charity, non-profit) and be optimized for credit efficiency in Make.com. The final system should produce structured data outputs and include clear, beginner-friendly documentation. ________________________________________ Scope of Work: 1. Automation Workflow: 1) Build a workflow to scrape Google for the following details: a. Organization Information: i. Organization Name ii. Organization Type (Mosque or Muslim-Based NGO) iii. Organizat...

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

Functional Analysis for the Project "Smart Company Management System" The "Smart Company Management System" is an internet-based system that helps organizations manage all internal processes in an organized and efficient way. The system allows managers and employees to automatically track projects, tasks, reports, and progress, improving work processes and optimally allocating resources. To perform a full analysis of the system, we will review each step of the project, including a detailed description of Use Cases and system actions. In this guide, we will conduct a functional analysis for each of the processes in the Use Case for the "Smart Company Management System," describing the actions that a user will perform and the actions the s...

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

...Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf using my resume on various platforms, like Linkedin, Workday and Indeed. Your task will involve searching for relevant job postings that match my qualifications, and submitting my resume for each opportunity. # Responsibilities: - Search for job postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow i...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...

I'm eager to learn how to build my own digital product store focused on E-books. I need guidance and support from an experienced professional who can teach me the necessary steps to set up an online store, from choosing the right platform to optimizing it for sales. Ideal Skills and Experience: - Proficient in e-commerce platforms like Shopify, WooCommerce, or Squarespace. - Strong understanding of digital product sales, particularly E-books. - Excellent teaching and communication skills. - Experience in setting up payment gateways on e-commerce platforms. - Knowledge of digital marketing strategies to promote the store.

...The process should include all the steps I need to follow to achieve this, starting from the domain verification to sending an email. For domain verification, I want to know how to add the required DNS records, such as TXT, CNAME, or MX records, and where to find these records in the Amazon SES console. The explanation should also cover how to confirm that the domain has been verified successfully and what to do if there are any errors or delays during the verification process. After verifying the domain, I want to activate SES. This includes instructions on how to navigate the AWS Management Console and set up the SES service. It should also explain how to move SES from the Sandbox environment to Prod...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helpin...

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

...data. This is a flexible, ongoing position with cash bonuses for honesty and accuracy. Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and accuracy in data reporting...