Find a local Microsoft Excel helper in Sunshine Coast

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.

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.

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.

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

I need help using excel spreadsheets and just some general PC guidance Tidying up emails etc

I have a budget spreadsheet that has been started there are some issues with formulas and key changes needed to finish this project

Spreadsheet customisation for stock control, manufactuing and sales. Integration with website product uploading and stock control. We have over 2000 products. We would like to be able to manage them through one central page, including scanning SKU with barcode reader for stocktake, manufacturing batches. sales and label re-printing. Upload photos and video to website ((Shopify). - Due date: Flexible

Helping with excel Marco coding - Due date: Before Monday, 25 September 2023

Need help with excel or word document - Due date: Needs to be done on Tuesday, 22 August 2023

I need to complete beginner and intermediate Excel course - Due date: Flexible

Applied business analytics QUT unit. Need help with using excel. Applying statical formulas in excel. Hypothesis testing etc. - Due date: Flexible

I need some tutoring in excel - Due date: Flexible

Need formulas to update a section of an excel work book approc 10 cells - Due date: Before Friday, 20 January 2023

Transferring data into an excel spreadsheet. - Due date: Needs to be done on Monday, 5 December 2022

Need help to convert my bank statements to an excel worksheet - Due date: Needs to be done on Saturday, 3 December 2022