Practice Video: Orientation, Margins and Scale

Loading...

En provenance du cours de Macquarie University

Excel Skills for Business: Essentials

3574 notes

Macquarie University

Excel Skills for Business: Essentials

3574 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
Program Director, Design and Experience, Global MBA
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.

A lot about 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.

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 a status bar,

there are three view buttons.

We're on normal at the moment,

but the next one is page layout.

When I click, you can actually see how update 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 crop 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,

a little wider on the other.

So, here's a well-hidden little option,

backup 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,

and we're going to center it horizontally and then say "Okay".

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 will see some problems.

Let's come back to our page layout view and click.

Now, even before I scroll around,

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

you'll see page one of a 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 it's 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 can 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.

In the scale to fit,

you can adjust either your height or your width,

or just manually change the scale.

I'm going to come up to width.

Click the dropdown 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 one of 50 would actually halved our paper usage.

One thing though that you should also check is what percentage you've 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 will also know might 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'd 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 adjusted it I can,

and if I need to add more columns they will spill onto the other sheets.

So, they have some of the most useful print options and of course,

a 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.

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

Télécharger dans l'App Store

Disponible sur Google Play