Excel macro how to jobs
Looking for an Excel expert to create a comprehensive document for my restaurant. The goal is to track and manage sales, expenses, and inventory data effectively. Key Features: • Sales Tracking: We need to digitally monitor our daily and monthly sales. This should make it easy for us to understand how well our restaurant is performing in the market. • Expense Tracking: We need a simplified way to record and analyze our major expenses which include food cost, labor cost, and utilities cost. • Inventory Management: The template should help to check and manage inventory any time we consider necessary. Ideal Skills: • Strong expertise in Excel. • Previous experience in creating Excel templates ...
...with a Macro-enabled Excel sheet. When I attempt to open the file, it closes automatically. I am in need of a professional with advanced knowledge and skills in handling Excel Macro issues. Key details include: - The Excel Sheet is not opening properly: Instead of loading correctly, the file automatically closes after I attempt to open it. - Issue presents in Excel's Safe Mode: The problem persists even when unloading all add-ins and opening Excel in safe mode. The ideal candidate for this job would have: - Extensive experience with debugging and troubleshooting Excel Macros. - A methodical approach to problem-solving. - Strong attention to detail to ensure that no related issues are overlooked...
I need a professional who can help me effectively market Excel VBA (macro) in Singapore and Malaysia. As the in's and out's of the intended audience's industry/s is not specified, a broad-spectrum approach that can appeal to a variety of sectors would be imperative. Key Responsibilities: - Implement this strategy aiming to peak interest and usage of Excel VBA The ideal candidate should: - Have proven marketing experience, particularly within the regions of interest, Singapore and Malaysia - Posses a profound understanding of Excel VBA and its potential applications
Hi there, I am looking to create a custom tool to export the values of a specific 1 minute bar on a trading view chart and export that data to an excel spreadsheet. An example would be, by right clicking on the specific bar on the trading view 1 minute chart it exports that Open, High, Low and close data to an excel sheet- with each O,H,L,C value assigned to a cell in an Excel spreadsheet such as A1-A4. Is this possible to do within the capabilities of trading view? Thank you for your consideration.
We need an entire domain to be scraped. The domain has around 1 million links. The domain is well protected by CloudFlare. You can do this manually or automatically. I need every single site belonging to the domain to be saved fully in html alongside its resources (JavaScript, images). You should also download any CSVs, Excel files, Word files, or PDFs in the domain. This should be seriously completed, within a few days. We are looking for competitive people. You will need to provide a sample of 100 pages before assigning the project to you.
Need to have remote access (google chrome remote) to access. able to key in data entry into software able to do some simple tabulation in excel voluminous data that needs to be entered meticulously into software and Excel, and all the data is comprised of text and numbers. To streamline the process, I need the data to follow a specific structure. Here's what to expect: - Entering Text and Numbers: The bulk of the project involves keying in text and numbers. You need to be accurate and prompt with every task. - Data Structuring: To make things simplified and meaningful, the data needs to be categorized appropriately into specific sections. This might require a keen eye for detail and the abi...
...seeking an expert in Excel and Visual Basic for Applications (VBA) to design a program that accomplishes three core tasks: 1. Report Generation: Create dynamic reports to track project progress. 2. Excel Automation: Boost efficiency by automating data entry from an external database( microsoft access) 3. Advanced Calculations: Leverage Excel's calculation capabilities to process data efficiently. Ideal freelancer should have extensive experience in working with VBA and understanding of database management. Familiarity with data analysis, automation, and report generation is key to this project. Your ability to create a system that can accurately fetch data from an external database and utilize that data within Excel is par...
...into Excel for the purpose of data analysis. - File Quantity and Structure: The project involves 1-5 PDF files. The structure of the tables within each document is mostly similar. - Data Type: The data includes complex tables with embedded formulae which need to be retained during the transfer process to Excel seamlessly. Designed schemas will not only enable easy data reading but also facilitate convenient manipulation while maintaining the data's accuracy and integrity. Skills and Experience: - Advanced Excel skills, especially in dealing with formulae - Proficiency in data migrating across different formats - Data analysis capability - Attention to detail and accuracy Job 1. Convert DAR 2023 Volume I and II (Sub-Heads 1 to...
I'm in search of a meticulous individual with advanced proficiency in Excel for a data entry project. Below is a precise rundown of my needs: - Input large volumes of text and numerical data into an Excel sheet. - The spreadsheet to be completed will contain 11 or more columns. - Both specific ordered data entry and random input will be required. Ideal Skills: - Solid expertise in Excel. - Exceptional attention to detail. - Ability to work with large data sets. Make your bid if you are adept at handling data entry tasks of this size and complexity.
Only Bid If You Done It Before I want to build an automated site (end to end) that offers removalist service (including design, development , hosting, etc.) This site will ask about the source, the destination, the required date/time, the items to be moved and it will set a quotation from an excel sheet that I will provide. it will require a deposit payment and will send the receipt. Please Submit Samples of Your Prior Work.
I need a freelancer for transcribing apparel sizes onto an Excel database. This is task has a high priority so a timely turnaround is needed. The excel database is created with all the employees and garments. Scanned PDFs includes handwritten notes of measurements of the people and the size they use. The task consists in writting in excel such information. It is quite straight forward. Happy to pay a bit more for a quick delivery (24 hours). Database includes 250 records. Expected time required 6 hours. Please it is important that the info is properly transcribed. Attached the output excel database, and an example of the handwritten notes. Many thanks!
...hand-in-hand with our dedicated automotive clientele. What You'll Do: You will be at the helm of the electrical components, driving their lifecycle from conception to integration. Your key role will involve collaborating closely with suppliers and delineating the component specs. Bridging the gap between suppliers and project teams will be a significant part of your responsibility, ensuring the quality and punctuality of deliverables. Immersing yourself in systems engineering principles, you'll be pivotal in the evolution and integration of components. Responsibilities: • Take full ownership of the electrical component lifecycle, from inception to integration. • Collaborate intimately with the technical systems delivery team and customer stakeholders. &...
...numerical into an Excel document. Key Requirements: • Experience in Data Management: The project involves working with both text and numerical data. Therefore, experience in managing, sorting, and filtering diverse types of data is absolutely necessary. • Excellent Knowledge of Excel: A high level of proficiency in Excel is paramount. Familiarity with various Excel functions, formulas, data visualization tools, and pivot tables will be helpful in executing this job proficiently. • Categorization Expertise: The data needs to be organized by categories, and this task requires someone who can demonstrate expertise in categorizing data effectively. I anticipate the data being divided into more than 10 categories. Therefore, the ability...
I require a reliable professional to assist with spreadsheet data entry sourced from PDF scanned documents. This task requires accuracy and attention to detail as the information will be utilized for important analysis and reporting. - Ideal Skills and Experience: - Proficient in Excel or similar spreadsheet software. - Experience in data entry from scanned documents, particularly PDF format. - Strong typing skills, emphasizing precision. - Ability to read and interpret various types of documents. - Proven ability to work with confidential or sensitive information. Please quote efficiently considering the complexity of data extraction from a PDF scan. I look forward to working with a diligent and meticulous individual on...
Looking for an experienced data scraper to extract and compile data from public sources into a designated Excel spreadsheet format. The spreadsheet has 9 columns comprising of information such as Private Lender, Mailing Address, State, Zip, Site Address, Loan Amount, Transaction Date, and Purchase Price. While the source of the data hasn't been specified, it's understood it will come from public databases. Ideal Freelancer: - Extensive experience in web scraping and data extraction from various sources. - Proficiency in Microsoft Excel for the precise structuring and formatting of data. - Attention to detail, ensuring all data points are accurately covered. - Able to handle unspecified data sources. Note: While skills or tools weren't sp...
...consists of taking an existing Excel calculator that performs a range of calculations including simple arithmetic (addition, subtraction, multiplication, division), statistical values (mean, median, mode), and financial computations (interest, loan repayment) and converting it to a PHP-based web calculator. Key Requirements: - In-depth knowledge of PHP programming - Able to emulate Excel's calculation methods accurately in PHP - A good understanding of basic arithmetic and statistical calculations, and financial calcualtions is essential - Solid experience with UI/UX design to ensure the calculator adopts a basic and clean design - Must be able to complete the project ASAP The successful freelancer should have proven experience in converting ...
I'm in need of a Laravel developer with approximately two years of experience and a proven ability to create APIs. This project has the potential to expand to more work if I find the right candidate. Here's what I'm looking for: - Laravel Developer: Your gravitas should be developing Laravel projects. Previous work on applications such as E-commerce websites, Blogging platforms, or CRM systems is a major plus. - Frontend Development: It's unclear yet whether you will need frontend development skills in addition to your backend expertise. Don't let this deter your application if you excel on the backend. - Design Capabilities: I might need help with project design or refining wireframes, so any experience in this area would be b...
I require a skilled coder to design a robust program that can accurately track and record the speed of race-horses at specific intervals while streaming a race online via my computer. The key responsibilities include: - Developing a program that can analyze video content - Ensure accurate speed tracking at specific intervals - Generating a table in Excel to display captured speeds Ideal candidates should have a solid background in programming and experience with speed detection technology. Previous work with video content analysis is highly desirable. The candidate should also be familiar with creating and handling Excel spreadsheets.
...documents. One will need to be converted into Microsoft Excel and the other converted into Microsoft Word format. The scope of work is as follows: - Convert one PDF file into an Excel document. Formatting similar to the existing PDF document must be maintained in the Excel file. This includes all text, numbers, tables, graphs, forms, etc. - Convert specific sections/pages of the same PDF file into a Word document. Details on which sections/pages to convert will be provided during project discussion. Ideal Skills for the Project: - Proficiency in converting PDF to Word and Excel while maintaining the layout and format. - Attention to detail to ensure accurate and precise data is extracted. - Ability to mee...
I require assistance with creating a custom Excel KPI document for my business to track crucial performance indicators like Sales Revenue and Productivity. Expertise in Excel along with an understanding of KPI tracking is necessary for this project. Specific requirements include: - The KPIs of focus are Sales Revenue and Productivity. - The data or metrics we need to track include Monthly Sales Revenue, Quarterly Sales Growth, Employee Productivity and Project Completion Rate. - All sales revenue data should be represented as a Bar Chart in Excel. As such, the ideal freelancer should be proficient in Excel formulas and charts creation, and have previous experience with KPI tracking and reporting documents. Understanding of business performance ...
...who can provide a solution for automating the creation of weekly MIS reports using Excel. The selected candidate will have: - Expertise in Excel and data manipulation - A deep understanding of sales data - A proven track record in automating data reporting tasks Tasks will include: - Understanding my sales data structure and reporting needs - Designing and implementing a process to extract significant data - in this case, Revenue, from my Excel sheets - Setting up an automatic report generation mechanism This project will require a tool or macro that can generate these reports on a weekly basis, without fail. The tool or macro should be straightforward to use and should effectively sort and analyze the data to produce the desir...
I'm seeking the expertise of an Excel pro who can whip up a complex formula to accomplish three main calculations: Sum, Average, and Count. This formula must be applicable not just to a designated range of cells but to an entire sheet. To make it even more challenging, the formula should be set to auto-update with each change in value regardless of cell. Here's what the ideal candidate brings to the table: • Advanced Excel skills, including creation of complex formulas • Experience in setting auto-updates in Excel based on cell value changes • Ability to ensure flawless application of the formula to an entire sheet The complexity of this task calls for an individual who isn't just...
We have about 1000 orders per month. Looking for a book keeper to constantly record cost and perform profit analysis on a monthly basis. The cost consist of 2 parts. Dropship - which we will be sharing excel with order number for vlookups. In-stock ships, which we can develop a standard cost. Besides recording, will also need the individual to check our bank statements ensuring receivable and debits are exactly as invoiced.
Looking for a proficient freelancer to convert a PDF document that contains detailed P&L information into an Excel document. There's no specific expense, revenue, or net income data that need to be targeted; I need all the financial data to be migrated. Formatting the Excel document isn't necessary. Your application should include: -Your past relevant work -Your experience in similar projects -Detailed proposal: state what your plan of action would be for this project Ideal candidate should have experience in working with financial documents, specifically P&L statements, and expertise in Excel and data extraction.
...freelancer who can assist me with the data entry from physical documents into MS Excel. Specifically, I need someone who can accurately and efficiently enter data from physical documents into an Excel spreadsheet. Requirements: - Proficiency in MS Excel and data entry - Attention to detail to ensure accurate data entry - Ability to work efficiently and meet deadlines Ideal Skills and Experience: - Previous experience with data entry from physical documents - Familiarity with Excel formulas and functions for data manipulation and organization - Strong organizational skills to ensure data is entered accurately and consistently If you are a detail-oriented individual with experience in data entry and MS Excel, I would lov...
...for someone who can help me create a pivot table in Excel. This pivot table will need to bring data from one table and import it into another. The data I am working with involves Excel spreadsheets and falls under the umbrella of Product data. Ideally, the freelancer tasked with this project will have a keen understanding of Excel and pivot tables, be able to understand and organize data effectively. The pivot table should produce the following: - Show data grouped by product categories - Demonstrate an understanding of how to work with and manipulate Excel spreadsheets - Create an organized and easy-to-read pivot table The ideal freelancer for this project should have the following skills and experience: - Excellent knowl...
I am seeking a api excel query editor to convert a Postman API call into a Microsoft Query Editor. you need skills in Excel, API utilisation, and Microsoft Query Editor. YOu can see query working in Postman scripts (we have so you can import).
I'm in need of an Excel formula expert who can help streamline my data analysis process. This project revolves around employing Excel formulae to automate tasks, specifically focusing on compiling and analyzing data. Key Requirements: - Involvement in building Excel formulae for data analysis. - Proficiency in automating tasks using Excel. Expected Outcome: - The desired result is the creation of an Excel formula that effectively automates the process of compiling and analyzing data. Your task would be to develop a formula which can handle large datasets with ease and deliver accurate results. Please, note that experience in similar projects and a deep understanding on how to manipulate and analyze data using Excel...
Local SEO.............I am looking for a freelancer who can evaluate and correct issues on my website using diib key performance metrics. I need my site to rank number #1 in my local city. I need my website scanned and all SEO issues fixed so my site rank better and has better domain authority using white hat techniques I prefer that you are experienced with or a similar website to scan for errors
...include basic management, but also the following: - Innovative Content Creation: Being able to create engaging posts that resonate with our various target audiences. - User Engagement: Regularly interacting with followers in a manner that encourages engagement and brand loyalty. - Performance Analysis: Monitoring and analyzing campaign performance regularly, optimising strategies when necessary to improve results. - Growth Strategy: Devising and implementing a strategy to grow followers and reach organically. Our target audience includes: Millennials, Parents, Business Professionals, College Students, and residents of San Diego. Therefore, an understanding of these demographics would be beneficial. To excel in this role, you should have relevant expe...
I am expecting high-quality work on this project that deals predominantly with Excel data manipulation. You'll be tasked with defining and implementing Excel formulas and functions, specifically data lookup and reference functions. This project has one primary purpose: to enhance the user experience for my team as they work with complex datasets. This is a unique opportunity for someone with significant experience in Excel (particularly in crafting data lookup formulas) to apply their skills. Strong attention to detail and an analytical mind are certainly appreciated.
...interest due quarterly with varying origination dates. This line item will be inserted below the Land Sale Infrastructure and Operating Cost. 3. Release values and lot data for each of the development areas will be calculated from the provided lot data. 4. Expenses will be calculated across phasing areas and will be allocated per lot. 5. Line items are rounded to the nearest dollar. III. DELIVERABLES: a. A proforma spreadsheet similar to the provided “SAMPLE PROFORMA V1 2-15-24” spreadsheet with modifications outlined in the Scope of Work....
...can design a comprehensive project tracker/dashboard within an Excel format. The purpose is to be able to clearly track and monitor over 60 different projects in active, future or completed stages. Key features that need to be included are: -Project name -Description -Resource allocation (specifying the departments involved - SCADA, Settlements, Operations, Metering, Control, Contracts, IT, Executive) -Status -Completion date -Notes -Charts/graphs for visual representation of project progress The way we organize resource allocation within projects is crucial. The ideal candidate must have a solid understanding of project management and data visualization, with past experience on related projects being a plus. Proficiency in Excel, including advanced...
I am looking for an Excel expert to enhance the functionality and automation of my present personal financial budget workbook. This upgrade is necessary to improve the accuracy, convenience, and efficiency of interacting with my financial data. Your responsibilities will be: * Improving overall functionality for a smoother user interaction. While automating some processes was not specified, the enhancement should focus on making the workbook more efficient, reducing the time and effort needed to key in financial data. Ideal individual should: * Be proficient with Excel * Have prior experience in projects requiring similar Excel enhancements. * Be able to offer suggestions for further efficiency improvements. * Be meticulous and detail-ori...
Hi, basically this is what I need An excel workbook that can capture weekly times worked by various different employees and various projects I have about 6 employees, needs to allow to add one or two more just in case And we work on around 5/6 projects every week I need to be able to record each day, each employee, one or two different project entries, add up the hours And then at the end of it all I need to have a summary page for that week, which includes the employee and all the different hours he worked for that week Should be simple enough I think, for someone who knows pivot tables well I will give you the project names to start and the employee names
...dropshipping business. Your responsibility will not only be sourcing the best products but also providing thorough research to back your findings. The particular details you would need to provide include: - Revenue potential - Competition level - Customer demand - Keyword difficulty - The top 5 countries for each product category or specific KW with search volume - PPC costs - Supplier links for these products The information on revenue potential, competition level, and customer demand should be obtained by analyzing market trends and consumer demand levels. The criteria for assessing keyword difficulty and search volume are: - Average monthly search volume - Relevance of keywords to the product's niche Required skills: - Market research - Competitor ...
...proficiency in Excel macros to carry out two specific tasks on trading data related to the stock market and cryptocurrencies. TASKS: - Data Analysis: I need to analyze the heavy trading data I have. Therefore, I need someone who can build smart macros that won't just ease the process but would refactor my data into meaningful information. - Data Recording: Alongside analyzing, my macros should also enhance excel to record my trading data meticulously. IDEAL CANDIDATE: Having a good hand at using Excel for data-related tasks is very much expected. However, having experience in dealing with trading data and designing macros for the same will really set you apart. Looking forward to seeing applications from freelancers who ...
...project involves using SPSS to perform two core tasks. Firstly, I need a comprehensive dataset, currently only available in SPSS or SAS, exported into an Excel format for my personal study. Secondly, I'd like some basic statistical analyses run on this data. Experience in handling datasets with more than 1000 variables is essential for this task, as the dataset in question is extensive. Proficiency in SPSS is also a must for successful applicants. I'm particularly interested in freelancers with proven track records in similar data export and analysis projects. The dataset is from the CDC's NSFG - national Survey of Family Growth found here: . I'd like to the Female Respondent Data File exported to excel and I'd like to...
I'm seeking an experienced data analyst who can assist in visualizing my data through Power BI dashboards and Excel reports. What the Project Involves: - Creating visually appealing and easily interpretable reports using Power BI and Excel - The data sets primarily to be utilized for these dashboards are sales data Specific Requirements: - Track the following user behavior metrics on the Power BI dashboard * Click-through rates * Conversion rates * Bounce rates Skills and Experience Required: - Experience creating Power BI dashboards and Excel reports - Experience in working with Sales data - Ability to create meaningful and actionable visualizations - Background in tracking and interpreting user behavior data will be beneficial
I am in need of a proficient ind...entry tasks and assist me in organizing my Online sales data into an Excel file. Here are the essential project details: - The role primarily revolves around data entry and organization. - The required information to be entered and organized pertains to sales data. - The specific sales data details that need to be entered include the product sold, the sales date, and the sales amount. - An additional critical detail is the conversion of the currency to ILS (Israeli Shekel). The ideal freelancer for this job would have experience with: - Data entry tasks and Excel management. - Familiarity with sales data, specifically within the E-commerce platform. - Currency conversion within Excel or similar softwar...
I'm looking for someone who can assi...(between 100-500 sq ft). Key Job Requirements: - Developing a 3D layout design using professional tools like AutoCAD, SketchUp, and Revit. - Creating an excel sheet cataloging the necessary items with detailed specifications for each piece. Skills and Experience: - Expertise in AutoCAD, SketchUp, and Revit - Experience in office space planning and furniture layout design. - Knowledgeable about various office furniture brands as specific brands need to be incorporated into the design. - Excellent understanding of ergonomics and spatial design. - Strong attentiveness to detail when cataloging items in an excel sheet. Looking forward to working with a dedicated professional who can transform a medium-sized ...
In this project, the primary task would comprise extensive cleaning of text data in an Excel dataset. This dataset is impressively large involving more than 5000 rows and columns. Specifically, areas that require intervention are: • Correcting typographical errors and incorrect spellings • Removal or replacement of irrelevant characters or symbols • Addressing inconsistencies in capitalization Ideal candidates for this job would have: • Proven experience in advanced Excel data cleaning • High level of attention to detail • Ability to handle large datasets • Proficiency in English for precise correction of typographical errors Your job would be to comb through the dataset and systematically eliminate these err...
I am seeking a meticulous freelancer for a data entry project, which involves both...meticulous freelancer for a data entry project, which involves both text and numerical entries. While there isn't a specific format or template to adhere to, I expect neatness and high level of accuracy. With the software for the data entry not specified, it would be ideal to have a candidate that is well-versed in a variety of programs including Microsoft Excel, Google Sheets, and other similar data entry software. The successful freelancer should ideally possess the following: - Proficiency in data entry with a keen eye for detail - Flexibility with various data entry software - Ability to handle text and numerical data entry - High level of accuracy - Ability ...
I'm in need of a skilled graphic designer to create a unique, watercolour-style logo and banner design for my online store. This is an exciting opportunity for creative minds who excel at transforming concepts into meaningful visuals. Here's a bit more about what the project entails: - Develop a logo in a watercolour style with images that I will provide - Preferred colours: dark ccolours, black and grey Ideal skills and experience for the project: - Proven experience in logo design - Strong portfolio featuring watercolour-based designs - A keen eye for color pairing - Creativity, originality, and strong visual skills If you have these skills and experiences, I would love to hear from you. This project has the potential to lead to more work ...
...freelancer who can assist me with the data entry from physical documents into MS Excel. Specifically, I need someone who can accurately and efficiently enter data from physical documents into an Excel spreadsheet. Requirements: - Proficiency in MS Excel and data entry - Attention to detail to ensure accurate data entry - Ability to work efficiently and meet deadlines Ideal Skills and Experience: - Previous experience with data entry from physical documents - Familiarity with Excel formulas and functions for data manipulation and organization - Strong organizational skills to ensure data is entered accurately and consistently If you are a detail-oriented individual with experience in data entry and MS Excel, I would lov...
For my company, I am searching for a highly competent freelancer or organization to design a MySQL database. My requirements are as follows: - The first priority is to be able to securely store and retrieve data efficiently and effectively. We're dealing with over 500 tables and data points, so the design must be optimized for extensive data handling. - Second, the database should be capable of analyzing the data and generating reports. Thus, applicants with a strong background in data analysis will have an advantage. - Last but not least, the system must integrate perfectly with our existing systems to allow smooth data transfer and operation. Skillset and Experience: - Proficient in MySQL DB design, data modeling, and optimization - Skilled in ...
My goal is to build a basic application that can pull website data and Excel information, and eventually transition into a SaaS product. The app will not merely pull the data, but it will showcase it in visually interesting and interactive ways. I'm seeking professionals with following requirements: - Strong skills in app development and data integration - Experience in working with Website data and Excel - Proven expertise in creating charts, graphs, interactive visualizations, and dashboards The project timeline is aggressive - I need completion as soon as possible. If you have the skills and ability to commit to a fast-paced project, I'd love to hear from you.
I need a highly skilled and experienced professional to handle my eBay listings. This includes: - Creating product listings: You'll be expected to accurately craft product listings that not only showcase the items effectively but are also appealing to potential customers. - Optimizing product descriptions: I'll need you to ensure every product description is fully optimized. - Managing inventory: You'll be responsible for inventory control, including monitoring stock arrival, tracking inventory levels, and proactively addressing any stock issues. - Image Editing: You must be proficient in using Image Editing Software to create appealing product images. - Pricing & Updating Items: Part of this job involves competitively pricing it...
I'm currently utilizing Excel 2016 in which I've integrated a substantial amount of customer data. The project requires the expertise of an individual with in-depth knowledge of Excel formula creation. Key responsibilities will include: - Crafting customized Excel formulas to efficiently process and analyze a wide variety of customer data Skillset and Experience: - Proficiency in Excel 2016 is mandatory - Proven experience with crafting Excel formulas - Proficiency in managing customer data effectively and efficiently for better analysis Please note that error fixing and optimization tasks are not part of the project. I solely need you to focus on creating unique and efficient formulas tailored to my needs and dataset.
