Microsoft Excel 77 Data Tables

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Data Tables in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hywmicrosoft

Transcript

00:00so let's say i want to go ahead and create something out like a multiplication table

00:09where i have one right here so let's just go ahead and click and drag this out till i have

00:15let's say for example 10 i'm holding ctrl to go ahead and increase out the number then i'm going

00:21to go ahead right here click and drag this out right here and then you got 10 right here just

00:26like this as well let me just go around over here and then go ahead and click and drag this out and

00:32this is what you have so now i can actually go ahead and create out a multiplication table using

00:38the numbers that i have right here so for that i need to give an example let's say for example i'm

00:43going to say five by five so i'm just going to press equals and five multiply by five right here so this

00:50is going to be the reference right here and this right here is where i want to replicate it out

00:56for each of the cell so to do that i need to go around over here onto the data tab right here

01:01and then i need to go to the what if analysis right here so you can see that data table is an option

01:08so here it says add in a row input cell so this is the row input cell right here five which i want to

01:15add in a sample and the column input cell which is going to be this right here on the top so press

01:21okay and then it says the selection is invalid because i never selected out the table so i need

01:27to select this first and then go around over here on to what if analysis and then choose data table

01:33go around over here onto row input table and then select out the row and then column input table select

01:39out the column right here press okay then this is what you have as you can see so you can see that

01:44five multiply by two is ten four multiply by seven is twenty eight right here so you can go ahead right

01:50here and then track down the multiplication value right here just like this so that is how you can

01:57go ahead and then create out data tables as you like inside of microsoft excel so i hope you found

02:05this video useful be sure to hit the like button don't forget to share this out with your friends

02:11and families and for more contents like these do follow simple tutorials

Category

Transcript

Be the first to comment

Recommended