| Time | Segment | Content | |------|---------|---------| | 0:00 | Intro | Why 60% of small biz fail due to cash flow, not profit. | | 1:30 | Setup | Open Excel → create columns (Date, Desc, Category, Amount, Balance). | | 3:00 | Formulas | Auto-calculating balance with =SUM($D$2:D2) trick. | | 5:00 | Data validation | Dropdown for inflow/outflow. | | 6:30 | SUMIF | Monthly totals: =SUMIF(Category_range,"Inflow",Amount_range) | | 8:00 | Chart | Insert line chart for balance trend. | | 9:00 | Template download | Link to free .xlsx file in description. | | 9:30 | Pro tip | Use Conditional formatting → highlight negative balance. | Q: Što je tok gotovine (cash flow) u Excelu? A: To je tablica koja prikazuje sve priljeve i odljeve novca kroz određeno razdoblje. Excel omogućuje automatski izračun stanja i predviđanje.

A: =SUMIF(range_inflow) - SUMIF(range_outflow)

A: Ne izravno, ali možete uvesti CSV izvadak iz banke i mapirati ga u svoj predložak.