Last 50 Posts on Chandoo.org

Chris on 2022-01-19 11:51:24
So I've managed to expand out all the tables to create a template for up to 100 users. Problem I now have is that the lines aren't matching to the name labels in the graph. I assume this is something to do with the radius value? Any ideas? Happy to share where I've got to so far if anybody is interested in helping me through the final steps?

nirmal singh on 2022-01-18 13:26:26
nice brother super information

Cladon on 2022-01-17 20:01:48
I ame working with "Office 365"

Cladon on 2022-01-17 19:59:42
I have the same problem. I have a value "-1" for Distance and Travel Time. What does it mean? The statuscodevalue = 200. What does it mean? I have a valid api key.

Pinak on 2022-01-17 05:25:09
Hello Chandoo, I am not able to download the file using your link? can you please help? Reference to link: Download the mutual fund portfolio tracker excel workbook now.

Rahul Srivastava on 2022-01-15 07:07:33
Great Work!

Stella Smith on 2022-01-14 04:56:12
Wow, I am blown away, thank you for sharing your knowledge. We use a lot excel to manage our work flow with contractors, this is definitely gonna help.

Naqeeb on 2022-01-12 17:58:22
This is a 100% helpful article about the solution for common problems. thanks

Srinivasan.R on 2022-01-12 11:58:16
Dear Sir, Your 2022 calendar is awesome , but in planner if i edit the "your plan" sheet, some errors are coming as "Name"in all the cells in Monthly calendar+Planner sheet, Please help to get it corrected.

Parish Chandra on 2022-01-11 06:05:11
HOw did you solve this problem?

Kiran on 2022-01-09 16:40:53
Firstly, thank you for the Mutual fund Tracker. I downloaded it to my system and entered my mutual funds data. But i found that it works only for lumpsum investments and not for SIPs as it requires me to insert all my SIP investments data month-wise. For example:- i started investing in ICICI prudential SIP with Rs.1000 per month from May-2020. I need to insert total 20 months data to get exact current value. Kindly look into this. or let me know if there is any other way out to insert all my SIP data (monthly investments)

Edna Timba on 2022-01-09 03:01:16
Option 1 by Bigtaff is the best!

Tetonne on 2022-01-08 16:30:31
Hi Chandoo, thanks for your website and all the tips... there are great it could be great to have this Calendar & Monthly Planner Printable Template with .ics export i share with you : https://www.vbforums.com/showthread.php?674670-utf-8-string-converter and this : https://datatracker.ietf.org/doc/html/rfc5545 Have a blessed 2022 all the best Tetonne

Chandoo on 2022-01-08 05:35:52
Please refresh the page and try again. It is working now. The link is also here - https://chandoo.org/img/c/101in1001-new-year-resolutions.xls

Poornima on 2022-01-07 13:03:01
Hi chandoo, Happy New Year, Im working on student database and we are creating the dashboard where students can see there performance of all the mock test but im stuck creating the table for mock test where For example: we offer banking course and if the student has taken a 10 mock test where in banking we have three sub section also like english, general awareness, Quantitative aptitude when we click one mock test all the score and the section score need to be seen in visualization can you please help out to this

Melissa Ruhland on 2022-01-06 17:49:41
I was trying to download this New Year's Resolution template but the link no longer seems to be working. :(

Eric Velthoven on 2022-01-05 17:20:33
Dear Chandoo, First of all, also for you and your family the best wishes for 2022. I have a question concerning the free 2022 Calendar & Monthly Planner Printable Template. I would like to start the week with Sunday instead of Monday. Can you please make an adjustment and send it to me, because I have not enough Excel knowledge to do this. Thanks in advance for your help. Best regards, Eric The Netherlands

Pagalworld on 2022-01-05 16:09:34
Wow!! Great... I am searching for some excel tips in Google then I found this site. Chandoo Sir thanks for helping us.

Neville Divecha on 2022-01-05 15:03:15
Chandoo ... great idea for a calendar/planner combo. If I may suggest, a calendar week numbering system adjacent to the week would help. Numerous occassions in our organizatioon people mention completion by calendar week CW6 for example. Thought I would share this with you. Have a blessed 2022.

Pran on 2022-01-04 17:35:36
I want to learn PowerBI from you.

Duong on 2021-12-29 05:04:00
Can I use it in Excel 2007?

required on 2021-12-28 17:15:12
Horizontal numbers in line chart start at 1, so they consequentally get offset, reading 1, 11, 21, Jesus save us. Why is default not 0, 10, 20, 30. Including belittlement, no answers on the internet actually fix this issue for humans, math-minded or not.

Jens Stencel on 2021-12-28 07:51:19
Hi Chandoo I use this formular to calulate percentage of the revenue in my income statement ( I have seen it in your you tube channel:-)) =Sum('LEDTRANS 1'[AMOUNTMST])/Calculate(sum('LEDTRANS 1'[AMOUNTMST]);all('LEDTRANS 1');'LEDTRANS 1'[Type]="Revenue") It calculates the correct percentage for all the data but if I chose a month in the pivot table the result is not correct, hope you can help? Best regards Jens

Levi on 2021-12-26 23:18:54
Great summary! Perhaps also worth noting that this is limited to the personal version of OneDrive. Hopefully it gets expanded to the business version at some point - and maybe it is already possible somehow but does not appear to be the default at least.

Praful Patil on 2021-12-23 07:55:12
Dear Sir, How to seperate amount, mention in remarks.

Suyash Singh on 2021-12-22 10:34:50
it would be fantastic if it was possible to track MFs based on a transaction statement. Any ideas on how to handle SIPs, if I am buying a fixed set of MFs every month.

jeremy on 2021-12-20 06:38:10
Hi have you found a way to solve it? im also suffered from that PowerPivot with it you cant use the calculated item function which is quite powerful in excel pivot. pls help.

David N on 2021-12-17 02:36:35
If we're using Excel 365, then XMATCH (or XLOOKUP) can perform an ascending or descending search without actually having to sort the data. So you don't even need the MAX function to find the highest GPA. =INDEX(C6:C45,XMATCH(99^9,D6:D45,-1)) And since we're already using Excel 365, SORTBY and SEQUENCE can handle getting the top five. =INDEX(SORTBY(C6:C45,D6:D45,-1),SEQUENCE(5))

krishnachaithanya on 2021-12-17 00:02:07
Hi, Chandoo, Iam thanking you for this course . your aim is to make awesome in Excel & Power BI is very good. This course is structured in a very good manner and understandable easily . It is very useful for aspirants like me who is going to start the career in data analysis Thank you so much krishnachaithanya gariki Nellore , Andhra Pradesh

Tom on 2021-12-15 16:07:41
I am trying to create a dynamic range based on the number of months eclipsed to an IRR function. I would like to get your input on how to do that. Example: [Cell A1] Beg Balance = -20000 [Cell A2] Monthly Contribution = -200 [Cell A3] End Balance = 25000 [Cell A4] IRR % after 5 months of contributions =IRR((A1,A2,A2,A2,A2,A2,A3),0.01) I am wanting to avoid adding another A2 after each new month.