Very nice informative video. I tried on DOGE but it didn’t work

I’d definitely be interested to see more

This is fantastic and works great. Took me a minute to find the right words in Google to find this, but glad I did

what if we just want to put the number grand total of the pivot to textbox with the slicer at default showing the grand total, but change depending which year we select?

You've already lost me

"DATA SOURCE NOT VALID" ERROR HOW TO REMOVE THIS ERROR PLEASE HELP.

How about if we need to add SUI SOLANA PEPE ADA HBAR for example, how can we accomplished that?

How do you account for transaction fees?

while using dated if formula and freezing column and by pressing $ i am getting #num ! error how to get rid of this ?? please help

Another reason to master excel 😂 great organized video 👌

Thanks. it was the left to right error for me 🎉❤

while using my excel in Mac my Alt key is not working coz of that am unable to use my shortcut key for excel pllz assist me,

Is anyone able to get this to work on a mac? I cannot find the option to import data from a file or folder

This was so helpful

what if you do consistent buys and sells, you need to calculate the avg buy price and cost. Is there a clean way to do that?

Does the data scraping still work for WSJ Markets? I am trying to do it in Excel and I am getting a credential login error.

Cool

Love it

Could you make a video on how to categorize based on a variety of possible key words in each transaction's description? I can't seem to find how to do this anywhere online. I really liked how you set this one up so that it can be updated easily. Please please help. I'm looking to get in control again of my budget since Mint dissolved.

why does it say "It must contain 2 rows when I try to drop my data into a new worksheet? Nothing is where it is supposed to be, either. This pivot table is broken.

Ihav heaps of sheets recrpt but don't know how to wifrà

This is great thank you! I've found that it returns you to the first selected cell, not just the top of the sheet. For example, if you scroll go to the last row of your data and make a selection of data to the top of the sheet then press CTRL + Backspace, it will return you to the first selected cell at the bottom of the sheet that you started on. Such a helpful shortcut, no more dragging scroll bars up, down, left and right any more!!

Thanks man 🖤

Ty I had a space in a cell causing the error

Hi Pete, any thoughts how to fix a pivot chart that does not update values? There is a table that feeds a pivot chart and a pivot table. When I update date in this table the pivot table gets updated but the pivot chart keeps the old values.

Thanks bro

I am having the #NUM! error as a result of a circular reference. I have turned on iterative calculations to try and circumvent this issue, but it still persists, and in my model it only happens in two years of the several years I am projecting. Meaning that iterative calculation is working as intended for some, but results in a #NUM! error in the rest. It does not seem that there are many resources that can help me with dealing with this inconsistency...

However, there were periods of time where I laughed quite a bit but, at the same time, I also had some dull moments. If it were myself, I guess someone else would appreciate this type of video better.

Jesus you talk waaaayyyyy to fast. I swear ive watched your video a thousand times having to pause. Slow down a bit. You’re not talking to fellow math enthusiast. You’re talking to people who are learning…

How can i add stock Icon on the sheet ? Thanks for the video anyway

Thanks and great tip.. I'm looking for the method of adding a middle boarder. Any suggestions?

😮😮😮

Do you have a class on Udemy?

Doesnt pmt give you the monthly payments including interest and principal together?

Hey! Great video, found this very useful! Although I'm wondering, because when adding new transcripts to the lookup table, a number of duplicates appear. How do I prevent this?

this works first time only but every month it never works when I try to add the new files and I have to rebuild the whole thing from scratch agin. every month its something diffrent. This month one file has doubled all the trasnaction and the other file does not load :( I have to build it again :( why does it do this? I have no Idea about power query. I just compy the insturction from the vid

Brilliant work, comprehensive collection of solutions! Thanks Pete!

Thanks, very helpful!

Please send full video

Mine is weird, using comma style, let's say 1 million Instead 1.000.000 It becomes 1000000.0.000, when decrease it becomes 1000000.. The ".0." And ".." behind annoy me, andl dont know what to do HELP 😢

i had transaction like that in bank statement "V4800 19/12 GALAXY 7 PTY LTD TRUGANINA 745644" now i can automate because transaction description is not same always. what to do ?

What if transaction desciption is not perfectly match ?? xlook fails to identify if there is minor difference in transaction description. Kindly make vid for the same

Bro i don't know whether you going to reply me or not but my question is i had bank statement those have same transactions but gae different desciption so even unique formula don't catch up those

Wow. But why does it happen at the first place

Fantastic presentation! Exactly what I was looking for. Is there a way I can get this Excel?

Hi! Awesome work, thank you for sharing with us. I have a question about what Excel supports. What if you want to track a coin like ADA. I tried, and Excel will not find it. How do you make something like that work?

whats the shortcut for mac. alt shortcuts not working in mac

Thank you very much

hi- what about mac. pls explain

shouldn't the formula be -pmt(rate, nper,pv ) ?