Practice Video: Orientation, Margins and Scale

Loading...

En provenance du cours de Macquarie University

Excel Skills for Business: Essentials

1086 notes

Macquarie University

Excel Skills for Business: Essentials

1086 notes

Cours 1 sur 4 dans Specialization Excel Skills for Business

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come. Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

À partir de la leçon

Printing

Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.

Practice Video: Print Preview4:16

Practice Video: Orientation, Margins and Scale4:50

Practice Video: Page Breaks5:24

Practice Video: Print Titles4:16

Practice Video: Headers and Footers4:37

Week 5 Wrap-up1:19

Rencontrer les enseignants

Dr Yvonne Breyer
Director, Learning and Teaching
Faculty of Business and Economics

In the last video we looked at working with Print Preview, however,

we only really want to use print preview right towards the end when we're ready to print.

And a lot of our data,

if it's a larger set is not going to fit easily on the page.

So very often we need to make some adjustments even before we go into print preview.

And there are two things that can help us.

The first is the Page Layout view.

You may remember this from week one.

If you come down to your status bar,

there are three view buttons.

We're on normal at the moment,

but the next one is Page Layout.

And when I click, you can actually see how our data is going to sit on the page,

but we can also edit the data in this view.

So it's a lot more efficient.

The other recommendation is to come up to the Page Layout tab.

This gives us a lot of options for setting up our page.

Now looking at this data,

first thing we probably want to do is change the orientation.

So I'm going to click Orientation and choose Landscape.

Already that's made a huge difference.

It's just not quite fitting,

but before we start trying to squish all of our columns,

a very quick and easy option is margins.

By default the margins are set to normal,

which are quite generous.

I'm going to change it to narrow.

And that has already fixed the problem.

Now I'd probably be happy with that,

but those people quite perfectionist might not like the fact

the margins are quite narrow on this side and little wider on the other.

So here's has a well hidden little option.

Back up to margins,

and come down to custom margins,

and here you can set your margins to any width you like,

but the option I really like is the option to center on page.

We're going to center it horizontally,

and then say OK,

and that's looking great.

Let's now look at a slightly bigger worksheet.

So I'm going to click into Orders.

And this is quite big,

so we foresee some problems.

Let's come back to our Page Layout view and click.

Now, even before I scroll around,

just having a little peek on my status bar on the left hand side,

you'll see Page 1 of 100.

I'm sure we can bring that number down a little bit, so once again,

let's come on to our Page Layout view and let's change our orientation to landscape,

and let's change our margins to narrow.

Well, it's looking a bit better,

but if I scroll to the right you can see,

still kind of spilling onto three pages and not looking great.

Now I'm never going to be able to fit all the data

onto one page wide and still be able to read it.

But I think I could probably get it to two pages wide,

and there's a great tool to help us with this.

It's called the Scale to Fit.

And in the Scale to Fit,

you can adjust either your height or your width or just manually change your scale.

I'm going to come up to Width,

click the drop down,

and change it to two pages wide.

Now if I scroll to the right- and that's already looking better- there

we go- the whole spreadsheet sitting nicely on two pages.

If I check the bottom here, page 1 of 50.

We've actually halved our paper usage.

One thing though that you should also check is what percentage you scaled it down to.

Anything down to about 75 is probably fine.

If it's down to 23, no one's going to be

able to read it so you might need to still change.

At the moment you'll also notice my scale is grayed out.

That is because I've set it to always fit to two pages

wide even if I go and add another 25 columns.

So do be a little careful leaving it like this.

What I would suggest is come back and flip this back to Automatic.

Now it hasn't adjusted my scale it's left at 79,

but if I need to manually adjust it, I can.

And if I need to add more columns,

they will spill onto the other sheets.

So there you have some of the most useful print options,

and of course, our Page Layout view.

In the next video,

we'll look at how to work with page breaks.

Don't forget to practice these skills yourself.

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2018 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play