Search results

@Chihiro wow thanks a lot that is amazing I wish you all the succcess and thank you for all the help in the past I think that is the way to go...I mean I imagine spending whole day discussing with clients clarifying what the requirements are and then clients eventually decided to say no and what...

@chihro wow thanks for your great advice. I realize that freelancing not only requires Excel skills but also project management skills, good sales skills, strategically choosing clients in other words positioning myself in the market. Also maybe emotional intelligence because there is fear of...

@chirayu Thanks yes do you find that some clients do not understand Excel at all and they may give unrealistic estimation? For example they might think if we find bug and spend more time they think we lack competencies and must work some hours for free. I guess the issue here is agreement on the...

Dear Community, Hi! Today I wanted to ask you this question because I was looking for excel-related work. What are the most common ways for Excel Engineers to do business? I can think of following but not sure which ones are common these days. [product base - paid by product] 1. Add-on...

@chirayu Thank you... This discussion reminded me of difference between strategic and tactical. For example, you can choose how to get from point A to point B. (Airplanes, ships, walk, cars) But then in big scheme of things, is it really necessary to go to point B? What if we go to point...

@chirayu Thank you for your post! The way I see it is not just mind-set. It is challenging this assumption that we can prevent errors. Tricks and techniques are good, but we also need to accept limitations of those and embrace alternative solutions such as teamwork & initial planning Can you...

Yes but you cannot under-estimate either. I think the challenge is to communicate and let people understand all the weaknesses while not also killing motivation and offending them. I think we just need every stakeholder to understand regardless of expertise in Excel there are human...

I am just sharing some infor here for cognitive biases Before I read a book called "Art of Thinking Clearly" Rolf Dodelli It was a good book. https://www.goodreads.com/book/show/16248196-the-art-of-thinking-clearly Dan Ariely is also good. http://danariely.com/ List of Cognitive Baises on...

@Peter Bartholomew, Thank you for sharing those. I understand your point. We humans have tendency to over-estimate our own abilities. I have a friend who used to work in Toyota and he always used to say 'work in a team. Team-work is everything." Some years ago, I also saw documentary of a...

@Peter Bartholomew @NARAYANK991 Wow wow... thank you for your posts!!! I did not read all the articles but I agree with the idea that we must accept the fact that humans make errors. If you are sick and need operation, would you go to one super doctor, or team of 3 average doctors...

@GraH - Guido Thank you so much! Great advice!

@Chihiro Thank you so much for your answer

@NARAYANK991 Wow thank you for your reply and these articles! I realized that designing & planning are very important.

3. Error Check Sheet in Template (book.xltx) I also have error check sheet in Template File, so every new worksheet will contain this sheet in order to remind me to double-check things

Dear Chandoo Community, I am sharing some of the strategies that I came up with in order to prevent errors when working with Excel I would be extremely grateful if you could share yours 1. Visibility of formula I try to check every formula contained in the Excel before submitting using VBA...

@GraH - Guido Thank you so much for this!

@Hui, @chirayu Thank you so much!

@Chihiro Thank you so much!

@Hui and all *I am sorry I am not sharing every information. I thought if I simplified my problem, I would get better answer, but I realized now that best solution depends on many factors. All I want at this stage is to explore various options for range lookup and I will experiment and learn...

@Hui @Marc L Thank you so much!!!!

@bosco_yip Wow...thank you so much!!!

@NARAYANK991 @shrivallabha Thank you so much for your answers!

Hi! Thanking you in advance for your help... I need to do lookup from table of 1 column that contains + 50,000 rows. I can only think of 3 functions to do this. 1. vlookup 2. match 3. countif My questions are: 1. Is there alternative way of doing lookup? 2. Out of these options, how can...

@Marc L, @Chihiro Thank you so much for your feedback!

Dear Chandoo community, I want to ask your opinions or experience of switching to Access from Excel. I want to know what was the main reason for switch. Here is my situation: 1)Every day I have been adding 100 rows of data to excels manually 2)Now the worksheet contains 10,000 rows. 3)For...