1
00:00:02,200 --> 00:00:05,090
Let's take a look at a fun hidden feature in Excel.

2
00:00:05,300 --> 00:00:06,170
So let's assume,

3
00:00:06,170 --> 00:00:11,860
originally I had this data on a piece of paper and I had to type it in my spreadsheet.

4
00:00:11,870 --> 00:00:17,690
Now I want to double check that what I typed in is identical to what I had written down.

5
00:00:17,810 --> 00:00:24,590
I can of course hold the paper beside my screen and cross-check. Or I can get Excel to read it out

6
00:00:24,590 --> 00:00:25,040
for me.

7
00:00:25,040 --> 00:00:28,510
The feature is called Speak cells.

8
00:00:28,730 --> 00:00:32,240
Trust me not many people know it exists.

9
00:00:32,240 --> 00:00:35,960
It doesn't exist on the ribbon. To be able to use it,

10
00:00:36,110 --> 00:00:39,200
You have to add it to your quick access toolbar.

11
00:00:39,200 --> 00:00:44,600
So let's go and select more commands. From this dropdown here

12
00:00:44,660 --> 00:00:48,750
select either Commands not in the ribbon or All commands.

13
00:00:48,770 --> 00:00:56,730
I'm gonna go with not in the ribbon and scroll all the way down to S. Speak cells is what I need.

14
00:00:56,760 --> 00:00:59,780
Let's click on it and add it to the other side.

15
00:00:59,870 --> 00:01:06,470
Let's actually add all the Speak cells items and see how we can use them. And then click on OK.

16
00:01:06,490 --> 00:01:09,590
So we see them pop up here

17
00:01:09,740 --> 00:01:12,830
and notice that some of these are a toggle.

18
00:01:12,830 --> 00:01:15,850
This one is called Speak cells by rows.

19
00:01:15,860 --> 00:01:18,860
There was one that was speak cells on enter.

20
00:01:18,980 --> 00:01:20,210
That's this one.

21
00:01:20,210 --> 00:01:24,630
"Cells will now be spoken on enter" activate it

22
00:01:24,830 --> 00:01:26,180
and let's see what it is.

23
00:01:26,240 --> 00:01:32,920
I'm just gonna start typing something in, "one thousand" "one thousand two hundred".

24
00:01:33,440 --> 00:01:35,570
I can get Excel to speak.

25
00:01:35,750 --> 00:01:39,800
Now let's take a look at the other options that we had.

26
00:01:39,800 --> 00:01:42,290
So let Excel read this to us.

27
00:01:42,350 --> 00:01:45,260
It's easier to read by rows in this case.

28
00:01:45,270 --> 00:01:49,000
I'm going to activate speak cells on rows.

29
00:01:49,070 --> 00:01:50,980
"Turn off speak on enter".

30
00:01:51,110 --> 00:01:53,120
So let's just turn this off.

31
00:01:53,120 --> 00:02:03,620
Instead I'm going to activate the speak cells, "Scarf-M", "one hundred", "one hundred and ten", "Scarp-W"

32
00:02:03,620 --> 00:02:04,760
"one hundred and fifty".

33
00:02:05,060 --> 00:02:07,190
Let's click on stop speak cells.

34
00:02:07,190 --> 00:02:12,840
So when we have it by rows and we activate the start speak cells it goes through our data set.

35
00:02:12,900 --> 00:02:19,850
And this makes it easier to compare this data to what we have on the piece of paper. To get Excel to stop

36
00:02:19,850 --> 00:02:21,490
from speaking the cells.

37
00:02:21,590 --> 00:02:29,030
Make sure that you click on stop speaking cells. Especially after you've activated speak cells

38
00:02:29,030 --> 00:02:29,630
on enter.

39
00:02:29,630 --> 00:02:33,960
It's always going to constantly speak unless you turn it off.

40
00:02:33,980 --> 00:02:38,840
You can also change the voice and the speed of the voice. To do that

41
00:02:38,840 --> 00:02:44,180
you have to go through your windows settings. So if you go to control panel there's a place called speech

42
00:02:44,180 --> 00:02:51,620
recognition, text to speech and adjust the settings there and apply them. If you don't want to have these

43
00:02:51,680 --> 00:02:53,190
in your quick access toolbar.

44
00:02:53,210 --> 00:02:58,380
You can just right mouse click and remove from your quick access toolbar.

45
00:02:58,520 --> 00:03:00,290
So that was the hidden tip.

46
00:03:00,350 --> 00:03:07,400
We've learned how to input data, how to edit data, how to add simple calculations, and also how to get

47
00:03:07,400 --> 00:03:09,320
Excel to speak back to us.