Excel spreadsheet tutorialJobs
Abrir um determinado numero de linhas no excel a partir de um número indicado na celular. Ex em anexo. Queria um botão que fizesse isso clicando no botão transformava o que está em AZUL para o que está em VERMELHO. anexo imagem
I'm in need of a spec...limited to: - Mastery of CYPE software - A strong understanding of energy properties - Applying CYPE software skills for tasks including structural analysis, building design, and construction documentation. Your proficiency in the software should allow for efficient job posting, a confident approach to the bidding system, and capable use of communication tools. Your skills will allow you to excel in the creation, editing, and proper documentation of projects. Your understanding of the specifics of energy properties and how to use CYPE software to analyze these is crucial. This job will require comprehensive use of your skills and abilities, demanding both technical precision and creative problem-solving. A strong background in web developmen...
...headcount exceeding 200 pigs. I'm seeking a freelancer who is well-versed in accounting practices and comfortable working with Excel to help me break down various aspects of my business costs. Key tasks would include: - Material cost analysis: This needs to consider everything that goes into looking after and maintaining over 200 pigs. - Labor cost analysis: I need to better understand how labor costs are influencing my total expenses. - Overhead cost analysis: All indirect costs associated with running my business need to be determined. The ideal freelancer for this job will have strong accounting skills, a keen eye for detail, and extensive experience in Excel. A background in agribusiness would also be beneficial but is by no means mandatory. What sets this pr...
I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.
...need of a digital wizard who is proficient in Excel and Airtable to assist me with a project. - The task at hand is to successfully transfer specific data from Excel to Airtable. This includes a combination of text, numbers, and dates. The organization is key, so I'll need these entries to be accurately placed. - The data in Excel is neatly structured in rows and columns. However, each individual file can contain a substantial amount of information, so attention to detail is imperative. - The goal is to have this data organized in Airtable according to specific categories. Preferably, I'd like someone with experience in data architecture to setup a clear, easy-to-navigate structure within Airtable. Ideal Skill: Outstanding knowledge in Excel, A...
I'm seeking a skilled video creator to produce a crisp, user-friendly tutorial for my website. Focused specifically on navigating product customization, this video will guide users through the process of selecting product options. Key tasks: - Demonstrate steps to select product options on the site - Highlight important areas and features related to product customization Ideal skills: - Proficiency in video creation and editing - Understands website navigation and user experience - Ability to create a clear, concise and engaging tutorial video. We need 2 videos of about 15 seconds each.
I am in urgent need of an expert who can promptly install Restreamer with SSL on my Ubuntu Linux server. I require professional assistance to leverage the potential of live streaming via this platform. in Linux Ubuntu - Exemplary skill in Restreamer live-streaming installations with SSL The Task: - Installing Restreamer with seamless SSL integration - Ensuring high-quality live-streaming functionality - Prompt delivery of the project I anticipate that candidates, who have a wealth of experience with Restreamer installations coupled with in-depth knowledge about Linux Ubuntu, will excel at this role. A quick and efficient delivery will be greatly appreciated. Kindly add references to your similar past projects in your bid.
I am looking for someone who can help with transferring textual data from digital documents to Microsoft Excel. I have a range of documents prepared, all you need is to meticulously input the information into the designated spreadsheet. Skills & Experience Needed: - Proven data entry proficiency - Familiarity with Excel and understanding its features - Strong attention to detail - Ability to input data accurately - Understanding of digital documents and formats
I'm in need of a professional with strong data analysis skills. Your task will be to help analyze PDF invoices from our clients and convert them into spreadsheet format on a weekly basis. The specifics of the job are as follows: - Extracting specified data points from client invoices, which includes the invoice number, total amount, and item descriptions. - Transitioning the extracted data into a comprehensive spreadsheet, ready for tendering. The ideal freelancer for this project will have the following skills and experience: - Proficient in working with PDF documents and extracting information. - Expertise in data analysis and management. - Strong knowledge of spreadsheets and other data visualization tools. It's important to note that new invoices will be ...
Necesito trasladar a la tabla Excel adjunta un listado de todas las empresas que aparecen en un buscador público (). Además del nombre, para cada empresa necesito que se indiquen dos cosas que aparecen en el propio buscador: (i) el municipio en el que se encuentra y (ii) el enlace a su autorización más reciente.
I'm seeking an experienced individual who is skilled in data entry, specifically with numeric inputs. You will be expected to take on the following responsibilities: - Transcribing numeric data from physical documents. - Organizing this information logically and efficiently in spreadsheets. Expert user experience in spreadsheets is a must for this project. You should be detail-oriente...logically and efficiently in spreadsheets. Expert user experience in spreadsheets is a must for this project. You should be detail-oriented with a high level of accuracy and speed. A background in handling physical document sources will also be advantageous. Your main objective is to ensure the smooth conversion of these physical numeric data into a clear, easy-to-understand format in a digital s...
I am looking for a proficient Microsoft Excel user, preferably with a background in architecture or design, who can accurately draw a floor plan of a lab space using my hand-sketched references. Key considerations for this project include: - Your advanced Excel skills, including creating graphics and managing moveable elements - Demonstrated ability to translate sketches into finalized digital renderings - Proficiency in using standardized industry symbols I will provide a sketch of the intended layout, and the plan needs to feature movable elements including cranes, racks, shelves, and tables. Your work should give an accurate representation of size and positioning within the lab. This project requires a meticulous eye for detail to ensure the final version is a trustwor...
I'm seeking a freelancer with exceptional experience in business process automation to help automate my sales process specifically. Here's what I need your assistance with: 1. Data Entry Automation: We have copious amounts of data that require efficient and error-fr...Contact Management: Currently, we're looking for a solution that will automatically manage our leads, track correspondence, and schedule follow-ups primarily through phone calls. 5. Proposal Creation: In order to save time and effort, I would like an automated system that can generate and send proposals, customized based on the lead information obtained. Strong working knowledge of CRM systems, Excel, and programming languages used in automation such as Python or R is expected. Previous experience in ...
As an individual with a lot of paperwork that needs to be digitized, I am looking for a capable freelancer to carry out a variety of data entry tasks. This will involve entering data from handwritten, printe...needs to be digitized, I am looking for a capable freelancer to carry out a variety of data entry tasks. This will involve entering data from handwritten, printed, and digital documents. The number of documents to be worked on will be less than 100, making this a suitably compact project. I need the data to be precisely entered in a Microsoft Excel format. Ideal skills and experience for this project include: - Proficiency with Microsoft Excel - Previous experience with different styles of data entry - Ability to decipher handwriting effectively - Accuracy and att...
I'm in need of assistance to combine several XLS and CSV files into one inclusive XLS file. Each sheet within the file should represent the original file from which the data was drawn. Although some files maintain a consistent format, others vary, thus requiring the ability to manage and merge a mix of formats. - Skillset Necessary: Proficiency in Excel is critical along with the ability to manage data from a multitude of formats. - Task Summary: Translate multiple CSV and XLS files into one singular XLS file with each sheet equating to an original file. - Data Arrangement: Data organized according to the original file it was grouped with. Please ensure your final delivery maintains the integrity of the original data, keeping original files organized, despite the div...
I am looking for a freelancers with Tableau experience to help visualize some data from Excel. The current plan is to generate heat maps in Tableau based on the properties listed in Excel. The deliverable will be Tableau files and screenshot. Please include your hour rate in your reply.
I am seeking a specialist for an Excel Exploratory Data Analysis (EDA) project who can conduct data cleaning, preprocessing, data visualization, and statistical analysis. The project will involve working with both categorical and numerical data and variables. The required skills and experience include: - Mastery in Excel for data cleaning and preprocessing - Proficient in data visualization using Excel - Familiarity with statistical analysis The primary objectives for this EDA project are: - Identification of patterns and relationships within the data - Detection of outliers or anomalies in the data - Understanding the data distribution of variables Please ensure your proposal clearly illustrates your past experience with similar projects and how you intend to a...
I need someone skilled in data entry and Excel to help me create a comprehensive database. I'll provide an Excel file with a list of names that I'd like you to translate into an organised, efficient Excel sheet. For each name, I require the following additional information apart from their email, title, and job specialty: - Company name - Location - Phone number - Job description I don't have a specific excel template in mind, hence, your creativity and technical know-how in creating a user-friendly format will be an asset.
I am seeking a professional capable of accurately extracting attendee lists from a number of LinkedIn events. Details: - The LinkedIn events in question will vary, and a comprehensive list will be provided upon commencement of the project. - A detailed project proposal outlining your approach and methodology is a mandatory part of your bid. Skills and Experience: - Proficiency in web ...upon commencement of the project. - A detailed project proposal outlining your approach and methodology is a mandatory part of your bid. Skills and Experience: - Proficiency in web scraping and data mining - Extensive experience with LinkedIn or similar professional networks - Strong attention to detail Please note that the extracted data should be neatly formatted and delivered as an Excel ...
...of data collection. Work script: 1. Open Google maps in a specific area (provided by us) and search for a specific keyword 2. Collect to Excel table all the businesses related to the specified keyword 3. Find if there is a website and collect it's address if present on Google Maps 4. Find some contacts of high level manager of the company in LinkedIn 5. If you can not find contact details of high level manager, find generic email of the company End result is an Google Sheets table with all the collected data. We are looking for someone, who owns fast computer to do this work effectively. Requirements: * Basic Web browsing skills * Know how to use MS Excel or Google Sheets * Fast computer to have good browsing speed * Must have your own LinkedIn account Table to fil...
I'm in need of a talented web developer to create a portfolio website for my company. This website should be a static one, providing details of our services, a comprehensive company profile, an "About Us" section, and other relevant information. A few salient points to note: • Utilize a color scheme that combines blue and orange, reflecting our...display on various devices. Ideal candidates should have: • Proficiency in web development, particularly in creating portfolio websites • Competency in responsive web design • An eye for aesthetics, as represented by a strong portfolio • The ability to incorporate our requested features and color scheme into a compelling and professional website design. If this sounds like a project you'd exc...
I require assistance with automating pivot table creation in Excel, using Python scripts. The pivot tables would need to handle both numerical and textual data. The primary operations to be performed on the textual data are grouping and counting. Ideal Skills: - Proficiency in Python - Experience with Excel automation - Ability to work with both numerical and textual data - Understanding of grouping and counting operations for pivot tables Tasks: - Develop python scripts for automating pivot table creation - Ensure proper grouping and counting of textual data - Test scripts to ensure accurate pivot table outputs
...report on the grid codes concerning the connection of photovoltaic installations to both low voltage (LV) and high voltage (HV) grids, categorized by surface and power, whether ground-mounted or rooftop, across several European countries. The countries of interest are Poland, Bulgaria, Germany, Spain, Italy, Croatia, Serbia, Czech Republic, and Slovakia. Additionally, we require the creation of an Excel table summarizing the collected data for all these countries. Scope of Work: Conduct an in-depth analysis of the grid codes and regulations pertaining to the connection of photovoltaic installations to both LV and HV grids, characterized by surface and power categories. Identify and summarize the key requirements, restrictions, and standards applicable to PV grid connection in ea...
I'm in need of a web developer who can build a website for me. The main purpose of the site is to provide educational tutorials to a target audience of professional adults. As such, the website design should be professional and visually appealing in order to attract the intended demographic. Key Responsibilities: - Developing a user-friendly, easy to navigate website - Incorporating a platform for posting and organizing educational tutorials Ideal Skills and Experience: - Proven Web Development skills - Experience with educational platforms or websites - Understanding of professional adult learning needs and preferences - Excellent UI & UX skills
My project requires a skilled freelancer proficient with Excel to develop a dashboard focused on trip tracking. Key performance indicator that should be incorporated is the number of trips. Your expertise in dashboard and data analytics would be most ideal, while experience in sales, finance, or marketing is not necessary for this specific task. Kindly refrain from including other metrics or data visualization as I prefer to focus solely on tracking trips for this particular Excel dashboard.
As a business professional, I need assistance with Excel data entry. Specifically, I need expertise in compiling specific types of data from the web into an Excel format. The project's primary scope entails: - Compiling contact details from various online sources. Given your expertise, you ought to have: - Varied experience in Excel data entry. - A keen eye for detailed, accurate data compilation from the internet. - Strong organizational skills that aid in arranging data logically and usefully in Excel. - Knowledge of Excel functions and commands. - A proven track record in web research. I look forward to receiving well-informed bids from freelancers with matching skills and experience.
...research skills to source 100 email/phone contacts of specific decision makers within national corporations' in-house legal teams. Deliverables: - Minimum of 100 legitimate email and phone contacts. - A spreadsheet with populated entries: contact name, job title, company, email, phone number. Job Description: - Research and identify decision makers within the corporate and legal sectors in national companies from a list of provided business names. - Job titles to focus on include 'General Counsel', 'Head of Technology', and 'Partner'. - Input all these details into a provided spreadsheet. Ideal Skills: - Exceptional research abilities. - Strong organizational skills. - Proven experience in Lead Generation. - Knowledge about corp...
As a beginner in Excel, I am looking for a passionate and experienced tutor to give me less than 5 comprehensive lessons, primarily focusing on Excel formulas, functions and pivot tables. Here's what I'm expecting: - Introduction to Excel formulas and functions. We'll go over the basics and gradually delve into more complex usage. - Teach me how to build and manipulate Pivot Tables. This includes being able to understand my data better and make more effective decisions. Ideally, you should have: - Strong command over Excel and its nuances. - Experience in teaching or tutoring, with ability to explain complex concepts in a simple manner suitable for a beginner. - Patience and good communication skills to ensure I properly understan...
As someone new to Excel, I am seeking skilled and patient instruction in this powerful tool. Here's what I hope to learn: - Delve into Excel's formulas and functions - Understand and create pivot tables Through these lessons, I hope to bolster my work-related Excel skills. Therefore, tutors with experience in business applications of Excel will be preferred. Be ready to make these topics accessible to an absolute beginner.
...membership form : It will contain basic details like name, address, district, Mobile number should be OTP verified. I can provide msg91 or smsalerts API Additionally it should have field for Voter ID. Once user submitted voter ID number it should validate using API and voter data is captured in backend and then proceed for final form submission. In admin panel, we can able to see all data, export in excel, filter entries by district, pin code , search using voter id. once user submits form, in end screen it should show application reference number with submitted date and time and they download it as acknowledgement. Ideal Candidate Skills: - Proficient in Angular - Experience in creating user-friendly forms - Comprehensive understanding of data storage and manipulation - Kn...
I have small task need help with excel work and few writing. This is bit urgent.
Task requires a skilled PHP Laravel developer, with expertise in both frontend and backend functionality enhancements. I am looking to make a few modifications/customizations to a script/website. You can view the script (message me). This task requires excellent PHP and Laravel framework skills, as well as good CSS experience. If you excel in these areas and are very knowledgeable, this task should take approximately 1-4 hours to complete. The maximum payment for this task is $30. No bids over $30 USD accepted. Time frame 2-4 days. Some modifications include: Allowing the use of HTML in the content boxes/sections of pages and homepage, Eg: to insert images, videos, info boxes, or any other HTML content. Currently, only plain text is allowed. The aim is to keep it very simple, (an...
I'd like to see about using you a again. I cannot figure out how to get an NDA executed so I can send you the spreadsheet to put together a quote for me. I cannot afford $80 per hour equivalent for tasks. Do you have flexibility in your rates? If not I will need to find someone else. The tasks are writing a few macros and figuring out some formulas I cannot get to work. If we establish a good relationship at a rate I can afford, I will need ongoing improvements and possibly bug fixing.
You should be skillfull in excel to carry our: Performa DCF analysis of the company, which should include 1. Calculating the FCF 2. Forecasting the FCF 3. Calculating the TV and NPV oft he company
My project involves a comprehensive rearrangement of my existing Excel spreadsheet. The tasks include: - Altering the column order - Modifying the row order - Grouping data appropriately These changes must align with my specific needs, which will be communicated as we proceed - a clear understanding of my requirements is essential. The freelancer best suited for this task would have strong Excel skills and prior experience in customizing spreadsheets to client specifics. Please note, there might be a need for followers up attention, which might include rearranging specific columns. However, these details will be provided as the work progresses. Your ability to adapt to these changes whilst maintaining the quality of work is crucial.
...System Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: Th...
I'm looking for an experienced and professional videographer who can create captivating and beautiful presentation of the halve-z lash extensions to run on my homepage of my website. Show the box, the set, then flash forward to applying it to the lashes, then the...to the lashes, then the completed look. Your responsibility will entail: - Developing content that is easy to understand for beginners. - Focusing on the application technique of lash extensions, while ensuring the video's clarity and quality. - Ensuring the video is intriguing, engaging, and informative. The ideal freelancer for this project should have: - Previous experience in creating tutorial videos. - An understanding of DIY beauty procedures. - Excellent videography skills capable to guarantee clear, ...
I'm in need of a freelance video editor who is well-experienced in creating professional video intros. This 5 seconds video intro will be used across an array of our future videos like promotional, tutorial, and social media videos. When applying, please keep the following aspects in mind: - You'll be ideally incorporating our company logo into a catchy and engaging introduction. - I'm leaning towards a professional style, so your proposal should reflect this in the examples of work you choose to include. - Prior experience in video editing is a must, especially in creating video intros. Your task is to create a very short but attention-grabbing video intro in line with our corporate branding. If you have done similar work before, don't forget to include samp...
Hola, Tengo un software en un servidor que contiene la información de nuestro catálogo de productos, tieneunas reglas de cambio de ean, stock etc y necesito cambiar unos valores
...our country and each province separately, with ability to select each province , with the ability to utilize geolocation, add custom markers, and employ filter options (by date, type etc..). Verified reports should be displayed on the map as pins, marks or some kind of icon.. As well as a section to post news/updates (can be fetched from the website [WordPress] or done independently) and video tutorial on the main app tab. Both app and web version need to have multilingual support (RTL direction too). Multiple user roles (volunteers,moderators, admins) and notifications for report status changes and/or news updates. User reports should include three options: - Text input: to describe the type and quantity of litter/waste. - Photo upload: for visual evidence of the pollution. -...
I urgently need a specialist in Excel Macros to create a template that can swiftly convert my data from its current Excel format to a specified end format. What I require is: - Expertise in Excel Macros. Although my data is in Excel, this task will require more than basic or intermediate understanding of Excel functionalities. Thus, the ideal bidding freelancer should be adept in creating and applying complex Excel macros. - Fast turnaround. Due to the immediate nature of the project, I require completed work ASAP. Therefore, a freelancer with the ability to work quickly and efficiently would be ideal. - Examples to aid understanding. To make the job more comprehensible, I will provide 'before and after' examples of the data conversion. ...
Create an excel sheet where I can score my columns based on categories and sub-categories. There are Two major groups. Likelihood & Impact. The end goal is to get a final Likelihood and Impact score for a bunch of risks. the max allowed score is 9 for both these groups. Each group is divided into 6 categories. Each category can have a max score of 1.5. Each category has 3 sub categories. Each sub category can have a value of 0 or .5. The categories and its subcategoreis for likelihood score is shown below. I need an excel sheet that can help me do this calculation where I can select the value of each sub-category (0 or .5) and I should have a total score of the category and then finally a total Likelihood score. The same will apply for Impact scoring. I can share the I...
Hi Ana, I have a new project if you are interested? I have a spreadsheet that needs email addresses and names added. The data will need to be searched in Gmail and then added to the spreadsheet. Thanks Chris
I’m looking to hire a proficient Microsoft Excel expert, specifically, someone who excels in automation tasks. Tasks for this project include: - Creating automation scripts for: - Data Formatting: The job will require you to set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and has extensive experien...
Hola, necesito un software para mapear un archivo excel contenido en un servidor. Debe se tener un output mapeado con unas reglas
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...
We are currently seeking English voice actors for male characters for a gaming project. Here are the desired skills and experience: - Voice acting experience - Ability to deliver a quick turnaround, as this project needs completing ASAP. - Understanding of audio recording and editing tools. - Excellent inter...and expressiveness, to ensure the audio captures listeners' attention. Due to the confidentiality of the project, we will send you the audition files upon receiving your application. If possible, you may also send your voice reel and contact information, so that we can reach out to you promptly for any suitable opportunities in the future. This is an exciting opportunity for voice actors who excel at creating intense, dramatic performances. Your voice could bring my p...
...has a keen understanding of the top trends in the iconography. The creative direction for this project leans towards a clean, simplified look that better matches Windows applications such as the Microsoft Office suite icons, for example, Word, Excel, and PowerPoint. Key Project Requirements: - Your design should reflect a professional yet attractive flat design style - The color scheme should be sophisticated and simplistic, complementing Microsoft Office's aesthetic - Please incorporate design elements that resonate with Microsoft Office's Word, Excel, and PowerPoint icons Ideal Skills and Experience: - Demonstrable experience with flat icon design - A deep understanding of Microsoft Office's design aesthetics - Provable proficiency in graphic design sof...
