Скачать или смотреть Part 6 AGEING OF INVENTORY: Supplies Inventory Recordkeeping Using Google Sheets

In this video, I shared the steps on how Supply Officers and Accountants in government can devise easy, convenient and dynamic tool (assuming they do not have the eNGAS software application) to keep records of their supplies inventory using Google Sheets.

-----------------------------------------------
TIMESTAMP:

0:00 Intro
1:16 Step 1 Formatting the would-be report
1:55 Step 2 Using ARRAYFORMULA, MAX and IF functions
2:36 Hack: How to return a blank value into a cell
4:48 Step 3 Similar to Step 2
6:22 Tip: How to return an "Error!!!" message into a cell
7:02 Conditional Formatting
7:50 Step 4 MAX and IF functions
8:30 Step 5 How to compute age of inventory

-----------------------------------------------
CREDITS:

Background Music:
Home by Neutrin05   / neutrin05  
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/_-home
Music promoted by Audio Library    • Home – Neutrin05 (No Copyright Music)  

Intro Music & Sound Effect:
https://www.bensound.com/​​​​​​​ --Buddy
https://www.zapsplat.com​

-----------------------------------------------
#GovernmentAccounting​​​​​
#SupplyRecordkeeping​​​​​
#RecordingInventories​​​​​
#AccountingPH​​​​​
#GoogleSheets​​​​​
#AccountantPHGov​​​​​
#SupplyOfficer​​​​​