0:00
hello and welcome to dl's point in this
0:02
video I'll show you how to use comments
0:05
and notes effectively in Microsoft Excel
0:08
whether you're collaborating on a
0:09
corporate sales report or you just need
0:11
to add some important reminders to your
0:13
sheets these features are super handy
0:16
for you here we have the sample data set
0:19
and let's take this example we have the
0:21
sales department and for the sales you
0:23
can see we are below Target okay so
0:26
let's say I want to remind myself that
0:29
uh I want to talk with the salespersons
0:31
Regarding why we have not achieved this
0:34
target so here I can right click and set
0:36
a reminder for myself with the help of
0:39
this new note feature so I'll click on
0:41
this new note and as you can see this
0:44
note uh box appears here I can see uh
0:51
salespersons on why we
0:54
didn't achieve the target all right
1:00
so I'll just uh click here and it is
1:03
disappeared now as you can see we have
1:05
this red mark over this cell if I just
1:08
hover my mouse over it you will see I
1:10
will be able to have this note so as you
1:12
can see this can act like a quick note
1:14
or a quick reminder for you uh regarding
1:18
to a particular cell so this is the uh
1:21
note uh feature in Microsoft Excel now
1:24
let's talk about the comments feature
1:26
now let's say you have multiple
1:27
co-workers or employees working on this
1:30
Excel sheet and you are collaborating
1:31
with them and let's say you are talking
1:34
about uh this customer support that has
1:37
exceeded Target I can quickly add a
1:39
comment on it for other co-workers by
1:41
right clicking and then going to new
1:43
comment and here okay it selected the
1:46
wrong cell let me just go here again and
1:49
I was talking about let's say this
1:51
operations we have exceeded the Target
1:53
right click and then new comment and
1:55
here I can simply say yeah time to set
2:00
liate okay if I just click here post
2:04
comment now this acts as a comment if
2:07
there are other co-workers or employees
2:09
who are collaborating with you on this
2:11
sheet they will be able to reply to this
2:14
now this is the major difference between
2:16
a comment and uh between this note now
2:18
this note acts as a reminder for
2:20
yourself only while this comments
2:23
feature can act as a collaboration
2:27
between you and your co-workers also so
2:30
before ending the video you can see we
2:32
can easily just remove these I'll just
2:35
now and if I hover over this we have
2:38
this one note and if we right click go
2:40
to notes and we can easily delete it all
2:43
right similarly for the comments if I
2:45
hover over it we have the comments now a
2:47
coworker can uh reply to it let's say
2:50
let's go and then just send it and this
2:53
will act as a reply to this comment also
2:55
we can remove these comments by right
2:57
clicking and then going to this comment
2:59
and and then simply click on this delete
3:01
comment now one thing to note here is
3:04
that I am using the online version of
3:06
Microsoft 365 which is completely free
3:09
to use for everyone so I will recommend
3:11
you to use uh this online version as
3:15
well that's it for this video I hope you
3:19
now feel confident using these features
3:21
to enhance your Excel work if this video
3:23
was helpful please give it a thumbs up
3:25
subscribe to the channel and share it
3:27
with your friends as well
