I'm going to show you how to create a daily planner in Excel with with the
combination of the group function and the table function so here we have the
week of September 4th and the days are listed here now if you wanted to look at
your week you all together see what your week look like you would click on two
and that would display each of your days and the tasks for each of your days now
if you want to just look at the dates again you click on one and you would
have the dates back now to find out what the September 5th is you know you know
that you have a meeting on September 5th so you can just select one day by
clicking the box below then it but that I low the date now the other thing too
is these are tables so you can either do you can either search by so we're gonna
select all and then we know we have a meeting with the customer so you say ok
and then it shows you the the time of the day that is allotted to you meeting
with your customer or the other the other function you can use with the
tables here is that you could say so what am i what am i doing at let's say
10 o'clock and you can look at that and 10 o'clock is open you could schedule
something else for that time so how we're gonna do it is let's a calendar
from the 11th to starting on the September 11th so let's start on a new
on a new sheet here so the first thing that we're gonna do what we're gonna do
is type in the date you're going to decide how you want it to be formatted
so what I'm gonna do is I'm gonna right click on that magnet group select format
cells I like it to be grouped like this until and the other thing is I'd like to
be a little bigger than this so on the Home tab I'm going to select and that's
let's make it 16 yeah but below there what we're going to do is we're going to
select we're going to type in time and then we're going to make this wider so
you can put a few things in here so let's take it tap ok so now let's say
our day starts at 8 o'clock and you want our scheduling done by every half-hour
so what I'm going to do is I'm going to select the 8 and the 8:30 and I'm going
to drive drive it down to 2 5 o'clock which is 1700 hours and now what I'm
going to do is I am going to select this all the way down to the end of this the
end of the tasks here and I'm going to go insert on the menu bar and I'm going
to go insert table and it's a Jetta it's telling you which one's it's going to do
and you say okay so there's your table for you now to get it grouped what
you're going to do is you're going to select from the beginning of the table
to the end of the table and you're going to go to the data tab and you're gonna
go group ok perfect so then just to create the rest of the days of the week
what you need to do is you need to just um you need to copy from the 11th all
the way down to the end of your table and you're going to go ctrl C and then
you're going to go one one line below and you're gonna go ctrl V now you just
have to change this to 12
and there you have it you've got your your your schedule started here so we
can click 1 and we're left with the 11th and the 12th and click 2 and then we
have our days expanded for you so that's how that's how you create a task a daily
task planner with the combination of the table and the grouping function in Excel
please subscribe