I have two columns, arrivals / departures. Signup for our FREE Excel Tips Newsletter. Etc etc. Can you please help me out to how I can be a expert in VBA. Keep it up. Hi Chandoo. Hi Chandu, Hi how are you, I have one issue in excel while opening please could you guide me how to resolve the below issue. Wat Happened to my issue. I think you are all fantastic for sharing your knowledge and I've learned a lot from your site.  You have set up a good example here. I am in management but it's been years since I've been in school. hi, Developed by JavaTpoint. In the online class you get more details on below: i already buy the portfolio managment dashboard and need to let each project name in the dashboard have picture linked with dashboard , how can i do that. When I currently run it, it shows an error of "Method or data member not found" and highlights the "shp.Value" part. I left my full-time job in 2009 to start on entrepreneurial journey of running Chandoo.org Soon, the site gathered momentum and today it is a massive part of my life. I am getting Run-time error '-2147467259 (80004005)': etc etc, The only thing I will give is the end date of the event which is 10 June. if you have any program or n add on that can be used for this purpose please contact me. Builder Pattern says that "construct a complex object from simple objects using step-by-step approach". Hi Simran.. we have not received a single question or email from you. Congrats and all the best! and use SUPPOSE WE ARE SUPPLYING COCA-COLA IN A RETAIL STORE. Press Enter when asked for a password. Ex: Ninja assassins (2/4/2009 to2/5/2011) and i want to extract only text from the cell not the dates. Operator:=xlFilterValues, _ I wish to go for it and looking for materials, if you could help! completly site. Once again please accept my apologies for delay in replying and I hope to see you in our class. 6 @Sandip: please feel free to use it. Really interesting stuff on your site. i want to learn excel start to Macros however confused what to start and when to start. Like this article? I have a difficulties in my project that need your advice. Excellent for xl novices like me. These learning helped me earning Rs 50k for a project Great inspiration!! Am I doing something wrong? of risks for that project. At Chandoo.org you can post questions at the Chandoo.org/Forums or as a response to the relevent posts I am sorry if I makw a mistake asking this. now i have one problem as i am trying to add the numbers ( which have been fetched from a master table using 22 nested concatenate operators). I could not bring back my formula bar to my work sheet. Best wishes and keep posting. Keep up the good work. Â, @Naveen I am working as an Accounts Officer in BSNL. Hey Chandoo, m a fan. It has helped me come up with some great Excel solutions for my job. I have problem : help to my organization. ð, Great Effort! Mahanti. Good look. We would like to show you a description here but the site wonât allow us. Please post under personal category. cc For example If in cell B4 the number 7 comes, so the excel should tell â TOKEN NUMBER 7?, after that in cell B7 is updated 21, so its should again tell as â TOKEN NUMBER 21?⦠and so on it should keep doing the same. In âReconâ file under folder B, I have data of client B. Can you please drop an email at chandoo.d@gmail.com so that we can help. But i'm here to learn. I downloaded your check boxes, and copied/pasted them in...great if I only need those 30. but I need 100. the new ones I add in format back to the old check box "format" location from the first cut and paste. Step 8:Now, similarly create concrete sub-classes SmallMasalaPizza, MediumMasalaPizza, LargeMasalaPizza, ExtraLargeMasalaPizza that will extend to the abstract class VegPizza. If any off the users changes the token number, it gets change in our main display but the problem it doesnt say the token number. My love affair with your blog will never end. Have a look here:  http://chandoo.org/wp/about/what-we-use/ really fantastic work... if my room no. http://chandoo.org/wp/excel-tutorial/working-with-pivot-tables/. Hi, i am a novice in excel. Chandoo, you rock. Sending many thanks to you from the US for your fantastic, step-by-step guidance. Man Power saran l7, i want this ans I am really impressed with your ideas and the way you have chosen after IIM is really amazing. SEMESTER -I 1. Business Communication & Etiquette 2. Business Wishing you good luck in your future life. I appreciate you penning this post plus the rest of the site is I am looking for a gantt which is self explanatory for all the below activities as one project update. Please help me so that in future if I add 10 digits in C Column, it will automatically be converting in US Date format i.e. It helped me a lot and 2 days seems the CHANDOO BUG has got me. Thanks for sharing. visit my blog careerandresum.wordpress.com The values in the cells are in graduation of 0.10, say 0.10, 0.20, 0.30 ... My question is how can I look for a value that is not a multiple of 0.10, say if it is 0.05, or 0.16, or 0.23? The specific date works wonderfully! example at : https://rapidshare.com/files/437021034/Laxman_Autofilter_Date.xlsm, i am verry new to excel , i found it verry interesting and want to be expert in dis, would u just guide me , how to start learning step by step. Fiction books and novels curated by expert booksellers. The forums are at: http://chandoo.org/forums/ LIMCA=400C/S= 40% Now for the last few months after I save and close this file, when i again open it up the file has an error. I was able to gather formulas from great minds on other fourms and your blog. On the Dashboard , on the left hand side where you select you project it is not showing No. I came across your site and been looking through lots of your videos and liked how easy it is to follow. Please help if possible. As of now I have maintained a plain vanilla excel sheet for it. Column B: Actual Date such as 12/23/2014 How can i use your tutorials and from where can i start? Adding a sample file is always a good idea, refer: http://chandoo.org/forums/topic/posting-a-sample-workbook, i need formula for growth but my last year data is in minus I own a financial planning business in Australia and is planning to launch a property investment company and needs a worksheet which could given projections on home ownership , assumed growth , loan amortisations over 30 years and it should also have some provisions for tax calculations if possible . Kindly contact on pranaykapur84@gmail.com. To Value: 0.7 I'm sure people are rolling their eyes because this is obvious to them but like I said, I'm not good at Excel and I'm trying to figure this out for my boss. I have looked through the Spam and Trashcan and cannot see your post ? Even Chandoo is Role model for budding Bloggers!!! price $ 78. Are u not busy? I added a few Named Formula as well as 4 formulas I'd just like you to know I really appreciate your site and all the tips you give. Very Inspiring Journey For Being An Entrepreneur.. Hi 66  I'm one of the your FAN from Mongolia. I will be creating 50 new videos on Excel, Power BI, Data and visualization by End of 2021. Very nice website, Truly right now I am the big fan of this site. But sometimes i get error like "Subscript out of range error " Mohan. JavaTpoint offers too many high quality services. i am an civil engineer with mba 1. Thanks you very much for your lessons on excel. http://www.danwoodfamily.de. I would like to gain some fruitful working knowledge about Excel although I do not have any formal on the job experience. shp.Value = Replace(shp, " ", " ") I just wrote an very long comment but after I clicked submit my comment didn't show up. I recently purchased both your portfolio and project packages and I love them both! 22 33 44 55 It says I'm a member, but I can't go to the courses, I am trying to make a simple dashboard that I can customize and apply to several areas in the service we provide. Now create a Textbox (By default, the name of the textbox will be 'Textbox1' - and since this is an example, I am not changing it ð ) Thanks for visiting my site. How can I proceed it ? 01/12/15 00:30:00 mates. I think i will back again, to see another good one here, If you want to know more about me, please donât hesitate to contact me here. : 9957566574. Many thanks for all of your posts and email notifications. You usually find one or the other on most sites, but you have managed to have both. Love your site. Chandoo, thanks bud for putting up all those great excel stuff up there and above all sharing it. i am an indivisual working in a smal org and can not affoard to buy it. Sandy, Hi chandoo, @Champak: Thank you so much.     MsgBox "Space is not allowed. Phong, Hi Chandoo, Please unsubscribe me from e-mails (too many to keep up with). Thank you for your assistance and I look forward to hearing from you. I am happy you like my site. I offer some products and training programs. Its Awesome the way you have done it. Corporate is misspelled! (I have tried everything and I am really struggling!!!!) It definitely has some nice options for data extraction from the web. I have a question to post but Icant figure out how to get a userid and password. It's a perfect fit for a piece we're doing and I think our audience would find some of the content on your site super useful. Keep doing good work ð. a lot. So, client A data from its recon file I will copy and paste it in tab âAâ of Master file. In âReconâ file under folder A, I have data of client A. . Man, its awesm.. keep up that spirit. subset of B are 1,*,10 Your blog is brilliant. Can you help? I'll not recommend at all to join this..... Hi James. Finally, I have visited so many VBA forums and sites. Great service, Sir. HELP! Please keep such information always available.. Thanks for your interest in linking to us. @Vaibhav Keep up the good work, as there are many people like me looking for some help over excel!! Assuming, starting number is in A1 and value you want to subtract is in D1: Now, type any 2 numbers in A1 and D1 to see what you want. Step 14:Create an OrderBuilder class that will be responsible to create the objects of OrderedItems class. Although some functions/displays are of interest, I still desire a fair bit of customization to meet my portfolio and project management needs. I will be able to help you right away. I've always found it difficult to use excel, mostly because I rarely use it on a consistent basis. This video was pretty epic when it comes to pickup, Hello Chandoo sir I am a web developer and currently working on an e-learning project http://www.alphacodingskills.com. The country shares land borders with Pakistan to the northwest, China and Nepal to the north, Bhutan to the northeast, and Bangladesh and Myanmar are to the east. My rate is 5 US dollars per episode and your first one is free ð. It has huge things to learn. Then on the right hand pane at the top click the download button, Hi Chandu...great to watch your stuff on internet...i have an interview on friday but it is in excel and i never used before ..by trade i am a developer (dotnet)...all they metioned in the interview letter that i need to undertake an assessment, which will involve analysing data from an excel matrix...any example please .. if i get basic understanding "analysing data from an excel matrix" thats enough please....hope to hear from you soon. Mainly we focus on cleaning features. can you guide me on how to start writing the code? This is an EXCELlent tutorial website, cheers and keep up with your EXCELlent work and knowledge share. task 3 - 21 may Loved your intro. Thank you for your valuable site. Do you know of anyone who can build a simple dashboard for us? You can try using http://import.io. Please learn more about our policies or ask a question in our forums or get in touch with me. My friend recommended this site to me. Microsoft recently discontinued that product. I help run Celebpulp.com and I am trying to spread the link love by linking to other blogs that I think our visitors would like to visit. The Indian phone number given is not reachable. I wanted some tips on preparing cashflows using indirect method in excel. Wants to become like you. Cheers Tammy. Dear Chandoo, Can you asist me with fomular to match colums and return value i another column, e.g: What are typical fee's for a Phd from India and can it be done virtually? I randomly came across your website on a google search. Thanks for visiting my site. The online class overlaps 60% with the live class you attended. So with 1000 we cover all Nov remain inventory 1000-500, remaining 500 Next 1 2 3 4 5 6 Bienvenue sur la page Boursorama, portail d'informations économiques et financières. Your tag line for 'spelling mistakes in a corporate world. remaining saran rows deleted The original file pivots source may linked to some external source files. Delete any references in the Rows To Repeat At Top and Columns To Repeat At Left options. `- A B Can you help? Â, I am facing a peculiar problem on my excel file , i am using this file in my office. thanks a million! I tried your overlap and that helped, sort of. Can you suggest any resources on using VBA to create measures (calculated fields)? Next shp Or 2,3,15 and 17. This site is excellent. Hello Chandoo @Anindya: I am humbled. For personal purposes, it is ok I guess. Request you to please help me. The Macro Recorder doesn't produce any code when you create a new measure. first of all i would lke to say Thanks & congrats,this blog is amazing.... If Target.Address = "$B$1" Then ActiveSheet.Range("$A$4:$B$25").AutoFilter Field:=2, Criteria1:=[B1] vinayak k secondly We would like to explore a possibility of having a 1-day program only on How excel can be used for enhancing sales productivity? I happen to visit your site accidentally this year(2013) from Oct or so to be honest when i was searching for some solution for an excel problem, what dragged me in was the amount of information that you had provided in excel and the inspiring story of yours..thanks for sharing such abandant info which really inspires many to take something on their own...I also started writing my blogs recently "alltestingconcepts.wordpress.com" just to share my experiences and Knowledge with the larger audience based on available time with me(i am bit slow in putting up my blogs)..Probably people like you had some triggers in doing so which had affected positively..Thanks, Thanks for for valuable site chandoo, i am new to this site. 3- Chose a name then beside it again open data validation-> INDIRECT(select cell address ) please suggest me a book to learn microsoft Excel And word. I think sharing little bits via a blog on a day-by-day basis is so much better than writing one of those awful books. 13 Create an abstract class CD which will implement Packing interface. My Pivot table has two different Running total field(Running Total for for Column A and Running Total for for Column B). Subset of 3 are 7,8,11,12 no one gives such good templates @ free of cost what they will be expecting from me in personal interview . Great job you are doing. i have registeredwith Chandroo and got user name and pass word too Have you developed something which will help someone manage their finances/money? I would use Match instead of VLookup This site is absolutely a 'life-saver', very useful...I've shared it as a resource with many...and all of them have appreciated it. can you please tell me where can I get a data set on ecommerce website such as log files, time stamp files, clickstream data ? Nice site and feel good that ur an indian. 1. I am tired of doing transpose manually...looking for any help to do it using VBA code. Hey, i recently read an article on MSN about the work you are doing. On the Dashboard you have a box called People. Hi Chandoo, great to know about your achievements. I just discovered your website, I think that I am well versed on Excel, but there is definitely room for improvement. End If This is an excellent blog for upcomming students who are interested in computers.. Can you remedy that, please? I wanted to learn Pivot table - I got it from your site and many thanks. You're amazing Chandoo! 1 5 10 Sunday 1 From To This is a fantastic resource. GREAT SITE !!! With Regards. http://chandoo.org/forum/ Your site is an encyclopedia by itself for excel. U do have a life. I have bookmarked your site and will be back. You are really awsome in EXCEL. (you will see) Please can you amend this. I AM GIVING AN EXAMPLE: Now i have two question here I am saving lot lot of time and learning lot from forum members, Unglaku Eppidi Nandri Sollunumo Theriyamatidhi, Notify me of when new comments are posted via e-mail, One email per week with Excel and Power BI goodness. Thanks for creating this forum for people to learn excel tricks which are generally not so easy. The price quoted by Supplier A is â¹18.00 per 100 numbers of the components and it is found that on an average 5% of the total receipt from this supplier is defective. Saran @Nitin Hi Chandoo, SearchDirection:=xlPrevious).Row This is really hampering my work.Â. 33 44 55 66 77 88 99 1001 Asking questions are genuinely pleasant thing DATE TIME ENTER DATE TIME AUTO CALCUATED Bye aa bb cc am staying at Hyderabad.can u suggest me which institute is good and can u send me tutorial for Macros.i want to learn macros in MS Excel.please send me the notes. 05/12/15 01:35:30 i read your article on telugu daily jyothi These jobs have better career prospects and help you learn and earn more. Now I see nothing and my profile says I posted twice. The table however, will not expand with sheet protection on. Thankx. Chandoo is my nick name and I used it as my domain name too. I like your approach to offering tips and information. What I do is take your raw recording, edit out parts that you don't want, mix in your intro, outro, music, etc., normalize volume level and add ID3 tag. Can you please tell me how to create this fancy border on the image. Chandoo Blog is very inspiring to me . dear chandoo i want to draw an 45 degree 90 degree 180 degree etc etc angle on excel line chart what is the porcedure???  (you will see) Please can you amend this. I am sure personally, there is huge room for things to scale beyond but the journey has begun and i feel elated to be a part of this journey. Request you to share some good Ideas for the same.