Video není dostupné.
Omlouváme se.
📊 How to Track Expenses & Investments in Google Sheets 2021 / Easy Step-by-Step Spreadsheet Tutorial
Vložit
- čas přidán 14. 08. 2024
- 📊 Spreadsheet Everything! → shp.ee/2iu52yq
💡 Invest in yourself! Sign-up to datacamp with my link and check out the first chapter of any course for FREE: bit.ly/2Nu90Qs
This is a step-by-step tutorial on how to make a basic personal finance dashboard with Google Sheets! We'll be making a cashflow tracker, a fund investment tracker, and a Pag-IBIG MP2 investment tracker. All of these trackers will be linked to a main sheet to create a simple dashboard. If you haven't used spreadsheets before, don't worry! We're only going to use simple formulas, so it shouldn't be too hard to follow along.
I personally use spreadsheets to track my cashflow and my investments. I've tried a lot of budgeting apps in the past, but none of them really fit my needs. Because of it's customizability, I love Google Sheets!
This is an update to the previous video where I showed you how to make an expense tracker with Google Sheets, which you can watch here: • How to track your expe...
We've reached 4,000 likes! 🥳
Here's the link to the template as promised: bit.ly/NicoleFi...
✅WHAT TO WATCH NEXT
➜ 🤑 Best High Interest Savings Account Philippines: • 🤑 Best High Interest S...
➜ How I Manage My Finances in My 20's: • How I Manage My Financ...
➜ 📈 What I Invest in as a 20-year-old College Student: • 📈 What I Invest in as ...
➜ What to do with (your future) ₱100,000: • What to do with (your ...
➜ Why I Invest in Crypto: • Why I Invest in Crypto...
➜ Personal Finance 101: • 🤑 Personal Finance 101
💵 FREE CASH FOR YOU
➜ Shopback: Get cashback when you shop and PHP100 when you sign up with my link bit.ly/nicolesh...
➜ GCash: Get PHP 70 worth of freebies when you sign up at bit.ly/2ZyrLWy and verify your account
➜ PayMaya: Get Php100 when enter 2Y817PZMN84O as invite code or sign up at bit.ly/2ZzVjTs and verify your account
💳 Apply for Citibank Credit Cards
Simplicity+: bit.ly/3jWv6FQ
Cash Back: bit.ly/3mMmFyH
Rewards: bit.ly/3mNSB5J
Prestige: bit.ly/2TRy83G
PremiereMiles: bit.ly/34Sl2cs
🍞Join our Discord Server: bit.ly/371S1uX
👍Facebook Page: / alba.nicoleee
☕Buy me a coffee: ko-fi.com/alba...
🚀Subcount: 101,375
🕰TIMESTAMPS:
00:00 Intro
00:55 Sponsor Mention: Datacamp
01:51 Basic Spreadsheet Skills to Learn
06:09 Updated Cashflow Sheet Tutorial (Expense Tracker)
10:18 Cashflow Sheet Demo
11:10 Investment Fund Tracker Tutorial
15:50 Pag-IBIG MP2 Investment Tracker
18:53 Personal Finance Overview Dashboard
Send this video to your homies so you guys can benefit from managing your finances together! SUBSCRIBE for more videos like this! I post one video a week and I talk about personal finance, self-development, or anything I learn or experience throughout my life as a 20-year-old.
--
🤝 Where to reach me
➜ IG: @alba.nicoleee
➜ Email: alba.nicoleee@gmail.com
--
How to Track Expenses & Investments in Google Sheets 2021 / Easy Step-by-Step Spreadsheet Tutorial
how to track expenses in google sheets 2021 / expense tracker google sheets / investment tracker google sheets / money management for beginners / manage money student / manage money for free / free budgeting apps / how to manage your money with excel / personal finance for beginners / personal finance with google spreadsheet
FTC: This video was sponsored by Datacamp
Happy Saturday BreadFam! You guys have been requesting for an updated spreadsheet tutorial for so long (sorry for the delay haha). I made this video for absolute beginners, so hopefully you guys will find this easy to follow 😄📊 Sorry for my voice because I felt a bit sick while filming this video 😅 Let me know if you have questions in the comments below! 😁
💡 Invest in yourself! Sign-up to datacamp with my link and check out the first chapter of any course for FREE: bit.ly/2Nu90Qs
ALSO THANKS FOR 100K GUYS!! Let's celebrate this milestone in another video 😄🌟🍞
Great video!
Waaaaaaaaaah may bago na! Time for an update ahahahaa
hi nicole!! um, how and/or where did u get the report for the dividend you received for your mp2 investments per year? thank u for this!!!
Waaaaa where's the template? Huhu
Hey Nicole. Your video really helped in making a simple yet effective tracker.
I was looking to add date selection, rather than typing in and found out that is possible. Hence adding below for the benefit of others.
Select the particular column and do the below operation.
Data menu > Data validation -> Choose ‘Date’ and ‘is valid date’ and you are set to go :)
Finally updated my spreadsheet today! Had the format you gave us few months ago. Using it made me feel like I’m a pro at managing my finances already 😂 (although the sheet just slapped me with the fact that most of my expenses go to unnecessary midnight snacks 🥲) thank you, Nicole! And congratulations for reaching 100k subs! All my love to you and bread fam! 🍞💓
Start up with 1k and earn profits of 10k....
Some quick tips for spreadsheet:
1) If you hate seeing Div/0!(15:10) since the formula divides with a zero, you can input this [=if(H16="","",J16/H16-1)]; it shall remove the error value and into a blank cell.
2) During 19:20, you can dropdown or drag down(the thingy with a crosshair) "Fund 1" or cell C7 to create succeeding funds or Fund 2, Fund 3, etc. You can do this with any text that involves "text + 1,2,3"(ex. Fund 1, Account#1)
I'm still learning more spreadsheet so yeah. I hope this help!
I am 29, and I just started watching your videos. Youre such a blessing! I kinda regret and hoped that I started the things you do when I was your age. Oh well, everyone has their on starting points and pace on the road to success.
Thanks for this. I'm 10 yrs your senior but I am really learning more from you. :)
Thank you a lot ♥️
Why do I find you sooo inspiring? I found one of your videos while browsing for investment ideas and boom! just like that I'm hooked. (SPREADSHEET EVERYTHING!!) I am near 30 now and I just made my first financial spreadsheet. I watched most of your videos and I found the 1000 subs vid and deeym, that IMAGINATION thing, its not cringe at all. It was inspiring! Brilliant! And looking at where you are now? (103k subs) I can't wait to see you make your first MIL! Thanks for pushing me take action!
Haha omg you watched my 1k video pala 😄 Thank you for your kind words 🥺❤️🍞
Now this answers the question that I was about to ask you as to how you track Credit Card expenses! Big help! Thanks!
Bruh, I've been looking for a nice format for my income, spending spreadsheet and this is it. Thank you!!!
Congrats Nicole for the 100k+ subscribers!!! Breadfam getting huge! Keep inspiring humans! :)
Best recommendation to clone___.281 on Instagram..
Great content! This video is a good start so that more people could practice tracking their finances.
I learned alot about excel in this short intro than all the years I explores ms excel. Lol. Thankz!
Hello Nicole! I just wanted to say thanks for this easy budget that gives me a layout for bank accounts and credit cards. I spent hours and weeks building different budgets here on CZcams, but just to realize that it wasn't working for me. By then, I'm getting really aggravated and was about to give up and try sometime later. I just happened to come across your video and decided I would give it a try. To my surprise, it was what I had been looking for. I have been using it for about a month and a half now and really loving it. I had not been very familiar with google sheets/excel, so it took me sometime to get it together because you move and talk pretty fast, lol! But thank you so much for sharing!
You can also "semi" automate the entries using Google forms 🙂. Then create a browser shortcut of the form on your phone so it's handy.
Can you share more about this? This is really interesting!
Ff
woah.. thank you for the idea
I stumbled upon your videos lately. Kala ko organized na yung trackers ko, dami ko palang dapat iimprove. Naalala ko tuloy yung mga investments kong inaalikabok na. Thank you sa video contents like this.
Super thanks po! I just finished making my personal cash flow tracker, and now that I kind of know how to use google sheet, I'm going to try applying it to where I work. Haha, thank you so much!!
Thank you bringer of breads and the alarm clock of the financially asleep! will apply this next quarter as I have already done your previous vid's spreadsheet :> hoping to add mp2 to my portfolio in the near future
Finally made my own expense tracker! Thank you so much Miss Nicole and God bless!
Many financial advise and tips to come 🍞😁
Isa ako sa mga subscribers mo ate since last year! Keep up po. I was able to be organized and was able to save money and track my expenses thru the help of your vidssss
"Financy" favorite word now
this was beyond helpful. ill be watching this 30 more times
thank you so much for your time and knowledge!
I just have to say. I like how you show example from the simplest form possible. I have tried to watch a lot of CZcams videos to make an easy and simple cash flow tracker. I will start to watch all you videos moving forward.
Thank youuu for sharing the template! It’s been 3 days since I watched one of your vlog, then now I’m binge watching. Learning so much from you! 🥰
one of my fave vloggers! Browsing your video is like reading a good book! I have benefited a lot! Thank you for your hard work!🥰 Your channel is great. I'll never get used to saying it is worthy of a million likes! Fully watched! 🎯💝
Hi Nicole, I absolutely love your videos! Quick helpful tip: for the last price cells, you can use the GOOGLEFINANCE function so that the price is constantly updated for you!!
@@leilegion hmm yikes, I don't think you can without maybe some extra steps
Thank you Nicole Alba for existing!!!!!!!!!
Thank You! Thank You! Thank You! sooo much for this track.. i might be late on this but this will help me track my finances (including debt) more power to you and your channel
thank you so much for this Nicole. very easy to understand. I've been watching your vids one by one. looking forward to learn more
I've been binge watching your finance vids. Such a huge help.. thank youuu 😘
Thank you for this!! Super effective nito at mas madali at mas maganda compare sa mga natry kong applications dati!
Try nyo na yung google sheet guys! Pwede din maglagay ng calendar sa data validation para double click nalang then select date.
HOPING FOR MORE VIDEOS ABOUT PERSONAL FINANCE, THANK YOUU!
-curently a 2nd year student
I'm addicted in using excel for everything so when I saw your video I immediately made my own ☺️☺️☺️
Thank you nicole. I usually do not keep track with my finances and then ask myself kung saan napunta ang pera ko. haha. But I was really inspired with your videos and so I tried doing this. It makes me feel more "responsible" HAHA. It's really helpful.
Best recommendation to clone___.281 on Instagram..
Oh btw, congrats for more than 100k subscribers. 👏🏻👍❤
Thank you for this, I used to not really keep track on my money but now I copied your tracker and I'm really inspired to start investing. I thought It might be "hassle" because you record every cent you gain or spend and takes my time but I didn't know it's fun and really helps with my self discipline and learn more about my behavior on how I spend my money. Super thumbs up for this, If only I can like the video for more than 1 time I'll do it. Looking forward for your future videos.
Yeyyy thank you for this nicole! Big help tong spreadsheet format/template. I use a mobile app to monitor my expenses kaso minsan nalilito ako hahahaha this one is easier to understand and kita agad lahat. Love it!
PS. Yung nagdislike ng video ni nicole di marunong magexcel. Charot hahahaha
Registered to SeedIn, created 2 MP2 savings, and made my own finance spreadsheet! 😂 Naka-graduate na ako sa panonood nang panonood lang ng videos mo since last year! Hahahahaha! Finally took action!!!! Salamat sa walang sawang paalala, narindi na ako sa reminder mo. 😂
Thanks for commenting. Feel free to write a professionel
I can't give out her personal information here without consulting her first.
Thanks for this video! I already started my channel with regards to personal finance. You are one of my inspiration in this channel! Thank you!!
I also check your vids. Looking forward to it!!!
@@wireelessie1806 thank you 🙂
Checked out your vids! Really glad that my videos encouraged you to start making your own videos. Keep it up Lorence! 😄❤️🍞
@@NicoleAlbaYT thankyou for noticing me!! ❤
Super easy to follow your steps. You make my Google sheet look like a pro.
Nicole, this video is very helpful. I really hate numbers but with this, it makes my life easier. HAHA! I started tracking my expenses/savings/investments this year. Keep inspiring people!! 😄😄
hello Nicole, would like to ask what's your formula for 'SELL'? thank you
I really appreciate how you taught us some excel “skills to learn” before you showed the actual creation of the spreadsheet!!
I believe it's important to learn the basics talaga so that you guys know how to make adjustments! Understood na my spreadsheet layout might not work for everyone, kaya better to teach people how to use google sheets 😉❤🍞
Hey Nicole, just want to let you know that this video (and your other videos) helps me a lot. Thank you. Your videos rocks \m/.
Thank You again Ms. Nicole for a helpful tutorial God Bless you.
I like your videos so much! Informative, concise, tapos fun pa panuorin. ❤️
Thanks for this Nicole! I'm trying to be a more financially responsible adult and seeing where my money goes is a huge wake up call. I'm also applying for a cc and this seems like a good way for me to keep my eye on how much I'm spending and not just swiping left and right without thinking about the consequences.
THANK YOU SHARING THIS I WAS ABLE TO TRACK MY EXPENSES AND MANAGE HOW TO SPEND MY EARNING GREAT CONTENT NEW FAN HERE
THANK YOUUUUU!!!❤️ Super dupeer helpful!, FINALLY!!!!
Thank you Nicole for your effort. Sobrang nakatulong :)
Love this video, thank you so much for this.
Do you have any recommendations of what to do if you're dealing with different currencies? (Investment accounts abroad etc.)
I need an entire weekend for this. LOL! Thank you very helpful!
Thank you, Nicole! I am using this to track my finances. 😊 I prefer using this than using apps.
I put it in my G. Drive so I can update it even in my phone.
This is great !!! thank you for teaching us :)
I love you... you helped me so much with finances. Continue the good work. 😚
It's actually because of your channel why I learn these kinds of stuffs, like way before I don't even know how to use a spreadsheet and even know what is financial literacy. So keep up the good work, you're doing a really good job.
Thank you Mark!! Here's to a more financially literate Philippines 😄❤️🍞
You're my first favorite vlogger Nicole! Congratulations on your 100k subs!🍞🌟 Thank you for teaching and inspiring both gen Zs and millennials about financial literacy and self-development💪
YAY HIHI THANK YOu!! That means a lot to me 😄 More sharing of knowledge the better 😄🌟🍞
Super siksik sa info. Thank you so much. This really inspires me spreadsheet everything. and I already started too. :D
Thank you so much for this tutorial video♥️😊 been 1 month on tracking my expenses using this and it made me so mindful to where I'm putting my money hahaha! At nakakaadik mag-encode sa sheets everytime may itatransfer or gagastusin ako😂
This is my favorite financy video so far 😁
Thanks for commenting. Feel free to write a professionel
I can't give out her personal information here without consulting her first.
Thank you for sharing this nicole it's really helpful.
Maraming salamat po. Ang genius mo.
You've earned my subscription. Congrats for the video, amazing piece of content!
learning so much thank you for new learnings
Hi Nicole, really glad that you are sharing how you setup your trackers! I love it a lot and I'm using your format.
I am using a google sheet function to automate the 'Last Price' column.
Function name: GOOGLEFINANCE( )
It automatically gets the price of the stock, specifically for US stock from Google Finance.
This removes the need to key In the current values manually in the 'Last Price' columns.
AMAZING! This is perfect for absolute beginners! OMG!!! I am learningggg. whoooo! Thank you Nicole
T͜͡ h͜͡ a͜͡ n͜͡ k͜͡ s͜͡ f͜͡ o͜͡ r͜͡ s͜͡ h͜͡ a͜͡ r͜͡ i͜͡ n͜͡ g͜͡ y͜͡ o͜͡ u͜͡ r͜͡ c͜͡ o͜͡ m͜͡ m͜͡ e͜͡ n͜͡ t͜͡ s͜͡
M͜͡ a͜͡ k͜͡ e͜͡ a͜͡ n͜͡ o͜͡ t͜͡ e͜͡ t͜͡ o͜͡ m͜͡ y͜͡ t͜͡ r͜͡ u͜͡ s͜͡ t͜͡ e͜͡ d͜͡ t͜͡ r͜͡ a͜͡ d͜͡ e͜͡ r͜͡ ,͜͡ Christopher Andrew Williams t͜͡ o͜͡ h͜͡ e͜͡ l͜͡ p͜͡ y͜͡ o͜͡ u͜͡ m͜͡ a͜͡ k͜͡ e͜͡ m͜͡ o͜͡ r͜͡ e͜͡ p͜͡ r͜͡ o͜͡ f͜͡ i͜͡ t͜͡ s͜͡ i͜͡ n͜͡ C͜͡ r͜͡ y͜͡ p͜͡ t͜͡ o͜͡
w͜͡ h͜͡ a͜͡ t͜͡ a͜͡ p͜͡ p͜͡ +͜͡ 4 -͜͡ 4 -͜͡ 7 -͜͡ 4 -͜͡ 1 -͜͡ 8 -͜͡ 3 -͜͡ 4 -͜͡ 4 -͜͡ 9 (7) (3)_
H͜͡ is s͜͡ t͜͡ r͜͡ a͜͡ t͜͡ e͜͡ g͜͡ i͜͡ e͜͡ s͜͡ a͜͡ r͜͡ e͜͡ t͜͡ o͜͡ p͜͡ n͜͡ o͜͡ t͜͡ c͜͡ h͜͡ .͜͡ .͜͡..
Thanks so much! I'm more than challenged to put something on my own spreadsheet than nothing. Savings is highlighted the most. 😁
where do you put the fees? for example you transfer money from gcash to your bank. they charge 15 php
Good job Nicole! And thanks! Keep it up!
Really appreciate this! Thanks!
This is so helpful! Thank you Nicole. New subscriber here - so glad I found your channel. ❤
You are welcome.
+1 (7 2 4 ) 6 1 7 - 2 0 6 1
Thank you for sharing your knowledge! this is pretty helpful for me to track my financial☺️💙
Spreadsheet is life.. thanks Nicole for the idea been wanting to improve my finance tracking spreadsheet
Thanks for commenting. Feel free to write a professionel
I can't give out her personal information here without consulting her first.
You are amazing thanks for all of these...stuffs
New subscriber here!!! Very informative!
Thank you Nicole ... Your content is really useful
Wow great content!! My new favorite.
Amazing video! Thanks so much :)
Okay, lahat yan ginawa ko rin HAHAHAHAH Salamat Nicole! Big Help! More Videos please
You do a great job ! I just wish you would slow down a bit you talk so fast I had a hard time following. I did learn from it Thank you
Hi this expense tracker has been very helpful for me. I hope you make a guide on how to generate charts na data from this sheet yung data ng charts. Para lang makita ko overview ng expenses ko per month, tapos what takes up most of my expenses food ba or bills ganun hehe thank you!
Start up with 1k and earn profits of 10k....
+1(2.1.8)2.0.3.0.9.0.8....
SALAMAT PO. Makakatulog na me.
Yay finallyyy ✨✨✨ Thank you, Nicole!
Hello Nicole! Hope you could also give some tips on how to do excel for small business? Like with inventory and sales. Thanks!
paspasa mutudlo waah mabuang nako, speed to 0.5. but still thankful for the demo
Thank you as always for sharing these easy, helpful tools for managing money and investments!
+19085096731
Wh//zapp
waiting for the link of the spreadsheet :P
Super Appreciated the tracking Information 💖
+19085096731
Wh//zapp
Galing! Thank you
Hi Nicole Thank you!
Thanks for this ate Nicole
This id is a great help especially to students like me ❤️
Thank you Nicole! This is helpful to us. ❤️
new subscriber here! Thanks for this, Nicole!
Thank you for this, totally a life saver. 🥰
Grabe! thank you Nicole Alba for sharing your knowledge. Ang dami ko natutunan sayo pagdating sa finance, I can't wait to build my EF and finally invest. I have never been this inspired mag-save at mag-aral pa. Thank you!
Thank you Ate Nics!
Hi Nicole, pwede mo explain pano mo nakuha yung buying power? Thank you
Thank you Nicole! this is very helpful! :D
Thanks for this 🌻
Love this Amazon work great guide
thanks for your feedback! contact me for more information 👇
@NicoleAlba1
been trying different spreadsheets to track my finances but this really worked for me!!! I love the pie charts too!! Thanks for this + teaching us basic spreadsheet skills!!!
Thanks for sharing!