Dr. Dinesh K Takyar, born in Chalaila, Punjab, India studied in St Michel's High School, Mumbai. He finished his Ph. D. from Hamburg, Germany. At present he is a corporate trainer with main concentration on Excel.

A complete guide to how Microsoft Excel is used.

Creating custom functions in Microsoft Excel can help automate your work.

How can you perform calculations based on criteria? Use the 'if' function!

Once you have data in an Excel worksheet, the next step is to extract information out of the data. For example, a teacher may need to know which students got grade A in Maths, an employer may need to ...

Using Data Validation to input data into Excel cells can improve your productivity substantially. Surprisingly few people use the data validation feature in Excel!

Named ranges can help you save time and make your calculations more intuitive in Microsoft Excel.