How to use excel for dummies jobs

...is to create striking images that can be utilized for commercial purposes. Key Requirements: - Proficient in outdoor portrait photography - Experience with commercial photography - Ability to capture compelling and unique images Ideal Skills: - Excellent understanding of lighting, composition, and perspective - Highly creative with a keen eye for detail - Technical mastery in transforming ordinary scenes into breathtaking visuals Your role would be to capture portraits in outdoor settings that not only tell a story but also appeal to a commercial audience. Each image should be able to reflect emotion, depth, and artistry, ensuring its uniqueness and timelessness. If you are passionate about photography and have the ability to ...

I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly beneficial.

I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.

I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.

I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.

...websites. This data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. Budget: Flat rate 5 NZD per 100 companies (100 office managers & 10...

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multipl...

I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of science. The analysis should specifically cover the experimental results presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demons...

...developing an AI platform for optimizing media campaigns, aimed at marketing agencies. The platform already has a functional MVP with an interface, missing the integrations and the AI ​​agent. 1. Backend & Integrations Integration with Ads APIs: Connect to the official APIs of Meta Ads, Google Ads and TikTok Ads to retrieve real-time data (e.g.: campaigns, metrics, budget). Create an OAuth2 authentication system for these platforms. Real Authentication System: Replace the current mock with a secure system (e.g.: Auth0, Firebase Auth, or JWT + OAuth2). Add permission controls (e.g.: admin, analyst, client). Real-Time Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Creat...

I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.

I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.

I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail

I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.

Subject: Power Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or ...

I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe

search and download

I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a ro...

I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills to understand and apply the required logic.

I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.

I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.

Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized l...

I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure

I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.

Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel.

I have a spreadsheet that requires some help with data formatting, particularly with date and time entries. I need someone who can fix the incorrect date/time entries so that the spreadsheet is accurate and usable. Ideal skills for the job include: - Proficiency in Excel or similar spreadsheet software - Strong attention to detail - Experience with data formatting and troubleshooting

...financial presentation for institutional investors, primarily aimed at securing investments. The presentation, approximately 20 pages in length, will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business context - Experience creat...

I'm seeking an experienced professional to design a compressed air piping layout for an industrial facility. The primary application of the compressed air will be for machinery operations. Key Requirements: - Design and layout of compressed air piping - Use of steel as the primary material for the piping - Consideration for industrial machinery operations in the design Ideal Skills: - Proficiency in industrial piping design - Extensive experience with steel piping - Knowledge of compressed air systems for machinery Please provide examples of similar projects you've completed, as well as your approach to ensuring efficient and safe design.

More details: Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP The target market for this project is tech companies. Targeting the global market for sales campaigns. The main goal is closed sales.

I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.

I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, please write "DATA" in your message.

...first book, which I plan to publish independently. The book will focus on how ma nagers can effectively handle difficult personalities in the workplace. The working title is Mastering Workplace Dynamics: How to Lead and Manage the Most Difficult People. I’m seeking an experienced book writer who can help me bring this vision to life. The writer will work with me to develop the manuscript, refine the structure, and ensure the content resonates with the target audience. Scope and Word Count: Word Count: Approximately 50,000 - 75,000 words The book will be divided into chapters, each focusing on a different difficult personality type found in work environments. Target Audience: This book is intended for managers, team lea...

? Title: Hiring Digital Marketing Executive & Marketing Personnel (Full-time & Part-time) ? Description: We are looking for two types of digital marketing professionals: 1️⃣ Digital Marketing Executive (Full-time) salary+ commission ✅ Execute digital marketing strategies based on brainstorming sessions. ✅ Set up and manage pages on YouTube, Vimeo, Skillshare, Coursera, and other platforms. post content on various platforms like medium substack vocal media ✅ Handle call-to-action campaigns, SEO, and social media promotions. ✅ Research and implement growth strategies to expand online reach. ✅ Assist in executing new ideas, business strategies, and brand promotions. 2️⃣ Marketing Personnel (Part-time) ✅ Flood the web with the company's banners, posters...

Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.

I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.

I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.

I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would b...

I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.

...inspire and educate people how to change and transform their lives. As an international teacher, I have taught in Australia, New Zealand, Peru, and Mexico and have assisted hundreds of people to find inner peace through yoga, meditation, & counselling. As a Coach and Therapist, I have pioneered a wholistic approach that assists people to transform their lives, using Yoga Therapy and Somatic Psychotherapy. This work has been recognised for assisting and affecting positive change in hundreds of people particularly those who suffer from anxiety and depression disorders. As am Empath & Intuitive I also communicate with animals and nature and teach people how to connect with the magic of life in this you want to create pro...

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm seeking to secure funding of $500k to purchase a transportable mixed-use facility. This facility will primarily serve both current and ex-Defense personnel. Key Features: - Mixed-Use: The facility will function as both accommodation and a toilet facility. - Disability Accessible: The facility must cater to wheelchair accessibility needs. Ideal Skills and Experience: - Experience with disability-compliant design and construction - Knowledge of transportable facilities - Previous work related to Defense personnel or military projects - Fundraising or grant writing experience. Proposals from those with relevant experience will be prioritized.

...can efficiently scrape sales leads from LinkedIn and Crunchbase. I want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline for project completion. Essential skills inclu...

I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.

I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner

I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.

Project Title: Web Application for Membership Sign-Up and ID Card Generation Project Description: I need a web application developed where users can sign up for a membership by filling out a form. After completing the form, users will be able to download their ID cards from their dashboard. The admin panel should allow administrators to monitor user sign-ups, view user data, and manage memberships. Requirements: 1. User Registration and Membership Form: User Registration: Users should be able to register on the platform via email or social login (optional). After successful registration, they should be directed to a membership form. Membership Form: The form will include fields such as: Full Name Email Phone Number Address (optional) Date of Birt...

I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.