![Brian Turgeon](/img/default-banner.jpg)
- 39
- 1 655 229
Brian Turgeon
United States
Приєднався 9 кві 2016
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.
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
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
Thanks you Brian. Can this be done for Forex and Commodities?
Just what I was looking for! You did a great job with this video. I am a complete novice compared to you. Thank you.
amazing! Thanks brother
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
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!
Bro is gone (⊙_◎)
What version of excel are you using. I tried entering the =googlefinance and it would not work. Thanks Gilbert
Montserrat is now my favorite. Thanks Brian
Thank you bro
hello, very helpfull video, how can i change the currency please ?
Thank you so much for your video
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!
Thank you Brian! Great help!!
Amazing video! Definitely moving from Notion.
El mejor video que he visto en mucho tiempo , excelente maestro y comparte su saber generosamente
Thank you I was getting frustrated, am learning to use Google sheet
Maybe add a field for the # of shares?
thank you
saved me hours, thanks legend
last part didnt make sense
And trust me your effort is highly appreciated.thanx again
Nice guide
1:10 - 1:41 Select HIGHLIGHT the range ,click FORMAT tab , select ALTERNATING COLORS and whoo hoo!Thanks
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
keystroke to use to change relative to absolute? Everything says F4 which makes no sense on a chromebook ! F4 is used for desktop overview
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?
Hey Brian, Appreciate you making this video, learned a lot!
I’m new to google sheets, this is great info thanks
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
this was very very helpful! thanks for taking the time to share!
This is brilliant!
Thanks Brian! Sending you love and support from Singapore!
AWESOME!!! Most appreciated
Thanks so much your about to change my life with this.
Very easy to follow and super helpful - thank you!
Thank you. This really helped
thx
Beautiful. Thank you!
Hello, you can please do a video about how to take out the RSI of a stock i Will really apreciate It
This is SUPER helpful! Tysm for the how to video.
Best video ❤
M having trouble where it showing all revenue calculations instead of one drop down. can anyone help?
I had made my own spreadsheet but this one is much cooler.
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.
great , a life saver 🙏🙏
really really appreciate the video bro. Keep growing :)
do you have any sheets for the stocks Portfolio?
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!
👍👍👏👏
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!