@functional.excel: Building a fixed rate mortgage tracker... #spreadsheet #exceltips #excel

Functional Excel
Functional Excel
Open In TikTok:
Region: GB
Tuesday 06 January 2026 21:59:37 GMT
434043
21203
92
1281

Music

Download

Comments

luke_mcdaniel1
Luke M :
being good at excel ≠ being good with data
2026-01-08 02:59:26
1036
zalbegtherson1
Zal Begtherson :
Is there a resource you’d recommend for becoming skilled at navigating excel using only your keyboard?
2026-01-09 02:29:06
18
excel
Microsoft Excel :
*tips cap*
2026-02-18 15:36:34
83
jwgood
Jordan Goodwater :
You’re done and I’m still trying to enter my first cell 🤣😅
2026-01-07 02:05:14
451
zach_whut
Zäćh :
After hitting alt h h for highlights, hit escape enter if you want to do the most recent color again
2026-01-07 04:51:35
460
ineedausernamepronto
ineedausernamepronto :
Something is off with the total principal payment formula, when you changed the loan to 30 years, the total principal paid = $600k+ and it should still be $450k
2026-01-09 03:40:00
80
albertsylvesterandersen
Albert :
You can’t divide the rate like that - you miss the effective rate
2026-01-21 22:06:17
100
peepeepoo_official
peepeepoo_official :
I wish to have the same Excel talent as you have
2026-01-21 19:40:29
4
user19284948899
User129392849 :
When you edit the loan years the principle went to 600k 👍
2026-01-12 03:54:34
5
l4rv3
l4rv3 :
i use ctrl+y to repeat last action with regard to formatting
2026-01-10 17:33:10
6
gsgsgsgsjbsbsh
gsgsgsgsjbsbsh :
Payment dates?
2026-01-18 22:23:29
1
ajadamd
adam davies :
1.00375^12 ≠ 1.045
2026-01-12 00:19:49
10
picklebrain
Jos :
This was cool! And your changes at the end also show how much worse 50 year loan terms are for the borrower than 30 year ones
2026-01-07 14:37:30
11
hhhhzrrrr
HR :
Once you’ve done something in excel, just go to another cell and click F4 (like your fill colour )
2026-01-11 23:09:55
0
bobbyspinks1
Bobby Spinks :
Haven’t you got ChatGPT? 🤔🤔🤔
2026-01-21 23:12:34
2
nathanvogel25
nathan vogel :
Not me thinking he did daily instead of monthly for the dates by mistake
2026-01-08 02:46:36
3
98tr_
T🚀 :
Would’ve done the monthly interest per number of days a month to get a more accurate figure
2026-01-11 12:42:46
3
tonii.htg
toni :
at the end where you put the plan term to 30 years it says 603k total principal on a 450k loan, how is that logical?
2026-01-21 15:20:42
4
ohlookitstara7
ohlookitstara :
This is what I strive to achieve! That was highly impressive.
2026-02-13 04:23:23
2
viralpodmoments6
ViralPodmoments :
How did you get so good at excel.
2026-02-28 07:03:10
1
yesevil666
Yesevil :
Ctrl alt dollar for currency. Much easier
2026-01-24 09:38:15
1
johangx27
Johan :
Not sure why u need to type it manually when there are ton of AI tools out there that can do it 100x faster
2026-01-31 17:50:40
1
estbabz
HephzibahBeauty :
This is such an attractive trait - I struggle with basic tasks on excel!! I need to improve...I will improve
2026-02-07 12:19:54
1
kristyy2610
Kristy :
Love this example despite $ was not £. As a Mac user at home I’d love to know the non MS shortcuts 🙏🏻
2026-01-21 23:48:30
1
user9184748292848
User9184748292848 :
You should’ve used edate and sequence for the dates, arrays are 👑
2026-01-10 11:09:32
1
To see more videos from user @functional.excel, please go to the Tikwm homepage.

Other Videos


About