That is quite a compliment. Thank you so much. It's awesome to hear that you were able to make it through and complete the whole tutorial. Thank you so much for sharing! 😊
7:40 If, later, I choose to expand the number of categories while using this sheet, will I need to repeat the two steps to include the new range names for the incomeList and the expenseList.
That's an excellent question. To add more categories, insert rows somewhere in the middle. For example, select rows 7 and 8, right-click, insert rows. Then copy the formulas in columns C and F to the empty cells, and that's it. No need to update the range names if you do it this way. 😊👍
Muchísimas gracias por este control de gastos. Sin duda será de gran ayuda para gestionar las finanzas. Estoy muy agradecido con tus videos. Que tengas un bonito día ☀️
hello thanks for this video tutorial but one more thing how can i change my currency in formula? in your video you added a ($) dollar sign in formula,how can i add mine in peso?
I'm so glad you enjoyed the tutorial. So the dollar signs used in the formula are not for currency. The dollar signs are actually added to change the reference type used in the formula. You can read more about it here. spreadsheetlife.com/understanding-cell-references/
If you missed that step, here is what you can do. Leave the data hidden. Click on the chart, click on the three dots in the top right of the chart, then click edit chart. In the panel on the right, under setup, check the box next to include hidden / filtered data. I hope this helps.
Interesting! I think I can help. This would be easier to discuss in more detail over email though. You can send me an email at info@spreadsheetlife.com. We will talk more there. 😊👍
A billion thanks, amazing video, you won a subscriber 🎉
Thank you so much for the subscription! I hope you love using the template! 😊
No teacher can teach batter than this. It took 3 hours to practically done that being a beginner. Live long stay blessed.
That is quite a compliment. Thank you so much.
It's awesome to hear that you were able to make it through and complete the whole tutorial. Thank you so much for sharing! 😊
Thank you alot Ryan sir! ❤
Of course! So glad that you enjoyed the video!! 😊👍
7:40 If, later, I choose to expand the number of categories while using this sheet, will I need to repeat the two steps to include the new range names for the incomeList and the expenseList.
That's an excellent question. To add more categories, insert rows somewhere in the middle. For example, select rows 7 and 8, right-click, insert rows. Then copy the formulas in columns C and F to the empty cells, and that's it. No need to update the range names if you do it this way. 😊👍
Muchísimas gracias por este control de gastos. Sin duda será de gran ayuda para gestionar las finanzas.
Estoy muy agradecido con tus videos. Que tengas un bonito día ☀️
😊❤️👍
Thanks!
Thank you so very much. For your comment, your gift, and your support! 😊
¡Gracias!
¡Muchas gracias! 😊
hello thanks for this video tutorial but one more thing how can i change my currency in formula? in your video you added a ($) dollar sign in formula,how can i add mine in peso?
I'm so glad you enjoyed the tutorial. So the dollar signs used in the formula are not for currency. The dollar signs are actually added to change the reference type used in the formula. You can read more about it here. spreadsheetlife.com/understanding-cell-references/
HELP: at the end when you said click the include data what if you didnt click it on time? how do I add the included data?
If you missed that step, here is what you can do. Leave the data hidden.
Click on the chart, click on the three dots in the top right of the chart, then click edit chart.
In the panel on the right, under setup, check the box next to include hidden / filtered data.
I hope this helps.
I have one doubt in Google sheet! Can you help me if possible?
I will do my best. What is your question?
Interesting! I think I can help. This would be easier to discuss in more detail over email though. You can send me an email at info@spreadsheetlife.com. We will talk more there. 😊👍
@@spreadsheetlifeSure. I mailed you sir. Kindly check.
😊👍
25:22 And I thought learning Hieroglyphy was difficult.🤣😂😮💨
LOL! 😂
It's certainly a long formula. But at least it makes for good practice maybe..?? 😅👍😊