- Видео 43
- Просмотров 91 509
Spreadsheets Made Simple
США
Добавлен 13 янв 2019
This is the channel for Excel and Google Sheets Spreadsheet enthusiasts of all levels of skill. Please subscribe to this channel to learn new Spreadsheet skills to apply in your professional and personal lives to increase your productivity, save valuable time, and set yourself apart from the crowd.
DIY - How to install/replace a GFCI outlet tutorial
You can find a GFCI Outlet I recommend below:
amzn.to/3QvwEd5
In this video, we'll do a walkthrough of how to install or replace a GFCI Outlet, covering the following:
1. Why a GFCI outlet is needed
2. Difference between a GFCI outlet and a standard outlet
3. How to identify the Line vs. Load wires
4. Wiring the GFCI Outlet
5. Testing the GFCI Outlet
amzn.to/3QvwEd5
In this video, we'll do a walkthrough of how to install or replace a GFCI Outlet, covering the following:
1. Why a GFCI outlet is needed
2. Difference between a GFCI outlet and a standard outlet
3. How to identify the Line vs. Load wires
4. Wiring the GFCI Outlet
5. Testing the GFCI Outlet
Просмотров: 221
Видео
DIY - Laundry Room Clothesline Install Tutorial - GorillaLine
Просмотров 409Месяц назад
Follow along with the install a demonstration of the GorillaLine retractable laundry clothesline. To learn more, and to purchase, follow the link below: amzn.to/3xAVLVb In this video, we will cover: 1. What's included in the box 2. What tools you will need 3. Installing the retractable clothesline 4. How to use the retractable clothesline
DIY - Centerset Faucet Install/Replacement Tutorial
Просмотров 312Месяц назад
In this tutorial we will cover the entire process of replacing and existing centerset faucet with a new centerset faucet. The centerset faucet shown in this video is the Allen and Roth Reagan Matte Blacke 4" Centerset faucet. You can find this faucet here: Reagan Matte Black 4-in centerset 2-Handle WaterSense Handle Bathroom Sink Faucet with Drain and Deck Plate www.lowes.com/pd/allen-roth-4-In...
DIY - Farmhouse Style Basement Support Column Install
Просмотров 143Месяц назад
Follow along with this tutorial for dressing up your basement support columns in a farmhouse style design. In this tutorial, I cover the following steps: 1. Remove the existing column design (if any) 2. Installing the wood boards for your accent (primed pine boards) 3. Sanding the boards 4. Caulking along all the seams 5. Painting (edging and rolling) Below are the tools and materials I used: -...
DIY - How to Install a New Toilet or Re-Install your Existing Toilet
Просмотров 13 тыс.2 месяца назад
Follow along to find out how to install a new toilet or re-install your existing toilet, such as after having to remove it to install new flooring. In this video, I will cover: 1. How to install the tank bolts 2. How to install the wax ring 3. How to position the toilet back over the drain 4. How to ensure the wax ring creates a watertight seal 5. How to tighten down the tank bolts 6. How to re...
DIY - How to Replace a Garbage Disposal Insinkerator
Просмотров 4 тыс.2 месяца назад
Follow along to find out how to replace your Garbage Disposal under your kitchen sink! In this video I am specifically replacing an InSinkErator Badger 5 with a new InSinkerator Badger 5XL. Learn how to replace your Garbage Disposal in less than 15 minutes!
Rental & Flip Property Calculator - Tutorial (Google Sheets)
Просмотров 3063 месяца назад
For more information, and to purchase, please visit: www.fiverr.com/s/EZa149 Welcome to the Real Estate Investment Property Calculator! This power tool is packed with everything you'll need to evaluate your future potential investment property deals, including: - Includes both a Rental Property Calculator and a Fix & Flip Calculator - Easy to follow step by step process for evaluating your deal...
Real Estate Property Flipping Finance Tracker - Tutorial (Google Sheets)
Просмотров 293 месяца назад
For more information, and to purchase, please visit: www.fiverr.com/s/j6kPym I will send you a Google Sheets template that will help you manage your Property Investment/Flipping business operations and finances. This template will be your one stop shop, comprehensive tool for all your Real Estate Investments needs. The following are some of the many highlights of this template's included featur...
Employee PTO Time Off Tracker - Tutorial (Google Sheets)
Просмотров 8044 месяца назад
For more information, and to purchase, please visit: www.fiverr.com/s/9y5dvA Welcome to the Employee PTO Time Off Tracker Google Sheets Template! This spreadsheet makes it incredible simple to track and manage your employees time off, as well as you own, and offers the following features: - Template only needs to be purchased one time and can be used for many years to come! - Ability to track P...
Monthly Bill Tracker - Tutorial (Google Sheets)
Просмотров 1354 месяца назад
For more information, and to purchase, please visit: www.fiverr.com/pft_president/send-you-a-monthly-bill-tracker-google-sheets-tempate Welcome to the Monthly Bill Tracker Google Sheets template. This software was designed to make tracking your Monthly Bills as simple as possible. It will allow you to track up to 60 unique bills, and will help you never be late on a payment again. It will autom...
Personal Finance Savant - Personal Finance Google Sheets - Analytics Dashboards Tutorial
Просмотров 137Год назад
FREE TRIAL VERSION AVAILABLE USING THE LINK BELOW. For more information, and to purchase, please visit: www.fiverr.com/share/vxlyNZ Welcome to the Personal Finance Savant Google Sheets template! This video focuses on an in-depth tutorial on the Analytics Dashboards included in the Personal Finance Savant program. For a high level Overview of the software, please check out the link below: ruclip...
Personal Finance Savant - Personal Finance Google Sheets - Data Entry Tutorial
Просмотров 79Год назад
FREE TRIAL VERSION AVAILABLE USING THE LINK BELOW. For more information, and to purchase, please visit: www.fiverr.com/share/vxlyNZ Welcome to the Personal Finance Savant Google Sheets template! This video focuses on an in-depth tutorial on the Data Entry sections included in the Personal Finance Savant program. For a high level Overview of the software, please check out the link below: ruclips...
Personal Finance Savant - Personal Finance Google Sheets - Financial Calculators Tutorial
Просмотров 75Год назад
Access the calculator portion of the template for FREE here: docs.google.com/spreadsheets/d/1f5nW-N6THJvF9QOZj6e5P2Ur7vgiiz-_4TgPs7g8nDw/copy FULL VERSION FREE TRIAL AVAILABLE USING THE LINK BELOW. For more information, and to purchase, please visit: www.fiverr.com/share/vxlyNZ Welcome to the Personal Finance Savant Google Sheets template! This video focuses on an in-depth tutorial on the Finan...
Personal Finance Savant - Personal Finance Google Sheets - Overview Video
Просмотров 282Год назад
FREE TRIAL VERSION AVAILABLE USING THE LINK BELOW. For more information, and to purchase, please visit: www.fiverr.com/share/vxlyNZ Welcome to the Personal Finance Savant Google Sheets template! This video focuses on a high level overview of the purpose of this Google Sheets program and how to use it. For an in-depth tutorial on any of the sections of this program, please check out the links be...
Personal Finance Series - Taxes (Part 2)
Просмотров 59Год назад
Welcome to our second video in our Personal Finance series. This video is intended to give you an introduction on the different topics related to Taxes you are likely to come across in your personal life. Some of the topics include: 1. What taxes are & how they are allocated 2. What are all the taxes we pay 3. How are the taxes we owe calculated 4. Case study of a fictitious individual and all ...
Barbershop Owner Financial Tracker Spreadsheet - Tutorial
Просмотров 983Год назад
Barbershop Owner Financial Tracker Spreadsheet - Tutorial
Personal Finance Series - Financial Accounts (Part 1)
Просмотров 48Год назад
Personal Finance Series - Financial Accounts (Part 1)
Personal Finance Introduction 101 (For Beginners)
Просмотров 94Год назад
Personal Finance Introduction 101 (For Beginners)
Personal Budget Tracker - Tutorial (Google Sheets)
Просмотров 3932 года назад
Personal Budget Tracker - Tutorial (Google Sheets)
Wedding Budget Planner - Tutorial (Google Sheets)
Просмотров 1,5 тыс.2 года назад
Wedding Budget Planner - Tutorial (Google Sheets)
Employee Work Schedule Template - Tutorial (Google Sheets)
Просмотров 12 тыс.2 года назад
Employee Work Schedule Template - Tutorial (Google Sheets)
Personal Finance Dashboard - Tutorial (Google Sheets)
Просмотров 3,9 тыс.2 года назад
Personal Finance Dashboard - Tutorial (Google Sheets)
Barber Financial Tracker Spreadsheet - Tutorial
Просмотров 2,1 тыс.2 года назад
Barber Financial Tracker Spreadsheet - Tutorial
Employee Work Schedule Tracker - Version 2 - Tutorial (Microsoft Excel)
Просмотров 1,3 тыс.2 года назад
Employee Work Schedule Tracker - Version 2 - Tutorial (Microsoft Excel)
Work Calendar Tracker - Tutorial (Microsoft Excel)
Просмотров 3,6 тыс.2 года назад
Work Calendar Tracker - Tutorial (Microsoft Excel)
Monthly Bill Tracker - Tutorial (Microsoft Excel)
Просмотров 20 тыс.2 года назад
Monthly Bill Tracker - Tutorial (Microsoft Excel)
Employee Work Schedule Tracker - Tutorial (Microsoft Excel)
Просмотров 17 тыс.2 года назад
Employee Work Schedule Tracker - Tutorial (Microsoft Excel)
Small Business Finance Tracker - Tutorial (Microsoft Excel)
Просмотров 5732 года назад
Small Business Finance Tracker - Tutorial (Microsoft Excel)
Personal Budget Tracker - Tutorial (Microsoft Excel)
Просмотров 2,4 тыс.2 года назад
Personal Budget Tracker - Tutorial (Microsoft Excel)
Wedding Budget Spreadsheet - Tutorial (Microsoft Excel)
Просмотров 6782 года назад
Wedding Budget Spreadsheet - Tutorial (Microsoft Excel)
Thank you 🙏✝️
Thank you for watching, glad you got value from the video!
You are a lifesaver thanks!
Thank you for watching and your comment!
Can you add notes to the pymt amt? Like a confirmation number and date paid or any other information needed to be noted?
Hello, Thank you for watching and your comment! Yep, you can add a comment to the cell in addition to the actual data you enter for that cell. To do this, you just go to the "Review" tab in Excel at the top, then click "New Comment". Hope this helps!
Forgot the caps which the anchor of must be placed UNDER the washer, before the nuts
Hi Joseph, Thank you for watching and your comment. You're correct I didn't use the cap anchor in my installation. In my case I reused the caps from the previous install which the anchors were old and damaged, so I decided not to try to reuse them and also view those anchors as a nice to have vs must have. Good catch though!
How do I get this ? I couldn’t find it
Hello, Thank you for watching and your interest! You can purchase this template using the link below: www.fiverr.com/s/wvdXDr?CopyLink_Mobile Please feel free to reach out there with any questions!
Where's the child support bill?
That one is a write in! There is a default list built it, but any custom ones can be added as needed.
hello, i see you put toilet down and line up both side the tank bolts down only , i wonder how you know center hole in middle wax ring my concern off center hole will cause it leak ? thanks for video
Hi Bryan, Thank you for watching and for your question. As long as the tank bolts are in the proper position, meaning you've slotted them all the way to the end of the track, then they will be directly opposite each other and on opposite sides of the wax ring. In this case, if you line up the toilet with the tank bolts, you can also be sure the wax ring is in correct alignment. I hope this helps address your concerns. Thanks again!
After a few days of use, should you go back and re-tighten the jonny bolts?
Hello, Thank you for watching and your question. I've never had to do this in the past and haven't had any issues. As long as you install the toilet properly the first time, meaning making sure to put some weight on the toilet to fully compress/seal the wax ring before tightening the tank bolts down, it shouldn't settle any further. However, for peace of mind you could always go back and tighten it a little more if it feels loose, but don't feel like you need to tighten it so much that you're worried the toilet might crack.
@@spreadsheetsmadesimple6342 great answer sir! Thank you
Promo>SM
how can I download this template
Hello, Thank you for watching and your interest! You can find more information and purchase this template here: www.fiverr.com/s/DAo3Qo?CopyLink_Mobile Please feel free to reach out there with any other questions
Can I still purchase this ?
Hello, Thank you for watching and your interest! Of course, you can purchase on Fiverr here: www.fiverr.com/s/LbWkw7 Please feel free to reach out there with any questions!
Do u have free download. Thank u
Hello, Thank you for watching and your interest! Please reach out to me in the link in description above and I will do my best to help you out
This is amazing, than you!
Thank you for watching!
I'm not sure how to integrate this to day to day if I am using auto pay. It feels redundant. Maybe it's only for small businesses? I can see the value of having a general idea of what cost how much a year and that it keeps track of every year, just not the checking off for auto payments if that makes sense
Thank you for watching! This template really provides the most value to folks who still prefer to manually pay their bills so they are aware of how much they are paying and to avoid paying late fees. For those that use autopay, it would mainly be valuable to know how much each bill is costing you on a yearly basis so you can budget accurately and also so you are aware of all the subscriptions (Netflix, Gym, Spotify, Meal Service, Etc.) and potentially decide which ones to cut out if they're not getting used.
please help..if employee's shift is from 12pm-8:30pm, how can I tag these hours or entire shift as 1? currently, it only tag the start time as 1 using formula: =COUNTIF(Schedule!$J$3,B5) I hope you can help me.
I need one with around 60 lines do you have that or can you add more lines if need be?
Hello, Thank you for watching and your interest! I have created an expanded version that goes up to 60 bills. Please check out the link in the video description for more info.
Great video but I urge you to go check that breathing problem you have it sounds really bad you maybe feeling normal but I'm telling you go get that checked
Thank you (deep breathe) for you watching and (deep breathe) your concern. I'm not quite sure (deep breathe) what breathing problem (deep breathe) you're referring to. :)
Where can I get this template from? I would love to use this
Thank you for watching and for your interest in this template. You can find more info here: www.fiverr.com/s/0oX0e2?CopyLink_Mobile
How to dwonlaod free sample?
Hello, Thank you for your interest! Please reach out to me in the link in the description to get set up with your 3-Month Free Trial.
@@spreadsheetsmadesimple6342I can try to open link for 3 month trail version but I can not open this file Pl send direct link of this file
But how did you make the template itself
What is the name for it on non apple laptop with mircosoft 365?
Hello great table! I want to ask if you know how I'm able to automate the whole process of generating this automatically each week? With the added option of being able to change the hours and pay rates too. My employees have set work schedules.
Hello, Thank you for watching and your comment! Since it sounds like your employees have the same schedule each week and you only need to make minor edits occasionally week to week, I would recommend just duplicating the file each week and then all your would need to do is edit the week starting date and any hours and pay rates. Hope that helps!
@@spreadsheetsmadesimple6342 Thank you so much for replying so fast!!! I ended up going with a simple googlesheets script. Here it is just in case anyone may find this helpful in the future: function addNewTable() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Expense_Track_Spreadsheet1'); var lastRow = sheet.getLastRow(); var lastColumn = sheet.getLastColumn(); var tableHeight = 8; // Adjust this to match the number of rows in each table var tableStart = lastRow - tableHeight + 1; // This should be the row number where the latest table starts var tableRange = sheet.getRange('A' + tableStart + ':' + sheet.getRange(lastRow, lastColumn).getA1Notation()); sheet.insertRowsAfter(lastRow, tableHeight); var newRange = sheet.getRange('A' + (lastRow + 1) + ':' + sheet.getRange(lastRow + tableHeight, lastColumn).getA1Notation()); tableRange.copyTo(newRange); // Add one day to each date in the new table var newDate; for (var i = 0; i < tableHeight - 1; i++) { // Adjust the -1 as necessary to match your table setup var dateCell = newRange.getCell(i + 1, 1); // The date is assumed to be in the first column var date = dateCell.getValue(); if (date instanceof Date) { date.setDate(date.getDate() + 1); dateCell.setValue(date); newDate = date; } } }
Hello, if I buy the Spreadsheet from Etsy, is it editable?
Hello, Thank you for your interest! You can enter in your own barber finance data to the template. You can also make edits, however I cannot guarantee any edits you make to the template structure/formulas will not break the current functionality.
great
Not a good video. You are showing off your skills instead of teaching how to create the spreadsheet. Horrible!
Hello, Thank you for watching and I appreciate your comment. This video is specifically intended to be a tutorial for users that have purchased this template from me. However I do have other videos that are intended to teach viewers how to do various things in Excel. Sorry for any confusion.
I wish I could find this template.
How to create that
this Personal Finance Tracker Spreadsheet. I would like to use and test it. Can you please send me a free trial version?
Hello, Thank you for watching and for your interest! Please reach out to me at the link provided in the video description and I can send you your free trial version.
@@spreadsheetsmadesimple6342 i have try to download sample file but i can not download it provide link for this file
@@spreadsheetsmadesimple6342 provide file so i can working in it
Hello, Unfortunately I'm not able to attach the file in a comment. Please reach out to me at the link below and I can send you your free trial copy. ruclips.net/user/redirect?event=comments&redir_token=QUFFLUhqbVZTUjNLNHNDWk5LZjV2VmZPODdiaHdUYnRzQXxBQ3Jtc0tuczU3eGI5dHlLclB4cUd2MnJUaUtNTTBGRlZqU0Vobl83ZHVrbm9Qb0xQY3BRWEw1YmdOR0QxY2lmNnpzNDE3Q1RBMUpvVVVjVTgxbDJ5dWoyRTUxWm9iRUxTaGZzZ3hfU0hQNF80c1hsU0pMdFpMNA&q=https%3A%2F%2Fwww.fiverr.com%2Fpft_president%2Fsend-a-customizable-personal-finance-spreadsheet&stzid=UgxwFVUkWVThZK8qiIt4AaABAg.9YuKUW4se_q9hkEsK81ueH Thanks!
@@spreadsheetsmadesimple6342 send excel file
How do I make this spreadsheet?
This is great. The only thing I might change is the average formula to AVERAGEIF(B4:M4,"<>0") which doesn't count the blank cells.
Thank you for watching and thank you for the great recommendation!
what about if someone has a split shift is there an easy way to do this and still able to track there hours. Like we work 3am-7am then 10am to 5pm. Like without making whole another collum
Hello, Thank you for watching and reaching out! It's not necessarily built to handle split shifts, however you could handle this situation by entering two rows for that employee and entering one shift on the first line and the second shift on the second line. Hope that helps!
Hi, what is the formula to input time in/out?
My husband owns a Barbershop and this will be the perfect spreadsheet we need. How do I go about obtaining it?
Hello, Thank you for watching and for your interest in the template! You can purchase this template here: www.fiverr.com/pft_president/send-you-a-barbershop-owner-financial-tracker-google-sheets? Please feel free to reach out to me there if you have any other questions.
This is great! Just wondering if the Etsy account selling this spreadsheet is legit or if we're only able to get it from Fiverr.
Hi Tony, Thank you for your interest! Yes, you can also purchase from Etsy, that is the same template. Thanks again and best of luck to you in 2023!
It's a nice job! the data entry and result processed behind are very direct, so it's easy understanding for those spread sheet beginning users. As more and more being added into the lists of the different categories, the side menu might be designed for a quick access, that might be the next version😀, BTW I saw I'm the fifth one to put the comment on, do I still have a chance getting the free sheet? wish you Happy New Year!
Hi Harold, Thank you for watching and for your advice! Please shoot me an email at PersonalFinanceTrackerHelp@Gmail.com and I will send you your free copy. Thanks!
You did awsome job! Can i get a free sample
Hello, Thank you for watching and thank you for your interest! Unfortunately, I do not have a Free Trial version of this template... however you can find more information and purchase this template here: www.fiverr.com/s2/df6a417d97
Thank you for watching! This video is actually a tutorial for those who have purchased this spreadsheet template. If you are interested, you can purchase this template here: www.fiverr.com/share/N4NLoQ?CopyLink_Mobile
Hello, Thank for your video about this Personal Finance Tracker Spreadsheet. I would like to use and test it. Can you please send me a free trial version? Many Thanks in advance for your kind consideration. Have a good week. BR Mat
Hi Mat, Thank you for watching and for your interest! Please reach out to me on Fiverr in the link in the video description and I will send you the Free Trial version in there. Thanks!
So you send the orders out as hard copy?
Hello, Thank you for watching and for your interest! This is a Google Sheets spreadsheet template which you can use on your computer. Here is a link for more information and to purchase if you'd like:www.fiverr.com/pft_president/send-you-a-barber-financial-tracker-google-sheets Thanks!
Can you show from the beginning
Hi . Can I have this schedul?
Hello, Thank you for watching and your interest! You can find more information and purchase this template here: www.fiverr.com/pft_president/send-an-employee-work-schedule-template-google-sheets Thanks!
This is more of an advertisement than a tutorial
Do have one for owners?
Hello, Thank you for watching and thank you for your comment! Currently I only have one for barbers, but I plan to make one for owners. Please make sure to subscribe so that you are notified as soon as I launch that version. Thanks!
Hello, I just wanted to reach out to let you know I just published a version for Barbershop Owners here: ruclips.net/video/u-GiJvsSZws/видео.html
Do you have a spreadsheet for barber owners?
Hi Frank, Thank you for your order! Currently I only have one for barbers but I do plan to launch one for owners in the future. Please make sure to subscribe to my channel, as soon as I launch that version I will post a RUclips video tutorial.
Hello, I just wanted to reach out to let you know I just published a version for Barbershop Owners here: ruclips.net/video/u-GiJvsSZws/видео.html
Do you have a version of this spreadsheet but with a column tracking an amount? For example, you have a total of $1000 (which is editable to stay current) and as you pay the bill, that amount subtracts from the $1,000? Either in the bottom metrics or an additional column on the spreadsheet?
Hello, Thank you for watching and for your comment! The current version only totals up the yearly amount you've paid towards each bill you have, but it does not have a feature to track a yearly or monthly budget you have set aside for these bills unfortunately. Were you looking to track this on a monthly basis or just a yearly basis? Thanks again!
@@spreadsheetsmadesimple6342 Hello. Yes, monthly. I am looking for something that has a total at top (for example $1000) and each expense I add in automatically subtracts from that total so I always know how much money is left in that account/bucket/budget/etc. Do you have any products like that? I like the idea of also having a button to show if it has been paid or not. I really like what I'm seeing here, I just need to also know how much money is still there and what is projected to be there at the end of the week/month/etc. I hope this makes sense.
Hi can you send this file to my email?
Hello, Thank you for watching and for your comment! To purchase this spreadsheet template, please visit this website: www.fiverr.com/pft_president/send-an-employee-work-schedule-tracker-excel-spreadsheet Thanks!
Hi can you please send me a file for this to my email?
Hello, Thank you for watching and for your comment! To purchase this spreadsheet template, please visit this website: www.fiverr.com/pft_president/send-an-employee-work-schedule-tracker-excel-spreadsheet Thanks!
Excellent video I show some of my work, I give advice PLE ruclips.net/video/UCI9CEeHcIs/видео.html Cotizador ruclips.net/video/7MbBe8OAOkw/видео.html Macros SG2 ruclips.net/video/lAdD9iaCvt4/видео.html
HI! I just purchased the spreadsheet. I would like to insert more rows but it won't allow me to. In fact, there aren't even enough rows to accommodate the options in your drop down list. Is there a way around this? I don't know exactly how many rows I want but I know I need more than 21. Thanks!
Hello, Thank you for your purchase and thank you for your comment! The spreadsheet is currently protected to prevent accidentally overwriting the existing formulas. Please reach out to me on Fiverr and I will send you an expanded version with more rows. Thanks!
Just a quick THANK YOU for your quick reply via email and taking care of me!! Looking forward to using the spreadsheet today. 🎉🤩
@@aimeecurrie9289 Happy to help!
I like this spreadsheet but i want to have more columns :like surname and mobile number and email adress and i would be great on time columns if i can have with time ansence reason for example USU ( sick umpaid )or UAU (unauthorised absence ) if you can make this changement could you tell me how i can buy it from you?
Hello, Thank you for watching and your comment! Let's continue our chat in the Fiverr platform.
Spreadsheets and life
One in the same! 🙌