Advanced excel and vba jobs in bangaloreJobs

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

...our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...

I'm in search of a skilled professional with JEST experience to help me create thorough JEST Test classes for my highly complex Lightning Web Components. Key Requirements: - You should have experience in JEST test writing, particularly for Lightning Web Components - The tests you write should focus on ensuring the functionality of these components - The complexity of the components demands that you employ advanced testing strategies - Your tests should aim for integration with other components/services You should have an eye for detail, and be able to provide comprehensive coverage, making sure the components function correctly and interact well with other pieces of the system. Your task will be to write test classes that will provide me with ...

...creative and skilled freelancer to design a video invitation card for a special event I am planning. The video should radiate elegance and class, appealing directly to my friends and family. The successful candidate should be excellently adept at: - Graphic Design - Video Editing - Animation The inclusion of the following elements is essential: - A well-crafted personal photo collage that will touch hearts - Animated text that adds a touch of class and uniqueness - Choosing or creating a befitting music or voiceover that complements the overall feel of the video It would be highly advantageous if you have prior experience creating similar video invitation cards, particularly ones that incorporate classic style elements effectively. Proven skills in ...

I am in need of an experienced video editor to help me replace a face in 4-6 scenes of my video with another face. The ideal candidate will have a good eye for detail and the ability to make the replacement look as natural as possible. Key Requirements: - Replace face in 4-6 scenes - Make sure the replacement looks natural - Deliver high-quality video editing work Skills & Experience: - Proven experience in advanced video editing - Familiarity with face replacement techniques - Ability to seamlessly integrate new face into scenes - Strong attention to detail Please provide examples of similar work you've done in the past. I'm looking to hire someone who can deliver high-quality work within a reasonable timeframe.

I'm looking for a ...specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with ...

I require a skilled digital photo editor who can transform an iPhone-taken picture into a polished 24x36 inches print photo. The work involves some vital tasks: - Enlarging the iPhone...24x36 inches print photo. The work involves some vital tasks: - Enlarging the iPhone photo to 24x36 inches without sacrificing the quality of the image. - The photo needs color correction to make it more vibrant and appealing for print. - Image sharpening is also required to enhance the overall detail and make the photo appear crispier in the final print. Experience in using advanced photo enhancing tools and software is a necessity. Familiarity with producing high-resolution, print-ready images is an added advantage. Looking forward to a beautifully finished pro...

I require a highly skilled computational fluid dynamics expert to perform a meticulous fluid ...requirements of this project include: - A deep understanding of fluid dynamics, notably turbulence. - Proficiency in using advanced simulation software. - The ability to precisely identify flow patterns. Key outcomes of this project include: - A comprehensive identification and analysis of flow patterns within a turbulent system. Ideally, the freelancer should have: - A background in Computational Fluid Dynamics, particularly turbulence. - Extensive experience with fluid flow simulation. - Detail-oriented analytical skills. Ultimately, this project aims to reveal insights into turbulent fluid flow patterns, providing valuable information for fu...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Est...

Transform my basic, education-oriented PowerPoint slides into something simple but visually engaging. Your task involves: - Reimagining the slides to have a strong visual impact which can effectively educate an audience - Creatively incorporating cool tones, blues and greens, into the design while keeping it professional - Balancing intricate design details with clear, readable information presentation Ideal freelance applicants should have advanced skills in PowerPoint design and an understanding of color theory. Experience in creating educational content will be highly beneficial. I am looking forward to seeing your creativity shine.

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

...can take my raw footage and turn it into a polished, professional commercial video. I know for many of you might not be the winner. It's just the nature of the contest. I suggest not to waste your time and effort, if you are not very good or don't have much experience, or don't have good taste. For you, who would like to try, GOOD LUCK! I appreciate all your effort. I will make sure leave you a great review for you who win. What we need: 30 - 35 second video We are going to use the video for Youtube, FB & Instagram ads. Need the video in these formats: 16:9 , 1:1 & 9:16 More details of the project: Requirements: - Advanced editing skills, including color grading and special effects. The video

I need expert hands to rekindle the enchantment of my small, intimate wedding by enhancing less than 50 photos. The task entails advanced retouching, in particular skin smoothing and object removals. Infuse these photos with a soft, romantic aura to echo our love-struck day. Proficiency in Adobe Photoshop or similar photo editing software, coupled with a keen eye for detail and presence of sensibilities matching to this specific genre (wedding/romantic), is essential.

I'm on the hunt for an experienced sales professional with a p...the hunt for an experienced sales professional with a particular strength in client relationship management. Key Responsibilities: - Primarily, you will be handling the re-negotiation of contracts with our clients. Given the complex nature of this role, I require someone who has an advanced level of expertise in contract re-negotiation. Ideal Skills: - Advanced understanding of contract re-negotiations within sales - Previous experience in long-term client relationship management - Excellent communication and negotiation skills If you have a solid track record in improving client contracts while maintaining strong relationships, please bid on this project. Preference w...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am searching for a skilled video editor to create engaging content for my YouTube channel. The ideal candidate will have experience in a variety of editing styles, including documentary, podcast, cinematic, tutorials, vlogs, and montages. Requirements: - Strong command of advanced editing techniques - Ability to incorporate a range of styles seamlessly - Proficiency in color grading and audio enhancement - Experience with YouTube content creation Please provide examples of your previous work that demonstrate your proficiency in these areas. Your creativity and ability to engage audiences will be key in this project.

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm in need of a multi-user web portal that will facilitate the connection between trainers and students. The portal will have the following features: - **Multi-Login System**: There needs to be a seamless and secure multi-login system to accommodate both trainers and students. - **Search Functionality**: Users should be able to search for trainers or classes based on the city or trainer's name. This will make it easy for students to find trainers that are close to them or whom they may have heard of. - **User Profiles**: Each trainer or class should have a detailed profile which includes: - Biography: A brief description of the trainer and their training methods. - Reviews and Ratings: Users should be able to rate and wri...

...will cater to the needs of advanced-level programmers. Key Features: - The software should encompass all the essential functions required for an advanced C# developer including code editing, compilation, and debugging - The program must be user-friendly yet comprehensive to accommodate the intricate requirements of advanced users Skills and Experience: - Strong proficiency in C# programming is mandatory - Prior experience in designing and developing development tools is highly preferred - A solid understanding of Windows operating system is crucial The primary goal of this project is to deliver a highly functional, effective, and efficient tool for the advanced C# programmer. If you have a track record in...

...WHMCS module that will take my DNS management to the next level. This module should: - Offer comprehensive DNS record management capabilities - Provide advanced DNS zone management options In terms of the user interface, I'm looking for a blend of simplicity and modernity. So, the UI should be: - Simple and intuitive for users to easily navigate and use - Modern and sleek to align with the current design trends The key part of this project is integrating with a custom DNS service. This means the module will need to be: - Compatible with the custom DNS service I use (API) is available - Highly functional for smooth integration and operation Ideal candidates should have experience with: - WHMCS module development - DNS managem...

...integrated advanced machine learning capabilities. This project encompasses several core components essential for a robust, user-centric platform. Project Components: User Registration System: Develop a comprehensive and secure user registration and authentication system. Ensure scalability and seamless user experience. Live Chat Feature: Implement a resilient and real-time live chat system. Ensure high availability and responsiveness. Advanced Machine Learning Integration: Develop and integrate advanced machine learning algorithms to enhance user experience and platform functionality. Key machine learning functionalities should include: a. Recommendation System: Tailor user experience by recommending content or produ...

I propose comprehensive market research data collection services tailored to your needs. My approach encompasses meticulous data gathering from diverse sources, ensuring accuracy and relevance. With proficiency in qualitative and quantitative research methods, we deliver actionable insights to drive informed decision-making. Leveraging advanced tools and methodologies, we ensure thorough analysis of market trends, competitor landscapes, and consumer preferences. Let us empower your business with strategic data-driven solutions to thrive in dynamic markets.

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data manageme...

I am looking for an 2-d artist NOT LOGO DESIGNER to create a unique heraldic image for me(you will be provided with ref...DESIGNER to create a unique heraldic image for me(you will be provided with references). Please look at my attached example for reference so you can see my expectation both in terms of style and complexity. If you are interested, please send examples of your previous work for consideration. (You will not be considered without submitting examples of your previous work, it is not my job to go to your profile and search) Compensation is $50 cad! If this is not enough, I completely understand, no one should be asked to do a job for pay they don't believe is enough. All I ask is you simply don't apply, and instead apply for the ...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's succ...

...application. This project will tap into your expertise in various areas such as C++ programming, the QT framework, and user interface design. Key Skills & Experience: - Strong proficiency in C++ - Extensive experience with the QT framework - Excellent User Interface (UI) design skills - Knowledge in Python and 3D will be a plus The main function: 1: Windows platform, jointly developed by QT+python. 2: Communicate with hardware devices through serial port/Ethernet. 3: Support MODBUS-485, TCP, UDP and other communication protocols, with 1ms cycle response. 4: Support hardware parameter configuration, multi-channel data analysis, storage, data playback, and support real-time data curves at different communication rates. 5: Supports l...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with E...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic ...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practica...

...companies and other registered individuals. The key features will be user registration, job referral requests, and a unique credit system. Key Functions: - User Registration and Profile Creation: The site should allow users to create and manage their profiles, essentially forming a lively, interactive community. - Company and User Searches: Registered users should be able to search for companies and other users to request job referrals. - Job Referral Requests: A user should be able to send job referral requests to another registered user. - Credit System: A credit system where users earn points for referring others, which can later be used to apply for job referrals. It should also allow the credits to be purchased with real money. Ideal Ski...

...proficient in Python to build an advanced trading bot. The bot should be compatible with TradingView and capable of the following: - Generating buy and sell signals based on specified trading strategies - Implementing stop loss and take profit orders for risk management - Adapting to customizable trading strategies - Actually executing trades and proving profitable over time The ideal candidate should have: - Profound understanding of trading principles and market dynamics - Solid experience in developing trading bots and implementing complex trading strategies - Proficiency in Python and experience in integrating with TradingView - A track record of building successful, profitable trading bots This ...

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simp...

Develop macro-enabled Excel file to handle CSV

...Modify existing features and incorporate new functionality - Implement user authentication system to ensure data privacy - Create real-time notification system for immediate updates - Develop advanced interactivity for data manipulation and customization Desired Skills: - Proven expertise in PHP development, ideally with PHPMaker 2023 - Comprehensive experience in building Data visualization (Charts, Heat maps, Custom Dashboards) - Strong understanding of user authentication mechanisms - Ability to develop real-time features for immediate data updates - Experience in creating advanced interactive user interfaces In conclusion, the ideal candidate for this project should have a solid PHP background, exceptional experience in...

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF docume...

Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in...

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

...loading speed and provides irrelevant results, causing a less than ideal user experience. The existing search feature has been built using PHP. To improve the functionality and user satisfaction, I'm seeking a professional with vast experience in PHP who can implement critical improvements. - Autocomplete Function: For faster and user-friendly search queries, incorporate a reliable autocomplete function. Having this feature can save users' time and enhance the browsing experience. - Enhanced Filtering Options: Alongside the autocomplete feature, the search bar needs to have advanced filtering options to serve the most relevant results to the users. This will not only speed up the site navigation process, but also foster a posit...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...5-10 minutes demo video in Bengali. The video will be focused on explaining 'how 3D videos work best and help students memorize important concepts". This video will be used as an educational resource for students studying in Bengali. The animator should have experience in creating engaging and visually appealing 3D animations. The ideal candidate should be able to bring concepts to life through animation and capture the attention of the target audience. Add a few important and understandable topic from, Life Science, Physical Science, Geography, History, Maths, (Topic of Bengali and English if possible) Skills required: - Proficient in 3D animation software (e.g. Maya, Blender) - Strong understanding of character...

You are required to write a report of 2400 words or equivalent in the style of a journal paper on an advanced contemporary topic in computer science. Your report should have the form and the style of a research publication and should have at least 12 references from journals, refereed conferences and other resources Ideal Skills and Experience: - Experienced in report writing - Able to conduct thorough research - Capable of writing in an engaging and informative manner - Able to work with minimal guidance.

I'm in need of a highly skilled and advanced CISSP trainer for on-prem training in Kuwait. The training will be for a small group of 1-10 participants. The ideal candidate should be able to provide the following training materials: - Comprehensive printed manuals and handouts - Digital copies (PDFs, slides) for participants to refer to post-training - Practice exams and quizzes to help reinforce learning and assess understanding The trainer will be expected to travel to Kuwait for this assignment. Experience in providing CISSP training in a physical setting, particularly in the Middle East, would be a significant advantage. The ideal candidate should be able to deliver complex CISSP concepts in a clear an...

I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any questions.

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I'm in need of an experienced developer or agency to create a custom assessment platform, similar to Coderbyte/ Hackerrank tailored to my specific needs not limited, but similar to . Here's what I'm looking for: 1. AI-Generated Code Assistance** - **Smart Code Suggestions**: Implement AI algorithms that provide real-time code suggestions and auto-completions similar to tools like GitHub Copilot. - **Code Snippets**: AI can suggest commonly used code snippets based on the problem statement and context. - **Problem Solving Hints**: AI can offer hints or guide candidates through difficult problems without giving away the solution. - **Adaptive Learning**: Use AI to adjust the difficulty of questions based on the candidate's performance in r...

I'm in need of a skilled Zoho expert to help me with the following tasks within Zoho CRM, Zoho Books, and Zoho Inventory, as well as integrations with Xero, QuickBooks, and Shopify. Key tasks include: - Data management and organization: Assist in setting up efficient data management structures within Zoho CRM, Zoho Books, and Zoho Inventory to help streamline our operations and enhance our understanding of client interactions. - Reporting and analytics: Create custom reports and set up analytical tools to help us better understand our business performance, customer interactions, and inventory management in Zoho. - Integration with other platforms: As we operate on Xero, QuickBooks, and Shopify fo...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.