Practice Video: Format Painter

Loading...

Do curso por Macquarie University

Excel Skills for Business: Essentials

3026 classificações

Explore Related Videos

At Coursera, you will find the best lectures in the world. Here are some of our personalized recommendations for you

Macquarie University

Excel Skills for Business: Essentials

3026 classificações

Curso 1 de 4 em 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.

Na lição

Formatting

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.

Practice Video: Formatting3:40

Practice Video: Borders3:54

Practice Video: Alignment Tools4:00

Practice Video: Format Painter3:35

Practice Video: Number Formats5:31

Practice Video: Styles and Themes5:05

Week 3 Wrap-up1:21

Conheça os instrutores

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

In the last few practice videos,

we've had a look at some useful tools for adding formatting to our workbooks.

The next tool we're going to look at is really exciting.

It allows us to very quickly copy formats from one cell to another,

and you just call the Format Painter.

The format painter is located in the Clipboard group on the home tab of the ribbon.

Let's have a look at how it works.

So, I've decided that my account managers could stand out a little bit more.

I'm going to click on Aanya and make that bold and italics and a dark shade of blue.

I'm very happy with that,

but now I need my other account managers to look the same.

So, rather than doing those three steps manually,

I'm going to make sure that I've clicked on

the cell that has the formatting I want to copy.

I'm going to come up to my Format Painter and click on it, and then,

I'm going to click and drag to paste the formats onto the other cells.

That both guarantees consistency and it's much quicker,

but wait, there's more.

The format painter can also be used to copy multiple formats simultaneously.

So, let's, for example,

say I want to get rid of these borders.

So, I'm going to click No Borders,

and instead what I want is banded rows,

that means alternating colored rows.

I've selected my second row,

and I'm going to make it a pale gray.

Now, I want to copy that formatting down to the rest of my data.

So, I select both rows,

come up to my Format Painter,

and then drag it on to the rest of the data.

No more borders, lovely banded rows.

You can do this on an even larger scale as well.

So, having a look at my sales 2015,

no formatting at all.

I want the sheets to look exactly like 2016.

So, I'm going to come back to sales 2016,

and select all my cells,

then I'm going to click on format painter,

come to sales 2015,

and just single click top left-hand corner, all formatted.

So, really powerful tool for speeding up copying of formats.

Now, what about if we wanted to remove these formats quickly?

Again, coming to each cell and changing it back to

not be bold and not be blue would be very slow.

So, the other option we have is the option to clear our formats.

The clear tool is located on the right-hand side of the ribbon.

If I were to choose clear all,

that will actually remove the contents of the cell as well.

So, we're just going to focus on the clear formats.

Again, start by selecting the cells that you want to clear the formatting from,

come up to your clear,

and click clear formats.

So, a very quick way of getting rid of formatting that you don't want.

So, we've looked at two tools,

the Format Painter which allows us to copy formatting,

and the Clear Formats which allows us to remove formatting.

Don't forget to practice it,

and make it part of your everyday use of Excel.

Explore nosso catálogo

Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.

O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.

© 2019 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play