Excel access skills vba jobs

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

...will be result after lottery, should have access to do it. - External API Integration: The website should be integrated with: - Crypto payment gateways for seamless and secure transactions. - Email notification services for communicating with participants. - Real-time chat for maintaining engagement and providing support. - Metamask integration, although users should have the option to buy tickets without logging in. Admin Panel: - Should have access to make new lottery , modify lottery details (commissions, rewards, lottery time, how lottery will finish, payment address, which payment network) - Logs (payment success fail, hack tries) - See Lottary Pools and Modify results, - See Payments and Delete / Modify results Ideal skills and experience fo...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

...up role-based security for my application. The main goal of this is to ensure proper authorization across different user types. Here's what I have in mind for this project: - I need the system to restrict access to various functionalities based on the user's role. - The application will have three types of users: Administrators, Regular Users, and Guests. - Among administrators, I need a specific functionality for them to set up role permissions. Technical Requirements: - Proven experience with Spring Boot and security implementations. - Excellent understanding of role-based access control. - Strong knowledge of setting up and managing user roles. I'm looking forward to collaborating with a professional who can ensure the security and authorization aspe...

I'm seeking a skilled draftsperson or architectural designer to create c...doesn't have to be to scale at the moment. Ideal candidate has experience in landscape design and space planning. Key requirements for this project include the following: - Creation of more than 100 RV parking spaces illustrated in the drawing - Drafting access roads within the property for easy navigation - Integration of a 10-foot pathway within a 30-foot easement - Landscaping concepts for further visual appeal - Elevation details and cross sections (if possible) - Preference for gravel surfaces for both RV parking spaces and access roads Make sure to incorporate all these features in an aesthetically pleasing and visually coherent manner. Previous experience with RV parks or similar pr...

I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. Quiz manager: Implement a q...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

Idea is to be able to manage my current users in my dev cluster, most of them have cloudadmin permissions, idea is to have a whitelist of users, I will be providing you access to my API Keys and repo for this, also the whitelist based on the users email, I am using azure devops to do CI-CD Tasks, idea is to create a yaml file pipeline able tu run this process everyday at midnight.

...with the Tomcat module installed. As a result of this update, both my Wordpress websites and Java application are not working. When attempting to access the websites, a 503 Service Unavailable error is displayed. Key Tasks: - Diagnose the issue: Identify the root cause of the malfunction and provide a detailed explanation of what caused the websites and Java application to stop working. - Implement a solution: Apply the necessary steps to rectify the situation and restore full functionality to both the websites and the Java application. - Testing: Ensure that the fix is effective by thoroughly testing the websites and the Java application. Skills and Experience: - Profound knowledge of Webmin/Virtualmin/Cloudmin with the Tomcat module is essential to understand the impa...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and effici...

I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involve...particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task will be to fetch data, analyze it, and present it in a detailed, yet accessible manner. If you are able to deliver this work to a high standard, I will have further projects...

I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems

... This will resonate well with the target audience and reflect the nature of the services I provide. Distribution Plan: - The PDF will be used in a variety of situations, so it must be adaptable. I intend to: - Email the document to clients. The design should be compatible with and visually appealing in email format. - Make it available for download on my website. The PDF should be easy to access and view on a digital platform. - Print physical copies for meetings. The document should be designed with print quality in mind, ensuring that it looks polished and professional when physically distributed. To be successful in this project, you should have: - Proven experience in graphic design, specifically in crafting corporate documents. - Strong understanding of layout, typog...

We are seeking a highly skilled and experienced Data Scraping Specialist to optimize and significantly increase the speed of our current data scraping processes. The ideal candidate will have extensive experience in web scraping, advanced knowledge of bypassing anti-scraping measures, and proficiency in utilizing cloud-based solutions for enhanced performance. Strong problem-solving and hacking skills to navigate complex web security systems are essential for this role. Responsibilities: Analyze and improve existing data scraping scripts to maximize efficiency and speed. Implement and manage cloud-based solutions (AWS, GCP, Azure, etc.) for scalable scraping tasks. Develop advanced strategies to bypass anti-scraping measures like CAPTCHAs, rate limiting, and IP blocking. Ensure da...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visu...

...all across various websites most of which I’ve never heard of or visited. Also there’s nonstop access to my existing online accounts and noticing suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Knowledge of cybersecurity meas...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

...provide instant feedback on student applications, based on the integrated machine learning model. - User authentication: The application should include a secure user authentication system to ensure only authorized users can access and use it. - Data visualization: The application should have data visualization capabilities to help users understand the evaluation process and results better. Integration: - The application will need to integrate with existing systems or databases. The specifics of this integration can be discussed in further detail with the chosen developer. Skills and Experience: - Proficiency in application development, especially for desktop platforms. - Experience with integrating machine learning models into applications. - Strong understanding of user...

I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by compar...be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in...

Logo needed for brand offering fundraising services for charitable causes. Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with...

I need a tech-savvy professional with vast experience in social media account recovery. I lost control of my old Instagram account but I have the username. My main goal is to regain access and permanently delete the account. Key Responsibilities: - Recover lost Instagram account using the provided username - Delete the account upon recovery Essential Skills: - Knowledge and expertise in Instagram account recovery - Experience in similar projects - Understanding of privacy and data security protocols I can provide a driver's license as proof of identity. Confidentiality and transparency during this process are paramount, and I look forward to a successful collaboration.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

Please Sign Up or Login to see details.

I'm looking for a skilled Wikipedia editor to update a public figure's Wikipedia page with verifiable, online sources I will provide. Key Requirements: - Skilled Wikipedia Editor: You should have a proven track record of editing Wikipedia pages, ideally public figure pages. - Access to Online Sources: You will need to be able to access and incorporate the online sources I provide.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...

...a user-friendly interface for agents to manage calls and access customer information. - Provide real-time analytics and reporting tools to monitor performance metrics and track agent productivity. - Ensure the system is scalable to handle varying call volumes. - Provide ongoing technical support and maintenance for the dialer system. **Requirements:** - Proven experience in developing and implementing outgoing predictive dialer systems. - Strong knowledge of telephony systems and VoIP. - Experience with database management and basic CRM integration. - Ability to configure dynamic caller ID and IP whitelisting. - Proficient in managing multiple campaigns and supporting a minimum of 10 representatives. - Excellent problem-solving skills and attention to detail. - Ability to...

As part of my endeavor...will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of any potential vulnerabilities and security loopholes * Devise strategies to fortify the data security dimensions against malicious hackers The ideal candidate should possess: * Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the identified issues Rest assured, full access to the necessary systems will be granted for the successful execution of the job. Please note that a thorough professional background check will be perfo...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...

I'm looking for an experienced full stack developer to help me with a project. This role requires a professional who is well-versed in both front-end and back-end coding. i need someone with great experience to deploy my webesite, i will give access to my sourcecode

I'm having an issue updating my WordPress site plugins due to a checksum error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my websi...from updating plugins and downloading WordPress updates. - Ensuring the site complies with Consent Mode V2. - Conducting a thorough evaluation of the website to detect any other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential issues caused by uncertain changes to the site. I'll provide you with WordPress admin access so you can...

As I am looking for an experienced Android app developer, I have a vision for an educational app that helps learners to access educational content with ease. Detailed walk through will be provided on call as I have the front end concept simulation ready. However here are some... Key Project Features: - User login & Registration: We require a secure user login and registration setup that protects the user's data and ensures only registered users have access to our app. - Requires Map integration and working with object on a map (google maps/mapbox, etc). - Implementation of Modal screens. Ideally, the freelancer should have a robust experience in the development of Android apps. The freelancer should be well-versed in creating apps that offer user-friendly inte...

...logins required). An in-depth knowledge of planning submissions and permissions and BNG is NOT needed. What is however required is accurate information to be taken from those websites and converted into a database for us. - This work can be done remotely and only requires a computer and access to the internet. - The geographical focus of the UK planning authorities we require information from will be provided to you in a prioritised list This is a meticulous role that requires sound organizational skills, attention to detail and an ability to efficiently analyse and interpret information. Candidates with extensive experience in market research, particularly within the UK, are preferred. In short, we are looking for entries into a database, each entry is the identifica...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...

With our upcoming rock concert, we're in need o...experience with rock music is critical as you'll be balancing and mixing sounds for such a performance. - Sound Equipment: We've got the basics covered; you will have access to microphones, speakers and mixers at the venue. Your expertise on how to utilize these equipment to create the quintessential rock concert atmosphere will be key. Ideal candidate should have: - experience as live sound engineer, ideally with rock concerts. - comfortable level of skill in sound mixing and balancing. - Familiarity with the use and management of sound systems and equipment; microphones, speakers, and mixers. - Excellent problem-solving skills in live sound situations. Be part of creating an electric rock concert experienc...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

...responsive as I want it to be accessible across various devices, particularly mobile. Key Features: - User Registration and Login: A seamless and secure process for users to create accounts and log in. - File Upload and Storage: A functionality that allows users to upload and store files. This should include a system for easy access and organization. - Payment Processing: A secure payment system that enables users to make transactions within the app. Ideal Skills & Experience: - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with security protocols for managing user data and payment processing. - Strong knowledge of cloud storage and data management systems for file upload and storage features. - Prior experience deve...

...Provide a detailed CV highlighting your translation skills and experience * Be able to pass 's verification process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to access the account * Assist the client in understanding the features of the platform **Selection Criteria**: * Qualifications and experience in translation * Quality of CV and references provided * Ability to pass 's verification process with a valid translation certificate or degree * Competitive pricing for services offered **Additional Terms**: * The freelancer will have access to the account and will be able to use ...

1) Configure the OpenVPN CloudConnexa Client on TP-Link (OpenWRT) so that other CloudConnexa Clients can access the devices behind the router. For example (see attached image), CloudConnexa Client should be able to access and 92.168.17.20. 2) Document required changes in a README file.

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.

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 project is on targ...

This project involves cleaning up an MP3 audio file. Key requirements are: - Experience with audio editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio...editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio file has low quality (distorted or noisy) - Ability to complete tasks within deadlines - Experience with handling audio files of less quality like this one will be favorable - Should have access to high-quality audio processing and editing software to deliver optima...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...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 Excel/CSV data import fo...

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.