AISubs v3.7
B.S. Teret
Thank you for joining us again this week.
Thank you for having us.
We are here again at Dospara Akihabara Main Store.
I'm so happy.
We've been here for a long time.
I wonder why.
We bought a computer.
That's right.
I wonder why.
Since we are in Dospara, we have Noborisaka46 here as well.
Thank you for coming again.
It's been a while.
Thank you for having us.
Thank you for having us again.
Thank you for having us.
This is the second time.
Do you know why you are here?
We bought a mouse, a computer and a keyboard.
But we still have something missing.
Me?
You gave it to me for free.
So, I have to say "thank you" to you.
Of course.
Thank you very much.
What is it?
It's an office software.
Office software?
Yes, office software.
Word and Excel are not included in the computer yet.
I'd like to go and buy it today.
You can buy it?
I see.
You are a college student and you use your computer a lot.
What are Word and Excel like?
Word is for writing sentences.
Excel is for making brackets and charts.
Mr. Nogizaka, is it correct?
Yes, it is.
That's great.
You are a college student.
As for Excel, you can calculate things and make charts.
It's a software that is often used for business operations.
I see.
Now that we know what Word and Excel are like,
I'd like you to look for something that you think is an office software.
Do you know what it is?
I don't know.
Good evening. I'm Sato Arika of Nogizaka46.
This summer vacation, I went on a trip to Okinawa with Saya-chan from Kanagawa.
It was my first trip to Okinawa and I had a lot of fun.
I'm looking for office software at Dospar Akihabara head office.
The time limit is five minutes. Will everyone be able to find it?
I'd like to start. Ready, go!
You're fast.
I think the second floor is...
You've been there, haven't you? Shall we go to the second floor?
Let's go to the second floor.
Ayati and Emiki decided to go to the second floor.
On the other hand, Hayashi...
Oh, is this wrong?
Is this wrong?
Hayashi, you're breaking the plan.
The two who arrived on the second floor...
This is wrong.
I don't know.
What is "butsu"?
Is it "butsu"?
No, it's not.
Because I think it's in there from the beginning.
This is wrong, isn't it?
Huh? I don't know.
This is wrong.
Hayashi, who has already found the office software,
goes up to the second floor to see how the two are doing.
Where is it?
Yumiki-san, how do you think the office software is sold?
It's very thin.
If you type in this, you can get everything.
I thought it would be sold as a rose.
Huh?
Isn't this it?
Yumiki, isn't this thin and too big?
Can you find it properly?
Is it "shitamaari"?
Hayashi-san, who noticed that it wasn't on the second floor,
headed for...
Huh? Isn't this it?
He found the office software near the entrance.
On the other hand, Yumiki...
Huh? Isn't this it?
I think it's pretty good.
Yumiki, isn't this a hard disk drive?
Hayashi, who noticed that it wasn't on the second floor...
Hey, old man.
It's not on the second floor.
It's not?
It's not on the second floor.
It's not?
Isn't it?
It's definitely not.
Isn't it?
It's quite expensive.
It doesn't say "office" here.
Do we have to write "office"?
It doesn't say.
It's definitely not.
Where is it?
Let's go and see.
Yoshida-san has been there.
I've been there.
Are you kidding me?
She said it without hesitation.
You're kidding me, right?
You have one minute left.
This is bad.
Hang in there.
This is bad.
You're kidding me.
You're kidding me, right?
Wait a minute.
Where is it?
Did you find it, Aya-chan?
That's fast.
Isn't it? It should be here somewhere.
Yumiki, this is not the time for you to wander around. Look for it!
It's written there!
What?
In the remaining 2 hours and 20 seconds, discover the Oasis software!
But, it seems like there are several types.
Will everyone know which one it is?
Then, this one.
This one.
This one is also correct.
However, the price is a little high.
It's expensive.
It's amazing.
All three of you are correct.
Once you buy it, you can't spend any more money on it.
You can only buy it, but if you buy both Word and Excel,
it's expensive.
These Word and Excel are included.
You can buy what you can afford.
Then, we will actually learn what Word and Excel are like.
Here, we say goodbye to Nogizaka464.
Everyone, we have come to a computer classroom.
It's amazing.
This is Curio Station Shin-nakano-ten computer classroom.
It's a computer classroom that has been loved by the locals for a long time.
The teacher is doing it alone.
She is doing it alone.
Let's go inside and have a look.
Yes.
The three of you have come to Curio Station Shin- nakano-ten computer classroom
where you can learn from scratch even if you have never used a computer before.
She is Onishi-sensei of the computer classroom.
Nice to meet you, Onishi-sensei.
Nice to meet you, too.
It's amazing.
What is the purpose of a computer classroom?
After all, there are many people who want to learn Word and Excel and PowerPoint.
It's almost like that.
In terms of age and so on?
Really, young people want to get a license.
Ah, I see.
They want to get a license and make use of their job.
In this era, it's hard to get a job if you can't speak Excel and Word.
That's right.
Now, let's ask the show to teach beginners how to use Word and Excel.
Ayase-san, do you use Word when you write reports at college?
Yes, I do. I use it.
I also use Word on my smartphone.
You have it on your smartphone, too.
I do.
Wow, that's amazing.
Is it different from a computer?
That's right. You can do it with a flick input, so it's fast.
Can you do it with one hand?
Yes, it's more convenient when you're on the move.
I see.
Yoshida-san and Uniki-san, do you ever use it on a daily basis?
No, I only use it in games.
Games?
I don't have a computer, either.
Ah, I see.
But in the past, there was a computer information class.
At that time, I used Word and Excel, but I don't remember it anymore.
Today, we'd like you to teach us a lot of things.
Let's start with Word.
First of all, we'll use both hands to type.
Do you know about "home position"?
Home position?
In home position, you put your index finger on "f" and "j" here.
Yes.
And if you roll up your hands like this, you'll see that "a" is on the left and "j" is on the right.
What is "home position"?
The basic finger position for pressing the key.
Put "f" on the index finger of the left hand, "j" on the index finger of the right hand, middle finger, ring finger, and little finger in order.
Basically, you use your fingers as if they were colored.
For example, when you hit "e", hit "i" and "e" with your middle fingers of both hands, and then put your middle finger back to "k" and "d", which is the "home position".
By repeating and learning this, it seems like you can play without looking at the keyboard.
With no look?
That's right.
Can you do it?
Well, you can't do it from the beginning, but you practice it, so you might be able to do it with a flick.
Well, it's that feeling, isn't it?
If you get used to it, you'll say it with your own senses.
Oh, that's amazing.
So, the three of them decided to try hitting their own names.
With Ms. Ayatee.
Yumiki seems to be hitting letters while being aware of her home position.
I can't do it at all.
Hayashi, who usually uses a computer, also has trouble with both hands.
If you hit a name, you can select this icon and change the color.
There are a lot of fonts, too.
With this part, they learned how to change fonts.
Now that you know the basic usage...
I'd like you to make your own self-introduction sentence, but as a rule, I'd like you to change your "sales point" to "color" and "font".
I see.
Yes.
So, the three of them will make a self-introduction sentence.
Self-introduction is very difficult.
It's surprisingly difficult.
There's nothing to introduce.
That's true.
There's nothing, right?
What is it?
This is what Hayashi, who was struggling with self- introduction sentences, made.
What is written in long sentences in small letters?
In the future, I will make and sell stuffed animals and buy stuffed animals again with the money I earned.
It's a stuffed animal infinite loop.
You said it.
Do you say you're buying stuffed animals?
That's right.
The fail point is "idol".
"Idol".
Shabuya.
Next is Ayati.
This is Hidaya's quiz.
First of all, it's from Shunshinji and it's decisive.
The first thing you think of is making pork kakuni delicious.
That's right. You often say that.
You can make it tender.
I want to eat it.
The minus point is that it's very thin.
That's why it's written so thin.
That's amazing.
Trick.
Programming makes you anxious, doesn't it?
You're making a mistake.
Well, this "nyoro-nyoro" is "saiti".
Maybe it's not kanji, but it's a part of it.
Because "hira" is long, "hira" is long.
That's why it's okay.
If you say you're doing it on purpose, it's not like that.
In general, it's kanji, isn't it?
If you know it too much, you don't have to worry about "nyoro-nyoro".
Did you come up with all of these words?
That's right.
That's amazing.
In terms of common sense of words, Aya-chan has changed too much.
It's like, "What do you mean?"
That's why you can tell if you're wrong or if you say something wrong.
Those words are amazing.
I don't know.
By the way, Aya-ti's sales point is her name.
It's important to have a name, isn't it?
The last one is "yumiki".
First of all, this is in psyllium color.
Psyllium color.
Do you know that?
Yes.
It's a job called "idol".
You can cheer me up in psyllium color.
I was born in 1990 and I'm from Kyoto on February 3rd.
Basically, I've been wandering between long and medium hair.
My blood type is type A.
My parents told me about it, but I don't admit it.
Basically, I'm an indoor person.
I don't go out of my house even for one day off.
But I remember the sense of crisis.
But I don't go out of my house.
I'm such a scary person.
I like people. I like them a lot.
But I like being alone, too.
This is an arrow.
This is troublesome.
I know.
Family is important.
That's all for my self-introduction.
Yumiki's sales point is that she values her family.
That's nice of you.
Now that you've made your self-introduction, I'll ask you to teach me about shortcut keys.
A shortcut key is a combination of keys that can be operated with a mouse.
For example, if you want to save a file, you need a two-step operation to save a file with a mouse.
But with a shortcut key, you only need to press "control" and "s".
So you don't have to use a mouse.
What does "control" and "s" stand for?
Do you know this?
I don't know.
Save.
Oh, I see.
I thought you meant "end".
I see.
End.
End of dance.
Hayashi, correct!
"s" comes from "save" and "s".
Now that you know that, I'll ask you to answer this question.
When you draw an arrow, what key should you press on "control"?
What does "control" stand for?
Then I'll say it.
It's not "Yui", it's "Yu".
"Yui", you said your own name.
It's not my own name.
It's "Yu", isn't it?
Yes, it's "Yu".
Correct answer, Ayati.
If you draw a line, the first letter of the underline comes from "Yu".
Next, the second question.
If you put the letters in the left stack and put them in the right stack, which key should you press first?
First, the left stack.
"T".
First, the left stack.
"T"?
"C"? "T"? "T" you said.
"T" I said.
First, the left stack.
That's right.
Ayati's answer is "L".
Oh, great.
It's "L".
"L"?
It's "L" in "left".
Then, what's in the right stack?
R
Ayati's answer is correct.
The right stack comes from "R" in "right".
By the way, the center stack is...
This is actually "E", isn't it?
"E"?
That's right. The center stack is "E".
"Central" is "center" in English, so you might think it's "C", but...
"C" is used for copying letters with "control" and "c", so the next letter of "center" is "E".
It doesn't always mean that capital letters are used.
When you paste other letters, it becomes "control" and "v", but it doesn't come from pastes, which means pasting.
Actually, when I first made my first computer, I said "control" and "c" can be copied.
When you paste "control" and "c", you can't leave "c" too much, so it's true that you can make "control" and "v".
It's easy to use.
Even if it's easy to use, think about it...
This is not even a header or something, and I put it there.
After this, make a table with Excel.
It's funny. I think it's the first one.
"Request" is crazy. "Up" is crazy.
Cute.
Hey, it was cute when I came here before.
Like this?
It's nice.
The show's original game "Denpa-to" is selling well for 980 yen.
We will also introduce our impressions of the show, so please try playing it!
Now that you know the basics of words, let's learn the basics of Excel.
Excel allows you to make tables and calculate, and is a useful software for making brackets and other things.
Now, let's actually make tables and learn!
Recently, I feel that you are worried about the budget of the show.
After entering this year, you are eating a lot of sweets during the break.
I'd like you to make a table of how much it costs, what you ate and how much it costs.
So, the three of you will make a table of what you ate during the break and how much it cost.
Wait a minute! I'm the first one!
Requests are dangerous!
Remiki, it costs a lot of money. Think about it!
Hayashi, who is using Excel at university, is starting to make tables.
On the other hand, Ayati and Remiki...
From the second line, you can put in the content, amount and price.
As the teacher teaches you, you enter the letters in Excel.
"Satsuma..." Was there such a thing?
Agemon!
Agemon...
We all ate it.
We ate it hot.
Yes, yes, yes.
As you indulge in your memories, you will proceed with your work.
Once you have the content and amount entered, you will draw a line to make it easier to distinguish as a table.
It's all handwork.
It's strange. I can draw a line, but isn't there a way to draw it at once?
If you want to draw it all, do it like this from here and push it like this.
Is this it?
Yes.
Push it like this.
Yes.
Beautifully.
Oh, but this is not it.
I've done something wrong.
But you can put it back. You can do it yourself.
Yes.
Let me do it.
You taught me how to draw a line at once, but you couldn't draw only one place well.
But it's amazing that you can combine lines of "d" and "e" and make a central array.
Since we were able to make each of them except for the total amount, we will ask you to teach us how to calculate the amount easily.
Bring me the function you want to output here and call it "autosum" and call it "total".
Oh.
You can use it here and do it like this.
Not only can you output "autosum" function, but you can also output average, individual values, maximum value and minimum value.
After this, you can learn Excel's latest function.
"Flash..." "Flash..." "Flash filter."
"Flash filter." "Flash filter."
"Oka-sa" is "o" and "otosa" is "a."
So it's "ao," right?
But I know. I'm not "ao" either.
Really?
There's definitely not a "a" in my name.
Please look forward to the next episode!
"Tokyo Basukun Club" will be broadcast on TVer and other platforms.
The program will continue for three years, four years and more.
Please click the "Like" button of TVer.
Finally, I would like you to tell me about Excel's latest feature.
Excel's one feature is pretty new.
"Flash..." "Flash..."
It's called "Flashfield." "Flash..." "Flashfield."
"Flashfield" is a function that automatically inputs data from imported data from the browser.
It's easy to use.
For example, when you want to separate last name from first name,
First of all, you enter it yourself and select the cell you entered and select the flash fill in the data.
Then you will find the rule and the rest can be easily divided and entered.
By the way, in the case of a name, be careful because you cannot use the flash fill unless you separate the last name from the first name.
This is quite useful, so I hope you will remember it.
That's all for today.
The booth of the program will be exhibited at the Tokyo Game Show!
Yay!
Come and enjoy what's in the booth!
Please come and visit us!
We'll be waiting for you!
See you!
Next time...
Wow!
PetroPC Grand Gathering.
Toapaso.
PetroPC Museum.
Flash...