[AI] Excel tutorials required urgently.

Geetha Shamanna geetha at millernorbert.de
Fri Feb 29 11:45:40 EST 2008


Hi Sudhir,

NAB Delhi has an Excel tutorial on its Web site. You may want to check it 
out.

Geetha
----- Original Message ----- 
From: "Sudhir R (NeSTIT)" <sudhir.r at nestgroup.net>
To: <accessindia at accessindia.org.in>
Sent: Friday, February 29, 2008 12:35 PM
Subject: [AI] Excel tutorials required urgently.


> Friends,
>
> I need tutorials on the following topics rather urgently.
>
>
>
> 1)      Creating Databases based on usage
>
> a.       Structure - Process of building a database, identifying fields 
> etc.,
>
> b.      Formatting
>
> c.       Data Types
>
>
>
> 2)      Common Functions
>
> a.       IF
>
> b.      Sum / Sumif
>
> c.       SumProduct
>
> d.      Count / Countif
>
> e.      Average
>
> f.        Min - Median - Max
>
> g.       Time and date addition and subtraction (ESOP Vesting, experience 
> computing, age etc)
>
> h.      Paste Special etc.,
>
> i.         Usage of filters
>
> Etc.,
>
>
>
> 3)      Advanced Functions
>
> a.       Lookups (V & H)
>
> b.      Nested IF
>
> c.       PMT
>
> d.      Range manipulation
>
> e.      Array Manipulation
>
> f.        Multiple formula  etc.,
>
> g.       Mailmerge
>
> h.      Data validation
>
>
>
> 4)      Graphs; Charts; Pivots
>
>
>
>
>
> Highly obbliged if you could send whatever you have to my mail id, 
> sudhir.r at nestgroup.net.
>
>
>
> Thanks and rgds
>
>
>
> RS
>
> M: 98 472 76 126
>
> To unsubscribe send a message to accessindia-request at accessindia.org.in 
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes, 
> please visit the list home page at
>  http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
> 





More information about the AccessIndia mailing list