Brian Turgeon
Brian Turgeon
  • 39
  • 1 655 229
Mortgage Calculator WITH Extra Payments | Google Sheets
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 over the life of your loan.
Переглядів: 13 697

Відео

How To Make SPARKLINES | The Coolest Feature in Google Sheets
Переглядів 10 тис.Рік тому
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!
Переглядів 3,8 тис.Рік тому
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! ua-cam.com/users/BrianTurgeo...
How To Track High Yield Dividend Stocks in Google Sheets
Переглядів 42 тис.Рік тому
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
Переглядів 14 тис.Рік тому
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
Переглядів 370 тис.Рік тому
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
Переглядів 4,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
Переглядів 757Рік тому
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
Переглядів 81 тис.Рік тому
Gridlines can be removed in Google Sheets under the "View" tab.
Easy TIME ENTRY Tracker in GOOGLE SHEETS
Переглядів 1,7 тис.Рік тому
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: ua-cam.com/video/BYZynIXm-Yo/v-deo.html
ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS
Переглядів 4,9 тис.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
Переглядів 21 тис.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
Переглядів 8382 роки тому
An age calculator can be created in Microsoft Excel using the DATEDIF function.
Summing Values Based on One Or More Criteria In Microsoft Excel
Переглядів 8582 роки тому
Summing Values Based on One Or More Criteria In Microsoft Excel
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
Переглядів 913 тис.2 роки тому
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
Google Sheets - How To Import Data From Another Sheet
Переглядів 1,6 тис.2 роки тому
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
Переглядів 12 тис.3 роки тому
REFERENCE CELLS With The Dollar Sign In GOOGLE SHEETS
Joining Cells with the CONCATENATE Function in GOOGLE SHEETS
Переглядів 9373 роки тому
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
Переглядів 8393 роки тому
COUNTING Values with the COUNTA Function in GOOGLE SHEETS
KEYBOARD SHORTCUTS for a MAC in GOOGLE SHEETS
Переглядів 12 тис.3 роки тому
KEYBOARD SHORTCUTS for a MAC in GOOGLE SHEETS
Counting Years and Days BETWEEN TWO DATES in Google Sheets
Переглядів 1,2 тис.3 роки тому
Counting Years and Days BETWEEN TWO DATES in Google Sheets
FORMAT POSITIVE AND NEGATIVE NUMBERS WITH CUSTOM NUMBER FORMATTING
Переглядів 2,7 тис.3 роки тому
FORMAT POSITIVE AND NEGATIVE NUMBERS WITH CUSTOM NUMBER FORMATTING
CUSTOM FORMATTING OF PHONE NUMBERS IN GOOGLE SHEETS
Переглядів 52 тис.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,7 тис.3 роки тому
INDEX FUNCTION TUTORIAL IN GOOGLE SHEETS
FIXING ERROR MESSAGES IN GOOGLE SHEETS
Переглядів 4,5 тис.3 роки тому
FIXING ERROR MESSAGES IN GOOGLE SHEETS

КОМЕНТАРІ

  • @growmybusinessonline5711
    @growmybusinessonline5711 День тому

    Thanks you Brian. Can this be done for Forex and Commodities?

  • @larryreed641
    @larryreed641 День тому

    Just what I was looking for! You did a great job with this video. I am a complete novice compared to you. Thank you.

  • @dannybirai
    @dannybirai День тому

    amazing! Thanks brother

  • @justynyocu7673
    @justynyocu7673 2 дні тому

    Under the Revenues chart I'm getting a #VALUE! in the total box and says error Array arguments to SUMIFS are of different size, help please

  • @rer1967
    @rer1967 3 дні тому

    Thank you so much for this video. I've been trying to calculate paying off my mortgage in the next two years based on additional principal. This worked perfectly!

  • @Dennis_here
    @Dennis_here 3 дні тому

    Bro is gone (⁠⊙⁠_⁠◎⁠)

  • @gilbertroybal7561
    @gilbertroybal7561 5 днів тому

    What version of excel are you using. I tried entering the =googlefinance and it would not work. Thanks Gilbert

  • @Ironfistinavelvetglove
    @Ironfistinavelvetglove 5 днів тому

    Montserrat is now my favorite. Thanks Brian

  • @micahjohnsonbass9498
    @micahjohnsonbass9498 6 днів тому

    Thank you bro

  • @ArthurMorelcrea
    @ArthurMorelcrea 6 днів тому

    hello, very helpfull video, how can i change the currency please ?

  • @MaribertJurado
    @MaribertJurado 7 днів тому

    Thank you so much for your video

  • @HAX3MEW
    @HAX3MEW 7 днів тому

    Thank you so much! This is going to save me so much work and time! You have no idea how happy I am right now!

  • @JennelJohnNatindim
    @JennelJohnNatindim 9 днів тому

    Thank you Brian! Great help!!

  • @rodneymaina4351
    @rodneymaina4351 9 днів тому

    Amazing video! Definitely moving from Notion.

  • @lasombra325
    @lasombra325 10 днів тому

    El mejor video que he visto en mucho tiempo , excelente maestro y comparte su saber generosamente

  • @beautifulplaces6328
    @beautifulplaces6328 12 днів тому

    Thank you I was getting frustrated, am learning to use Google sheet

  • @dynamicsinDividends6636
    @dynamicsinDividends6636 12 днів тому

    Maybe add a field for the # of shares?

  • @suthanawatwiangsima5660
    @suthanawatwiangsima5660 13 днів тому

    thank you

  • @SapphireUnique
    @SapphireUnique 13 днів тому

    saved me hours, thanks legend

  • @yuvrajsingh8960
    @yuvrajsingh8960 13 днів тому

    last part didnt make sense

  • @kwijukaderek4682
    @kwijukaderek4682 13 днів тому

    And trust me your effort is highly appreciated.thanx again

  • @manasandmohit
    @manasandmohit 16 днів тому

    Nice guide

  • @Replace.Garage.Door.Spring...
    @Replace.Garage.Door.Spring... 16 днів тому

    1:10 - 1:41 Select HIGHLIGHT the range ,click FORMAT tab , select ALTERNATING COLORS and whoo hoo!Thanks

  • @milfinu
    @milfinu 16 днів тому

    2:32 You make it more complicated than it should be, all you have to do is click the top of collum and stretch it out to the width you need it at. NOT EVERY one knows what size is 150 or 600. its easier to just click and drag

  • @WmLatin
    @WmLatin 17 днів тому

    keystroke to use to change relative to absolute? Everything says F4 which makes no sense on a chromebook ! F4 is used for desktop overview

  • @DonShader
    @DonShader 17 днів тому

    This was great. I'm 72 years old and even though it took a couple days, I managed to follow along, find my own mistakes and ultimately made it work as instructed. This was fun and it will be very useful. What's next?

  • @danromesaint
    @danromesaint 19 днів тому

    Hey Brian, Appreciate you making this video, learned a lot!

  • @Petersworld77
    @Petersworld77 19 днів тому

    I’m new to google sheets, this is great info thanks

  • @zoeeforder3844
    @zoeeforder3844 21 день тому

    Do you have a version of this that allows for variable interest rates, but the minimum monthly payment remains the from that change. ie original payment is $170 per week at 10.%pa, then 6 months later the rate changes to 11.25% and the new minimum payment is $173 without the minimum payment changing as the principal goes down. Thanks

  • @MadeItEasyBeauty
    @MadeItEasyBeauty 21 день тому

    this was very very helpful! thanks for taking the time to share!

  • @chidinmamoses6084
    @chidinmamoses6084 21 день тому

    This is brilliant!

  • @vivianang3741
    @vivianang3741 22 дні тому

    Thanks Brian! Sending you love and support from Singapore!

  • @FedericoDeObeso
    @FedericoDeObeso 22 дні тому

    AWESOME!!! Most appreciated

  • @tsunzaki
    @tsunzaki 23 дні тому

    Thanks so much your about to change my life with this.

  • @Stevesutanto79
    @Stevesutanto79 23 дні тому

    Very easy to follow and super helpful - thank you!

  • @sayan_919
    @sayan_919 23 дні тому

    Thank you. This really helped

  • @boedeful
    @boedeful 23 дні тому

    thx

  • @ktran991
    @ktran991 23 дні тому

    Beautiful. Thank you!

  • @duvanjulio8870
    @duvanjulio8870 23 дні тому

    Hello, you can please do a video about how to take out the RSI of a stock i Will really apreciate It

  • @radmac8699
    @radmac8699 24 дні тому

    This is SUPER helpful! Tysm for the how to video.

  • @amritasingharay3095
    @amritasingharay3095 25 днів тому

    Best video ❤

  • @briannperry3553
    @briannperry3553 26 днів тому

    M having trouble where it showing all revenue calculations instead of one drop down. can anyone help?

  • @cordlefhrichter1520
    @cordlefhrichter1520 26 днів тому

    I had made my own spreadsheet but this one is much cooler.

  • @yoflor6412
    @yoflor6412 28 днів тому

    Loved your video. It was very detailed. I plan to use it to keep up with my finances. I can tell you put in a lot of work. I appreciate you sharing your work.

  • @Sakibweb3
    @Sakibweb3 28 днів тому

    great , a life saver 🙏🙏

  • @vs009
    @vs009 29 днів тому

    really really appreciate the video bro. Keep growing :)

  • @TeeTalesFashion
    @TeeTalesFashion Місяць тому

    do you have any sheets for the stocks Portfolio?

  • @svenlim6899
    @svenlim6899 Місяць тому

    Hey brother, all I can say is thank you so much for this video! It helps me alot to keep track. Liked and subscribed to you!

  • @manhonlee7691
    @manhonlee7691 Місяць тому

    👍👍👏👏

  • @susanmedina2969
    @susanmedina2969 Місяць тому

    I’ve never used Sheets before. This was a great tutorial and I made my kids help me too so they could learn. Thank you!