Web

Resolved · Low Priority · Version 2003

Web

David has attended:
Excel Advanced course

by - delegate David [1 post] (2008 Jun 27 Fri, 16:14) Reply

HOW DO YOU LINK EXCEL TO THE WEB?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: web

by - trainer Pete platinum contributer [799 posts] (2008 Jul 11 Fri, 10:29) Reply

Hi David,
Welcome to the forum, thank you for your question;

Excel worksheets can be saved as HTML with functionality which means the answer to your question is;

Save your Workbook/worksheet as a Web Page = File>Save as Web Page.

Following through the options and choosing as you require will allow you to save your work as an HTML document, which can then be posted to your Intranet, or if you have FTP to the Internet.

I hope that helps, regards Pete

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Basic Excel Training
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Improve Performance Of Your Excel Macros
· Interesting Lifestyle Applications for Microsoft Excel

Please browse our web site to find out more about
microsoft excel courses in and other Microsoft training courses.

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips

Rate this page: