Тёмный

Excel Create an Income and Expenditure Spreadsheet 

Chris Waite
Подписаться 94 тыс.
Просмотров 154 тыс.
50% 1

Shows you how to Create an Income and Expenditure Spreadsheet and keep track of your finances.

Опубликовано:

 

27 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 153   
@tmnkomo9403
@tmnkomo9403 11 дней назад
Just the step by step no show off kind of tutorial for an excel dummy like me😅 Thank you. With you , I can learn a lot more.
@jayj4439
@jayj4439 4 года назад
Thank you. There are way too many youtubers wanting a buck for something that's not rocket science. Thanks!
@cwtek1
@cwtek1 4 года назад
Glad to help
@finlaymacbeath422
@finlaymacbeath422 3 года назад
Thank you for the clear concise video. Just what I wanted without anything too complicated or fancy.
@cwtek1
@cwtek1 3 года назад
You're welcome!
@LexCATL
@LexCATL 3 года назад
OMG Thank you! Wanted to make a simple sheet to keep track of profits coming in for my business, and this was perfect!
@cwtek1
@cwtek1 3 года назад
You're so welcome!
@matthewpierce8337
@matthewpierce8337 Год назад
As a small business owner, I thank you sir! You have made my paperwork so much lighter :) Cheers!
@cwtek1
@cwtek1 Год назад
Most welcome!
@abnercollette625
@abnercollette625 Год назад
You are the Bob Ross of home finance, my friend! Grateful for your info.
@cwtek1
@cwtek1 Год назад
Wow, thanks!
@jacamo1947
@jacamo1947 4 года назад
Thank you for the simple and clear explanation. Beautifully done.
@cwtek1
@cwtek1 4 года назад
Glad it was helpful and than you for your kind words.
@mollygregorious369
@mollygregorious369 2 года назад
What an amazingly simple and easy to follow guide for new excel users!
@cwtek1
@cwtek1 2 года назад
Glad it was helpful!
@louisgianfrancesco
@louisgianfrancesco Год назад
Absolute gem for doing this, thank you Chris!
@cwtek1
@cwtek1 Год назад
Glad you enjoyed it!
@susan5440
@susan5440 4 года назад
Fantastic. Thank you for show us in simple layman terms so easily understood compared to the others as the come across too fast .cheers
@cwtek1
@cwtek1 4 года назад
No problem, I am glad it helped!
@SandraMarie1165
@SandraMarie1165 2 года назад
Thanks! Just starting up a little business and don't have much to invest in accounting, etc. right now. This is perfect!
@cwtek1
@cwtek1 2 года назад
Glad it was helpful!
@lorenagarciaguirre1498
@lorenagarciaguirre1498 Год назад
Super, super, super easy instructions to follow. Just what I needed! Thank you very much!
@cwtek1
@cwtek1 Год назад
You're welcome!
@EmilyRainsford
@EmilyRainsford Год назад
This was so clear and simple and exactly what I needed, thank you so much!
@cwtek1
@cwtek1 Год назад
Glad it was helpful! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@methinks5093
@methinks5093 4 года назад
Thank you for making my life so easy.
@cwtek1
@cwtek1 4 года назад
No problem I am glad the video helped!
@nnabuifeorakwe2732
@nnabuifeorakwe2732 4 года назад
Awesome video. i really learnt a lot. and you equally answered all the questions i had in mind regarding this.
@cwtek1
@cwtek1 4 года назад
That's Great Glad it helped!
@kaymur3368
@kaymur3368 3 года назад
THANK YOU this was a great tutorial..GLAD I FOUND IT!!
@cwtek1
@cwtek1 3 года назад
You're welcome!
@robertbarker55
@robertbarker55 Год назад
Thank you Chris. a simple clear explanation just what I needed thanks again
@cwtek1
@cwtek1 Год назад
Very welcome. If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@mercedesballou2275
@mercedesballou2275 2 года назад
Thank you. Your clear explanation has given me some confidence that I can create a spreadsheet.
@cwtek1
@cwtek1 2 года назад
Glad it was helpful!
@a.nahari380
@a.nahari380 2 года назад
Thank you. Simple yet powerful tracker you’ve just shared.
@cwtek1
@cwtek1 2 года назад
Glad it was helpful!
@wordsunspoken7391
@wordsunspoken7391 Месяц назад
As a student it helped me a lot to keep track on my expenses sir , thanks a lot ❤❤❤
@vrogger
@vrogger 3 года назад
This video was so helpful, thank you!
@cwtek1
@cwtek1 3 года назад
Glad it was helpful!
@izzycolman6478
@izzycolman6478 11 месяцев назад
Chris this was soo clear and simple thank you!
@cwtek1
@cwtek1 11 месяцев назад
Glad it was helpful! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@Lifeofalondoner3567
@Lifeofalondoner3567 3 года назад
Thank you very much. Very clear and easy to understand and follow.
@cwtek1
@cwtek1 3 года назад
Glad it was helpful!
@bennydeada9068
@bennydeada9068 7 месяцев назад
Thanks for the video. It’s very helpful.
@cwtek1
@cwtek1 7 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@jacobhovland9770
@jacobhovland9770 2 года назад
Thanks! This tutorial was very helpful!
@cwtek1
@cwtek1 2 года назад
Glad it was helpful!
@habbizzelle
@habbizzelle 4 года назад
Thank you so much for this!
@cwtek1
@cwtek1 4 года назад
Thank you I am glad the video helped!
@re.imajinvideo76
@re.imajinvideo76 3 года назад
Thanks a lot Chris, this was perfect, something simple and to the point. Is it possible that you show how to do a simple graph. But nothing too complicated just simple One-step at a time tutorials :)
@cwtek1
@cwtek1 3 года назад
Great suggestion! I will see what I can do!
@lilianmerriman4824
@lilianmerriman4824 2 года назад
Thank you
@AhmadAZ9
@AhmadAZ9 3 года назад
Good explanation! Keep it up! It is very useful & thanks for the formula
@cwtek1
@cwtek1 3 года назад
Glad it was helpful!
@isaacrashid3331
@isaacrashid3331 3 года назад
Great video, just what i needed, thanks so much
@cwtek1
@cwtek1 3 года назад
Glad it helped!
@joannawest8488
@joannawest8488 Год назад
Excellent video. Easy to follow. Just what I needed. Thanks
@cwtek1
@cwtek1 Год назад
I am glad you found this easy to follow. If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@MoniqKenyUSA
@MoniqKenyUSA 3 года назад
Thank you so much! Just what I needed
@cwtek1
@cwtek1 3 года назад
You're welcome!
@elevation_by_tammy
@elevation_by_tammy Год назад
Thank you Chris!! This was so very helpful!!!!
@cwtek1
@cwtek1 Год назад
Glad it was helpful!
@BethHab
@BethHab Год назад
Thank you for this great lesson. What is the easiest way to set this up so that all months are on the same sheet?
@lolaolajide8656
@lolaolajide8656 Год назад
Wow. Very clear and very simple. Thank you so much.
@cwtek1
@cwtek1 Год назад
You're very welcome!
@ManuelRodriguez-wx2lb
@ManuelRodriguez-wx2lb Год назад
Thank you so much very good video I am just a novice helped greatly
@cwtek1
@cwtek1 Год назад
You're very welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@Bhaskar_Blr
@Bhaskar_Blr Год назад
OMG!!! Thank You So Much Bro ❤️ Very Helpful & Brief Explanation
@cwtek1
@cwtek1 Год назад
I am glad to help!
@rohannaik6848
@rohannaik6848 7 месяцев назад
Thank You, very simple and useful
@cwtek1
@cwtek1 7 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@sophiepiper883
@sophiepiper883 3 года назад
Perfect, and so easy to follow!
@cwtek1
@cwtek1 3 года назад
Glad it was helpful!
@rosfrank
@rosfrank 3 года назад
Well done Boss it really works (7/28/2021) Thumps UP
@cwtek1
@cwtek1 3 года назад
Thank you!
@feisalsamadi9133
@feisalsamadi9133 Год назад
Very useful. Thank you Chris!
@cwtek1
@cwtek1 Год назад
Very welcome!
@Theomoonrise
@Theomoonrise Год назад
Thank you so much! I was beating my head against a wall trying to figure something like this out!
@cwtek1
@cwtek1 Год назад
You're very welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@Theomoonrise
@Theomoonrise Год назад
@@cwtek1 I have and I was looking through the videos. I think I will find a few of them very helpful. You was so pleasant to listen to while I learned how to do something new and it was easy to understand what you were saying and how to do it.
@pietervanduijn2790
@pietervanduijn2790 4 года назад
Hello Chris. At 7:30 you are inserting a blank row because there was no room anymore. Is there an automatically way to do that so that the row below moves one row down?
@cwtek1
@cwtek1 4 года назад
Yes I am inserting a blank row as there was no room, I guess there maybe a way with a bit of coding but unfortunately I do not know of anyway to automate this process
@SaraMc66
@SaraMc66 4 года назад
Hi Chris, thanks for sharing this, is it possible to have a third column showing a running total of the balance, rather than have it separated? So, money in, money out, balance columns. Thanks in advance.
@Hotterdotcom
@Hotterdotcom Год назад
Thank you!! Helps so much!
@cwtek1
@cwtek1 Год назад
You're welcome!
@CRAZYNESSGAMING
@CRAZYNESSGAMING Год назад
IT WORKS LIKE A CHAMP! THANKS MATE! BIG W
@cwtek1
@cwtek1 Год назад
You're welcome!
@LBinspirations4.0
@LBinspirations4.0 Год назад
Great tip with using Sum Indirect
@cwtek1
@cwtek1 Год назад
Glad it was helpful!
@ramiroastrain4935
@ramiroastrain4935 2 года назад
nice and simple for someone that does not use excel on a regular basis.
@cwtek1
@cwtek1 2 года назад
I am glad to help!
@dianamaldonado2354
@dianamaldonado2354 10 месяцев назад
thank you for the formula ... very helpful!
@cwtek1
@cwtek1 10 месяцев назад
You're very welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@susan5440
@susan5440 4 года назад
Hi I have succeeded in doing this, first time student. If I wish to do each month, do I open new blank excel or continue down the first month entered?
@cwtek1
@cwtek1 4 года назад
You can add another sheet (or tab) to the excel file by clicking the plus at the bottom of excel and then you can give it a name (i.e. April) and then you can have a years worth of income and expenditure on one sheet.
@Ismail_Khayre-
@Ismail_Khayre- Год назад
Thank you.This is very clear.
@cwtek1
@cwtek1 Год назад
You are welcome!
@ruthashburner-gorse8669
@ruthashburner-gorse8669 4 года назад
Awesome ... thanks so much !
@cwtek1
@cwtek1 4 года назад
No problem I am glad the video helped!
@bridgetmcconnell5872
@bridgetmcconnell5872 3 года назад
the balance figure remains at zero even if my expenditure is more than my income. Is there any way I can calculate for a loss?
@cwtek1
@cwtek1 3 года назад
Please double check the formula's I have just tried making my expenditure more than my income and it does show a minus value in the balance cell.
@timszon
@timszon 3 года назад
Would this work for a trucker trying to track the Mileage and different prices on the border between USA and Canada
@cwtek1
@cwtek1 3 года назад
I am not sure its only a simple spreadsheet, you could give it a try and see if it works for you!
@dazzler1813
@dazzler1813 2 года назад
Thank you so much - so helpful! :o)
@cwtek1
@cwtek1 2 года назад
You are so welcome!
@lucysam5820
@lucysam5820 3 года назад
Hi Sir Waite, How are you? Happy New Year. I found this video and was extremely excited to learn the format that you shared. I do have a query if during the month and or week, I transfer money from checking to savings and or received refunds from purchases, can you share how the formula can be modified to do so? I really appreciate and look forward to seeing that video. Sincerely New Viewer
@cwtek1
@cwtek1 3 года назад
Happy new year to you too, sorry I do not know how to do this I only know the basics in excel.
@lucysam5820
@lucysam5820 3 года назад
Sir Waite, How are you? though am disappointed that there may not be a formula to resolve my query, am glad to have met you, and to view and enjoy more video's from you. Have an awesome weekend.
@michellevlogs1580
@michellevlogs1580 Год назад
Thank you do we add the calculations for each month or yearly
@cwtek1
@cwtek1 Год назад
It’s entirely up to you.
@wakihaha791
@wakihaha791 4 года назад
Please help Cant use the formal '' =SUM(INDIRECT(¨C2:C¨&ROW()-1))
@cwtek1
@cwtek1 4 года назад
Are you using Row C where you are putting your Money in Figures, also your speech marks look slightly different to mine, mine are like this " and yours are like this ¨ not sure why.
@lukephiri7186
@lukephiri7186 2 года назад
Thanks a lot Chris.
@cwtek1
@cwtek1 2 года назад
My pleasure!
@amirashtin4593
@amirashtin4593 3 года назад
Great video! I was able to create a spreadsheet! Yay! Can you do a video on how to create a monthly income and out spreadsheet??
@cwtek1
@cwtek1 3 года назад
Thank you, Great idea, I will see what I can do.
@amirashtin4593
@amirashtin4593 3 года назад
Ok. I was wanting one that shows my business income monthly and that shows the money out for each month. Now what I did was skip over 2 rows then started your same process but for June. I was wondering if one could be done to show each month so all you would have to do is enter the income and money out data.. is it possible??
@askavettech2057
@askavettech2057 Год назад
Thank you very much!
@cwtek1
@cwtek1 Год назад
Your welcome, If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@racherutheneko7270
@racherutheneko7270 10 месяцев назад
Just what I was looking for!
@cwtek1
@cwtek1 10 месяцев назад
I am glad to help! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@jackiefoxall1947
@jackiefoxall1947 Месяц назад
Great tutorial.
@omsoni8484
@omsoni8484 2 года назад
Thabk you so much for the tutorial
@cwtek1
@cwtek1 2 года назад
You’re welcome 😊
@bloggs692413
@bloggs692413 Год назад
superb just what I needed have sub'd
@cwtek1
@cwtek1 Год назад
Glad to Help and Thanks for the sub!
@kathrynalvarez7303
@kathrynalvarez7303 2 года назад
How would I add sales tax to this?
@victoriamillar8683
@victoriamillar8683 Год назад
this was very helpful!
@cwtek1
@cwtek1 Год назад
Glad it was helpful!
@kaylakay7012
@kaylakay7012 6 месяцев назад
This is very helpful. Bravo thank you 🤍
@cwtek1
@cwtek1 6 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@kaylakay7012
@kaylakay7012 6 месяцев назад
@@cwtek1 oh I know. I'm just surprised your content is authentic as far as I'm convinced. Subscribed ♥️♥️
@arunpandian3868
@arunpandian3868 5 месяцев назад
Excellent thanks man
@cwtek1
@cwtek1 5 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@harmonymaskstore5397
@harmonymaskstore5397 3 года назад
Thank you :)
@cwtek1
@cwtek1 3 года назад
I am glad the video helped!
@juliopizzachef8152
@juliopizzachef8152 10 месяцев назад
My accountant asked me to provide my spread sheet of the income you have received and the expenses you have paid in the last tax year. Does it mean i have to do something like this?
@cwtek1
@cwtek1 10 месяцев назад
Yes this would be perfect!
@juliopizzachef8152
@juliopizzachef8152 10 месяцев назад
@@cwtek1 thanks for reply and for the video. I would have been clueless without it as it's my first tax return
@promiseonyemulu6080
@promiseonyemulu6080 6 месяцев назад
Thank you!
@cwtek1
@cwtek1 6 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@mayowaomoniyi6420
@mayowaomoniyi6420 4 месяца назад
❤❤❤❤
@abdullahiahmed5247
@abdullahiahmed5247 Месяц назад
The formula isn't working for me
@nav4076
@nav4076 3 года назад
Very nice
@cwtek1
@cwtek1 3 года назад
Thanks
@sathushawn8688
@sathushawn8688 4 месяца назад
Good!!!
@theguardianabroad6846
@theguardianabroad6846 5 месяцев назад
In 2024 - 👍🏽Thank you
@cwtek1
@cwtek1 5 месяцев назад
You're Welcome! If you haven't done so already please don't forget to subscribe to my RU-vid Channel, its Free and easy to do so and you will find out about all my latest videos.
@shhtopboys5019
@shhtopboys5019 3 года назад
It says wrong name?
@cwtek1
@cwtek1 3 года назад
Sorry I am not sure what name you are referring to please can you re-phrase. Thank you!
@bellomuhammadishola5898
@bellomuhammadishola5898 3 года назад
Formulas 🤦🤦
@cwtek1
@cwtek1 3 года назад
I hope this helped.
Далее
Maybe a little TOO much gel 😂
00:12
Просмотров 13 млн
2DROTS vs RISENHAHA! КУБОК ФИФЕРОВ 2 ТУР
11:31
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Просмотров 4,8 млн
Spreadsheets #1: Introduction
13:27
Просмотров 1 млн
Can You Pass This Excel Interview Test?
11:20
Просмотров 858 тыс.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Bookkeeping Basics for Small Business Owners
8:22
Просмотров 1,3 млн
Create an Expense Tracker in Excel in 14 Minutes
18:32
Просмотров 291 тыс.
Maybe a little TOO much gel 😂
00:12
Просмотров 13 млн