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
