Please help a desperate ignorant

lady · Apr 15th, 2002, 12:11 PM

This is for a work project. Each one in my section gets a change to give the group training on a topic that the supervisor selected. I have been requested to give training on the following functions in Excel (but I am totally STUPID with this program!!!!). Is there maybe somewhere a free training tutorial available on these topics on the Internet?
1. MS Query
2. XLookup, VLookup, H Lookup
3. Filters/DataBasis
4. Form Buttoms for Excel/Word
5. Macros
6. Hyperlinks
7. Bullets/Numbering
8. Mail Merge

4.

AJ · Apr 15th, 2002, 12:17 PM

Oh My God!
You have been dumped on from a great height haven't you?
Just the macros topic alone you could go on about for years.
Anyway, without wanting to depress you further, here are three websites with useful tips to get you started...

http://j-walk.com/ss/
http://www.thewordexpert.com
http://www.ozgrid.com

lady · Apr 15th, 2002, 12:19 PM

Hi

Thanks for the reply.
I know the basics but it is the more advanced that bothers me.

Al Chara · Apr 15th, 2002, 12:21 PM

Lady,

That is a hell of a task. Take a look at the excel help files and buy a book or two:
http://www.mrexcel.com/book.shtml

Ian Mac · Apr 15th, 2002, 12:28 PM

Quote:

On 2002-04-15 11:11, lady wrote:
This is for a work project. Each one in my section gets a change to give the group training on a topic that the supervisor selected. I have been requested to give training on the following functions in Excel (but I am totally STUPID with this program!!!!). Is there maybe somewhere a free training tutorial available on these topics on the Internet?
1. MS Query
2. XLookup, VLookup, H Lookup
3. Filters/DataBasis
4. Form Buttoms for Excel/Word
5. Macros
6. Hyperlinks
7. Bullets/Numbering
8. Mail Merge

4.

An excellent yet MAJORLY overlooked source of information is the Help files themselves (within Excel/Word) they give very good detailed decriptions of eveerything you've been handed (nay, bombarded).

It won't be all you need so have a look at the sites suggested, they're ALL excellent sources of infomation.

Also use this site to Search for any keywords, a lot of people have given very good reasons behind the formulas/VB they've used.
Check also the user names of people who often post good solid replies, they usually do it for other posts.

Best of luck.

Apr 15th, 2002, 12:21 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Lady, That is a hell of a task. Take a look at the excel help files and buy a book or two: http://www.mrexcel.com/book.shtml __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 12:11 PM	#1
lady New Member Join Date: Apr 2002 Posts: 3	This is for a work project. Each one in my section gets a change to give the group training on a topic that the supervisor selected. I have been requested to give training on the following functions in Excel (but I am totally STUPID with this program!!!!). Is there maybe somewhere a free training tutorial available on these topics on the Internet? 1. MS Query 2. XLookup, VLookup, H Lookup 3. Filters/DataBasis 4. Form Buttoms for Excel/Word 5. Macros 6. Hyperlinks 7. Bullets/Numbering 8. Mail Merge 4.

Apr 15th, 2002, 12:17 PM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Oh My God! You have been dumped on from a great height haven't you? Just the macros topic alone you could go on about for years. Anyway, without wanting to depress you further, here are three websites with useful tips to get you started... http://j-walk.com/ss/ http://www.thewordexpert.com http://www.ozgrid.com

Apr 15th, 2002, 12:19 PM	#3
lady New Member Join Date: Apr 2002 Posts: 3	Hi Thanks for the reply. I know the basics but it is the more advanced that bothers me.