Find a local Microsoft Excel helper in QLD

AirTasker Description: Excel & Database Expert Needed to Create Automated System with Pipedrive, Outlook, and Excel Integration Task Overview: We’re looking for an experienced Excel guru and database expert to design and implement a streamlined, automated system for managing our manufacturing and stock orders. The setup needs to integrate seamlessly with Pipedrive, Outlook, and Excel to auto-generate picking slips and improve overall workflow efficiency. Key Requirements: Database Creation: Develop a robust database that stores customer order data, inventory levels, and manufacturing details. System Integration: Ensure the database communicates effectively with: Pipedrive for tracking customer information and orders. Outlook to receive order updates and send notifications. Excel for additional data handling and reporting. Auto-Populating Picking Slips: Set up an automated process that generates a picking slip for each order, complete with manufacturing and stock details. Data Flow Automation: Enable seamless data updates across all platforms, ensuring that changes in one area (e.g., Pipedrive order status) reflect automatically in the Excel database and picking slip. Ideal Candidate: Proficient in advanced Excel (VBA/Macros, pivot tables, etc.). Experienced with Pipedrive and Outlook integrations. Strong database and workflow automation skills. Excellent communication and problem-solving skills. If you have the expertise to bring this vision to life and are skilled in cross-platform automation, we’d love to hear from you!

macro datasbase, quoting database, component database & picking slip.

Excel skills to provide a payroll reconciliation

I need someone to help me with Excel. I use a template and enter data each day and want it to transpose it on another sheet. Have very basic skills so unsure how to format this.

Assist with set up of excel spreadsheet and data entry for one day. 6 hours My place, my computer. Teach, supervise and also do several hours of data entry.

Hi im a beginner and and am wanting to increase my skills in Excel .

I don't know if this needs to be done online or in person I'm not very good with computers and need to sort and excel spread sheet out

I have a excel data sheets I need to transform into a VBA data entry program, for more effective employee data entry, and more simplicity. Also a professional informative dash board to show. I have all the Data there I just need it to transform into a VBA development program with Userform entry. I am using for Training and Assessing.

Need an excel genius to help me with finalising a profit margin calculator in excel. I have the basics done but I need it to look better plus easier to use as right now it’s quite difficult.

I am looking for a Excel wizard to create macros and formulas to generate result outputs. Rate per hour can be discussed once the offer is accepted.

Looking for an excel turor

We need an efficient accountant to complete a several tax returns for a small brick laying business. We want to maximise our benefits and do everything by your knowledge. If all goes well, we would be interested in working long term as we are unable to keep up with this independently. The location question is a bit vague, if you have an office we can come to you. I will enter a generic number for the price, just let me know how you can help and what your price may be so we can discuss further.

I need to learn Microsoft excel. I have basic IT skills but need to learn formulas, spreadsheets, filters, designing them. I am wanting to do this in person as online does not help me. This will be several sessions over a few weeks and could lead to more ongoing training. Will pay hourly. Thanks

I am new at keeping track of my personal expenses and need training on how to do it either in Excel or another free software program for budgeting sake

I have a set of hand calculations for complex geotechnical engineering problems. Now I need help with converting these into an excel with the formulas I have.

Write a macro to save an image as jpeg format from an excel sheet (column a) with the file name as shown in column b

Would like a list of names compiled in word/excel format along with other lists created and typed out on Microsoft Word.

We need to build a custom Spreadsheet for our company. We run slightly more than basic sheets, however we need them to do more for our business.

Hi All, I own a landscaping business and I am going to be commencing with a program that will assist with the accuracy of putting quotes together and the entire production of a quote with detailed scopes of works and much better ability for me to track all costs during the job. Whilst this job could be done via sharing information online i unfortunately will not go down this path again due to the fact that the last task I posted was being done by Ai. What I need is for a proficient and accurate data entry person to load all of the price lists that I currently have to an excel spreadsheet. The crew at Workguru have provided me with an example of how the spreadsheet needs to be filled so as it can be imported correctly. I am as far as you can get as the person who has the time or skills to do this work. I have been advised by the team at Work guru that on price lists that only come as a PDF and not as an excel sheet that the sections that need to be added can be converted to excel in Adobe and then once added it can be altered to meet the requirements........This is still all foreign to me as it's not my thing. I will need to be able to speak with the person who is doing the task as there will be things that will need to be altered as far as the categories that items are put into, and I find it easier to explain my thoughts when speaking with a person. Workguru suggested that they can all just be entered as the are and then you do as search for the product. I will be preferring to have separate categories. Such as. Concrete sleepers as they come in different profiles and sizes, I feel that this will just save time and it seems a bit easier for me. I have attached a copy of thew spreadsheet with instructions from Workguru and I have also attached an example of one of the price lists I have from one supplier and there are a few suppliers. The budget price I list is per hour, as I have no idea how many hours it will take.

Looking for someone to come to our office and provide training on Excel and Word