Hey everyone! I recently saw a video on YouTube that said tutorials are dead and you're never going to need them again because of this new AI tool. Of course, as somebody who runs a channel that's all about tutorials, this got my attention.
This is Google AI Studio, which, among other things, kind of lets you get a tutor to talk you through something that's happening on your screen. So, I thought we would take it for a spin and see if I should worry about being replaced. We'll go through three examples: one in Microsoft Excel, one in Photoshop, and then a more complex one in AWS.
To follow along, just go to aistudio. google. com.
This is totally free, at least at the moment, but you do need to be signed in with a Google account. Then, you want to come into Stream Real-Time up here on the left and navigate. Now, just a big warning before we start: I'm going to be sharing my screen and also recording my microphone, which means that Gemini Google is recording all of that.
According to Google, they can use your data to train their model, so please, please, please don’t use confidential information. Don't have that up on your screen as you're doing this; anything that you're showing could potentially be available to the whole world. Okay, so I'm going to start by recording so I can use my microphone to talk with Gemini, and then I'm also.
. . "GNA.
" Okay, sounds good! What are you going to do next? Hey Google, I'm going to share my screen, and I need some help with a few things, so let me share.
Sure, I can help with that. Let me know what you need help with once you share your screen. Okay, I'll share my second monitor.
All right, I see your second monitor. What do you need help with? The first thing I need help with is Excel.
Do you see my Excel spreadsheet? Yes, I can see your Excel spreadsheet. What do you need help with in it?
I need to write a formula that lets me look up the price of a product based on the product ID. How would I do that? Sure!
You can use the VLOOKUP function to find the price of a product based on the product ID. Do you want me to explain how to use the VLOOKUP function? Yes, please!
Okay, let's start with the VLOOKUP function. In this cell where you want to display the price, you'll type equals VLOOKUP, then select the cell that contains the product ID you're using to look up the price. After that, add a comma, then select the range of.
. . So, the first parameter.
What would I use for that? The first parameter is the lookup value, so you would use the cell with the product ID that you want to find the price for. For instance, if you wanted to find the price of the product in cell A2, you would select cell A2.
Okay, then what's next? Add a comma after A2, and then select the range of cells that contain the data, including the product IDs and prices in your spreadsheet. That would be the range of cells A1 to D18.
Then add another comma. Okay, I actually have more cells than that, so I'll go all the way down to D101. Okay, so the range should be A1 to D101.
After that, you will need to input another comma and then the number of the column where the price is located in your selected range. Since the prices are in the fourth column, you will need to input four, followed by another comma. Okay, now what?
Then, finally, type false and close the parenthesis. This will ensure an exact match when looking up your product ID. Okay, I think I wanted to be able to type in a product ID.
I don't always want the ID in A2. How would I fix that? Okay, I understand.
You want to be able to type a product ID into a cell and then have the VLOOKUP function find the corresponding price, correct? To do that, you should type the VLOOKUP formula in cell G2, using an empty cell as the lookup value parameter—for example, cell G1. Then, when you type a product ID in cell G1, the corresponding price will appear in cell G2.
Okay, so here I need to say G1 instead of A2, and then in G1 I would type. . .
That's correct—something like this. Now, if you type a product ID into cell G1, the corresponding price will appear in cell G2. Okay, good!
I think that's what I want. That's helpful. Now, I also need some help in Photoshop.
Let me show you that screen. Okay, I'm ready to help with Photoshop. Just let me know when you're sharing your screen.
Okay, do you see it? Yes, I can see your Photoshop screen. It looks like a picture of a forest.
What do you need help with? So, I got a new camera, and I don't think I've got the settings dialed in correctly. The colors look a little bit off, and the sky is a little bit blown out.
Can I fix this in Photoshop? Yes, you can definitely adjust the colors and sky in Photoshop. Would you like me to guide you through adjusting those?
Yes, please! Okay, let's start with the colors. In the Layers panel, which is on the right side of the screen, click on the Adjustments button at the bottom, which looks like a circle that's half filled in.
Then choose Color Balance from the menu. Okay, now you should see three sliders for Red, Magenta/Green, and Yellow/Blue. Try adjusting these sliders to see how they affect the overall color of the image.
Okay, let's see. . .
All right, that's getting me somewhere great. Are you liking how the colors look now? Yeah, it looks better.
How do I fix the sky? Okay, to fix the sky, let's add a curves adjustment layer. Go back to the adjustment button at the bottom of the layers panel and select curves.
Okay, now you'll see a graph with a diagonal line. Click on the line near the top right and drag that point down slightly. This should darken the sky and bring back some of the details.
It's kind of darkening the whole image, but I think I can play with this, so this is good. The other thing I need help with is Amazon Web Services, so let me bring up that screen. Okay, I'm ready to help with Amazon Web Services.
Great! Please let me know. Okay, I see the AWS console.
What do you need help with? So I need something kind of big here. I need to create a multi-tier application.
The front end should be accessible through the public internet, but the back end needs to be private. It's going to have a database and an API. So how would I go about building something like that in AWS?
Okay, so it does seem to cut off at some point. Let me switch back to Google AI Studio, and it looks like something went wrong. This did happen to me before.
I'm guessing there's some kind of a limit on the context, so let's just clear this to start a new session. I will start recording again. Hey Google, are you there?
Yes, I am ready. How can I help you today? Let me share my screen.
Okay, I understand. I'll wait for you to share your screen. I need some help with an app that I need to create in AWS.
So it needs to be a multi-tier application. The front end should be available through the public internet, but the back end should be private. It's going to include a database and an API.
So how would I do that? Okay, you want to create a multi-tier application in AWS with a public front end and a private backend that includes a database and an API, is that correct? Correct.
Great! To start, you could use Elastic Beanstalk for the front end and a VPC with private subnets for your backend, database, and API. Do you want to go into more detail about these or other options?
Yeah, tell me more about the VPC with the different subnets. Sure! A VPC is a virtual network you create in AWS, and subnets are subdivisions of that network.
A public subnet has a route to the internet, while a private one does not. This allows you to isolate your database and APIs from the public internet. Would you like to dive deeper into that concept?
Actually, just show me how to create one of those. Okay, let's create a VPC first. In the AWS console, search for VPC and select the VPC service.
Then click on Create VPC to start the wizard. Would you like me to walk you through each step? Can I use an existing VPC?
I have a default one. Yes, you can definitely use an existing VPC if you already have a default one that works. Are you planning to use the default one, or are you considering creating a new one?
Let's do the default. Okay, let's use the default VPC. Now, do you want to proceed with setting up the subnets?
Okay, I'll stop that there. We could go on for days, but my overall take is this: This is very impressive tech. I think we've all become a little bit blasé about all the AI stuff that's coming out, but this is very impressive, and this is only the experimental model.
So you have to assume it's going to get better. But this seems really useful if you're working on something that's task-based and has documented steps, and if you know enough to know when it goes off the rails. I tried a couple of different things in AWS that it just got wrong or had to kind of nudge in the right direction.
It obviously is not able to write things on your screen or diagram concepts or architectures, which I personally find very helpful when I'm learning something. But it is a solid helper if you're learning new software or you're stuck on a particular task. So that is it for this video.
If you found it helpful, give me a thumbs up so YouTube knows to share it with more people, and also consider subscribing to the channel for more content like this. Thanks so much for watching.
