How To Fill Reference Check: Fill & Download for Free

There are two methods of Demat account closingVisit to nearest HDFC securities office and get close by filling form and submit it.Write a simple mail as per screen shot below and there should not be any holdings in demat account the time you will mail them. Your account will get closed in five working days. In my case I mailed them on 22 Jun and account got closed on 27 Jun.For reference check the screenshots of email I received after sending above email to HDFC.After that response I received final closing status on email five days later.P.S.:- all of these details you can get from Netbanking login (Demat section).PS:- By new net banking layout, some of the information that users can get from is NetBanking -> DEMAT -> Enquire -> Client InfoThank you kul

Single most underutilized trick, that I have almost never seen anybody use, is the shortcut Ctrl+D.Ctrl+D seemingly copies the contents of the cell immediately above the current cell to the current cell. But that’s not all it does. If the above cell contains a formula with references to other cells, Ctrl+D will not simply copy the contents, instead it will copy the formula with all references updated and will display a result.I have seen people working on Excel in high paced jobs where they had to keep repeating the same thing over and over again in a column, like a date, and they were leaving the cells empty to fill at the end of the day at once because repeatedly typing the entire date took too long. They were shocked when I told them how they could save time by using Ctrl+D.Update:A commenter mentioned, in a rather cryptic manner, that if you select a column of cells where first cell is not empty, Ctrl+D will work like fill handle being dragged down and it will use the top cell as the template, will update references if a formula is found.I have checked. It works. Same thing works for Ctrl+R too if you’ve selected a row. Contents of left most cell will be used in this situation.One exception to note is that fill-handle can guess a data series to fill by using data in first 2 or more cells. Ctrl+D and Ctrl+R simply copy data and formulae, they do not guess data series.

Yes. Absolutely. My first job from campus was at Microsoft HQ in Redmond as a SDE in the much coveted Core OS team of Windows. Microsoft was at that time the world’s largest tech company and Windows was its crown jewel. I had 3 competing offers — from Google and 2 other tech companies. I didn’t go to a top university. That didn’t limit what kind of jobs I could get and this is despite the tech economy not being as hot as it is today.Top companies hire thousands of people each year and it is very hard for them to fill solely on the basis of degrees. MIT and Stanford barely produce 100 odd CS majors each year. The same is true for most top notch schools around the world. And many of these graduates love to do something else besides working for a big corporation. While tech recruiters absolutely love students from top institutions they are also in the look out for top talent coming from outside the traditional academic system.The reason recruiters look for top schools is because:It shows strong work ethic and commitment. Getting into and graduating out of a top school shows that you can work hard. You might not be a genius, but you can work hard.It allows easy checking for background. Reference checks are easier in top schools and there is a bigger element of trust. As a recruiter you don’t want to be embarrassed by the person you brought in.It shows you can learn fast and will not be too intimidated.If you didn’t go to a top school, you need to find ways to replicate the 3 things that recruiters look for.Show incredible hardwork. If you had worked 2 years contributing to a popular Github project and have hundreds of commits to show for, it will be hard for a recruiter at Google or Facebook to not call you for an interview. Go way beyond your academics and stand out with contributions outside.Build up trust by working with people that big companies trust. If you had worked on a big research project with a professor from a top lab or if you had published a good paper at a top journal or if a noted person in the industry can recommend you because you had impressed them with your intellect/skills, you satisfy the element of trust.Show the ability to learn fast with your projects you have done off-school. Code for fun and build super interesting stuff. During your interview, if you could show well you thought through and built your projects, your interviewer can be quite impressed. I interview 100s of students from top colleges and I’m always astonished how few actual projects students have done. Most show cookie cutter, copied projects that any professional interviewer can see through (if you are from an IIT, please don’t show the ‘Ultransonic walking stick for the blind’ — I have seen it 300+ resumes now and I know you copied it).Remember, the guy who has gone to a top institute has often worked quite hard to get in. To compete, you need to work twice as hard in college to make up for the lost time. No way around. If you don’t have anything interesting in college besides your mundane classwork & exams, it is super hard to rise up.If you are from a not-so reputed college, here is the simple way out. Take the next year working for a coding project and spend 1500+ hours in it — code 4 hours a day, day after day for 365 days. I guarantee you, that is most likely to get you an interview to a top company. You can surely find 4 hours a day [there is a lot of pretend work you can do in a boring class, while you secretly hide your CLRS and build algorithms by hand] and 1 year is not too long given that you have messed up your high school by not being able to get to a good college. Don’t get sucked by the people around you — the masses are the most dangerous obstacles. You need to be nice to them, but you don’t need to be them.