advanced.excel

advanced.excel - Excel

Resolved · Low Priority · Version Standard

Excel

Iris has attended:
Excel Introduction course

by - delegate Iris [1 post] (2007 Sep 5 Wed, 09:57) Reply

How do I add extra sheets to a workbook

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Pete platinum contributer [801 posts] (2007 Sep 5 Wed, 13:10) Reply

Hi Iris, Thanks for the post, to add extra worksheets you would choose the Insert Menu and click on Insert Worksheet, or alternatively you could right click on a worksheet to the right of where you wish to insert a new worksheet and choose the Insert option from the Insert dialog box choose worksheet. Hope that helps.

· Identifying Suitable Candidates For VBA For Excel Training
· Prepare for your MOS Certification with MS Excel Courses
· Training Budgets In A Bad Economy
· VBA Excel 2007
· Database Tips from an Excel Training Course

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Rate this page: