Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
advanced excel seminar training - supply chain accountant

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Supply Chain Accountant

advanced excel seminar training - Supply Chain Accountant

ResolvedVersion Standard

Dushyant has attended:
Excel Intermediate course

Supply Chain Accountant

Need assistance printing. Printing to fit a page.

Thank you

RE: Supply Chain Accountant

To fit printing to a single page, there is an option in the page setup menu.
Depending what program you are using, the options may be slightly different. I will assume that you are using Excel for this example.

Select FILE, then PAGE SETUP.
Look at the SCALING options

There are two choices:

- Adjust to a %
- Fit to page.

The easiest way of forcing all your printing onto one page is to select the FIT TO PAGE option, and then specifying how many pages you want to print on.

EG:
1 Page Wide by 1 Page Tall = 1 page only
1 Page Wide by 2 Page Tall = 2 pages one underneath the other
2 Page Wide by 1 Page Tall = 2 pages one next tp the other

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.