Practice Video: Format Painter

Loading...

Do curso por Macquarie University

Excel Skills for Business: Essentials

1426 classificações

Macquarie University

Excel Skills for Business: Essentials

1426 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 have 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 it is called the format painter.

The format page is located in the clipboard

group on the home tab of the ribbon.

Let's have a look at how it works.

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

I am gong to click on Aanya and make that bold and italics.

And then 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.

And 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 sheet to look exactly like 2016, so I'm going to come back to Sales

2016, 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 and if I were

to choose Clear All that would actually remove the contents of the cell as well.

So we are 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 Format which allows us to remove formatting.

Don't forget to practice it and make it part of your everyday use of Excel.

[SOUND]

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.

© 2018 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play