Excel VBA / Access / Power BI Consultant / Freelancer/ Programmer for Hire
Sometime its hard to find out if there is a better and quicker way of doing anything unlesss you meet an expert. With over 10 years of experience in excel automation, we at Upskill Technologies support businesses and individuals with their excel needs acrosss the globe.
If there is anything that you work on excel and you have these situations then you know its time to call us:
"Oooh! this is too manual, there should be some way out"
"Aaaah! You sure you have to type this all by myself!"
"Maaan! I need like 20 hours on top of 30 days to fix this formula!"
"I have been doing this reporting since last few days and I am still not done."
"Wow! Isn't this model suppose to give you a +ve number for profit!"
"We need a better system than excel. We just can't manage this now!"
"I saw a dashboard on the internet, can we use such for our business?"
"Is there a formula in excel which can do this?"
"Why dont we automate this and spend more time on other stuffs?"
"I think we can use Access somehow to make things faster"
Why to hire us:
We have a team of specialists who have a combined experience of over 25 years. We have worked in different industries for life on excel and we can not only complete the task but propose more flexibile solutions with our experience.
Our draft solution is absolutely free and you pay us only if you are satisfied with our work. So there is nothing to loose.
We offer our services at discounted rates. Our minimum rate per hour is as low as 10 USD.
We are avaialble 24 hours a day on skype, phone or email. As our esteemed customer you can call or email us anytime you need our support.
We have network of consultants who deal on other technologies. In future you need services on any platform we provide references you can bank on.
We respect each of our client and protect our customer's data. We are always ready to sign a NDA.
What have we done so far.
Automation of 500 odd invoice creation from a single excel source file.
Editing & consolidating 100 odd excel files and generating a report.
Updating weekly dashboard with data from websites and Ms-Access.
Creating Financial models with complex calculations.
Professional Dashboard automation which include pivots and charts.
Lead Management System.
Recruiter Tracking System.
Recent Automation Projects: If you have a similar requirement then you will be lucky to have an instant draft ready to review.
Project: Extracting email ids and relevant records based on hierarchy (Excel Job Support)
Date: August 2020
Client: Employee from an IT company (Infrastructure Projects)
Task: Looking up email ids of managers and extracting records for all the consultants under their hierarchy.
Requirement: Employee had a data source which has the information of all users and the assets they are tagged to. The task was to filter out all the relevant records using the list of managers and their email ids. Then the list of assets for each of the consultant reporting to these managers have to be filtered out and lot of information was supposed to be looked up from few mapping files. If manually done this task was taking around 6 hours with not more than 95% accuracy and this was a routine task which was required to be run every couple of days.
Solution: The employee was tied up in this task and he took our support to automate this task. All the steps he does manually were listed and we wrote a VBA code to do the same automatically. It was tested with many other files and then a bit fine tuning was done to get the required result. Thus reducing the time for the task to under 4 minutes freeing up more than 15 hours of work in a week.
Consulting Cost Total: 20$ (1500 Rupees)
Savings: Its always better to automate regular and mundane excel tasks. If there is a logic and particular steps followed in an excel activity then it can be automated easily and save huge amount of time. In this case 15 hours a week is a major thing for just 20$.
Project: Cleanup of contact names, email and phone records
Date: April 2020
Client: Major Diagnostic Service Provider in US
Task: Cleanup data from huge amount of records to have a valid record with information
Requirement: Owner of a major diagnostic service provider had huge volumes of data around a million records which has name of the company, email id and a phone number. But as the data was sourced from various methods it was not clean and there were too many errors like email id being invalid or phone number not in proper format and name of the company having some other issue. Also sometimes the data was mixed up like email id being in phone column and vice versa. The requirement was to clean up this list and remove all invalid records and fix any common errors to make the data more reliable and ready for use.
Solution: The solution was to write VBA code and run series of commands to do one fix at a time. As doing manually 1 million rows was out of scope. VBA code was written and first email ids were fixed. The code identifies any invalid email id and removes the complete row and moves it out to another sheet. The code then identifies phone numbers and fixes them if any issue and removes any invalid phone numbers. Using vba we removed additional spaces, special characters and such stuff from all the records and the result was a repository of a clean record which was ready for use.
Consulting Cost Total: 30$
Savings: Cleaning up names, email and phone records was easy with VBA and it took less than an hour to write the logic to clean the text.
Project: Trading Signal Application (Buy Sell Signal in Excel)
Date: Feb 2020
Client: Day trader majorly in Nifty Options
Task: Capture live cost of an option contract and apply a strategy and generate buy sell signal instantly.
Requirement: Client is a day trader who does swing trades in Nifty Options. He has over 10 years of experience in options trading and have many tested strategies in his Armour. All he was lacking is a system which would trigger a signal to buy/sell when all the conditions are met. The task was to read the live markets and pull in the various parameters related to price and volume into excel. It was required to have a continuous feed of data at the interval of each minute and then transform that data feed into candlestick to identify patters and to catch a particular one based on various parameters.
Solution: The broker client was using provided real time data via its browser based application but it was a challenge to capture this data into excel without having to pay for APIs. But with combination of VBA, HTML object library and Selenium this task was finally automated. Then in VBA programming was done to convert the feed into candlesticks and apply various conditions to trigger an alert when it's time to Buy or Sell. After lot of rigorous testing and eliminating false calls the system was able to deliver 95% of the time the desired output as per the Client's expectations.
Consulting Cost Total: 300$
Savings: Apart from savings on costly software subscriptions and unknown methodologies, our client was able to have a tool based on his knowledge and was able to have a much better outcome in trading.
Project: PowerPoint Automation Project
Date: Dec 2019
Client: A High-tech Education Institute
Task: Automate generating report card in a PowerPoint deck with student's test results and emailing them to email address.
Requirement: Client is a reputed global school which does monthly assessment of students on various parameters. Rather than sending a printed report card they wanted to make a separate PowerPoint deck for each student showing how their performance was along with some basic details. The results of assessment were captured in an excel file and lots of graphs are created from predefined template in excel. The excel file would house the data for all the students studying in various grades and having different sets of parameters for assessment. Once the assessment results are gathered a very manual process was involved to filter data for a particular student, make charts out of it and then paste these details into a PowerPoint deck. Then another expert would do a thorough check if all the files are fine and he/she would send it to email id of the parent with a customized message. This process involved spending 2 days of full time work for 2 employees. Moreover there were possibility of errors in this process.
Solution: This task was automated with VBA where the solution file would pick-up the excel sheet, filter data for a student, make a PowerPoint for the student with his/her details in tables and charts and stores it in a folder for each grade. Once sample testing is done by an expert on few of the files and approved by the authority then the files would be automatically attached to a customized email and sent to parents.
Consulting Cost Total: 200$
Hours Saved: 48 hours of monthly savings
Project: Excel Calendar Template
Date: Sep 2019
Client: Employee of an ITES working in ticketing environment
Task: To create an excel calendar template showing which refreshes every month
Requirement: Client works as a coordinator in the ticketing department where they record and analyze number of tickets received daily. He has to create the template every month by putting the correct formatting for weekdays and weekends also add a lot of calculation manually to give the score by each week. Moreover this particular layout was used for various reporting with slight modifications in place. Once the format is ready then the values for the particular date and by each representative has to be brought in from a flat file source saved on shared drive every day.
Solution: This task was automated with VBA where the file with correct formatting was generated only the 1st working day of each month and then another button was provided, the back end code of which would fetch details from the flat file and put it into each column for the respective reps.
Consulting Cost Total: 12$
Hours Saved: 22 hours of monthly savings (avg 1 hour per day reduced to 2 minutes or less)
Project: Automation of word templates from Excel Files
Company: Client from IBM
Task: To populate word file with data in excel.
Requirement: Client gets an excel file with 1000s of records for various project and occasionally a word template has to be created for a single project. The word template has fields which include the project name, function which it belongs to, contact details of the requestor, contact details of the approver, monthly volumes spent on the project, future projection for the project.
Solution: VBA code was written in excel where in an interface was provided to select the project and function. Based on the project and function the data gets filtered and using loops calculations and matching is done to get a summary of values to be pasted in word. Then the word template will be opened by VBA and the data gets pasted in blocks in the word file wherever required. This entire process happens in a couple of seconds and the word template file is saved and opened for the user to review.
Project: Creation of SLA Ticketing Tool
Company: IT company in Hyderabad
Task: Client handles IT tickets coming from various regions and a team of 20 people work on these tickets. Admin assigns a priority to the ticket and then assign it to one of the team members. The status of the ticket changes based on the progress. The TAT for each ticket has to be calculated based on the priority and when its closed the status should be updated automatically based on the TAT.
Solution: We created a file which works as a ticket application tool with forms. User gets option to launch forms for specific entry. A form to make an entry of a new ticket and another form to assign the ticket to the team member. The data gets stored in the table and the calculations are done using vba to decide the allowed TAT for each ticket. Finally an option to the user to generate report based on the TAT and team.
FREE DRAFT SOLUTION
As low as 10 $
We also create small applications for project management, inventory management, point of sales application, lead management system and many more in Ms-Access/Excel. Save time and money today and concentrate on important tasks in life while we code the repetitive tasks for you. Drop a note to info@upskilltechnologies or call/whatsapp us at +91-9985130004(India) today to get a draft solution and quote to simplify your life.