Combine excel sheet vbsJobs

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...

I'm looking for a talented article writer who can help me create engaging, detailed biographies around net worth analysis. The articles will need to cover different individuals and their professional and personal journeys. Key requirements: - Ability to research and compile engaging biographical content - Experience in an...skills, with the capacity to deliver both professional and personal tones - Quality sources to back up the net worth and biography analysis The ideal candidate will have a mix of a journalist's curiosity and a financial analyst's precision. This project will offer an opportunity to craft insightful pieces on successful individuals, and delve into the financial aspect of their lives. If you can combine storytelling with financial data analysis, I...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

...The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the ...

I'm looking for a talented graphic designer to create a logo for my new property management company. This logo should stand out yet be minimalist in style. Key Specifics: - Ideal colors are warm and bold, su...should stand out yet be minimalist in style. Key Specifics: - Ideal colors are warm and bold, such as peach, mild orange, and dark reds/burgundy. - The logo can incorporate a building silhouette. Or even an abstract building. - I prefer the logo not be too tall or too wide. More of a block shape. The ideal freelancer for this job is experienced in modern, minimalist logo design and is able to combine abstract ideas with strong design elements. Color sense is crucial for this task. I look forward to viewing your portfolios and working with a creative mind to bring my ...

...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...

I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualizati...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure...

...instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the bro...

I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...

Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.

Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!

I'm seeking a highly skilled flutter developer possessing in-depth experience with Laravel to contribute their expertise to my social media application. Here are the key features expected: - Main UI is completed with flutter. - Laravel backend is almost 70%. - to be implemented: integrate the API into the current UI. social login(FB, twitter, tiktok, apple) inapp and banner ad audio combine with BGM. support the deploy on google play and app store HOW to apply. - please send me the FLUTTER APP URL on google play and app store and code screenshot of that App. (the proposal without the screenshot will be declined) - send me the laravel system URL and screenshot.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

Create Financial Project on Excel

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you

I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.

...professional presentation sheets for our martial arts school. These sheets will be used in sales conversations to visually convey the specific benefits of our training program to potential members. **Objective:** Each sheet should visually highlight a specific benefit of our training program: 1. Boosting Self-Confidence 2. Development of Defense Skills 3. Physical and Mental Balance **Format and Software:** - Size: 20x30 cm - Software: Photoshop or PowerPoint - The final files should be editable to allow later insertion of photos. **Design Requirements for Each Sheet:** **Sheet 1: Boosting Self-Confidence** - Title: "Stärkung des Selbstvertrauens durch Kampfsport" (Boosting Self-Confidence Through Martial Arts) - Main Elements: Before-and-after im...

...information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - Data Organization: Good data organization skills are also important to present

I need help with scraping specific information from urls (we will provide). The key details I need are the company name and contact information. Website Phone Email Brand Country Of Origin Total Entries: 1704 No research required, you just need to copy paste information from the fields onto a google sheet.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

I'm in need of an experienced and creative mobile app developer to craft an innovative mobile application for me. The mobile app should serve the general public and combine some specific features to make a user's experience convenient and enjoyable. Key functionalities should include: - Social media integration, allowing users to connect the app with their various social media accounts - In-app messaging, enabling users to communicate with each other within the app - Push notifications, informing users about important updates or messages even when they are not actively using the app Timing is crucial for this project as I'm looking to have it completed within a month. Ideal candidates should have: - Proven experience in mobile app development for both iOS and And...

I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.

Have two parameters: one for sheet ID and and one for collection. When you run the script, it extracts all data from that collection and puts it into a sheet tab with DateTime as tab name.

Project Title: Experienced Translator Needed: Translate Italian Company Balance Sheet to English Project Description: I am seeking an experienced translator to translate the balance sheet of my company from Italian to English. The balance sheet contains important financial information that needs to be accurately translated for business purposes. Project Details: Document Length: The balance sheet consists of 38 pages. Deadline: The translation must be completed by next week, asap. Expertise Required: I prefer a translator who has experience in financial or business translation, particularly with balance sheets. Technical Terminology: The balance sheet may contain technical financial terminology, so familiarity with such terminology is essential. Requ...

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call for a creat...

I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. T...understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them will b...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.

Hi Ashish, this is for the tasks I emailed about.

I'm in need of an expert who can develop a risk assessment model for Cmbs SASB. The main g...of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss further details and expectations once...

I have a document that needs to be typed up. It's scanned, so you must be able to read and type from scanned documents. The document is in English, so fluency in English is essential. The final document should be in plain text format. Ideal Skills and Experience: - Fast and accurate typing skills - Experience in copy typing, particularly scanned documents - Proficiency in English language - Familiarity with converting documents to plain text format.

I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.

I'm in need of an expert who can assist with financial analysis and create a 5-year sales and expenses forecast for my startup. I'm specifically looking for a professional who can: - Perform a comprehensive financial analysis for my start...forecast using customizable templates. - Include a detailed cash flow analysis in the forecast. The ideal candidate for this project should have: - Proven experience in financial analysis and forecasting. - Proficiency in creating customized financial templates. - Strong expertise in conducting cash flow analysis. - Ability to deliver high-quality work within a reasonable time frame. Example sheet attached below (it's reference purpose, not editable) I'm looking forward to receiving bids from highly skilled and experience...

...Microsoft PowerPoint template. Being a professional-themed project, I expect a sophistication that will portray my engagements in a streamlined, clear, and engaging manner. Key Aspects: - Single master slide design - Dominant color: Yellow Ideal Skills: - PowerPoint design expertise - Graphic Design Knowledge - Fluent in English to understand communication nuances The right freelancer should combine their creativity with a professional outlook. Remember, less is more in this scenario. Looking forward to an elegant, yellow-themed design that can encapsulate my professional presentations in a single master slide. Familiarity with corporate designs is a bonus. The slide is used to provide a monthly update on key information to our business. Style guide and logos will be provide...

I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.

...instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the bro...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

...confirming their details, and their current role and skills; identifying the industry or industries they can work in; and, hopefully, bringing them back to the organisation as an active candidate to place. The role will include: - Cold calling to candidate data provided based on the script provided - Gathering and confirming information based on the script provided - Updating the information in the sheet provided - Returning regular updates on progress, highlighting any active candidates open to exploring opportunities Once the initial project is completed, we may have further project requirements, to be determined....

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...