Excel vba consultingJobs
I'm looking for an experienced Tableau expert to build us daily reports from CSV/Excel files. This will include: - Creating Sales reports - Setting up Financial reports - Designing Marketing reports We are seeking candidates who have a strong background in data analysis, specifically having worked with CSV/Excel files for data sourcing. Key skills and aptitudes: - Extensive knowledge of Tableau and its functionalities - Proficiency with CSV/Excel files - The ability to keep the reports updated daily - Strong attention to detail - Prior experience in creating financial, marketing and sales reports.
Excel web query to extract data into Excel spreadsheet from also extract Live odds comparison table from Currently, these 2 tables are not showing up using Excel web query
I have project need to knkw if it's can be done If you can start now, start your bid with NOW
I have project need to knkw if it's can be done If you can start now, start your bid with NOW
I require a keen, detail-oriented individual to transcribe text data from a physical copy into an Excel file. Key Tasks: - Typing text data accurately from a hard paper copy - Efficiently organizing typed data into a neat and easily readable format in Excel Ideal Candidate: - Demonstrates excellent typing skills - Proficient in Excel - creating and manipulating spreadsheets is a must - Possesses fabulous attention to details - Past experience with data entry projects is highly valued Your task will purely be concerned with data entry. Understanding of the written content won't be necessary. But precision in transcription and ability to deliver on time are crucial.
I require a keen, detail-oriented individual to transcribe text data from a physical copy into an Excel file. Key Tasks: - Typing text data accurately from a hard paper copy - Efficiently organizing typed data into a neat and easily readable format in Excel Ideal Candidate: - Demonstrates excellent typing skills - Proficient in Excel - creating and manipulating spreadsheets is a must - Possesses fabulous attention to details - Past experience with data entry projects is highly valued Your task will purely be concerned with data entry. Understanding of the written content won't be necessary. But precision in transcription and ability to deliver on time are crucial.
I am seeking an experienced data scientist with expertise in forex trading. Your tasks will encompass: - Analyzing datasets related to historical forex market data, economic indicators, and news sentiment. - Developing predictive models to anticipate currency trends based on analysis. Experienc...Developing predictive models to anticipate currency trends based on analysis. Experience in forex trading, predictive modelling, and data analysis is ideal. Also, you must have skill in cross-checking daylight saving times against these datasets. Please demonstrate your ability to handle these tasks in your proposal. - Data will be for 15 years worth between tick data and 1M prices. Very large Excel file which has over 500k to 1Million rows per tab / year depending on 1minute or...
...in need of a highly skilled Excel expert who can efficiently create two dashboards from a database of 5-7 columns. These dashboards will be used mainly for visualization reporting purposes. The built dashboards should be able to handle and present mixed data, made up of both numerical and textual information. Since data will be updated on a weekly basis, the dashboards should be designed with this frequency in mind to facilitate seamless updates. Key Skills Required: • Advanced Excel knowledge and experience. • Understands data visualization best practices. • Proven experience in creating interactive dashboards. • Ability to manage and present mixed data types. • Capable of setting up dashboards for weekly data updates. This is a great opport...
we are proficient professional who can handle data entry into Excel. Our responsibilities will primarily require: - Working with mixed text and numerical data. - Entering and organizing this data into a tabular format. Our ideal Team possess robust Excel skills, coupled with a attention to every detail. Our ability to process mixed text and numerical data efficiently will be the key to success in this role. We have multiple Prior experience with similar data entry projects and we would be advantageous but is not compulsory. We know that Timeliness, accuracy, and confidentiality are crucial aspects for this job. Looking forward to any data project will be provided to our team for processing.
I require an expert with a solid background in Excel and advanced problem-solving skills. Your tasks will include: - Cleaning and formatting sales, financial, and survey data. Please ensure accuracy and consistency in our data sets. - Calculating relevant statistics and metrics from this data. I entrust your knowledge of appropriate statistical methods to use to bring us meaningful results. - Creating dynamic charts and graphs to visually represent our data. Your ability to present information in an easily understandable manner is crucial. The main goal of the data analysis is to uncover trends and patterns that will enable us to make data-driven decisions. Therefore, strong analytical skills and business acumen are a must. Experience with similar projects is highly desirable. Del...
Hi Vanessa Kudzai C., We have been shortlisted for an Assignment in Zimbabwe and are seeking a potential local partner to support our team. Kindly let us know if you are still currently consulting so we can proceed to deliberations.
I'm in need of a professional who can successfully convert my Excel sheet into a stand-alone Windows-compatible program. The key functionalities to be retained from the Excel sheet within the new program are: - The ability to manually input and extract data - Execution of all existing formulas and calculations - the program should be user friendly and can not be copied without special permission - a good design with my company logo is essential Ideal candidates should be experienced programmers with strong knowledge of data management and task automation, as well as an understanding of Excel functionalities. Familiarity with data analysis will also come as an advantage.
I'm seeking a professional who can script a user-friendly interface in PowerBI for my team to manually enter numerical data/ text directly without the need for excel. The main task will be to design and implement a data entry system suitable for a non-technical team. Key responsibilities include: - Setting up this custom data entry system within PowerBI - Ensuring the system allows for manual input of numerical data which is then stored in sharepoint excel - Verifying the accuracy and consistency of the data entered The ideal candidate for this project will have: - Significant experience with PowerBI, Python, and data visualization - Understanding of data management and integrity checks - Proven track record of creating custom data entry forms in PowerBI Expertise i...
I need highly skilled graphic designers to create an A5, double-sided menu flyer for my cloud kitchen. This is an exciting opportunity for a designer that thrives on clean, modern design styles. Key details about the project include: - Size: The menu flyer must be A5, ensuring a compact but comprehensive layout. - Style: Preference will be given to designers who excel at modern and clean aesthetics, providing a visually delightful and uncluttered experience for my customers. - Pages: The menu flyer should be double-sided, utilising space effectively to present all necessary information without overwhelming readers. Ideal candidates should have significant experience in graphic design, particularly in creating menu flyers or similar materials. Knowledge of modern design trends a...
I require expert legal consultation for my endeavour - registering companies in India using public domain information. The companies of interest are within the environmental sector. What I n...registering companies in India using public domain information. The companies of interest are within the environmental sector. What I need: - In-depth knowledge of Indian legislation regarding company registration and the use of public domain pertaining to that. - Expertise in advising strategies to navigate this complex process efficiently. - A proven background or substantial experience in legal consulting related to company registration, specifically within the environmental sector in India, is essential. Feel confident you can take on this challenge? Apply and shine light on your e...
I'm looking to populate the front sheet of my pricing document using the tabs behind. I need it to look for any populated value, if there is one there, return it. e.g. formula in C25 looks up list in Product List A2:A500 and returns the first value populated. In C26, it should look up the same column of A2:A500 ignore the first value because that's already populated above and return the next value. I cant have it returning row for row as i have limited space. The standard Product should look up Product list tab, Bespoke one should look up the first bespoke tab, Bespoke 2, the second etc. One formula should pretty much work for all, its just what its looking for and how to get it to ignore values that have already been pulled across.
I'm seeking detailed-oriented freelancer(s) with Excel expertise to help me transcribe and organize data into approximately 350 spreadsheets. Key Responsibilities: - Entry of various types of data (text, numbers, and dates) as modelled in the provided sample. - Employing a versatile organizational approach where data types might be handled in more than one column. Timeline: The project should be completed within one month. Ideal Skills: - Proficiency in MS Excel and data management. - Detail-oriented approach and high accuracy in data entry. - Ability to follow instructions and work with varying data arrangements.
...time data from multiple websites to Excel spreadsheets. - Data Types: The project involves working with a variety of data types including text, numbers, dates, as well as articles, notes, and data in Hindi font. The proficiency in Hindi and ability to handle various data formats is crucial. - Number of Websites: Data has to be scraped and entered from three or more different websites. Experience in web scraping tools is mandatory. - Volume of Data: For each website, you will be dealing with approximately 400 pages. Expertise in data management from high volume websites is a key requirement. Your ability to accurately handle and organise a large amount of dialogues will be directly correlated with the success of this project. In-depth knowledge of Excel functionalities...
I am seeking a freelancer with expertise in data visualization for a graphic d...task will be to create a pie chart that clearly represents ten 'Sectors of Life'. I have chosen Excel or similar so that I can modify the words as needed because I appreciate its simplicity and I want to be able to make edits in the future if required. The skills and experience required for this job are as follows: - Proven experience in data visualization and Excel chart creation - Ability to interpret life sectors and visually represent them in an organized way - Consistent communication for the successful execution of the project I look forward to seeing your bids and working with you on this interesting project. Please include samples of similar pie chart graphics you have created...
As a small business owner, I require an Excel expert who can assist in creating a custom-made Excel file specifically for quotation calculation purposes. This Excel file will primarily perform comparisons of quotation calculations derived from various vendor rate lists. The ideal candidate should possess the following skills and experience: • Expertise in Excel formula calculations, and knowledge of macros will be helpful. • Familiarity with business quotation calculations from various supplier rate lists. • A proven track record of creating tailor-made business tools using Excel. The role's responsibilities include: • Designing and constructing an Excel file suitable for executing complex quotation calculations reliabl...
I am promptly looking for an expert capable of converting a VBA script that currently operates on Windows Excel 16 to function on Mac Excel 16. The existing VBA script is primarily used to automate tasks, owing to which, proficient experience in scripting automation and swift task execution is key. - Ideal Skills: Proficiency in Excel VBA, familiarity with both Windows and Mac Excel 16, understanding of task automation via scripting, and the ability to deliver within short timeframes. - Key Ask: The primary function of the script is to automate tasks. While specifics aren't provided, a good grounding in automating generic tasks through VBA scripts will be invaluable. - Timeframe: This job is immediate. I require a swift ...
I have an Excel 2016 VBA script in need of converting to Mac VBA. The converted script is expected to retain the same functionality. Additionally, I require a video tutorial demonstrating the successful running of this new script. The video duration is flexible and it shows the success of the converted script. I'm urgently looking to complete this project. Ideal freelancer should have: - Experts in VBA scripting, especially Excel 2016. - Proficiency in MAC VBA Scripts. - Experience in creating video tutorials. - An ability to complete tasks on short notice.
...qualified individual to efficiently convert a Windows VBA script to operate on Mac Excel 16. This is an immediate job that requires delivery in a few hours. Key Requirements: - The converted script should exhibit specific functionalities on Mac Excel 16 such as: - Automation of tasks, particularly spreadsheet management - Conducting worksheet operations - Accurately applying formulas Ideal Candidate: The ideal candidate will have an in-depth understanding of VBA, familiarity with both Windows and Mac environments, and proven experience in Excel automation. Deliverables: - The converted VBA script that functions successfully on Mac Excel 16 - A video demonstrating the successful operation of the converted script on Mac Excel...
Hello - I'm creating a fixed price project to add in a consulting page to the existing project we worked on (Harvyst).
We require a VectorWorks, VectorScript plugin built to do some calculations and present results. The following is a brief summary. More details will be supplied to successful candidate. In we need to be able to click in the VW, 4 extents (length of item, start, stop, and width). A popup should show and advises some information. A data table is then referenced (think Excel - VLOOKUP) The object is then measured, labelled, and put into a table on the sheet.
...sophisticated quiz module for delivering online tests. This should include the following key features: - A facility for multiple choice questions. - A countdown timer for each question. - Random question selection for greater challenge and variation. - user can register and then attempt our quiz - list of Our created quiz will be be display at front end -admin can download quiz attempted user data in excel format I plan to create multiple types of quizzes, each having a unique configuration and targeting different user groups. Knowledgeable freelancers who can demonstrate prior experience in Drupal quiz module creation will have a significant edge here. It's worth mentioning that I will supply all quiz content. So, I do not expect the selected freelancer to create the co...
we are proficient professional who can handle data entry into Excel. Our responsibilities will primarily require: - Working with mixed text and numerical data. - Entering and organizing this data into a tabular format. Our ideal Team possess robust Excel skills, coupled with a attention to every detail. Our ability to process mixed text and numerical data efficiently will be the key to success in this role. We have multiple Prior experience with similar data entry projects and we would be advantageous but is not compulsory. We know that Timeliness, accuracy, and confidentiality are crucial aspects for this job. Looking forward to any data project will be provided to our team for processing.
I require a freelancer to convert our existing Excel estimating spreadsheet into a Cubit estimate template. Key Requirements: - Full conversion of Excel spreadsheet to Cubit. - Maintain key functionalities from our original spreadsheet, including formula calculations and data sorting. - Help us set up Cubit in our office for testing use. Ideal Skills: - Proficiency in Excel and Cubit estimating systems. - Experience in migrating data from Excel to Cubit. - Understanding construction estimating, specifically for modular residential homes, would be advantageous.
...feeding task and capable of importing data from an XLSX format Excel workbook into Corel in a certain format . I have attached an excel file which has data of students and a corel file which has format in which the data of all students needs to be filled. (not copy pasting) So this is a school result and it is in excel file and We have a set format in Corel draw. All you have to do is import that data which is in excel file to corel file according to their headings. From class 1-12 there are 4 formats. There would be around 2000 Students. It is very time sensitive task considering results. You won't get much time (hardly 1-2 day max). Key Responsibilities: - Implement and execute graphic design tasks in Corel - Import Excel data (in XLSX forma...
I'm looking for a skilled develope...automation system catering to account processing tasks: Key Tasks: - Data entry - Calculation of financial transactions - Report generation - MLM Plan Incorporation with recurring functions Aligned to eventually be accessible online, this system will be primarily used by one administrator. I operate in the consumer industry, so related experience and understanding is advantageous. Proficiency in VBA or Python programming is paramount. Accounting knowledge is also indispensable, as well as familiarity with Multi-level Marketing (MLM) schemes. This project offers an opportunity to create something that could greatly enhance efficiency in consumer finance. Please bid keeping in mind the balance between quality and cost. Looking forward to ...
[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Inputs] "" and "". [Output Goal]Copy Excel(.xlsx) data ant paste to Google Docs( not microsoft Word) [Output Example] [Detail]Process Excel tables row by row and paste them into Google Docs. Image data can also be set as necessary.
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule. The data parameters from the spreadsheet that need to be incorporated into the schedule are names and time slots. Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. Skills & Experience: - Strong Excel skills - Excellent organizational abilities - Prior experience in creating schedules or calendars from Excel data Your job will be to carefully transfer the 'Names' and 'Time Slots' from the spreadsheet into the daily calendar format I need. Please ensure the information is both accu...
I'm on the lookout for an Excel whizz for creating an Excel project management tracker with the following specific features. Required Features: - Task Tracking: This is the most crucial aspect of the project. We will be tracking various data like task progress, deadlines, and associated team members, in which I'm focused on. - Time Spent on Task: The tracker should also allow tracking of the time employees spend on individual tasks, helping us to understand resource efficiency. Ideal Skills & Experience: - Proven experience in creating complex Excel spreadsheets - Deep understanding of data tracking and resource management - Proficient in handling project management tools, specifically Gantt charts I'm looking forward to a specialist who can make ...
...proficiency in Microsoft Power BI, who is able to masterfully combine data visualization and data modeling. The specific functionalities required are: - Data visualization: turning large and complex data sets from Excel spreadsheets into visually appealing and understandable visualizations. - Data modeling: structuring the raw data in the Excel spreadsheets into a more useful and relatable form for easier interpretation. The primary goal for this project is to create engaging and interactive reports from existing data. An ideal candidate would be comfortable and experienced with Excel and have a deep understanding of data interpretation and reporting. Strong communication skills are essential in order to understand my needs and translate them into the interactive...
I'm looking for a talented developer to create a product comparison website focused primarily on electronics and household appliances. The website needs to include specific features: - Product reviews: Visitors should be able to read reviews about the mentioned products. - Filter and sort options: These are crucial for a user-friendly experience. Visitors should be able to easily f...product with the search button or choose the main product category for example first step -- PC then the second one is Notebook then maybe Apple then Macbook PROs and so on. I need to add Google ads(It will not take up too much of the page and will not disturb visitors much.). I need also a management console to update the website and I would like to add multiple products at the same time like from ...
I require a talented coder skilled in creating Excel macros to automate data entry tasks. The macro should efficiently handle logical formulas but does not require extensive knowledge in IF statements, AND/OR/NOT or VLOOKUP-HLOOKUP conditions. Key responsibilities include: - Developing an Excel macro that automates data entry tasks - Implementing logical formulas into the script Ideal skills: - Proficiency in Excel and VBA - Strong understanding of logical formulas in Excel - Experience in creating macros and automating data tasks Please note that while this project doesn't have the specific logical conditions, a generic understanding and ability to implement logical conditions if required are preferred.
I need an Excel expert to create a formula that will automatically pull matching data from one sheet to another based on a unique identifier. Specifically, the formula should locate and pull information using social security numbers. Here is what you need to bring to the table: - Advanced knowledge of Excel formulas - Prior experience with data matching functions - Understand the importance of accurate data handling due to sensitive information (social security numbers) - Ideally, past work with financial or personal data If you have handled similar projects and mastered the required skills, I want to hear from you.
Hi Dreamers Consulting LTD, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Set up the following questions and solutions in Excel and verify the solutions provided. Explain and interpret the reasoning behind solutions. Annotate carefully your work in Excel. Provide proofs where necessary. Provide theoretical/ mathematical/statistical justification for your workings in excel. Interpret in full your results. All solutions are provided
I have multiple client lists scattered across a few Excel files, which I am keen to consolidate into a single Excel document. Each consolidated list should have its own sheet and be arranged in table format for smoother data management purposes. Freelancers ideally should have: - Strong skills in Excel and data consolidation - A keen eye for detail - Prove their proficiency by showcasing their past work involving similar tasks This project involves consolidation of 1-5 Excel files. Your thorough understanding of Excel Data management and table manipulation will be beneficial in delivering success for this task. I look forward to your expert assistance in this matter.
I am in need of a professional who possesses advanced skills in Excel data entry. My project involves: - Complex data input with use of formulas - Formulas will be provided by me The ideal freelancer would be someone highly experienced in Excel, particularly in managing complex data input through formulas. Knowledge of Excel's advanced functions is also a must. Being able to work accurately and efficiently is crucial for the success of this project. If you have such skills and you're looking to take on a new project, I'm eager to see your bid.
I am in need of a meticulous freelancer with strong data entry skills to help me populate an Excel spreadsheet with simple text data. Key Responsibilities: - Data entry into my Excel database - Ensure all entries are accurate and error-free Ideal Skills and Experience: - Significant experience using Excel for data entry - Detail-oriented and accurate - Familiarity with data cleaning and formatting This task will require careful attention to detail and the ability to handle simple text data efficiently. I look forward to your bids and questions about the project.
Hi, enclosed donut chart needs to be finished. What need to be done: - outer ring needs to be finisihed - different scales of the color from dark to light - all the labels inside their area (so most of them need a small radius adjustment)
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I'm looking for a competent Excel specialist who can use advanced formulas to analyze an extensive batch of survey data. I essentially need a couple new formulas written for an existing excel file Your duties will include: I have an existing excel file I want to add an extra row of captured data to and pull out trends from that new data with existing data
I urgently require a skilled freelancer with comprehensive knowledge of Microsoft Excel to execute intricate modifications to an existing Excel file. Key changes I need include: - Data validation: I want the data entered via the arrows online and calculated for AQL. The freelancer must be adept in managing flexible data entry and control measures. - Formula adjustments: The selected professional will have to be skilled in making and tweaking formulas. - Formatting changes: I'm looking for an aesthetic refit of my Excel sheet. The freelancer needs to have a good eye for layout design and detail. - The file should lock unused cells for consistency and error avoidance. - I'd also like to have a clear button included for the easy cleaning of specif...
I'm urgently seeking a versatile Business Consultant, with pr...ultimate aim is to generate tangible results that reflect positively on my bottom-line. What I Expect: - Help me streamline and improve my operational processes to foster efficiency - Assist in devising a robust marketing strategy that increases visibility and clientele - Revamp my financial management approaches to maximize profitability. Ideal Skills & Experience: - Prior proven experience in consulting for the automobile sector - Strong knowledge of marketing strategy, financial management, and operations - Ability to provide quick and effective solutions. I anticipate prompt turnaround times and quality has a premium. I'm keen to see this project commence ASAP. Please bid if you possess the relevan...
I urgently require a skilled freelancer with comprehensive knowledge of Microsoft Excel to execute intricate modifications to an existing Excel file. Key changes I need include: - Data validation: I want the data entered via the arrows online and calculated for AQL. The freelancer must be adept in managing flexible data entry and control measures. - Formula adjustments: The selected professional will have to be skilled in making and tweaking formulas. - Formatting changes: I'm looking for an aesthetic refit of my Excel sheet. The freelancer needs to have a good eye for layout design and detail. - The file should lock unused cells for consistency and error avoidance. - I'd also like to have a clear button included for the easy cleaning of specif...
