Відео

It's there any way to create a live continuous update into Excel from data i can only see on my computer screen? To clarify, i trade options and use thinkorswim platform. There is certain data from option statistics in the put call ratios that i want to feed into Excel and calculate with certain formulas... Instead of having to constantly manually update them I'd love to find a way to get them updated automatically. Normally the platform provides a link to feed into Excel but not for this data. I can only see it change on screen... Is it possible to get that data from just my screen live into Excel and update automatically as it constantly changes?

Thank you, I have managed to create an expense tracker by following the video. I surprised myself by creating an income tracker (using the same logic) on another tab and got it to feed into the summary sheet.

Your website is suspended 😞

you are wizard my guy!

This is fantastic. So many people I work with wish Microsoft would use some common sense here - in that nearly everyone in the U.S. knows that zip codes are 5 digits - with 10% of them having leading zeroes here - and just build in code to recognize that it is a zip code. Thank you!

Thank you …. Is it passable to create it with 3 conditions? Two rows and one column ?

Thanks man. Been looking for this for day 👌👌

Finally, Find This Video 100% help me

I was trying to get some ideas on how to design an expense tracker and I came across your video and the free tracker. I have tried using paid apps to track my expenses, but they never work for me. Your template has been a lifesaver. I can easily and quickly track my own expenses being aware of where and how much I spend each month. Thank you so much!

Is there any way to search for multiple tags at once? e.g. I’d like to search for franchise, then narrow down further to sequel, then even further to CGI, etc?

I wonder if you can also add a roll for attack and damage by everyone in the party and monsters?

I followed the steps but Excel loaded all the numbers in my Summary page as a 0 in each column and row? Does anyone know how that happnes?

Dear SIr if i put continue same date 2 or 3 time for 2-3 different categories expense then it will go to undated or outside date range what can we do for that :) by the way thanks for you sheet

How do I put both lists side by side and then make both lists equal so I can compare apples to apples on each row? Vlookup?

thanks so much for it. It helps my startup in very early stages

I find myself needing some assistance with the following: Please imagine a spreadsheet with various columns between A-T For simplicity I will reference my own needs to column A & C Column A will contain the name of a person who is assigned a piece of work. Column B will contain the date they were assigned the work. Column C will contain the date they completed and return the work. The task I have been assigned it to collate how many times a person is assigned a piece of work and when they returned it. ( I am required to present data on a month by month basis ) At the moment I have been using filters as I am unsure how to use formulas to simply this process. We have up to 25 names that could be used in column A. Over a month we have 125-180 pieces of work. As you can imagine using filters for this process has been difficult. Colleagues will not assist me or teach me how to use excel functions and make my life easier. Is there a way of searching for colleague (x) in column A and automatically finding all return dates associated this colleague (x) in column C ? Any help would be greatly appreciated.

how can I add more columns and rows on the first tab without messing up the sheet's formula's?

This was the triumphant finish to understanding why I my ISBLANK formulas weren't working on data exported from Salesforce. And yes, the 'text to columns' hack is a great time saver. Very well presented - like a rockstar!

you dont need to show 3 minutes and 30 seconds of different examples of why these fake "blank" cells arent actually blank. we get it, theyre FAKE. Get on with it... I bet your students fall asleep on every single of your lecture, jesus christ edit: doesnt work

This was super helpful, I was able to adapt to my personal tracker! Thanks so much for sharing!!

Thank you! I was able to extract the info I needed very quickly using this methodology! Thanks for sharing!

It's too complicated for me

I followed your steps and it was helpful. But when I actually went to use it the numbers weren't transferring from the expense spreadsheet to the summary spreadsheet . Did I miss a step? I even downloaded the one provided from the video link and it is still not working. Please help me understand what step I'm missing. I have a MacBook Air.

beautiful

Could you please make a weekly version of this?

Some cells came with a space and are easy to replace but the false blanks are really a pain... Thanks for your help.

This is NOT beginner!

What is the comparable way to do this with Power Query?

This is such a terrible video😂. It does not have to be this complicated.

Thanks so much

Hello Sir, thank you for your share, but I have one more question, how I can set the if not found to show "Name Error" and "Month Error"? Thanks

Amazing 👌

Amazing video, thank you its just what I've been looking for!

thank you for the excel download

Thanks a ton awesome video

Thank you, that was much simpler than I was considering

Thanks bro for tutorial you make it. Im from Indonesia cant find this tutorial.

Спасибо за видео

Dude thank you

650

Your Video is very Helpful. Thank you

Good workaround! Love the creativity. Worked like a champ.

Thank you! This video was a life saver!

That was amazing, thank you

This was a wonder to watch and learn from, I've been a DM for a little over 6 months now, but I've been loving it. This is the perfect guide for me because I love using excel to make my life easier and the way you explained everything made so much sense and was very intuitive. I've downloaded this video so I can work on making my own encounter tool and tweak this one to work with my Obsidian vault where I keep all my notes. Keep up the great work, I'll be browsing your channel for more content and to learn even more about excel ❤

yeah but now temp hp :(

AWESOME VIDEO! thank you so much :) it was fun to watch and easy to follow

Great

If you use an ifs function in the current HP box you can get rid of the error column. if max hp and damage is less than 0,0, if it's more than max hp, max hp, then a placeholder formula like if max and damage is greater than 0, max and damage. Current HP will work fine and not go above max or below 0.

This was very helpful - thank you!