Vba excel speed optimization jobs
...rectify database errors, and resolve configuration conflicts for seamless operation. My approach involves meticulous analysis and targeted solutions to ensure optimal performance. Past projects demonstrate my proficiency in Magento 2 optimization, database management, and problem-solving. Trust me to elevate your store's performance and stability, providing tangible results. Let's collaborate to restore your Magento 2 store to its peak efficiency and functionality. Moreover, My experience in website, theme, plugin, extension development, speed optimization, Migration, version upgrade, and customization using M1 & M2 enterprise and community editions. I am sharing my profile for your reference. Kindly refer to the below attachment file. Magento 2 C...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...
I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases
I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...
I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...
...website. The specifics of my requirement include: - On-page optimization: I need my website to be enhanced for better rankings. Tweaking the tags, meta descriptions, and overall content is expected. - Keyword Research and Analysis: A detailed keyword report with the recommended action plan would be beneficial to tune the content more aligned with the desired audience. For the ecommerce part, I did not specify any particular functionalities, so an open-minded approach to this vertical is anticipated. The project does not have any specific timeline and a well-thought, quality-rich solution would be preferred over a quickly implemented one. Ideal freelancer should possess strong skills in WordPress SEO, experience with on-page optimization techniques, and good knowledge...
...in a B2B environment - Strong understanding of SEO with the ability to conduct keyword research - Ability to tailor content to a professional audience The successful applicant will need to understand the intricacies of B2B marketing and be able to craft compelling product descriptions that resonate with this particular audience. This will involve a blend of strong copywriting skills and SEO optimization. Tasks will include: - Conducting keyword research and integrating these into the product descriptions - Writing engaging, professional, and accurate descriptions that highlight the features and benefits of our products - Ensuring all content is original, error-free, and consistent with our brand voice and style. Overall, I'm looking for someone who can bring a fresh and...
I'm looking for a skilled video editor to help me enhance and edit my video reels for Instagram. Ideal skills and experience: - Proficient in video editing for social media content - Creative with a keen eye for detail - Ability to engage an audience through dynamic edits The primary goal is to create compelling and engaging reels that can attract and re...audience. The editor should have a good understanding of Instagram's video guidelines and best practices. Key tasks include, but are not limited to: - Enhancing footage through editing techniques - Ensuring the reels are optimized for Instagram in terms of length, quality, and format - Adding text, captions, and other elements to enhance engagement - Providing suggestions for improvement and optimization based on th...
My store is a Magento 2.3.4, it was working perfectly and for some time it has been very slow, sometimes I can't even make changes within the admin because it crashes, generating useless files and tables. I'm seeking a Magento expert to optimize my Magento 2 store which is currently facing performance issues, database errors and configuration conflicts. Your main responsibilities will include: - Improving slow performance: My website is running slowly, and I need you to identify the bottlenecks causing the slow performance, and fix them efficiently. - Fixing database errors: We are experiencing database errors that need to be addressed promptly to ensure smooth operations. - Resolving configuration conflicts: There are conflicts in the configuration which need to be resolved to...
I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...
In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...
As an established business, we are in the market for a seasoned SEO expert or agency who can help us optimize our React-based website for improved search engine visibility. Key Project Details: - Past SEO Efforts: We have previously invested in SEO efforts, and now we are looking to take our website to the next level. Your work will be building upon what we've already achieved. - Target Audience: Our target audience is broad, including both the general public and B2B businesses. Your strategies should be able to cater to both types of audiences. What We Aim to Achieve: - Increase Organic Traffic: One of our primary goals is to enhance our organic traffic. Your SEO strategies should be geared towards attracting relevant, high-quality traffic to our website. - Enhance Keyword Rankings...
I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?
My Excel file is very heavy and unorganized. I want it to get cleaned and effecient
I'm seeking a skilled developer to convert Figma designs into a WordPress blog. This task will require: - Strong proficiency in WordPress development - Knowledge of Figma - An eye for blog design will be advantageous Key website functionalities include: - Social media integrations - YouTube integration without autoplay - Implementation of Cookies, AdSense - SEO optimization - Easy mechanism for copying and pasting content. The website will host many blog posts as I'll be uploading AI-generated content often. If you're this person, I'm excited to work with you! IMPORTANT: Good communication skills are required as we will be discussing how the blog will be, its features, functionalities etc. Please ask any questions you have.
...BY Freelancer, but I found it might be usefull. = SPEC-01: AI-Powered Auto-Broker Application Development - MVP == Background This project involves developing an MVP for an AI-powered buyers' agent auto-broker app using FlutterFlow and completing an existing partially completed app design(see images). Developer should be able to integrate existing tools and services to maximize development speed and cost efficiency, laying the groundwork for more advanced features in later phases. The app leverages the MarketCheck API for automotive data and employs AI technologies to enhance the car buying experience. == Requirements *Must-Have (MoSCoW Method)* - Continue development off an existing FlutterFlow project with provided screenshots. - Efficient data handling and querying...
As the owner of a website, I'm currently facing a sig...the owner of a website, I'm currently facing a significant issue relating to slow loading speed that's proving detrimental to my user's experience. I am seeking a skilled and knowledgeable webmaster who can handle: - Troubleshooting: Primarily, I need someone who can effectively identify issues that are causing my website to load slowly. - Speed Optimization: After pinpointing the problems, I need the webmaster to take actionable steps to optimize the speed. My desired target load time is between 2-3 seconds. The perfect freelancer for this project would be one having expertise in website troubleshooting and solid experience in improving website load times. Proficiency in site sp...
I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.
I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes
Your expertise will contribute to a cutting-edge project that combines music generation with voice cloning to create songs sung by virtual personas. We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Skills expected of you 1. Strong background in machine learning, deep learning, and neural networks. 2. Experience with audio signal processing and familiarity with audio data preprocessing techniques. 3. Proficiency in Python and experience with machine learning libraries such as TensorFlow, PyTorch, and Keras. 4. Knowledge of music theory and composition is a plus. 5. Exp...
I am looking for an experienced professional with proficient Thai language skills to handle pre-employment verifications. The main purpose of this project is to verify applicant information. While the specific details of what needs verification were not provided, it's safe to assume it ...freelancer for this job should have: - Experience in human resources or a related field. - A keen eye for detail to ensure all information is correct and up-to-date. - Excellent communication skills. - A strong command of the Thai language. Since the criteria for applicants to meet in order to pass the verification process weren't provided, you should be prepared to verify a variety of information. Speed and accuracy are crucial for this project, so being able to work efficiently under...
I'm looking for a talented sales and marketing professional who can help me boost brand awareness an...through effective marketing campaigns - Utilize social media, email marketing, and search engines to promote the brand and capture the attention of potential customers Key Skills and Experience: - Proven track record in successful brand awareness and lead generation campaigns - Extensive experience in B2B and B2C marketing - Strong understanding of social media, email marketing, and search engine optimization - Excellent communication and analytical skills - Creative thinking and problem-solving abilities If you have a keen eye for market trends and consumer behavior, as well as the ability to craft engaging and persuasive content for different digital platforms, I'd lo...
I'm seeking an expert in Azure cloud cost savings particularly with regards to the purchase of reserved instances for Virtual Machines. Through Azure Advisor Savings, I have identified an opportunity to potentially reduce total costs. As such, I'm seeking an expert's review and recommendation concerning this initiative. Key Responsibilities: • Review curr...current Azure Advisor Savings recommendation • Provide a comprehensive report justifying the necessity or otherwise of the reserved instances purchase • Recommend optimal configurations (if necessary) to maximize cost savings Ideal Skills and Experience: • Proven experience in FinOps, particularly on Azure Cloud • Expert knowledge on Azure VM Reserved Instances • Strong understanding of...
I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation
I need an expert in mobile-friendly design, specifically proficient in Wordpress's Divi Builder, to enhance the user experience of my website on mobile devices. It consists of one main page and two minor subpages. Freelancer should focus on: - Layout and Design: Create a minimalist design layout that aligns with the website's existing aesthetic. Knowledge in modern mobile-friendly techniques and trends is necessary. - Navigation and Menu: Ensure the website's navigation menu is accessible and user-friendly on mobile. This should include drop-down menus, links, and page transition. - Call-to-Action Buttons: Design and optimize touch-friendly call-to-action buttons, ensuring they are conveniently located and easy to engage with on mobile devices. One particular issue needs...
I need a digital marketing expert proficient in SEO and social media platforms, mainly Instagram and TikTok. Key Tasks: - Implement strategies to boost website traffic and generate leads or sales via SEO - Manage and optimize my Instagram and TikTok, ramping up activity and engagement Candidates must have a proven track record in SEO strategy execution and social media optimization, preferably with Instagram and TikTok platforms. A clear understanding of the latest industry trends is needed and creativity is a plus. Experience achieving significant lead generation and sales is a must.
I need a YOLOv9 face detection model trained for surveillance purposes. It's crucial that the model is optimized for high accuracy, even if it means that i...accurately detect faces in both indoor and outdoor environments. - Additionally, it needs to be able to detect people and vehicles. The final model needs to be suitable for both indoor and outdoor surveillance, which will require a good balance between accuracy and processing speed. Ideal skills for this project include: - Proficiency in YOLOv9 and related technologies. - Experience in training models for surveillance purposes. - An understanding of optimizing models for high accuracy without significant loss of processing speed. Please include relevant experience and suggestions for how you plan to execute thi...
I am in need of an experienced electronics and electro mechanics professi...building a digital textile printer tailored to our specific requirements. Key Project Details: - **Print Size:** The final print does not require high resolution and can look pixelated. - **Printing Speed:** The printer should operate at a medium speed. - **Fabric Type:** Primarily, the printer will be used for printing on cotton fabric. Ideal Candidate: - Proficient in electronics and electro mechanics. - Prior experience in building digital textile printers is a huge plus. - Understanding of printing on fabric materials, particularly cotton. - Ability to optimize the printer for medium speed without sacrificing quality. Please bid if you have relevant experience and can offer a tailored so...
I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.
I'm seeking a skilled database developer to help me successfully migrate my database from .NET Framework 4.8 + EF6 + AspNet Identity to .NET 6 + EF Core + Identity. The database size is small - less than 1 GB, but it's crucial that user data is meticulously preserved during this transition. Key Tasks: - Perform data migration without any data loss. - Ensure the user login system and roles functions seamlessly in the new system. Ideal candidate should have: - Proven experience in .NET Core and EF Core migrations. - Strong attention to detail, particularly regarding user data. - Proficiency with user login systems in a .NET environment. Attached is the project source.
Need to amend to speed up the loading. Page load slow when heavy. Amend on the flow. (3 issues only) Able to follow one by one. Work with ftp and start immediately.
...the Shopify dropshipping site. As the owner, my primary responsibility will be maintaining of the website, while the selected manager will have complete autonomy over day-to-day operations. This includes, but is not limited to, product research and selection, supplier management, inventory management, order processing and fulfillment, customer service, marketing and advertising, and conversion optimization. In exchange for your expertise and efforts, I propose a profit-sharing agreement. I envision a split of 60% of the profits to us as the owner and 40% to you as the eCommerce sales manager. It's important to note that there will be no fixed salary or hourly rate; your compensation will be directly proportional to the sales generated by the website. This incentivizes both ...
As the owner of a brand, I'm looking for a skilled Shopify developer to turn my design into a functional e-commerce site. My main requirement is to prioritize user experience optimization and ensure that my customers have a seamless and effortless shopping journey. Here's what I need: - A Shopify page built from a specific design. - Strong emphasis on user experience optimization. - No requirement for multiple language support, just English. As an ideal candidate, you should have: - Extensive experience in developing Shopify sites from scratch. - A keen eye for detail to accurately implement my design. - Expertise in user interface and user experience design. - Proven track record in creating easy-to-navigate online stores. Get in touch if you can help me crea...
...in these three areas would get me there: - Keyword Optimization: Greater focus on researching, analyzing, and using keywords across my content to achieve higher rankings. - Backlink Quality: Increase the number of high-quality links directing to my website. Any proven techniques to improve our backlink profile are welcome. - Website Loading Speed: Ensure my website is running efficiently and quickly. Need help to identify and resolve speed issues contributing to lowered search rankings. The ideal freelancer for this project should demonstrate an excellent grip on SEO, skilled in technical SEO audits like backlink analysis, developing SEO strategies, improving website loading speed, and a track record of successful keyword optimization. I need thes...
summarize in a specific table in Excel
I am in need of an experienced ad campaign specialist to create and manage lead generation campaigns on Facebook...am in need of an experienced ad campaign specialist to create and manage lead generation campaigns on Facebook and Instagram. Key Responsibilities: - Develop, execute and manage lead generating ad campaigns on both Facebook and Instagram - Efficiently utilize budget to reach a global audience - Implement strategies to target ideal customer demographic - Provide consistent monitoring and optimization of campaigns Ideal Candidate: - Proven experience in running successful ad campaigns on social media platforms - Deep understanding of lead generation strategies - Proficiency in targeting ads to a global audience - Excellent analytical skills to measure campaign effe...
...interfaces with React.js. Key Responsibilities: Develop and implement backend services using Node.js and Express.js. Design and develop user-facing features with React.js. Collaborate with the team to understand project requirements and deliver solutions accordingly. Write clean, maintainable, and efficient code. Ensure the technical feasibility of UI/UX designs. Optimize applications for maximum speed and scalability. Implement security and data protection measures. Required Skills: Proficiency in JavaScript. Strong experience with MongoDB, , React.js, and Node.js (MERN stack). Familiarity with front-end technologies such as HTML5, CSS3, and Bootstrap. Experience with version control systems such as Git. Knowledge of authentication and authorization mechanisms. Excellent prob...
Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...
Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word
...who can assist me in fixing my tracking issues. I've already installed the Pixel on my WordPress website, however, it seems that the events aren't tracking as they should. Key requirements: - Troubleshoot and fix tracking issues: I need you to ensure that the Pixel is correctly tracking the events that I've specified which include page views, add to cart, and purchases. - Recommendations for optimization: I'd appreciate it if you could also provide me with some advice on how to optimize the tracking for better performance. - Experience with a wordpress/Woocommerce website using 'Facebook for WooCommerce' plugin Ideal Skills and Experience: - Proven expertise in Facebook Pixel: You should have a strong understanding of how the Facebook Pixel opera...
I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...
I need an experienced Social Media Strategist to run a Facebook promotion for my business as a Live Stage Hypnotist. The primary goal is to generate leads, targeting Corporate events, Comedy clubs as well as College campuses. Ideal Skills: - Expertise in Facebook Ads - Lead generation strategies - Experience in pr...primary goal is to generate leads, targeting Corporate events, Comedy clubs as well as College campuses. Ideal Skills: - Expertise in Facebook Ads - Lead generation strategies - Experience in promoting performing arts - Targeting multiple demographics - Experience in event marketing Your capabilities should involve comprehensive audience targeting, ad creation and monitoring ad performance for optimization. Proven experience with similar clientele will be highly adv...
I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...
I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.
...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...
I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks
