- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (8)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (17)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (6)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)
Excel | Basic printing exercise | 2007 Printing - MP expenses
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
You can learn how to do this exercise if you attend the course listed below!
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Open the workbook called: MPs formatted for printing from the folder shown above.
In print preview, make the following changes to the print settings:
- Change the margins to:
(These settings should squeeze it onto one page - if not, reduce more!)
- Centre the workbook on the page horizontally
- Add a standard footer giving the current and total number of pages
- Add a custom header with the following details:
Left: Current time is: then the time is automatically printed
Centre: Creative Accounting (in a fancy font)
Right: Confidential (in a huge font!)
Check your new settings on the print preview screen and then print it out (if possible!).
Your workbook should look something like this in print preview:
Something like this is great!
Save the workbook with the new name: MPs with print settings