You are here:

Excel/Expert Profile

Victor Lan

Singapore

On Vacation
returns 12/01/2009

Expertise

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

Experience in the area

3 years of professional Excel experience. I currently work for a global investment bank and our team is responsible for certifying the daily profit and loss of the trading desk. Excel is one of the primary tools used at work.

Organizations

Member of Toastmasters International.

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 could save time, be much more productive at work, doing away with manually processes, and adding more value to their organization by focusing on creating 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 with as many people as I can and to connect with people who want to know more about the possibilities of Excel. 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	T	P	Comments
Dominique	11/16/09	10	9	10	10	thanks a lot for this answer! Dominique
Bhavesh	11/16/09	10	10	10	10	Hi Victor Thank for support to me .....
emre	11/15/09	10	9	10	10
Bhavesh	11/14/09	10	8	10	10
Kelly Moore	11/11/09	10	10	10	10	Such a clear and concise response, and .....

Recent Answers from Victor Lan

2009-11-16 Absolute cell reference:

Dear Kirupairajah The example you gave is perfectly correct in both Excel 2003 and 2007. Absolute cell reference does not change when you copy the formula to other cells. In order for the formula

2009-11-15 variable data size in a chart or worksheet:

Hi Dominique, SERIES is a special kind of function to define a chart series. It can't incorporate worksheet functions or formulas into its arguments. In order to create a dynamic chart, simply use

2009-11-13 First Blank:

Hi Stuart, I'm not sure which worksheet you are referring to with the statement "either B or C is blank, C returns a sum of all the values above it?". The following examples will help you. To

2009-11-13 How to serch speedly ?:

Hi, To speed up Autofilter, especially while working with large excel files with many formulas, I would suggest the following: Open up the files, make sure the formulas are updated/re-calculated

2009-11-12 Locked up a column only:

Hi Mr. Lo, Yes there is a difference between 2003 and 2007. At the first glance, the interface is really different. If you want to lock a picture: select the picture, go to tools>format picture>

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: