Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Macros- Will still need more training

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training - Macros- Will still need more training

Resolved · Low Priority · Version Standard

Reply Wed 12 Dec 2007, 16:40Delegate Daniel said...

Daniel has attended:
Excel Advanced course

Macros- Will still need more training

Will post question later

For upcoming training course dates see: Pricing & availability

Reply Mon 17 Dec 2007, 11:01Trainer Rajeev said...

RE: Macros- Will still need more training

Dear Daniel

Thank you for attending the Excel Advanced training!

The best course for you to follow on from what you have learnt in Excel Advanced in terms of Macros will be VBA course where you start of from creating a basic macro and then to see how you can customize it and make it work for you!

If you have any questions with related to Macros from what we did in the training please don

Excel articles

· Importing Excel Data Into Access
· A Brief Glimpse At Excel's What If Analyses Tools
· How To Create A Custom List In Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Differences In Excel 2003, 2007 And 2010

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips