Friends: Please guide me

Dear Friends,

I need a small information. Recently, I appeared for Financail Executive
post in a leading private bank. And, in that interview, I am asked to rate my
skills with regard to Excel. I rated myself as "Accurate". Later, the
interviewer asked me, "r u familiar with the advanced topics of EXCEL or will
be using EXCEL just by and for punching figures and doing calculations. Now,
what I want to know from u is that What does he mean by "Advanced Topics"?

Please reply. I would be grateful to the guys who respond to this query.

Thanks a lot.


Prasad Rao Seera

It's hard to say, exactly, what he meant by "advanced topics", but I would
say the following are typically considered to be the more 'advanced' features
of Excel:

Using Macros (VBA)
Creating and Editing Macros
User Defined Functions (UDF)
Workbook Security
Consolidation, Web, Integration, XML Features
Customizing Excel
Syncronizing the use of databases, importing data

Hope that helps.

--
Regards,
Dave


"PRASAD RAO SEERA" wrote:

> Dear Friends,
>
> I need a small information. Recently, I appeared for Financail Executive
> post in a leading private bank. And, in that interview, I am asked to rate my
> skills with regard to Excel. I rated myself as "Accurate". Later, the
> interviewer asked me, "r u familiar with the advanced topics of EXCEL or will
> be using EXCEL just by and for punching figures and doing calculations. Now,
> what I want to know from u is that What does he mean by "Advanced Topics"?
>
> Please reply. I would be grateful to the guys who respond to this query.
>
> Thanks a lot.
>
>
> Prasad Rao Seera

A guess, but I would suggest he means things like

- pivot tables
- charts
- data validation
- Goal seek
- scenarios
- subtotals
- filtering

and maybe some more

--
HTH

Bob Phillips

"PRASAD RAO SEERA" <PRASAD RAO [email protected]> wrote in
message news:[email protected]...
> Dear Friends,
>
> I need a small information. Recently, I appeared for Financail Executive
> post in a leading private bank. And, in that interview, I am asked to rate
my
> skills with regard to Excel. I rated myself as "Accurate". Later, the
> interviewer asked me, "r u familiar with the advanced topics of EXCEL or
will
> be using EXCEL just by and for punching figures and doing calculations.
Now,
> what I want to know from u is that What does he mean by "Advanced Topics"?
>
> Please reply. I would be grateful to the guys who respond to this query.
>
> Thanks a lot.
>
>
> Prasad Rao Seera

Those would have been my guess too. Throw in Solver and IF / VLOOKUP /
SUMPRODUCT type formulas as well and you have a pretty fair list I think.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>A guess, but I would suggest he means things like
>
> - pivot tables
> - charts
> - data validation
> - Goal seek
> - scenarios
> - subtotals
> - filtering
>
> and maybe some more
>
> --
> HTH
>
> Bob Phillips
>
> "PRASAD RAO SEERA" <PRASAD RAO [email protected]> wrote in
> message news:[email protected]...
>> Dear Friends,
>>
>> I need a small information. Recently, I appeared for Financail Executive
>> post in a leading private bank. And, in that interview, I am asked to
>> rate
> my
>> skills with regard to Excel. I rated myself as "Accurate". Later, the
>> interviewer asked me, "r u familiar with the advanced topics of EXCEL or
> will
>> be using EXCEL just by and for punching figures and doing calculations.
> Now,
>> what I want to know from u is that What does he mean by "Advanced
>> Topics"?
>>
>> Please reply. I would be grateful to the guys who respond to this query.
>>
>> Thanks a lot.
>>
>>
>> Prasad Rao Seera
>
>

IF? LOL!

I doubt that most users would see SUMPRODUCT as an advanced technique Ken,
they probably don't see it as you do.

Bob

"Ken Wright" <[email protected]> wrote in message
news:evqD%[email protected]...
> Those would have been my guess too. Throw in Solver and IF / VLOOKUP /
> SUMPRODUCT type formulas as well and you have a pretty fair list I think.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------*------------------------------*------------
----
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------*------------------------------*------------
----
>
>
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >A guess, but I would suggest he means things like
> >
> > - pivot tables
> > - charts
> > - data validation
> > - Goal seek
> > - scenarios
> > - subtotals
> > - filtering
> >
> > and maybe some more
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "PRASAD RAO SEERA" <PRASAD RAO [email protected]> wrote in
> > message news:[email protected]...
> >> Dear Friends,
> >>
> >> I need a small information. Recently, I appeared for Financail
Executive
> >> post in a leading private bank. And, in that interview, I am asked to
> >> rate
> > my
> >> skills with regard to Excel. I rated myself as "Accurate". Later, the
> >> interviewer asked me, "r u familiar with the advanced topics of EXCEL
or
> > will
> >> be using EXCEL just by and for punching figures and doing calculations.
> > Now,
> >> what I want to know from u is that What does he mean by "Advanced
> >> Topics"?
> >>
> >> Please reply. I would be grateful to the guys who respond to this
query.
> >>
> >> Thanks a lot.
> >>
> >>
> >> Prasad Rao Seera
> >
> >
>
>

LOL - Tickles me sometimes what i've seen people consider as 'Advanced'.

I remember helping someone at work on a spreadsheet once who had asked for a
bit of help with formatting. I accidentally deleted a number, and happened
to notice that the totals didn't change. Yep you guessed it, he had used a
calculator to sum all the values and then put the total in. I showed him
Autosum and he thought that was amazing.

Ditto one of the girls at work, who had values in say A1:D20, and then in
row 21 had

=A1+A2+A3+A4+A5+A6..........

She then started again on the next column, and did them all manually. When
i showed here Autosum she was amazed, but when i showed her how copy and
paste was relative, she was stunned.

Then the other day I'm trying to play a game that my daughter had on the PC
and I failed miserably to understand how it worked. Then my 5 year sold son
came in and showed me how to do it, and he was good!!! I give up <g>

Regards
Ken.................

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> IF? LOL!
>
> I doubt that most users would see SUMPRODUCT as an advanced technique Ken,
> they probably don't see it as you do.
>
> Bob
>
> "Ken Wright" <[email protected]> wrote in message
> news:evqD%[email protected]...
>> Those would have been my guess too. Throw in Solver and IF / VLOOKUP /
>> SUMPRODUCT type formulas as well and you have a pretty fair list I think.
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*------------
> ----
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*------------
> ----
>>
>>
>>
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:[email protected]...
>> >A guess, but I would suggest he means things like
>> >
>> > - pivot tables
>> > - charts
>> > - data validation
>> > - Goal seek
>> > - scenarios
>> > - subtotals
>> > - filtering
>> >
>> > and maybe some more
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > "PRASAD RAO SEERA" <PRASAD RAO [email protected]> wrote
>> > in
>> > message news:[email protected]...
>> >> Dear Friends,
>> >>
>> >> I need a small information. Recently, I appeared for Financail
> Executive
>> >> post in a leading private bank. And, in that interview, I am asked to
>> >> rate
>> > my
>> >> skills with regard to Excel. I rated myself as "Accurate". Later, the
>> >> interviewer asked me, "r u familiar with the advanced topics of EXCEL
> or
>> > will
>> >> be using EXCEL just by and for punching figures and doing
>> >> calculations.
>> > Now,
>> >> what I want to know from u is that What does he mean by "Advanced
>> >> Topics"?
>> >>
>> >> Please reply. I would be grateful to the guys who respond to this
> query.
>> >>
>> >> Thanks a lot.
>> >>
>> >>
>> >> Prasad Rao Seera
>> >
>> >
>>
>>
>
>

"Ken Wright" <[email protected]> wrote in message
news:[email protected]...

> Then the other day I'm trying to play a game that my daughter had on the
PC
> and I failed miserably to understand how it worked. Then my 5 year sold
son
> came in and showed me how to do it, and he was good!!! I give up <g>

What amazes me about kids these days is that they never seem to need to read
the manuals, and specifically refuse to. I see the death of RTFM!

Response would be "What's one of those then?" :-)

Ken................

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
>
> "Ken Wright" <[email protected]> wrote in message
> news:[email protected]...
>
>> Then the other day I'm trying to play a game that my daughter had on the
> PC
>> and I failed miserably to understand how it worked. Then my 5 year sold
> son
>> came in and showed me how to do it, and he was good!!! I give up <g>
>
> What amazes me about kids these days is that they never seem to need to
> read
> the manuals, and specifically refuse to. I see the death of RTFM!
>
>