List xls files vba excelpráce

I'm seeking a Power BI developer to work with Excel and MYSQL databases for my project. The following will be required: - Connect Power BI to Excel and MYSQL databases - Create interactive maps as part of the data visualization aspect of the project Below i have attached Pbix file for reference Now i want to show community names on that each filled color it is showing only when i zooming by default if i open that map it should show name of each community and also giving reference website link and image How it should be shown exactly : ""

I'm looking for an expert who can summarize and visually represent my data using bar charts. The data is currently in an Excel spreadsheet format. Your tasks: * Derive insightful summaries from the given data to help me understand it better. * Create engaging and understandable data visualization using bar charts. Skills & Experience: * Proficient in Excel and data analysis. * Excellent command of statistical analysis. * Should have a good eye for design as well. * Proficient in creating bar charts and data visualization using other appropriate tools. *Identify and explain why statistical method(s) was/were chosen *Summarized data provide relevancy for research paper publication- identifying P factor etc * Color correct chart/data to maximize presentation Stud...

I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and ca...

I'm in need of an experienced Excel professional who can help me write some basic excel reports. These reports will consolidate information from several sources into one cohesive view, bringing an understanding of non complex data sets at a glance. The required Excel operations include: - Averaging data - Merging information from multiple reports into one Types of information to be processed: - Dates - Names - Current month's dues The reports should be formatted as tables. Ideal candidates should have extensive experience with advanced Excel functions and calculations, and a keen eye for detail in data consolidation. Strong understanding of data layout in Excel table format is essential.

HI, I wanted to read vcf files from folder and scrap data fields into csv file 1 file will be add as new row in csv file wanted to scrap fields mentioned in screenshot attached in chat. approx. 19 important fields: as follow 1-Title,2-First name,3-Middel Name,4-last name,5-Suffix,6-company,7-job title,8-file as,9-email,10-website link,11-business phone,12-home phone,13-business fax,14-mobile, for business address 15-street,16-city,17-state,18-zip,19-country

Seeking a meticulous data miner for a detailed task. As an Accountant-focused organization, we're looking to expand our database. Here's what I need: 1. Collect contact information, specifically: - Indvidual accountant names - Email addresses - Phone numbers - Mailing addresses 2. Target Accountants as primary industry 3. Only include data from specified postcodes and regions of Queensland, Australia. Ideal freelancers should be: - Experienced in internet research and data extraction - Familiarity with Australian directories/specific websites would be beneficial - Accurate in data entry. As the accuracy of this information is crucial for our outreach, we need your work to be spot-on. If you're detail-oriented, savvy in hunting down elusive online data, and...

...(1st Software) - Create a personalized search engine for a specific list of sites; - When i Click in a Button a list of keywords are searched in my own Google search engine (My Google search engine can be done here: ) - This search engine will use specific Dorks to search if these words exist on some of the sites previously selected by me and added in the Profile of my own Google search engine; - Then the links to the pages of the preselected websites that my Google search engine said that these words exist will be placed in an Excel in Google Drive; 2nd Stage (2nd software) - Then whenever I click on a button in the software, the software will look for the links in Excel from Google Drive and open these sites/pages; - There will be many

Seeking a dynamic advertising strategist who can amplify our presence on Facebook, Google Ads, Instagram, and LinkedIn. With a focus on Home Services (electrical services), your campaigns should drive quality leads and build efficient sales funnels targeting homeowners, property managers, and B2B audience. Ideal skills and experience: - Proven track...platforms - Deep understanding of the Home Services industry and our target groups - Expert in formulating strategies for lead generation and sales funnel optimization - Ability to provide actionable insights from campaign data Your role will be instrumental in positioning our services to the right audience, increasing our reach, and driving sales. If you have the experience and the drive to excel in this role, we would like to hear...

MESSRS - DO NOT MESSAGE or BID WITHOUT READING EVERY WORD IN PDF BELOW - NO BS CREATE ...INSTRUCTIONS: See Below DELIVERABLE: Three (3) spreadsheet file(s) One (1) Word doc with code and detailed documentation Autocomplete API Tasks 1. List A converted to .xls filed named Output 2. List C for new separate .xls named Output Name to Domain API Tasks 3. List A converted to converted to new .xls file named NO 4. Output A (see above) converted to new .xls file named Output A1.xls 5. Output C (see above) converted to new .xls file named Output C1.xls CREATE ACCOUNT LINK

More details: What type of information is included in each listing? Business name, Address, Phone number Is there any additional information that needs to be included in each listing? Website URL, Description How would you like the listings to be organized on your website? By location

Ich brauche eine excel Mappe für ein Trainings- und Ernährungscoaching. Auf der ersten Seite mein Logo (optionalerweise miterstellen bzw. Einen Vorschlag), ein Foto von mir, ein paar allgemeine Informationen und disclaimer. Auf Seite 2 einen Datentracker für das Körpergewicht mit einer Tabelle die die Entwicklung des Gewichts graphisch abbildet. Auf Seite 3 dann den Trainingsplan (eventuell aufgeteilt für mehrere Einheiten) bei welchem die Kraftwerte eingetragen werden sollen. Auf Seite 4 einen supplementplan (einfache Übersicht von supplements aufgeteilt nach essenziell und optional mit jeweiliger Dosierung) und Seite 5 mit einer kleinen lebensmitteldatenbank. Bestenfalls sollte der freelancer bereits ähnliche Projekte gemacht haben und kann mir e...

I'm seeking a professional who excels in creating user-friendly Excel spreadsheets. Your task will be to incorporate a Comprehensive Home Loan Repayment Calculator, a Detailed Monthly Expense Tracker and a Proactive Savings Planner into one efficient tool. Key Features: - Home loan repayment calculator that dynamically updates as variables change - A monthly expense tracker with features such as: * Tracking of income and a range of expenses * System built on the principles of a flexible budget - A savings planner to help set and track savings goals Ideal experience and skills: - In-depth understanding of Excel functionalities and formulas - Prior experience in creating personal finance trackers and calculators - Knowledge in financial budgeting principles, particu...

Application should optimize cost of transportation for the company employees. Based on dem...should optimize cost of transportation for the company employees. Based on demand for a specific date which departments of company are working, it should provide the list of people who are most cost-effective to transport to destination. There are predefined bus routes with addresses of employees. Based on this information application should provide list of names, which employees should be working on that day and provide, which lanes should be active, keeping in mind the cost effectiveness. Cost-effectiveness can be calculated based on mileage on the route and the number of routes (buses). At the moment all that is present in excel, but it can be modified and delivered in whate...

I am looking for an experienced developer to refactor and improve the performance of my existing mobile application todo list. The todo list is currently written in Flutter and I would like to refactor using BLoC & list view builder for easier readability. The todo list works already by itself. No need to connect to firebase or update the UI etc. Just refactor the code existing working code. Skills and Experience: - Strong proficiency in Flutter and mobile application development - Strong proficiency in BLoC state management - Experience in refactoring and optimizing code for improved performance - Familiarity with mobile app UI/UX design principles - Knowledge of task management features and best practices Project Requirements: - Analyze the existing code...

...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...

Hello, I have domain and hosting with go daddy. Currently I have the domain forwarding to a site that I made in Canva. However, in the hosting there is a Wordpress site. What I am trying to move the Wordpress site to a new domain. I need this done within 12 hours. Please do not bid if you cannot meet the deadline.

As the project owner, I'm looking for a proficient freelancer who can demonstrate competence in statistical data analysis using Excel. While I didn't specify the exact tasks in the questionnaire, the freelancer should be versatile in performing: - Descriptive statistics - Hypothesis testing - Regression analysis The purpose of this analysis is also open-ended. It could be for decision-making, identifying trends, or forecasting future outcomes. Ideal candidates should possess: - Robust knowledge of Excel and data analysis tools of the software - Previous experience with statistical data analysis projects - Ability to understand and respond effectively to project needs In your application, even though I didn't specify what you should include, it would be ...

I'm looking for an Excel specialist with intermediate proficiency to assist with data analysis, forecasting, and supply chain management tasks. Here’s a summary of the key responsibilities: - Perform extensive data analysis - Develop forecasts - Manage supply chain operations Key tasks will also include: - Data cleaning and preparation - Creating intuitive, effective data visualizations and statistical analysis Although I don't have an explicit preference for the types of data visualizations, I expect the chosen freelancer to make recommendations and create charts/graphs that best represent the data in a clear and comprehensive manner. For this project, experience in forecasting and supply chain management is crucial. Freelancers who can demonstrate prior expe...

I am looking for a skilled freelancer to create SVG files for an online 3D clothing designer project. The project requires the following: Number of SVG files in total: 280. But many on the same garment. 34 tiff files/clothing types. Design concepts for each SVG file: We have the tiff files for each garment with the 3D overlays. And a PNG of all the styles required for each tiff file/clothing type. Deadline for completing the SVG files: We are flexible with the timeline and would appreciate a reasonable amount of time for completion. Ideal skills and experience: - Proficiency in creating SVG files - Experience in designing clothing items - Familiarity with 3D overlays and tiff files - Ability to work within a given timeline If you are a...

Just need someone to transfer data from provided PDF to provided Excel Template

I require data entry services to extract mixed numeric and text data from one unstructured PDF file, and input it into an Excel file. The project requires attention to detail to ensure accuracy of inputted information. I am preferably seeking someone with experience in data entry, with the ability to interpret unstructured data, and proficiency in Excel.

I have here an Excel document with adresses from our donors (391) and a donor system. We used the document for many years, however, we want to have this digitally. You need to change each name in the donor system into “Yes, by mail”. First: Go to “Daily Work” - “Contacts” and then 1. search for the name 2. pop up open contact 3. go to tab communication and 1. change “magazine” from no into “yes, by mail”.

I am seeking a highly meticulous individual for extensive text-based data entry. Key Responsibilities: - Enter all information provided into an Excel spreadsheet. - Ensure data is alphabetical. Ideal Candidate: - Proficient in Microsoft Excel. - Reliable and strong attention to detail. - Excellent organization skills to sort data alphabetically. - Prior experience in data entry tasks. The successful candidate must be accurate in their work and follow the designated order strictly. It is imperative to keep the project organized and easy-to-read.

...assigned to each batch in order to maintain traceability both in terms of cost and material origin Pouching Department This Department has two types of machines. 2 head and 4 head. Depending on the SKU the supervisor chooses which type to Pouch the batti in. Currently there are 8 machines 4 - four head, 4- two head. These are counting and packing machines. A sample manual report being maintained in excel format will be shared. Each Worker is paid on the pouched quantity in RB quantity ( not dipped quantity ) one worker per machine. Wage is calculated on a contractual rate decided as per SKU, if workers dont reach a minimum wage it is supervisor decision to give minimum daily wage or not. Stock of pouched batti is required. In kgs. The amount of batti pouched is deducted from d...

I'm on the lookout for an adept React developer to create a specific React component. - Design: The design for this component is already decided, so you'll need to be able to accurately transl...Design: The design for this component is already decided, so you'll need to be able to accurately translate my target aesthetic into functional code. - Libraries: For this project, experience with MUI is essential as I'd prefer that the developer work with this particular library. - Functionality: The principal functionality that this React component should have is a collapsible layout. To excel in this job, the ideal candidate will have a proven track record working with React, MUI, and implementing complex user interfaces. Let's work together to bring this ...

Verify a lead list emails to check for no bounce, will be hourly work 3 hours 5x a week!

I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bonus.

I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the databa...after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...

I'm looking for a proficient Excel expert who can incorporate specific types of filters into my workbook. The applicant must be skilled in applying the following filters: - Filter by Value: This will separate data based on specific criterion I provide. - Filter by Color: Assist in classifying certain data points using different colors. - Filter by Date: Help in organizing data chronologically. Specifically, these filters must be applied to specific columns of the worksheet, improving data management and analysis. In addition to the filters, I also require the following features: - Highlight Filtered Results: Highlight specific extracted information for easy identification. - Sort the Filtered Data: Arrange the outcomes in a particular order for better examination. - Searc...

I am in need of a proficient Data Analyst skilled in Data Visualization and Descriptive Statistics. ...is understanding and interpreting data from various sources. Key Project Requirements: - Proven experience in delivering data interpretation through Visualization techniques. - Proficiency with Descriptive Statistics, adept at summarizing the main features of the collected data. - Experienced in working with multiple data sources. Data in the following formats will be utilized: - Excel Spreadsheets - CSV Files - Online Databases Ideal candidate should be detailed-oriented and able to accurately interpret and present complex data sets. Your role would significantly influence important business decisions and strategies, so it’s crucial that information is accurately a...

I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirme...

Excel sheet data typing Im a hard work person and i know how to work in excel sheel im a CA (Computer Application) student i will do my best for this job

I'm in need of an individual expert in Excel who can perform some simple calculations on my attached spreadsheet. The details of the task are shown in the spreadsheet, it won't take an expert too long to finish.

Hello, I am looking for a talented and affordable video editor to assist with editing 2 hours of content. This is a continuous project, and I am seeking someone who can de...rate for the initial 2 hours of content editing. As this is a continuous project, we can discuss long-term rates and payment terms once the initial project is successfully completed. Application: If you are interested, please send your portfolio or examples of your previous video editing work. Include a brief description of your experience with video editing and any specific skills or tools you excel in. If you have experience with Kannada language content, please highlight that in your application. I look forward to finding a reliable and skilled video editor to collaborate with on this and future projects. ...

I require expert assistance in analyzing financial transaction data using Excel. The project's primary goal is quantitative data analysis. Through this project, I aim to draw valuable inferences and insights. Key responsibilities: • Analyzing large datasets related to financial transactions • Applying advanced Excel formulas and functions to dissect data Ideal Candidate: • Proven experience in data analysis, specifically within financial sectors • Proficiency in Excel for data management and analysis • An excellent understanding of quantitative data analysis methods.

I need an expert in Excel to build a robust calculator capable of handling complex mathematical equations and statistical analyses. This tool should be designed to deal with less than 100 distinct variables or data points. Key Requirements: - Excel proficiency with in-depth knowledge of mathematical and statistical functions. - Prior experience in building sophisticated Excel calculators. - Ability to create a tool that imports data from external sources automatically. The ideal candidate would have a strong statistics background and be capable of understanding the mathematical formulas I'll provide. The automation of data importing is crucial as it will streamline the usability of this calculator. The project is to calculate drivers pay and fuel consumption...

You need to collect local business details out of Facebook groups and put them in an excel file. Data fields are: Source (posting url) Kind of business (like “painter” for instance) Name of business Contact Person Name (optional) Phone if available Email if available Phone is preferred but if not possible then email is ok. Please make your offer for 100 data rows aka 100 businesses and mention the word Australia at the beginning of your application so I know you have been reading the instructions. We will provide the local Facebook groups where the businesses post. Some of them you need to join first, others are open.

Web scraping from provided list of URL

...planning a similar project there: Domestic News A regional online magazine was to be created and reproduced in a franchise. Each franchisee will fill the contents themselves. The website appears under a subdomain, for example www.domestic-news/manila I need: - An easy-to-use CMS with login for every franchisee o Customer data (company, name, address, email, web, telephone) o Customer data – export to Excel o Rubrics prepared according to template - Deactivation of categories without content - Expansion of categories by franchisees - Frontend design is already sketched (in the appendix) - All images in 3:2 format automatically cropped - Home page with selection of regions/locations - Version for screen, tablet and mobile phone - Backend language: English Design template, a...

Need an expert to clean up my textual data currently stored in an excel spreadsheet. This includes: - Fixing the formatting issues present in the dataset - Removing any blank cells to create a more organized and streamlined data view Please note that while the project does not require any specific end format for the text data, I'm looking for someone with a keen eye for detail who can make suggestions to improve the data readability and utility. Success in this project would involve achieving a tighter, cleaner dataset, hence your experience and familiarity with Excel and data cleaning techniques will be crucial.

This business intelligence project requires creating a comprehensive database of all the flooring manufacturers across the USA and Canada. I specifically need information about companies producing hardwood, laminate, and vinyl flooring. Key tasks includ...identifying marketing contacts in each company, complete with their contact information. - Companies can be of any size, from large corporations, medium-sized businesses to smaller local operations. Ideal Skills: - Exceptional research skills - Experience in lead generation and data mining - Familiarity with the flooring industry, specifically hardwood, laminate, and vinyl - Proficient in Excel or similar database management tools This project is great for freelancers with an instinct for detail and diligent data search ...

Tenemos todos los datos y un documento de flujo de caja pero necesitamos un documento mejor estructurado y formulado para que se pueda entender y exponer mejor

I am looking for an expert in Excel especially well-versed in the Norwegian language to assist me in data entry and creating database leads for marketing purposes. The focus is on signage companies in Norway. The ideal candidate should be proficient: - In Excel data entry and organization - Skilled in designing and managing databases - Must have an understanding and fluency in Norwegian language. -this project requires phone calls and web searching The main task will revolve around generating leads through database creation for targeted marketing campaigns (Signage companies in Norway). This project requires a good grasp of lead generation strategies in addition to the aforementioned skills. Please place your bid keeping in mind all the requirements stated.

K zobrazení podrobností se zaregistrujte nebo přihlaste.

Objective: To set up and configure Microsoft Office applications for a small business in New Delhi, India, to modernize operations and enhance productivity. Key Requirements: Primary MS Office Applications: Excel: For managing data, performing calculations, and creating reports. Outlook: For email communication, scheduling, and task management. SharePoint: For document management and collaboration among team members. Installation Scope: The MS Office suite will be installed on 1-5 devices to accommodate the needs of the small business. User Proficiency: The users of the MS Office suite are beginners. Therefore, the setup will include basic configuration and user-friendly customization to ensure ease of use.

I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, continge...

More details: What type of data do you need to type into the Excel sheet? Numbers How many columns and rows are there in the Excel sheet? 10-20 Would you like me to create any specific formulas or functions within the Excel sheet? Summation formulas, Average formulas, Lookup and reference formulas

I'm searching for an experienced Excel Macros Specialist to help me edit my document. Quick easy job. Won't take more than 10 minute.

I'm seeking a freelan...experience in LinkedIn data mining with a focus in the tech industry. A high accuracy level of data should be assured. I have got a LinkedIn link of 4500 profiles of software engineering managers, I need all the list. Required fields : Contact first name, last name, company name, title, email address, phone number, industry, LinkedIn profile, state. I need all verified leads, check by verification software. Tell me what software do you use for lead generation ? Key Tasks: - Develop a list of LinkedIn titles specific to managerial level professionals in the technology industry - Focus area of list building should be Australia Ideal Skills: - Experience with LinkedIn data mining - Proficiency in tech industry headhunting - Familiarity wi...

I'm looking for an experienced freelancer who can create a dynamic and detailed Excel spreadsheet to break down the scenes of a screenplay, identifying specific elements of each scene (e.g Location, Characters). **Requirements:** - The ability to input details including Location, Time, Characters involved, and whether the scene is interior (INT) or exterior (EXT). - The spreadsheet should be structured to allow sorting options. This function is crucial for organizing the scenes in various orders, such as Chronological, by Scene Number, or other categories as needed. **Ideal Skills and Experience:** - Basic Proficiency in Microsoft Excel or similar spreadsheet software - Previous experience in creating spreadsheets for screenplay analysis or similar projects would...