6 hours 3 minutes
Okay. Um, what you see here is something that I have created before
and this is a good example Off monthly traveling report that being pleased of a company that are using company car
I have to fill but the end of every month. So this is something that has is pretty much standard form. You have this part here where you enter your mileage. So you have a date. You have a day. You have starting time.
You have the number on your dashboard which shows how many kilometers was on their support when you started Then when you ended it at the end of the day also starting time in the morning and in time in the evening.
And then you have ah, kill me too has traveled.
Ah, and this is pretty fine formula. And then you have ah special column here that in which simply enters how many of those kilometres have been used for private use. For example, typical thing in companies is that when you're traveling the morning to the office
or traveling back from the office home, those kilometres,
this mileage is your private mileage. So you entered there and then the total time of usage is something that you enter.
It's not ending time, minor starting time. It's probably if you have spent on in your car, like two hours or two and 1/2 hours, just enter there.
And then if you have been traveling with the company car and you have paid
purchase gas and paid with the company car, do you have to enter hell, the volume in leaders. If you're in Europe, then how much did you pay?
And if you're throwing from country to country, it can be in different currencies of terrorism.
Comb for currency and so on and so on. And here there is some calculations, so let's go back to the sheet one and let's recreate this report
and we're going to do this by copying the text, and I'm going to show you, in a way, how to do this. So let's say that we just copy this cell here, and then we moved to Sheet one and say, OK, let's put it here
because if you have noticed the comedy was empty, we're just going to put well years. We're not going to put the formal thing
and then let's go here on Dhe selected this cell
and noticing that I'm not selecting all these cells together. And this is why some of these cells emerged. And I'm going to get back to that immediately. So let's go here
now. We didn't want to do that. We wanted to paste just the failures.
And then we go to
sell T womb
here. Well, you as well.
And then we can go again to the sheet final
and because the mileage
we go back here
So here's where we put mileage
and then let's go here every copy fuel
and let's not go to the right anymore.
Just, for example, copy all of these cells because here we don't have any
merging. So we control, see,
and then we click here on repress again values.
now let's do some form of thing, which is useful thing for you to learn.
for example, this
this is something like
this. Let's not write too much fully the colors. Let's say that this was the text was wide.
And then let's look at the side that we're just going to do it like this,
and then it's not going to be this fund, but, uh,
and you see it it goes like this informant, just this cell on and nothing else is visible.
So what we want to do is select all of these cells
and then you have here at the home tab. You have deception emerging center. We don't want to center it. We're going to Toby aligned to the left,
and we click on months traveling report and we get this.
And let's do now the same thing for
the company name.
So let's again changed fund.
And let's say it's white and the background waas
on. Let's make it bigger,
Okay? And now it's still emerge in center
on Dhe. Then let's do the same thing with
this SL. Here
go. Let's say there's let's make it.
Then we select these two cells.
Sorry, and we merged them.
Yeah, this is how it's working.
So we got this
heather off this.
So let's, uh, it's
make this comb smaller because it's here just for the cosmetic purposes. It doesn't obtained anything
and look here,
and the same thing is happening here
let's click here. Double click here. So we moved to this ruler part of the
And we go where the comedy ends. We go here and the way to look for the change in the Pointer and it looks like this. We double click here
and it automatically sets the wit off this column to match the text in it.
And we do it for a while
here, a cz well
and so on and so on. So this is how it looks.
And let's go with former thing of the rest of the
we have this mileage and the fuel as well. So okay, I made a mistake here.
First of all, I made this too small, So let's make them
And then this one was supposed to be dark green.
So something like this
and then this one is also in a different fund,
so but it's not so big in terms. Off
Let's say it's 24
and now it's, uh, the blue and the text is white
and again, we're going to select these cells and we're going to just merge them
here. We're going to do the same thing, so it's going to be merged. Then we're going to click on this cell, we're going to click informant, painter and click on this cell, and we get this and then we just have to change the background
and we get it in orange like it's supposed to be.
And now let's look at what we can't else conduce. So we then
so, like, these cells make this bold,
changed the fund
make it, uh,
like this. Let's see what we did here. No, it should be
a little bit
less dark. So, like this. And then form a painter. Quicken this.
And then, uh,
I was just change.
No, let's not do it like this. Let's select thes cells.
Let's go here
on Dhe again. Change
this. So you see, these things take a little time,
but it's worth the trouble, because now it looks much, much nicer.
change the wit of cons because you have changed the typeface too different typeface, and we headed bald. So it's now
slightly more space. Taking here is well,
so we fix this
now. We can't do this. We have to make it bigger. So
it's like this. So this is pretty much how it looks.
And then we have
areas Richard there to make
the whole ting look more like
a table. So let's click, for example, here
and here is well
And then let's select the cells and then we copy them and then paste them
and then paste them and then lets you like them again all three together
because we are going to waste less dying like this.
just one more, I think.
And that's pretty much it. So let's look here where are ending in 37. So
we have to select just one more
and put it here. So now it looks nice
and it has 31. So you select oldies you Sorry we have to press escape first
and we see like these cells
and yeah, there is 31 of them and
that's what we needed.
let's go. Here s o kilometres traveled
ending kilometers minus starting kilometers. We present there
We go to that cell again. We go here, wait for the pointer to change,
then drag this
and then we just say Phil without formal thing, we want tohave this alternating gray and white
So we get this.
Nothing's changed here,
and what we have here is a calculation. Here is amount in local currency,
which is basically equals
multiplied by exchange rate.
And again we're going to drag this,
but with the right mouse button click like we did before
and then Phil without formal thing.
And here we are. So let's, um let's un's umed this a little so you can see everything
and here in the month.
So what we have here a month way have month report
that this is actually a mistake. So, uh, here we should have
And then here we have a month.
So let's, uh
it's reduced the font size
And then let's, uh, merged these cells.
Let's click here,
copied the former thing
what we have here
here. We have total kilometers,
so we're going to have here
ah, equals some off.
And then this year,
and because we wanted to be slightly bigger, we're going to merge these cells,
and then we're going to change this again to a different formed
and make bold and make it
something like this
a little less and we're going to century vertically,
okay. We forgot to merge it with these cells, but it doesn't matter. This is big enough.
And then what? We have total time on the road.
I just copied this so we don't have to
re type it. So
And then we copied. This is well,
so we have the student when empty. So it goes here
and we have one more. Sorry.
Yeah, money spent
We copy this
and be paced Alia's.
And then we're going to merge these cells
to merge these cells
maybe to select these cells and merge them.
And then we're going to cycle of these cells and merged them well.
And then total time of the road is going to be equal to some
and again. We're going to merge these cells,
and it's going to be equal to
fuel purchased. So some off
and again, we do some merging,
and we had
your formula, which is going to be some off
and this is it. And now we're going to just pick the former thing of this one and copied here. Now we can do that because they're not merged. So
we're going to say that this is
assistant. It's going to be bald. We're going to increase the size.
We're going to center it like this. And now we're going to just
you're going to
Yeah, pretty much weakened. But we can do
is, uh, just make this. So what was
here? It was, like, 11. It was bold.
sorry we can do this on. We can come here
on dhe. Uh,
quick. This way
and so on and so on. So let's not spend more time. Just just copy this foreman to make it look nice
and then changed color.
This one is well
and thes two cells. They're going to be,
And that's it. So we have our
It took us quite a lot of time to create it.
And now we're going to just save as
let's say that we're saying in a year
and here we're going to select
find where is the tape template.
So Excel Template XL, T X.
And we're going to say that this is named
and we're going to save it.
And now, whenever somebody wants to use it, they can just open it,
name of the month here
and entered the will use in it. And when they finish, they save it and it's for the current month.
So this is how the template is created.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered