Excel Jobs

Ayuda para entender algunos temas especificos basicos de power bi y como generar graficos correctamente.

Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento

Descripción de la Solicitud: Estoy buscando un profesional experimentado en la creación de casos de negocio para empresas, que pueda desarrollar un caso de negocio modelo para la implementación de una solución de gestión de gastos en una organización. Detalles Clave: Propósito del Caso de Negocio: El objetivo principal es demostrar el retorno de inversión (ROI) y los ahorros significativos que la implementación de un software de gestión de gastos, específicamente Rindegastos, puede ofrecer a la empresa. Formato del Modelo: Excel Adaptable: El caso de negocio debe estar en un formato de hoja de cálculo Excel, permitiendo personalizar y modificar los parámetros de ahorros y otros datos específ...

Se trata de generar informes de ventas en Excel desde un archivo madre, también en Excel

EXCEL. Preferencia: Google Sheets. Tengo una sola hoja con varias columnas: Conjunto 1: columna 1 "Activo" tienen nombres que pueden repetirse. columna 2 "Categoria". tienen clasificaciones. Conjunto 2: columna 3 "Titulo" tiene nombres de Clasificaciones. columna 4 "Categoria de Activo 1" a columna 11 "Categoria de Activo 8". columna 12 a 31 "" y "" con pasos de suma 1 en 1, portan valores numericos del 0 a 5. columna 32 a 41 "D1" con paso de suma 1 en 1. Relaciones: + columna 1, 2 y 32 a 41 estan relacionadas. + columna 3, 4 a 11, 12 a 31 estan relacionadas. Se necesita crear una tabla dinamica donde aparesca cada dato de "Activo" donde se halla una coincidencia "Categoria" con "...

**Descripción de la Empresa:** Somos una agencia inmobiliaria en Madrid, España. Nuestra empresa se destaca por su enfoque tecnológico y servicios de calidad en el sector inmobiliario. **Posición Disponible: Asistente Virtual para Llamadas en Frío** **Ubicación:** Remoto **Responsabilidades:** - Realizar llamadas frías a propietarios para ofrecer servicios inmobiliarios y captar propiedades para la venta. - Utilizar guiones de conversación y contraargumentos para superar objeciones (lo proporcionamos nosotros). - Mantener una comunicación cordial y profesional en todo momento. - Persistir durante la llamada para cerrar visitas o concertar fechas para conocer la propiedad. - Actualizar una hoja de Excel con comentarios sobre ...

EXCEL COSTOS Y PRECIOS EN base al tipo de producto QUE SE ENUMERARARAN DEL 1 AL 10 (ELECTRONICA, SOFTWARE, ETC) , peso , volumen y costo pagamos unos ciertos impuestos de importacion SEGUN EL TIPO DE PRODUCTO NOSOTROS QUEREMOS QUE EN BASE A ESTOS DATOS QUE VAMOS A PREFIJAR PARA CADA CATEGORIA , YA NOS DE EL COSTO , CUANDO EGREGUEMOS PRODUCTOS NUEVOS COMPLENTANDO LA TABLA. CON LOS COSTOS DE ESTA TABLA , NECESITAMOS OTRA TABLA PARA CALCULAR MARGEN DE GANANCIA TOMANDO EL PRECIO DEL PRODUCTO Y NOSOTROS PODER SETEAR UN MARGEN MODIFICABLE PARA CADA ARTICULO DE NUESTRA TIENDA, ESTOS TIENE UNOS COSTOS FIJOS (FEE FIJO DE VENTA , GASTOS DE ENVIO , COMISIONES DE PLATAFORMA QUE VARIAN) ADEMAS NECESITAMOS QUE EN ESTA TABLA SE PUEDAN HACER ¨COMBOS¨ ES DECIR PONER VARIOS PRODUTOS Y QUE CALC...

Hola, estoy en la búsqueda de un book keeper con excelentes habilidades utilizando macros en excel esto es una de las habilidades importantes que me están pidiendo en el freelancer, indispensable también que tenga experiencia haciendo los libros para negocios en Canadá. Comunicación excelente en inglés. Me gustaría oír de ti. Saludos

Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos

Estoy construyendo informes en power BI, busco quien en sesiones en línea me guie en ir construyendo lo que entrego trabajo para desarrollar, debo hacerlo yo con la guía de un experto en power BI para entender bien las conexiones y poder editar el reporte. Debe tener paciencia y saber explicar.

Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten

Tengo u a hoja de sheets muy completa para trabajar en la que quiero que se ejecuten las fórmulas a las 00, mediante macros de un bot externo, y como consecuencia no se puedan ver las formulas por parte del cliente pero si pueda el trabajar con ella.

Estoy buscando un experto experimentado en Google Sheets para mejorar nuestro actual sistema de gestión de archivos. El objetivo principal es generar estadísticas tanto de productividad como de tiempo de procesamiento, así como establecer parámetros de control para monitorear el progreso. Responsabilidades clave: - Tu responsabilidad principal será optimizar nuestro sistema de archivos para generar estadísticas detalladas de productividad y tiempo de procesamiento. - Necesitarás crear informes condicionales basados en el estado actual de diferentes archivos. - Otra tarea clave será integrar datos de varias hojas en nuestro sistema de archivos principal. Habilidades y experiencia ideales: - Conocimiento avanzado de Google She...

Estoy buscando un experto en Excel para realizar cálculos de ventas y rendimiento. Es importante que el freelancer tenga un sólido conocimiento en: - Realización de cálculos en planillas de cálculo Excel. - Generación de informes de ventas y análisis de rendimiento. Las funciones específicas de Excel a utilizar serán determinadas de acuerdo a los trabajos a realizar. Las habilidades con diversas funciones de Excel (suma, promedio, porcentaje, ordenamiento, etc.) son idóneas para realizar los cálculos de manera eficiente. La precisión y la rapidez son características esenciales para este proyecto.

Estoy buscando un experto experimentado en Google Sheets para mejorar nuestro actual sistema de gestión de archivos. El objetivo principal es generar estadísticas tanto de productividad como de tiempo de procesamiento, así como establecer parámetros de control para monitorear el progreso. Responsabilidades clave: - Tu responsabilidad principal será optimizar nuestro sistema de archivos para generar estadísticas detalladas de productividad y tiempo de procesamiento. - Necesitarás crear informes condicionales basados en el estado actual de diferentes archivos. - Otra tarea clave será integrar datos de varias hojas en nuestro sistema de archivos principal. Habilidades y experiencia ideales: - Conocimiento avanzado de Google Sheets, inc...

Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online

Fast and easy job: I need script to convert my semi-structured csv file into an Excel format (.xlsx) and split the data into separate columns. Its easy job, please check the picture:

I require a freelancer who has exceptional skills in word processing and an eye for detail. Your task is to accurately transfer content from a digital PDF file into a Word file. Specific points for the job include: - The PDF contains both images and tables. These need to be included in the Word document. - Consistency is key - the Word document must mirror the formatting of the original PDF file as closely as possible. - This is not a basic copy-paste job. Your experience in this type of work, especially handling images and tables, is essential. Please apply if you are meticulous, reliable and have excellent skills in MS Word.

I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.

Looking for a motivated and enthusiastic Social Pages Management Intern to join our team. In this role, you will have the opportunity to gain hands-on experience in managing our social media presence across various platforms, including but not limited to Facebook, Instagram, Twitter, and LinkedIn. Responsibilities: Create and curate engaging content for our social media platforms. Schedule and publish posts using social media management tools. Monitor social media channels for comments, messages, and mentions, and respond promptly. Assist in developing and implementing social media strategies to increase brand awareness and engagement. Track and analyze social media performance metrics and prepare reports for management. Stay updated on industry trends and best practices in social media ...

I have a PDF file that needs to be converted to a Word file. The formatting and layout of the PDF file should be meticulously preserved in the Word document. Key requirements: - Convert PDF file to Word while maintaining layout - Text-based PDF, no image conversion needed - Project completion within a week Ideal skills and experience: - Proficient in PDF to Word conversion - Attention to detail in preserving formatting - Fast turnaround while maintaining quality - Previous experience with similar projects

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as well as the das...

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.

I'm on a mission to procure leads for potential house buyers in Dubai, and I need a skilled professional to assist me in this endeavor. Specifically, I am looking for a freelancer who can use online platforms to gather these leads. The leads you provide should include: - Basic contact information - Property preferences - Financial readiness The goal is to obtain between 100 to 300 leads. Your understanding of the real estate market in Dubai, as well as your ability to navigate and utilize online platforms for lead generation will be key to your success in this project. Experience in similar tasks would be a huge plus. Looking forward to reviewing your proposals.

TRANSLATING DOCUMENTS FROM ENGLISH TO ARABIC & ARABIC TO ENGLISH MICROSOFT OFFICE PACKAGE (WORD, EXCEL, POWER POINT & VISIO) PHOTOSHOP PRORAMME CORPORATE ORGAISATIONAL STURCUTRE, EVALUATION REPORTS & PROMOTION TYPING: 40 WORDS PER MINUTE IN BOTH ARABIC & ENGLISH

I am looking for a skilled Data Extraction/Lead Generation Specialist to assist us in compiling a list of project leads. A specific website containing the all the information we need will be provided. The task is about collecting the information and storing them into a structured Google Sheet or Excel spreadsheet of about 500-1000 entries. Please submit your proposal with your rate for the project.

I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.

I'm on the hunt for a proficient typist with an eye for detail. Your task will be to manually convert a PDF document into a Word file. The document is less than 10 pages long, but your accuracy in transcribing it is paramount. The requirements include: * Transcribing basic text from the PDF to Word. * Using a specific font style and size, to be exact, Times New Roman size 12. Ideal candidates will have a good record in data entry, Excel, PDF, and Word tasks. A fast typing speed, a sharp eye for detail, along with a strong grasp of English spelling and grammar are crucial for this job. Please bid if you're ready to start immediately, and able to deliver accurate work swiftly. Looking forward to your proposals.

Requiring a skilled and experienced Estimator to accurately estimate painting works including quantities, materials and labour Responsibilities: - Analyse project specifications, drawings & finishes schedules to determine painting requirements - Calculate quantities of ceilings, walls, doors, skirting etc (all painting components) - Prepare accurate and detailed estimates Qualifications: - Proven experience as a Painting Estimator or similar role - Strong knowledge of painting techniques, materials, and equipment - Excellent mathematical and analytical skills - Ability to communicate effectively - Proficiency in estimating software and tools - Provide BOQ in excel format? I require a detail-oriented individual with a passion for delivering high-quality painting estimates T...

I need a skilled freelancer who can efficiently convert a Google Doc into a Word document. -Significant to the project is maintaining all existing styles and formats on the Google Doc in the converted Word document. -A table of contents is required to be added to the Word file. -A sound understanding of Google Docs and Microsoft Word is ideal, with emphasis on expertise in style preservation during conversion.

For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, precision, and cle...

Job Description: 1. Identify 20 Filipino KOLs and collect their media and pricing information. 2. At least 6, but no more than 10, should be from the sports category. 3. Sort the KOLs into three categories (high, medium, low) based on YouTube followers. 4. Must have a Facebook Page or Instagram Page; having a TikTok account is a plus. 5. At least two of the KOLs must be males aged between 23 and 28. Information required when requesting quotes from KOLs: 1. Travel to Taipei for a 5-day, 4-night trip during August to September 2024. We are an agency and will provide flights and accommodation. 2. Posts on social media promoting Taipei tourism before and after the trip are required; inquire how many posts can be made. 3. At least one YouTube video needs to be posted after the event. 4. Pleas...

I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely beneficial...

I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and famil...

I'm in need of an expert researcher who can help with extracting text content from two specific websites to be used for data intelligence. Key Responsibilities: - Extracting text content from the given webites - Populating the relevant data in a spreadsheet, this will be provided for you. Ideal Skills and Experience: - Proficiency in web research techniques - Experience with data extraction and population - Ability to understand and navigate through websites efficiently - Understanding of data intelligence - Attention to detail to ensure accurate data entry The end goal is to have a well-populated spreadsheet with the extracted text content from the specified websites. A successful project completion will require close adherence to the instructions and a high level of accuracy in t...

Project Description: Customer Data Integration and Personalized Marketing System Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system aims to provide insights into custom...

I need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experience in medium-sized dat...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I'm looking for a detail-oriented freelancer who can assist me with a data entry task. The job entails transferring text data from typed documents into Word document format. Key requirements: - Data Entry: You should have a strong eye for detail and be proficient in accurately transcribing text. - Software: Familiarity with Word processing tools is essential. Ideal Candidate: - Strong attention to detail - Proficient in typing and data entry - Experience with Word processing tools The data will be provided in typed documents and needs to be accurately transferred into Word documents. A successful candidate will be able to work efficiently and accurately.

I'm seeking a property manager capable of handling a variety of tasks. Responsibilities primarily consist of a broad range of account management duties: * Gather data from designated sources (e.g., Google Drive) for entry into document management systems or partner websites. * Review documents for accuracy and completeness, attaching supporting files as necessary. * Conduct searches for additional information to complete incomplete documents. * Verify, correct, and manage data integrity, including deletion of unnecessary data and data consolidation. This position demands meticulous attention to detail, a college degree, proficiency in basic software tools (Microsoft Office - Word & Excel), and accessibility to email and devices (computer or phone). We require individuals who can...

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.

Por favor, regístrate o inicia sesión para ver los detalles.

Title: Expert Web Scraper Needed for Advanced Sales Lead Generation Description: We're in search of an expert web scraper proficient in niche database search techniques and advanced web scraping beyond Google and mainstream platforms. The ideal candidate will specialize in extracting company information from platforms like LinkedIn, focusing on contact details for sales lead generation. Key Details: Target Data: Company Information on LinkedIn Purpose: Sales Lead Generation Responsibilities: Utilize advanced web scraping tools and niche database search techniques to extract company information, emphasizing contact details. Ensure accuracy and reliability in gathering and organizing contact information from various sources. Collaborate on developing targeted outreach strategies ba...

I am seeking an individual proficient in converting PDF files into editable Word documents with a specific focus on maintaining table formats. Key Tasks: 1. Convert multiple PDF files to Word documents. 2. Accurately transfer tables from PDFs to Word, ensuring the original formatting is maintained. Ideal Candidate: - Experienced in PDF to Word conversion - Detail oriented with strong formatting skills - Previous work successfully converting tables from PDFs to Word.

I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and will connect and probably do it together Max payme...

I'm looking for a diligent freelancer to help me with a straightforward data entry task. The task involves: - Collecting text data from various websites - Organizing and inputting the data into Word documents. The ideal candidate should be: - Skilled at conducting online research - Proficient in Microsoft Word - Detail-oriented and able to maintain accuracy - Good at time management to ensure timely completion of the task. Your role will be pivotal in creating a structured, comprehensive database from the web content I provide.

I would like to receive a price quote for making phone calls according to the following details: Territory: Netherlands Number of records: 58 The purpose of the conversation: to find out if the company still exists and why they stopped buying Background: We are a company that sells aluminum frames for the sign industry to sign manufacturers in the world, including Netherlands. These records are of companies that have purchased from us in the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching ...

I'm in need of a skilled freelancer who can assist me with two core tasks - manual data entry and uploading of images or videos on a portal. Key Responsibilities: - Manual Data Entry: The main task involves entering data into a system or platform. This will require a keen eye for detail and accuracy to ensure that the information is correctly captured. - Content Upload: You will need to source images or videos from online video platforms and upload them onto the portal. This requires a good understanding of image and video formats and how to properly upload them. Ideal Skills and Experience: - Proficient in data entry with a high level of attention to detail. - Experience in handling and uploading images and videos would be a plus. - Familiarity with online video platforms is prefe...

I'm looking for help in combining multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process and e...

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your main goal would b...