Excel vba copy cells based on criteria jobs

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

I'm seeking a freelance Python dev... The script obviously fails on the "L" shapes. The has the expected result simulated. Attached is a zipped folder with everything you need to start. To run a script, use this command {filename} Example The "source" folder has various source images that have working and non-working cases. I need a solution that will work in most "non-working" cases. This script also has a function that saves points coordinates to JSON (before, after, and applied translations) It needs to be working and save only 4 points. Once a first working solution is submitted, I will make this contest "Guaranteed". Please don't post your code publically so other people will not copy your code.

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

I'm on the hunt for a skilled professional who excels in Tuya platform, specifically in app development. The intended Tuya app should manage the following functions: • Home automation control • Energy monitoring • Multi-device Management I favor a clean and minimalist design for this application. Ideal candidate should show: • Proficiency in Tuya app development • Experience with home automation, energy monitoring and multi-device management • An eye for clean, minimalist designs Apply now if you meet these criteria and demonstrate an impressive track record in the Tuya platform.

I'm seeking a proficient Telecaller to focus on generating leads for two key segments within my Event Management company: Corporate Events and Conferences. KEY RESPONSIBILITIES: - Establish productive communication with potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion ...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should b...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

...then make a compares between the 5 articles on level of the cybersecurity CIA and these articles should be from 2020 to current only. note; i will share the topics with you. select topic and then google it looking for the research paper. then find the survey paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP. Your prompt attention and quick work turnaround will be highly appreciated. Research Report 1. Title: [Insert your research title here] 2. Names: [Insert author names here] 3. Department: [Insert department name here] 4. Email: [Insert email address here] 5. Abstract (9-10 lines): Research area: Briefly explain the area your research focuses on. Problems: Identif...

We are currently in need of a highly skilled and experienced senior software developer to create web-based attendance and payroll software. Key Features: - Time Tracking: Essential for accurately recording hours worked. - Leave Management: Allowing HR to monitor and control employee leave effectively. - Shift Scheduling: Facilitating efficient scheduling and management of employee shifts. - Payroll Functionality: A critical component, ensuring accurate and timely processing of employee salaries and wages. It's beneficial if you have experience in creating applications that may need to potentially interact with existing payroll or HR systems in the future. However, specific integration with these systems at this point is undecided. Your experience in dealing with these kinds ...

...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We...

I have a task for those skilled in data entry, particularly with respect to copy-pasting job. The work is to be done in Google Sheets, so excellent proficiency in Google Sheets is vital. The volume of data is less than 100 rows and columns total. Therefore, I'm also expecting a high level of accuracy and attention to detail. If you've been involved in similar projects previously, that'll be an added advantage, but it's not a must. Key Skills/Experience: - Excellent copy-pasting abilities - Proficiency in Google Sheets - High attention to detail - Previous experience in similar projects is a plus

I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. For the view/UI React/It's front-end Library Setting up server, Use , which we'll use it for serve our front-end to talk with our DB Which is MongoDB, the DataBase. To deploy MERN stack app for free, first build your React frontend. Choose Netlify or Vercel for frontend hosting. Connect your GitHub repository and deploy the React app. For the server, select Heroku. Prepare your backend, set environment variables, and follow Heroku's deployment guide. For the database, use MongoDB Atlas, their free tier suffices. Connect your backend to MongoDB Atlas using its URI. ...

...ticket: I have tried again to update the staging site with the latest copy of the production and update the plugins and theme as well as the PHP version and here is the result. Updating the Pro theme have broken the existing layout of the pages and will need an overhaul of the child theme to match the new parent theme version when it comes to the structure. Updating the PHP version to 8.2 have generated and error on the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it had was way back 2016. The last post on their twitter account is way back in 2021. This plugin needs to be updated to match the requirements of PHP 8.2 before we can update the PHP version on the server. - update: I alr...

I am looking for someone based in the UK to assist me with my online business. The major responsibilities include: - Customer Support: You'll be tasked to answer basic customer inquiries. It's an easy commission based job that anybody can do on side, just the basic requirement is the person should be located in the UK.

...heterogeneous graphs. The main goal of the project is to predict links in the e-commerce data graphs. This task is essential for understanding and predicting customer behavior in my online store, which is crucial for improving services and increasing sales. Ideal skills and experience for the job include: - Expert proficiency in PyG (PyTorch Geometric) - Prior experience with link prediction on heterogeneous graphs - Strong understanding of e-commerce data and its characteristics Your role in the project will involve working closely with the e-commerce data, understanding the underlying patterns and relationships, and building a robust link prediction model that can be utilized to make informed business decisions. I'm looking for a freelancer who can deliver high-quali...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

Dear Developer, We have an older application that was developed 15 years ago to manage appointments for kitchen mechanics, using native PHP and JavaScript. As this app is now deprecated and outdated, we are looking to rebuild it entirely from the ground up while retaining its core functionalities. Project Overview: We are see...current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If you are interested in this exciting project and would like to discuss further details, including access to the existing application and specific requirements, please let us know. Thank you for considering this opportunity to collaborate on a forward-thinking technology project. Bes...

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates:...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should b...

...that's focused on software inventory. Key Details: - The report should specifically list all the software installed on the devices. Only installed software, not the default software installed by the operating system. - I only need a list of the installed software, without any additional usage statistics or version/license information. - It's essential that the report is filtered by operating system (Windows, macOS), as I need to have insights specific to these platforms. This is a crucial piece for our system management. The ideal freelancer for this project should have: - Deep knowledge of SCCM and experience in creating custom reports. - Solid understanding of software inventory and how it can be effectively reported. - Ability to precisely filter and structu...

Do you like getting freebies and earning a decent side income at your spare time? If so, become a product tester for Deal Select today! 3 Benefit of participating - Keep all received product samples. - Participate anytime, anywhere; each product testing project takes 10-15 minutes to complete. - Great side income at your spare times. Candidates should meet the criteria below. • Enjoy trying out different / new products. • Capable of formulating constructive reviews • Individuals residing in the US or Canada. Being familiar with the online consumer product landscape of US and Canada regions. Your responsibility: Once you have received the item, utilize the item for a specified amount of time. Then formulate a product review. The review is to be written within a w...

I have a website, , that I would like to copy for a new domain. However, I need this new site to have a similar structure, yet with a unique and bright and vibrant color scheme to avoid any SEO issues with Google. Key requirements for this project include: - Cloning the structure and layout of my current website , ensuring a similar user experience - Updating the design with a bright and vibrant color scheme - Ensuring the updated design is distinct enough from the original site to avoid any penalties from search engines Ideal skills and experiences for this job would include: - Proficiency in web design and development - Experience with creating SEO-friendly websites - Strong sense of aesthetics and understanding of color theory - Familiarity with cloning

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

I'm in need of a talented copywriter to handle a variety of projects. - The ideal candidate for this role is someone who has a strong command of the English language and the ability to create engaging, compelling copy that will resonate with my target audience. - I'm looking for someone who has experience writing for a variety of mediums, including web content, social media, and marketing materials. - You should be able to adapt your writing style to suit different platforms and audiences, and have a good understanding of SEO principles. - It would be a bonus if you have experience writing for business professionals or young adults. If you're a creative, detail-oriented copywriter with a passion for engaging your readers, I'd love to hear from you.

I'm in need of an individual with exceptional graphic design and attention-to-detail skills to create a mockup of a custom dimension basketball court. The court should be designed according to the following criteria: - Dimensions: I require custom dimensions for the court, which will be provided upon project commencement. - Freelancer Application: Please include your past work, specifically related to graphic design and preferably if you have previous work on athletic fields or courts. - Color Scheme: The mockup should utilize my team's colors. The precise colors will be shared with the chosen freelancer. Proven experience in a similar project and understanding of the principals of basketball court design is a mus. Your unique artistic style, ability to follow ins...

I am in need of a talented and experienced content writer to generate professional blog articles that delve into the realm of technology. Key Requirements: - Understanding and capacity to write detailed blog content on various aspects of technology. Creativity when it comes to making complex tech-related topics engaging for a wide audience is central to this project. - Ability to adhere to a professional tone of voice throughout all blog articles. Desired Skills and Experience: - Proven track record in writing about technology. - Strong ability to write in a professional tone. - Fluency in English and excellent proofreading skills. This project requires the combination of technical understanding and exemplary writing skills to create informative, professional, and engaging...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

I'm looking for a skilled motion designer who can work quickly to repurpose a video we have. The scope of the project will involve: - Using an existing video that we have as the foundation - Modifying the text and graphics within the video - Adding in new footage as needed - Altering the color scheme to fit our updated b...Modifying the text and graphics within the video - Adding in new footage as needed - Altering the color scheme to fit our updated branding - Ensuring the final video is succinct, being no more than 24 seconds in length Ideally, the freelancer will have experience in video editing and motion graphics, and can work creatively and effectively under a short timeline. Experience with rapid turnarounds and copy jobs is a bonus. We need this project completed as so...

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skil...

I need someone with accounting knowledge to copy instructions from a video onto paper. The video is about job costing and necessary journal entries and you will need to write each step down exactly as the shown in the video. Only apply if you can start right away as I need this job done fast.

I need someone with accounting knowledge to copy instructions from a video onto paper. The video is about job costing and necessary journal entries and you will need to write each step down exactly as the shown in the video. Only apply if you can start right away as I need this job done fast.

...compelling website copy that adheres to our brand guidelines. - Develop insightful blog articles that will keep our audience engaged. - Write product descriptions that effectively detail our offerings. Ideal Skills and Experience: - Proven experience in copywriting with a focus on business clients. - Exceptional writing and research skills. - Ability to write crisp, enticing and well-structured copy. - Excellent understanding of content optimization and SEO strategies. Though the main goal was not specified, a keen understanding of business trends and the ability to adjust the tone of content to resonate with the business audience will be of extreme importance. If you are quick on your feet and have a knack for speaking the language of businesses throu...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I am in need of a capable freelancer who is skilled and experienced in creating SAT practice tests. Here are the specific details: - The difficulty level of the SAT practice tests should be medium. - Each SAT practice paper should include the following sections: Mathematics, Reading and Writing, and Essay. - I am requiring 10 complete SAT papers to be reconstructed. Given ...be reconstructed. Given the nature of the work, a detailed understanding of SAT format and contents is absolutely necessary. A background in educational fields, especially test preparation, would be a big asset. Good command of English for the Reading and Writing section is also a must. Your work will aid in providing valuable practice resources for SAT students. If person fits criteria this will be a salary...

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

Copyright copy writing copy tipe

...Studio, and other related software. Our goal is to mentor high school students to help them create a dummy app. We are committed to: - Enhancing the students' critical thinking and analytical skills in the span of a 2-3 month project. - Teaching them how to create and utilize a dummy app. We are looking for a mentor who can: - Implement problem-solving strategies using AI. - Instruct students on various software tools like JAVA, XCode, React Native, Android Studio, etc. Hence, candidates with experience in both educational and practical aspects of the above-mentioned software, along with a strong dedication to education and mentorship, would be an ideal fit. We embrace expertise and enthusiasm for teaching young minds. Interested candidates may share their CVs at dis...

I have recently received a rejection for my visa application due to a misunderstanding of the eligibility criteria. I am in need of a skilled professional who can help me with the appeal process. Key Responsibilities: - Review the rejection reasons and my initial application - Advise on how to address the eligibility issue - Help in presenting the supporting documents more effectively Ideal Freelancer: - Experienced in visa appeals and immigration processes - Familiar with eligibility criteria for the specific visa I have applied for - Skilled in crafting effective appeal documents - Can work efficiently to meet any deadlines related to the appeal process

...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough...

Job Description: We are seeking a motivated and results-driven individual to join our team as a Social Media Sales Representative. As a commission-based role, you will be responsible for reaching out to potential clients on Instagram and securing orders for our social media services. Your primary goal will be to generate leads, build relationships, and close deals. Responsibilities: 1. Identify and reach out to potential clients on Instagram who may benefit from our social media services. 2. Present our services in a compelling manner to effectively communicate the value proposition. 3. Build and maintain strong relationships with clients to foster repeat business and referrals. 4. Negotiate pricing and terms to close sales and achieve revenue targets. 5. Provide ex...

I'm building the brand for a new business that offers affordable tax services to freelancers. This is a VERY EASY project. All we need on the logo are two elements: 1. The business' name: Goodtax 2. An "icon" IMPORTANT: > The business name is Goodtax - that's capital G and the rest lower case. > Business name is one word. > We don NOT want a slogan in the logo. > The preferred font is Inter, but feel free to suggest a similar font. > The icon we don't know what, but looking for ideas. Attached is an example of how simple we want the logo (don't submit a copy of these). Here's some more info about the business to use as inspiration: --- Get help from a tax accountant who understands. Good tax? Seriously? Yes, Good...

...focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particu...

...materials. These materials will primarily focus on advertising our products/services to a target audience of young adults. The ideal candidate for this project should: - Have experience in creating modern and minimalist designs. The aesthetics should represent our brand to help distinguish our products/services in a competitive market. - Have a sound understanding of how to speak to a young adult audience through visual design. This includes an understanding of the type of imagery, typography, and color schemes that resonate with this demographic. - Be able to create materials that are not only visually appealing but also effectively communicate the benefits of our products/services. This may involve a mix of visual elements and concise copy. Ultimately, the goal of t...

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...

...Implement User Registration and Login to enable job seekers and employers to create accounts and access the platform - Job Search and Filtering, enabling users to search for jobs based on different criteria - Apply for Jobs feature allowing job seekers to apply directly for the positions they are interested in Additional Features: - Push Notifications are to be integrated into the app to keep users informed about relevant updates - The app will have a Resume Upload and Storage feature allowing users to upload and store their resumes on the platform Ideal Skills: - Proficiency in hybrid app development, particularly on iOS and Android platforms - Experience in building and integrating admin panels for managing online platforms - Strong knowledge of mo...

I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if workin...

More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is

I am seeking an experience...of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix this issue...

I need a thorough and capable freelancer to assist in data entry tasks. This project revolves around seeking out the contact details of companies provided by me. Key tasks will...thorough and capable freelancer to assist in data entry tasks. This project revolves around seeking out the contact details of companies provided by me. Key tasks will include: - Google each company name I provide - Gather relevant contact details such as phone numbers, email addresses, and the company's website As I am seeking information from a range of different companies without specific criteria, being detail-oriented and accurate will be crucial. Experience in data cleaning, analysis, and transcription would be advantageous. Understanding and utilization of web scraping techniques would also...

I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.