PDA

View Full Version : Introduction to EXCEL Major Functions and Operations



punchi
2009-01-17, 09:11 AM
Introduction to EXCEL Major Functions and Operations(MACRO)

cococrunch
2009-01-17, 11:13 AM
Hi punchi, do you have this file in other links like public share. I cant seem to download attachments here. Thanks!

punchi
2009-01-17, 11:17 AM
http://rapidshare.com/files/184640065/Introduction_to_EXCEL_Major_Functions_and_Operations-20031030-B-1.0.rar

don forget me:D

gsmmangi
2009-01-17, 12:33 PM
Introduction to EXCEL Major Functions and Operations(MACRO)


Thanks man for the share will try it out share my view on it

:)

simmus0300
2009-01-17, 01:54 PM
http://rapidshare.com/files/184640065/Introduction_to_EXCEL_Major_Functions_and_Operations-20031030-B-1.0.rar

don forget me:D
kindly explain the funcions ans macro with examples

da_manole
2009-01-17, 04:15 PM
http://www.filefactory.com/file/700af4/n/F1_20-_20Get_20The_20Most_20Out_20Of_20Excel_20Formulas_20and_20Functions_rar

basith.aces
2009-01-17, 04:21 PM
Thanxs for sharing.

da_manole
2009-01-17, 04:30 PM
http://rapidshare.com/files/7460542/E2003F.rar
pass: tFE2003F.rar
examples can be found http://www.j-and-r-williams.com/ExcelStuff/Excel 2003 Formulas

simmus0300
2009-01-17, 04:39 PM
http://rapidshare.com/files/7460542/E2003F.rar
pass: tFE2003F.rar
examples can be found http://www.j-and-r-williams.com/ExcelStuff/Excel 2003 Formulas
the link www.j-and-r-williams.com/ExcelStuff/Excel[/u is not working

proy1_10
2009-01-17, 04:47 PM
Anyone have e-books or tutorials about Microsoft Access?

simmus0300
2009-01-17, 04:56 PM
the link www.j-and-r-williams.com/ExcelStuff/Excel[/u is not working

pl give examples of macro,function used in daily life/service

simmus0300
2009-01-17, 04:58 PM
Introduction to EXCEL Major Functions and Operations(MACRO)

Anyone have e-books or tutorials about Microsoft word with examples.

justdream
2009-01-17, 05:12 PM
Please I need something like that for MS Access

justdream
2009-01-17, 07:07 PM
Friends, help me to use vlookup
Suppose that I have the attached table which contains:

1) Long and lat merged together
2) Signal strength
3) Long and lat after removing some points
4) In the 4th column I want to get the signal strength of the long and lat points of the 3rd column

So what will be the function formula !!!!!!!!!!!

da_manole
2009-01-18, 03:14 AM
check if this is what you need.
you should copy the signal stren..in the right regarding long _lat and You should take care that long_lat to be unique else you will have just the first signal stregth from the list(you can check this :first you can order ascending (make a copy in other page)and after that find the duplicates with other formulas)

da_manole
2009-01-18, 03:26 AM
http://rapidshare.com/files/165404184/ebook.Access_X_Bible_Bible_Wiley.0764539868.zip

example used in the book
http://media.wiley.com/product_ancillary/68/07645398/DOWNLOAD/Access%20Auto%20Auctions.rar

da_manole
2009-01-18, 04:46 PM
the link www.j-and-r-williams.com/ExcelStuff/Excel[/u is not working
you should use all words
http://www.j-and-r-williams.com/ExcelStuff/Excel 2003 Formulas

da_manole
2009-01-18, 05:32 PM
the link www.j-and-r-williams.com/ExcelStuff/Excel[/u is not working

The complete link is
http://www.j-and-r-williams.com/ExcelStuff/Excel%202003%20Formulas/
may be the site had some problem (but it's working ..I can put in other place..)

justdream
2009-01-28, 07:11 PM
Sorry Da_Manole,

I wasn't test your vlookup solution as I was too busy,
when i tested it today, it doesn't give me what I need

could you see the attached and help...thanks

cococrunch
2009-01-29, 11:11 AM
Hi excel experts,

Im having some problem with site neighbour database in excel. The thing is how to transpose list of neighbors arranged from rows into columns and vice-versa, do we have to use macro for this?.. This is also useful for actix database. Thanks! :)

cococrunch
2009-01-29, 11:21 AM
Here is a sample. Ive already made the first row, please help.. thanks!

gsmmangi
2009-01-29, 01:33 PM
Why don't you try www.btebook.com (http://www.btebook.com) it has a very good collection of ebooks on various topics and also lots of stuff relating micrsoft application.






Anyone have e-books or tutorials about Microsoft Access?

justdream
2009-02-03, 05:51 PM
In General, regarding transpose column to row

you could use the following:

highlight your colum then go to insert/ pivot table
then check the box (right to your column name) and drag it to the column label field as shown

'I hope this help'

ako655
2009-02-04, 02:58 AM
Thank you for this...

da_manole
2009-02-15, 09:18 PM
Sorry Da_Manole,

I wasn't test your vlookup solution as I was too busy,
when i tested it today, it doesn't give me what I need

could you see the attached and help...thanks

hope will be more clear

justdream
2009-02-15, 09:45 PM
I appreciate you gave me of your time to explain, thanks a lot :hug:

FUNMOBILE
2009-02-15, 11:21 PM
Thanks for excel function doc.

Funmobile

da_manole
2009-02-16, 02:12 AM
I appreciate you gave me of your time to explain, thanks a lot :hug:

it's ok with this last example?

justdream
2009-02-16, 02:28 AM
Yes, Da Manole.......Done ;)