Como hacer un sistema de control de caja en Excel

In this video tutorial, I'll explain how to create a daily cash control system in Excel that allows you to record all incoming and outgoing cash transactions for your business, illustrating the situation with a chart and generating alerts when minimum and maximum balances are exceeded. You can download the pre-made template for free here: https://www.planillaexcel.com/planill... Contents: In the first part of the video, we'll insert a table to list the types of cash we handle, associating them with a code or number. For example, cash has the code 001; bank is assigned the code 002, and so on. Next, we'll create the table where we'll record the incoming and outgoing cash transactions. We'll generate a drop-down list with the cash type codes and calculate the balance. Contents: We will create a formula to calculate the open balance per cash register and include a pie chart for easier understanding. Finally, we will add a warning that will alert us when we exceed the upper limit for maintaining cash on hand and when we fall below the lower limit. CHAPTERS 00:00 Introduction 00:27 Creating the list of cash register types 02:27 Creating the daily cash register movement table 03:19 Inserting a drop-down list in the Code column 05:21 Calculating the balance 10:33 Creating the balance by cash register type 16:44 Inserting the pie chart 17:28 How to add more information to the tables and have it update automatically 19:05 How to generate a warning when we exceed the limits RESOURCES To learn more about drop-down lists    • Listas desplegables en Excel   To learn more about IF functions    • Tutorial Función Si en Excel   You can see how to use the template Here:    • Cómo usar la plantilla de Control de Caja ...   ================================================================================ 📚 Register for my FREE Excel Masterclass https://www.planillaexcel.com/clase-e... =============================================================================== 🎓 Want to master Excel? Learn step by step with my course https://www.planillaexcel.com/cursos/... ================================================================================ 🔔 Subscribe and hit the bell to be notified of new channel updates    / @planillaexcel   👪 Follow us on our social media: ►Facebook   / planillaexce.  . ►Twitter @planillaexcel ►Instagram   / planilla.ex.  .