Excel Jobs

Busco un profesional en Power BI para desarrollar un reporte visual e interactivo basado en un archivo Excel con varias hojas (denominadas "Lam") que ya contienen datos calculados. Requerimientos: Conectar y cargar el archivo Excel. Crear gráficos interactivos (barras, líneas, tablas) para mostrar acreditaciones, canjes, saldos y porcentajes de redención. Incluir filtros y segmentaciones para explorar datos por hoja, fechas o miembros. Diseñar un tablero visualmente atractivo y fácil de usar. Entregar el archivo Power BI (.pbix) listo para usar. Adjunto el archivo en excel y un ejemplo hecho en power bi

Requiero desarrollar e instalar un sistema de web scraping que revise unas 2000 páginas web que publican convocatorias y que consolide en un sheets los datos de las últimas convocatorias que se publiquen. Se debe configurar también alertas y conexión con un sistema de automatización como para hacer otras integraciones en el futuro. Deseo implementarlo inicialmente en un pc local con windows o en un servidor económico en la nube.

Pago 30 dolares 6 páginas Necesito desarrollar una plantilla de google locker studio para un report financiero. La idea es que los datos se puedan modificar fácilmente (enlazado con una hoja de google sheets). Los apartados son: HOJA 1: - Ingresos netos: que se puedan ver mensuales, trimestrales y anuales. - Costes directos - margen bruto hoja 2: - costes generales - ebitda - resultado neto - flujo de caja hoja 3: kpis - % margen neto mensual - otros kpis hoja 4: -comparativa mes a mes, trimestre a trimestre o anual: evolución de ingresos, costes y márgenes. Variaciones porcentuales. -Presupuesto vs. Real: Análisis de desviaciones. Que se puedan poner comentarios sobre causas y posibles soluciones Hoja 5: - Previsiones financieras Proyecciones de ingresos...

Pago 30 dolares 6 páginas Necesito desarrollar una plantilla de google locker studio para un report financiero. La idea es que los datos se puedan modificar fácilmente (enlazado con una hoja de google sheets). Los apartados son: HOJA 1: - Ingresos netos: que se puedan ver mensuales, trimestrales y anuales. - Costes directos - margen bruto hoja 2: - costes generales - ebitda - resultado neto - flujo de caja hoja 3: kpis - % margen neto mensual - otros kpis hoja 4: -comparativa mes a mes, trimestre a trimestre o anual: evolución de ingresos, costes y márgenes. Variaciones porcentuales. -Presupuesto vs. Real: Análisis de desviaciones. Que se puedan poner comentarios sobre causas y posibles soluciones Hoja 5: - Previsiones financieras Proyecciones de ingresos...

Agencia de viajes on line de Valencia, necesita apoyo administrativo/contable Utilizamos soporte ZOHO BOOKS Tiempo estimado: 2h/semana Finales de trimestre: 3-4h/semana Tareas: introducción de facturas, organización cuentas, elaborar informes... Imprescindible residencia en España con conocimiento del PGC ,normas contables y fiscales. Formación previa obligatoria no remunerada, 3h aproximadamente. Spanish speaking only

Hola, ando buscando un persona que me ayude a buscar oportunidades de productos para vender en Amazon y Mercado Libre así como buscar distribuidores o fabricantes en primer instancia en forma de arbitraje. Logística de FBA, solicitudes de marca, inventario, hablar con distribuidores y análisis de productos Proyectar temporadas y posibles formas de aprovechamiento.

Presupuesto 15 dólares para unas horas la entrega Descripción del Proyecto: Ajustes en Dashboard de Power BI Estoy buscando un freelancer experto en Power BI para realizar ajustes específicos en un dashboard ya desarrollado. El trabajo consiste en: 1. Corrección de dos gráficos principales: Costos real vs presupuesto. Gastos por rubro real vs presupuesto. 2. Aplicación de filtros: En el gráfico de costos, debe filtrarse correctamente por categorías como mantención y administración. 3. Revisión general: Verificar que el dashboard cumpla con las especificaciones detalladas en el archivo "Instrucciones Evaluación - Power BI " (se proporcionará junto con los demás archivos).

Presupuesto 12 dólares para unas horas la entrega Descripción del Proyecto: Ajustes en Dashboard de Power BI Estoy buscando un freelancer experto en Power BI para realizar ajustes específicos en un dashboard ya desarrollado. El trabajo consiste en: 1. Corrección de dos gráficos principales: Costos real vs presupuesto. Gastos por rubro real vs presupuesto. 2. Aplicación de filtros: En el gráfico de costos, debe filtrarse correctamente por categorías como mantención y administración. 3. Revisión general: Verificar que el dashboard cumpla con las especificaciones detalladas en el archivo "Instrucciones Evaluación - Power BI " (se proporcionará junto con los demás archivos).

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizació...

I'm in need of a passionate and creative primary school teacher, preferably a fresh graduate. This role involves teaching Mathematics and English. The ideal candidate should be adept at using hands-on activities to engage students and make learning fun. Experience with Special Educational Needs (SEN) is not a requirement but would be an advantage. Key Skills: - Strong understanding of Mathematics and English - Ability to implement hands-on teaching activities - Familiarity or experience with SEN If you're enthusiastic about teaching and looking for an opportunity to make a difference in students' lives, I look forward to hearing from you.

I'm looking for a data analyst with strong skills in MS Excel, Java, and HTML. The primary focus of this project is to analyze and report on sales data. Experience in data visualization and reporting is crucial, as the results will need to be presented in a clear and coherent manner.

I'm looking for an expert in PowerBI to create interactive dashboards that primarily display our sales data. These dashboards should include customizable filters and real-time updates to ensure they can be used for live monitoring of sales performance. Ideal Skills: - Proficiency in PowerBI - Experience with DAX functions and data modelling - Skills in creating interactive dashboards - Understanding of sales data Please note, the quality of the data is paramount, so prior experience with data cleaning, profiling, and standardization will be a plus. The ability to manage data integration and enrichment tasks will also be beneficial.

I'm seeking assistance with a PDF text entry task. The primary objective is to enter mixed data (comprising both numbers and text) into a database. Key Requirements: - Data entry from a PDF into a database - Handling of mixed data (numbers and text) The ideal freelancer for this job should have: - Proven experience in data entry - Familiarity with PDF manipulation - Attention to detail to ensure accurate data entry. There's no specific format or template required for this task, so creativity and organizational skills will be beneficial.

I need assistance converting some forms from a PDF into a fillable, interactive PDF. Requirements: - Convert forms from existing PDF into new interactive PDF - Basic text formatting only Ideal candidate should have experience with: - PDF editing software - Creating interactive elements in PDFs

I'm seeking assistance with a PDF text entry task, which is crucial for a data analysis project. The PDF in question contains mixed data - both numerical and textual. Your role will involve extracting this data from the PDF. Ideal candidate should be detail-oriented, proficient in data entry and have experience with handling mixed data. Understanding of statistical analysis would be a plus as it will help you comprehend the importance of the task.

I'm looking for an experienced developer to help refine our workflow application. The project involves incorporating three distinct user roles: Administrator, Manager, and Employee. Key Responsibilities: - Implement role-specific functionalities in the application. - Establish a set of predefined statuses (Pending, In-progress, Completed) across the workflow. Although we have a set of statuses ready to be applied, the ideal candidate should have experience with permission management, role-based dashboards, and custom notifications, as these features may be needed in the future. Skills and Experience Required: - Prior experience in workflow application development. - Strong understanding of role-specific application requirements. - Capability to implement predefined status sets in...

I'm looking for a skilled Excel expert to create a task management system tailored for team collaboration. The system needs to support a small team of 1-5 members. Key Features: - Task Assignment: The system should facilitate the distribution of tasks among team members. - Progress Tracking: There should be a way to monitor the progress of tasks and projects. - Shared Calendars: A component for a shared calendar is essential, allowing team members to stay informed about deadlines and important dates. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating complex spreadsheets. - Experience in designing task management systems. - Understanding of team collaboration needs. other things required: calendar view deadlines short term , long term plans deadline re...

I'm in need of a comprehensive Excel file detailing the top 50 universities in the USA offering PhD programs in Quantum Computing with a focus on AI. The Excel should contain the following: - University name - Details of Professors 1 to 5 including: - Their department and position - LinkedIn profiles - Emails - History of past collaborations or projects in AI - Application deadlines for both Fall and Spring batches - Program specifics I would like this data to be organized in a single sheet with categorized columns for ease of use. Ideal skills for this project include experience in data collection, proficiency in Excel, and knowledge of the field of quantum computing and AI. Previous experience compiling similar data sets will be an added advantage.

Must be able to monitor and report stock market price changes, during market hours. 8:30am - 3pm CST Mon-Fri

I'm running an existing company and need some help with data entry. Specifically, I require a highly competent individual with exceptional data entry skills to enter purely textual data from our company files into various websites. Ideal Skills and Experience: - Data entry with high accuracy - Previous experience working with company data - Proficiency in basic computer skills and website navigation - Good time management skills to meet tight deadlines Please note, the entered data needs to be delivered in a format that can be easily provided to the websites. Accuracy is key in this role! If you think this is the right job for you, please don't hesitate to place a bid. Role Overview The Backlink Outreach Specialist will identify backlink opportunities, conduct outreach to p...

Excel Data Loading : Python coding ************ This project comes with Non-Disclosure Agreement ( NDA ) ************* Expecting to automate Data Loading into Excel Step 1 : There's a VA Excel Plugin which we have subscribed provides the data from their VA website (VA Plugin ) & this data dump gets populated into Excel 2 Data sheets which needs to be downloaded are Standardized Data (SD) & Company Data (CD) Automatically need to Login to Visible Alpha plugin and download the data ( Can skip this part, not needed ) After we get this SD & CD data, with some formula Surprise analysis & Source count both populated in Surprise analysis Sheet Now this is Base or Primary file which consists of SD, CD, Surprise analysis data Step 2 : Only the required Line item...

I need a freelancer to gather the contact details for businesses across Canada by scraping a number of websites. This will be a multi-stage project. You will find businesses’ contact details from five types of websites, with each type being a stage in this project: Stage #1: Municipality websites Stage #2: Chamber of Commerce websites Stage #3: Business Improvement Area (BIA) websites Stage #4: Niche business directories Stage #5: Business associations ** NOTE: This first project only concerns the first type of website: Municipality websites. Once this stage is completed, I will move on to the second stage (Chamber of Commerce websites) ** Here is exactly what you will do in this first stage, step-by-step: Stage #1: Municipality websites: a) You will scrape the website for ...

I'm seeking a meticulous professional for a PDF content entry service. The task involves inputting text, images, and forms into a PDF, adhering to strict formatting guidelines. Key Responsibilities: - Enter various types of content into the PDF - Follow precise formatting guidelines including specific fonts and sizes, exact layout and alignment, and designated color schemes and themes Ideal Skills: - Attention to detail - Proficiency in PDF editing software - Experience in content entry - Ability to follow strict guidelines Please only apply if you can adhere to the strict formatting requirements and have relevant experience.

Project goal To develop a user-friendly financial planning tool with detailed income, expense, and savings features tailored for a couple. Scope of work - Input salary details and additional income for both individuals. - Calculate total and individual expenses, providing a monthly overview. - Enable setting of savings goals with monthly saving requirements for individual and combined targets. Cost Distribution: • Based on our incomes, the tool should calculate how much each of us needs to contribute to shared fixed costs, adjusted proportionally to our earnings. For example, if my wife earns €1,000 and I earn €1,200, and the total amount to be deposited into the joint account is €1,500, I should contribute proportionally more because I earn more. I would nee...

I'm seeking a meticulous professional for a PDF content entry service. The task involves inputting text, images, and forms into a PDF, adhering to strict formatting guidelines. Key Responsibilities: - Enter various types of content into the PDF - Follow precise formatting guidelines including specific fonts and sizes, exact layout and alignment, and designated color schemes and themes Ideal Skills: - Attention to detail - Proficiency in PDF editing software - Experience in content entry - Ability to follow strict guidelines Please only apply if you can adhere to the strict formatting requirements and have relevant experience.

I'm seeking assistance to register with various local interior design companies. Your role will primarily involve: - Filling out application forms: You'll need to accurately and efficiently complete application forms with both my personal and professional details. - Managing communication with companies: You'll handle all correspondence with these companies on my behalf, ensuring a professional and prompt response to all communications. Ideal skills for this project would include excellent communication skills, attention to detail, and proficiency in filling out forms accurately and quickly. Prior experience in a similar role would be advantageous.

I'm seeking a proficient data scraper to gather unique and diversified SaaS product pricing models from various websites. The goal is to collect at least 30 distinct and deeply differentiated pricing models, not merely similar ones in terms of pricing, to stand out from the crowd. Key Responsibilities: - Scrape data from a variety of SaaS websites, focusing on pricing tiers and features of different SaaS products. - Upload the collected data to a no-code database, such as Notion or Airtable, following a specified format. Data Upload Example: Your uploads will resemble this format - [Notion Sample]() Ideal Skills and Experience: - Proven experience in web scraping, particularly in gathering pricing models from SaaS websites. - Proficiency in using no-code databases like Notion or Ai...

I am looking for a qualified AI trainer to provide onsite training for a small group of corporate employees, focusing primarily on the introduction to popular AI tools for beginners. The training should also cover common MS Office extensions that can enhance efficiency. Key aspects of the project include: - Providing training for a small group (1-10 people) - A primary focus on AI tools, with some content on MS Office - Hands-on demonstrations, with opportunities for implementation during the session Ideal candidates will have: - Expertise and experience with popular AI tools and MS Office extensions - Prior experience training corporate employees - Excellent communication and demonstration skills. I am looking for a trainer who can make the session engaging and informative, allowing ...

I'm seeking assistance with managing and organizing data in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, particularly in handling data entry and organization tasks - Attention to detail to ensure accuracy in data handling - Prior experience in administrative tasks or data entry roles would be an advantage

I'm looking for a freelancer who can accurately transcribe text from a PDF document into a Word document. The successful candidate will need to: - Carefully enter all text from the PDF into the Word document - Follow detailed formatting instructions to ensure the final document matches the original PDF - Maintain high levels of accuracy and attention to detail throughout the task Skills and experience: - Proficiency in Microsoft Word - Prior experience in data entry and transcription - Excellent attention to detail - Ability to follow detailed instructions accurately - Strong understanding of different text formats and styles

I'm looking for a skilled programmer to create a Windows-based solution for automating the process of creating company ID PSD files. The program should be compatible with Adobe Photoshop CC 2019 - 2021. Key Requirements: - The program should pull information from provided Excel sheets and generate barcodes in the Code 128 and code 39 format. - The PSD files need to be automatically saved in PNG format. - It should work seamlessly with Windows and the specified version of Photoshop. Ideal Skills: - Proficient in programming and automation - Experience with Adobe Photoshop scripting - Knowledge of barcode generation - Excel data manipulation skills

I'm seeking a professional with keen attention to detail for a PDF content entry service. The task involves transcribing data from digital PDFs into a new document while retaining the original formatting. Ideal skills for this job include: - Proficient in data entry - Highly detail-oriented - Able to follow formatting guidelines accurately Experience with similar projects is preferred. Please note, the content to be entered may involve different types, including text, images, and tables.

I'm seeking a meticulous data entry professional to transcribe my handwritten notes into a PDF. This task involves carefully preserving and accurately representing the special formatting present in the notes. Ideal Skills: - Exceptional attention to detail - Proficient in data entry - Good understanding of PDF software - Able to recognize and replicate special formatting Experience: - Prior experience with transcription from handwritten notes - Familiarity with data entry from diverse formats

I'm seeking a proficient data scraper to gather unique and diversified SaaS product pricing models from various websites. The goal is to collect at least 30 distinct and deeply differentiated pricing models, not merely similar ones in terms of pricing, to stand out from the crowd. Key Responsibilities: - Scrape data from a variety of SaaS websites, focusing on pricing tiers and features of different SaaS products. - Upload the collected data to a no-code database, such as Notion or Airtable, following a specified format. Data Upload Example: Your uploads will resemble this format - [Notion Sample]() Ideal Skills and Experience: - Proven experience in web scraping, particularly in gathering pricing models from SaaS websites. - Proficiency in using no-code databases like Notion or Ai...

I need a freelancer to gather the contact details for businesses across Canada by scraping a number of websites. This will be a multi-stage project. You will find businesses’ contact details from five types of websites, with each type being a stage in this project: Stage #1: Municipality websites Stage #2: Chamber of Commerce websites Stage #3: Business Improvement Area (BIA) websites Stage #4: Niche business directories Stage #5: Business associations ** NOTE: This first project only concerns the first type of website: Municipality websites. Once this stage is completed, I will move on to the second stage (Chamber of Commerce websites) ** Here is exactly what you will do in this first stage, step-by-step: Stage #1: Municipality websites: a) You will scrape the website for ...

I'm in need of a professional who can assist with entering images and forms into a PDF. All content will be provided by me, so your role will primarily involve accurate placement and formatting of this content. Ideal Skills and Experience: - Proficiency with PDF editing software - Attention to detail for accurate content placement - Experience with data entry and content management - Ability to adhere to standard formatting requirements.

I require assistance with manual data entry. The task involves transcribing text from printed documents into a digital format. Ideal Skills: - Exceptional attention to detail - Proficient in English - Fast and accurate typing skills - Previous experience in data entry from printed documents - Familiarity with basic computer applications (Word, Excel, etc) Please note that the data to be entered is purely text-based, and it is essential that the work is carried out with a high level of accuracy.

First job is 450 entries You search with user name pick 3 dropdowns and pick profile after you cooy the profile like and past in sheet. Do this 450 times.

I'm seeking a data specialist to assist with my project of extracting in-play odds from Betfair. Key Responsibilities: - Extract data every minute from Betfair. - Focus on in-play market prices for cricket. Ideal Skills and Experience: - Proficient with data extraction tools and techniques. - Understanding of betting markets and odds. - Experience with Betfair is a plus. - Knowledge of cricket is an advantage. I am looking for someone reliable who can consistently deliver data at a minute's interval. This project is crucial for my analysis and your timely support will be greatly appreciated.

We are seeking a highly organized and detail-oriented Administrative Assistant to support our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with...

We are seeking a highly organized and detail-oriented Administrative Assistant to support our day-to-day operations. This is a long-term, part-time position with potential for growth. The ideal candidate will have experience handling a variety of administrative and office support tasks, from managing data and emails to providing excellent customer service. Key Responsibilities: Data Management: Organize, manage, and update records and databases (experience with tools like Airtable, Excel, or similar is preferred). Email Handling: Monitor and manage incoming emails, respond to general inquiries, and escalate urgent matters when necessary. Customer Service: Provide professional and timely customer service via email and occasionally over the phone. General Administrative Duties: Assist with...

I am looking for an experienced freelancer to scrape auto parts store data across 7,500 towns in the USA . The freelancer will be responsible for scraping the following information from Google search results: - Store name and address - Contact information - Website (if any) - Contact person's name (if available) The towns / cities names will be provided in an Excel sheet, and the freelancer will need to: Search for auto parts stores in each town via Google. Scrape the relevant data (store name, contact number, address, website). Compile and organize the scraped data into an Excel file. Requirements: Experience with web scraping and the use of tools like Selenium, BeautifulSoup, or Scrapy. Experience using Google Custom Search API or SerpApi to extract structured results from Goo...

I'm in need of a Google Sheets expert to help me troubleshoot and enhance my current sheet. Key Tasks: - Fixing errors in existing formulas - Creating new, complex formulas The primary focus areas for these formulas are: - Data analysis and reporting - Project management Ideal candidates should be well-versed with Google Sheets, have a strong analytical background, and be able to create intricate formulas.

I'm in need of a web scraping expert who can extract specific data from online retailers of windscreen wiper blades. Data to be Scraped: - Make and model of the vehicle - Year of the vehicle - Size of the wiper blade - Whether it's for the rear wiper Ideally, you should have: - Proficiency in web scraping tools and programming languages such as Python - Experience with data analysis - Ability to present the data in a clear and organized manner Please get in touch if you have the required skills and experience. Thank you!

I'm looking for a competent data entry specialist to assist me with entering mixed data (text and numerical) from various online sources. Key Tasks: - Extracting and entering numerical data from online databases - Collecting and inputting text data sourced from online tools Ideal Skills: - Proficiency in data entry - Familiarity with online databases and tools - Attention to detail - Ability to work independently and meet deadlines

I'm in need of the volume data for Nifty 50 Futures on a 5 minute interval from 2015 to 2019. The data should be delivered in CSV format, as it will be used for a machine learning model. Ideal Skills: - Data extraction - Understanding of financial data - Proficiency in CSV formatting Experience: - Prior experience with stock market data - Machine learning model input preparation

I need assistance with extracting Examsoft questions from a downloaded exam on my Mac. The questions need to be compiled into a PDF document, maintaining the original formatting. Requirements: - Extract multiple choice and essay questions from the Examsoft file - Preserve the original formatting of the questions in the PDF Ideal skills and experience: - Familiarity with Examsoft - Proficiency in Mac systems - Experience with PDF document creation - Attention to detail for maintaining formatting

I need a professional who can create an Excel report in a dashboard format tracking the performance of our management. The report should encompass: - KPIs (Key Performance Indicators) - Financial performance - Employee productivity Ideal candidates for this project should be proficient in Excel, with experience in dashboard creation and performance reporting. Strong analytical skills and understanding of management metrics will be a plus.

Excel sheet financial expert to monitor my income, expenses and investments with proper graphical visualization.

I'm in need of a professional data scraper to assist with uploading over 700 SKUs from a wholesale supplier site to my own wordpress platform. The task involves collecting various product details including names, information, SKUs, types, and photos from the source website. Key Responsibilities: - Scrape product data from a publicly accessible wholesale supplier site - Collect product names, SKUs, types, information and photos - Directly upload the gathered data onto my website Ideal Skills and Experience: - Proficient in data scraping and web crawling - Experience with eCommerce platforms and product data integration - Attention to detail to ensure all data is accurately copied and uploaded - Familiar with handling large volume data