Skillshare: Microsoft Excel in Minutes - Create a Chart and Format a Table | Dr. Warren Chalklen | Skillshare

Skillshare: Microsoft Excel in Minutes - Create a Chart and Format a Table

Dr. Warren Chalklen, Education Innovator

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
3 Lessons (21m)
    • 1. Welcome to the course!

    • 2. How to create a chart

    • 3. How to create a table


About This Class

In this course you will learn a no frills approach to intermediate Excel knowledge and skills. 

Last course update: October 6, 2016

A complete template with additional formulas for Mac and PC added for easier use!



Become the Excel expert in the room with this value for money course!


As a professor and data analyst I have worked with hundreds of people around the world advancing their skills in Excel. I developed a system that rapidly moved them from beginner to expert regardless of their starting skill level. 

And now…I want to share this process with you so you can improve how you use data to inform performance, communicate results through meaningful charts and find information with razor sharp formulas.


✔ Easy to Learn Material—free template download available to get started

✔ Project Based Learning—Know Excel through this hands on approach

✔ Apply what you learn to your context

 Follow the Best Practices of Top Corporations For Your Context

Five-Star Review: Perfect for beginners.

Here's what we will cover in this course...

Don't forget to check out the free preview lectures to sample my course. Are you ready to learn with me? By the end of this course students will know:

    • Excel terminology

Don't wait another day to start learning Excel.



1. Welcome to the course!: Hello, Jumble San Assalam alaikum and welcome to this course Microsoft Excel from basics to advanced in rapid time. My name is Dr Warren Chocolate, and I am incredibly excited about Excel. Why is Excel important? It's the world's most popular productivity tour. Over 89% off companies around the world use it to increase the productivity and budgeting and forecasting 70% of them use it for the mission. Critical processes and 83% use Excel for Monday and close processes. It's a tool that is as popular as the tables and chairs in companies around the world. 81% of organizations use Excel in conjunction with their CPM solutions. And why? Why is X also popular? It's popular because it's flexible. It offers you in ease off high use adoption. It has powerful formulas and quit modeling. Those cost is going to take you from beginner from basics all the way through to advanced, and it's gonna do it through a process that makes you the expert in the room. Let's show you how we gonna do that. We begin with a basic data set, and what we do is we go through a process where I show you how to sort and filter your information. We also put in formulas such as some F count if and the average we then look at charts and tables. I show you how to create charts, how to use shapes on how to unfold. Matt information. Once we've learned thes basic pieces, we're then gonna move on to pivot tables. I'm going to show you how we craft pervert tables, how we felt, a pivot tables and how we begin to sort information vision. And finally we entered the look up one of the most powerful formulas in Excel where I teach you not only how to use it but the features that comprise the formula and and I give you practical examples that you can apply to your own experience. This cost is ideal for anyone hoping to learn the basics of Excel for their work opportunities, all hoping to improve their skills through a step by step process. This course will provide a certificate upon completion, feel free to look through the course description, and I look forward to seeing in the class enrollment 2. How to create a chart: Hello and welcome to this lecture in this particular class we're going to be doing three main things were gonna be combining cells, creating a chart and formatting your child. I hope you recognize this. Uh, what we have on our screen right now in that this is what we recovered in the last lecture . Well, I'm gonna be shaking it up a bit. I want to create a chart that has the teachers names and the ages. But what I want to do is I want to combine or I want to create a cell and combine the first and last names. So what I do is I click on under the column that I want I right click, and then I press inset and I'm gonna call this column full name. Now, how do I combine these two cells to to create the full name here? We're going to use a formula, and I'm gonna show you exactly how we do that. Repressed equals two. We open the parenthesis. We then click on the spur so that we want which is a three repress. We hold down shift and we put the end. We then put a parenthesis in inverted comments. We press the space bar, you press the inverted commas again, we then press and and then we put the second. And as you can see, once again, let me talk you through this. Let me talk you through this one more time. In fact, I'm gonna zoom in just so that you can see exactly what this has looked like. I'm gonna do it one more time. We press equals two. We opened the parenthesis, we click the seller we want All right, we hold down, shift depressed and we then put the invention covers in press space Bar invented Commons know what that says is that there's a space. So it says this cell and space right, repress And we pressed the next cell that we want And then we close the parenthesis so that it's symmetrical. And then you press enter and what we will do is we will go to the corner and drag this down . And but we will also do is we'll wrap the text and with drag us across. Now you'll notice that when I copy this, that's a copy of this. And I wanted to paste it right over here. Watch what happens. You will see that when I paste. It won't. It won't come as the name that that I wanted to be. Because I'm not doing what's called Pay Special Ng If you remember, we can ask ourselves what do we want it to look like? And I'm going to say I want the values only So when I click that I'm able to copy and paste and it will forget that it's a formula and actually give me the value that's in that cell. But anyway, I digress. I'm going to zoom out little bits that we can see a bit better. And what I want is I want to create a chart that has the full name of the teacher and the age. So what I do is I highlight the two cells, the two columns. Excuse me. And then what I do is I go into charts, click charts, and we're gonna make a bad shot. So I click this and we're gonna make a clustered color chart. Okay, so what I see is immediately I have a I'm gonna drag this right over here for us. I'm actually gonna put it over some of the other information so that you can see exactly what we're looking at over here. Okay. And once you can see is that we have the names of the bottom and we have the age is at the top. Now let's say I didn't want a bar graph. Let's say I wanted a line drop. I could click here and I could. And there we go. We have the line, we have the lion graph. OK, but I'm gonna go back to our bar graph. But now let's say I wanted to change the color. Could go up here to chart styles and change the color that give me a variety of options. Okay, We're gonna stick with Blue and let's on one of the four match to change a little bit. So let's say I wanted a legend. Let's say I wanted values. I would go up here to the layouts and I would select these values right here. OK, there's a wide variety of options that you can choose from. Okay, Now I'm gonna choose the simple one, but what I'm gonna do is full. Matt, What's called formatting? This shot. Okay, now we've done it through the click method. But what we can do years If I right click on this, I can say format, chart, area. And what this allows me to do is you'll see that as I change some of these pieces, I'm gonna move this right of here. As I changed these pieces, you will see that our chart will actually change as well. So what? You're if I go, Phil? Okay. I can actually change the color of the background to fill, and I can also change the transparency of it. I can make it completely transparent so I can make it completely call it right. In this case, I'm going to go Nofal. Okay. Oh, I'm going to say automatic. I can also change the inside to be a Grady int. So let's say I wanted to be radio right. I can change this so that it looks all sorts of colors, right? We can even add colors in there, for example, that so I wanted to be black and red. I can also change the angle off the color and shifted around, and once again, I can work with the transparency of it. I can also add a picture perhaps I can choose one. I can choose the texture. Perhaps I wanted to be green at the back or that looks really eye catching or purple. We can play around with it. Or we could even make this a patent in the background. Some Sometimes this may work for you. I'm just playing around here. But what I want to show you is just the different options that you have. I'm gonna cancel this and I'm gonna go back and show you the other options. We can also go to change the lining. You can see the lining that we have, all right. And we can create a very, very thick lining right around our chopped. Gonna make that a six. OK, um, we can create a shadow on our child, weaken soft, go the edges. We could even change the font of our child. And we can do that right over here where we can turn the front about chart into, for example, aerial black. There we go. And if you press OK, we'll find that I can also go to the perimeter, my Charton, and play around with size when my cursor becomes a four legged era I can then move my chart . When my cursor becomes two arrows, I can change the size off my chart. Okay, now, let's say I wanted to click on my, uh, change specific things about the child. So if I clicked on the these bars and I right clicked, I could add data labels. Why could also format? It's Let's add data levels. You'll see now it gives us the value, but let's also format it. Let's see what happens in before matters. We could change the color of this remastered earlier. We could change this to read. Okay, We could also go in here and change this so that it format text. We can change the direction off the text. Right. So we can say we can look at the text, Phil, so we can make this a different color. Maybe we want to make this read as well. Okay, we can change the font. As I've shown you, we can also Ah, look at how we can change this to be, you know, radical horizontal. We can change it in many different ways. And finally, what I'm going to show you is how we can change the title of our of our chart. I'm going to call this teaches by age or teachers who attended by age. Now, what I want to show you is quite important if you have a chart and let's say you wanted to hide something about the list. So let's say I decided I was going to hide the age, Noticed that your chocolate will not be able to find that data. So when you hide something, remember that it's always connected to different areas in excel and hiding. It can actually affect your data. So what if I wanted to? What if I just wanted my chart to not change when I hid other cells? And that's when you would save it or copy it as a picture side right clicking it. And I'm going to save it as a picture. Okay. And I could give this picture and name. I'm going to call this this picture Teachers attended by age. Okay, I'm gonna save it on my desktop, and I'm gonna save it as a J pic. Now, let's say that I started a new sheet and I wanted to insect that, uh, picture I could go to inset. I could go to photo or picture. All right. Andi, I could actually in inset this particular picture Saigo picture from file document. All right, I'm a desktop, remember? And let's find this document really quickly. Teachers and I could say in set. And there is my table as a picture. No, just that I can change it now that it's a picture. If I wanted to change it, I would have to go back to the original and actually adjust the original and save it again . Okay, so here we are. We've created this table. I can now present this to my colleagues. I can packs, put it on a PowerPoint slide. I can do all sorts of things with it. But this is the just off how to go about, uh, working with tables in Excel. 3. How to create a table: welcome to this lecture. I hope that your skills and your understanding of excel is increasing exponentially in this particular lecture we're gonna be doing four key things are gonna help you and format insert tables, text boxes and shapes. Why might we conform at something? So let's say I was given this particular Excel document, but I wanted to create my own and customize it. I would need to un format it. And when I do is I highlight the area that I would like to. Okay, On my go here, under home, I go edit and I go clear and I can say it clear all, which means it'll clear everything whacking clear the formats. In this case, I want to clear the formats, Which means that everything that I did remember the conditional formatting and the like has been removed. Now, let's say I wanted to turn this document into a table, A nice table, and what I would do is highlight everything click table and find something that really resonates with me. And and I think I'm going to go for the orange because it matches with the top and I'm actually gonna merge the cell okay, Merge these two cells Bayan merging and then merging them again. Fantastic. So oven formatted and I have created a table. Let's say I wanted to create an explanation. I could type it into a So I'm just going to say the with explanation. I could type it into eso like I've done here. Excuse me? Kanye stretches. Um, I could type it in, but, you know, I also in excel sometimes nice to play around with some of the formatting tools that we get . And, as you can see, excels already co opted this cell because we were using it earlier. All right, so I'm gonna hold on Command and Z, and it will undo that. Okay, No, let's say I just wanted to add a bit of flair to this and not necessarily be bound by cells . I'm gonna show you how we insert text boxes. And what we do is we go up to insert we got down to text box, and then we can draw a text box, and we could even fill it so I can go over here. I'm gonna fill this. I'm gonna make it red when I make my text. White and I'm going to say demonstrates information about teaches who attended, uh, event. So this looks a whole lot better than just the and I can even grab this and move this right over here. And so anyone who's opening of my Excel document can actually see an explanation as to what this table is about. And let's say I wanted to point them towards a specific area in the table. Let's say I wanted to point to the age or I wanted to point to a specific person, and I could do that by going insert and we could go down here to shape and I could choose a shape that would be really useful for me, right? And when I would do is I'm going to say we're gonna look at the ages. So I click this and I didn't let me draw. And so I'm gonna go over here and actually click that right there. And, you know, I could even make it really nice and thick and say something like Right Click edit text and says something like, Look here! And what I could then do is go home and send to this and to make it uniform. I could even change that up. And we could even increase the fund size. It's make the fund says 12. And I do that by clicking that going out of here and making it bigger. Okay, Now, I could put that right over there and say, Look here, or I could even go right over here. Highlight the cell. Okay, go down to my borders and create a nice, thick outside border to show you that I'm looking at the specific person. Why could even Phil this cell and make it yellow? All right, let's make it yet. It right? Yeah, So that I am pointing and highlighting this specific person over here. So what we've done is we've I'm formatted. We've used we've re sort of defined our table. I've inserted a text box and I've added some shapes. And the most important thing about shaves is that they add value. They add dynamic into interaction into your excel document. And that's what Excel is about. It's not just about numbers, but also creating stories. Now, you can imagine when we combine this with I, um table, how interesting This can all look. Okay, So let's do that together. So let's say I'm just gonna go the last name I'm gonna put in the age We did this in the previous one, but I'm just going Teoh, do it with you as well. We're gonna put this right over here, and so you can even in Sirte a I'm gonna go down over it and even in certain shape, to go around over here and make this make the shape orange and bring it right in there. So you're you're highlighting specific people. You're highlighting specific information, and that is really what I've been trying to show you. End this particular lecture. I hope to see you in the next one. And I hope you're enjoying this class thus far.