Lernen>
Wirtschaft>
Grundlagen der Unternehmensführung>
Excel Skills for Business: Essentials-Kurs>
Practice Video: Alignment Tools

Loading...

Practice Video: Alignment Tools

Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.

Excel Skills for Business: Essentials

Macquarie University

Kurs 1 von 4 in Excel Skills for Business Spezialisierung

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.

Lehrplan anzeigen

Skills You'll Learn

Graphs, Microsoft Excel, Chart, Sorting

Unterrichtet von

Dr Yvonne Breyer
Program Director, Design and Experience, Global MBA

Skript

The next set of formatting tools we're going to look at,

are called the alignment tools.

They can be found in the home tab of the ribbon,

just to the right of the font group.

Alignment, basically means to change the positioning of your data within a cell.

So, for example, if I select all of my data over here,

at the moment, some of it's left-aligned,

some of its right-aligned.

If I click center align,

you can see it's now all center-aligned.

Right-aligned, it'll shifts over to the right,

and that looks okay for most of it,

but what I'm going to do now is just select

my account managers and make them left-aligned.

The alignment tools we've had a look at so far,

refer to all horizontal alignment.

But in Excel, you can also change your vertical-alignment.

In other words, if things sit at the top,

bottom or center of the cell.

So, I'm going to click on my main heading here,

and I'm going to click on center align vertically.

You'll see I can also vertically align to the top.

Let's go for the center because that looks really nice with our headings.

Now, one of the problems you find in this worksheet and indeed a lot of worksheets,

is sometimes the data doesn't fit properly into the cell.

Now, there are lots of ways you can solve this problem.

Sometimes making the column wide is the best option but in this case,

I really don't want to.

So, the other option available to me,

is to use something called wrap text.

So, I'm going to select all my headings,

come up and click on wrap text,

and what that has done, is to wrap the text around in the cell where it doesn't fit.

So, it makes it more readable.

Then, if I center align that vertically and horizontally,

my headings are now looking a lot better.

Just under the wrap text tool is something called merge and center.

This is a really cool tool for making

your headings sit nicely in the middle of your workbook.

So, I've got this big heading here,

but even if I were to try and put it in cell E and center align it,

it's still not going to be perfectly in the middle.

So, the alternative is to

select all the cells that I would like it to be in the middle of,

and then merge them into one big cell and center the text.

So, I do that using merge and center, and there you go.

It looks really cool.

A slight word of caution with this though,

make sure you only have text in one of the cells or otherwise you could lose data.

Also reserve this tool for headings,

don't try use this inside

your data areas because later on when you try and sort and filter,

you'll run into problems.

Right. One last little thing to look at in the alignment section,

and that's the orientation tool.

Coming back to the idea of having

very wide headings but not wanting to have very wide columns,

you can change their orientation.

So, I'm gonna select my headings here,

I'm going to turn off wrap text for a moment,

and then I'm going to come to my orientation and

I'm going to choose angle counterclockwise.

What it's done is actually angle the heading so it can fit the main beautifully,

without making the columns wider.

If you don't want them hanging off of the edge,

another option is to rotate text up.

There are few other options that you can have a look at.

Some of them, quite good fun.

Now, I'm going to put this back though to how it was before,

because I think with this dataset that probably is our best option.

When you play around,

see what you like best.

Über Coursera

Courses, Specializations, and Online Degrees taught by top instructors from the world's best universities and educational institutions.

Join a community of 40 million learners from around the world

Earn a skill-based course certificate to apply your knowledge

Gain confidence in your skills and further your career

Coursera arbeitet mit erstklassigen Universitäten und Organisationen zusammen, um Online-Kurse anzubieten und dadurch universellen Zugriff auf die weltweit beste Ausbildung zu ermöglichen.

© 2019 Coursera Inc. Alle Rechte vorbehalten.

Aus dem App Store herunterladen

Erhältlich bei Google Play