Excel/Expert Profile


Ask A Question

Expertise

I can answer questions related to the following topics: 1. MS Excel - Creating and Linking Formulae, Running Pivot Tables, Vlookup etc. 2. Macros / VBA - Creating Macros to do specific jobs. Importing / Exporting / Validating Data in excel through Macros.

Experience in the area

I've been working on excel for over 10 years and on VBA macros for over 3 years now.

Education/Credentials

Bachelor of Commerce, Chartered Accountant from The Institute of Chartered Accountants of India

What do you like about this subject?

To me, excel is the most powerful and versatile software I have ever come across. I have not come across any problem which couldn't be handled in Excel.

What do you still hope to achieve/learn in this field?

Learn more and more in excel by answering more and more questions.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Nat08/17/16101010Thank you very much, works great.
Bimmy08/04/16101010Only 1 thing... Hope and Wish that .....
Natalie06/15/16101010Thank you Gulshan, i will give the .....
Natalie05/06/16101010Thank you very much Gulshan, this works .....
Dimitris04/01/16101010Very fast and accurate answer, you are .....

Recent Answers from GULSHAN PURSWANI

2016-11-21 Kindly assist me in filtering a pivot using a cell reference:

Dear Jayendran,  Can you share more specific details of your problem:  1. What is the error message you're getting  2. What is the pivot table setup you're using  3. Can you share a copy of the file which

2016-09-06 Copy row from WB to another WB:

Hello Khaled,    This can be easily achieved using a Macro. I need a few answers before I start working on it:  1. How does the macro identify the row to be copied, is it the first row / last row / or

2016-07-28 Too many layers in formula:

Dear Jeff,  Excel has a limitation that it can allow only a maximum if 7 if statements within a loop.    If you want to use more than 7 conditions, then you'll either have to split the formula across 2

2016-07-16 Paste Value VBA if criteria met:

Dear Jason,    Thanks for the detailed question. Let me rephrase the question as per my understanding and try to answer it:  You are looking for a value in column Z based on certain logic but you don't

2016-06-22 If and Count Statement assistance:

Dear Richard,    I'm not clear with the question.  1. First up, the dropdown cannot be made conditional upon the value in another cell. Excel supports simple dropdowns. If you still want to have conditional

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2016 About.com. All rights reserved.