I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks: - Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive. - In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard. - Open another SharePoint Excel file (Excel3) from online and paste the clipboard information. This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.
I'm seeking a skilled data entry professional for categorizing product data. This involves managing product descriptions, prices, and inventory. Ideal Skills: - Native Spanish speaker - Proficient in data categorization - Experience with product data - Highly attentive to detail - Excel and spreadsheet management skills
As discussed will proceed for those 5 images
I'm looking for someone to assist me with data entry from PDF files into an Excel spreadsheet. The data is a mixture of both text and numbers, and primarily, the converted Excel file will be used for record keeping. Ideal Skills and Experience: - Proficient in Excel and familiar with data entry processes - Attention to detail to ensure accuracy in data transfer - Ability to handle mixed data (text and numbers) - Prior experience with data entry from PDF files is a plus Please note that specific formatting or organization in the Excel file may be required, but this will be clarified during the project.
I'm looking for an experienced Unity developer to create a mini games / horror game designed for VR. Key components of the game include an interactive game should have a design aesthetic reminiscent of 'Scary Baboon’ or ‘Monkiverse’. I would also like for you to add a player model like scary should be a room for the lobby mini games , shop and horror. The games name is called Munka Bunka so it will be underground. Key Requirements: - Extensive experience with Unity and VR development - Proven track record in creating engaging mini-games - Strong understanding of horror game mechanics - Ability to design an interactive shop within the game - Extensive work in blender Please provide examples of your previous work, particularly any VR or ...
I'm seeking a data entry operator with hands-on experience in managing inventory on both eBay and Amazon. Proficiency in Excel or Google Sheets is a must. Key Responsibilities: - Oversee and manage inventory across both eBay and Amazon - Utilize Excel or Google Sheets for inventory tracking, updates and reports Ideal Candidate: - Proven experience with eBay and Amazon inventory management - Exceptional skills in Excel or Google Sheets - Detail-oriented and able to work independently - Knowledge of eBay and Amazon product upload processes would be a plus
I'm in need of a proficient SQL expert to help me with some data manipulation tasks using SQL queries. The main focus will be on performing calculations with columns and modifying the structure of my tables. Key Requirements: - Experience with SQL, particularly in manipulating data - Ability to perform calculations with columns - Skills in adding or removing columns from tables Please note, this project does not involve inserting, updating or deleting records, nor does it require changing data types of existing columns or reorganizing table indexes.
I would like a formula inserted in Column J to rank the data in Column F "Rating" and start a new ranking each time the time changes in Column B. I would like 3 sheets ranked I used a formula that worked for 100 rows. After row 101, it gives a div error, and the rest. I have 7k rows in one sheet. check the attached worksheet. Budget: $5 (fixed price) Post service support is needed.
...tasks. Conduct online research or any other ad-hoc tasks as required. Requirements: Proven experience in CV distribution or as a Virtual Assistant/Personal Assistant. Strong organizational skills and attention to detail. Excellent written and verbal communication skills in English. Familiarity with job application platforms (e.g., LinkedIn, Indeed) and basic office tools (e.g., Google Workspace, Excel). Ability to work independently and meet deadlines....
For 3 sheets, create a formula that ranks values as mentioned in chat. Must be done in 30 usd budget.
I'm seeking a Virtual Assistant primarily focused on data entry tasks, specifically inputting job information, tracking jobs, lead volumes, and prices of quotes sent into spreadsheets. Ideal Skills Include: - Proficiency in spreadsheet software (Excel, Google Sheets) - Detail-oriented and able to maintain high accuracy - Good understanding of data confidentiality and integrity - Experience in data entry and virtual assistance - List all jobs on job sheet - List Email Jobs - Clean Email Folder - How Many Leads we had per Day - All Leads Quoted - All Quotes Sent - Notify Google Chats
I need a freelancer with exceptional data entry skills to assist me in typing data into Excel. I have a general idea of how I want the data formatted, but I will need your expertise and assistance to create a comprehensive and effective template. Ideal Skills: - Proficient in Excel - Strong attention to detail - Excellent typing skills - Good understanding of data entry and formatting Experience: - Previous work with data entry and Excel is crucial. - Experience in creating Excel templates will be highly beneficial. I am looking for someone who is reliable, can work independently and can deliver quality work on time. If you believe you fit this description, I would be happy to discuss this project further with you. Thank you.
...competitor sell prices to a database for future analysis. Competitor pricing will come from two main sources: Shortlist of specific competitor websites (sites we will provide). Top results from Google Search for the exact product name or SKU. Product Input: We give the Input of all product data (e.g., product name, SKU, and our sell price). Support for bulk upload of product data in formats like CSV/Excel. Competitor Price Collection: Scrape pricing information for each product: From a shortlist of predefined competitor websites. From Google search results that sell the same product. Identify products using keywords, SKUs, or model numbers. Data to collect: Competitor name/URL Competitor sell price Date and time of data collection Database Storage: Save all collected data...
I need assistance comparing 3-4 structured Excel files. This task involves verifying data matches, specifically contract titles and numbers. We are talking about 3-4 columns only in total. Key requirements: - Expertise in data match verification - Proficiency in working with structured Excel files with headers - Ability to provide accurate analysis within an hour If you can commit to this task and deliver accurate results promptly, please place your bid. Please place your bid if you can dedicate the 1 hour of your time now
I've been having issues with the Suremembers plugin. Currently, the downloads for an access group are showing, but they are not 'live' and can't be downloaded. The content in question consists of documents, excel files, and pdfs all packed in Zip files. Despite the downloads being visible, there are no error messages when attempting to download these files. I suspect that the problem might stem from recent changes made to the plugin's settings. Ideal Skills: - WordPress plugin troubleshooting - Specifically with Suremembers plugin - Configuration and settings adjustment I'm looking for someone who can help me fix this issue promptly.
I'm looking for a skilled Excel expert who can create a comprehensive spreadsheet for tracking project deadlines. This spreadsheet should be able to monitor: - Start date and end date of each task - Days elapsed since the task started - Days remaining until the task is due In addition to these tracking capabilities, I also need the spreadsheet to have pop-up reminders for upcoming due dates. Ideal candidates for this project should have: - Strong proficiency in Excel - Experience with creating complex spreadsheets - Good understanding of project management principles.
...the page in the json config file. And the usee should be allowed to add, edit, delete a custom icon (path), custom Headline and Subline which should be stored in the json file as well. 4. The config json must be exportable or to be "saved as" so the user can have multiple config files. Fictional example for the data and the use: time series of hourly temperatures for one day in many cities. The excel contains the city name in the top row and in the rows below the temperature values. The json config file would then assign a a city to a country name, the user can edit that: e.g New York, = USA, Berlin=Germany. While cities could be in multiple pages and pages contain multiple cities. The user can add edit delete page names e.g. pages "USA", "Canada"...
I'm looking for an Excel expert who can help me consolidate data from multiple sheets. The primary goal of this project is data consolidation, specifically focusing on pricing and labor costs. Want to pull information from different tabs on same workbook to use as base pricing model. This is URGENT to be done by noon Thursday CST. Key Requirements: - extremely Proficient in Excel formulas - Experienced in linking data across multiple sheets - Ability to organize data effectively by information from different sheets into main. I can share document to look at if you feel confident.
I am looking for a freelancer who can create an Excel pivot table and generate a statistics report from a CSV file spanning the past 10 years. The specific statistics that need to be included in the report user profile analysis Chart Type: I would like the pivot table to be presented in a bar chart format and line chart to show trending. Time Period: The data should be broken down annually. Ideal Skills and Experience: - Proficiency in Excel and pivot table creation - Strong understanding of statistics and data analysis - Experience in generating reports from CSV files - Knowledge of creating bar charts in Excel - Attention to detail and ability to accurately present data in a clear and concise manner. example data: firstName LastName Princess Maxima Center for pe...
I'm facing issues with circular references in my annual budget Excel file. These errors are found on the Revenue sheet, the Summary sheet, and the Annual Budget sheet. I need a professional who can resolve these circular references by adeptly using iterative calculation.
...of database list. scheduling options for reminders. Option for allowing unsubscrible Allow mutiple user to do blasting Admin allow which user to to which grouping database 3. Backend Dashboard for Admin (optional) • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and messager) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting Allow grouping of database list. scheduling options for reminders. Option for allowing unsubscrible Allow mutiple user to do blasting Admin allow which user to to which group...
I have an Excel spreadsheet that contains data on my portfolio's performance. I need a freelancer to help create a chart that visualizes this data in an effective way. Key Responsibilities: - Create a visualized chart that displays the yearly performance of my portfolio mgmt for resale and rent based on purchase price. - Incorporate relevant trendlines into the chart to help illustrate performance patterns. Ideal Skills: - Proficient in Excel with a strong understanding of creating and manipulating charts. - Ability to analyze data and identify key trends for visualization. - Attention to detail to ensure the chart is accurate and easy to understand. With the data already in the columns, this task should be straightforward for someone with the right expertise.
I'm facing a challenge with my mail merge process from MS Word to Outlook. I can successfully send emails to single email addresses, but I encounter an error when attempting to send to cells containing multiple email addresses, separated by semicolons. ...extraneous characters within the cells. Unfortunately, these attempts have not resolved the issue. What I need is for assistance in being able to send emails to multiple addresses contained within a single cell, as a single email. PLEASE BE SURE TO SEND A CUSTOMIZED RESPONSE AND NOT AN AUTOMATED RESPONSE! COOKIE CUTTER RESPONSES WILL BE IGNORED. Skills Needed: - Proficiency in Microsoft Word, Excel, Access, and Outlook - Experience with Mail Merge - Strong troubleshooting skills - Good understanding of data validation and em...
I need a freelancer to categorize approximately 2500 items into one main category and at least 1 or 2 subcategories. You'll also assign an expense center based on written instructions I will provide. The items list will be supplied in a spreadsheet. Ideal Skills & Experience: - Attention to detail - Experience in data categorization - Proficiency in spreadsheet software (Excel, Google Sheets) - Ability to follow written instructions accurately
Job Title: Online Tutor for IT & Non-IT Courses Job Type: Part-Time/Contract (Remote) Courses: IT : C, C++, Python, Java, Android development, Graphic Designer, UI/UX developer, Angular Js, Node Js. Non-IT: Digital Marketing, Cloud Computing, Cybersecurity, Advanced Excel, MATLAB, Tally, CAD (CATIA, AutoCAD), HR Operations. Responsibilities: - Deliver engaging online classes. - Customize teaching materials. - Guide students on real-world projects. - Monitor progress and provide feedback. Requirements: - 3+ years of experience in the domain. - Strong communication and teaching skills. - Reliable internet and tools for online classes. Documentation Needed: Updated resume/CV. A sample recorded session (Mandatory). List of topics/courses you can teach. P...
I will Make High DA, Spam Free Dofollow Backlinks for Your Business, My backlinks will be Google-friendly and spam-free, which will help to better improve yo...Directory Submission → Profile Link Creation → Blog Promotion → PDF File Submission → Local Citation Backlinks → Business Listing Submission → Press Release Submission Service Features: 100% indexing in Google 100% Boost up In Google Ranking Up To DA 50 to 90+ Back-links Low Spam Score 100% Manual Work No Bots or Software Contextual & Mixed Back-Links Increase Domain Authority Detailed Excel Delivery Report Please Open chat Box and send message So I can Share backlinks Sample. You can optimized Our backlinks Quality via check our Sample MY First priority “Client Satisfaction...
I need a proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - Add new calculations and formulas - Set up automated reports - Fix incorrect calculations - Troubleshoot and rectify data updating issues Ideal skills and experience: - Strong proficiency in Excel and VBA - Experience in creating and modifying Excel macros - Ability to set up automated reports - Aptitude for accurate calculations - Problem-solving skills for troubleshooting data issues
Hello Hafizshouaibali. I'm interested in your excel template. Would it be for sale? I can put in my own data?
I'm seeking a professional developer with experience in audio engineering ...experience in audio engineering and AI to build an online platform. This platform will use artificial intelligence to mix and master audio tracks, specifically tailored for the heavy metal genre - think distorted guitars, extreme vocals, and fast-paced drums. Key Aspects: - The focus should be on achieving an industry-standard quality of mixing and mastering. - The platform should particularly excel in ensuring the overall mix quality, with clear and powerful instrument separation. - iZotope should be the primary tool used for mixing and mastering. Ideal Skills: - Expertise in AI and audio engineering. - Experience with heavy metal music production. - Proficiency in using iZotope for mixing...
I'm looking for a freelancer skilled in Excel to help consolidate market data from 20-25 spreadsheets. Each spreadsheet has 6 tabs, but all are uniform in format. The task involves: - Manually consolidating the data into one tab of a new Excel file - Sorting the data by specific dates Please note, all source spreadsheets follow the same consistent format. The ideal candidate for this task should possess: - Strong proficiency in Microsoft Excel - Excellent attention to detail - Ability to adhere to timelines This project is perfect for someone who enjoys data work and is looking for a straightforward task.
I need a program that can manage to print a single label from an Excel spreadsheet. The label is 1.1 x 3.5 single labels. The printer is a Brother QL-1100C. Attached is the spreadsheet and what needs to be printed on the label. I need something that I can just click print and it prints that information from that line. Key Requirements: - Ability to handle queue management, job scheduling and job prioritization. - Specifically designed to print from an Excel spreadsheet onto custom 1.1 x 3.5 labels. - Allow creation and saving of custom label templates for reuse. Ideal Skills and Experience: - Prior experience in developing printer management software. - Strong knowledge of Excel and label printing. - Excellent problem-solving skills and attention to detail. Th...
I'm seeking an experienced data analyst or business intelligence expert to develop a comprehensive Power BI dashboard for me. The dashboard should track sales performan...seeking an experienced data analyst or business intelligence expert to develop a comprehensive Power BI dashboard for me. The dashboard should track sales performance, and it should be updated daily. Key Responsibilities: - Develop the necessary data from Excel spreadsheets to create a compelling narrative within the dashboard. - Design and implement the dashboard to monitor key sales metrics. Ideal Skills and Experience: - Proficiency in Power BI is a must. - Strong data analysis and visualization skills. - Experience with Excel and creating dashboards. - Understanding of sales performance metrics...
...automatically receive reminders for the event email and other messager . • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and messager) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting Allow grouping of database list. scheduling options for reminders. Option for allowing unsubscrible Allow mutiple user to do blasting Admin allow which user to to ...
I'm looking for a skilled architect/designer to help me design a 2-bedroo...site by owner or use IKEA. * Open living, dining, and kitchen * The full size of house is to have a basement below. We grow food and can a year’s worth of food at a time. We plan to build out basement later. One area of basement will be a safe to store valuables. Maybe it could be hidden. * Space for a shop in the garage. * Roof deck on top of home for viewing. * Heating and cooling by three mini splits. Hopefully basement won’t need anything. * Well and septic tank are in. Plans must comply with Yavapai County, Arizona, USA requirements. Architect and Engineer must submit plans to them for approval. If architect is not approved in the State of Arizona, they must find a local architect ...
I need assistance with descriptive data analysis using Excel. The data for this task will be sourced from various databases. Ideal candidates should have extensive experience working with Excel, particularly in data analysis. Skills in identifying trends, patterns, and insights from data are crucial.
I'm looking for a data analyst t...BI, conducting comprehensive data analyses, and generating detailed reports. As I have a foundational knowledge of Power BI, this role is perfect for someone who enjoys teaching and can work collaboratively. Key Responsibilities: - Work alongside me to create interactive dashboards - Conduct data analysis - Generate reports Skills and Experience Required: - Proficiency in Power BI, SQL, and Excel - Strong problem-solving skills - Excellent communication skills - Ability to complete project requests within 3-5 days Ideal Candidate: The ideal candidate will not only have technical expertise but also a passion for data and teaching. If you can explain complex concepts in an understandable way and enjoy working collaboratively, I would love to...
I'm seeking a proficient web scraper to gather data on news analysis YouTube channels. The task involves collecting and verifying contact details, primarily email addresses and social media handles, and organizing this information into a clean Excel spreadsheet. Key Requirements: - Experience in web scraping and data extraction - Ability to compile a list of YouTube channels based on specific criteria - Skills in data organization and ensuring accuracy - Proficiency in Excel Your role will be pivotal in assisting with outreach and marketing efforts, making this a significant opportunity for those with the right skills.
I need a 3-4 page website to display company data, sourced from a database (likely an Excel sheet). The site should have the following pages: - Home - About Us - Search instruments - Indices Ideal skills and experience for the job include web development, data management and Excel. The primary goal of the site is to showcase information, so a clean, user-friendly design is essential.
...communications écrites (e-mails, messagerie) et les tâches administratives. ?️ Mes services incluent : ? Gestion des réservations : Coordination via des plateformes comme et Expedia (traitement des demandes, mise à jour, synchronisation des tarifs et des disponibilités). ? Support administratif : Gestion des e-mails, saisie et organisation des données, suivi des factures et paiements. (Excel et Sage100) ? Relation client écrite : Réponses professionnelles et rapides aux messages clients pour garantir leur satisfaction. ? Gestion des réseaux sociaux : Création et publication de contenu, modération des commentaires et suivi des messages. ? Organisation et coordination : Gestion des plannings et ...
I'm looking for a skilled Excel expert who can create our quotation format/template on excel/sheets so that it can be easily modified by us when required. We also need it to be styled a bit and make it attractive.
I need a comprehensive financial plan for my startup. This will involve creating around 13 different sheets in Excel covering various aspects of our finances. Key Components: - Revenue forecasts: Estimating our sales and income over the next few years. - Expense tracking: Keeping tabs on our costs and expenditures. - Cash flow management: Ensuring we have enough liquidity to sustain our operations. I would like the plan to include visual representations of our finances. Specifically, I need: - Bar charts: To compare different revenue streams and expenses - Pie charts: To show the breakdown of our costs and profits Experience with creating financial plans and proficiency in Excel is crucial for this project. Please include your relevant experience in your proposal.
...the site to an offline staging enviroment of our own, as we have tried with another freelancer with little experience in the plugin our whole site crashed and we had to set it up again. Once the staging site is working it will be implemented online. We will not give the CPANEL, you have to copy it making sure Google can't see it to avoid duplicate content. 2- We import data to this plugin using excel so you must add as matching data the new custom fields (this is funcamental for us). Here you can see how custom fields work in the plugin. You may have to modify the of the child theme that is already installed. Here you can see a demo of the plugin,
I need help with understanding and analyzing my data. My data is in an Excel/CSV format. I am not sure what specific descriptive statistics I might need, but I would appreciate your expertise in guiding me through it.
I need an Excel dashboard for project management, specifically to track metrics related to production orders. This dashboard should be macro-based and capable of providing insightful visualizations and summaries. Key Requirements: - The dashboard should monitor production order metrics, including duplicates and their aging. - You should have a deep understanding of Excel and its macro capabilities. - Experience in designing and implementing management dashboards is crucial. - Ability to translate complex data into user-friendly visualizations is essential.
I'm searching for a proficient Data Analyst to assist in organizing and managing data for our online classes. The data will primarily include: - Attendance rec...extensive experience with Google Sheets, as these are the primary tools for data management. Key Responsibilities: - Data entry and organization: Ensuring all data is logged accurately and systematically. - Generating reports and visualizations: Creating clear and informative reports and visualizations to help understand trends and insights from the data. Skills and Experience: - Proficient in Excel/Google Sheets - Prior experience in data entry, organization and report generation - Ability to create visualizations from data I'm looking for someone who can help us make sense of our data and ultimately improve...
I need assistance in fixing an Excel file. The main issue I'm encountering is creating formulas, specifically logical functions such as IF, AND, OR. The primary goal of using these functions is to categorize data. Ideal Skills: - Proficient in Excel with a strong understanding of logical functions. - Experience with data categorization in Excel. - Ability to troubleshoot and fix formula errors.
...Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de Excel 2. Dos idiomas ingles y español Control de planilla 1. Salarios 2. Cargos 3. Vauchers...
I'm in need of an experienced Excel specialist to build a comprehensive customer database, with fewer than 300 customers of a meal delivery program. This database will be primarily for tracking customer records, and will also include various customer-related information that can be summarized with pivot tables, monthly and annual reports. The database should store: -Customer Name -Customer Address - Contact details -Special requests -Allergy alert information - Service history -Delivery route number -Delivery route order (in what order are the deliveries made) - Feedback and complaints Furthermore, I need this database to produce various reports. Specifically, I need it to assist with: - printing production orders - generating monthly government reports - integrating with b...
Es una App que busca unir a los proveedores de servicios de Mantenimiento (Carpinteros, Albañiles, Cortadores de Arboles, Plomeros, Electricistas, etc), con clientes que requieran alguna solución inmediata a precio razonable. Al descargar la aplicación el usuario deberá elegir que es….. si Proveedor ó...Contar con mensajería, entre cliente y proveedor. • Almacenar fotografías o video por cotización o solicitud de trabajo. • inglés y en Español. • Manejar expediente para proveedores y expediente para clientes. • Pago en línea para suscripción de proveedores. • Calificación de clientes y proveedores. • Table de Control para el Administrador • Base de Datos de P...
I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should i...
