ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS Brian Turgeon (bmturgeon) 2022-03-16 | 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 absolute reference.
Calendars Made Simple In Excel | Free Template Brian Turgeon (bmturgeon) 2025-09-23 | Learn how to make your own Excel calendar for tracking dates and appointments.Use the link below to access a free template (please make a copy after opening so you can edit):https://1drv.ms/x/c/ef9264ca3b57852c/EQPhvRUAaB5CutfYA8Q5n0YBugoSPuiwXWDp_-9GN5_UAg?e=N90VKV#Excel #Productivity #Organization
Create An Automatic STOCK TRACKER In Google Sheets Brian Turgeon (bmturgeon) 2025-09-02 | In this spreadsheet we use many of the features google sheets has to offer to build a personalized stock tracker that will assess your lifetime gains.Access the free template below:docs.google.com/spreadsheets/d/1_N4bTL3Y-aTVpd-B_mOixzK2JQWVHVGQQY329ipPpzA/edit?usp=sharing#excel #googlesheets #stocks
How To Make A Budget In Google Sheets | FREE TEMPLATE Brian Turgeon (bmturgeon) 2025-07-19 | Let's create a simple and easy monthly budget to get ahead of your finances. Use these google sheets tools to see your income and expenses in one place.Click the link below and make a copy to access the template of this sheet:docs.google.com/spreadsheets/d/1PUOoqCjxTOR51gWRoqwa1LhIOJX1cdmWQKg0-BaPNOM/edit?usp=sharing#googlesheets #budget #finance
2025 Expense Tracker | Excel Template Brian Turgeon (bmturgeon) 2025-07-15 | Let's create a spreadsheet that allows you to track all your income and expenses in one place. Simply enter in your transactions and the rest will take care of itself. Perfect tool for budgeting and helping you to meet your goals.Below is the link to the template created in this video. This file is read only so you first must make a copy to be able to edit.https://1drv.ms/x/c/ef9264ca3b57852c/EYp1rT5kdlpMrlUel8P4E38BJT8LpJtdPbPYk32cnFTP3Q?e=LBd8bE#Excel #Budget #Finance
SUMIF and SUMIFS in Excel | The MOST Useful Formula Brian Turgeon (bmturgeon) 2025-05-23 | Learn how to use the SUM, SUMIF, and SUMIFS functions in Microsoft Excel. These let you sum data sets in Excel based on one or multiple different criteria.#excel #sumif #spreadsheet
How To Make a Line Chart in Excel Brian Turgeon (bmturgeon) 2025-05-09 | Line charts can be made fast and easily in Excel. They are great tools to visualize both small and large data sets.#excel #spreadsheet #linechart
How To Format Phone Numbers in Excel Brian Turgeon (bmturgeon) 2025-05-04 | Discover how to use custom number formatting to make ten digit figures look more like an actual phone number with parentheses and dashes.#excel #tutorial #exceltutorial
Car Payment Calculator With Extra Payments | Excel Tutorial Brian Turgeon (bmturgeon) 2025-05-02 | Follow this spreadsheet if you want to figure out how much your monthly car payment will be. Also use the extra payments feature to see how you can decrease the amount of interest owed over the life of your loan.#excel #spreadsheet #car
How to Make a Drop Down List in Excel Brian Turgeon (bmturgeon) 2025-04-26 | Here are the two main methods you can use to create simple drop down lists in your spreadsheets.
How To Remove Gridlines in Excel Brian Turgeon (bmturgeon) 2025-04-22 | To remove gridlines in an Excel spreadsheet simply go to the view tab and deselect gridlines under the show group.
How to Track Your Finances in 2024 | Automated Google Sheets Template Brian Turgeon (bmturgeon) 2024-07-11 | 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
Mortgage Calculator WITH Extra Payments | Google Sheets Brian Turgeon (bmturgeon) 2023-10-18 | 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.
How To Make SPARKLINES | The Coolest Feature in Google Sheets Brian Turgeon (bmturgeon) 2023-05-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 - WinLoss1:52 - Line3:00 - Column4:50 - Bar7:35 - Stock (Column)youtube.com/@BrianTurgeon#GoogleSheets #Excel #Sparklines
How To Track Your Habits in Google Sheets | Boost Productivity! Brian Turgeon (bmturgeon) 2023-04-19 | 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/1xyM17RjRpTzARt1WQBYOocJWmV6iu3KDTmIlhu7tSzQ/edit#gid=0#GoogleSheets #Excel #Habits
Track School Assignments in Google Sheets Brian Turgeon (bmturgeon) 2023-03-01 | 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!youtube.com/BrianTurgeoninstagram.com/brianturgeon.yt#Excel #GoogleSheets #School
How To Track High Yield Dividend Stocks in Google Sheets Brian Turgeon (bmturgeon) 2023-02-08 | 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 #Excelyoutube.com/@BrianTurgeoninstagram.com/brianturgeon.yt
How To Keep Zeroes From Disappearing in Google Sheets Brian Turgeon (bmturgeon) 2023-01-30 | Use custom number formatting in Google Sheets to keep your leading zeroes in zip codes.
How To Track Your Expenses | Mind Blowing Google Sheets Tutorial Brian Turgeon (bmturgeon) 2023-01-19 | 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 #Excelyoutube.com/@BrianTurgeoninstagram.com/brianturgeon.yt
How to Create the Best To Do List in Google Sheets Brian Turgeon (bmturgeon) 2023-01-11 | 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 Intro00:19 Inserting Checkboxes00:51 Alternating Colors02:09 Visual Enhancements02:51 Tracking How Much of List is Complete
Say Goodbye to VLOOKUPs. Use XLOOKUP in Google Sheets Instead. Brian Turgeon (bmturgeon) 2023-01-03 | 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 Brian Turgeon (bmturgeon) 2022-12-07 | 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 Brian Turgeon (bmturgeon) 2022-12-05 | Gridlines can be removed in Google Sheets under the "View" tab.
Easy TIME ENTRY Tracker in GOOGLE SHEETS Brian Turgeon (bmturgeon) 2022-08-26 | 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:youtube.com/watch?v=BYZynIXm-Yo&t=4s
Finding The HIGHEST or LOWEST Values Of A Range In GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-12-27 | 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 Brian Turgeon (bmturgeon) 2021-08-11 | An age calculator can be created in Microsoft Excel using the DATEDIF function.
Summing Values Based on One Or More Criteria In Microsoft Excel Brian Turgeon (bmturgeon) 2021-07-27 | SUM: The SUM function allows one to find the total sum of a range of values.SUMIF: The SUMIF function allows one to find the total sum of a range of values based on a criteria.SUMIFS: The SUMIFS function allows one to find the total sum of a range of values based on one or more criteria.
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets Brian Turgeon (bmturgeon) 2021-07-03 | Easily build a complete stock watchlist in Google Sheets. Here's my template for this sheet:docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV7ANkBZK027RI_CouSsDM0XfmQ/edit?usp=sharingLinks to referenced videos can be found below:GOOGLE FINANCE: youtu.be/94XpstOfZoUCUSTOM # FORMAT (POS. OR NEG.):youtu.be/8Kn2Bm1Dok0CUSTOM # FORMAT (LARGE NUMBERS):youtu.be/iXGoznnWphQINDEX FUNCTION:youtu.be/hH54skyJfvgIF ERROR:youtu.be/R7E7BC1FjMgALTERNATING COLORS:youtu.be/K_iOt87vKFEREFERENCE CELLS:youtu.be/HRzfHcgDvyk#GoogleFinance #StockWatchlist #StockTracker
Google Sheets - How To Import Data From Another Sheet Brian Turgeon (bmturgeon) 2021-06-30 | In this video we learn how to import data from an existing sheet to a new sheet using the IMPORTRANGE function.
CUSTOM FORMATTING OF PHONE NUMBERS IN MICROSOFT EXCEL Brian Turgeon (bmturgeon) 2021-06-10 | There are endless possibilities for how you can you custom number formatting in MICROSOFT EXCEL. For the sake of this video, we discuss how you can make a custom format for PHONE NUMBERS so that they appear the correct way in each cell of your spreadsheet.
REFERENCE CELLS With The Dollar Sign In GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-06-08 | The use of the dollar sign in a GOOGLE SHEETS function can allow you to lock rows and/or columns in place as you drag a function out either way.
Joining Cells with the CONCATENATE Function in GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-06-06 | The CONCAT and CONCATENATE functions in GOOGLE SHEETS allow the user to pull data from multiple cells and display it in a single string under one cell.
GOOGLE SHEETS BASIC TUTORIAL Brian Turgeon (bmturgeon) 2021-05-30 | This basic Google Sheets tutorial contains many of the most important functions that you will need to know. Some of them have other videos on this channel and they can all be found on the same playlist below:youtube.com/playlist?list=PL2UYNY-mZ8NL0jZa_n16NOzCZ26dXmKV6
COUNTING Values with the COUNTA Function in GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-05-18 | The COUNTA function is similar to the COUNT function in that they both count the amount of values in a range. The difference is that the COUNT function only counts numerical values, while the COUNTA function counts the amount of non-empty cells.
KEYBOARD SHORTCUTS for a MAC in GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-05-05 | There are many keyboard shortcuts in google sheets. Today we go over many of the important ones and how to do them on a Mac:Open Keyboard Shortcut Menu: Command + /Copy: Command + CPaste: Command + VFind: Command + FUndo: Command + ZOpen Find and Replace Menu: Command + Shift + HSelect Column: Ctrl + SpaceSelect Row: Shift + SpaceFill Cells:Fill Range: Command + EnterFill Down: Command + DFill Right: Command + RFormat Text:Bold: Command + BItalic: Command + UUnderline: Command + IText Alignment:Left Align: Command + Shift + LCenter Align: Command + Shift + ERight Align: Command + Shift + RChange Number Type:Decimal: Ctrl + Shift + 1Time: Ctrl + Shift + 2Date: Ctrl + Shift + 3Currency: Ctrl + Shift + 4Percentage: Ctrl + Shift + 5Exponent: Ctrl + Shift + 6Cell Borders:Top Border: Option + Shift + 1Right Border: Option + Shift + 2Bottom Border: Option + Shift + 3Left Border: Option + Shift + 4Clear Borders: Option + Shift + 6Full Borders: Option + Shift + 7
Counting Years and Days BETWEEN TWO DATES in Google Sheets Brian Turgeon (bmturgeon) 2021-05-01 | Using the YEARFRAC function one can count the number of years between two dates. Alternatively the MINUS function can help you to count the number of days between two dates. We will also look at the TODAY function which will perpetually change your counts if you are counting the number of years or days from today.
FORMAT POSITIVE AND NEGATIVE NUMBERS WITH CUSTOM NUMBER FORMATTING Brian Turgeon (bmturgeon) 2021-04-30 | With Custom Number Formatting you can alter the way values appear in a cell in many ways. In this video we will talk about some of the basic syntax of custom number formatting and how you can use it to alter font color and add other features fro positive and negative numbers.
CUSTOM FORMATTING OF PHONE NUMBERS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-29 | Custom Number Formatting allows you to make many different alterations to your spreadsheet. In this video we will look at how to format a 10 digit number into a visually appealing phone number.
CUSTOM NUMBER FORMATTING OF MILLIONS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-28 | Custom Number Formatting in Google Sheets is very open ended and allows many options. In this video we will discuss how to take a large number and make it easier to view by adding comma separators, decimal places and other symbols.
INDEX FUNCTION TUTORIAL IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-24 | The Index Function in Google Sheets allows you to pull a piece of data from a set. By embedding another function into an index function you can do many things...Link to related video:youtube.com/watch?v=94XpstOfZoU&t=1s
FIXING ERROR MESSAGES IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-21 | Error messages are common occurrences in Google Sheets and they can be altered to display something other than the error message.
ROWS WITH ALTERNATING COLORS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-17 | Make rows or columns with Alternating Colors in Google Sheets.Link to previous Alternating Colors Video below:youtu.be/K_iOt87vKFE
ADDING ALTERNATING COLORS INTO GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-13 | Alternating Colors allows you to view data more easily by changing the background color of every other row.
USE CONDITIONAL FORMATTING TO COLOR CELLS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-04-03 | Conditional Formatting allows one to take a range and apply color to it based on many different criteria.
CREATING A DROPDOWN MENU IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-03-25 | How to easily create a Dropdown Menu in Google Sheets using Data Validation!
FILTERS IN GOOGLE SHEETS EXPLAINED Brian Turgeon (bmturgeon) 2021-03-17 | By using FILTERS in Google Sheets, one can sort the data of a range in many different ways.
USING THE COUNT, COUNTIF, AND COUNTIFS FUNCTIONS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-03-06 | The COUNT, COUNTIF, and COUNTIFS functions in Google Sheets allow you to count the amount of values in a range given no criteria, one criteria, or multiple criteria.
USING GOOGLE FINANCE TO ANALYZE STOCKS IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-02-28 | The GOOGLE FINANCE function allows you to see real time and historical data on stocks.
SUM, SUMIF, AND SUMIFS TUTORIAL IN GOOGLE SHEETS Brian Turgeon (bmturgeon) 2021-02-20 | Use the SUM, SUMIF, and SUMIFS functions in Google Sheets or Microsoft Excel to find the sum of a range given no criteria, one criteria, or multiple criteria.
