Como hacer una planilla en excel paso a paso jobs

My Excel sheet requires some urgent formatting adjustments to properly calculate and display the gross profit (GP) of items. Key Issues: - Formatting problems predominantly in the cells and tables Necessary Skills: - Advanced Excel expertise - Experience with data validation and conditional formatting - Attention to detail to ensure accurate GP calculations Your role will be to troubleshoot and rectify the formatting issues to ensure the sheet operates correctly and efficiently. Your expertise will allow for the implementation of necessary data validation and conditional formatting to improve the functionality of the sheet.

I need a straightforward travel calculator focused solely on air travel. This tool should be built in Excel and utilize a simple user form with concealed tables that house the necessary data sets. Key Features: - The calculator should handle only air travel. - It should factor in flight distance and also calculate frequent flyer points based on the journey. - The user input form needs to encompass departure and arrival locations, class of service, and booking class. Ideal Skills: - Proficiency in Excel, particularly in creating interactive user forms and concealed data tables. - Understanding of air travel metrics and frequent flyer point systems. - Ability to create a user-friendly, simple yet effective travel calculator.

I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!

I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)

I need a skilled HTML/CSS professional to create a custom quote template in Cin7. The template should be based on a design I created in Canva, which I can provide as a PDF or JPG. Key requirements include: - Inclusion of specific elements: Client Information, Terms and Conditions, Company Information, and a personalized header and footer. - The ability to replicate a style I've created in Canva. Ideal candidates will have: - Extensive experience with HTML/CSS. - Familiarity with Cin7 and it's variables. - Ability to interpret and translate a design from Canva into a functional template. - Attention to detail and commitment to delivering a high-quality, professional product. Link to Cin7 custom document article fo...

Render de un parque industrial el parque industrial se llama “BRUGA Parque Industrial” son 16,000 m2 con calles de 20m de ancho, sistemas contra incendio en una ubicación privilegiada a 20 minutos del aeropuerto a 5 minutos del nuevo cedis de castores a 1.5 km del macrolibramiento. Barda perimetral, CCTV, Vigilancia 24/7 , ubicado en la zona de mayor crecimiento industrial en la ZMG. quiero 8 bodegas, que son de este estilo, con jardines, pero que respeten una calle para camiones pesados de 20 mts con la glorieta Al fondo y busco una entrada de parque industrial como la de la foto.

I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included

I'm seeking a dedicated individual or a team to assist with research into Melbourne-based businesses. Your primary tasks will include subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales Navigator - Proficiency in Excel - ...

I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.

I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED

I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail

I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experience with Excel, parti...

I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel...

...other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs) should be organised in folders and linked to their corresponding rows in the spreadsheet. 3. Requirements: • Ensure data accuracy and completeness. • Follow ethical web scraping practices (only scrape publicly accessible data). • Avoid causing disruption to the website’s operations. Deliverables: • A completed dataset in Excel/CSV format. • A folder containing all associated images/files. • A brief summary of the process and any challenges encountered. Budget: • ~£100 Deadline: • Please...

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.

...After registering, the registrant lands on my custom thank-you page in Systeme.io. * Here, I want their unique webinar link (generated by Stealth Seminar) to be displayed.
 3. Dynamic Webinar Link Display: * The goal is to retrieve the unique webinar link from Stealth Seminar and display it dynamically as a clickable link on the thank-you page. See attached images (Resistration-Page and Thank-You page) Documentation (important parameters):

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.

As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.

Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken langu...

I am on the lookout for a talented animator to create five 2-minute long, cartoonish, 3D animations aimed at a children's audience for entertainment purposes. The video IT'S ABOUT "EL CONEJO" RABBIT IN SPANISH Key Requirements: - Experience in creating 3D animations, particularly in a cartoonish style. - A deep understanding of children's entertainment, with the ability to create engaging, age-appropriate content. - Strong storytelling skills to convert the lyrics to video animation. - Ability to deliver high-quality, professionally polished animations within a set timeline. - The lyrics are in spanish. - LYRICS MUST DISPLAY AT THE VIDEO Ideal Skills: - Mastery of industry-standard 3D animation software. - Excellent understan...

I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.

I'hankm looking for a pPDF, Word. T y Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft Excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective drop-down lists. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

...________________________ We are looking for a dedicated full-time admin doing bookkeeping reports! This role is ideal for someone with basic or no bookkeeping skills who is eager to learn and grow. Responsibilities: Prepare and submit reports every hour on the hour during your shift. Attend and participate in a meeting to review the report at the top of each hour. Maintain accuracy and timeliness in all reporting tasks. Schedule: 9:00 AM to 5:00 PM EST, Monday to Friday. Requirements: Basic understanding of bookkeeping (no extensive experience necessary). Strong attention to detail and time management skills. Ability to follow a structured schedule and meet deadlines consistently. Reliable internet connection and proficiency with tools like Excel, Google ...

I need assistance with an Excel spreadsheet. The project involves data analysis, particularly performing statistical analysis. Ideal Skills: - Proficiency in Excel, particularly with formulas and data analysis tools. - Experience with performing statistical analysis in Excel. - Ability to assist with sorting and filtering data, as well as creating pivot tables.

Dear Freelancers We need someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over the years -number of the invoice and how much invoice they paid over the years too Invoices are .doc (so you can copy/paste) easily We give access to our Dropbox From 2020 to 2024 there is around 1300 invoices You can do it on excel or something else if you have an other idea, we need something designed and easy to look at please Write elephant in your bid to show us that you've read what we need Need it fast, thanks !

I'm looking for an experienced Excel professional to create a comprehensive spreadsheet for tracking my stock trading activities. This spreadsheet needs to be efficient and effective, capturing all relevant data points. Key Requirements: - Proficiency in Microsoft Excel (preferably with experience in creating financial spreadsheets). - Ability to efficiently track and calculate critical metrics such as purchase dates, sale dates, and profit percentages. The ideal candidate will have a keen understanding of stock trading and can translate this into an effective tracking tool.

I need an expert to help me organize my Excel file containing employee attendance data. Key Requirements: - Setting up filters for my analysis on employee attendance - Creating specific filters for different aspects of the data - Ensuring the file is user-friendly and easy to navigate Data Types: - Employee attendance data which includes number of days off, late comers, and early leave. Ideal Skills: - Advanced Excel proficiency - Experience in data organization and analysis - Attention to detail - Ability to create user-friendly spreadsheets

Create a .Netcore Razor Pages solution connected to SQL. It is for handling work orders in a workshop. An order will be assigned to a mechanic. The equipment or machinery is registered. The items to be used to control the inventory and materials are added. It must be able to record comments. And it must have a reporting session. The equipment and machinery must be registered and the maintenance dates stored. --- Crear solucion en .Netcore Razor pages conectado a SQL. Es para manejar ordenes de trabajo en un taller. Se asignará una orden a un mecanico. Se registra el equipo o maquinaria. Se le agregan los items a utilizar para controlar el inventario y materiales. Debe ser capaz de registrar comentarios. Y de...

I need to delete multiple rows within a Word table. I have an Excel showing which rows should be deleted. Afterwards, some page breaks and formatting work might be needed. Skills needed: - Proficiency in Microsoft Word - Attention to detail I have two print screens attached. The word document has 102 pages with 675 rows. 326 rows need to be deleted. All work in the word document needs to be done twice: There is an English version of the document, and a German version.

I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.

I'm looking for a Personal Assistant to help manage my workload. Key Responsibilities: - Scheduling and calendar management: Keeping track of appointments and deadlines - Email and communication management: Handling correspondence in a professional manner - Research and data entry: Conducting basic research and inputting data as needed - Performing marketing tasks such as SEO work - Performing customer service Essential Skills: - Proficiency in Microsoft Office Suite: Basic level is sufficient, but familiarity with Word, Excel, and PowerPoint is necessary - Good communication skills: Able to handle correspondence professionally - Basic research skills: Capable of conducting simple research tasks Ideal Candidate: - Previous experience as a Personal Assist...

We are seeking a detail-oriented and reliable Data Entry Specialist to assist with organizing and entering new contacts into an Excel format. The ideal candidate will have excellent typing skills, a keen eye for detail, and the ability to deliver high-quality work within specified deadlines. Project Details: Scope of Work: Cognito will provide a list of companies. Using this list, the specialist will research and identify relevant Marketing and Media & Communications contacts in the US, UK, Netherlands, Germany, Hong Kong, Singapore and Australia, including their job titles (and email if available). Requirements: o Proven experience in data entry or similar roles. o Ability to conduct accurate online research to source contact details. o Proficiency in ...

Please Sign Up or Login to see details.

I need a consultant who can install and configure the Nets Checkout system on my Zen Cart 1.5.8 webshop. The integration should focus on basic payment processing. - Existing Account: I already have an active Nets account set up, so no assistance is needed with account creation. - Potential Ongoing Support: Depending on the complexity of the installation, I may require ongoing support for troubleshooting and updates. Ideal candidates for this project should have proven experience with Zen Cart and Nets Checkout integration. Please refer to the integration guide at the following link for specifics:

I need a Tally coder who can automate data entry from various sources into Tally in real-time. Key tasks include: - Automating data entry from Excel spreadsheets, a Database, and Manual entries into Tally. - Ensuring that the data is updated in real-time. Ideal skills and experience: - Proven experience with Tally and data automation. - Proficiency in working with Excel spreadsheets and databases. - Ability to manage and automate manual data entries. - Excellent attention to detail and commitment to accuracy.

I'm looking for an expert with advanced Excel skills to help me set up and manage an inventory system using Excel. Key Responsibilities: - Design an Excel-based inventory management system - Analyze customer data within this system - Integrate Excel with external databases Ideal Skills: - Proficient in Excel, particularly in its advanced functionalities - Experience in setting up inventory management systems - Strong data analysis skills - Familiarity with customer data analysis The inventory system will manage a small to medium-sized inventory.

I'm looking for a Power BI expert to analyze my sales data for me. The data is stored across Excel files and Cloud storage, so familiarity with these sources is crucial. Your tasks will include: - Importing and cleaning the data from Excel and Cloud storage - Conducting in-depth analysis to uncover sales trends and insights - Visualizing data in a clear and engaging way Skills and experience ideal for this job: - Expertise in Power BI - Strong data analysis skills - Experience working with sales data - Proficiency in using Excel and accessing Cloud storage - Ability to present data in a clear and engaging manner

I'm in need of an expert data scraper who can help me gather contact information from a Business Directory website. The focus will be on local businesses. I require comprehensive details including: - Email addresses - Phone numbers - Mailing addresses - Company names - General contact information Ideal Skills: - Proficient in data scraping - Familiar with Excel for data formatting Primary Deliverable: - A neatly organized Excel spreadsheet containing all the scraped data. Please note, the website is quite extensive and would require someone with expertise in data scraping.

I'm looking for a script that can find photos of generic product categories from e-commerce websites and add them to an Excel file. The images should be saved in JPEG format. Ideal Skills: - Proficient in scripting languages (Python, JavaScript, etc.) - Knowledge of web scraping techniques - Familiarity with Excel automation Please include your relevant experience in your bid.

I'm in the process of conducting medical research aimed at identifying risk factors, and I require assistance with my statistical analysis. Key Responsibilities: - Conduct statistical analysis on my data - Design Kaplan curves - Create descriptive tables Deadline: All tasks need to be completed ...Conduct statistical analysis on my data - Design Kaplan curves - Create descriptive tables Deadline: All tasks need to be completed within 2 days. Skills and Experience Required: - Proficiency with statistical analysis - Experience with Kaplan curve design - Ability to create descriptive tables - Medical research understanding is a plus Software: You can use any statistical software you're comfortable with. But at the end you provide me with a word and excel ...

I'm looking for a Windows batch file solution that can split a large text file, approximately 900K lines, into smaller text files of 10K lines each. Each of these smaller files should contain the headers from the source file. Additionally, the solution should automatically submit all the created files to a designated FTP location. Key requirements: - The solution can be created with Python, Node.JS, Powershell, or and exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built...

is seeking a Part-Time Affiliate Marketing Manager from India with proven experience in the online gaming industry. This role is commission-based, offering unlimited earning potential for high-performing individuals, as there is no salary cap. The ideal candidate should be motivated, results-driven, and comfortable working on a flexible schedule. We welcome applicants of all ages—if the candidate has the talent and ambition to excel, this opportunity is for them. Company website: Commission-Based Income Potential: Up to 20L in six months, 50L in one year, no earning cap Role: Drive traffic and player acquisition through affiliate partnerships in the online gaming industry. Manage affiliate relationships, optimize campaigns, and report on KPIs.

Please Sign Up or Login to see details.

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

Need an excel Expert to compare Multiple files

...EXPERIENCE WILL BE IGNORED. *MUST HAVE SQUARE PAGE SETUP EXPERIENCE (NOT SQUARESPACE) as per: MUST SHARE PORTFOLIO* I need a professional to set up my Square page (application is Square not Squarespace) and Facebook account for my modern and sleek jewellery company. I will need 25-30 products to showcase online, I require a product catalog with descriptions, online payment integration, and a customer review section on my Square page. Key Responsibilities: - Set up a Square page and Facebook account for my jewellery company. - Create a product catalog with descriptions for about 25-30 products. - Integrate online payment functionality. - Establish a customer review section. I also need guidance on the type of content to post on my Facebook ...