excel info

S

SuperCop

New member
Joined
Jun 18, 2026
Messages
0
Reaction score
0
just was wondering if someone can explain to me on how to go about doing the following:

1-how do i go about doing V-lookups and what the heck it is ...
2- macros
3-pivot tables

would appreicate some help

thank u
 
I'm no expert in excel but i'll share to you what i know..

1-how do i go about doing V-lookups and what the heck it is ...
Used to search for values that are from different dataset/s. For instance, you have two sets of data (A and B). There are information in B that you'd like to have in A. One of the way to do this is by using the vlookup formula.

2- macros
Created to make complicated things simple (or to make an entire computation/processing automated). Indeed very complex and neither do I have an idea how to create one.

3-pivot tables
To summarize data (and at the same time, edit table formats as one pleases to have a better analysis).

IT peeps, please correct me if I'm wrong. Hope these help.
 
vlookup is called as Vertical lookup there something similar called as hlookup which is horizontal lookup.Vlook functions works asfollows
Year I
1 2.5
2 3.5
3 4.5
6 7.8

if you give statement vlookup(range, 1 , true) you will get 2.5 Please find more abt this function at
http://www.techonthenet.com/excel/formulas/vlookup.php
Abt macros
macors are simple VB programs which help you manupluate simple excel data Please find more abt it on
http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial.htm

I am not very sure abt pivot table as I have not used it.
Hope this helps
Laxmikant
 
Super, i'm just wondering. Did you post this question in response to the large # of financial positions that require you to know this or for other reasons?

I ask this because I am currently looking for an entry level market/research analyst position and it seems as though they require their candidiates to know this sort of Excel skill to work w/ their financial statements and such.

At the moment I am going through some Excel books to brush up on my skills and i'm not certain if I should just skim through the mumbo jumbo and jump straight into the vLookup and Pivot Tables. But it seems that ppl that has attained these skills hold jobs of 60k+ yearly, or atleast my buddy is.
 
yes that is the exact reason i am asking !! ur right

60 k in toronto ? is your buddy a recent grad ...whats is his prior work exp and where.......does he hold a masters or a bachelor degree ..ie finance or accounting......

well little little things make a difference

well the more one knows about excel the better......i have to improve to
 
He graduated w/ a MIS (Management Information System) of Bachelors degree from a standard California State University in 1998 and started working w/ financial statements and such about 2.5 years ago and now switched to another firm (law consultant firm) that's paying him 70k (80k+) w/ bonus. Ya, it's kinda crazy pay for a few yrs in the industry, but he works hard. He told me Excel is a big part in internal financial statement reporting etc, so i'm working on my skills right now.
 
instead of vlook up, use match and index functions.they work better.
 
This site has a good section on pivot tables:

http://www.datapigtechnologies.com/ExcelMain.htm
 
You must log in or register to reply here.
Back
Top