Excel Inventory Setup and Automation

Hi Good morning , How are you? I just saw your job posting . I see you have been looking for someone experience with these technologies Software Architecture and Excel. I believe this is some thing I can help you with because I have 9 years of experience working with these tech stacks and 8 years of experience working on freelancer.com which you can confirm from my profile: https://www.freelancer.com/u/AwaisChaudhry I have few questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements. 2. Do you currently have anything done like Wireframes, UI/UX? Or this job has to be done from scratch? 3. What is the timeline to get this job done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Lets start the chat and discuss your job in detail and we will continue from there. Regards, Awais

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

Hi there! As I have read, I see you need help setting up and automating an inventory in Excel software, and I could help you! With my expertise in Excel and experience in setting up complex inventories, I am well-equipped to assist you in creating a robust and efficient inventory system. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Respectfully, Giovanni.

With two decades of experience in software development and Excel expertise, my robust team at Einnovention has got your back for setting up and automating your inventory. We've had incredible success with past projects: over 248 completed on Freelancer.com alone, with a 4.9/5 rating, and clients appreciated our innovative approach and meticulous attention to detail. Automation is our forte; we'll build a solution that will make maintaining your inventory a breeze. Our experience in setting up complex inventories aligns perfectly with your project demands of tracking multiple items simultaneously while updating and transferring data automatically across worksheets. We can also incorporate calculations you need like the total value of the stock, ensuring a comprehensive system that covers everything you require. In conclusion, be it implementing the latest frameworks or delivering user-friendly applications that tick all the boxes, we excel at it- quite literally so in this case! So, let me assure you that hiring Einnovention is a decision you won't regret. Let's talk timelines and nail down the specifics. Looking forward to working together!

Hi, Are you in search of a highly skilled Microsoft Excel expert proficient in automated solutions encompassing Excel VBA, Excel formulas, Excel macros, functions, Excel dashboards, and Pivot tables? Look no further, as you have arrived at the right place! At EXO Automations, I offer a comprehensive range of solutions tailored to meet your needs: Excel Automation through Excel VBA and Excel Formula Interactive and Dynamic Excel Dashboard MS Excel User forms, Charts & Graphs Automatic Invoicing, Sales Orders, Payroll using Excel vba Data Analysis and Web Scraping Custom Excel Spreadsheets/Templates Complex Excel formula Google Sheets Expert (Google Spreadsheets) and much more

❇️ I can help you set up and automate an inventory system in Excel to track 100-500 items. My expertise in Excel allows me to create a system that automatically updates data across different worksheets and performs calculations like total stock value. I can also ensure the system is user-friendly and adheres to sound inventory management principles. Let's chat to discuss your specific needs and how I can customize the system for your business. My experience includes: ✅ Automated Inventory Management System for Retail Store ✅ Sales & Stock Tracking Spreadsheet with Dynamic Charts ✅ Order Management & Reporting Tool in Excel ✅ Customizable Inventory Database in Excel ✅ Data Analysis & Reporting Dashboard for Inventory Data (2) ✅ Inventory Forecasting & Reordering System in Excel ✅ Barcode Integration with Excel Inventory System ✅ Inventory Management System for Online Store ✅ Multi-Warehouse Inventory Management in Excel

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali

Dear client, With extensive expertise in Excel, I specialize in designing intricate inventory systems tailored to your needs. I'll develop a dynamic Excel solution capable of managing 100-500 items with ease. Automation features will ensure seamless data updates across multiple worksheets, while built-in calculations will provide real-time insights into stock values. My background in inventory management ensures an efficient and user-friendly system.

Hi, I am an Experienced ETL (Extract-Transform-Load) Developer. I can provide services related to Excel, Pentaho etc. It would be a great opportunity for me to work on your project. Please inbox for more details and discussion about project, timeline and budget etc., thank you. Best regards Amir

Hello, I can set up and automate an inventory in Excel software. I am certified in advanced Excel, data analytics, and Dashboards from Macquarie University, Australia. I have a lot of experience in databases, data analysis, Excel Charts, and graphs. I am an Accountant and I have over 10+ years of experience in Accounting. My Skills In Excel : 1. Dashboard, Slicers for interactive dashboards. 2. Pivot Data, Pivot Table, Pivot Chart. 3. Macros, Conditional Format, Shape, Sparkline 4. Data Validation, Drop down list. Data Modelling 5. Power Pivot, VLOOKUP, XLOOKUP, and Cube Functions. 6. Excel Function, DAX Function. 7. Analyzing data with Power Pivot. 8. Visualizing data with Power Pivot. 9. Power BI, Power Query, Creating a Power BI dashboard. Best Regards,

Proficient Excel expert programmer ready to develop the required inventory control with automated tasks and reports. Skills and reference in my profile link, copied below. Please reach out if you interested to discuss further details. https://www.freelancer.com/u/vw1514518vw

I work for a Supplychain tech platform, Warex. I have completely implemented several inventory management modules both in excel as well as through ERP. I can design several modules to 1. Add/ edit SKUs 2. Enable their inwards, outwards and transfers 3. Track their cost price and sales price 4. Inventory report by value or count. etc. Please let me know if we can discuss on your specific requirements and move forward.

As an accomplished software developer and data analysis expert, my two decades of experience have been sharpened in renowned institutions like the UNO and WHO. Among my full range of skills, Excel and Software Architecture sit at the pinnacle of my expertise. I am zealous about building efficient systems to harness pivotal data, and automation is a sweet spot for me. My previous successes with designing complex inventories and incorporating automatic calculations will provide your project with an enhanced capacity to track comprehensive inventory data. Having dealt with large volumes of data for diverse organizations, I appreciate the urgency of efficient inventory management. That's why I plan to employ my well- honed automation skills to ensure smooth transitions between your 100-500 different item types in separate worksheets. You mentioned the need for automatic calculation; this is a terrain I'm very comfortable with, and I'll ensure not only accurate calculations but also automate the derivative processes like updating stock values in real time.

Hey there! Picture this: your project, but even better. I've got skills that'll make your ideas sing and your goals soar. Let's chat and make some awesomeness happen together. Trust me, it's gonna be epic!

Hi, My name is Tarannum, a seasoned Excel, and g-sheets expert. I have extensive experience setting up and automating complex inventories, which aligns perfectly with the needs of your project. I am well-versed in tracking and managing hundreds of different items effectively. My automation skills are something that sets me apart from the rest. I can create dynamic formulas and macros that will automatically update data between different worksheets as well as calculate the total value of stocks, taking out any chances of data errors or additional manual workload. Streamlining your inventory management process will be my top priority. Additionally, my knowledge of inventory management principles will ensure that your system is not only efficient but also user-friendly for you to navigate easily. Let's transcend your inventory management system to a whole new automated level together! Regards Tarannum

Hello there, we are experts in PHP, JavaScript, MySQL, Website design and development. Please, send me a message to discuss the work and finish in no time. Thank you Ashish from Coding job online.

Greetings, I am Emad, with over 15 years of MS Excel experience, specializing in Excel Reports Automation using Power Query. I handle full inventory control for finished goods and raw materials daily, automating tasks with Power Query for CSV and text files from our database. I excel in Excel formulas, cleaning, formatting, conditional formatting, and standardizing spreadsheets. I create insightful reports and charts with one-click Excel tools. I offer exceptional after-service support and prioritize your success. Visit my portfolio for samples. Let's collaborate for efficient data solutions. Regards, Emad @EmadOwaida's profile on Freelancer https://www.freelancer.com/u/EmadOwaida?frm=EmadOwaida&sb=t

Hey C D., I have carefully read through your project requirements for setting up and automating an inventory in Excel. To achieve this, I will start by creating a master worksheet to track the 100-500 different types of items. I will then set up formulas and functions to automatically update and transfer data between worksheets. Additionally, I will incorporate automatic calculations to determine the total value of the stock based on the quantities and prices entered. With my expertise in Excel and experience in setting up complex inventories, I will ensure that the system is efficient and user-friendly. By utilizing automation skills in Excel, I will streamline data updates and enhance the overall inventory management process. I am eager to discuss this project further and provide a tailored solution to meet your inventory needs. Best regards

Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For my past work please visit https://www.freelancer.pk/u/TayyabDastgir?frm=TayyabDastgir&sb=t Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?