PowerPoint Business Presentations - Data Visualization and PowerPoint | Andrew Pach ⭐ | Skillshare

Playback Speed


1.0x


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

PowerPoint Business Presentations - Data Visualization and PowerPoint

teacher avatar Andrew Pach ⭐, PowerPoint, Animation & Video Expert

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

    • 1.

      Introduction

      1:22

    • 2.

      Resources and assignment

      1:21

    • 3.

      01-01. Warm-Up

      2:52

    • 4.

      02-01. Header

      1:28

    • 5.

      02-02. Body

      1:44

    • 6.

      02-03. Footer

      1:49

    • 7.

      02-04. Guttenberg Diagram

      2:20

    • 8.

      02-05. EXERCISE

      2:59

    • 9.

      Leave a Review, Please

      0:32

    • 10.

      03-01. Action titles

      2:56

    • 11.

      03-02. Examples

      3:59

    • 12.

      03-03. What are they for?

      2:12

    • 13.

      03-04. Blueprint

      2:18

    • 14.

      03-05. EXERCISE

      3:59

    • 15.

      04-01. Pyramid Principle

      2:04

    • 16.

      04-02. Examples

      2:58

    • 17.

      04-04. Barbara Minto

      2:04

    • 18.

      04-04. EXERCISE

      3:40

    • 19.

      05-01. Horizontal and Vertical

      2:21

    • 20.

      05-02. SCR Framework

      2:31

    • 21.

      05-03. Examples

      3:42

    • 22.

      05-04. EXERCISE

      2:54

    • 23.

      06-01. ESS

      1:44

    • 24.

      06-02. Good Practices

      2:26

    • 25.

      06-03. Framework

      1:57

    • 26.

      06-04. EXERCISE

      4:14

    • 27.

      07-01. MECE

      2:08

    • 28.

      07-03. Graphical explanation

      1:59

    • 29.

      07-02. Examples

      2:38

    • 30.

      07-04. EXERCISE

      2:10

    • 31.

      08-01. Types of charts

      3:41

    • 32.

      08-02. Chart Basics 1

      3:32

    • 33.

      08-03. Chart Basics 2

      3:00

    • 34.

      08-04. Chart knowledge

      2:32

    • 35.

      09-01. Work with me

      0:50

    • 36.

      09-02. Clustered column

      4:22

    • 37.

      09-03. Stacked column

      3:55

    • 38.

      09-04. Line Chart 1

      3:27

    • 39.

      09-05. Line Chart 2

      2:59

    • 40.

      09-06. Pie Chart

      3:57

    • 41.

      09-07. Bar Chart

      3:14

    • 42.

      09-08. Area Chart

      4:17

    • 43.

      09-09. Stacked Area Chart

      3:29

    • 44.

      10-01. Map (Office365)

      1:48

    • 45.

      10-02. Map (Template)

      3:00

    • 46.

      10-03. Waterfall

      5:50

    • 47.

      10-04. Combo

      3:38

    • 48.

      10-05. Pictograph

      4:01

    • 49.

      11-01. w3.org

      2:28

    • 50.

      11-02. Accessibility

      2:25

    • 51.

      11-03. Subtitles

      1:57

    • 52.

      11-04. Reordering and Alt text

      2:21

    • 53.

      11-05. Contrast Checker

      1:41

    • 54.

      11-06. Contrast Checker online

      1:36

    • 55.

      11-07. Color Blind Safe

      0:59

    • 56.

      12-01. Master Slide

      3:57

    • 57.

      12-02. BG Graphics

      2:13

    • 58.

      12-03. Layouts

      3:36

    • 59.

      12-04. Guidelines

      2:41

    • 60.

      12-05. Footer

      2:39

    • 61.

      12-06. Font

      3:58

    • 62.

      12-07. Color Scheme

      3:30

    • 63.

      12-08. Layout 1

      3:59

    • 64.

      12-09. Layout 2

      2:59

    • 65.

      12-10. Layout 3

      2:35

    • 66.

      12-11. Layout 4

      3:02

    • 67.

      12-02. Save Template

      1:45

    • 68.

      13-01. Topic

      0:58

    • 69.

      13-02. Storyboard

      2:46

    • 70.

      13-03. Title

      3:46

    • 71.

      13-04. Statement

      3:13

    • 72.

      13-05. Slide 3 Text

      1:27

    • 73.

      13-06. Slide 3 Chart

      3:48

    • 74.

      13-07. Slide 4 Left

      3:59

    • 75.

      13-08. Slide 4 Right

      2:16

    • 76.

      13-09. Sections

      0:58

    • 77.

      13-10. Slide 5

      3:15

    • 78.

      13-11. Slide 6 Table

      3:47

    • 79.

      13-12. Slide 6 Text

      3:37

    • 80.

      13-13. Slide 7 Table

      4:40

    • 81.

      13-14. Slide 7 Text

      3:31

    • 82.

      13-15. Appendix

      2:23

    • 83.

      13-16. Thank You

      1:54

    • 84.

      13-17. Simple ESS

      3:46

    • 85.

      13-08. Advanced ESS

      3:59

    • 86.

      13-09. Slide Sorter ESS

      0:41

    • 87.

      Thank You!

      0:28

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

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.

213

Students

3

Projects

About This Class

This PowerPoint class teaches you how to prepare high-level business presentations.

I divided the class into several larger chapters for a coherent learning experience

At first, we dive into business frameworks like MECE, storytelling, executive summary slides, and how to write Action Titles to prepare a base and teach you important rules of thumb to follow for a great presentation.

After that, we practice how to visualize your data in PowerPoint to get you up to speed with all the tools and tricks used when creating exciting presentations.

After that, we will work on a PowerPoint Template from start to finish, including preparing layouts, selecting a font, preparing a color scheme, and finally saving that template directly into PowerPoint for future usage.

At the end of the class, we will make a real business presentation. Using all the frameworks we learned, data we managed to visualize, and templates we prepared for ourselves.

Join me on this incredible journey, and start watching the class!

Meet Your Teacher

Teacher Profile Image

Andrew Pach ⭐

PowerPoint, Animation & Video Expert

Teacher

Hi! My name is Andrew Pach and if you want to learn PowerPoint you are definately in the right spot! To my friends I'm 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. If you look below you can select any of my PowerPoint classes to learn from them!

See full profile

Level: All Levels

Class Ratings

Expectations Met?
    Exceeded!
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%

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.

Transcripts

1. Introduction: Are you looking to learn or increase your skills with charts and business presentations in general, then you are in the right place. Welcome to the PowerPoint presentations and data visualization for business professionals class. Here on Skillshare, a detailed guide on creating business presentations. Our main software will be PowerPoint, but the knowledge, especially the business principles, apply to any presentation software you work on. My name is Andrew, No, not James Bond. And I will be your instructor within this class. To make this the best learning experience possible, I divided the course into three comprehensive chapters. At first, we will barely open PowerPoint because we need to learn principles and frameworks like how to tell a story or write titles. After that, we dive into data visualization, where we will go over several charts together. After that, we will apply all the knowledge we've collected to create a real business presentation. Not only that, I will provide resources, so you can work alongside me every step of the way. We will waste no time. If you want to become a better presenter and storyteller, start watching this class. See you inside. 2. Resources and assignment: Hey, hey, hey, welcome. It's nice to see you here. If you want to download the resources, just click on the Project and Resources tab. Select resources here on the bottom, the version may change, but the resources will be always available here. The zipped package needs to be unpacked. You can simply on Windows extract on Mac, you can do similar. Once you have that extracted, you basically have a set of PowerPoint files to work along. Good luck and have fun. It would be amazing. And you can help me on Skillshare by starting a product for this class. Nice. At first, it doesn't have to be ready. Product is go to the Project and Resources tab. Hit on Create Project. And right, You're welcome message. Later on when you create a slides from the lectures, you can share a screenshot of that slide. You can do this by going to File Save As Selecting Browse. And you can select to save as a JPEG there. By saving JPEG, you can select all slides are just this one. Then you can come back to the project, select Image and to just add a slide that you created. I will be really happy to see it and it'll also be very helpful. Please start the product right now. It will take only a few clicks and helps me a lot here on Skillshare. 3. 01-01. Warm-Up: Welcome. In the warm-up lecture within this course, you can use the resources if you download them. As you can see, you can just open PowerPoint and do the same. At first, I would like to show you how to set a shortcut and set something to default within this course. Later on, we will work a lot with charts. The charts feature is on Insert chart. What you can do to make your life a bit more convenient. You can right-click on this feature and simply select Add to Quick Access Toolbar. This listen to feature has been added here on the top as a little shortcut. Anytime I'm working in PowerPoint, I can just click here quickly and I can insert a chart right away. Let's go one step further. Let's say that you have a project and within this product, you are using a lot of bar charts. You can go to the bar chart directly. You can right-click on the chart and set this chart as default. Now, whenever, whenever you click on the Insert Charts feature, the bar chart will be already pre-selected. Pretty cool, huh? It can save you a couple of seconds and a couple of clicks. What I also wanted to mention, this Quick Access Toolbar on the Windows version, you can press your left Alt key and use further shortcut to recall to any function, e.g. the new function I added in my case is 0c0c. And I could insert a chart. This, as I'm aware of, doesn't work in the Mac version. I hope it will be implemented in the future. But in the Mac version, you can right-click customize. And I recommend setting the toolbar position instead of above ribbon to set it below ribbon. Also please deselect this. Always show command labels. So we have more space for shortcuts. And this way, those shortcuts would be a little closer to your mouth. Do you want to see something else? If you introduce shape in PowerPoint, e.g. a, normal rectangle, it is always blue and has an outline. I really don't like to outline what I often do. I go to Shape, Outline, not outline. You can even go to Shape, Fill and give it a different color. You can right-click and set as default shape. Right now, every time you insert something like insert a shape, it will be yellow and it will have no outline. This could, again saved me two clicks. This is a little warm-up. Those are quality of life improvements. I wanted to show you within PowerPoint. I hope this course will have a lot more to offer, especially regarding business presentations. But saving your time is a crucial thing that you should consider doing. Thank you very much for listening to this lecture. In the next lecture, I would like to start the business part of the course and explain you a lot of frameworks that we will work on and built upon. So stay tuned. Let's go to the next lecture and see you there. 4. 02-01. Header: I'm extremely happy to be opening this course. First things first component of a good slide. You may think, why am I telling you about such simple things, like a slight header. Apart from the very first slide in your presentation, that may be an introduction. Most of the slides in your presentation will contain a title, maybe a subtitle, and an additional lead into the story of your actual body content. But the header area will be usually placed at the top side of your slide. It's important that you know why, Because this is the first area that the viewer will see and probably read, especially for business and consultant presentations. It must represent the main idea of the slide itself and direct the reading flows of the slide. What I mean by that, it should essentially summarize the content below and orchestrate its narrative. Speaking of orchestrating, if I would compare a PowerPoint or any presentation slide to an orchestra, the title would probably be the conductor itself. It should navigate, lead, and paint the story of the slide and what is coming next. Hopefully you will like this example because it will help us to visualize the hierarchy and importance of different sections in a slide. 5. 02-02. Body: After the slide header, naturally comes this slide, the body, the main area where you put your content in. Let us put this into perspective with an example. We are still talking about Philippines, 50 largest island accumulate 99% of population. This is a very quantitative way of building a title. I give here strict data, 50 letters, island, 99% of population. Then a bit more descriptive, subtitle, highest expansion. It's so difficult to pronounce for me highest expansion potential in two biggest islands lose on n Mindanao. This is my slide, elite in my title. And here I'm supporting this with factual data. But what if on the right side, I would give a completely different topic, not related to the title itself. Explaining an extremely popular tourist island. This would be an incorrect move when it comes to a business presentation. A business presentation and the business slide should communicate one insight per slide and choose a simple method to do so. As I mentioned, the body should relate to the title. I know you like the orchestra example. So if your header area contains a title, it will be your conductor. Then the body area would be the orchestra that relate to what the slide tells them to and what the orchestra seats. They are separate, yet correlated, and cannot exist and properly work without each other. I think you understand the magnitude of this and slowly, some things are starting to click together when thinking about making business presentations. Let's continue. 6. 02-03. Footer: The footer area can be found on the bottom of your slide. When we say footer, we usually think the date, the company name, the page number. Because basically PowerPoint did teach us that it's a correct approach. If we go to Insert, there is something called Header and Footer. Without adding additional boxes, you can always click on the header and footer. You can add a date, you can add a slide number. You can add basically some further information like that. You will apply it and it will showcase in the slide. But there are two additional things for business and also different usage. It contains sources and additional footnotes. What's also important? I'd say that it usually is detached from the body visually and in smaller lettering. So it doesn't get in the way because this is more of a peripheral area. If I would go back to my Philippines example, a footer area would look probably something like that. I would cite the source where I took this data from. It would be smaller and maybe in a different color or not. That's completely depending on the design itself. I know that you are probably waiting for the opera example. We have the header with our conductor. We have the actual opera with the main body. And we have the supportive footer area on the bottom. For an orchestra that may be additional instruments where we could put instruments that aren't played throughout the entire of the play, but they are still vital to its completeness as a whole. You couldn't just skip the part where the harp or the triangle is played by maybe an additional person that will go from one to the second instrument during the play. 7. 02-04. Guttenberg Diagram: An extremely important topic that correlates the components on the slide is the Gutenberg diagram. Let's start with a simple definition. It describes the general pattern the eyes move through when looking at evenly distributed homogeneous information. Now, let's read that last part again. Homogenous means equal. And this is why I emphasize to have one key argument or statement explained on one slide. It also helps the viewer to understand the topic. This is our example slide, like we already know it, divided into four equal pieces. The Gutenberg diagram explains these areas, this for equal areas as the primary obstacle area, which is the main point where you start the viewing. The strong fallow area, where on the far right side it starts to fall off. And you are going to the next piece, the week follow area also falling in the corners and the terminal area where you probably will end up reading as the reader. The Gutenberg diagram also explained the reading gravity gravitating from the left top area towards the bottom. The pattern itself suggests the eye will sweep across and down the page in a series of horizontal movement called axis of orientation. Each sweep starts a little further from the left end, moves a little bit closer to the right edge. It suggests that the strong and weak fellow areas fall outside the reading gravity path and receive minimal attention. Unless, of course, emphasize enough. If you make a big red footer and a big red logo on the top side, someone will see it, but that isn't probably what you want. If it would be to draw how a normal person who watches the slide, it would be probably something like that. You would sweep across from the top-left side towards the bottom right side. This is why it was so important to understand the components of a slide. First, before I show you the Gutenberg diagram, that can already gives you so much information about how your future viewers will see your presentations. Based on that knowledge, you will only start to craft better presentations. 8. 02-05. EXERCISE: There will be a PowerPoint file with different exercises to perform. Let's perform the first one based on what we've learned about slides structure. You already know what this is, what this is, what this is. If your different elements below the slide, I want you to pause the video right now. Take individual elements and placed them on this slide where you think they should or could be a tension. There is no one correct answer to this. Just go with your gut feeling and take e.g. the logo and decide where would you probably put it. After you put everything that is on the bottom, you can unpause the video and I'll walk you through how I would consider doing this. Pause it now three weeks later. Or if you are not doing the exercise, Let's preview what I would do. I would consider taking the logo on the top side or the bottom side. The bottom side, if this would be a consulting presentation where I would be confident, highlighting my company on the top side where I want it to be, it a bit less prominent. Since this is a terminal area where the viewer will probably watch at the end. If your logo is not that important at this point, it can be on the top side, the title obviously will go into the header area. The subtitle will follow the title and go into the header area as well. The placement isn't as important. It's just an estimate. Now the sources I'm going one by one. The sources would be in the footer area or under the body. I would put the sources approximately here. Let's go to the body tags. The body texts would be on the left or right side, depending if this is a key insight or something that I wanted the viewer to read first, the viewer will probably see that first. I will take the chart and I'll put the chart itself. Let me probably click on it, the chart itself on the left side, because on the right side I have the supporting ideas that explain the data on the left side, and this would be my basic layout. The date and page number can be wherever you desire, probably on the bottom. It could be also on the top area. There's no one right answer to it. You could just as well putting it here. But for the sake of the default design, I would imagine that the page number and date would be probably on the bottom right side. They currently don't fit. I made him a bit too big because they are over-explain. This is how a basic regular business presentation slide layout would look like. I can preview the slide and I think everything looks correct here. I hope you had the same idea or approximately the same understanding of what to put where. We will close this segment of the course with this exercise. And I can't wait to continue because there is a lot of cool stuff more to come. See you there. 9. Leave a Review, Please: Hey, it would be extremely helpful for this class if you go to the Review tab and click on leave a review and write something there. If you don't see this button yet, you need to watch a few more lectures and it will become available. Sculpture now requires that classes have recent reviews on them. So it would help me greatly. You just click here, you tell if you'd like to class or not, and you write a simpler view and click Submit. I would be very obliged if you can do this right now. Thank you so much and see you soon. 10. 03-01. Action titles: Let us talk about action titles and why are they called action titles? And instead of just regular titles? Well, action titles are supposed to be one-sentence summaries that allow to understand your entire slide and it's key insights. An action title is supposed to answer the question. So what? When someone sees your slide and read squat on it and asks, so what the action title, she'll give him an answer for that. Let's use it on an example. We have a product called funny shoes. Instead of using a regular title like funny shoes, market shares, without any deeper context, an action title would sound more like market shares of funny shoes grew by 6% in year. Why? I'd even scratched the by and just leave six per cent in given year. You want to make it as short and concise as possible. This can naturally create some healthy anticipation and understanding of your entire slide. Do you remember that Gutenberg diagram? If we take a step back and look there, naturally, action titles will be of course put in the header area. And now you already know why because the header area is the primary obstacle area, the first place where you viewer will watch and try to read something. An excellent title shouldn't be longer than two, maybe three lines. It depends, of course, on the topic and what you are describing. To summarize what I've said, the desired situation would be when your presentation could be understood by just reading your action titles. Later on, I'll teach you about storytelling for your entire presentation. So you will get back to that little trick can be putting dots before and after your title and what this title flow nicely into our next slide. Let's answer that. E.g. market shares of funny shoes grew by 6% in this year, keeping this year over year growth can place funny shoes as market leader with 30% over all share. This would be an example of two action titles on two different slides that continuously tell a story of your presentation. Another example, instead of just world revenue growth, I'd probably put a title like revenue has grown 31% over past five-years. Asia being strongest contributor because just world revenue growth doesn't say anything if I were to ask, so what this title wouldn't answer it? Action titles wants to summarize everything you've put on your slide in one sentence, let us go through a few examples to explain a couple of concepts about this. 11. 03-02. Examples: Let us look at a couple of action title examples. Usually action titles wants to have some data already built into it. So the key statement is easier, understandable, but not always here, e.g. this is an action title that says, the biggest online platforms have user basis on par with the populations of the world's biggest countries. A really intriguing and interesting action title doesn't reveal the data because the data is not important. The importance here is that this slide, the person who created, wanted to say that platforms like Facebook, WhatsApp, or YouTube have such large, usually basis that they are almost as large or even bigger than the population of countries. A beautiful way of utilizing action titles to write a compelling story for your slide. Let's go to another example in the same presentation. It's an older presentation, but the data doesn't matter. Here, a completely different approach. You can see how the person who created this presentation plays around with data and with interesting descriptions. 50 million small medium enterprises use Facebook to find customers and 30% of their fans are from other countries. We have clearly quantify the data. 50 million businesses use Facebook. And the second part, 30% of the refunds are from other countries. And then we have two supporting charts that support the claims told in the title itself. Beautiful way of crafting a business and consulting type slide. Another very good example. Approximately, one-third of business leaders plan to make decisions around the development of a new product or service by a given year. I don't need to read the entire slide more because the key statement is that over a third, over a third of business leaders plan to make decisions to develop a new product, and it is reflected in the supporting data below it. But I already know what the person wanted to say with this slide. An absolute magnificent way to utilize an action title and tell the entire story. Here, I deliberately, another difficult words for me. I deliberately chose something more difficult, a longer action title, but it couldn't be made shorter. It's still a wonderful read. Let me read it first. In January 2021, demand recovery in automotive appeared as semiconductor sales. Then it says that it was already five to ten per cent above pre-COVID levels. We have so much interesting data quantified. In this one sentence. I can't even tell you how beautiful that is. January 2021. We have precise time, demand recovery. In automotive, we have the industry and we have what actually happens. And the key takeaway, the key statement is at the end, the sales levels of semiconductors were already five to ten per cent above pre-COVID levels. That's a key insight that the person who wanted to communicate. And the chart is also brilliantly designed. There's no doubt about it. We have a red line that shows here is the starting point. And at the very end, January 2021, it already starts to grow above previous values. We can see it's five or even 10% above previous values. And other magnificent way of using action titles to explain this slide without even looking on the rest of it. Action title are partly creative, but partly there are rules of thumb you can use and I want to give you them to be able to write and start writing this type of titles. Let's see each other in the next lecture, and let's work on that. 12. 03-03. What are they for?: In this lecture, I want to explain what our action titles and why are they used in business presentations? In business presentations in general, I divide this into two parts, for the viewer and for the presenter itself. For the viewer, the person who will read or hear the presentation. At first, an action title can be really intriguing. It can peek his interests, and it can even give a provocative statement to make you think. The second thing is just reception. It can help to digest. It can really help to digest the presentation and make it much more easier for the viewer. The third thing, as you can see, you can remember my band-aid. It is an aid to the viewer. If the viewer gets lost or starts to wander off with his mind and wants to get back in your presentation. He can quickly read your action title to understand the entire slide you're explaining again. Or if it's just reading the presentation. Obviously, he can skim through the presentation by reading the slide titles for the presenter. It's also important because if you get lost at any given point, you can briefly check out your slide title and you'll get back quickly into it is two objectives. Slide title has. At first, it wants to answer the, so what question? If I just write market shares? I mean, so what is our market shares? But if I write, our company's roof tile gained a stable five per cent market share in the German roof construction industry. It's quantified an understandable that I'm telling you about roof tiles. The second important objective I'd like to highlight is can the viewer understand your slide without reading it further? That's something important that you need to ask yourself when moving forward from now on, when you create business presentations, ask yourself this question. Let's try to establish a couple of rules and guidelines you can use as a blueprint for your future presentations. 13. 03-04. Blueprint: With this lecture, I want to give you some kind of blueprint you can follow when you think about making action titles. In the next lecture, we will actually practice writing an action title. I prepared a chart with US, unemployment rate a couple of years. And you can see this chart here, I am Mark the great recession when the unemployment rate rose a little bit. Then after the COVID pandemic, the unemployment rate also went very high into almost 50 per cent. If we will write an action total of four that I want you to avoid being descriptive or completely obvious. You want to avoid a long descriptions like unfortunate events with great impact on the US economy. Instead, you would rather write COVID pandemic costs, US unemployment rate increase. It's not exactly quantified, but it's already less obvious and descriptive. Then use simple expressions. You won't write an action title correctly in the forest go. If we wrote, the great recession was an important factor in the rise of US unemployment rate. That's true, but it's a little award, It's a little long. Let's write it a little better. Great Recession impacting US. Unemployment rate. Same thing set with far less words. And even better if we would add some quantified data in business presentations, quantified data will always be a little bit more important and better seen than just descriptive explanations. Great Recession causing 10% unemployment rate. Bu Dan dot. You don't have to elaborate anything more. My last big tip would be quantified or communicate key insights. We've been over this already. But for that, if we talk about the great recession in 2008, 10% due to great recession in 2020, 15% due to COVID pandemic quantified clear data, maybe not pretty but understandable. Let give you one bonus tip. Make it read like a story because your next slide might continue telling it. 14. 03-05. EXERCISE: Let us work on an example action title you could write in your business presentation. With this supporting data, I want to talk about the second data, the COVID pandemic and the 15%. And you should start simple and just write down what you see. You will not write perfect action titles. And there is not something like a perfect action title. Right away. I would write that COVID, pandemic cost 15% employment rate. The title is really big. It wouldn't be really suitable for a business presentation. It's more what I did here for this course. But this is already a place I can work from COVID pandemic card 15% unemployment rate. I think this information is incomplete. If I help myself by adding dots here. Now, if someone would look at a different slide, then come here, then go to the next slide. What he understand this like COVID pandemic, it's almost precise. I would add the year, the year is here to 20 and it was April. In this case, it of course, requires some additional research from you, but that's why you are creating the consulting presentation while we are consulting a different person or a different company because you are doing the research and finding the data in April 2020 due to COVID pandemic. C. I can now start working on it. In April 2020, due to COVID pandemic, US, unemployment rate rose to 15%. It's almost there for myself. I think. I could squeeze in rows, 4-15% in again. And this would be it. This would be one possible way of writing an action title for this slide. In April 2020 due to COVID pandemic, the US unemployment rate rose from 4% to 15%. You, as the presenter will probably explain what happened after. But here are a couple of different examples I wrote. Like we wrote this, without looking at this end. Everything will say the same thing, but in different phrasing. Covid pandemic cost, US unemployment rate increased from nearly 4% to 50 to 14.7. I like the word increase. Instead of making unemployment rate higher, you should avoid long and descriptive words. Something like increase is a perfect phrasing for an action title. Us unemployment rate at 15% in April 2020. 2020 due to COVID-19 pandemic, 20 plus million jobs lost. I forgot to write that down. This was due to additional research I made on the topic. And it would also be a very relevant on what happened because of this. This would be the so-what? This is the big so-what? This action title would be even better. Covid-19 influenced the US unemployment rate more than anything before April 2020, almost 15% all-time high. You can see this is a more descriptive and flashy action title. I'm not the biggest fan of this descriptive third version, but you need to know your audience. If your audience requires a more descriptive version, this would be perfectly fine with that. I wanted to showcase that action titles have no one fits all solution. This is something you need to practice and find your own style. Scratch what you heard. If you can just delete this title and try to write your own. Thank you very much for watching this section. Let's proceed with the next topic. 15. 04-01. Pyramid Principle: New section, New Energy. Welcome, and let us talk about the pyramid principle. The pyramid principle literally flips on its head the way you are thinking about presentations, Let's get straight to the point where they pyramid principle. You want to start your slide or your presentation with the key statement. Then you want to give supporting arguments to that statement. And after that, you want to give additional data or supporting facts that will reinforce what you just said. If you compare that to a classic scientific way, how to build presentations and how probably most information in your life was presented to you, whether it's in a school, university, or on some conferences. At first or come. All the details, all the explanations, then some insights, and at the very end, a conclusion with a possible recommendation, what to change, what to make and what to make of all the data you are presented by. Just consider what we are talking here in this course. We are talking about Corporate analysts and business presentations that are presented. Most likely too busy clients, busy investors, busy executives. And they'll appreciate getting to the point straight away and not talking long, like me right now. Before I go deeper into this topic, now, you understand why I explained the action titles and components of a slide first before talking about the pyramid principle. Because if you look at the pyramid itself, start with the key statement that perfectly aligned with an action title on your slide. That starts with the key insights, key statement then cascades down towards some supporting arguments that try to confirm your action title. And of course, Data, Lakes, charts, and other information on your slide. Not every slide should have all three components, but it is a good way of structuring your thoughts and ideas. In presentations. Let's drop right into some examples and discuss together what we see on a given slide. 16. 04-02. Examples: Let's recognize a couple of pyramid principle patterns on a slide. Let drop into some pyramid principle examples that we may recognize on slides and they perfectly aligned with what we already know. This is a slide with a strong action title, claiming that millennials across life stages spend significantly less time-consuming traditional TV and much higher uses of online video statement. Then we have some supporting arguments, elaborative described here, and supporting data. Part three of our pyramid principle applied to this first slide. A beautiful usage of the pyramid principle. It isn't that you have to apply the payment of principal to every slide, but it helps you to prioritize what to put where with what significance and what should be there to really support your title. Beautiful. The next slide, it's a bit more tricky because here we have the main statement that global flows have ten per cent of global GDP and dataflows actually account for a large, arguably largest chunk of that contribution. Then this is the statement. Then on the bottom, we have some supporting statements accounting for secondary effects, not only dataflows. Dataflows generally influenced trade flows of the eye and even people flows. And this is all supported by data, even though by numbers, dataflows seem to have smaller impacts to 0.6 against 3.14 goods trade. But in reality, dataflows also influence other categories. This means that dataflows are arguably the largest chunk of that contribution. I love the wording, very bold to use a word like chunk in a business presentation. Really well thought out, it is provocative, yet a correct statement. Another example here, a presentation about quantum technology. It's not the topic that matters. Public and private funding continues to skyrocket around the world. With North America is still investing the most. I can understand the slide, that North America is the biggest investing player in this field, in this industry, then we have some supporting statements like the market is still concentrated in North America. Funding continuous at rapid rise and global market participation is increasing. Three supporting statements to the main premise. And then we have some data and deeper descriptions. Again, beautiful, cascading down information laid out in a understandable manner. The thing is that you want to cascade down with your information. And remember how your viewer perceives the slides and how he will read it. You need to anticipate those things and you'll be well on your way to craft better presentations. 17. 04-04. Barbara Minto: It will be almost unfair to mention the pyramid principle and not tell about Barbara mentor. She was an employee of McKinsey and their 60s and 70s. And basically, she formalized this way of thinking into the pyramid principle. She generally realized that thinking in formulating ideas wasn't great and people really didn't communicate and present their data and general statements well. So she tried to formalize it and came up with the pyramid principle that spread then into not only McKinsey and other departments, but also other companies like wildfire. At first, it was formalized in a book in 1985. It was called the pyramid principle logic in writing and thinking. Then after she collected even more experienced, she published it as the mentor pyramid principle, logic and writing, thinking and problem-solving. And until this day, decades later, it's still a very important book in publication when it comes to logic in thinking and writing and problem-solving. I don't want to make this too long. This is meant to be a homage to someone who really influenced how we structure our thinking and big kudos to that. Congratulations, If this lecture would be a pyramid principle, I will tell you that barbara mental, a former McKinsey employee, is the creator of the pyramid principle. May supporting statements would be that she published this into a book and also teach other departments, both at McKinsey and was invited to other companies to teach this way of thinking. If I would cascade down good information that you may need but don't need to. I will tell you that Barbaro mental later on Format her own company. She was invited to this, this and this company. And she held that this and this and this many public speeches. This is how you cascade down, starting with the key and most important fact. 18. 04-04. EXERCISE: Let us work on some exercises and demystify how those top notch consulting companies make the presentations. Because once you see the patterns, you will become aware that it's possible to create presentations to the same standard. This is a pretty complicated and busy slide. So the title says here, regulators must create assessment tools to evaluate the impact on real world economy. This is the statement that we wanted to get across within this slide. Then what at the bottom side of the slide, you can recognize the structure right here on the left side, we have four recommendations. This is already a recommendation slide. This is at the end of one of the sections. And here we have clearly bolded recommendations and then you have additional information that support each of that recommendations. My natural way of thinking would be that these are the supporting arguments. And here on the right side, we have additional data or additional insight that helps us to understand the entire idea of creating this toolkit. Let us take a look at a different slide. This is another business slide. And even though it has so much text, you can see how well it is organized. It has a big title, developing an adaptive pricing strategy, create an environment for growth. And this is the statement we will put on this slide. Then we have some kind of description. And right after the description, we have four distinctive point and dose will be the supporting arguments for the title. Under them, we have descriptions for each, and it isn't a coincidence. This slide uses the parent principle to use the title, use supporting arguments and additional information under it. And this is one of the frameworks you will use in your future presentations. Here you have somewhat of a pyramid. You have certain items below the slide. I'd like you to arrange them properly. From the most important thing to the least, maybe not least important, from the most important thing towards additional items and supporting items. Pause the video here. Try to arrange that. Well, whether you're paused the video or not, I don't know. Go and try to arrange that video. Now we have main idea, additional facts, supporting arguments, and additional data, everything for this statement, number one, the main idea or statement would be the top level thought I have on this slide. Then under it, I need some supporting arguments or additional facts. Let's think about it. At first. I want the more important things that directly correlated to the main idea. I'll give the supporting argument number one and supporting argument number two here. Okay. Then as the last in no particular order, we have additional facts, number one, additional facts number two, and additional data number three. You may think what a stupid exercise, but in reality, you working on something like that. We'll leave something in your head, in your brain and hopefully you will remember about this principle and memorizes better by really clicking around within a program like PowerPoint and reading what is here. Thank you very much for watching this exercise and let us continue with next lectures. 19. 05-01. Horizontal and Vertical: We arrive at the chapter where we talk about storytelling, how to tell a story with your presentation, we have a couple of frameworks in place you can apply to your presentations to make that easier for you. At first, I want to talk about the horizontal and vertical flow. Let's talk about the horizontal flow. It can be explained very simply that your slide titles or leadings or action titles are wonderful titles, however you want to call them. They should tell the full story line of the presentation without needing to read the evidence in this slide body. If you look at that, it perfectly aligns with what he wants to accomplish. An action title, if I would make a simple story about making pancakes, but I don't have milk. I would do something like that on four different chapters for different slides. I ran out of milk than the second title would be, when in the middle of making pancakes. Then number three Could be, I stopped the process and went to the groceries. And my final piece of the story would be, I finished making pancakes. You don't know the details, but the story is complete by just reading titles. Let us move over to the vertical flow or vertical logic. This time, your slide leading should be fully supported by the evidence in this slide body. That simply means that everything on a given slide will reinforce the title. This is why I emphasize that you should tackle one argument per slide and make the content on it homogenous so it supports each other. If I would elaborate on my story, I ran out of milk. I could support it with some evidence. We had only a small bottle and I was sure there is more in the fridge, but there wasn't the second part where I was in the middle of making pancakes. I was very hungry and my pen was already hot. I stopped the process and went to groceries. My decision was mainly motivated by hunger. I couldn't continue without milk. Now everything makes sense even though you understood the story first, I have now a supportive arguments to back it up. I finished making pancakes and my pen was still hot. Horizontal and vertical logic perfectly aligned with our pyramid principle in action titles that we already know something about. 20. 05-02. SCR Framework: We already talked about logic across our slides, the horizontal flow. Then we talked about logic within individual slides, the vertical logic. But how to make a story out of this? It's a very simple. One. Framework that is very popular is the SCR framework made by McKinsey. It stands for situation, complication and resolution. And you just can feel that it beautifully aligned with a normal, regular story. Just like in movies. If your presentation would be about avocado sales, the situation might be growing consumption in Europe. The complication might be there is limited availability and logistics to bring enough of this product onto this given market. The resolution might be something like building new logistics chains, finding more sellers and so on. This is how I would build my slides in a presentation following this situation, complication, resolution, logic. Mckinsey isn't the only consulting company, but other companies have their own frameworks, but they follow a very similar pattern. E.g. PwC uses something like a hook. Wow, this is a situation something like that really occurs. Let's dive deeper into it and fixed to that hook that essentially wants to give the resolution or the answer to what was explained in the hook. A very similar way of building a story for your presentation. It follows a similar pattern of a situation, something that happens later on, and recommendations you can give. If you want to create some kind of urgency in your presentation, you can start with the resolution first, then explained the situation and complication. It's also possible, of course, this is your presentation. Choose the way you want. Remember that these three key factors will help you to build up a story. Remember my example about the orchestra, I'm sure you do. Let's do a theater or movie. Now, we could say that the SCR helps us set the stage for a prologue. The situation where we introduce the title topic or present a problem, then the complication and reveals a plot. In business, this would be of course, where we support our teachers with some relevant arguments, data. And the resolution would become the epilogue, where we find solutions or draw conclusions or give recommendations. This type of story can again cascaded down, like in the pyramid principle. You can see it slowly starts to fit in together. 21. 05-03. Examples: You are creating presentations and you are trying to make the best title is possible that make up a storyline. You are trying to organize content with respect to the pyramid principle, where you give the key takeaways at, at first and then you trickle down into other topics. And you also hear about something like situation complication resolution. Now, how to fit everything on a slide. These frameworks are not to make your life more difficult. They are to help you to organize content and to exactly see how you build your presentation. We have example action titles here. We could confirm those action titles with supporting data, having content below them, content that gives contexts. Now, if you would be to organize everything you see here, the first would be the situation where you explain everything, then there would probably some kind of complication to the situation you address in the presentation and you would end up with a resolution or next steps are recommendations. Let us put it on an example. I've animated this framework for a cosmetics company with face, skin, and hair products. That company has problems. It has insufficient products and therefore, of course, sales. I'd start. We have incomplete product lineup. And mind the wording here. You need to know your audience and you need to know if this is an internal presentation. So I am able to say we because maybe I'm from the company and I'm consulting it. If I would be an outside party, I definitely wouldn't use wording like weak. Then I am supporting that with our last product launched a couple of years ago, we have no shampoo in our headline up and so on. This would be the situation we're dealing with. Later on. I would state some fact, last year we have five per cent less sales than some information about that. No new competitors in our respective niche. Some information about that. And oldest product still provides value and sells well. You can notice, even though this entire thing makes up the complication, I've also organized my content to go from the most negative thing towards some positive things, like the most negative will be last year, five per cent less in sales, then no new competitors, which is a slightly more positive information, and all this product still cells, that will be a positive. So you can notice that I've organized the content from most negative to the most positive. This could create urgency and maybe not scarcity, but depending on how you want to build your story, that way you will organize your content. It isn't set in stone. What comes where at the end, of course, some kind of resolution like lineup companies with a new launch, we need new launches, new product launches, and the product needs to complement other products. There are some information and obviously this is the resolution. This entire presentation should also work if I scratch the content entirely, this presentation should work with just the titles. If someone just want to get a grasp about it. If you just quickly skim through the titles. Incomplete product information, information, information, let's launch new products. It makes up a story consistently. You can compare this, of course, to an introduction, the main content, and some kind of conclusion, some next steps. I'm not forcing myself into any framework. I'm just organizing content based on some things I know about presentations. 22. 05-04. EXERCISE: We will do two simple exercises. The reason we're doing this is for your brain, so you don't have to repeat the lectures anymore. This is one of the simplest remembering techniques, putting your interaction and actively engaging in the content you are taking. If these are your four slides, obviously, you can drag again items onto the slide. The horizontal slope is best represented by an arrow. You can remember about that, e.g. someone standing with an arrow creating this horizontal flow. The vertical flow will make up the content of your presentation. This will build logic into all your slides. Of course, as we talked about, a situation, complication can be but doesn't always have to be in the middle and some kind of resolution in the end. Congratulations, that will be the first exercise. The second exercise would be more related to the situation complication resolution model. I have here some information I'd like you to order accordingly. Read carefully the brief, how to increase profitability in our company. We have a couple of things. Reduce expenses, increase income, shrinking market, low profitability, little sales, and high cost. Please try to think about what would be the key message, key statement, and key topic. You can pause the video now and arrange everything. And in a second, we will arrange that together as well 2 h later. The question here is how to increase profitability. So probably the situation is low profitability. It could also be high cost. This would also work here, but for the sake of this question, directly answering the situation by calling it low profitability. Let's go one by one, reduce expenses. This is already an recommendation and probably in the past, you might put it here, but, you know, right now that the resolution should come naturally at the end at the closing part of your presentation. So I will put them here, increase income. That's also another end game recommendation we could do. Now, everything will fall into the middle category, shrinking market, sales and high cost. Of course, some information about high costs can be here and how to reduce the highest cost. But you get the idea about the situation, the problems, the complications, and the resolution. This is a correct solved exercise. I hope you will learn something and have fun completing those exercises. We will continue with amazing topics in the next lecture. So stay tuned and let go there. I for certain cannot wait. 23. 06-01. ESS: Welcome. In today's lecture, we are going to talk about the executive summary slide. Sounds flashy, but an oversimplified way of explaining it. An executive summary slide is your presentation condensed into a few slides and put at the beginning of your presentation, not everyone has time to read your entire deck and you want to get your point across right away and have a condensed way to showcase your presentation, e.g. to executive. But not only of course, any person getting your presentation might want to read that. As I've mentioned, it is positioned before the body content of your presentation. It's usually after the introduction and agenda, but before the main content. Now, the name is pretty self-explanatory. And you can imagine if you had a 50 slide presentation to your executive, it might be difficult to grasp what is worth. But if you take your key arguments and findings and it just briefly point out your solutions or recommendation. Put it at the beginning of your presentation. So the person who takes it can quickly skim through it. Bam, hopefully you have his interests. In the next lecture, let me show you an example of how that really looks. Let me also tell you what boxes should it take. It should reflect the SCR, the situation, complication, resolution, storyline of your deck, and the headings should be a story in itself. Before I let you go. Executive slide summaries are meant to be read. So usually they contain a lot of texts, you know already a little bit about action titles and about building a storyline. So the executive summary is usually a condensation of all the titles you've prepared. 24. 06-02. Good Practices: Let me work on an example and show you something. This is a possible executive summary I've written is for a travel agency that doesn't have an app or a website yet, I have things listed in bold and some supporting arguments. I want to show you the mistake made here graphically. Everything looks correct. We have clearly bolded items that should be read first, and probably the person who will see this executive summary will read only this this, and this without the additional points. So what would be my mistake here? I've written global trends and travel booking industry landscape, and then I have three supporting facts. This first sentence, if you read it, the next sentence, it doesn't read like a story. Customers prefer online search over traditional visit at agencies. This is already quantified because here I already tell a part of the story where customers prefer online search over something, something. But here I only said global trends and travel booking industry are listed below. I should immediately start to write a story like e.g. apps and metals search account for 60% of all travel booking. Let's just keep it that way. And this EPS and metasearch account for 60% of all travel over all bookings. It already is a bolt and informative statement. I can continue that statement here. Customers prefer online search over traditional visits at agencies. Having a phone app and website as an all-in-one solution yields the best results. All three sentences make up some kind of story. They follow the situation, complication, resolution formula. And it helps the person to understand the intent of your presentation without reading the additional point. Of course, Here's another example without the data, but I just want to show you that executive summaries can sometimes, of course have several slides. It doesn't need to be on one side. Of course, one slide would be preferred, but it can just as easy look that way. In the next lecture, I want to give you some kind of framework of how to think about executive summaries. And then we will try to write our own from a couple of slides I've prepared. 25. 06-03. Framework: Before we try to put together an executive summary, let me give you a few key points that you could follow when creating one. Your executive summary should reflect the storyline of your deck, whether it's the STR or a different framework, it should be reflected in the executive summary as well. If you plan to use headings and supportive arguments, then the headings themselves should make up the story already without needing to read. Additional points. And additional tip is to simplify things and make it easy readable and quickly skimmable because usually an executive summary contains a lot of texts. So you can't really bored the viewer. You want to make everything as concise as possible. If I would go back to the previous slide and try to reduce anything e.g. a. Here I've written, customers prefer online search over traditional visits at agencies. I might delete that. Online search over takes traditional visit at agencies. The person knows what the presentation is about and I would probably try to drain a few words out of it if it's possible. Of course, without losing contexts, try to use as little text as possible. When it comes to the graphical representation of an executive summary, usually the key arguments are bold and the underlying statements aren't bolded. Or only individual words in them are bolded. But you need to keep both the formatting and the tone of your wording consistent across your sentences. 26. 06-04. EXERCISE: I've prepared a fourth slide presentation about the global cheese industry. Let us prepare together an executive summary with a similar format. I want to show you an amazing trick in PowerPoint that you can follow. With this presentation. I had to titles here, I added all the first information in my title. That's normal practice, but what you maybe don't know, you can go to View. You can select Outline View. And basically it gives you an outline of the content on your slide. And what if I tried to read this title, this title, this title, this title, and just make sure that it is a story. The outline view can be very, very helpful. Let me simply in the outline view, create a new slide. I already have this template that I prepared, selected and I will call it executive summary for the points. I could be that bold and just copy items from here. Of course. Sometimes you just need to go into this slide and tinker with it. But that is the outline view. And if you use titles, It's a very convenient way that to add all the texts. As you can see, it would add everything. But I obviously don't want everything. So 12, I will take slide number three. And I will take slide number four. Again. I will just select everything control C and put it in my executive summary. Of course, it's now very ugly format, but you can very quickly adjusted by going to Home and de-selecting the bullet points. I like that. The important things are already bolded. I would remain them like that. I would select the additional items and I would highlight them like this. I could decide if I want them further or not. The main thing here is It's too much of them. I would probably leave only two of the most interesting, I believe, or IoT, try to rephrase it for the sake of a tutorial. Let's not do any rephrasing right now. I just want you to work with a technical aspect of PowerPoint. You can see PowerPoint tries to resize everything for you. So it sometimes is a hassle. I will not lie, but that why do we learn? I will press enter. I will just press Enter here. And we have all the information consistently presented across. Now I would select the additional point. I would press Control or Command key probably on a Mac, and I would just select the secondary items. I would bullet point them. And now I would make sure that the font sizing is consistent. I would go to the font sizing and I will press e.g. 16 or even less like 14. I want to go to View because there's too much text now in front of me. I wanted to go back to the original normal view. And this would be a well made executive summary. If you need more space and you don't have anymore, you can always click, go to home. And this individual textbox can have, of course, lower spacing. Lower spacing is made with the paragraph option about line spacing. And you can press one or go to the line spacing options and just decrease the spacing before to zero. And e.g. this add 0.67. This will make a very narrow line. You can see we can adjust the line to our neat. You can always click your back again and increase the differences between the lines. This would be one way of creating a quick executive summary. That was a presentation about the global cheese industry. The company who tasked me with the presentation, asked me, what types of cheese should it focus on Ansel to have the most revenue and what types of cheese are the most popular. Following an SCR, a framework to make everything complete. I started with a research about the market in general, about its size, forecasts and grows. And then I slowly trickled down towards some situations and recommendations. 27. 07-01. MECE: Welcome to this lecture where we're going to explain the Missy principle. Me see, is there to divide complex topic into simpler and more logical groups for easy understanding. To put it in very simple terms, it is a way of organizing information. Let's look at the name itself, m, e, c, e, mutually exclusive and collectively exhaustive. Let's work with the first one. Mutually exclusive means that topics don't repeat or overlap each other. They need to be really neatly defined. Like if you have e.g. something about physical activity per age group. Now, you are doing three groups, zero to 24 years, 18 to 60 years, and 60 years and above. What do you think? Is this mutually exclusive or is there any overlap? Of course, there is an overlap with the two age groups. I couldn't really divide eight groups and overlap 024.18, 60. It should be more like zero to 18. 18 to 60.60 plus this would be now mutually exclusive. The second part is collectively exhaustive. This essentially means that the sum of all your little groups need to paint the full picture of a given topic. Here, if we go again to the physical activity in specific age groups, I have 0 181-860-6065. But what people above 65 do not train anymore, do not walk anymore. If I want to be collectively, meaning all those groups need to paint the whole picture. I should do it more like 018 186-060-6565. Plus now I'm painting the entire picture. The messy principal did help me to divide age groups into separate groups that are not overlapping each other, but are painting together the entire picture. Let me show you graphical explanation. 28. 07-03. Graphical explanation: Let me show the Missy principle on an example. And if you go to Shape Format in PowerPoint while having two items selected, you can see under Merge Shapes, there is something similar, but it isn't related to the MEC principle. The principle is more theoretical. Mutually exclusive means that two ideas, two ideas should be grouped separately. They shouldn't overlap each other. This is how in a business presentation you should treat separate topics. For an example, if you had continents, one continent would be Asia, the second continent would be Africa. You have two continents divided into those separate topic this is okay, but I would give you an information that I'm doing a presentation about continents are some statistics. And then I'm making something like Asia. Asia and Europe or Eurasia. This isn't really messy because they aren't mutually exclusive. Asia is both in the first group and the second group. I need to keep that in mind when I will pull any statistics for you. Then going one step further, we already know what M E stands for, but the CE, collectively exhaustive means all ideas together should paint the full picture of what you want to say. If I would write here, world sales by continent, and then I just show you safe in Asia and in Africa, this probably wouldn't be collectively exhausted because in order to exhaust a topic, when you deliberately used the word world, I would need to paint the full picture. The proper way of arranging information would be show you all continents and then maybe the two best performing or any kind of statistics. But this would paint the full picture. And this is exactly what are the Missy principle is all about. You need to paint the full picture, but topics shouldn't overlap each other. In the next lecture, I want to show you an outstanding example of the Missy principle in the real world product. 29. 07-02. Examples: Let me show you a real business example. The economist, I'm sure you heard about it, has something like The Economist Intelligence Unit who does their own research on certain topics every year, they release a global mobility index for certain cities where they tried to quantify which are interesting to live in, and which cities rank high in this index, and cities that gets a score of 80 to 100. There are few, if any, challenges to living standards. And cities that get a rating of 50 or below aren't considered as interesting to live in, then they explain their entire methodology. This is subject to change, but currently they have five categories. Stability, health care, culture, education, and infrastructure. Mutually exclusive categories, beautifully divided into separate topics. Now, they are exclusive, yes. But are they collectively exhaustive? Do they paint the entire picture of a city, e.g. do they take into consideration that I like a city where my friends and family are, or I like to play football. So I especially value cities who have football fields. This is just an example. Well, no, because when you do a research or a presentation, you cannot possibly exhaust every option there is on the world. This is why at the beginning of this document, they specifically explain their methodology. They explain their categories. They explain what comes into each category, e.g. in education, they consider access to private education, access to public education with the infrastructure. They talk about things like public transport, roads and other availability. And each category gets its own weight, with stability being very important. E.g. infrastructure gets 20 per cent of importance with the amount of data they bring in with respect to their own methodology, they are able to draw a collective conclusion as to if a city is interesting to live in or has high standards or not, for the sake of their own publication, they are being very transparent about it. And they drafted the categories, in my opinion, in the MEC fashion. They are mutually exclusive, but collectively paint a really good picture of the quality of life of given cities. Keep that in mind in business presentations because there will be a point where you will start to think, Am I going too much into detail? Am I being too granular? And then you need to think what we'll paint the collective picture, pick the topics, and consider moving forward with your content. 30. 07-04. EXERCISE: Let us go again to a simple example. A company had troubles with their recruiting strategy. They needed something new, they didn't know how to really onboard new employees. We consulted the company and divided the recruitment process into four distinct steps. I'd like you to organize the steps and the descriptions. As usual, you can pause the video here and in a moment, I will do that with you together. A few moments later, I will start by reading through the main points and main categories. Build loyalty, hire most qualified candidate. Onboard new workers, find and attract new candidates. Of course, the first step would be find an attractive new candidates here. This would be a perfect fit to open up the recruitment process. Second, would be higher most qualified candidates. Then do you want to build loyalty right away or first onboard new people? Of course, some kind of onboarding would be very welcome in the recruitment process. Later on, we could go to build loyalty. We have for mutually exclusive steps that collectively give us a good and solid recruitment strategy. Our company. You can add additional talking points like gift, personal onboarding guide tasks, veteran employees to explain responsibilities. This would fall into the on-boarding category. Job posting on board and post information about your company. This should definitely be among the first steps. Read resume is recognized experience, invite for interview. Definitely, this has go into the hiring category and to build loyalty, some kind of bonus and recognition and appreciation of the work done. This is up to the company how they want to recognize and appreciate the work done. We will do some later recommendations. But here we wanted to focus on organizing everything in a messy fashion. I hope you've enjoyed this little exercise and we see each other in next lectures. 31. 08-01. Types of charts: I think I don't have to convince anyone that data analysis, statistical thinking, and being able to present what we analysed is an important skill. I want to give you a solid foundation about data visualization and a starting point to make better charts for your presentations and all media you communicate with. Let me open up by showing you a couple of basics about the most important charts you should learn about. And I'm opening up this beautiful list with the column chart, which is made up of horizontal bars stacked next to each other. A column chart is great for comparing different categories to each other. It looks really well wherein there are 345 categories, it gets a little messy if there are too many of them. Next would be the bar chart. And an easy and simple way to remember which is the column chart and which is the bar chart, is someone walking a really, really long walk from the bar home and he needs to work on top of the bars. A bar chart is basically a column chart, but flipped around. Why do we do this? Because we have plenty of space for labeling. And it really looks good even if there are many things to compare. E.g. I'm sure you looked at charts like that and this looks perfectly fine. No matter the data, you can put plenty of items on top of each other. The next, Who else than the line chart? The line chart is a beautiful way of displaying data, especially showing things continuous in time, like trends, because we can have plenty of data points that go on and go on and go on and align can display that. It's good even for plenty of measurement. Next up, the beautiful, The tasty pie chart, especially graphically, it looks very appealing. The pie chart has some advantages because all slices together need to make up 100 per cent. So it perfectly shows part-to-whole ratio, but it gets a little difficult if there are more than four or five slices. If you have like 1012 slices, it's really not the type of chart you want to select. Next up, the area chart, which is a specialized form of the line chart. If you take a look at it, but it actually has color below it. It's used to display two or more quantities like sales of two items making up your entire sales. What's interesting, it can combine a line chart and a bar chart below it. So it's a really interesting form of a chart. Next up, if we talk about business and finance waterfall chart, this is a form of a column chart, but actually the waterfall chart wants to show you increase and decrease of certain values. It visualizes the start and finish e.g. income, which is changed by expenses, by something, by something. And at the end, the total income is like that. And the waterfall chart can beautifully display that. There are plenty of other chart types like pictographs where you show something with icons or combo charts, where you have a column and a line chart connected to each other displaying two different metrics will work on a different chart types, and I'll explain everything step-by-step. This was just a brief introduction to allow you to dive into the topic and make your brain prepared for chart knowledge. 32. 08-02. Chart Basics 1: I want to be fair to everyone, even to people who never opened PowerPoint and never work with charts. This is the time to learn and I want to challenge you right now. If you know a lot about Charles, that's great. If not, then I'll try to show you everything with simple steps, but they will be challenging to force your brain to think really hard. I want you to open the practice file on the chart, basics. I'll always display a 3D chart. This is what you want to achieve. A practice chart, this is where you want to work and practice your skills. I'll try to write down tasks so you don't get lost. Chart basics are task number zero is two times to select something. If you select a chart in PowerPoint, you click on it. You have selected that entire series here, here, here, and here. But if you click once again, you can select an individual item within a series. This also works for Data Labels and four legends. If you have a legend, I'm selecting a legend, but if I click again, I can select an individual item within the legend. If you want to add and remove certain items from the chart, either hit this plus sign or go to Chart Design, Add Chart Element. And you can add and remove certain elements here, I strongly recommend that if you've never worked with charts, that you open this chart elements and you try to add titles and add data labels to see what they actually are. Okay, we've performed task number one or actually zero. Let's go to task number one. Something very important. Change x-axis values to display every 20 per cent. I will select the x-axis on the bottom, you can see it displays every ten per cent. I can right-click on it, go to format axis. And specific options to this axis appear. Not only filling options like you may know within PowerPoint, but also those specific options for the selected chart item. Here on the unit, I want to change the major from 0.1 to 0.2. I press Enter and you can see it takes place now every 20 per cent. This is something that really cleans this chart up. Remember that drawback here is that the vertical grid lines also disappeared because they are connected to the actual axis. We have performed tasks number 1.0. Now we'll go to give the x axis aligned fill. Select the x-axis again. Now instead of the specific options, go to the filling options. Under the filling options, I want to open line and I'll increase the width to maybe two points. It's a bit much, but I want to clearly displayed this line. I can change the color to blue. And I can go back to the specific options. Because I also like to have tick marks. You can open tick marks major type, inside or outside. I like outside because they are facing down straight on the number. And this is how we format it. Interestingly, the x axis. I would like us to create the rest of the tasks next lecture, so you don't get overwhelmed. Try to open this file, try to perform at least the first few tasks, and we will see each other in the next lecture when we finalize this practice file. 33. 08-03. Chart Basics 2: Okay, We are doing really fine. Change individual bar color. I've mentioned that you can select the entire series by clicking on it. But if you click again, you can select an individual part of the series. This way, I can go to the format options, Shape, Fill, and give it any color I want, e.g. a dark gray color like here. Now, trained bar color using the legend and actually not bark collar, not individual bar with isotype, you're serious color. Because if I click on the legend, I can click again to select an entire series. This way I can go to Format, Shape Fill, e.g. give it a purple fill. And the purple fill will be automatically applied as well to the entire series. A really convenient way to just click on the legend and recolor entire series in your chart. Remember about this possibility? At one data labeled per category, I want to select this first object. Go to the plus sign and select data label. You can see this number appeared. We have no contrast here. I need to change the color to white, but the number appears if I would select entire series and I would press data labels, data labels would be added to the entire series. Let me make it on the blue ones so you will see it. You can see the number appeared everywhere. But if I de-select the data labels, I select just a second block. I select Data Labels. It will display the data label only on the selected object. This is especially important if there are plenty of data labels and you will not display only the couple most important ones. Play around with the vertical line, a dashes. I can click on the line itself. Right-click. Format axis are actually not Format Axis. I can click on it and select Format gridlines. I can format the grid lines and I can increase their width. Just for fun. I can change their dash type two dashes. And you can see we've changed the design of the chart itself. Beautiful. This is what we wanted to achieve here. The last thing is reorganized legend and a chart title. The chart title usually is on the top. It really looks well on the left-hand side. And for the legend, you can decide for yourself, do you want the legend here on the right side? Or do you want to select the chart? The chart itself, make the chart smaller. And maybe the legend take up more space. Maybe that makes sense. You can go to the font, make this bigger, and notice that it looks beautiful, but it is possible to put the ligand wherever you want. This is what I want you to create within this lecture. I want you to play around. Thank you, and see you in the next lecture where we will continue our practice. 34. 08-04. Chart knowledge: I want you to learn the most you've ever learned within this course when it comes to charge in PowerPoint, I want to show you and very advanced thing within PowerPoint charts. Here I have a chart where I simply put a shape above it. If I resize the chart, the shape stays in place because this is a regular PowerPoint shape in the chart on the left side, I've actually embedded those items within the chart. Now, if I resize the chart, the items come with it. They become bigger, smaller, and they try to stay accurately within the same place. This is the ReadMe file. Now go to the practice file. Within the practice file, put something inside the chart and try to resize the chart and then see what happens. You can actually click on the chart. You need to have it selected. And right now, if you go to Insert Shapes and you enter the shape, e.g. a. Rectangle because you want to display or highlight this part. I had the chart selected. If I resize the chart, this item resizes as well. What's even more amazing, I can click on this item and it will not go over the chart. It is bound within the chart because it is embedded right into it. If I de-select the chart, I go to Insert Shapes and I insert a normal shape here in PowerPoint like here. This shape can go everywhere because this trait isn't embedded within this chart. I can make it smaller. Then shape stays as is. I want you to click on a chart, go to Insert Shapes and insert a shape. And try to maybe right-click on the Shape Format Object. And under the filling options give it some transparency. This way you have a nice highlight that will always follow the chart you created. There is one notice. One thing I noticed within PowerPoint, if I go to Insert Chart and I insert a waterfall chart, This doesn't work on this type of chart. I don't know why, but Microsoft prohibits to add items, at least currently, at least today. When I add a shape, it's still isn't embedded within the chart, but we ordered chart is a very specific chart. You'll have to excuse it. Regular charts, line charts, bar charts, column charts. Everything works and you can always have an item embedded within them. Practice that and we'll see each other in the next lecture. 35. 09-01. Work with me: Very brief information before we start, you already know how to work in this course. I just want to mention that this is working progress. This may be different, but you will have a different project files for this data visualization. It's always difficult for me to pronounce data visualization. And you'll open each file. You will have some data. You will have an example chart designed by me. This is something that you want to create yourself as well, but you can take a look. Oh, you did it like that. Oh, he e.g. he made those arrows interesting. And this will be the place where you work. Above the place, there should be some guides and information about tasks you have to perform. I will show you everything within the next lectures. So let's open the first file and let's start working. See you there. 36. 09-02. Clustered column: Within this lecture, I want to work on a clustered column chart where we compare three different companies within different years. Okay, let's grab the data. We have graphic card sales revenue between different years in billion USD, between three companies, graphics turbo and hurts. I'll take the entire table. I'll go to Insert Chart, column chart, and insert a clustered column to compare those competitors. Alright, let me enlarge this a little. I like to do it like that. Okay, graphics, durable and hurt. This is task number one, insert a clustered column chart. Task number two will be to change graphics and hurts because graphics has a little bit lower values. And with this presentation, I wanted to actually compare turbo and Hertz. This is only additional data. We have many ways of switching around data. E.g. I. Can select this entire part of the table. I can move my mouse to the side. I can press shift. And when I move it forward, you can see it has this little bolder line. It will be simply put as the last one. This is one way of doing so. Let me press Control Z. I want to show you another way. Another way is to select this entire column, press Control or Command X to cut it to the last column and simply insert cut cells. It would also cut the first one and insert it at the end. Alright, we have now turbo inherits as the first one. This is just me. I forgot to minimize myself and we completed task number 1.2. Number three, put a legend on the right side. It's very simple to put a legend to the side. You can click on the legend itself. E.g. you can do it on the plus sign. You have the legend. You can open the legend options and put it on the right. It takes up very little space. So I would maybe move the chart a little and simply make this a little bigger. You can also make this bigger by going to Home and increasing the font. If you wanted to give this a little bit more space, I think this is okay. We've put the legend on the right side, number four at data labels for turbo and hurts. Turbo is this 1 hz is the second one. So I will just select the first data series. Again, go to the plus sign and enter data labels. I'll do the same for the second series. I can hover my mouse. Serious heart. Data labels as well. I think they are a bit small so I can click on the Data Labels and I can enlarge it just by pressing this little icon to make it stand out a bit. I do this very often. Control B because we completed this task. Number five, reduce serious overlap and gap width. This is something specific to column chart. And I want to show you, I will click on this chart. Just right-click on any serious Format Data Series. And in the Format Data Series Options, you can actually change how much of a gap is between the Series, between the companies and how much of a gap we have between the categories e.g. like, this would make it a bit cluster, but we can increase the overlap to connect them together and increase the gap width. So we have big gaps between the ears. Sometimes. This is what you need to do if you have very little space for your chart, but the regular gap width is pretty okay, and it looks very nice. This is a bonus option. I wanted to show you specific to this type of chart. Press Control V. Now remove horizontal line and y-axis. Since we already have data labels here, I think we do not have to duplicate the data labels on the left side, you can just select this axis and press Delete. Do you want the horizontal lines? Maybe I delete the horizontal lines. What if I want vertical lines? No problem. Press the plus sign grid lines, primary vertical lines, they would now beautifully divide different years from each other. I hope you've enjoyed this little lecture. Please try to replicate the steps and we will see each other in the next lecture. See you there. 37. 09-03. Stacked column: Here we have interesting data. Average hours per day spend on leisure activities bisects to have both sexes, men and women. And this is a perfect example where you want to stack the data and see how much comes together. So I'll take the entire table. This is approximately what do you want to achieve. And let's now work on that. We have our tasks. Number one, insert a stacked column chart, no problem. I'll insert a chart. I'll go to column. And instead of a clustered column where it would be next to each other, I want a stacked column. So data is on top of each other. Let me enlarge the data, press control V. And we have one category too much. I'll just make this data selection a little smaller. And you can see perfect. We have only our three categories. We have so much space here. We completed number one. What does number to remove? A vertical axis and horizontal lines? Yeah, it's very difficult to read the data from this axis here. So I'll delete the axis. And by going to chart design, Add Chart Element. I'll enter the data labels we have now data labels. And what I also wanted to remove is the horizontal lines, okay, we don't need the line. I'll just press Delete. Okay. We completed task number two. Test number three will be legend on the right side, we have the legend on the bottom. And it's like a bit difficult to read. So I'll make the chart much, much smaller. I'll really don't like that. It is so big. And I'll take the legend because here the legend is really, really important. Maybe not like that. I'll enlarge the legend like that. Maybe a bit too big, and now we very nicely have that highlighted. Alright, Control B, number four will be changed colors. I'm using a color scheme and you can see, we can barely see like this dataset, this dataset. I can either make the font of the data labels white or completely changed the color. Even though we have a nice color scheme for our entire presentation. Sometimes it's difficult to see if there are so many categories. I'm going to my format options, Shape, Fill, and I will start with a normal green color. Then I will select the next one. Shape fill. You can also go to more fill colors. You can either pick one of the pre-selected ones or go to a custom color. You can enlarge that. You can go to a green, maybe a much, much lighter green. It should look very nice. I'll press OK. And now we can clearly see what is happening here. For the last one, either make the data labels, text fill white. Oregon, select the entire data series. You can do this even here by selecting the legend Shape Fill. Let's give it an orange or yellow, something that will make this stand out. Now we can see much, much better what's going on. Apart from this first data label, I'll give it a white text. Now, everything is, in my opinion. Okay. We have changed the colors, Control B. As a little bonus, I wanted to tell you that if you want e.g. women to be on the left side here, instead of the largest category first, you can always press on the bottom axis, right-click Format Axis. And there on the right side is a feature called categories in reverse order. If you select that, the categories will reverse. Of course, you can take the table and you can like put the woman higher, like editing in Excel, but it's a bit quicker and more convenient if you're just select this option. I hope you can replicate all the steps and work on this stacked column chart. And in the next lecture, we will continue to work on a different type of chart. You see you there. 38. 09-04. Line Chart 1: Is there anything more beautiful than a line chart? Within this lecture, we want to create this type of chart. If we go to our data, we have unemployment rate in the 1940s in the United States, and we have total men and women. If you see this many data points, by many, I mean above ten, you most likely will use the line chart, especially if this is continuous data that can be set over time. I'll select the entire dataset we have here. I'll go to my new slide. And l started out by inserting a line chart. Go to Insert, go to line. And you have a default line chart, or we have the line chart with markers. If you want the little dots on each data point, we have this many data points. So I will prefer to have a clean line. If I just paste my data into PowerPoint, you can see we have a bunch of information, it's barely visible, what's happening here, it will get even more difficult if this chart would be a little smaller. So what we can do to change that? At first, I want to show you, you can filter out serious and time from a chart. I can click on the chart. I can go to my filter options. And e.g. if the total value is the most important here, I could possibly deselect the man, deselect the women, select, apply, and only this one series would remain. You can do the same for categories if you would like to reduce the time displayed. Alright, beautiful. We've learned something about filtering. Then. I want you to add a percentage sign to the y-axis. We have percentage on the left, but there is no percentage sign. There is no percentage of total information on the left hand, there is no title yet. What you can do, you can actually click on this axis, right-click Format Axis. And apart from the normal axis options on the bottom, you have number. This means what is displayed here. By default, we have general to not over-complicate things. You can format code. You can press Space. And after pressing space, I can simply select percentage. Onetime percentage, select, Add, and no percentage will be displayed next to the general number. Beautiful. We completed task number three. Number four, re-color horizontal lines. If you want, give this chart a completely different feeling. You can select these horizontal lines and they are just a part of the chart like anything else here, you can right-click, select Format Axis and format the grid lines I will select. Instead of formatting just the x's, I'll actually format the grid lines. And the grid lines. There are normal line filling options. On the line filling, I will select the color to be blue. And you can see this chart has now a completely different vibe. If you want that last line to have the same color as well, you need to select the axis because the first line is always from the axis. The rest or the grid lines, I'll select the axis itself with today's, go to their filling Options. And under the line options, I will change this color to blue, Beautiful. Now, all horizontal lines are blue. I'll end this first part here and let's continue editing our line chart in the next lecture because the line chart is so beautiful, we need to give it a little bit more attention. 39. 09-05. Line Chart 2: Let us continue working on our line chart. Now, make men and women serious, thinner. I'll use the filter options to enable the series. Again, enable, enable, apply. We have the series and I would like them to be a little bit different from the main line. Domain line is what I want people to see, but those are now too thick. You can click on the individual lines or go to the legend and click on the line by double-clicking on the legend. Go to the filling options. We have border and just reduce the width of the border to one point or 075. Now select the women and reduce it to 075 as well. You can see now this chart is a much more readable than the default values. If you want, you can take the main line, go to it's filling options and make it a bit thicker to showcase that this is the most important data. We have completed. Task number five, what does the last one? Reduced number of displayed months, just as you can click on the left axis. And in the bounds on units, you can change the units, e.g. to be every 2%. Instead of every 1%, it would reduce the number of lines. The same way you can edit displayed month on the bottom, let me show you what we can do here. I want to display only yours, e.g. because this is far too much information, I will go to the bounds. And under the units we have every two months currently, I'll maybe do every year and every one year. Powerpoint automatically knows that these are dates. But now this doesn't look great. I'll go to Number and I will change the category to a date. Let's change it to a date. And from the date, we have a bunch of predefined dates. Suddenly we have no pre definition for years, but that's no problem. Just select one that has years, e.g. this three for March 14, 2012. No problem. The ears are why why why why? You can delete everything, meaning the months and days and just leave the ears and press Add. Add is simply a refresher. Now, we have displayed only the years. We're complete with this chart. If you would like the ears to be somewhere else. No problem. If you want, you can even delete this axis, the one that is telling you to put the x's on the bottom. You can go to Insert Shapes. Insert a text box, and e.g. 1950s. You could do a normal text box like that, a bit bigger and you would be under complete control where this will be put e.g. if you want the year e.g. to be here and your for the a to B here. No problem. 1948. You can do it that way. I know this is a bit complicated, but you will get so much better at PowerPoint by doing so. Good luck and let see each other in the next lecture when we continue working on our beautiful charts. 40. 09-06. Pie Chart: The pie chart is perfect to showcase relation and part two hold. And in this lecture, I'd like to go over with you how to create a pie chart properly. And what we can editor. Here we have some data. I'll select the data. It's votes cast by 60 students on what is their favorite subject. So I'll take the entire data table, I'll insert a chart. I will select a pie immediately. The 3D pie isn't really something we will use. We will definitely wants to use the normal original pie chart, Okay? And we have inserted the data as close this up, and this is what we see by default created by PowerPoint, we have inserted a pie chart. I will select this as complete sort numbers high to low. You can see we have a lower number, then we have a higher number, low load. And again, Hi, I would like to organize this highest to lowest. I will right-click Edit Data and go very briefly into Excel. You can see everything is selected. By going to data. You're going to click on the sort and filter or just enlarge this a little bit. And here in the sort and filter category, we have Z2, meaning the biggest to smallest. But if I click on this, you can see PowerPoint still makes a mistake. Mathematics has 12, but it is after five. Sometimes if you select the title as well, you need to select the data once again without the titles. Now I press z2. It should organize properly. Yes, we have 12th now here, everything seems to be fine and we have sorted the data. Now, when you click on the pie chart, you click on the plus sign. You see there's not much things. We can de-select the legend and insert data labels because they look very well on a pie chart. I'll press Control B, and the last one is at percentage or values. I'll click on the data labels, right-click Format Data Labels. And you can see on the right side where something different than we had in the previous charts. Here, we can actually showcase percentage, showcase the category name that we have, and maybe de-select a value because this is getting too much of information on them. I'll make the data labels slightly bigger. And I need to change your color. This one basically is invisible, so I would go to the text color and I would recolor it too wide. Maybe I would call this white as well. Maybe the music white as well. I want to show you one last thing you can do with a pie chart. With a pie chart, if you click on the pie chart itself in its options, you can see the angle of the first slice if you want the first slice to start later, sometimes it depends on the presentation. I can e.g. hit 90 degrees and this will be the starting point. The last thing I want to show you is the pie explosion. I'm not a big fan of this feature. You can exploit the pie a little bit, meaning exactly what you see here. You can also grab something and pull it outside of the pie chart. But as you can see, this explosion really doesn't help. It only restricts the area for our pie chart. And this also depends how much space the actual chart has. You can see I could make it smaller, I could make the title smaller soil gain a bit of space here, but the explosion really isn't very attractive, in my opinion. Another little thing we're going to click on the Data Labels and you can select where they are displayed. You could e.g. make them outside end. You would need to change the color of course, because now they would be outside the pie chart. I like to have them inside the pie chart if the pie chart itself allows it and maybe adding some information on the site, this would be a very easy readable slide. Thank you for your attention in this lecture, Let's work on the pie chart a little bit. And in the next lecture, we will work on another different chart. 41. 09-07. Bar Chart: Graphically speaking, the bar chart is one of my favorite charts, especially if you have plenty of data points and you want to put them horizontally so we can read everything, e.g. if you compare different laptops and their performance, this looks very well on a bar chart. Here, I have a lot of data. We have different types of oil and how much area is needed to produce one ton of oil. Not all data is accurate here, but this is just an example. I will take all the data points. I'll go to slide number three. And at first it says insert a column chart. Let's do it like that. I'll insert a column chart, a normal column chart. Putting the data, let me enlarge this. I'll put in the data. I'll of course reduce the number of categories here and look what happens. This also looks okay, but I wanted to show you one feature in PowerPoint into how much better a bar chart would look here because we barely can read everything, especially because there are so many of those names here. If you right-click, Change Chart, Type, change it from column two bar, you can do that at any given point. You can press okay. And you can see how much better this chart already looks. Okay, canceled. Be next. What do we have? Right-click on the y-axis on the left side and set categories in reverse order. Yes, we've already been talking about that, but very often you wanna go high to low. Everything about sorting. It's very convenient that in PowerPoint, if you go to format axis, you can select categories in reverse order. We are in luckier because the categories have been already sorted. I've already sorted them high to low, but if not, we would need to go for a second into Excel. This looks beautiful. Add data labels and recolor almond oil to make it prominent. I love doing this. We will not highlight almond oil either. Double-click to select it. We go to chart design or format and give it a different fill. But you can see the color is barely visible. What I often do, I give a very light color to everything. Shape Fill, e.g. a. Gray. Gray is the perfect color to showcase something less relevant. And once I have great, I select the data I want to highlight. And I highlighted with the color that I'm using in the presentation. In our presentation, we are using blue. So I'll give it this deeper blue. And I'll also enter data labels. This selected. Click once again on the entire series plus sign, add data labels. Beautiful. We see all the labels. It looks really good. I think since we already have the labels, why don't we just delete this upper axis and also please delete the legend. We absolutely do not need a legend. This is what we came up with. It looks absolutely gorgeous, and this is how you can utilize the bar chart. I would like you to go into PowerPoint and make the same changes into this chart. Play a bit around with the data that we have here. And you surely will learn a lot about PowerPoint and about using this type of chart. 42. 09-08. Area Chart: If you have data on a line chart and have the same data on a column chart and you put them one above the other. You can see we basically create an area under it, and this is exactly what the area chart is used for. Here we have data. We have three models of phones sold in one year, second year, and third year. And they were released later on. And I want to take all the data and create an advanced area chart. It will display how one phone started out well, but of course, over time, the sales get a bit lower. But then the next phone launches and it has, it overtakes the sales. Okay, Let's start creating by inserting an area chart. I have the area chart selected by default. I press Okay. And here we have two areas overlapping each other. I'll Control V, the data. You can see plenty of data points and you have three different phones. Okay, beautiful. We inserted this area chart. Now, go to Chart Design, Select Data, and de-select one of the ears. We can either do this by clicking on the chart, clicking on the filter, and de-selecting one year here, or simply going to here on the top side, Chart Design. And we have this option to select data. If we go to select data, you can see this opens and we can de-select one of the data points, okay? It's just depending on what is more convenient for you. I wanted to show you that you can do similar things in different places in PowerPoint. Now, make the 2049 phone data series a little transparent. I would like to know if I click on the left and you can see, I would like to see what happens here. I don't want this to be covered, but since this is a normal area chart on top of each other, they cover each other. So I'll click on this one, right-click Format Data Series. I'm going to this bucket to the filling options. And it's automatic, automatically it sets to a color, but I will select the same thing, a solid fill. But if I select the solid fill, I have now also the transparency options. I need to return to the blue color. It was the second blue color. And I need to give it a bit of transparency. This way I can see what happens behind. This is an optional step, but I really like to do this to showcase more information to people who watched this chart. Then this vertical grid lines every year, delete years completely. Now, this would be a difficult task. Look at those data points. So many of them. What do we want to do? We want to go to the ears and those grid lines. Let me select the grid lines. Instead of a primary major, horizontal, I want the vertical ones, but there are so many vertical lines. I want the vertical unit display every one year, you can see what happened. Beautiful. Now we have your number one here, number two, year number three to 48. I'll delete this completely because I don't want the legend to be on the bottom. The legend is okay, but I didn't want the axis to be on the bottom. Instead, I can simply go to Insert Shapes. I can introduce shape and make a completely custom design, e.g. displaying 248, I will select by control a averaging, going to home and just making it bigger, placing it in the middle, maybe making this a little like that. And beautiful. We have something that displays the ears. Press Control D. I have a shortcut for recoloring enemy basically designed some kind of display for our years for different phones, Shape, Format, Shape, Outline, now, outline. Everything. Looks really nice. I think we completed task number four. Number five, add yours manually. This is exactly what we wanted to do since we have no x's, but we still need to inform people what is going on in this chart. We needed to display them like that, okay, here we would need to explain this is sales in units or something like that here we would need a title and this chart would be ready. In the next lecture, I want to show you a stacked area chart that showcases information a little different because different areas are on top of each other. So see you there. 43. 09-09. Stacked Area Chart: This is what I want to teach you within this lecture, you can see now the area is on top of each other. So we see this chart until the end. Now, if you compare this, this is a normal area chart. This start falls off, but we don't really see how it falls off. Here. We have this additionally the second one and additionally the third one. So if this would be one company, you would like to add the sales. But if these are three different companies releasing a product, you most likely will use a normal area chart. Now, let me go right over to the slide number three where it says practice. And we want to practice on the same chart that we ended up with, Adverse Change Chart, two stacked area chart. You already know that you can change any given chart at any given point. Just change serious. Go to a stacked area chart, area here, normal area. And the second one is the stack area. We have now the data displayed a little different until B, because we already have that. Now click on the chart, go to the filter options and you can see 2050, the data is still there, but it wasn't allowed. So I'll enable it again and hit Apply. So this is now visible, beautiful. Task number two is complete. Task number three, display thousands units. On the y-axis. This isn't always available, but here we have number of sales. I want to use the word thousands here because it's only a number right now. It could be any given number, 1,000 of potatoes. So I go to format axis. And here we have display unit. Instead of num. We can use thousands if this isn't available. That's not a big problem. If this isn't available. This click on the chart. Select Insert Shapes. Insert a normal textbooks are inserted. The textbooks from here hit thousands, thousands. Turn it around with your shift key and you can place it here, no problem. But this way we automated it for ourselves. And you can see legend is now displayed differently instead of 10,000, right now we have ten thousands on the left. This is a really nice way to display data in a shorter way with an explanation beautiful. Control B, because we completed that task number for change grid lines, two horizontal ones. Alright, right now, I would like horizontal grid lines because I'm counting the total number of sales. I'll go to the plus sign. I'll change the grid lines from the vertical to horizontal. Now, at this given month, we almost hit 10,000 sales, 10,000 total sales of our phones. One less adjustment I would like to make. I would like to hit it like 250 and recolor it to have the same phone. This way. We made another area chart, but this time the chart isn't one next to each other, but one above the other. This way, even though the phone sales are lower here, we still sell a little bit of the older phone and the newest phone. And we are about even on the sales. Depending on your presentation and data, this type of area chart needs to be used. Thank you, work on it and we see each other in next lectures. 44. 10-01. Map (Office365): Please treat this lecture as a bonus because I'm not sure that every PowerPoint version will have this available. I assume that only Microsoft 365 subscription will have this feature because it's downloaded online. But I may be wrong. If you go into chart, there is an option for the map. As I said, I believe it is only for Microsoft 365, but the map isn't really great. I want to show you this feature as a little bonus if I hit Okay, powerpoint imports a map from their database and basically XL file opens with the different countries and we cannot only display e.g. I. Would like to only display Africa or only display Europe. I can't really do this. The only thing I can do, I can change the series, change the data, e.g. if I type in Germany and press 50, then Germany will appear. But if you e.g. now add e, Egypt 50 as well, you can see the entire world appears. So unless you want to show only one country like that, you can almost the entire world or the entire wheel displaced the entire map. The problem here is that I cannot reuse only a part of the map, only if I use this one country. The map also isn't perfect. As a bonus, we can know about that. We can sometimes use it for a rough estimation or rough display of some intensity. One metric on countries. This could be okay, But don't really get used to it. I still prefer to use an outside map and edit it by myself, so I have more control over what and where is displayed. I'll show you in the next lecture what I mean by that. Thank you very much for watching this little bonus. And let's go over right away to the next one. 45. 10-02. Map (Template): Let me show you a different way to obtain a map and you can download maps online. If you type in PowerPoint map template or PowerPoint world map, you should be able to find something, but I'm using the official Microsoft PowerPoint templates. Since I do have a PowerPoint license, I'm allowed to use this map in my product. If you do not have PowerPoint anymore, you aren't possibly not allowed. I was asking Microsoft about this. They basically said, if I have an active license, meaning if I bought PowerPoint, I can use those templates. So I'll do this right now. E.g. this one, map pins, infographic. We could also use this one, this blue one. I only want to gather the map here. I'll select this template. I will download it as you watch the video, this website might be different or they may delete the map saying it's no longer available. I'm at this point when I'm recording this video, a map is available. If not, I would download one online. Let me download this. I'll double-click on the PowerPoint template that I downloaded. I will enable the editing. And you can see I have a map here, but I cannot click on it. This is because this map, if you go to View Slide Master, this map is a template within the Slide Master. You can grab them up here. What I usually do, I just take this map control C, Closing the Master view, just selecting a new slide. This time, I changed the layout to a blank layout control V. And I have my map here, my vector PowerPoint map. I can now take this map and be very careful with it because Right-click Group, I can ungroup this. I need to right-click group and group it again because it was like a double group. And you can see every country is like two times displayed. This is just a way it was designed, perhaps two layers on top of each other. I didn't really know here, if I would like to grow up one country, e.g. India, I could make so I could take India, put it somewhere, then I could take a different country and we could put them next to each other on a different slide. I will select a new slide. I'll put them next to each other. Boom, the map isn't perfect. No doubt. But you could display some basic information and data like that. This is just a showcase. Again, I'm treating this lecture as a little bonus, because if you are talking about charts, you most likely work with data. And if you work with data, you will most likely come across the need of using a map within your projects. So if you have an active license, if you purchase PowerPoint, you are basically allowed to use this template. At least this is what I was told by Microsoft employee. If not, just download a map online, I will not do that here because I cannot really share things that are showcased on line. Hero in the next lecture, where we go back to a few important and interesting charts to create here. See you there. 46. 10-03. Waterfall: In this lecture, we are talking about a waterfall chart. Within PowerPoint. A waterfall chart is made of total values, positive and negative change. It tells the story how this value came to the last value for Windows. This chart, I believe, was added in 2016. I'm looking at the official support page of Microsoft and I think this isn't available on the Mac version. On the Mac version, it says here, excel for Microsoft risks to five, but not PowerPoint for Microsoft 365. If you are on a Mac, probably at this point the waterfall chart won't be available to you. Hopefully I'm wrong, or at least in future versions, Microsoft will include it. This is why I'm treating this more as a bonus lecture, a waterfall chart. Let me take that data. Here. I have like increase and decrease of a certain sales in a given month. We have mirror sales for January. I'll take this entire table. I will add a waterfall chart and count revenue and total revenue. Let me insert a chart. It will be a waterfall chart, but by default, this is what we get. We have a waterfall chart with 123 total values. I'll explain total values in a second. I will paste the data. What I have to do here, I have to count the increase and decrease. So I'll put this aside a little lower. So this would be revenue. And here I will just make equal sign some and summarize the balance. The January sales and the add-ons or maybe not. Maybe. Okay. Yeah. All three of them. This is the sum and then total revenue. Now, I want to count everything together. By counting everything together, I mean, the revenue. Sorry, equals sign some. I need to open the function, the revenue. But we had some costs for shipping, for stress testing, for warranties. And I'll close that down. So this will be the last total value you have. You can see powerpoint automatically has set its total value here. Let me control be the first step. Number two, set the revenue total. We have revenue here. I need to click on this particular bar. Click on it again, right-click and set S total. This has a function unique to the waterfall chart available on here. But this shouldn't be a total value. I'll click on this. Right-click clear total because this wasn't a total at all. This was just default by PowerPoint. Okay, now, set colors increased should be green and decrease, it should be read. It is much easier to see increase. If it is color-coded. By color-coded, I mean, something that people recognize instantly. By green, this is the universal color for growth. And for the decrease, the universal color would be, of course, red. Now this chart is much easier to understand because here we have some increase, decrease, and this would be the end value. Make y-axis or Data Labels display currency in dollars. Here on the left side, we have like a value, but a value of what? This is actually in thousands of dollars. Or we have the entire value here, but I can right-click Format axis. Just like in other charts, we have the distal humans here. So I'll display thousands. Okay, it is a number. Now I need to open the number and press space and add $1 sign. I'll press Add. And what happens now? Right now we see $80, $100. But if we go show, display humans label on chart, this will be in thousands of dollars. If you don't want to set it like that, if you want the entire dollar value, no problem. Just de-select that, select none and it would be the entire value shown. I just added a little dollar sign at the end. So it's easier to understand. We should actually do this to our data labels. So you can do the same with the data labels number. You can add $1 sign, not percentage dollar, press, add at the end. Make y-axis or Data Labels display currencies. We did that. Number five, PowerPoint, you can move things around here. Now the waterfall chart is a very specific chart. It always wants to have the title and items to be on the middle. You can see, I cannot move this. I cannot move the legend. Well, we don't really need the legend. So it's a very specific type of chart. Also. If I have selected and they want to add an item inside of it, you can see it's not adding to the waterfall chart. So as you can see, the waterfall chart is very specific. If you don't have this feature, you would need to count the entire value. Then subtract the change in value. So e.g. here we have 74,000 and here we will have 30,000. And you should need a stacked bar chart. A stack chart would allow me to make this bottom area. Click on this bottom area, on this bottom chart and make it simply invisible. We would need to count everything. So it would be a lot more work. So this is why it's convenient if this feature will be finally natively available for everyone. Thank you for watching. Treat this as a bonus lecture. And in the next lecture, I want to show you other cool tricks within PowerPoint. 47. 10-04. Combo: Something outstanding to me within PowerPoint is the ability to put two different charts on physically. One chart, this is called a combo chart. Let me take the data. We have laptop stands, revenue from selling and units sold. This isn't really a metric that should be put together, but we will manage to do so using a combo chart. The first task is add a clustered column chart. I'll open chart column, clustered column. Okay? I will insert the data. Of course, I need to reduce the selected data. And what do we have now? We have the revenue pretty high because we have this metric on the left side. And the units sold very low because we have this in a lower number. What can we do to change this number to task number two is right-click Change Chart Type and select a combo chart, right-click Change Chart Type. Selecting a combo chart. Here within the Combo Chart, combo means multiple on one. The revenue is displayed as a clustered column, but the units sold should be displayed as a line. Perfect. Now this will look a little different. You can see the preview here, but still not there. There is a special function called secondary axis. If you enable the secondary axis, you press okay. Column chart has its own axis and the line chart has its own axis here on the right side as well. This is beautiful. Number three is to right-click on the new line chart and format data series. You can also select the secondary axis by right-clicking on the series directly, formatting data series. And here in its native options, you can select a primary or secondary axis if you want this to be put on the secondary axis. Now, you want to add data labels for both. I'll simply select the chart, hit the plus sign, and select data labels. As you can see at this point, the data labels are barely visible. We will correct that in a moment. When we go to editing. Number five, adjust x values so they don't overlap. I don't like that the line chart is so high up here. I would like to lower their line chart to make everything more visible. I can do so by changing the values on the axis. And this applies to any chart you work with. With PowerPoint. I will click on the Access directly. I'll increase the minimum. It may be to 20, so it got a little lower, but the maximum should be much, much increased like 300. This way, we put this line a little lower. Now, beautiful, I can make the data labels extremely visible. Like number six is, make the unit sales data labels extremely visible. So those are the data labels for our units sold. You can see or you cannot see them. What you can do, you can click on them. You can simply go to the filling options. You can give them a solid fill. This is instantly better because we have a white color. If you want, you can of course, use one of the colors that we used previously. Then you can go on the right side of the text options. Give it white font. I'll maybe increase the font I press Control B. Now, everything would be much, much clearer and more visible. This is how you can edit a chart, not only a combo chart, but how you can edit data labels, edit access on chart, and make sure that if you use a combo chart, that sometimes it's useful to select it to be displayed on a secondary axis. Now, you can open PowerPoint and try that for yourself. 48. 10-05. Pictograph: Within this lecture, I want to show you how you can possibly create pictograms, meaning displaying data with help of icons and visual elements. This is the data I wanted to display. Here. I have a lower margin and then I have a big, large margin for energy prices. I wanted to showcase this on a light bulb. Look on the right side, I wanted to showcase that 72% of the energy price is the margin of the selling company will. But it's actually not about data. It's about what you can visualize with icon. It's important that we use a vector icon here. This is an SVG icon. If you have newest versions of PowerPoint, Microsoft 365, you should be able to go to Insert Icons and have graphical vector icons available here. Let's e.g. select an apple or what else we have. An apple would be completely fine. Instead of this light bulb, we have a PowerPoint vector object right here. We can change the graphics to make it a bit more visible. And I want to show you what you can do if you would like to showcase 25% of like Apple sales or 25% of something, I would Control D to duplicate this, 123, we have now four apples. I always take three of them. Shift click the third one, right-click format object, and I would increase its transparency. This way. I could display 25 per cent of hole. If I want 50 per cent, I would just reduce the transparency on the second one. This is one way of utilizing data and showing data as pictographs. What I did here, e.g. I. Divided this light bulb into several objects. You can do the same. Let's take the apple Control D, and let's put it on the bottom. If you would like to divide this apple maybe into three parts. Control D, Control D. Of course, put it next to each other. And what I would do, I would go to Insert Shapes. I would insert a different shape above this apple like that, e.g. here. Let me change the color so we see that better. Control D Now I would make it the same, but a bit higher here. And this way we can divide an apple into 123 parts. How to do this? Select the apple itself, the vector icon, Shift-click on this shape, Shape, Format, Merge Shapes, and subtract. If you select them in the right order, meaning the apple first and the shape second, you should be able to use the Merge Shape Tools to subtract. You can also of course intersect fragment. You will see how this feature works by subtracting, I'm deleting one object from the other, since those are vector shapes, vector object PowerPoint can recognize them and subtract one from the other. Now I will just need to go to my Graphics Fill. Give the apple a different color here, give it a different color. Maybe the red one is okay. And then just put them one over the other. Shift-click. Move them with Shift Control G. And we know divided this apple into almost equal parts. If you use pictographs, you don't always have to be perfectly precise with the percentage as long as visually, it looks very good. This is a bonus lecture. It's very difficult to use that instead of normal charts. But there are situations when you run into your presentations, when you have a given topic and you can display it with pictures. Keep that in mind. Remember that for the future, maybe you will have some ideas. This depends on your creativity, but from time to time, it's nice to create a slide with icons. Thank you. Practice this a little bit here within PowerPoint, I'll try to share an icon, either use this light ball or this apple, and you can work a little bit with it around. 49. 11-01. w3.org: I cannot start talking about accessibility any other way that informing you about W3 dot org? Let's get straight to this website. And this website simply contains all information, guidelines and good practices to make your presentations. Internet media, websites more accessible to people with vision impairments and any other disability. If you want to learn more, I'll tell you where to look specific and what is of most interest to us. On the left side, we have accessibility. When you enter accessibility, you have a couple of categories. Something that is very important is standards and guidelines. And this is exactly what this website is about. Currently, as I'm recording this video, we're still using the 2.1 standard. It has information about how big your font should be, what colors you should use, what type of contrast. And of course, this changes over time. So we have two points to draft. And also WC AG number three is already in the making. This is simply a document that contains information about how to make your media accessible. There is one more thing I want to point you that is of special interest to people within this course. If you go to teach an advocate. On the left side, we have make presentations and media accessible. And this is of special interest to me. I recommend reading, at least through the basics. And during the presentation or meeting. If I go to during the presentation or a meeting, we should speak clearly, use simple language, give people time to process information. Not like I'm doing now. Reading it so fast. I know or e.g. here, describe other visual information. If you are making a presentation, you're asking people to raise their hand and asking them about something. Some people raised their hand. As the presenter. You should then tell about half of the people raised their hand. So the people in the front rows don't have to look back and don't have to guess how many people have raised their hand. This is one standard. It's not a rule, it's a guideline of how to make your presentation more accessible and therefore better and more inclusive for all people. In the next lecture, I want to go straight into PowerPoint and show you a couple of tools how PowerPoint can help us to make our presentations accessible. See you there. 50. 11-02. Accessibility: Let's talk about the accessibility feature in PowerPoint. This feature is available both for Windows and for Mac. I'm not sure about older versions, but if you use the current version of PowerPoint 365, you should have it. No problem available at all times. You can click on anything in PowerPoint, on pictures, on shapes, on texts. You can go to Review. And there'll be checked accessibility if you open this feature. And new tab appears on the top, accessibility. And here you have a couple of different features like reading order and alternative texts. I'll explain that in later sections. Here. I wanted to tell you that this exists. You can turn it on and off. Here on the right side, you can select keep accessibility checker running while at work, or you can deselect it if you don't want it. You can also do this by going to File Options. And there is accessibility. You can keep it enabled or disabled. Another interesting thing is that it actually has a good help section. You can click on the Help section here. You can get some guides on making your presentations easier to read with screen readers, with captions and so on. I will show you one more trick in this lecture. This is actually an amazing trick. Curious how to do this on Windows. I'm sure on a Mac you can also filter out colors. Let me go to a colorful slide and let me show you something. I can go into color filter settings of my system. I can actually turn my screen gray. On gray scale. I can additionally, for people with different impairments with their view, also select those settings to preview how that colors are displayed. This is important. Create presentations. You can preview how the colors potentially will look to somebody with a vision impairment. Usually I have it set to gray scale and you can enable a shortcut. Windows Control C. Now, every time I do something on my PC, I can go Windows Control C, and I can turn it on and off, on and off. It's really convenient to quickly preview how your presentations or e.g. your picture would look on a grayscale. Those are the basics about the accessibility features. I'll explain you now a couple of things and how they work and how they help people. So stay tuned for the next lecture. 51. 11-03. Subtitles: Subtitle magic PowerPoint in its accessibility features. Let me go to Review. Accessibility feature allows to use our automatic subtitles that will be created by an AI of Microsoft, but I believe you need the Microsoft 365 version to use it. I'm not 100% sure on my version this is available. I have the newest version. Then I can select my spoken language and I can even try to automatically translate it into another language. Let's say that you are in France, you have a presentation, you speak English, but there's someone who speaks only friends in the audience. I'll turn this setting on. I need to stop my recording now because PowerPoint will not be able to take my microphone. Okay, Let us try at first to record something in English. Let's see how microsoft PowerPoint does. Okay, I'll change the subtitle settings, subtitle setting to French. Now I'll speak the same things again, and let's see how microsoft PowerPoint does this time. I don't understand French at all, so I had to take PowerPoint word for it. As you can see, it tries to create subtitles live when I'm speaking. If I start to play my presentation, you can also enable it. Here on the bottom, you can see powerpoint tries to translate live. What I'm telling on the presentation to French. I'm not so sure my English is good enough for PowerPoint to understand, but at least it makes its best effort to artificially create subtitles live within the presentation. This can be such a big help for people who have problems hearing properly, especially if they sit far away. It's an optional feature, but it's pure magic and it really works. So it's definitely something to look out when you try to make your presentations, especially live presentations accessible. 52. 11-04. Reordering and Alt text: Within this lecture, I want to talk about alternative texts and reading order. Let's say I've prepared this presentation. This is box number 123. Obviously, this is how I want it to be red. I'm going to review, I'm going to check accessibility. And here on the accessibility, we have Reading Order pain. I can see the reading order is improper. I should take group number three and put it at last. Why is that important? Is a very important. If someone uses a screen reader, I have enabled a screen reader for myself. Let's preview this presentation slide show slide for one. A pictogram is a chart that uses pictures to represent data. 32 basic ways to use pictograms. Pictograms can make your data more memorable. Excess ability dot pptx PowerPoint, slide for slide view. Did you see the problem? If you're reading order isn't properly setup the screen reader. We'll read it in the wrong order. The same goes for alternative texts when someone e.g. gets your presentation, Here's the picture. If I select Edit alt text, there is no alternative text. But on the second picture, I've enabled some texts. I wrote it myself, one wing of a plane on a blue sky. Now, look at that. If someone accesses this presentation and clicks on this picture graphic, he only knows that it's a graphic. But if you give it alternative texts, graphic one wing of a plane on a blue sky. The screen reader will actually know what that is. We'll read the context of this graphic. It's important that both you get your reading order in order and your alternative texts for things that need alternative texts. You can also enable alternative texts for basically any box, e.g. if the person who would edit this grouping, the first box explains what a pictogram is. Okay, he would now know that the first box is about this and that topic because I write ticket, I selected, Edit alt texts and I explained it in the alternative texts. If it's only a declaration, if it's only a box to decorate, you can mark it as decorative. If you mark it as decorative, the screen reader will simply go forward avoiding this shape here. 53. 11-05. Contrast Checker: Let me tell you about the contrast checker within PowerPoint. Powerpoint can also check the contrast of your items, and it will give you a warning here and the accessibility tab. If you open the accessibility tools, you can see hard to read text contrast on this oval. However, this text is also hard to read, but PowerPoint doesn't know, doesn't count the background color in. So only if I were to take this shape, this is a normal text box, but it is also a shape. If I would go to Shape Format, I would take shape fill and I will give it a gray color. Now PowerPoint would know, Hey, this great background on this object makes this text barely visible, please correct that. And this is okay, this contrast checker. That way. Powerpoints told me. But the problem is, if you have PowerPoint, I'm inserting a shape. I'm putting a shape here. I'll even right-click, send it to back. This text is now perfectly visible, but even if this tax would be not very visible, PowerPoint still doesn't know because PowerPoint doesn't know, hey, is this shape behind the text or not? This is a separate shape. So this is a little problem with the native PowerPoint contrast checker. It only works if you have a shape text right within the shape. So this is one object. This text PowerPoint will take into consideration because it is written directly on this shape while having it selected. So PowerPoint knows what is hard to read. You should know yourself as the designer, that you should avoid situations like that where the text is barely visible. Let me now show you a normal contrast checkers we use over the internet. 54. 11-06. Contrast Checker online: You know that I like to use Website with color schemes. Those websites also help you make your colors accessible. And you can see you have WC AG standards to 0.1. We have a double standard and triple a standard. That triple a standard says if the contrast ratio between you two colors is at least seven, your presentation will be very easy to read. So if I make this color darker, this a little lighter, you can see the contrast is increasing. This would be a perfect color scheme for use in your presentations because it is easy to read. On the Adobe website, color.adobe.com. Adobe also shows us some suggestions. If we cannot adjust the color, we can hit Apply to increase the concentration, to increase the contrast ratio. There are plenty of contrast checkers, e.g. on call or Adagio. If you go to Tools, there is also a contrast checker and basically any color scheme you use can be checked for contrast. We have the same default colors, but you can of course, use the color that you prepare for your presentation, e.g. something like that would be impossible to read. But if you give it a black background, all of a sudden, that contrast is beautiful and it will be superb even for triple a rating because we have a contrast above seven. Remember about that when you select your color schemes for your presentations to also be mindful about the contrast. With experience, you will also know which colors contrast well together. And this will make you a better designer and your presentations more accessible. 55. 11-07. Color Blind Safe: Some of you already know about this, but one particular reason why I do love the Adobe Color website is because of the new accessibility tools. And not only the contrast checker, but we also have color blind, safe. And you can see a simulation of how the colors you've selected would be seen by people with those impairments. And this is really perfect because here you can notice no conflicts found. Swatches are color blind, safe, and this is perfect. You input your color scheme here. Then you can double-check if you have a high enough contrast ratio and if it's colorblind safe to make your media accessible, I highly encourage you to always do that or to turn your system filters on your computer to make your screen grayscale or also simulate those impairments. And this will also make your presentations better and more accessible. I hope you enjoyed this content and we all learn something new. 56. 12-01. Master Slide: Welcome in this lecture where I want to explain to you how PowerPoint templates are made, what they are. And we'll start, of course, by telling you what the Slide Master is. This is a normal PowerPoint slide. If I right-click, I can change different layout. Some basic PowerPoint layout, but it also says additional here. This is just my name for my slave master. It can be named anyway you want, and we will change this. I want you to go to View and open up Slide Master. If you look what happens here, I will scroll to the top. We have one big slide, and this is exactly the Slide Master and some underlying slides under it. Those are the layout. Those are layouts that we can change for our slide to make our design process quicker. Because sometimes we know we want one big box or we want two big boxes. We have already layouts prepared for that. We can add our own layout or we can even delete layout. That's no problem. So this is how a PowerPoint template is established. But why is there a slight Master? Slide Master is the highest in hierarchy. We can right-click. We can rename the master, call it super master. Alright, that's just a name, but this super master can determine What fonts do we use, what colors do you have and how regular text on a presentation looks like. Let me do something like that. I have a funny presentation, so I want a different font. And the font, Aharoni, you don't need to use the same font. I'm just making you an example and I have text here. So the second text, I don't want to bullet-pointed and I want this text. If anyone makes Level two texts, I want this text to be read. Okay, what happened apart from the title slide, because we have master slide, title layout and then normal layout. All layouts that contain text inherited the changes that I made on the Slide Master. So be very careful. Whatever you put here in the Slide Master will be applied to all the layout. So you need to be very careful to not put crazy things on the Slide Master. Usually you put here some colors, fonts, how your design, basic design should look like, and what your brand guidelines or your company guidelines are that should be applied to the entire presentation. You can put it here, but as you can see, you need to be very careful because all layout will inherit that. If I would exit now back to PowerPoint, because this is a completely separate place. And I'm making a new slide. I making a different layout, e.g. these two content layout, I'm making some text. I press Enter, I press Tab. And you can see the second text is red because level two texts was determined in the Slide Master to be red. Now we have some problems because it's no longer a bullet point. And the problems cascaded down because I would need to again click bullet point. I would need to change it to level three. Now it's back black again. Be mindful of what you put on the slide master. You can, of course, by hand change the font back again. But I just wanted to show you the power of the master slide. And one additional thing, if I go to View Slide Master, you usually don't do that, but it is acceptable to right-click and have multiple masters light in one PowerPoint file. Because sometimes you have a company and your company makes two types of presentations. I would suggest to make them into separate PowerPoint files, but it is possible to have multiple masters lights within one PowerPoint file. This way, when I right-click, I click Layout, I have my super master with its layout. And now I have this custom design with its layout. Again, it gets a little crowded here, but I just wanted to show you the potential and how this technically works in PowerPoint. In the next lecture, I want to show you one more thing about the master slide, and we'll proceed with creating a PowerPoint template. 57. 12-02. BG Graphics: Let me show you one important. Let me show you one more thing about the master slide. I'm going to view opening the Slide Master. I will delete this second slide master because I don't want so many things here. I'm here on this master slide. Let's say that our company has a logo. I will insert a logo. Let's pretend that this is our company logo. You need to be very, very careful, as I said, because if I put the logo on the master slide, all layout will inherit that. I cannot click on it. I cannot click, I cannot change, I cannot delete it because the master slide has this graphic on it. So the entire presentation, we'll have this graphic, all the layout. There is one work-around here within the background section of this layout. Not the Slide Master, but this layout I can hide background graphic. This is sometimes useful because, because your company might say your logo has to be always in the top corner, but then you have a slide that's completely different in design, maybe it's black and your logo is invisible. So you can select that layout. You can make sure that on this one layout, the background graphics are hidden. You will go back to PowerPoint. And now each line that you make will always have this graphic here, this logo. But if you need to do something different, you can right-click layout. You remember that this layout didn't have the graphic. You click on it and it won't be there because we've hit the background graphics. If you go to design and you select any of the PowerPoint templates, you may think, Oh wow, How amazing those templates are. So impressive. They aren't, they are basically regular slides with just one shape in the background. If I go to View Slide Master, you basically go to the Slide Master. Either it's a blue color and the background or just a shape. But here you can see I can go to N or the layout. I can remove the shape, or I can play with it around. It will be somewhere different. So this is how PowerPoint layouts are made within the Slide Master will go now to layout and we will have some fun creating some for our presentation. See you there. 58. 12-03. Layouts: Before we start creating, I want to tell you what the layouts are truly are. If I'm on the Home tab, new slide, I have different layers to choose from, but I can of course, create my own layout. I'm going to view, I'm going to Slide Master, back to the Slide Master. And here within the New Slide Master panel, we can insert Slide Master or insert a layout. Within the layout. The very basic layout, an empty layout has a title that we can select or deselect, and has a folder that we can select on de-select by default is here, but unless you enable the photo written PowerPoint, it will not be visible. Now, what can you do on a layout? In essence, you insert placeholders that make your design process quicker. Let's say that you very often make a slide with six textboxes. Instead of making that, you can create a layout for yourself. Layout with textboxes or e.g. three text boxes on the bottom, 123, you can see we have this weird red color on the bottom. I need to change that in a moment or deleted back. So I would have three text boxes. Now go to insert placeholder and maybe three pictures. That would be a layout that I no longer have to design by hand and PowerPoint, because I can always select this layer within this one presentation. You can see it takes a bit of time and practice to do so. But let's pretend that this is a beautiful layout and I would have that. Now within my PowerPoint, what else can you give here? You can simply take a look at the placeholders. My favorite place holder is simply a content place holder. A content place holder allows you to select if you want a table picture chart or whatever you would like. So you are not restricted just to a picture or just to text because you have a content place holder and you can select for yourself what that is. It can be a double-edged sword. Sometimes it's simpler. If you want to make sure that the person who works in this file and later on works only with pictures, you give him a picture placeholder and there's no room for mistake where with a content place holder, there is a lot wiggle room and also room for mistakes because you can select yourself what to put there. If I would leave that now, Slide Master, Close Master view, I would select this layout to work on. It's the custom layout. Completely crazy, but you can see what happens now, if I drag and drop pictures into PowerPoint, they will be automatically placed here. I wouldn't have to crop them to make them smaller. They would be automatically placed within this layout. So this is the power of a layout. But a layout has also its problems because you don't always want your slides to look exactly like that unless your company tells you. So sometimes you want it to be different and you can run into a trap of making too many layout like PowerPoint templates, e.g. the ones that are sold or that are very advanced, can have like 40 or 50 of those layers and it's difficult to find something for yourself. So just keep that in mind. We will later on create a couple of layout, professional layout for ourselves, for our presentation. And I'll show you what to mind and how to do them. This is all I wanted to explain about layout. You now know what a master slide is, what the underlying layout are. You almost know everything of creating a PowerPoint template because this is the whole package. 59. 12-04. Guidelines: Showtime, what if I told you that we will now together create a PowerPoint template for ourselves that we will later on use to create a presentation. Let me start by custom trick that I personally use. And almost nobody knows about this and doesn't use it. You know, that if you go to view within PowerPoint, you have something like guides. You can insert guide by right-clicking Grids and Guides and inserting a vertical and horizontal guide that like standard normal, regular procedure. But what if we go one step further? Go to view, go to Slide Master. And I want you to click on the first master slide. Let us do something for ourselves and put one guy on the left side and one guy on the right side. And we will try to not go over those guides. Right-click grids and guides. At vertical guide. And right-click, maybe add another vertical guide. I will put one on the left side, negative 638, alright? And positive 638 as well. Alright? Now, imagine that the presentation that I'll create width you, this business presentation. We will try to not go over this line. We will try to always leave displays empty. And this guide will help us tremendously. Why? Because we have put it on this master slide. I will put another guideline here on the right and left side, but maybe that a little bit later on, I'm closing the Master View. Now within PowerPoint. I can of course move the guide that I created, but the ones that are created on the master slide will be always there and I cannot click on them. You can see the ones in the middle of work-related in this like Mr. as well. So they will stay stay there, but I cannot click on them. I cannot move them. And every time I will want to make something pixel perfect, we'll enable and disable the guide. You can see I've put them here in my Quick Access Toolbar. You can do that by going to View, right-clicking on the guide and selecting Add to Quick Access Toolbar. I think it's a pretty convenient feature to quickly take a look. Okay, we are perfectly fine here, deselecting it and we're ready to create another slide. You just started to create your template and you are starting to do it the right way. Because we've already set some guidelines for us. Go to PowerPoint, go to View Slide Master, and try to create the guidelines on the left and right side. 60. 12-05. Footer: In this lecture, I will show you what we can do with the footer and we will establish a footer for our template. Let us pretend that we are working for a consulting company called construct. And we were tasked with a quest to create a company presentation template that we will use within this year. Okay, no problem. We've set some guidelines. Let's go to View. Let's open slight master and make sure that you are not on a layout because by default PowerPoint and it's allowed, but you want to be on the Slide Master. You want to make this footer to be a guideline for all the photos and the layout. What I will do, I will take the slide number and now you can see why I have those guidelines. I don't have to think about it. I just put it to the right side. Like that as I make this smaller. So this slide number should be in the right corner. Now I take maybe the date and I put it next to the slide number because usually we will not use the date. The text of the photo. I'll put it on the left side. It's on the left. Maybe smaller, maybe not. I have some texts prepared here. Copyright, a given year, conscript our company name, and all rights reserved. This can be changed. Of course, this would be just the default text. If someone inserts effort or what's the last thing you would like to do? Go to home and make sure it is justified aligned to the left side. Note that we have some gap here, even though I brought it to the guideline, we still have some spacing here. You could change that by clicking on the text box format shape. On the right side we have shape, options and size and properties. Within the Size and Properties, we have text box and you have margins. I could reduce the margin to zero, but it's a double-edged sword because then I would need to reduce all textboxes to zero because I want everything to be nicely aligned. By default, I'm leaving the margin at 0.1. What we will do later, maybe we will take this 0.05 and we will put it here for now. Let us leave it at 0.1. This text will not appear by default, but I wanted to see how that looks. You would need to have this somewhat prepared when we are within PowerPoint. Now, I know that if I go to Header and Footer, I inserted the slide number, I insert a photo and I put some texts here. I will apply to all I know that the text will be on the left side and the text on the slide number will be on the right side. Perfect. We know that we use the guidelines is perfectly placed on the left and right side. And we are done with adjusting the footer for our template. 61. 12-06. Font: Changing the font, one of my favorite parts of making a template better. Let me suggest that we will use a different font for our presentation. By that, I mean going to View Slide Master and actually determining a font for our presentation. You can see we have a color font effects. And those teams will of course, save our team later. We will call it something cool. But before we do that, we need some fonts. As you can see, I have a couple made by myself, like font pairing that I like. I like Montserrat, I like Open Sans. I like Poppins. Who doesn't. Yoast is also a very interesting font, Butler, but also just something simpler. Maybe lateral. Letter fund is a completely free font that you can use for your commercial and private products. If you don't have it installed on your PC, you need to exit PowerPoint, install it, and then come back here into PowerPoint. If you do not know how to do this, e.g. go to Google Fonts, there's Google Fonts. Download or just go to Google Fonts directly type in lateral. And somewhere here currently it's on the right top side. You'll have downloaded family. You will be able to install the entire font family. You need to unpack it and simply installed, I will download it if you've never done something like that, I have that on here. I will extract it. In my case, it's extracting herein in one of my folders, letter font, I can simply select all the fonts, right-click, install them. On a Mac. It's a little bit different, but it's also very easy to install font. Let's say that you have installed latter font. What's beautiful here now that I can go to fonts, I can go to customize fonts, and this is a thing of beauty. We can determine a heading font and a body font. And wherever we use a title or reuse a textbox here to enter some text, and we change that later. It will automatically change with the body font and the heading font. Let me go and find lateral directly. I have lead two. I have a bunch of different letter forms that are black hairline light. Usually you go for the titles, earthly, bolder and for other text, body text, a little lighter, but let me go simple here. I'll use lateral, the normal font. It is also very beautiful to use a normal, not bold font for the body font as well. Lateral. Okay? And I already have this combination, but you can call it for yourself like lead TO nice lateral, lateral, double, double, lateral. E.g. I. Click Save. And this is now a new font style I saved for my presentation. I'm going to home for my title. This is the title layout. Those are normal layout and this is the Slide Master. I also want to click on the title and make it smaller. Like 32 is completely fine for the text. Since we are talking about a business presentation, probably 18 across the board will be perfectly fine. Now, what I did, all normal layout will have this text size, of course, the different ones that are bolded, not nothing more to do. Slide Master, exit. What's beautiful about that? If I create new slides on different layers, I'm typing within the text and I'm typing within the body. Now we can see lateral body. If I decide for myself, well, this one doesn't work. I go to Design. I can open, not designed with variance. I can font, open font, and I can use different fonts. And they will apply to my presentation because they are both on titles and on textboxes. You can create really cool font pairings for yourself. And there'll be applied to your entire presentation with one-click. A beautiful feature, I recommend downloading lateral setting up later for ourselves. And later on, we will create a couple of layout that will go beautifully along with this font. 62. 12-07. Color Scheme: Let us continue creating our PowerPoint template. You a little bit bored that when you insert a shape, it is always blue. If you change the color, you have always those default colors. Not with our template, are both gave us our accompany colors. And I've selected a couple of red colors we will use for creating this template. Go to View Slide Master because this is where we are at home. No matter on what you click, we have colors. We've already selected the font. This is letter font. Now we want to select colors. You can see I have a bunch of teams created by myself, but I sometimes change them around. Those are the default Powerpoint colors. I want you to click on, Customize Colors. I want you to use a completely custom color and you will create it on your computer. Those are the colors I will try to share this file or just simply try to copy over their values. If you have a newer version of PowerPoint, I want you to change that first dark color, select more fill colors, and go to Custom. Either you enter the RGB values, which you can see here, or you copy over the hex color. I'll put the hex color here. Alright? And the second color as well. The second dark color, I have it here. I'll put this file in the resources, of course. Okay. I want you to like leave the latex. Latex is okay. I want you to change all the accent and also the hyperlinks. You can see we'll have beautiful charts. When we do that. I'll do this one color by one color. That's not a big issue because I want to establish this. And you will be able to use this in all your future presentations within PowerPoint. How cool is that to create a couple of good color schemes that you can over and overuse, especially if you work in a company. Let me do that really quickly. X and number four. Now, I've created this color scheme. You can already tell. It works well along together. Maybe the text background could be a bit brighter, maybe white, so we don't have it that dark. Okay. Now, give it a name you like e.g. red hashtag one. It depends on your personal naming. I tend to keep it short and clean, like red, parent dies, let's call it read Paradise. One. Press Save. Congratulations. Not only did you establish a color scheme for this template, you already have now a color scheme on your computer. If you create order PowerPoint presentations, you will see e.g. I. Have here, read Paradise. It's interesting that we chose a gray color for our texts and red color for our elements. Now, any new shape you enter into PowerPoint will already be read. Not only that, if you go to Shape Fill, you can see we have this beautiful gray color for the text. As our company instructed us to weave beautiful red colors and shades underneath to use within this template, within this presentation, this is great if we plan to introduce some charts, e.g. a. Chart like that, boom, it's already read and beautiful and Colorado and graded, not like the default one. Tried to replicate the step and create your own color scheme based on the colors I've added here on the screen. 63. 12-08. Layout 1: Let us now create together layouts for our presentation by default, if I right-click, go to Layout, I have those multiple layers with I would like something completely different for our company presentation. I immediately, I immediately go to View Slide Master and I take a look what's happening here. So we have the master slide, then the title layout, and then normal layout. What I want to do, I want to delete all normal layout so you really learn to create templates. Now, this will be our title slide. Let's make something different than PowerPoint proposes as default. At first, I want to take the boxes, put them a little bit to the right. I think it would look really cool if we have no photon in the title slide. And we put a picture on the left side. How to do this? Let's insert placeholder. Insert placeholder, select the picture placeholder and put it perfectly on the left side. When it comes to the size, I would say something about one-quarter of this slide, something like that. Okay. We have a picture placeholder. In my opinion. In the middle of the slide, we just have the title, subtitle, and date of the presentation. We already have two placeholder boxes here, so let's use them. I'll put this on the left side and we don't need to be pixel perfect here. Just think about how this would look. Make it smaller, and definitely the text should be way smaller. I'll go to Home and I'll reduce it to maybe 44 points should be okay. Now, how do you want the text to be? Since we have a picture on the left side, I would prefer to align it to left as well. Align left. And I'll extend this a little, maybe not completely to the end, but to hear a title slide is something a bit different than our entire presentation. So here we are breaking the rules a bit and we're not going for the full size, maybe something like here will be fine. Now for the subtitle, the same thing, I'll make it a little smaller and of the same width. I will align it to the left side and you notice something different. The text here is aligned to the bottom, and this text is aligned to the top side. I would like this text to be aligned to the top side as well. Right-click on this box. Format shape. Under the Format Shape options, you don't only have the filling options effect, but you also have size and properties. As we have the margins. The same way we have vertical alignment. And I will just change this to middle or top. Let's make it top so everything looks consistent. We have the first and second text box. Let me go to insert placeholder and put another placeholder text box here. So we have something for the date. This will be the date. And I don't want this. I will click on the box. I don't want this by clicking on home. I don't want this to be a bullet point. I want the color to be actually the color of this template. So the red one. So the date will be set as a red font color. Beautiful. My last adjustment is the font size. Here. We have home. Maybe 44 is a bit too much. 40 here, 24 also to March 20, and they should be consistent. So let's make it 20 as well. This way, we created our first slide layout. I'm going to Slide Master. I'm closing Master View, menu slide. Beautiful. I will deselect the guide so I see more. This is a template for our title slides in our company and we could use that for multiple presentations. It was very simple and it's an advanced technique. In my opinion, it's a little nicer than the default layout from PowerPoint and it definitely stands out. See you in the next lecture where we'll try to create a couple more Layout and we will be ready with our template. 64. 12-09. Layout 2: Let us create a layout number two for most of our slide. And just to tell you something about templates, you don't always know at the beginning of creating your presentation, what type of layout you will need. Normally if you use PowerPoint, create presentation first, so you know what type of layout you need. But here we are, have specific guidelines from our company. Let's pretend it is like that. And we know how to do a couple of those layers because we already have presentations from our company. Let us do layout number two in this slide for regular content powerpoint slides, I'm going to View Slide Master immediately. I'm going to right-click and insert a new layout. This is the default layout we currently have. I don't like this very much, so I'll instantly take this title. I'll put this title to left side. You can see how useful those guidelines will be and we need to decide now, how high do we go? Let's put it a little higher. Just eyeball it like that. Or if you want to be perfectly precise, right-click and you can add a horizontal guide. Let's skip this step for now to not complicate things. I have the title, I want the title to have room for maybe two lines, and I'll right-click Format this shape. Go to the Text Options and again, start from top. I like when it starts from the top and left side, you can see on top we have a different margin than on the left side. I want the same margins. So top margin control C, control V, Control V, Enter. Now everything will have 0.05 margins. I think this is pretty good for consistency. I will insert another placeholder for texts are simply content. For content. And I will make it to the size of almost the entire slide, something like that, with little space between the content and the title. I want to get back to PowerPoint and see if I will fit two lines of texts. Let me check the size home, the sizes 32. And for regular content it is 18. This is acceptable. The default values, my PowerPoint are set pretty Okay. Slide Master, Close Master View. I will create a new slide. It automatically added this layout as the default because the title slide is only added once. And I'll just place a sample text here. Okay, I can fit two lines here. It would be perfect if you could fit three lines. But that's not always the case. If you want. We can later change this to 28 to fit three lines. But for now, let's maybe stay at 32 and see where this will get us. I think we are ready with this new layout. This layout is perfect because we have plenty of space for the title and plenty of space for content. In the next lectures, we will try to create a different type of layout that will be used for many of our upcoming slides. 65. 12-10. Layout 3: Now let's prepare a slide layout for two types of contents. And I can see I've made a mistake here by putting this too far. View. Slide Master. We are back at work. I will enable the guides and I'll make this a little shorter. And also the I don't know why I did the photo like that. Let me put some texts here. Let me also put the same text on the slide master, and I want to divide the middle content with another guideline. Let me place at vertical guide. Right-click add vertical guide. This one is 0.17. This is okay. And this will be also 0.17. I'm making some empty space in the middle. If you want, you can change the color to yellow. So it's a little bit less visible. To create visual space for ourselves. I have this layout. I will just press Control D to duplicate this layer because I want to create almost the same layout. We have now, everything perfectly positioned. And also, I'll make sure that those layers have pixel perfect. They are exact mirrors. I duplicated it, so I don't have to worry if I made a mistake. Now, I will reduce this content place holder. And you can see how useful those guidelines can be. I'll press Control D on this placeholder and I put it on the right side. You can see everything seems to be pixel perfect. Let me get closer and see if this is on the same level. Okay, I will select this. I will select this. I'll even go to Shape Format, airline and select Align Top just to make sure because if one would be lower by mistake, if you select both of them with my shift key, Align, Align Top. I make sure that everything will be aligned to the highest item. Right now, everything is perfect. I will deselect the guide and we have prepared a layout for two types of content on our slide. It's perfect, I love it. And I won't even right-click. I will select Rename layout entitled to content, maybe h4s or to content LR to content left, right, because we will do another one in a moment. This is exactly what we wanted to achieve within this lecture. Let me go to the next lecture and create one more slightly out for us. So we are complete with our PowerPoint template. 66. 12-11. Layout 4: You get the idea how templates are created and how layouts are added. Let me add one more layout to round up our presentation template. Let us create one additional layout that might get useful with our slide creation. I press Control D to have, again, everything perfectly aligned the same way. I'll enable the guidance. Was he a little more? And I'll put this to the top side and this one to the bottom side. Now, this is the middle line, but you can notice we can't exactly use it. So what do I will do? I will enlarge this to this entire slide like that. And I'll just press Control D. I will make sure that they will put one above the other. And I have still some spacing between the photon. We could put the foot or lower to not waste any space because I'm not sure if we will use the folder or use this for source material here. So let me select this. Let me select this, also this. And the first one, I've selected everything on the slide. And let me show you a little trick. I wanted the gaps between this and this and this to be perfectly equal. So I'll select Shape Format, airline. I make sure that a line selected object is selected and I'll just distribute vertically. Now, I made sure that this space, this space, and this spacing is perfectly equal. In my case, when I click on this shape, I go to shape format. You can copy the values. If you can predict fit in. The values of my height is 2.48. For the title 1.45. And basically, those are the most important values. 12, 12, 75 is the width. But if you have a different width, that's no problem. I just wanted to teach you how to create another layout for us with two boxes above each other instead of next to each other, I will rename it renamed layout. It will be two continents, maybe TB for me, it top, bottom. For me, it's understandable. You need to come up with your own nomenclature. What's also important? Let me close the Master View. If you go back to your presentation, you right-click layout. If you have like 20 or 40 layout, you need to give it short, understandable names, descriptive names, so you will know what you are actually doing. Sometimes I also go into View, Slide Master and creating another, one, another template with an empty space. I just rename it to blank. It's really useful to have something like that as well. Congratulations, we completed a couple of layout. Maybe we'll come up with a few more. But for now, this would be perfect for creating a PowerPoint presentation. It's essentially a template done. Let me go to the next lecture. I'll show you again something exciting. Let's save this up and you will be able to reuse this in the future. 67. 12-02. Save Template: The moment we have been waiting for, save this as a template. How to do this. I'm going to view to Slide Master. I'm just going through it in my head. We established a slight master. We established a title slide, 1234, different layout. We established colors, we established font, namely lateral and lateral phone. We added a photon, but the photon could be changed, or maybe next year it will be changed when our company requires changes. So now we can click on Teams. Save Current Theme. This is a glorious moment. Let us call it e.g. red lateral, lateral. We will understand that this is red branding color and lateral, lateral is the font. You can of course, naming differently. Find your own nomenclature and press Save. Now, every time you come into PowerPoint and you are like bored by the default, setup, colors, fonts, and everything. You will just go to design. You will open the themes. And under the custom themes, that will be something called red lateral. Lateral. You will click on that and it will automatically switch. They found that text, the colors and everything, including the layout will be already here. Oh, it duplicated because I have 1.2. I click on it a second time. And if I go to View Site master, the layout simply duplicated, but that's no problem. I can quickly delete them and you have 12345, beautiful layout. And we are ready to create any type of presentation with that. And you can add more layers later on if we need them. 68. 13-01. Topic: Hopefully my voice will sound now a little better. Welcome to the section about making a formal business presentation together. Let me explain the topic. It's 2041 and you are a consultant company called conscript. You will be the consultant making the presentation for a client called freshly. Freshly is a company that sells fruit juice and face declining sales and identity problems. For a few years already, they came to us to find more insight into the market they are in and possible solutions as to what could their next steps be? How could they change their product and what would bring them back financially? They gave us plenty of information about your company, about your product, about their expectations. We made thorough research and we want to prepare a presentation for them. Let us start working. 69. 13-02. Storyboard: Welcome. In this lecture, I will explain to you something about a storyboard. In the upcoming lectures, we will finally start to create this PowerPoint presentation, a formal business presentation based on data that we first research. As you can see, that design is rather formal, but what's more important before ever opening PowerPoint? Well, ironically, I did this storyboard in PowerPoint, but before creating the presentation, I created a storyboard for myself where I put a key argument, supporting arguments under it. And both of those create one slide. So basically I could get to my storyboard, okay, this is slide number one. This is slide number two. This is slide number three. And so on. Slide number four, it's maybe Slide number five, and this would be slide number six. This makes your work so much easier. It also allows you to organize yourself without extensively thinking what to put up next. At first, I made a thorough research, then they put everything into a separate PowerPoint slides, and then I tried to organize everything into a story that would make sense. I started the story by explaining what's going on in our company, What's going on on the market. Then we went onto complication. The complication stems of problems within our company and within the market. Those were the negative complications. Then they went into positive complications. Since our fruit juice sales went down, the product is no longer look like, interesting for customers. So this creates opportunity to re-brand yourself, change the product, or do something new and fresh for our freshly company. Not all data will be real here, but the effort I've put into preparing the content and the presentation will be very real. Remember I made this research and all these texts, so you don't have anymore. I want you to focus 100% on PowerPoint and creating a professional, formal business presentation that uses guidelines that we set up for ourselves. In the next lecture, I'll ask you to open the template and a text document. That text document will contain both the storyboard if you want to look into it, and texts that you will put into each of the slides. Do not mind the ugly design of this. This is only text that I prepared for you, so it will be quicker and easier for us to work together. Within the next lecture, we will finally prepare the next slide based on the template we've already created for ourselves. And I cannot wait to start working on the presentation. Let us start with in the next lecture. See you there. 70. 13-03. Title: I'm really excited to be starting our presentation journey. If you prefer the template, you can simply open PowerPoint, go to Design and click on the template and start working. If you didn't or if you want to work on the same file that I just go into the resources, open, the business presentation template and the business presentation text. The text is here. You don't have to write everything yourself. I will put the text here. At first we have the storyboard. Then here on the right side, there will be some of the texts. I will maybe change the design of this, but this will be simply the texts to put on the presentation template opened. Make sure that you maybe have to right-click layout. We want to start with the title. I will actually start with the photograph. I don't need these copyright information on the title slide. The photograph is also within the resources I just downloaded. Fruit juice image like that. Put it here. Powerpoint will automatically put it in our placeholder. Beautiful. Now we can start to add the text. Make sure that you select only the text, not the entire box. Because if you select the entire box, it might copy over wrong. Okay, only text control C. This is the title of the presentation control V. Now bear in mind, since I copied text over it, inherited the design from this word file, I need to press Control or Command and keep text only. This way. Powerpoint will know, okay, I'm keeping only the text, but the formatting is from this PowerPoint file. And I will just repeat the steps for other things that I want to put here. Here, Control T. This will be my subtitle for the date we've selected, December 2041. And I would also like the logo of my company to be on the right, bottom side. If you remember, the company is conscript. I'll just take the logo from the resource files, put it on the right side, put it on the bottom. Beautiful. You can enable the guide just to see where we are at. And also some copyright information. I wanted to put this under the logo, again, Control key, because if you do that, it will automatically make lateral font out of this. I will make this much smaller. Is also a little smaller, maybe like that. And let me align it to the right side together with the logo. It's aligned with the logo. I can shift click on the logo and press control or command G to group them together. I think this will look perfectly fine. Maybe a little bit more to the right side. Okay. This is fine. I don't like the big gap between the text here. Since this is only one line, I can click on the text itself or on the entire box. Right-click Format Shape. Go to its texts options. And instead of on the text options, instead of the vertical alignment bean top, I will select bottom. And now they are closer to each other. This way. We've prepared our title slide. If you don't want the number to appear on the bottom, you can go to Insert Header and Footer and you can de-select slide number or don't show on title slide apply. And since this is the title cite, it will no longer be visible. Beautiful. We prepared our title slide. Now I can select a new slide and powerpoint automatically did change the layout to something different, the custom layout number one, then we have a couple of more layout that we preferred for ourselves. See you in the next lecture where we'll work on the next slide. 71. 13-04. Statement: The second slide will be a big statement that opens the entire presentation. And I want this slide to look completely different from the regular slides. So let us start creating something like that within our presentation new slide. This template is okay. We need to copy over the statement, slide number two, statement. Take only the text. Now put the text here. Control V, and maybe with comfortably get rid of the bullet points. Alright? You have a choice. To be honest. This might be the title. You have a choice, right? And I want this text to be on the middle. And these texts also in the middle. I want both of the texts to be really, really big, like huge. I want this to be a very important information. I would consider making this a little smaller. You can make it smaller like that. Or Procedure Control or Command key to make it smaller from both sides. You can see we adjusted a little bit of the appearance of it. I will put that lower and I'll put that lower as well. Now, this is a really In your face important statement. Let me use some company colors by changing the right-click Format Background. Give it a solid fill from the colors. I'll select my first main color and see how that looks. Obviously, this color doesn't work with a gray font. So I'll select everything, this and this. I will just put it in white. I think this looks okay, but I would put a box behind that just to have some differentiation between the headline and the actual texts. I'll press Insert Shapes. In my case I have a shortcut Alt to do so. And I'll put a rectangle behind this main text. I need to format this rectangular a little bit. Maybe like change the color for now just so we see it. Right-click, send to back. I want to make sure that this is in the middle. So I'll go by having it selected, Align, Align center, beautiful. Let's do something completely different and use a pattern fill. Pattern fills are usually a little bit crazy. And you can select a pattern and you need to select two colors. Color number one will be like one of the red color number two as well, one of the red. This way we created, if I come closer you will see a little pattern. You can of course, change the patterns to see them a little bit more because the colors overlap a bit. I'll also shape, outline, select no outline. So it gets blended into this design. I think this is okay. Like the colors are barely visible if you don't see the patterns, just select green for a moment and maybe a pattern like that. They are not perfect, but it depends also on the color. You select, the background color. Let's make it a little lighter. Okay, this is too light, beautiful. Now we prepared a statement on the second slide. I think that the copyright information either delete it or make them white because we can't really put them in gray writing because they are very visible like that. This would be slide number two. 72. 13-05. Slide 3 Text: Slide number three will be very enjoyable to make. Putting items on the left and right side. Here's number three is of course the executive summary, but this is made on the end. We will make a slide like that. Okay, Let's start creating new slide. Right-click select layout to content left, right. This is the framework, the templates, the layout that we want to use for our slide. I will of course, need the text for slide number three from my file. And the title Control D. This would be the title. Now on the left side, we will have a chart. On the right side, we will have some information. I will take the information right away, Control C and Control V them onto the presentation. Make sure that you control and only paste the text and see what happened. Completely. Like it got a little crazy with the formatting. I want to delete the bullet points and also make the bullet points are a bit different. I will delete it by hand. I will make the first statement bold the key takeaways. Then I will select all the text and give them a normal bullet point that goes along with the formatting of our presentation. We prepared the main part of the slide. In the next lecture, I would like to work on the chart that we'll put on the left side. And stay tuned for that, because we will use a couple of tricks to make this slide complete. 73. 13-06. Slide 3 Chart: In the second part of the slide, I want you to use the chart data. Just select the chart data like that. Press Control C and go-no fully to PowerPoint. For the chart, I'll go to insert the content called chart. We will use a normal clustered column. This is perfect, but for the column, as you can see, all the colors are already perfect because we made a template for ourselves. And I'll press Control V to make the series and the data. I want to reduce the series only the first one. And I'll close that down. You can see 2041 is only projected sales. So we need to immediately click on that. Click on this once more. And instead of a normal fill, automatically, Let's go to a pattern fill. A pattern fill will suggest that this is some kind of projected data. This already looks a tiny bit better. For the title. I would suggest going to home and putting it on the left side, maybe smaller, like 18, and putting it on the left top side in million units, I can press Enter to put it on the bottom. And maybe the title could be controlled, be bolded. This looks a little cleaner. I don't like that. I have to guess the data points because we are actually talking about fruit juice sales. So I'll click on the series. I'll click the plus sign. And if you know, we can enable data labels. Since we enabled data labels, precisely, we can get rid of the left axis, go to access, and get rid of the vertical axis. Now, everything looks much more understandable and cleaner. You can see we also have the years here. We don't need an a legend. I'll click on the legend, press delete, and this now looks really solid. The data labels are very important for this slide. I'll press Control B, and I'll make them a tiny bit bigger, okay, to 16 points. This should be perfectly fine. And we see a huge collapse here between the year 39.40, 2-17. We can insert a speech bubble, like going to interchange. We have some basic call out here on the bottom. I can e.g. put a call out here that we'll refer to this point. And -300,000 unit sales. This will be an important information that is probably a key talking points within this presentation. So I wanted to highlight that for the Shape Fill, I'll revert to a gray color, but a gray color that will make my text visible, beautiful. Ignore. This looks now much more consistent. Something that also divides the presentation into health. And to make sure that this information goes into that information is inserting a triangle, a right pointing triangle. You can use a normal triangle. You can shift it around, press your shift to the right side. And you can simply make it much, much narrower and put it like that within the middle of the slide. This indicates that the information on the left side directly translates into the key takeaways between blah, blah and blah, blah, right? If you want more space because it's getting a bit crowded here. We put up guides for ourselves, but there's nothing stopping us to put this a little bit to the left and this abuts to the right. We can go like that. And like that. This would be still a very clean and I think we are ready with this slide. And this way, you created slide number three of our business presentation in forming on what's the situation on the market. 74. 13-07. Slide 4 Left: On this slide, we will make two charts next to each other. If we take a look at the storyboard, I prepared a bunch of information for this slide. But what I actually wanted to say is that fruit beverages is just around 5% of the drinking market. And water consumption is increasing in households over time. And because of that, I will create a new slide and let me make it a bit simpler and use charts, data visualization instead of texts, come to the text file and take slide number four with the situation on the market. I will double-click to copy over the title. I'll paste the title and I'll make sure that I'm pasting only text. Okay, let's get back to the file and let us paper the first chart. You can immediately see we have plenty of data points here in my head. This is already a line chart because so many data points, it will definitely look very good on a line chart and it also will explain the trend we want to showcase. I'm going to a line chart, either the normal chart or the width markers chart. Select, Okay, Go for the data and press Control V. Beautiful. I'll make this a little smaller and we've put here all the data points. It looks at tiny bit ugly right now, let me make a couple of adjustments. At first, delete the legend. Now the bottom axis, I don't want so many years to be displayed here. I want to write it Format Axis and under the label feature, specify unit and make it four or 58 is depending on your preference for years. Everything is now maybe 563 years. Three years works as well. Now, if you look on the bottom here, we have like ten points of space, but on the top side we only have five points of space. I'll click on the left axis, and I will change the value to 150. Now it is kinda more in the middle. I want to add a couple of data points just to inform the viewer what is happening here. Maybe a data label here. Go a bit further. And other data label and one data label towards the end, we can see a natural trend. If you want to go one step further. And underlying chart, if you really want a trend, there was a trend line. You can actually open this and use a linear or maybe forecast line. Maybe the linear, and it clearly shows an upward trend. This is very relevant to what I wanted to say. Now, look at this. On the bottom. We have yours. It's kind of self-explanatory, but is it on the left side, we have liters consumption. But do we actually know is that liters, is it cups? Is this percentage? You always need to inform percentage or liters or everything of what. I'll make Control V on the first line. I will go to the second line and write in liters daily average in the United States and 23 to 40 year. Okay, I want to add some labels to this axis. I can do so by going to simply selecting this chart, pressing, insert shapes, and selecting a normal text box in liters. You can see there's no space to put it. I will create space for myself by just making this chart a little smaller. This as well, a little smaller in liters. Control D, since I'm doing the liters, Let's maybe a year. Year would be completely fine. Okay, it can be a big letter. And we also have no space for the ears. So I'll again click on the chart. Put this chart the higher the year here and perfect. We created the left side of this slide. In the next slide, I would like to do the second chart with you on the right side. 75. 13-08. Slide 4 Right: Let us now work on the pie chart on the right side of this slide. As always, open the file with the text, go to slide number four, situation. And I'll just copy over the data. A pie chart will be relatively simple to create. Just insert a chart, select pie. You should already know how to do this. Press Okay? And just here, pick the first one and paste the data. We have the data and I'll close it out. You can see we don't really know what is happening here because I don't want a legend, I want data labels. So I click on this plus sign, delete the legend, and insert data labels. But the data labels themselves don't look very informative right now. Right-click Format Data Labels. We can very quickly change it. Make sure that you select the percentages. Where is it now? Go back, Label Options, de-select values, and category name should be definitely here. I will maybe make everything a little bit bigger, like that, maybe 14 points. And I will make sure that everything is white, of course, besides our fruit juice and milk. So this one will be dark gray, and this one will be dark gray as well. If you want. If you want, you can Control V and make fruit juice a little bigger, but you don't have to. I will inform about that when presenting this presentation. You want consistent design across this presentation. This one is in the middle of this text, and this title is on the left side. You need to decide that you want to be very consistent. I will press this little. I press Enter Control B here and put it on the left side. Now, what has happened? I want this to have 18 points, okay? Make this a little smaller and everything fits now properly, but it also needs to be aligned to the left side. Now, everything is beautifully in the corner here, and in the corner here I see I made one space here, didn't I? I didn't align it to the left side. Now, this was a big mistake. Now, everything looks very consistent and we have prepared our next slide. In the upcoming lecture, we will work on the situation on the market. It will be really interesting. So let me get there. 76. 13-09. Sections: Our presentation gets a little heavier. It will be useful to right-click and create some sections. This was added, I believe in PowerPoint 2016. I don't really remember, but older versions didn't have this. Newer do have, I will call this introduction, and I'll separate the market information from the introduction. So this actually was my situation. You don't have to call it exactly situation. It can be like market evaluation or something like that. I'll go with introduction situation. Now, we will go with the complication part of this presentation. It will make much easier to navigate between slides because at any given point I can close different sections and work on the under section I'm currently at. Please do so for your presentation as well. And in the next lecture, we will work on another cool slide. 77. 13-10. Slide 5: In this lecture, we will make our business light divided into the top and bottom part. If I take a look at the storyboard, we have a lot of information here, so I wanted to make it attractive graphically. We have all the text here. Let us start, of course, with the title that I have already written. And let's go to this slide. We can put the title here as always, use only the text. And since we already used in this presentation left and right, Let's now go for a different layout, meaning top and bottom, because we prepared something like that for us previously. I can see I have one more layer of explanations like brand problems and product problems. Let me take the information is first at this text here. The second information, as well as text. This isn't really attractive, so I'll take this l, put this a little bit to the right side, and I will maybe make sure to right-click Format this object. Go to the text formatting options textbox and simply put it in the middle of this textbox. This might look a bit better. I need to delete the unnecessary line that has copied automatically. And this already looks a little bit more promising. To add some design value. I'll insert a shape and make a shape like that. Make sure that you open the guides and that you do not go overboard. You can go a little closer. You can scroll it like that and you can put this perfectly here. You can see it automatically aligns with this textbox. Beautiful. I'll press Control D, and I'll align this as well. Naturally, it all looks really good. Now here I wanted to inform about some brand problems, and here I wanted to inform about some product problems. This is a formal business presentation. Usually, I would also add an icon here. It depends on the type of presentation you want to create. I think we used everything we wanted. I somehow wanted to divide the top side from the bottom side. I'll insert shapes. I will insert just a normal, regular line from the left side to the right side with my shift key. Again enabling the guides because I want to make sure that I'm okay. Here I am perfect and here I need to make it a little longer, beautiful. We have a line. What do you think about the line? Is it too thin? In my opinion is. Okay. But you can always click on the line, go to the filling options, the line feeling options. I would increase the width because it's barely visible and give it some dashes just to give it a bit more flavor. You can always make this a little closer by pressing the control key. Okay, like this and taking the boxes and placing them a bit to the right side because we have so much space on this slide that you don't always need to start from here. If in your opinion the line is a bit too long, take the line, make it a bit closer, a bit shorter. And under the Shape Format, you can go to Align. Align will, or sorry not align middle, align, center. And now it centrally, this way, we created another formal business light for our representation, divided into two different segments. 78. 13-11. Slide 6 Table: You can notice our business lights get increasingly difficult to design. This is in my opinion and advanced table, what I wanted to say, what this slide is, that this age group is the most appropriate to target as the company. But it wouldn't really be effective without putting it into context with other age groups. Let us go into our presentation, select a new slide, top, bottom. This layout is perfectly fine. And I will try to insert all the information and design something out of it. We can maybe just maybe right-click layout and select a blank layout because this will be kind of a custom design. I can take elements I've already designed from the previous slide. Let's take those two boxes, Control C, and let's place them here. I know that I only need a lot of space. I'll enter the guide. So I'll start right away. I want to divide the content of this slide into four of those boxes. They can be small, but we need to fit at least four of them. I'll press Control D. I'll put it on the bottom. And let's eyeball it now. Do we have enough space for all four of them? Beautiful, yes, we have. I can even take them with my arrow key. I can nudge them a little lower. If you want to fill out this space. Take this a little bit higher. Take this a little bit lower. Select all four of them. Shape, format, Align, and Distribute Vertically. This will make sure that we have equal spaces between them. Okay, beautiful. We have the age groups. So this is the beginning for our table. For our slide. I will slowly copy over the information at first, the slide title. We want to fit the slide title here. For the age groups, we have 20%, 20 to 39. Alright, so we started with eight groups. If I look at the other information, we also have some titles like age group, market evaluation, comment. And I want to fit it above here. So maybe I made those boxes at tiny bit too big. I will make them smaller. I'll put this a little lower. And same principle applies. I can select all of them, Shape, Format, Align, and Distribute Vertically. I'll add this to Quick Access Toolbar because probably I'll use this a lot. Ok. Now, you will go to Insert Shapes and insert a normal textbox. Here. I want to age group. I want to precisely informed that this is an age group. You're going to get rid of the y letter if you want, or you can leave it as is okay. Age group. What did we have else here? Some kind of market evaluation and common market evaluation. Okay. Market evaluation. At the end, we had some kind of car calm and don't worry that they aren't even yet. I will select all three of them. Shape, Format. I want to align everything to the age group. Age group is lowest here. So I'll simply go to Align and align bottom. This way. Everything is perfectly within the same line. Let me go to the previous slide. Let me copy the line as well, because I want to do as little work as I can while maintaining the entire integrity of this presentation with the same design across different slides. This way, I'm making sure that everything looks consistent. Okay, this line could be a little longer here. I think this will look better. I get comments on the right side, market evaluation somewhere here. We'll take a look in a moment depending on how much texts do we put here. I will finish this lecture. Here. In the next lecture, we will populate this table with additional texts. And we can go from there and design a couple of additional elements to make everything stand out. 79. 13-12. Slide 6 Text: Let us continue with our slides. At first, I'll of course take all the text information and try to copy it over here. I copied, I copied over all the textbook. You can see the boxes are of different sizes. I think a box of approximately this size would be perfect. So I'll go to Shape Format. I see 538. I will select all the boxes and I will start by making all of them 513. And let's go from there. It already looks a little better. Now I can take 1234, I can take all of them. Just guess. I'll go to Align and align everything to the left side. So everything aligns beautifully to each other. I press Enter here so it gets bigger. And now to align it, take this one and the same. Maybe align, align it to the left. Let's see how much space do we have? It turns out that this five-thirds is perfectly fine. I'll enable my guide. I can see I'm almost at the guide. I'll go a little bit to the right side. Now, everything is spaced out. Really nice. Now, take it again, make sure that the lowest one is nicely aligned to this box. Take all four of them, Shape, Format, align, distribute vertically. And I will simply, since those are distributed, I will pick the left one and the right one align top, left one, right one aligned this way. This is lower, so I want to align to bottom. So this one goes lower. Those two, let me press Enter here, so we have more space, delete the empty space. This one, they are almost equal, but this one is lower and the left one is the one that sets the tone. Align, Align Bottom. And this one as well, align, align bottom. Now I have almost everything perfect. I want it to actually highlight this information. You can do this by going to Insert shape. Inserting a normal shape, make sure that the shape is a little bigger than the entire information. You can see it automatically selects the color from our presentation. I will deselect a guide right-click Format Shape. And I'll increase the transparency to at least like 80 per cent. I can now right-click, send it to back, shape, outline now offline. And this way I have highlighted this information. You can see this looks horrible because we didn't have Andrew here. I can take this by hand so I aligned it a little bit wrong. It should be a little higher. If there is one more line here in the slide that I created, you can see a place, normal lines here and dashed lines here. This is another thing we can do with we don't have to, I put triangles. So there was a clear understanding that the left information goes into the right information. So the viewer will read information from left to right, top to bottom. If you want, you can do the same. Just add a normal triangle, move it around, and make it much, much, much, much smaller like that. Okay, perfect. This one here, Control D. This one a little lower. This should be aligned to each other, okay? They are aligning to each other. Control D, Control D. And this slide, in my opinion, is finished. This is perfect for a business presentation like ours here. 80. 13-13. Slide 7 Table: This will be the slide where we will give for different recommendations to their company freshly to reinvigorate their sales and overall re-brand them. I divided them into two brand awareness things and to product popularity things. If we go to our presentation, we select a new slide and empty slide. We can take a look at the text. We have a title and a subtitle, and a couple of informations. Let us start by putting the information here. We have a lot of texts. I will just control C. I will change the layout to the layout with texts, and I'll press control V. You can see it's a bit awkward now because we have so many bullet points. Let me copy over the text, keeping the text only and de-select the default, selecting this entire thing, de-selecting the default bullet points. It looks now okay, so we have four different points. So we can put them in four different boxes. Make again, some kind of table. I'll put this on the bottom. And since we already made some elements in the previous slides, let me use them. I'll take the four boxes, Control-C, and I'll just place them on this slide. If you open the gate, notice that they are perfectly on the line we've set it previously on. Okay. I'll put this in just roughly like that, like that like that. We definitely need to make those boxes bigger but not too big. Let's make them bigger like that. Now I know that they will not cover the entire slide. Going to shape format to 84. Okay, Let's make 2.8 and let's see where that brings us. I'll put this on the right side. Now I will select all four of them. Are alignment, trig, align, and distribute them horizontally, okay, we have perfectly equal spaces here in-between. Everything looks pretty good for the text. I actually want to put some icons here. If you take a look, what I did here, I actually put some icons next to the text to make the design a little nicer. So I'll do the same here. For that, I need to delete the existing text. Okay? Texts deleted. And I want to put separate text boxes, insert textbox, separate text boxes for this key information, educate and inform. Okay, I can barely hit it. Educate and inform something and something, something, something, something and something. Promote healthy lifestyle. Adjusting, juice composition, select everything and control V. And select everything and Control V. Alright, I may want this to be on two lines. I also liked everything. I will center it and promote health lifestyle. I will also try to put this on two lines. Now I can take each of the boxes and put them right. There is space on the right side because I want to leave some space for icons. Take all the text boxes. You can select them with the shift click and make the text white. We've made the basic layout of our design. Let's add some icons that we can insert straight from PowerPoint. If you use Microsoft 365 subscription, you should have icons available. If not, you'll have to download them online or I will share them somewhere so you can put them on the slide. Just something about education. Education. You can just click around and select a couple of icons, just something that you think is suitable. You can do this by selecting maybe the books and promote, promote healthy lifestyle. Then I type in health and I go with something like that. Okay. Jews married, maybe there is a juice icon, okay. No, just icons. If you cannot find anything, there are categories here like accessibility, nature and maybe nature will, food and drinks, or food and drinks will be perfect for the Jews composition. An apple should be fine. And for the brand. Something business should work very fine. Alright, something like that. People around here, icon will appear straight in PowerPoint. I will make them small. I will make sure that the graphics fill is white. I will place them accordingly on. Okay, this was the Jews, this was the apple. This is the brand. And I'll make sure either they can stay this big or this even looks cool if they go a little bit outside. Because those are white icons. I think this looks really nice. Let's make use of the white background. Like that. It looks completely fine. In the next lecture, I'd like to continue with this design. 81. 13-14. Slide 7 Text: Don't worry, I didn't forget the title. Let me take the title. Place it here as always, only text. And maybe make this a little smaller because this time I am already adding subtitle that informs key drivers divided into brand and product Undertakings. Because I had to information about the brand and to information about the product. Okay, I'll put this on the left side. It's easy to adjust, Shape, Format, text fill, and use our brand color for the text. So it stands a little out from the original title. Okay, how to put the text on the bottom? Since we already started to make a table like that, you can take all four of those boxes, press Control D, put them a little lower. They will automatically align perfectly and just make them a little longer. It really, no rocket science. You can make sure what the shape format to maybe give it no outline. And you can decide if you want to stay with the red text or with the gray. I think the gray. It looks a bit more pleasing for the eye. Okay. It seems I had unnecessary bullet points. Let me take the texts. Just control C control V. Control C Control V, Control C Control V, Control C, control V. You can see it turned out white because the white, what's the default color for the text? We can change that by going to Shape Format, text fill. We can give it either this red color or simply the dark gray. Dark gray should work very fine. You can go to home. You can give them bullet points. Let me deselect the guide. What I don't like about that is that they start in different positions because we have different amounts of texts. This starts here. This starts here. As you know, we can right-click Format Object, and this will be very important. You can go to the last step, textbox. For the vertical alignment. I want to select the top, but I don't like that. We have so much space here on the bottom of them. I want to give it a custom top margin to the size of maybe 0.3. This will make sure that we have plenty of space here on the top side, and this will now look a little better. I'll make this smaller. And I somehow want to divide the left side from the right side. There are a number of ways of doing so that you can insert a text box. Make sure that this is about brand awareness. And everyone knows this, that this is about brand awareness. And this is about the product. We will type in product popularity. This should amount to a better product popularity. Alright, we will try to see if you can align this. Just take both of them. Shape, Format, align, and adjust, align the middle so they are even to each other. Alright, I'll put them a little bit to the left, and I think this would be completely enough for this slide. Let me delete this because we don't need the text. What I did at the end is going to shapes and just using a simple bracket. You don't have to do this, but it looks a little bit more complete. If you put a bracket here, you make it a tiny bit bigger with my Control key and make sure that it gets bigger in both ways. This bracket kind of informs that those two boxes are about product popularity and those two boxes are about brand awareness. This way, we completed designing this entire slide. This of course, isn't the end. We need to complete the presentation with a couple of more slides. But this is the essence. Those are the business light we wanted to create together. 82. 13-15. Appendix: Before we close our presentation, we definitely need to make some kind of appendix, citing all the references that we used in our presentation. I also, as the author, wanted to thank someone within this appendix going into our presentation, I will start with adding another section, calling it closure, where we can ask questions, give the appendix, make a thank you. Slide. It depends on what you want. You can literally call this appendix or references. I'll call this references and links. And maybe we will put the links here. Let me go a little lower. Links I've used might be useful for Appendix resources list, okay, I have a resources list and those are the links are used. I will just maybe get rid of the bullet points and put them here. Make sure that I use consistently lead off on across this presentation. And you can place an Enter. You can at any given point press Shift and Enter. To put this on the next line, this will look a little better if you want to be like completely clean. You can give longer links at the end and shorter links at the front, but you definitely don't have to do this. I want to keep it professional, so I'll leave it as is apart from the references. And I want to make sure this is at least 18.19, 18 points, right? Apart from the references, I also wanted to thank a contributors special thanks to, and I wrote some kind of texts to thank a person. You can see this slide is a little different from the usual slides. You can definitely make the text smaller and put this a little higher because we need more space to put everything into good perspective. I actually have special thanks written. Put them here. I'm not sure about the color. I will change the color to a gray, like we had consistently in this entire presentation. This is one way of making an appendix. Of course, we could do a completely different design for it, e.g. with a background color like this and the text in white. That's for you to decide. Just make sure if you create business presentation, always have your table, references and everything in some kind of resources list or appendix prepared. If someone would ask you where you got your information from. 83. 13-16. Thank You: In this lecture, we will make a thank you slide to close up the presentation. And if you take a look how we started, it will be on the other side. To give this composition some closure, we don't have to create a new slide. We can just take the introduction Control-C, go to the very bottom of the presentation and press Control or Command V to paste this slide in. Nothing is stopping us to reposition everything from the left side to the right side. Beautiful. The same image looks really okay. I'll put this bit further away. So we have space here, and I will align this to the right side. Now, for the tagline, we can write something like, thank you for listening. Ready for questions or anything you think would be relevant here. The date, we can skip the day or just put it here on the right side and the logo of course, on the left, we don't have to exactly match the guide that we set for ourselves. Since the title and the ending slide has a bit of a different vibe here, I'll just eyeball it. I will put the text a bit to the left side, aligning it to the left, further away, right? I think it's too close to borders. Let me put this here. And this makes for a really good composition since we started from the left side and on the right side. And in my opinion, like graphically, this all makes sense. I think this text is a little close to each other. I will just take this box, click on the entire box and make the spacing maybe 1.51, 0.5 is okay. The date a little lower, and now it's visually a bit more aesthetic and pleasing for myself. Thank you for making disclosure slide. Let us go now to the next lecture and continue working on our presentation. 84. 13-17. Simple ESS: Within this lecture, I want to work on an executive summary slide with you. At first, a simpler one. I'll put the text also here within the text document, but I really want you to work alone on this. I will show you an advanced trick, go to View. This is something that rarely an end-user's. We have all titles and text here. We can go to Outline, View. What you see here. Older textboxes and titled that we entered for our presentation. And this should make sense. Reading only the titles should make sense for you. You can very easily right-click and create a new slide. This will be the executive summary. You can go to Outline View you are on the executive summary. You could quickly grab text from this slide, go here, and just paste this in. I know it's not the most convenient, but it should be completely fine. You remember, we had a sections in this presentation. The sections aren't showed here, but I know that the first two slides were about the market. Then I will make a space. And the next two slides, it added the anterior side. The next two slides were about the complication on the market. So I will take only the title here. I'll try to be precise. Go back to slide number three. And this is how you can very quickly, very quickly build a very simple executive summary. Now the last slide, slide number eight, we cannot really copy for recommendations for freshly to establish their identity. Instead, we need to copy like the four recommendations that we actually do there. So I'll maybe play something like four recommendations for the Km as their next steps or something along these lines. Then I will just go to slide number eight and I would copy, educate, and inform, promote healthy lifestyle, adjust to its composition, rebrand, and establish their identity. Okay, I've copied that over. Education, promoting adjustments, rebranding, and I wrote a couple of things from the slide I've created. Let me go back to normal view and we need to put some kind of information here like this is mar, market insights. We had situation but this is only working section. The situation is that market insights. Then here, the complication, we had negative complications and positive complication. So I'll write something. Remember, this will be for people who wants to read only this slide and understand what you are meaning on all your slides. So I would make something like problems can create new opportunities. Problems can create new opportunities, something like this. So it's understandable what I said on this slide, and what I said on this slide, I'll make Control B. This will be this market insights. And market insights is a little and descriptive. So I would maybe expand this with difficulties for market insights and difficulties for fruit juice sales than about the freshly company increasing water and nutrient rich beverage consumption. This would go perfectly alone information than alcohol is. Then I will call this executive summary and we would be done with the first version of our executive summary slide. And it's a really interesting tool to create this type of slides and get an overview on what you are actually working on. 85. 13-08. Advanced ESS: Within this slide, I want to go one step further and show you a nicer looking way of making executive summary slides. We can take our existing slide and just duplicate it because we made the majority of work already, but I wanted to portray it a bit different. So we have market problems and recommendations. We can use icons, different icons for that. Going to icons and again, searching for something relevant. I will make this window smaller market. Do we have something like that? Okay, maybe market difficult. Difficult. This is okay. Let me type in problem and see if there's something else okay. Problem. This would also work and an opportunity. I don't know if there will be an icon for like idea or something fresh. Light bulb would be perfectly fine here or dislike opportunities for icons, but I'll only need three. Let me see what looks better. The light bulb, the ideas will be at the end, the recommendations, then the problems. This looks like problems and market insight. Well, this icon will be fine for that. You can see we already have all the texts. I'll just control C and control V. It maybe this text is a little long. So let me stay at only market insights. Since I've already designed this, I can decide upon the size in a moment, maybe make it a bit bigger. I don't like that. This is so small. I don't like that. This is bold. Market Insights, market problems. We need a bit more space. And the last one will be recommendations or opportunities or a proposed course of action, proposed changes. Again, we need a little bit more space. We will see in a moment if that makes sense. And later in the presentation, we made a couple of horizontal lines. I will just take one of the lines Control C because I'm lazy and I'll just duplicate it over there. You can clearly see where I'm going with this. I will make something like that. Another line here and another line here. Now we divided this into three neatly organized categories and we can put a couple of informations on the bottom. You see where I'm going with this. I'm making essentially the same type of content, but written a bit differently. Now for the texts we already typed in market sales. So I will just take the first two sentences and I'll put them separately here. Adding a bullet point and putting them under this market insight section. You can see I'm very often just duplicating and working with existing elements. I'll put this, duplicate it like that. I'll try to make this the same. Alright, perfect. And one more duplication, but this a bit more to the right side, and this will be fine. I'll of course change the text. I need the bullet points so everything looks consistent. And the four recommendations, this text is a little different, but it should also fly perfectly. This one will be bullet-pointed. This one deleted. This way. Let me delete that. I created a completely different executive summary slide. You know that I can make this a tiny bit smaller and make this bold, put this in different places. This is just cosmetics. I just wanted to give you a general idea that you can approach executive summary slides and make them differently understandable. The general idea here stays the same. You can divide a slide into different categories and present data like this. I think this is a very pleasant executive summary to look at. And it clearly guides me to read this first than this and then this to understand what the presentation is about. 86. 13-09. Slide Sorter ESS: Thank you for arriving at the end of the creation process of this presentation. Obviously, you could now eyeball everything. The simplest way to do so is to go to the slide sorter here on the bottom side are going to view opening the slide sorter, and you can very easily preview each section that you prepare for this presentation. This makes up for a convenient way to quickly get a grasp if everything sits well together, I hope you've learned a ton of information about creating business, formal and general about PowerPoint and presentations. Let us now go over to some other things about PowerPoint and we will see each other soon in other lectures. See you there. 87. Thank You!: I would like to briefly and humbly thank you for arriving at the end of the course at first. Congratulations to you for finishing everything. No matter if you worked alongside me or not, you've certainly learned a lot about PowerPoint from my side. The best, Thank you. You can give me would be to give a positive review for this course. Thank you very much If you consider doing so, I hope we will meet again and see you in other courses. High-five.