Загрузка страницы

STOCK INVENTORY MANAGEMENT SYSTEM with Google Sheets

In this project we will explore Google Sheets capabilities to build an inventory or stock management system

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon

You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more

Index:
00:00 - Introduction
01:58 - Building the Sheet and Column Structure
04:45 - Writing sample data for Product Sheet
05:28 - Create the data validation for the input/output sheet
07:55 - Vlookup for automatically inserting the name of the product
12:00 - Sample data for Input / Output Sheet
13:17 - Creating the Stock or Inventory Sheet
19:52 - Conclusion and Next Steps

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:
➤Patreon: https://practicalsheets.com/patreon
➤Webpage: https://practicalsheets.com
➤Newsletter: https://practicalsheets.com/newsletter
➤Telegram: https://practicalsheets.com/telegram
➤Facebook: https://practicalsheets.com/facebook
➤Twitter: https://practicalsheets.com/twitter

Any suggestion, question or insights, feel free to comment below

Видео STOCK INVENTORY MANAGEMENT SYSTEM with Google Sheets канала Practical Sheets
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
13 октября 2021 г. 19:00:27
00:21:36
Другие видео канала
EVENT GENERATOR in Google Sheets 📅 - Part 3  - Edit and delete eventsEVENT GENERATOR in Google Sheets 📅 - Part 3 - Edit and delete eventsConnect different Google Sheets files, and choose any column with IMPORTRANGEConnect different Google Sheets files, and choose any column with IMPORTRANGEQUERY Course for Google SHEETS -  Lesson 2 - Filtering with WHEREQUERY Course for Google SHEETS - Lesson 2 - Filtering with WHEREHow to order a table automatically in Google SheetsHow to order a table automatically in Google SheetsCurrency Converter in Google SheetsCurrency Converter in Google SheetsCreate a Dependent Dropdown Form for Google Sheets - WebappCreate a Dependent Dropdown Form for Google Sheets - WebappQUERY Course for Google SHEETS -  Lesson 1 - Introduction and SELECTQUERY Course for Google SHEETS - Lesson 1 - Introduction and SELECTSend email from Google FormsSend email from Google FormsQUERY for Google Sheets - Complete Course - Part 4 - LIMIT, AND OFFSETQUERY for Google Sheets - Complete Course - Part 4 - LIMIT, AND OFFSET7 ways to drag down your formulas in Google Sheets7 ways to drag down your formulas in Google SheetsDinamically merge 2 tables from different Files in 1, with Google Sheets (NO CODE)Dinamically merge 2 tables from different Files in 1, with Google Sheets (NO CODE)Generate automatic Serial number with Google SHEETS and Google APPS SCRIPT  - Optimizing the scriptGenerate automatic Serial number with Google SHEETS and Google APPS SCRIPT - Optimizing the scriptCreate Recurring Calendar Events from Google SheetsCreate Recurring Calendar Events from Google SheetsInventory System in Google SHEETS - Part 9 - First-in first-out FIFO Costing SystemInventory System in Google SHEETS - Part 9 - First-in first-out FIFO Costing SystemHelp Desk System in Google Sheets, Forms and Google Apps Scripts - Part 3: Send initial emailHelp Desk System in Google Sheets, Forms and Google Apps Scripts - Part 3: Send initial emailMAIL MERGE SYSTEM with Google Sheets 📧 - Part 1 - Send multiple emails to your contactsMAIL MERGE SYSTEM with Google Sheets 📧 - Part 1 - Send multiple emails to your contactsWorkout logger in Google Sheets - Part 3 - Easliy bring exercises grouped by categoryWorkout logger in Google Sheets - Part 3 - Easliy bring exercises grouped by categoryPersonal Finance System in Google Sheets - Part 3 - Tracking Income 💰💲Personal Finance System in Google Sheets - Part 3 - Tracking Income 💰💲4 methods to create Timestamps in Google Sheets without code4 methods to create Timestamps in Google Sheets without codeInventory WebApp with Google Sheets and Google Apps Script - Part 2 - Create a Product DropdownInventory WebApp with Google Sheets and Google Apps Script - Part 2 - Create a Product DropdownHow to build a Google Form to schedule appointments in Google Calendar - Part 5 - Booked CalendarHow to build a Google Form to schedule appointments in Google Calendar - Part 5 - Booked Calendar
Яндекс.Метрика