You are invited [personal]
Almost an year ago, my life took a pleasant, awesome turn. I became dad to two beautiful, naughty and energetic kids. We named them Nishanth & Nakshatra (meaning Moon & Star). Ever since they entered our world, our lives have changed. They bring laughter, love, anxiety and curiosity to our life everyday. And this Friday […]
A round-up on Circular References
Here is a little experiment to freak out excel.
Go to cell C3 and write =C3 and press Enter. Excel would throw up nasty message saying, “Microsoft did not know what to do. We have a sent a support engineer to your home, but he is stuck at the round-about near your house.”
Well, not really. But what you did when you wrote the formula =C3 in cell C3 was, you created a circular reference.
A circular reference is created when you refer to same cell either directly or indirectly.
See Mona Lisa, in circular reference style.
Learn more about Excel Circular References, how to use them, examples, how to avoid them, how to deal with them in this article.
Excel School is Open – Join Today
Hello reader, my friend & supporter,
I am happy to announce that Excel School is open and ready for registrations.
Visit Excel School page to learn more and sign-up.
In this post, you can find some information about the program and links to sign-up.
Make your data validations dynamic! [quick tip]
Ok, since excel school 3rd batch is going to open on 15th, I wasnt going to write anything today. I have slept just 4 hours last night, blame it on work (and that funny video on youtube). But I found 30 minutes free time, so here you go, a quick but delicious tip on making your data validation dynamic.
Dynamic Data Validation?!? What in the name of slice bread and peanut butter is that?
See the demo aside to understand and read on to master the trick.
How to Calculate Working Hours Between 2 Dates [Solution]
This post builds on earlier discussion, How many hours did Johnny work? I recommend you to read that post too. Lets say you have 2 dates (with time) in cells A1 and A2 indicating starting and ending timestamps of an activity. And you want to calculate how many workings hours the task took. Further, lets […]
10 things you should know about Excel School
This post is about my Excel School online training program. Feel free to skip if you are looking for excel tips. Some of you know that I run an online Excel training program called Excel School. It helps excel newbies and beginners to learn about various powerful features and become proficient in them. We discuss […]
How to Paste Numbers Only [quick tip]
Sometimes when you are working with data, you may need to just copy and paste numbers from one range to another. Here is a handy little trick to achieve that.
Use Paste Special > Add operator to paste numbers only.
1. Select the source range, press CTRL+C
2. Now, go to target range, press ALT+ES to activate paste special dialog
3. Select “Add” operator (you can press d)
4. Click ok.