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 ;)
vBulletin® v4.2.5, Copyright ©2000-2024, Jelsoft Enterprises Ltd.