ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

MS Excel Functions - VVI (wht else u need ...)

CA CS CIMA Prakash Somani (Landmark Group) (23477 Points)

10 July 2009  

This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other common spreadsheet programs.

  1. Spreadsheet Formulas
  2. Excel 2003 Functions
  3. Excel Logical Functions
  4. Excel's Math Functions
  5. Excel Count Functions
  6. Excel Text Functions
  1. Excel's Date Functions
  2. Excel Statistical Functions
  3. Excel's Trig Functions
  4. Lookup and Reference Functions
  5. Excel's Financial Functions

Spreadsheet Formulas

Formulas are one of the most useful features of spreadsheets like Excel. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections.

Excel 2003 Functions

Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel 2003.

Excel Logical Functions

Excel Logical Functions can be used to introduce decision making into your spreadsheet.

Excel's Math Functions

Excel's Math Functions can be used to perform common mathematical operations such as addition (SUM function), multiplication (product function), and rounding numbers (ROUND function).

Excel Count Functions

Excel Count Functions allow you to count up the number of cells being used for a specific purpose such as the number of cells containing number values or the number of blank cells in a data range.

Excel Text Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

Excel's Date Functions

Excel's Date Functions can be used to add such things as the current date, the current time, or the day of the week to a spreadsheet.

Excel Statistical Functions

Excel Statistical Functions can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you have, the average value of your data.

Excel's Trig Functions

Excel's list of functions includes the common Trig functions that can be used to find the sine, cosine, and tangent of an angle.

Lookup and Reference Functions

Excel's Lookup Functions can be used to simplify finding specific entries in a data table.

Excel's Financial Functions

Excel's Financial Functions can be used to help you determine changes in dollar value of investments and loans.


 11 Replies

BALU.... (CCI STUDENT....) (44614 Points)
Replied 10 July 2009

great work prakash will wait for like this more from you..thanks for sharing.....


(Guest)

good work prakash Thanks

Mack... (N/A.) (175 Points)
Replied 10 July 2009

You are an excel whiz-kid, Prakash...thanks for these links

Abhishek Kaushik (service) (43 Points)
Replied 10 July 2009

hi  prakash

as always, great efforts indeed !! thanks for sharing....

 

 

 

CMA Ankur Pandey (Govt.Job) (4401 Points)
Replied 10 July 2009

thanks for sharing

CA CS CIMA Prakash Somani (Landmark Group) (23477 Points)
Replied 10 July 2009

:-)

1 Like

(Guest)

thanks yaar

S abdulmazeed (Student) (58 Points)
Replied 17 September 2009

Thanks for the sharing of excel files & God bless u!

monika gupta (student) (786 Points)
Replied 17 September 2009

Good work prakash ji,

Thanks for sharing.

 

CA CS CIMA Prakash Somani (Landmark Group) (23477 Points)
Replied 27 September 2012

thnx all

CS Ankur Srivastava (Company Secretary & Compliance Officer)   (17821 Points)
Replied 27 September 2012

Exemplary Sharing.. thanks a lott...


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  





Subscribe to the latest topics :
Search Forum:

Trending Tags