Brian Turgeon
Brian Turgeon
  • Видео 40
  • Просмотров 1 733 025
How to Track Your Finances in 2024 | Automated Google Sheets Template
This finance tracker is the perfect tool to manage your income and expenses. Automate your progress and see your spending across all categories in just a few easy steps. See how the full sheet is made and take control of your financial situation.
To download a full template of this spreadsheet follow this link:
docs.google.com/spreadsheets/d/1cNzA6lfFsApZvKmS9AH5hx0i705yTAH3f_oDnotcMz8/edit?usp=sharing
(Need to first make a copy in order to edit)
#googlesheets #excel #finance
Просмотров: 1 569

Видео

Mortgage Calculator WITH Extra Payments | Google Sheets
Просмотров 17 тыс.9 месяцев назад
To download a full template of this spreadsheet follow this link: docs.google.com/spreadsheets/d/13t4nvGKN91oLsVSYg5yPeUlrxa32YjPxmsqBvjL_Q_k/edit#gid=0 (Need to make a copy to edit) This mortgage amortization table is the perfect tool to monitor your current or future property. Use the google sheets features in this video to analyze how interest rates and extra payments can impact what is owed...
How To Make SPARKLINES | The Coolest Feature in Google Sheets
Просмотров 12 тыс.Год назад
Sparklines are basically mini charts within cells in Google Sheets. They update to inputted data and are a great way to visualize said data. In this video we cover many sparkline types: 0:00 - WinLoss 1:52 - Line 3:00 - Column 4:50 - Bar 7:35 - Stock (Column) youtube.com/@BrianTurgeon #GoogleSheets #Excel #Sparklines
How To Track Your Habits in Google Sheets | Boost Productivity!
Просмотров 4 тыс.Год назад
Looking to reach your goals? Creating a habit tracker will keep you accountable in the tasks you need to complete to reach your goals. Using Google Sheets or Excel, we can better monitor our monthly progress and see how well we are keeping up with the tasks we need to take care of. Download this free template using the link below: docs.google.com/spreadsheets/d/1xyM17RjRpTzARt1WQBYOocJWmV6iu3KD...
This School Assignment Sheet Will Unlock Your 4.0 GPA
Просмотров 1,1 тыс.Год назад
School / College is busy and overwhelming. In order to succeed, you need to know all your course schedules inside and out. By using this school assignment spreadsheet, you can now stay on top of your homework, quizzes, projects and exams and never turn in an assignment late again. This sheet helped me achieve a 4.0 semester in college and it can do the same for you! ruclips.net/user/BrianTurgeo...
How To Track High Yield Dividend Stocks in Google Sheets
Просмотров 45 тыс.Год назад
Dividend stocks are a great way to build wealth and passive income. In this tutorial, see how we can create a dividend tracker with Google Sheets automation. Use google finance to track your stocks or as a watchlist for dividend stocks you may be interested in. #Dividend #GoogleSheets #Excel youtube.com/@BrianTurgeon brianturgeon.yt
How To Keep Zeroes From Disappearing in Google Sheets
Просмотров 16 тыс.Год назад
Use custom number formatting in Google Sheets to keep your leading zeroes in zip codes.
How To Track Your Expenses in 2023 | Mind Blowing Google Sheets Tutorial
Просмотров 388 тыс.Год назад
In this video, we go through how to create an automated budget tracker spreadsheet that tracks all of your INCOME and EXPENSES. See all the cool tricks we use with the magic of Google Sheets to make this useful tracker. #GoogleSheets #BudgetTracker #Excel youtube.com/@BrianTurgeon brianturgeon.yt
How to Create the Best To Do List in Google Sheets
Просмотров 5 тыс.Год назад
We can create so many great things in Google Sheets including this beautiful yet simple To Do List. In this video we discuss checkboxes, alternating colors, and the COUNTIF function. 00:00 Intro 00:19 Inserting Checkboxes 00:51 Alternating Colors 02:09 Visual Enhancements 02:51 Tracking How Much of List is Complete
Say Goodbye to VLOOKUPs. Use XLOOKUP in Google Sheets Instead.
Просмотров 1,8 тыс.Год назад
In the latter half of 2022 XLOOKUP was finally added to Google Sheets. XLOOKUP returns an exact match while VLOOKUP can only return an approximate match. Learn how to use XLOOKUP effectively in this brief video.
How to Make a Drop Down List in Google Sheets
Просмотров 775Год назад
Drop down lists are a great tool to speed up data entry and make your spreadsheets more efficient.
How to Remove Gridlines in Google Sheets
Просмотров 91 тыс.Год назад
Gridlines can be removed in Google Sheets under the "View" tab.
Easy TIME ENTRY Tracker in GOOGLE SHEETS
Просмотров 1,9 тыс.Год назад
Learn how to use GOOGLE SHEETS functions to create a TIME ENTRY tracker for your job or any other application you see fit. For additional information on the cell reference portion, see my previous video: ruclips.net/video/BYZynIXm-Yo/видео.html
ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS
Просмотров 5 тыс.2 года назад
RELATIVE - When dragging functions, the location of the input cells change relative to the location of the function. ABSOLUTE - When dragging functions, the reference cell does NOT move as follows... $A$1: Column and Row do NOT change when copied. A$1: Row does NOT change when copied. $A1: Column does NOT change when copied. The $ placed before the letter or number of the cell creates an absolu...
Finding The HIGHEST or LOWEST Values Of A Range In GOOGLE SHEETS
Просмотров 22 тыс.2 года назад
The SORTN Function allows one to extract the top or bottom x amount of values in a range of data. This function saves time that would otherwise be spent physically looking through a range to see which values were the greatest.
Age Calculator Tutorial In Microsoft Excel
Просмотров 8472 года назад
Age Calculator Tutorial In Microsoft Excel
Summing Values Based on One Or More Criteria In Microsoft Excel
Просмотров 8793 года назад
Summing Values Based on One Or More Criteria In Microsoft Excel
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
Просмотров 944 тыс.3 года назад
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
Google Sheets - How To Import Data From Another Sheet
Просмотров 1,7 тыс.3 года назад
Google Sheets - How To Import Data From Another Sheet
CUSTOM FORMATTING OF PHONE NUMBERS IN MICROSOFT EXCEL
Просмотров 5 тыс.3 года назад
CUSTOM FORMATTING OF PHONE NUMBERS IN MICROSOFT EXCEL
REFERENCE CELLS With The Dollar Sign In GOOGLE SHEETS
Просмотров 13 тыс.3 года назад
REFERENCE CELLS With The Dollar Sign In GOOGLE SHEETS
Joining Cells with the CONCATENATE Function in GOOGLE SHEETS
Просмотров 9743 года назад
Joining Cells with the CONCATENATE Function in GOOGLE SHEETS
GOOGLE SHEETS BASIC TUTORIAL
Просмотров 1,5 тыс.3 года назад
GOOGLE SHEETS BASIC TUTORIAL
COUNTING Values with the COUNTA Function in GOOGLE SHEETS
Просмотров 8543 года назад
COUNTING Values with the COUNTA Function in GOOGLE SHEETS
KEYBOARD SHORTCUTS for a MAC in GOOGLE SHEETS
Просмотров 13 тыс.3 года назад
KEYBOARD SHORTCUTS for a MAC in GOOGLE SHEETS
Counting Years and Days BETWEEN TWO DATES in Google Sheets
Просмотров 1,3 тыс.3 года назад
Counting Years and Days BETWEEN TWO DATES in Google Sheets
FORMAT POSITIVE AND NEGATIVE NUMBERS WITH CUSTOM NUMBER FORMATTING
Просмотров 2,9 тыс.3 года назад
FORMAT POSITIVE AND NEGATIVE NUMBERS WITH CUSTOM NUMBER FORMATTING
CUSTOM FORMATTING OF PHONE NUMBERS IN GOOGLE SHEETS
Просмотров 54 тыс.3 года назад
CUSTOM FORMATTING OF PHONE NUMBERS IN GOOGLE SHEETS
CUSTOM NUMBER FORMATTING OF MILLIONS IN GOOGLE SHEETS
Просмотров 24 тыс.3 года назад
CUSTOM NUMBER FORMATTING OF MILLIONS IN GOOGLE SHEETS
INDEX FUNCTION TUTORIAL IN GOOGLE SHEETS
Просмотров 2,9 тыс.3 года назад
INDEX FUNCTION TUTORIAL IN GOOGLE SHEETS

Комментарии

  • @sp3mistr
    @sp3mistr 21 час назад

    this was simple and easy to follow! if you wanted to have a method for tracking savings and investments, how would you recommend going about this?

  • @villasolidaridad
    @villasolidaridad 2 дня назад

    THANKS MAN

  • @joycehalbmaier2460
    @joycehalbmaier2460 2 дня назад

    Thank you. Very helpful. We use a lot of the Google formats for the school and everyone comes to me to help with the different ways to best use the programs. This is one more trick I can share. 😁

  • @samaddada7566
    @samaddada7566 3 дня назад

    I tried this sheet, but for whatever reason the Net income and reports are not working

  • @marktolmen3090
    @marktolmen3090 3 дня назад

    Good job Brian

  • @mohanmadayi1498
    @mohanmadayi1498 3 дня назад

    EXCELLENT

  • @diegopallavicini4293
    @diegopallavicini4293 5 дней назад

    may I ask a stupid question? what about the day after? do you have to create a new colomn? it cant be live right?

  • @newmanpc4253
    @newmanpc4253 5 дней назад

    I dont uderstand nothing what you are saying what does the hashtag mean ect.

  • @wooloopy8999
    @wooloopy8999 6 дней назад

    hi! how do i change the currency and date without having to redo the whole thing by myself? it breaks whenever i change it to euro and day/month/year

  • @adityadhepe2186
    @adityadhepe2186 7 дней назад

    Thank you for making this video

  • @brunopradomusic
    @brunopradomusic 7 дней назад

    what an incredible channel

  • @Barter709
    @Barter709 7 дней назад

    Thank you! You helped two small businesses.

  • @adamthemulch
    @adamthemulch 8 дней назад

    hey how would i go about adding another column in the formula for like investments coloumn

  • @Sukooor
    @Sukooor 8 дней назад

    Will it update orice with every open??

  • @NadiaBro-v7g
    @NadiaBro-v7g 8 дней назад

    Thank you so much Brian, this is very helpful. I do have the same question about the "sort" option for the date.

  • @Ajaytshaju
    @Ajaytshaju 8 дней назад

    while using it further in 2024, do i need to change all things manually to get the report of 2024 and more?

  • @HelenOsborne-h3f
    @HelenOsborne-h3f 9 дней назад

    great

  • @Lilly-jo1pb
    @Lilly-jo1pb 9 дней назад

    Thank you so much!!!!!!!!!!!!!!!!!!! I was about to buy QuickBooks but no longer need to :) you're the best, def a new sub

  • @agronoxdt
    @agronoxdt 9 дней назад

    This just blew my mind... I am going to make this for myself as soon as my mind is back together.

  • @TommasoPretto
    @TommasoPretto 10 дней назад

    Thanks for the video, just wanted to flag that you should put 1+tax rate on bracket as what you got was (50*1.29)=64.5 *1= 64.5 +0.06035= ~64.56. Instead the right result would be $68.39

  • @jayaramanonda
    @jayaramanonda 11 дней назад

    THANK YOU VERY MUCH

  • @samzmuda1851
    @samzmuda1851 11 дней назад

    Thankyou! you are awesome for making this!

  • @MitchellDurham-z7p
    @MitchellDurham-z7p 11 дней назад

    The key to big returns is not big moving stocks. It's managing risk in relationship to reward. Having the correct size on and turning your edge as many times as necessary to reach your goal. That holds true from long term investing to day trading.

  • @dev-akeel
    @dev-akeel 12 дней назад

    I ❤ it, and I need even more advanced an updated.

  • @ThomasBohan
    @ThomasBohan 14 дней назад

    Brian, thank you very very helpful

  • @varghesekurien86
    @varghesekurien86 14 дней назад

    Thanks

  • @sunalogy
    @sunalogy 14 дней назад

    This is what I was looking for

  • @sunalogy
    @sunalogy 14 дней назад

    Amazing one...

  • @darylbancairen361
    @darylbancairen361 16 дней назад

    Thank you it really works... woooh

  • @maryhilker7526
    @maryhilker7526 16 дней назад

    I came accross this by accident. What an awesome video. Clear and consise training. This will really help me in my business! Thank you so much! You did an awesome job!

  • @daisyromo4634
    @daisyromo4634 16 дней назад

    Thank you

  • @zee-sports-international
    @zee-sports-international 16 дней назад

    Thank you, you are awesome. Your pace of teaching is just good for a GDF (God Damn Foreigner LOL)

  • @chanelmousier8494
    @chanelmousier8494 18 дней назад

    Can the OP help me please. Using this sheet successfully for two months now but the sheet stopped tracking revenue for me for some reason now.

  • @anonymousanonymous7770
    @anonymousanonymous7770 19 дней назад

    How would I go about adding a date I forgot to the earlier dates? Is there some sort of “sort” function to filter the dates out if I just want to see one date?

  • @anonymousanonymous7770
    @anonymousanonymous7770 20 дней назад

    How would I go about including credit card expenses here?

  • @hemants5496
    @hemants5496 20 дней назад

    Thanks a lot. How to track mutual funds ? like expenseratio or net assets AUM etc .. can you please share that too here ?

  • @dennisquach1233
    @dennisquach1233 21 день назад

    you the man! thank you! simple, clean, effective!

  • @metalmetalmetalify
    @metalmetalmetalify 21 день назад

    I love it!! Thank you so much

  • @sheisatabbym6014
    @sheisatabbym6014 22 дня назад

    This is fantastic, exactly what I needed. Thanks so much.

  • @flavialima5815
    @flavialima5815 22 дня назад

    Thank you!

  • @chibe1842
    @chibe1842 23 дня назад

    thank you so much

  • @camioneur
    @camioneur 23 дня назад

    I've been using your first spreadsheet on this topic for a year or so now which is great and this one looks even better, cheers Brian

    • @brianturgeon
      @brianturgeon 23 дня назад

      @@camioneur Glad to hear! Hope this one works for you too

  • @picklepete112
    @picklepete112 23 дня назад

    LETS FUCKING GOOOOOO

  • @mohummadshaikh86
    @mohummadshaikh86 24 дня назад

    this video was simple to understand, easy to follow and extremely helpful, thank you

  • @emilyrodriguez4704
    @emilyrodriguez4704 24 дня назад

    Wow!! This tutorial was amazing, thank you for helping me get my adult life together 😂

  • @asupplevoice
    @asupplevoice 24 дня назад

    Love this!!! Thank you so very much!!!

  • @sypherop
    @sypherop 24 дня назад

    Nice sheet. Appreciated. Thanks

  • @MyNigellus
    @MyNigellus 25 дней назад

    How to apply tickers from another region, another stock exchange than us?

  • @mbilly3013
    @mbilly3013 25 дней назад

    nice tutorial..building blocks for more advanced setup. thank you for the sharing the template.

  • @myrle-v4g
    @myrle-v4g 26 дней назад

    I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024

    • @Daneilchirs
      @Daneilchirs 26 дней назад

      Since risk is at an all-time high right now, perhaps you should be a little more patient and return when it has decreased. Alternatively, you can consult a trained financial expert for strategy.

    • @shizue-w7n
      @shizue-w7n 26 дней назад

      Yes true, I have been in touch with a brokerage Advisor. With an initial starting reserve of $80k, my advisor chooses the entry and exit commands for my portfolio, which has grown to approximately $550k.

    • @shanisonia
      @shanisonia 26 дней назад

      I’ve been looking to switch to an advisor for a while now. Any help pointing me to who your advisor is?

    • @shizue-w7n
      @shizue-w7n 26 дней назад

      Angela Lynn Shilling is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.

    • @shanisonia
      @shanisonia 26 дней назад

      I searched for her full name online, found her page, and sent an email to schedule a meeting. Hopefully, she responds soon. Thank you