Last 50 Posts on Chandoo.org

Daniel on 2021-06-13 03:38:34
Thanks for the excel dashboard how-to pointers! Dashboard is indeed something important to learn if you want to visualize your data in excel

Tetonne on 2021-06-12 14:06:29
great thanks a lot :-)

D. Dutta on 2021-06-09 14:27:49
Hi, I am using this. However, please note that SBI Equity Hybrid - Regular Plan - IDCW is not in your data base. So this fund is not updating. Request you to look into this Thanks

Sam on 2021-06-08 19:31:12
Really enjoyed this however I have tried several different ways and am struggling with managing the relationships. Can only link each dimension to one fact table, not multiples. Have troubleshooted and tried several different methods but alas.

Rambo on 2021-06-08 11:33:20
Found it, had to flip the MM to DD then it started working Text.AfterDelimiter(Text.BeforeDelimiter([Date of Join],"-",1),"-",0) &"/"& Text.BeforeDelimiter([Date of Join],"-",0) &"/"& Text.AfterDelimiter([Date of Join],"-",1)

Jay on 2021-06-07 13:07:41
Hi in my Chart data labels reflecting for (slicer) person A and I am changing in B it's not reflecting please help me to identify the error and make it correct

Paul Clifford-Jones on 2021-06-07 11:08:31
Many thanks for a thoughtfully produced, well structured and evenly paced video and supporting material. Professional and approachable.

Kingshuk on 2021-06-06 15:26:38
How are you getting " % of total cost " as 80% for class A ?

Brij Bhushan on 2021-06-06 10:52:58
Hello Chandoo, Your excel tips are excellent. I have learned so many things from your website and your videos. I want to thanks you for everything. You made best tutorials. Thanks for all this.

Rajeev Saraf on 2021-06-06 07:20:36
Hi Chandoo First of all, thank you for BEING AWESOME IN EXCEL. I have learnt a lot in Excel during last 1 year of lockdown, thanks to you. Regarding timestamp, I have a query - I have made a file for my sales team who are supposed to fill their daily sales visit reports and send to me on excel. I have created a timestamp and told them about enabling iterative calculation also. However, when they send the file to me and I save the file, the timestamp changes to current date for all. How do I correct this? PS - I do not use VBA / Macro because my team is not tuned to these and I also need to learn it yet. So I am dependent on formulas only in the cell. Regards Rajeev

CricketMyLove on 2021-06-05 13:48:26
A very nice site to visit & learn Excel. Which WordPress theme you are using. Superb

Vandan Dave on 2021-06-05 10:14:38
Please explain this formula ="We are "&IF(INT(K21)=INT(K18),"on",TEXT(ABS(K21-K18),"0")&" days "&IF(K21>K18,"behind ","ahead of"))&" plan."

Freddie Wofford on 2021-06-04 17:36:22
I am having another problem on the dashboard. The block for the "next 6 months in the below projects" is not calculating any information. How can I fix it?

Freddie Wofford on 2021-06-04 17:32:02
I just purchased the project portfolio templates. On the dashboard in the Ganett chart view the scroll bar on the right hand side does not appear. How can I fix that. Thank you.

Thierry Santhi on 2021-06-04 13:59:41
Excellent and easy! Congrats

Abhinav on 2021-06-04 04:29:55
As usual, your trick was "dead simple" and finished before I could finish my coffee. I have a query though, instead of highlighting the cells on selection of drop down values, is it possible to block certain cells?

Dave on 2021-06-02 17:17:00
Absolutely Brilliant!!! I used to vlookup from List A and then again from List B to understand what were duplicates and unique data items. This will save a ton of time! Thanks again!

Christian Salway on 2021-06-02 08:51:48
This is no good. it can leave a column without a number, which is not correct rules.

Brij Bhushan on 2021-06-02 00:05:45
This is a great help for me. Thanks for providing valuable information.

Suresh on 2021-06-01 08:56:18
Worked awesome! Thanks!!

Suchitra on 2021-05-31 14:09:50
Sir, I have no idea about all these things but want to have an excel sheet which sends out reminders on mailing or alerting donors about their current year donation due. It should serve as a reminder for us. How to do it ?

Arjun M on 2021-05-31 10:20:08
Thanks for the great video, Dear Chandoo. This may be useful Employee Turnover Rate = Employees Left / ([employee count at the starting of the period + employee count at the end of the period]/2) x 100

Marian on 2021-05-31 06:18:33
I’ve been working with Excel all day but after seeing this blog I think I can easily submit the report after few hours which usually takes me the whole shift and sometimes, it takes me days to finish it off.

Sethumadhavan V S on 2021-05-31 05:11:05
Hi Chandoo, We have a attendance for civil labour at site. we need to maintain and give payment at the end of every week. the problem is, it the wages varies from Mason to Helper-1 , Helper-2 etc. Also we used to change the site as per the need. Now the task is we need to calculate their wages as per their presence and also need to site wise work detail. Can you help me in this regard. Note: If required I can share the file. Regards, Sethumadhavan

Mike on 2021-05-28 22:06:14
Mouth literally agape at how awesome this is you put this together. Literally thought I had 0 chance at finding a way to do this through Excel - though i did luck out we had existing API keys! Amazing and thank you so much!

Ninan Thomas on 2021-05-28 16:17:19
watching

Ashit Shroff on 2021-05-28 15:59:56
Thank you Chandoo!

mubarak on 2021-05-28 15:16:08
hi chadoo, Thanks for your wonderful articles on Excel. I have a doubt on demo application file where you are declaring values for inThisRange variable in checksales function

Ruth on 2021-05-27 19:59:11
Any word on how to add multiple events to the same day?

Ahmed Mallook on 2021-05-27 05:37:07
Hi, Thank you for the great tip. One problem, when I click on get data >> from file, I don't see the PDF source option. How can I add it? I tried to add it from Quick Access toolbar >>> Data Tab, but again the PDF option is not listed there. I am using Office 365