You are here:

Excel/Expert Profile

Victor Lan

Singapore

Unavailable

Expertise

I can assist you in manipulating and filtering data, creating and using formulas, pivot tables, and writing VBA to solve problems and automate processes. I can also research and find a solution for almost anything in Excel for you.

Experience in the area

3 years of professional Excel experience. Currently working for a global Investment Bank.

Education/Credentials

BSc Banking and Finance (First Class Honours), University of London. Diploma in Electronics, Computer and Communication Engineering, Singapore Polytechnic.

What do you like about this subject?

Excel is one of the most important tools used by many organization globally. When people are proficient in Excel, they save time, be much more productive at work by automating manual processes, and add value to their organization by focusing on higher value-added activities.

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

I hope to share my knowledge and expertise in Excel and to connect with people with similiar interests. You are welcome to email me AT victorlan.allexperts@gmail.com if you would like to say hi, drop me a message, or just to connect.

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
AUREL	04/01/10	9	9	9
Dennis	04/01/10	10	10	10	Thanks
Zhao Ge	03/31/10	10	10	10
jenny	03/30/10	10	10	10
Alan	02/25/10	10	10	10	I would like to thank Victor for .....

Recent Answers from Victor Lan

2010-04-07 excel help:

Hi Kaye, To find duplicate companies in your Excel file, assuming that you have one column of companies name in column A. Use Excel Advanced Filter and filter for unique records only. http://www

2010-04-06 Finding Max and Min:

Hi Dante, Sorry I don't quite understand your question. "I have a row of numbers on the top row. i.e. 15 20 25 40 50 80 100 150 200 250 300 400 450 500 600 750. I would like to fill up the min

2010-04-05 For/Next Loop:

Hi Stephen, The following code will store the values in range A10:F15 into an Array Variant. It then pass it to the function DisplayData to process assuming 5 rows (friends) and 6 columns. 5 rows

2010-04-05 If else multiple cases macro:

Hi, Thanks for the further explanation. The following code will determine the last row in column D and save it to variable LastDataRow. ============================= Dim LastDataRow as Long

2010-04-04 unusual file size:

Hi Nalin, It is quite difficult to pinpoint the issue with Excel file size. Backup your file and try the following: 1) Do the following to all worksheets. Select any single cell, press F5, click

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

Encyclopedia

Browse Answers: