Personal Financial Control Spreadsheet Excel Free Download How to Do It with Dashboard

55,180 views

Excelente João

Published on Oct 24, 2023
About :

🔵 FREE SPREADSHEET DOWNLOAD: https://excelentejoao.com.br/wp-conte... 🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this Excel video lesson, we will learn how to make a daily personal financial control spreadsheet in Excel and you can download the Excel spreadsheet for free. We will learn how to make an Excel cash flow spreadsheet, that is, an Excel spreadsheet to control cash inflows and outflows. This is a personal income control spreadsheet in Excel, but you could also use this spreadsheet to control companies, business cash flow control, business financial control. From scratch, step by step and in practice. Let's learn how to build this free personal financial control spreadsheet in Excel. Let's start by building a header and making the spreadsheet fully dynamic and automated so that we can use the spreadsheet for every month of the year and for every year whenever you change the month all the action dates are updated automatically for you, that is, a spreadsheet that works completely automatically. We will also see how to fix the spreadsheet header, that is, how to fix the first rows of the spreadsheet, how to freeze the rows, how to freeze columns in Excel, how to make a column fixed in the spreadsheet so that even if you move it and the spreadsheet dies, the first column always remains fixed on the screen. We will also see how to make a row fixed in Excel, how to fix rows in Excel. The next step is to describe and write all the income we have, such as salary, overtime payments, extra services, etc., that is, all the money that comes into your account needs to be accounted for here. And then we will account for and describe all the expenses, such as electricity bills, water bills, and all the expenses we have, rent, condominium, etc. Here we need to account for and enter the values ​​of everything that left our account, of all the outgoing movements. At the end of the spreadsheet, we can create a new row with the balance calculation, that is, with a daily balance of everything that came in and everything that went out, this way we can monitor whether we are positive or negative on the day in question. In addition, we will add conditional formatting so that the cells change color automatically whenever the value changes. If the value becomes negative, the cell is painted red. value is positive the cell is painted green, that is, the cells change color automatically from green to red whenever the values ​​change automatically. #ExcellentJoão #Excel #Dashboard

  • vidoe Comments
Trend Videos
7:02
2NE1 - Come Back Home+Fire+I Don't Care+UGLY+I'm the Best♬
SBS Entertainment
6,142,554 views   13 days ago
23:52
Noh Hong-chul surprised by the current Bali price level (self-cooking, close friend travel)
노홍철
314,448 views   1 day ago
26:46
[VLOG] 6 years after marriage, father visits daughter's house for the first time👴🏻❗️(Proud Yujun, starts dieting)
리쥬라이크 LIJULIKE
733,120 views   2 days ago
9:22
No, honey, stop crying;;
김계정
455,319 views   3 days ago
9:55
I will tell you honestly why I did not receive the diamond button related to the number of subscribers.
보겸TV
1,281,307 views   2 days ago
23:38
SNL vs XXXL! A talk show where two real crazy people make each other crazy Takdae EP24 Kim Ah-young
빠더너스 BDNS
972,484 views   2 days ago
18:14
Why did Ryu Hyun-jin's friends (Yang Ui-ji, Kim Hyun-soo, Hwang Jae-gyun) and juniors (Chae Eun-seong, Jang Min-jae, Park Geon-woo) all show up at the end of the year?
Eagles TV
298,388 views   2 days ago
5:15
Blue and Summer - Mrs. GREEN APPLE / COVER by LILPA
릴파 lilpa
1,011,153 views   11 days ago
48:25
'Squid Game 2' Review
침착맨
949,291 views   2 days ago
9:55
I will tell you honestly why I did not receive the diamond button related to the number of subscribers.
보겸TV
1,281,307 views   2 days ago
3:40
[What do you do when you play?] Hwang Ga-ram - I am a firefly (FULL ver.) #WhatDoYouDoWhenYouPlay? #YooJaeSuk #HwangGaRam MBC241228Broadcast
놀면 뭐하니?
555,962 views   7 days ago
0:19
RIIZE RISE 'Hug' Stage Video Teaser
SMTOWN
164,114 views   1 day ago
1:18
[Pre-release] The passionate stage of Jeon Yu-jin, the current king of singers who is highly anticipated throughout the year! Jeon Yu-jin - Love (A stage where Cho Yu-jin's unparalleled emotions overflow! Cho Yu-jin - Love)｜⚡Korea-Japan Top Ten Show⚡
현역가왕&한일가왕전
149,506 views   2 days ago
21:13
2025 Season 1 [Invitation to Noxus] Season Opening Draft 2025 LCK
LCK
493,344 views   2 days ago
18:37
“I was abused?” Surprising behavior of a dog with a blind owner (Veterinarian Seol Chae-hyun is also surprised)
원샷한솔OneshotHansol
1,165,116 views   2 days ago
6:19
Buy lots of winter perilla leaves and try this!! Simple, healthy, and delicious/an ultra-simple perilla leaf dish
sogyo table 소교식탁TV
147,251 views   2 days ago
12:10
I waited 7 hours to buy strawberry soup for my wife who had just given birth.
네루짱NERU
520,149 views   2 days ago
21:15
A heart-pounding winter survival operation💕
원지의하루
347,529 views   1 day ago
12:52
145,000 won per person? The most expensive strawberry buffet in Korea
더들리
493,147 views   1 day ago
15:07
Lee Ji-hye's emotional surprise camera of her husband who bursts into tears (Terry Ellie, crying)
밉지않은 관종언니
256,999 views   1 day ago
9:22
No, honey, stop crying;;
김계정
455,319 views   3 days ago
3:25
Squid Game II 3 Minutes Summary
유요
915,061 views   3 days ago
28:38
[vlog] Year-end spent with loved ones
찰스엔터
349,115 views   1 day ago
13:32
To be or not to be thyroid cancer, that is the question...
배말랭
459,796 views   2 days ago
21:15
A heart-pounding winter survival operation💕
원지의하루
347,529 views   1 day ago
13:32
To be or not to be thyroid cancer, that is the question...
배말랭
459,796 views   2 days ago
6:53
G-DRAGON - POWER+Crooked♬
SBS Entertainment
4,343,523 views   13 days ago
9:59
🥔Ep. 0 ㅣ CEO KWANGSOO Dreams Big, KYUNG SOO Makes It Happenㅣ👨‍🍳🥔GBRB Spinoff
채널십오야
877,750 views   1 day ago
12:10
I waited 7 hours to buy strawberry soup for my wife who had just given birth.
네루짱NERU
520,149 views   2 days ago
24:30
[🇦🇺vlog] A busy 2024 summer Christmas vlog spent with family
해쭈 [HAEJOO]
479,405 views   2 days ago
25:50
[Eating Vlog #109] I finally tried rose-duruchigi. But the taste..🤔 I'm the one who eats mackerel 3 times a week🐟 Hippo pound bagel, heart tiramisu, spicy noodles, cheese stir-fried noodles + pudding hotdog + cheese ball
살빼조DietJo
462,458 views   5 days ago
2:15
[Captain America: Brave New World] Main Trailer
MarvelKorea
678,893 views   1 day ago
Google AdSense
336 x 280
Up Next
13:36
New iM5+ full color outdoor wi-fi camera how to configure application: Mibo Cam
Marcos Matos e você o rei das câmeras
13,328 views
2 years ago
3:11:01
COMPLETE COURSE FROM ZERO TO 50 THOUSAND IN THE FREE MARKET IN 2024
Walace Messias - Shark ecommerce
216,850 views
8 months ago
18:26
Intelbras iM5 S Full HD outdoor Wi-Fi camera how to configure
Marcos Matos e você o rei das câmeras
23,650 views
3 years ago
13:40
INSTALLING AND CONFIGURING INTELBRAS WIFI EXTERNAL CAMERA WITH AUDIO (IM5 S)
OJI SECURITY
195,301 views
3 years ago
8:07
How to configure the Intelbras iM5-SC external Wi-Fi camera compatible with Alexa and Google.
Aplicando Engenharia
39,484 views
1 year ago
11:25
Intelbras iM5-SC external Wi-Fi camera how to record via memory card app: Mibo Cam
Marcos Matos e você o rei das câmeras
11,858 views
2 years ago
8:07
Intelbras IMX C Mibo camera how to easily configure application: MiboCam
Marcos Matos e você o rei das câmeras
39,392 views
1 year ago
11:03
How to configure Intelbras IM3 camera and its MANY FUNCTIONS
Conexão CFTV
369,985 views
4 years ago
15:01
iM7 Full Color 360⁰ Outdoor Wi-Fi Camera How to Set Up App: MIBO CAM
Marcos Matos e você o rei das câmeras
78,017 views
2 years ago
10:07
Functions and Settings of Your Intelbras Security Camera: A Complete Guide via the APP
O Knaipp
17,572 views
1 year ago
7:41
HOW TO RESET THE INTELBRAS IM5 FULL COLOR CAMERA TO FACTORY SETTINGS
Rodrigo Ferrari
1,030 views
2 months ago
12:41
HOW TO CONFIGURE MOTION DETECTION ON MIBO IM5 TECHSERVICEONE WELTON 💡⚙️
TECHSERVICEONE - WELTON BRUNO LINO
30,851 views
4 years ago
9:07
How to configure the Intelbras iM5+ external Wi-Fi camera compatible with Alexa and Google.
Aplicando Engenharia
12,889 views
1 year ago
24:52
MIBO IC4 INTELBRAS CAMERA Learn how to set up!
Papo Segurança com Alexandre Rodrigues
223,000 views
5 years ago
11:53
Review of the Mibo iM5s outdoor smart camera Intelbras
LAB4 - Inspirando os entusiastas da tecnologia
27,357 views
3 years ago
6:39
Intelbras iMX Mibo Camera Presentation and How to Install
Upperseg Superioridade Em Segurança
78,887 views
3 years ago
19:46
presentation INTELBRAS WI-FI CAMERAS!!! which one to buy?
CAIQUE DAS CAMERAS
65,857 views
1 year ago
45:44
HOW TO INSTALL WIFI CAMERA ON NVR
LetraJota
236,396 views
5 months ago
4:32
Access im5 S camera via cable
Andre Carmelito
9,915 views
2 years ago
18:08
How to configure the Intelbras iM3 black Full HD Wi-Fi camera
Marcos Matos e você o rei das câmeras
22,018 views
3 years ago
12:47
[Guaranteed to sleep outdoors] At 1am, the sea is right in front of me... I rode the scariest last train on the Tokaido Line! I took the last train to the last stop #20
ナオヤ鉄道ch
377,625 views
7 months ago
17:23
[Sleeping rough guaranteed] Crossing 1 metropolis and 2 prefectures! I rode the terrifying last train to the very end of Kanagawa! I took the last train to the end of the line #27
ナオヤ鉄道ch
593,441 views
6 months ago
11:28
[A rare trip past 1am] I rode the last train on the Odakyu Line I rode the last train to the last stop #60
ナオヤ鉄道ch
102,368 views
1 month ago
13:35
[Passing 29 stations] I rode the fastest rapid express train on the Odakyu Line, which is as fast as a limited express! #OdakyuLine #Odakyu #OdakyuElectricRailway #OdakyuOdawaraLine #RapidExpress #Odakyu5000Series #FastestTrain
山手快速
24,245 views
3 months ago
14:28
[Guaranteed to sleep outside] I tried riding the last train to the end of the line, which was so scary that I ran out of energy just before reaching downtown Tokyo I tried riding the last train to the end of the line #44
ナオヤ鉄道ch
177,719 views
3 months ago
20:39
[Guaranteed to sleep outside] I rode the last train to the end of the metropolitan area! I rode the last train to the end of the line #34
ナオヤ鉄道ch
437,381 views
5 months ago
13:07
[Sleeping outdoors guaranteed] I rode the last train to the end of Kanto and the highest point in Kanagawa I rode the last train to the end of the line #52
ナオヤ鉄道ch
135,021 views
2 months ago
21:33
[Don't fall asleep] I missed the most terrifying last train in Japan I went to the last stop on the last train #48
ナオヤ鉄道ch
159,929 views
2 months ago
15:39
[I'll definitely be sleeping outside] I ended up exhausted at the station, so I tried to ride the last train to the end of the line I tried to ride the last train to the end of the line #47
ナオヤ鉄道ch
208,984 views
3 months ago
11:52
[Don't oversleep] I woke up in the mountains!? I rode the last train on the Chuo Line, the scariest one yet! I took the last train to the last stop #7
ナオヤ鉄道ch
740,504 views
1 year ago
12:32
[Sleeping outdoors guaranteed] I rode the latest last train in the Tohoku region! I rode the last train to the last stop #33
ナオヤ鉄道ch
220,796 views
5 months ago
12:36
[Timetable change] What's next for Odakyu Line express trains?
てつたん
8,472 views
2 weeks ago
58:26
[#3 Driving Part 2] Sotetsu/Tokyu Shin-Yokohama Line Plarail Driving Event Report Video
every dayday
56,166 views
1 month ago
14:06
[Guaranteed to be sleeping rough] I took the terrifying last train from the big city, which takes you to despair in just 25 minutes! I took the last train to the last stop #36
ナオヤ鉄道ch
292,545 views
5 months ago
Google AdSense
336 x 280

fetery.com. Copyright 2024