Video

Thanks al lot for this wonderful video

This is only available to Beta users

Do these functions work only when the base data is structured in TABLE format?

I didnt't got checkbox & python, any solution for it?

Sir please make one video on how fresher get their first data Analytics job without any past experience, also who also want video on this topic please like 👍🏻👍🏻

Ha. I made this invoice (with my own custom design) for a friend. Followed your instructions and code but when she loaded the invoice onto her laptop the address cells controlled by the xlookup function failed. Turned out her excel version was 2019 so xlookup was not recognised had to use vlookup. But she is happy and is productive.

HOW CAN I FIND A BLOCK NUMBER IN 100 APARTMENT - MY SEARCH WILL BE THE APARTMENT NAME AND THE BLOCK OR FLAT NUMBER

Hi Kenji, hope you have solution for the radio button problem. @erikguzik8204 has given the solution and good suggestion for the selection of limited cells only. Let me simplify it. Need to unlock cell reference which is linked with the radio button.

What an absolute masterpiece! I was searching for such a course like this. Great job, thank you for this :)

Hi, is there a way to make it so when you search, it returns the values its found in the smaller table but is also editable in that table, and then whatever changes are made in the smaller search table are then executed in the original table? I hope that makes sense, any help would be greatly appreciated!

What if you had annual data and needed to add a date filter to get monthly?

How will it impact in terms of performance if we use formulae instead of pivot tables?

can't. really import ,, there's a pop up that says: Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range(128) 😫

Kenji is by far the best in regards to excel and overall ease of explanation

Great video, Awesome job!

IF you have room on your worksheet.…

Thank u. It's really helpful and not even an analyst ❤

the best

Interesting.

Thanks for sharing. Awesome!

After 6 months still no Checkbox. Sad.

Anyone else had trouble downloading PowerBi Microsoft?

Every crash/collapse/recession provides an equal market opportunity if you are properly prepared and knowledgeable. I've seen people amass up to $800,000 during crises and even with ease in a bad economy. Someone has undoubtedly become extremely wealthy as a result of the crash.

this is so helpful thanks for creating and i look forward to the next one! blessings!

Hi Kenji. Sorry what is your full name in order to send you a Linkedin invite ? Thanks.

Hello. Can you put here the excel file for DCF starting from EBIT please ? Thanks.

You can just click in the pivot table and press refresh. Do not need to go to the ribbon.

Hello Kenji. This is a very helpful video. I am wondering if can we use spin button from the developer tab instead of drop down list. For example: the first spin button will spin Region and the second spin button will spin only those Countries of a Region selected by first spin. Thanks

i have one question , when i analyzing the data , on pivot analysis on the data invoice how the date and month i remove from the column selected?

it is very nice and very impressive

love this function and thanks for the demonstration. how long does it take to get access to this stuff in excel? i just set myself up as a beta user and the function still isn't available to me. I'm also hoping to be able to use the REGEX functions that are in beta. Does is take a couple days to kick in??

cool, like the test. didnt know about the goal seek tool. for last task when using xlookup for multiple criteria i like to use this format as i find it easy to visualise: xlookup(1,(range1=criteria1)*(range2=criteria2),return range) so in your example it would be: xlookup(1,($B$11:$B$22=$B7)*($C$11:$C$22=C5),$F$11:$F$22) helps when the data is in a table too.

Add a button to refresh the pivot table

How to get Summary of invoices

Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value

"command+enter " at 8 step to full fill empty sheet at MacBook

Absolutely clear, no BS, straight to the point and you make the content very easy to understand. Much love Kenji.

Bonus trick super

जय श्री राम

Nice video but I'd challenge that in general it's not a good strategy to use Excel to collect information from users. This is precisely what a Form is for which is included in the Microsoft office suite. Most of the tips/tricks in video only make Excel look like a form (additional ideas would be hide the unused rows, add protection and hide headings). Inserting vba into the equation reduces the overall security of an office by enabling macros (especially if they have to record). So nice vide, but bad idea. Your other stuff is better 🙂

Awesome tool . One day hopefully I can be on that list

Thank you so much, just a questions, the %completion not working fine with small duration tasks, like say the task is 7 days or so with weekly scale

Is there a significant difference between the two methods in the last question? Are there specific use cases for each, or is it just preference?

What about pivot?

perfect video I have a question in the "form" you have the item "Staff ID" how is it possible to make the "Staff ID" value so that I don't have to enter it manually, but it would always be new with a new record example: first staff value 1 second staff value 2 etc... something like n+1 always on a new record

Thanks.Great job. I completed the Gantt chart and am very excited to implement it. You are excellent, sir

U r the best thank u

You are a great teacher.

cost breakdown for agriculture farming

The way you explain this topic is really clear. Thanks.