Tables in PowerPoint - Learn How They Work and Design Better Ones! | Andrew Pach ⭐ | Skillshare

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Tables in PowerPoint - Learn How They Work and Design Better Ones!

teacher avatar Andrew Pach ⭐, Animation all the way!

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

9 Lessons (29m)
    • 1. Introduction + Class Project

    • 2. Types of Tables

    • 3. Native Table Design

    • 4. Table Layout - Add and Edit Cells

    • 5. Using the Pen and Eraser

    • 6. Importing EXCEL data

    • 7. Designing a table Pt. 1

    • 8. Designing a table Pt. 2

    • 9. Final adjustments

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

Everything you need to know about table usage, importing and designing with help of PowerPoint. I will show you how to import tables from Excel, types of tables and how to customize them.


I am going from basic to advanced, touching all important topics:

  1. How to add a PowerPoint table and edit it (basic)

  2. How to import and utilize EXCEL tables (intermediate)

  3. How to design a custom table like above (advanced)

The final boss of this class is the design you see above - we will design together a high quality PowerPoint table!

Meet Your Teacher

Teacher Profile Image

Andrew Pach ⭐

Animation all the way!


Hi! My name is Andrew Pach, to my friends known as 'Nigel'! I am an After Effects / PowerPoint / video / graphic design junkie eager to teach people how to utilize their yet uncovered raw design talent! I run a YouTube channel called "andrew pach" which I do with absolute joy and passion. Here on Skillshare, I would like to share interesting, project-based classes that will make your design workflow a greater experience.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.


1. Introduction + Class Project: no tables. They do not always look pretty, but they felt a certain role in design in power point in presentations. So we definitely have to talk about this topic here. In the few lectures, I want to show you how they are important, how they are created, how they are designed. So let's head over to power point right away, Inside of power point In a couple of lectures, I want to explain to you how to create power point tables, how to import data from excel. And last but not least, how to design a professional appealing table in power point from scratch. Remember, if you have troubles, you can always download my resources and preview both the Excel data and the table I've designed. Once you're finished with your design, please head on. Do create project to finish this project, simply make a screenshot off this table. Once you have this file, please upload it. Here, give a title. You can also upload it here by selecting image. This is it. This is what I want you to complete in this class. Let's each other inside 2. Types of Tables: Hello and welcome into this first lecture about Power point tables where I want to show you four ways off inserting a Power Point table. Now we have to start with the basics. The basics are we can insert a Native Power Point table by going toe insert and on the left side in Power Point. We do have table, we can click on it and you can select the size of a table, which will be inserted to Power Point. Don't worry, it can be bigger than that. This is just an example from Microsoft to make it a very quick and easy to use, so we basically click on it. And we have this native Power Point table inserted right away where we can fill out information. Number two will be copying a table from Excell straight away. I have prepared a simple Xel file, and since people very often do work with excel when it comes to data or have larger spreadsheets, sometimes you can quickly grab a table control, see and control V it into power point. This is how the quickest way to import an Excel table more about that later, another way off, inserting a table also from Excel is by going to insert and we do have an object here. Do not worry if you cannot find this Aiken because if your screen a smaller power point, will resize this Aiken to be only this small item, As you can see, it invites items. So what we do, we click on this object we select create from file and we simply give the information about the file. In my case, this is example Table one. I can either link it or not about Axel. We will talk a little bit later. I just want to show you basically a few waves off inserting a table. All right, so this was number tree number one, number two by control C and control V and number three by insert object number four That, like, more appealing way off doing a table is to create and design a table from scratch. And I'll show you all the ways of creating a table in the few upcoming lectures. Let's go to the next lecture, where we slow. We will talk about how to design and how to change those tables and power point. And then we will slowly move towards this little design that which we will complete together. See you soon 3. Native Table Design: in this lecture, I went to look with you. At what options do we have when it comes to designing? Now I'll insert table and insert a basic Power point table. Now I don't want to say that this is ugly, but this certainly isn't pretty. What do we have at our disposal to change the design and look off this table at first? Finally, also, the PowerPoint templates seem to be feasible and viable because they look pretty good. I personally especially like the light ones because they do not have overwhelming design and overwhelming colors like, for example, does here. So I will choose a light layout just so it's easier for my eye. Once we click on the table, you can notice that here, as usually in power point, we find table design and layout. Depending on what we select, we always have those specific options. At first I want to quickly talk about the table design. Personally, I do not use those because I prefer to design my backgrounds and coloristic myself. But if you want it to be very, very quick, you can add a total road. At the end, you can make the roads bandit, so every second row will be colored. You can add the first column, the last column and bandit columns also here. But if you do not want to use those options, that's fine. You will get a clean, normal table, and you can always do this by hand. Let's say that I want to color the first horizontal and vertical row. I simply select this. I go to shading and I select my desire, shading my desire. Shading will be, for example, light or darker orange. Now I also celebrities and I just click on the shading if I want additional elements to it . I also give it a border by opening a border and selecting out site borders, as you can see very quickly. Or I can go one by one border border, border, border order Very quickly. You can achieve a design like that without any hassle and much work by default. You can also add effects, but to be honest, the beveling effects on tables This looks very old school, and I do not recommend using this. If you are not 100% certain that you want to highlight one element and you want to bevel this one element. This is all I wanted to talk about in the first lecture. In the next lecture, we will follow up with the layout because it's very important. What can we apply to a table and its layout now? It will be your job. Police, open up our point. Please create a table and please enter table design and click around with all the options you have here. This will not take you much and you will understand better what's at stake here. You can leave out the pen pen tools because I will show you the pencils in a moment. So let us see in the next lecture want to click around a little bit. 4. Table Layout - Add and Edit Cells: all right. We have this almost pretty table here in Power Point, and I want to show you what's very important is the layout options. This is very important because if we have a table like that, look at this. We can very easily select an entire row and press delete. Also vertically. We can press the lead, and we will shorten this entire table with ease just by clicking backspace or delete delete . This is very convenient, but what if you want to enter tables and change its design? It's also very simple. You can either go to the late option or want your click it inside a cell. You right click and Power point will give you a shortcut. Here. You can very quickly insert a column to the left to the right, insert a row above or answered a row below another way off. Adding those roads is by pressing tap on your keyboard. Typing, typing, typing. It will automatically add those Roath. What is great here that we can either do this year or go to the layout and simply insert insert, insert weaken split cells if you want. For example, this cell Toby too little cells. We just click here to split it into two Boom. And we have two columns and two cells out of this one. Well, sometimes it's a bit difficult. Well, we rarely will need such a small one. But as you can see, it is possible. We can also click on this and drag it to the left to the right. If there is the possibility in space to change the position and size off any given self, the next very important thing I wanted to show you here is if you have more text, for example, you have some text here and now this would look very, very weird. Luckily, there is another solution for that in power point. If we select this text, we can not only center the text like we do, usually with text, but we can also center the position of the text when it comes to a table so we can center it vertically. And as you can see, it was brought to the middle off this table. This is great because if we design the table, we want everything toe look very clean. We do not want toe always, always everything to be like a line to the left side, and this doesn't look any good. Of course, the data which I inserted now looks also very ugly. But because this is just a string of letters, but you get the idea. It's very important that when you click on something when you are inside the table and inside the layout design, you can change the position off text. All right, The very last thing I want to show you is how to use the pen. So stay tuned until the next lecture and let's head over there together. 5. Using the Pen and Eraser: this will not a long, but I had to do this in a separate lecture. Once we do click on the table in the table design, we have the pen. We can change the pen Akal or Or we can change the pen thickness. And what's most important, we can click on draw table. And now look how depend works. Please focus yourself on my mouth. I have selected the pen collar Toby Red. Let's maybe make it yellow, so you see it better. If I click here, you can start to see a selection, and if I drag down the selection, I'll color this entire element with the pen I can very easily recall or a table what you can also do with the pen. You can split cells. Do you see this little mark? So see how versatile a pen can be. We can either change the table we can either recall or a table. And what's great here that you can recall Onley certain elements of a table, and that's absolutely beautiful when it comes to coloring borders. If you want to color those elements, you're using shading, but if you want to color the borders, you are using the pen tal and want to click here on the draw table again. We are de selecting the pen, and it is no longer at use. Now let me move the table a little bit to the site. Another great feature of the pen. If you click on the table, we go to draw table and we can draw absolutely custom tables clicking on this table that miss, like draw table. And it's very important if we are inside here and start to drag, you can see again. This line appears now it's a bit difficult. You need to really watch closely if you are creating a new line because very, very easily you can sometimes create a table over a table over a table. And this is not what I wanted. I wanted to create a new cell within this existent table, so you need to very carefully look. How the hell did little lines appear? It's a matter of training a little bit with it. So if I go to your table and I start inside here in a click and direct, you can see this line will appear. So now I will create a new line. And let's just say that I want only to have this one little cell and then three cells around it. I just used the razor ID lead this. I delete this gate right now. I would have a table like that. The only problem is Power Point doesn't recognize this exactly as being one cell, because it's in a different roads that I can start to type here. I can continue here, and it would appear as this would be one connected table and this will be another connected cell. I mean, Selna table. Please do consider. We do not always have to use the pen because many off the things we want to do can be just done by, for example, selecting those arose on going to table design or layout and just emerging or splitting them. For example, If I want to merge, I do know you have to use the razor. I just select everything and I click on merge. But we can do the same with the pencil and the razor, and it's up to you which tool you want to use with, which is more convenient for yourself. In the next lecture. I want to a very briefly talk about Excel. And what's the difference between an Excel table and the Power point table and why do we often use it? So stay tuned, please get over to the next lecture and then we'll go to the designing section. 6. Importing EXCEL data: hello and welcome. Finally in the actual Power Point lecture, how do we import it into power point? Well, the simplest way is to select everything Control C and control V straight into power point now. But watch here. This is something very important. We have the paste options. When you go to home, let me show you. We have the paste options and weaken paste using the power point style we are using currently. But we can also keep the source for mating straight from excel. It's rarely that we have cool design in excel but sometimes the design is pretty good. If I would have a white background, this would look very solid and decent, so I might want to consider keep source for mating. What else? There is embedding the entire from Excell And this is also a great way because as you can see, I cannot edit the element but I can double click and it will open the real life Excel spreadsheet And I can change everything I want here and I just dis elected and it will go away. Other options is to pace it s picture. If you are for a certain that you will not use this anymore. And you only want a picture off the table. Also, we can keep the text only This is if you want to design the table by yourself. You only want the text quickly. Eso No This is like one books with text and we can very quickly like for example, I want to Canada. I just take this in this data. I place it somewhere and I have this plain and simply on a separate text object. It's very, very convenient as you remember the second way off importing in Excel data waas insert object create from file Let me import the example table and you can read the result here if we inserted like that inserts the content off the file as an object into your presentation so that you can activate it using application that credited it So you can activate this table now with this Little Excel spreadsheet. But there is another way. Let me delete everything because it is getting a bit crowded here. Some people do like only the view off real axle, and this is what the Microsoft developers prepared. You can object create from file and just browse the file you were browsing and just browse the file you're preparing and you can link it when you link it. Oh, it it copied some unnecessary elements. What's different here? That you can double click on this element and it will open the actual table. Now let's say that I press 1000 here. You can see it. It Ah, it's corrected now and you can see I have 1000 here. What's also very important. This Xel file would be now Safed. So if if if I close this file I do not want to use this file anymore, I double click on it. It's opening Excel. You can see it has the old data. But I can't. For example, press 101 100. I can save it and they can close it. You can see we have the two values that two new values. I entered the 101 100 values and want you double click on it. Now I have saved this file. So I am really life working on my Excel spreadsheet. So I do not have to consider. Is my spreadsheet changed, is it not? Yes, it will be so remember about the link function when it comes to Excel spreadsheets, all previous tools, common hand. But this is not a table Now. This is a shape because we are linking it. It's not considered to be a native power upon table. So this is maybe the downside, which we want to consider because we have no less options to change it. Of course, we can change the background a little bit, but there's a lot that we cannot do. So consider that when working like that when connecting in linking elements between PowerPoint and Excel. So I prepared a very, very brief conversion. What and when? If you want a table just to be usable and just to give information, use the Native Power Point table or the Excell imported table. It can be even linked. But if you wanted to look a good look really outstanding and original, you might want to consider designing it. We can now head over to the design part and create together a nicer looking table like this 7. Designing a table Pt. 1: Finally, now comes the design part. How did I design a table like that? With the exact same later I showed you previously. The only thing I had to search prior was a picture. Since we already have this color, I just stick to it. I went to the Web and I used on slash dot com and I simply type in data. Some pictures appeared. I selected this picture and I was even too lazy to download this picture. So I just right click copy graphics. I went into Power Point. I moved away because he wasn't sure that if I will use this and oppressed control V once I had a picture in Power Point, I went toe picture format and to crop. I knew that I want the picture toe fill my entire screen no matter what happens later because I wanted to have a nice background. So I resize the crop I went to crop and I selected filled perfectly. Power point has filled my entire object. Now I was thinking about the table and I wasn't sure if it will take the entire slide or just half of it. But usually you do not want such a big table. So I took this text and I simply turned it around. It snapped in with 90 degrees. The picture needs to be right click and sent to back To make everything a little nicer. I pressed insert shapes and I started to create some shapes. At first I wanted direct angle on the left side. Okay, Perfect. Let's create it for the text again. It gets in the way off the text, but we can adjust this later for the shape. Phil, with the eyedropper I clicked and I select the color from the previous slight. So this was the color for the shape outline. I, of course selected no outline. Let me bring the text back because I want to see it right Click on the text, bring to front. Now I can take the element and I can position it into the proper place we had here something like table title or it can be anything. All right now, Actually, I wanted to create like, the main element for the table and this was super simple. I went to insert shapes and I chose a rounded rectangle. You can do the same. Please do around the direct angle. Create around to direct angle for approximately the amount you want, the table toe be filling the screen. And with this little yellow up, we can adjust the roundness off this rounded rectangle. This is the entire beauty off this design shape. Old find again. No hotline shape, Phil. I went for one of the standard. I believe it was this bluish darkish one or a dark one. You can decide for yourself. Let me go for this bluish one like this. It's called Blue Grave. My greeting. This made this entire design to flat. It's like nothing is going on here. So I clicked on this object once again in its shape effects. I went to shadow and since I do not always like the basic shadow I went toe shadow options . Farpoint opened for me the form and shape. And in the second option in the shadow, I had first selected a simple preset And then I adjusted the Blur to be bigger. As you can see, the Blur is starting to race in this entire shadow. I made the Blur to about 30 or 40. And then I worked with the transparency, the less transparency, the more the shadow is visible. I wanted a strong shadow, so I just stayed with, like, 30 or 40% of transparency. And the blur about this size should be right now. I was convinced this is a very, very nice background for my table content so I could finally bring the table content itself . So this will be the base for this design, which I want you to create a swell. And in the next lecture, we will slowly, like, finish up this design by populating it with the actual content and by following up with some minor adjustments to make everything look a little bit better. So stay tuned. Let's it over to the next lecture want you have created that use any picture for the background and create a big, solid object to be like the main beef off the slight 8. Designing a table Pt. 2: This is a beautiful moment in this design because we are almost ready with everything and it will go very smooth Right now. I go to excel and I copy my table control C Control V. Now, as you can see, it doesn't look much appealing. A. To this point, I want to delete the absolutely crazy road you can see. It's not easy. I go to lay out the lead delete roast boom! It has gone away. How we don't want this color. We can either make it transparent or make it the same color as this one Cyprus shading. And because I'm lazy, I just take the same color and I am close to being done. We have this native table and we are still like, not satisfied with what's going on here for the text I want to select White, and now I do really see what's going on. What's happening? What needs to be changed. And as you can see, I can very easily precise everything. What I've done is what we've learned previously. Well, I select everything. Layout center center. Okay, it starts to look a bit better. I want to give it a bit more space. And I want to use the same fund that we used here. In my case, this was Gilroy Extra Ball and Gilroy Lite. Sorry to select I Goto Gilroy. Hello. Gilroy again. Hello. Gilroy and I make it slightly bigger. So I really see what's going on here. As I made, the bigger it started to, like look like a normal design. Maybe this first line was a bit too big. Okay, Perfect. Also there. The rest of the text should be selected and changed. In my case, this is Gilroy right now. So I know those two phones complement each other. We have the majority off the design done, but we have still those bar odors. I do not like those borders. So I go to table design borders, and I simply select no borders because I do not want them. We can, of course, decide to have them. But actually, do we need them? If we use those nice colors, maybe make those a little bit bigger. I know a shortcut which is control and right bracket key to make everything bigger, and it instantly looks a bit better. This has made this entire design possible now it's very simple. If you, for example, would like to highlight those, you can select them. You can go to table design and two shading. You can do any color you want, for example, even black and what's important here you can go to form and shape, so right click former shape and you could work a little bit with the transparency. So right now it's very black. I can select all those rows by clicking and dragging down, and I can make them a bit transparent. So now what? This black wouldn't be s strong as apparent and it would blend better together with the design. Basically, I will leave this design just in the next lecture. I want to show you what I've adjusted to like give it the last little tick to the last little design to make it light more consistent and give it the last little flare. Let's head over to the next lecture and we'll finalize this design 9. Final adjustments: What I did now is just a design adjustment which I felt will complement this entire design . So I went toe insert shapes and I inserted eight rectangle shape. I wanted to give this some kind of flowy background like here. So what I did, it's again. Shape, bold line. No old line shape Phil radiant and give it an ingredient. It will make it a bit quicker, right? Like former shape toe. Open the right panel with form and shape. And once you see the Grady int, I made eight to color. Radiant. One color was, of course, the red and the second color. Well, since we used this this kind of color, that's just use this one. You can see where I'm going with this. I selected the first color and I used a bit of transparency, and I selected the next color and gave it another part off transparence. Of course, I do not like the angle. I want the angle to be straight from top to bottom. So I just went to the direction and selected top to bottom. Right now I need toe right click sent back and on the picture as well. Right? Click sent to back because if we sent something to back it sent entirely as the last object . As you can see, it's like the matter off a personal preference. We can adjust the transparency levels and we can, like, tinker with the entire design. We can also move. How much off one color do we have in compression with the second color? The second thing I adjusted. I gave it a small like overly. Here I take this existing object control de because I owned those objects to be the same. I am aligning them over each other. Ingredient Phil and I am adding to white collars The first color transparency like 70% the second color, 100%. And we can no play with the angle and give it a very unique overly. If you'd not exactly like this overlay may be able to change the direction to like going from the corner. You can always direct click on this element edit points and I can delete a few points. Maybe like this, I can delete this point who I wanted to be like this like a more straight oven edge boom. So I created this very original overlay. This overly doesn't have to be so strong. I can give it plenty of transparency. It can be like 90 92%. It is just here to give it like that last little touch and basically we have now to off the same designs with a bunch of different colors. I only added this little element to, like separate the title from the actual table. But if you do not want this, you can also delete this element you can. I can select this and I can place this table. For example. Here I have two completely different designs. Both look great and both would be easy to replicate. And this is how I go and approach about designing a custom table. I designed the custom table, and I add some little flowy elements to it to enhance the initial design. I do hope this entire section is very helpful to you. No matter if you use tables or not, it's something worse, knowing when it comes to apartment and overall presenting skills