Affinity Publisher: Beyond the Basics!

1. Class Introduction: You're ready to take your affinity publisher skills to the next level, then this is for you. Today, I'm excited to announce my brand new course, Affinity Publisher, beyond the basics. This course has been designed for anyone who knows the basics of affinity publisher, but still feels like there's more to know about this amazing program. If you already know how to add text and place images, but you haven't heard of data merge or table formats, then this is for you. We'll start off by learning my favorite ways to work faster and affinity publisher, including document templates, assets, advanced master pages, and custom shortcuts. After that, we'll learn advanced techniques for stylizing your text so that you can pull your reader's attention to the things that matter most. With just a little bit of practice, you'll have complete control over your text, even for things that seem a bit complicated at first, like tabsops, and textiles. You're going to learn so much in this course. You'll learn how to add footnotes, indexes, and even tables, which you can use to add Excel looking data to your documents or to do fun and creative things, like making a menu for a restaurant. I think you'll be surprised at how useful tables can be in affinity publisher. Finally, we'll finish off this course by learning about one of my favorite tools in publisher, Data Merge. You can use data Merge to speed up repetitive tasks. Using data merge, we can make address labels or playing cards for a custom card game. But address labels and card games are just two examples of data merge. Once you know how this tool works, you'll be able to do amazing things with it. But before we dive into affinity, I want to mention that this course comes with a few example files that we'll be using throughout the course. I encourage you to download and use them because practicing what you learn is the best way to retain all of the new skills that you'll be learning. You can download those example files in the next lesson, and then you're ready to start your journey to really becoming an affinity publisher master. Let's get started. 2. Download the Class Files: Before you begin this class, I recommend you download the exercise files. These files will be necessary for you to follow along with the tutorials. To do this, you first need to come to the Project and Resources tab. Then click on the download link. The Exercise files will then be downloaded to your computer and you'll be totally prepared to follow along with the rest of the class. 3. Work Smarter Not Harder: The first chapter of the course, we're going to learn a few ways to work more efficiently an affinity publisher. Using these new skills that I'll teach you, you'll be able to work smarter and not harder. It's going to be a lot of fun, so let's get started. 4. New Document Templates: This video, we'll learn how to make document templates. Templates are pre made files that you can use as a starting point. Whenever you're making a new project. As an example, let's say that I'm part of a book club, and my job is to design our club's monthly newsletter to make my job easier. I want to create a template that I can use as a starting point for each month's newsletter. To make a template, we first need to make a new document. I'll come right up here to the top to file, and then I'll click on new. Now you can just make this whatever you want. In this case, I'm going to go ahead and go with the letter setting here. Then let's come over here two pages. I'm going to keep facing pages checked on, and then I'm going to start this on the left. Let's go ahead and do two pages, going into color. I think I want this to be RGB. Then I'm just going to come in here and turn off margins, and I also want to turn off the bleed. I'll just type zero into any of these boxes and then I'll press enter. I'll write in just like that, we have our document ready, so I'll press create. Now, before we turn this file into a template, we need to add any design elements that we want our template to always include. Since this is just a tutorial, we won't spend too much time designing the template. But let's go ahead and quickly mock something up. I'm just going to grab the artistic text tool and we'll put in a title right up here. Let's go ahead and call this the Classy Book Club. Using the move tool. I'll go ahead and adjust this. Let's go ahead and choose any fun font that you want. I like this font right here. Then I'll go ahead and shrink that down and center it on the page. Perfect. Next, I'm going to use the frame text tool to type out a few lines of text here. For the first line, I'm going to say the next meeting is going to be on a certain month and a certain day. Now, it's a little hard to see what I'm typing. Yeah, I misspelled something there. I'm going to grab the move tool and I'm just going to make this bigger so I can see what I'm typing. Then I'll go ahead and drop down a line and this will be the location of the meeting. And then we'll have the book and the book name. My idea with all these lines of text is that these will be included in the template, and then you can come in and fill in whichever month and day address and bookname. It is for the month. That way you can easily update this. With that done, we can go ahead and adjust this text. I'll grab the move tool. Let's go ahead and change this font to times New Roman. I'll go ahead and just start typing in the word. Oops, that didn't work. Let's try that again. There we go. Then I'll change this to times New Roman. I think 24 looks like a good size for this. And that's all centered up with the title. I think that looks good. Let's go ahead and continue. I'm actually going to duplicate this. While holding command or control, I'll drag this down, and then I'll click in here to edit this. This is just going to be a message from our president of the club. I'll shrink that down. Then I'm going to put a block of text underneath this so that the president has space to type out a letter of whatever they want to say. Using the frame text tool, I'll just click and drag out a text frame like that. Make sure that's lined up on this side. Y. Then I'm going to go ahead and duplicate this text frame while holding down command or control. There we go. I'll just drag this down a little bit. Just to give it some more room. Now that that's all done, I think I want to put in some filler text next. But before I do that, I want to connect these two text frames. I'll click on the output arrow and then connect these two frames. Then I can go ahead and insert the filler text. I'll right click, then we'll go ahead and insert filler text. That looks pretty good. With my cursor blinking in there. I'm just going to press Command or Control A to select all of this text. Then we can go ahead and edit it. I like the times new Roman fonts, so I'll keep that. But I think for this, I want this to be a little bit smaller. Maybe 18. That looks pretty good. I just have one more element that I'd like to add to this template, and that's the signature of the club president right over here. I'm going to use the place image tool to do this. Then I'll go ahead and select the signature. It's the first exercise file right here, and then I'll press open. Now I can just click and drag to add this in. Now we have this lovely signature at the end of our letter from our president. I'm just going to turn on preview mode to make sure this all looks good. I think that looks great. Now to set this up as a template, all you need to do is come right up here to the top and go to file export as template. I'm going to go ahead and name this template Book Club. Now, here's where you need to make sure you pay attention to where you're saving this. You need to place your template into a folder on your computer, I've already made a folder for this called Affinity Publisher templates. This folder should be in a place somewhere on your computer where you won't delete it. You don't accidentally want to get rid of all of your templates that you store in here. You actually need to save these on your computer in order to use them. I'm going to go ahead and press save. Then to get the full impact of what's about to happen, I'm going to close this document by pressing command or Control W. And we don't need to save this version of the file, we already saved it as a template. I'll just say, don't save. Now I'm going to show you how to open up a template and how easy it is to edit those templates. To do this, I'm just going to go to File New. This is just as before. We're just creating a new document. But this time, instead of creating a brand new document, we're going to come right down here to templates. Then I'm going to click right here. Now we're in the Affinity Publisher template folder. I'm just going to press choose. Now you can see that this folder has been connected to publisher so that these templates can easily be used in the program. You can see this template right over here that we already created. I'm just going to click on this template to select it. Then I can go ahead and press Create. Just like that, we're back in the document and I can go ahead and edit any of these things here. For example, I'll just say the next meeting is September 24. We'll go ahead and update this address here. I'm just going to say this is 431, Kitty Cat Lane. For the book, since we have a cat theme going on, let's go ahead and do the cat in the hat. All right. Now that I've placed this new information here, I can export this document just as a normal document so that I can share it with my book club. As each new month rolls around, I can just go to file ne and I can open up the template all over again and I can re input the new information. As long as I don't remove the template from the folder on my computer, then it will always be ready for me to use, making this monthly newsletter much faster to create. Now you know how to make templates in affinity publisher. Templates can really save you a lot of time. They are a great way to work smarter and not harder. 5. Assets Panel: In this video, we'll learn how to use the assets panel. I'm going to use an exercise file for this video, so you can go ahead and open that up. In the last video, we learned how to save a document as a template. But maybe you don't need to save a whole document as a template. Maybe you just need to save a single layer that you want to use in future projects. If that's the case, the assets panel is just what you need. To open up the assets panel, let's come on up here to Window. Then you can click on where it says assets. I'm going to place this panel right up here next to the pages panel. Now that we have this panel. We can go ahead and start turning elements of this exercise file into an asset. Let's go ahead and start by selecting this elephants text right up here. As you can see, we put a lot of work here into spacing out these letters and recoloring every other letter. That took a long time. Maybe I want to save this as an asset, so I don't need to remake this again. To save this as an asset, go ahead and come right over here. Click on this Hamburger menu, and then press on, add from selection. Now the word elephant has been added right here, but this doesn't look very good at the moment. I'm actually going to come up here to this Top Hamburger menu. I'm going to change this to show as List. There we go. Now you can easily see what we're talking about here, the word elephant. Now I'm going to continue to add these different elements as assets. Let's go ahead and do this text frame next with that selected. I'll click on this Hamburger menu and add that from selection. I'll go ahead and do this photo as well. L ast down here, I want to add this element. There are a few layers here, I'm going to click and drag to select all of them. Then I'll go ahead and add these from selection. Uh oh. That actually didn't work. It separated each of these layers to make their own asset each. That's not what I wanted. I'm going to go ahead and right click to delete each of these assets. Let's try that again. If you have multiple layers like this that you want to turn into an asset, you actually need to group them over here in your layers panel. To group layers. Remember that all you need to do is have them selected and then press command or Control G. Now that they're all grouped up, we can go ahead and save these. Now they're all placed on one single asset layer. Now it's time for the magic. I'm going to close this document by pressing command or Control W. Then I'm going to go ahead and create a new document. With our new document made, it's actually super easy to incorporate any of these assets into our document. All you need to do is click and drag on them to add them to your document. Assets are stored inside Affinity Publisher. They will always be accessible whenever you open a new document until you decide to delete the assets by right clicking on them and deleting, just like we did a minute ago. As one last tip, I want to show you that the assets panel comes with one category right here. This category is called default. The default category has one subcategory called assets. We can actually add much more than this if we want to, though. I'm going to create a few more categories by coming to this top Hamburger menu here. Then I'm going to press Create new category. I'll go ahead and do that one more time. I just added two categories. Now we have animals, the default category that was already there, and a plants category. In the plants category, I'll go ahead and add a few more subsections here. Right now, we have assets, but I think I actually want to rename this. I'll click on the Hamburger menu and then I'll click on rename. For this one, I'll go ahead and rename this flowers. Then I'm going to add another subcategory here. Now for this, I need to come right back up here to the Top Hamburger menu. Then I'll press Create subcategory. This is automatically named assets. I'll go ahead and rename this. Let's go ahead and name this trees. We can do this in any of the subcategories in the animal one, I can go ahead and rename this. Let's just call this ducks. Just like with the other one, we can always create more subcategories and rename them. Now, as I work on different projects, I can save assets into each of these categories just as we did before. Just have a layer selected. Then in that subcategory, click on the Hamburger menu and add from selection. Now we have elephants in our elephant category. If we quickly wanted to add a tree asset that we have, we could go to plants and then pick up an asset from over here and add it to our documents. Assets are a great way to save things that you need to place in lots of different documents. For example, my job is to teach the affinity programs. It's not uncommon for me to need the affinity logos. I might decide to make the affinity logos and asset so that I can quickly drag and drop the affinity logos into whichever document that I'm working on. But for you, you might have your own company logo that you want to make as an asset, or maybe you have a string of texts that you use a lot or even a photo that you use all the time. Assets have a lot of potential and they are a great way to work smarter and not harder. 6. Master Page Text Frames: In this video, I want to show you a great way to combine master pages, text frames, and auto flow. Now, this is definitely beyond the basics, but you're going to love it. First, though, let's go ahead and have a ten second review of two things that we learned in Affinity Publisher for beginners. The first thing is, you can make a text frame on the master page. Then when you go back into your normal document, you can type in that frame from inside your regular pages. Number two is that you can use auto flow to place long text files into your publisher document. Once you've placed your text, you can hold down shift and click on this arrow. Wow, look at that. We were able to auto flow all of this text onto the rest of our pages. All of this is amazing and good information, but there's one problem. Unlike master pages text frame. I can't easily change all of these text frames at the same time. What if I need to resize and position them? Now only this one is changing, not the rest of them. But what if we could combine this wonderful auto flow feature with master pages so that all of these would change at the same time. That would be something special. Let's go ahead and press command or Control Z a few times until everything is blank again. Now we're back to the beginning. We don't have any text frames in our main document, and on our master pages, we have no text frames. We're back to the start. I'm going to go ahead and add a text frame again. I'll go ahead and drag this out on our first page. Then I'll go ahead and hold down command or control so I can duplicate it to the other page. As you can see, we now have two text frames. Next, I'm going to connect these two text frames. I'll click on this little arrow here and I'll connect them. With those two text frames in place, I'm going to go back to our main document, and here we are on page one. Now on page one, I'm going to go to file and I'll place our word document in here. I'll go ahead and click here. That's been placed and it's flowing onto the next page. Now I just need to hold down shift and click right here to auto flow this into the rest of the pages. That looks good. Now, all we need to do to adjust the size of these frames is go back to the master page, and now we can go ahead and adjust the sizing of these text frames. If you look in our main document now, you can see that all of the left pages have been shortened. Now, problem solved. We've been able to use the master page to adjust these sizings and it updates automatically. This is only possible by making connected text frames on the master page like we did. If we didn't connect these two frames together, that wouldn't have happened. But the fun doesn't end here. This is just a starting point. You can still customize your document. For example, if I come back into our document here, I can add pages in between these auto flow pages. I'm going to go ahead and right click and add two pages. Now you can see we have two blank pages in between our auto flow here. If I click right here, you can see that this text flows all the way into this page. If I wanted to, I could go ahead and use the text frame tool to add an all new text frame here, and I could connect it with the previous text frame. I'm just going to click on this output arrow and I'll insert this right here. Now you can see the text flows from here to here, and then it picks up where it left off and flows again. In addition to doing this, if you remember, you can always go ahead and come to any page that has a master page on it, and you could still edit these frames on your own. If you just want to edit this frame, all you need to do is go to the parent layer, go ahead and right click, and then click on Edit Detached. Now, you should be able to move this around however you want. When you're done with that, you can go ahead and press finish. Or if I wanted to, let's just go back into detached mode. I could also just delete this text frame with that selected, I'll press delete. You can see that the text still flows right around that, even though we deleted it. The next thing I want to do is, I just want to give you a brief example of when you would want to use this technique. For this example, I'm going to open up the publisher document that was included in the courses Exercise files. Here we have this new exercise file. I made this document with master page text frames using auto flow, but I actually forgot to leave room for page numbers. What can we do? Well, let's go ahead and go to our master pages. Then I can go ahead and select both of these frames by holding shift and clicking on them. Then I can go ahead and move them both up at the same time. As expected in our document, all of the text moved upward, and now we have room for our page number. I'm just going to go back into our master page and let's go ahead and use the frame text tool. I'll click and drag here, and then we can go ahead and add our page number. That all taken care of. I'm just going to hold down command or control and shift so that I can move this in a straight line while duplicating it. Let's go ahead and check out the page numbers in our document. This looks great. I'll just turn on preview mode. There we go. Now you can see how easy that was to adjust all of these text frames. We didn't have to go individually and change them because we used the master pages to connect them. However, since we did shrink all of these text frames, I do think we should go check on our last page, I think we need to do auto flow again. So I'll hold down shift and click, and this will add in those last pages. Okay. So as you can see, combining master page text frames with auto flow is an amazing way to work smarter and not harder. 7. Multiple Master Pages: This video, we'll learn how to make multiple master pages. To begin, I've already made this blank 30 page document with facing pages. Go ahead and create one for yourself so that you can follow along. Now, before we can make multiple master pages, I'm first going to edit the original master A. I'll double click on it. Then I'll add a few elements here to make this page unique. Now, this is going to be the page that will be used through most of the document on the body pages. I'm going to make sure we have a page number. I'll go ahead and add that in here. Once that's nice and centered up, I'll go ahead and press command or Control J. And with that duplicated, I'll hold shift and bring this over to the other page. Then to differentiate this page from other pages. I'm also going to add a rectangle to the side here. I'll go ahead and give this rectangle a color. I'll make it orange. This is going to be the pages for the main body text. Next, I'm going to create another master page that we can apply to all of the chapter pages in our document. How do we make another master page? Well, we could press right up here to add another one. But another way to do this is to right click and then duplicate this. Now you can see we have master A and we have master B. Master B has all of the same elements as master A. This is nice if you wanted to still include page numbers, but just change something else about this. In this case, I think I'll delete the first page number on the left page. I'll change the color of this rectangle. Then I want this to be a page that's fully covered in an image. I'm going to grab the rectangle picture frame tool, and I'll just click and drag out a picture frame. This looks like a good setup for a chapter page. Now we have Master A and Master B. But if you look in our document, all of our pages still have master A applied to them. How can we apply this other master page? Well, there's actually a few methods to do this. The first method is to click and drag on Master B and then release it on top of the page you want to apply it to. Just like that, very nice and simple. We have Master B applied to pages 1 and 2. Another way to do this is to select multiple pages while holding shift. Then you can click and drag to apply to all of those pages. The last way to do this is actually to right click on Master B, and then click on Apply Master to pages. This dialog box will pop up and it'll tell you that you're applying Master B to certain pages down here. We could say all of the pages, if we just want to completely wipe out Master A. We could say all of the odd number pages, even number pages, or we could have specific specified pages that we want to apply this to. In this case, I'll just type in 13 through 16. Then one last thing to know down here. This will replace the existing Master A page. You'll no longer have that layer. You can check this off if you want to keep all of the layers of Master A and Master B. But I'll go ahead and leave this checked on so we can replace it, and then I'll press. Just like that, we have 13 through 16 here with Master B applied. I hope you enjoyed this video. That was pretty simple to do. Master pages are really one of the best features of a Finity publisher, and making two, three, or even more master pages can really help you to work smarter and not harder. I 8. Custom Keyboard Shortcuts: Let's learn how to make custom keyboard shortcuts. To start off, I've already opened up a blank document that has two pages. To get into our shortcut menu. First, we need to have the move tool selected with no layer selected. That way, the context toolbar looks just like this. Once your toolbar looks like this, you can click on preferences. Then you can come on down here to where it says shortcuts. Before we can start creating our shortcuts, first, we need to figure out how this dialogue box is organized. First, take note of this toolbar right up here. Here we have the menus that say file, edit, document. If you come down here into this dialogue box, we can click right here and it will say file, Edit, document. This dialogue box is organized in the same way as that menu bar at the top. Once you click into one of these, for example, I'll click into text. We have new options that appear down here, and we can see these options start with find, find next, find previous. If we go into the text menu right up here, you can see those are the first options. The options that are shown down here are going in order of how they appear up at the top. Now that we know how this is organized. Let's work on a practical example. For this example, let's say that I want to add a shortcut to create a page break. It's a lot of work to go into the text menu, then to go into insert, breaks, page break. That's just a lot of menus to get through. You can actually see right here that line break already has a shortcut, but page break doesn't. Let's go ahead and add one to that. Now, before you click out of this part, look at the options, we went from text to insert, then breaks, then page break. As you scroll through this list, you need to look for the word insert. There we go. Then you need to look for the word break. There we go and page break. It can be a little tricky navigating through all of these. If you need to look back in your menu a few times to find it, that's totally normal. I do it all the time. Once you've found Insert breaks page break, we can click in this little box right here, and we can add our own custom shortcut. For this shortcut, I'm going to press command return on my keyboard. Now, if you're on a PC, you'll want to press Control enter. Once you've entered that, now you can see we have this shortcut for page breaks. Let's go ahead and test it. In my document, I'm going to make two text frames. Then I'm going to link them together. Then I'm going to go ahead and place the document that I prepared for this video. I'll go right up to file place. And then I'll go ahead and press on keyboard shortcuts and I'll open that up. I'll add that right here. With my cursor blinking in there, I'm going to press command or Control A to select it all. Then I'll go ahead and make this text bigger. Let's test out our page break. Now, with page breaks, you need to have your cursor blinking right before where you want the page break to start. I'll go ahead and do that. And then we'll do our shortcut. I'm going to press command return. If you're on a PC, press Control Enter. Let's see how this works. It worked perfectly. Look at that beautiful page break. That was way easier than going through all of those menus. Yeah, that would have taken a lot longer. That's the beauty of creating your own keyboard shortcuts. Let's go ahead and see another example. In order to get back to that shortcuts menu, I first need to click on the Move tool and then click outside of my document so that nothing selected. Then I can go back into preferences. Now this time, I want to create a shortcut for the resource manager. This manager is found in the Window menu, and it's right here. I'll go to Window. Once you've found Resource Manager, go ahead and click in its box. Now we can go ahead and create a shortcut for this one. I'm going to press Command or Control R. I wanted to use R for resource, but it looks like this is already taken. You see this yellow warning sign. It says Show Rulers. That means that this shortcut is already being used for rulers, so we can't use this one. I'll go ahead and delete that by pressing the x. Let's try instead for manager. Command. It looks like this one's already taken by curves. Let's try something different. Maybe instead we can do command option, or if you're on a PC, you would press Control Alt M. Finally. Sometimes it can take a little bit of trial and error to find a shortcut that's available. But let's say that I really wanted to use Command R. I don't use my rulers that often, and I really think command R would be really useful for my workflow. If that's the case, then we can go ahead and delete this and put command or Control R right in here. Then we need to find rulers in this dialogue box and remove that shortcut. To do that first, let's go to the view menu and then find where rulers are. I just found it. All you need to do is go to view, Show Rulers. Let's go ahead and do that. Here's Show Rulers. You can see there's a warning here because we just apply this to the resource manager. But we could definitely press the x button now. Now, Show Rulers has no shortcut. We totally removed it. If we go back to window, we can see the resource manager has command or control r right in here and there's no warning. Just to finish off this video. I have a few last quick tips. Up at the top right here, you can actually reset all of the shortcuts to the default shortcuts. You could also save your shortcuts as an affinity shortcuts file, and if someone sends you a file like this, you could load it right here. Which shortcut keys you use in your workflow is entirely up to you. But now you know how to create custom shortcut keys so that you can work smarter and not harder in affinity publisher. 9. Adding Style: This chapter, we'll learn how to add more style to your designs. We'll learn new ways to work with images, text, and even text frames. It's going to be beautiful, so let's get started. 10. Pinning Images: In this video, we'll learn how to pin images, tier text. In this exercise file, I've placed some text in a text frame, and I place this rabbit photo with the place image tool. Now, I want to pin this rabbit image to the text so that if the text moves, the rabbit image will move right along with it. I'll go ahead and place my image right here, and then I'll come right up here and turn on text wrapping. Let's go ahead and make this tight, and I'll go ahead and increase the distance from the text right here. Let's go with 0.25. Now you can see the rabbit image is in the text, it's wrapped around nicely. However, if I move the text, the rabbit image just stays in place. It doesn't follow the paragraph. To fix this, it's actually pretty easy. Just select the layer that you want to pin, and then come right up here and click on this pin. Now you can see this pin up here. This is pinning the image to the text, and you can adjust where this is placed. I'm going to click and drag this and put it right after the word although. If you want to pin an image to a particular paragraph, make sure you put it right after the first word of the paragraph. Otherwise, it just won't work quite right. Now with that pinned in place, I'll go ahead and move this text downward, and you can see the image floats right along with it. In fact, if I come right up here and move all of the text down, it still floats with that paragraph. But because it's connected to that paragraph, if I change any of the other paragraphs, the rabbit will just stay in place. However, if you want this to move with all of the text, you can always select the rabbit and then move the pin. Now that it's on the last paragraph. If I move any of these other paragraphs, it'll move right along down with it. You might have noticed over here in the layers panel that because the rabbit image is pinned to this text, it's now placed as a child layer to the text. A simple as that. Now you know how to pin your images to your documents. I think this is so useful when you're working with large documents. 11. Drop Caps: In this video, we'll learn how to add a drop cap tier document. Just so you know, drop caps are those big fancy letters that people sometimes put at the beginning of a paragraph. Lucky for us, adding drop caps in affinity publisher is actually really easy to do. To start, make sure you have the move tool selected, and then select one of the blocks of text without entering type mode. Make sure you don't have a cursor blinking here. Then come on over to the paragraph panel. There's actually a section for this. You can see right here, we have drop caps, go ahead and open that up, and then go ahead and check on enabled. Now you can see these big letters at the beginning of every paragraph, and we can make a few adjustments to this. First, we can change the height in lines. Right now it's set to three, and if you look over at our document, you can see we have three lines of text, and that's the same height as each of these letters. But you can go ahead and change this if you want to. You can make this less lines if you don't want it quite so dramatic, you can make it bigger like that. Either way. You can also change the distance to text. What this does is as I increase this, you can see the text gets pushed more away from the letter. I think I'm just going to do 0.1. That looks pretty good. Next, I want this to only have a drop cap on the very first paragraph. It looks a little dramatic to have it on every single paragraph. The way to do this is to uncheck enabled, and now we're going to enter type mode. I'm going to click into this paragraph and have my cursor blinking somewhere in the first paragraph. Then I'll go ahead and check on enabled because that paragraph was selected. Now that's only applied to that paragraph. Now that we like the sizing of this, we can go ahead and select this letter and change anything else that we want. For example, we could change up the font if we wanted to to make it a little fancier, and we could also change the color. Now you know how to use Affinity's built in drop cap menu over here. But I want to show you a fancy way to add your own Arts drop cap. The first thing I'm going to do is I'm going to grab the artistic text tool, and then I'll click and drag out a letter. Then I'll go ahead and type R. I'll go ahead and give this a different font. Let's go ahead and use times New Roman, and I'll go ahead and give it a nice bright color. Then using the Move tool, I'm just going to position this. Then going back into our layers panel, I'm going to place this underneath our text so that it's not blocking any of the text. I'll just put it all the way to the bottom of the layers panel. Then I'm going to lower the opacity of this letter. Like that. This is a bit of a different style, but it still gives a similar effect of having a very dramatic first letter. I'm just going to turn on preview mode so we can see how cool that looks. Drop caps are a really easy way to grab your reader's attention. In the next video, we're going to learn how to use paragraph decorations to make sure that your reader also notices important paragraphs within your document. 12. Paragraph Decorations: This video, we'll learn how to add paragraph decorations. These type of decorations allow you to draw your reader's attention to an important paragraph. In order to decorate our paragraphs, let's go ahead and go to the paragraph panel. I'll go ahead and close up the drop cap section. In the section we want is the very last one called decorations. Go ahead and scroll down here and Wow, look at all this. There's quite a few different options you can use when creating these types of decorations. I want to show you a few examples of how you can draw this attention to your paragraphs. To start off, I'm just going to select this text frame here. Then I'm going to go ahead and click right here to turn on the left decoration so that we can see this better. I'll come down here and increase the width of the stroke. Now you can really start to see it there. I'll go ahead and click where it says stroke, and I'm going to change the color to a nice bright color. Now you can see this is taking up the entire left side, but if you see here, it's actually overlapping with the letters. I want to space this out a little bit better. A good way to do that is affect the left indent here. If I go positive, you can see as I increase this, it goes more into the text. I actually need to go negative. Once you have a distance that you like, you can go ahead and take a step back. I think that looks pretty nice. That's the basics of paragraph decorations, but I want to show you a few more things. I'll go ahead and turn off this left dent, have the frame text selected and then click here to turn it off. This time, I'm just going to have my cursor blinking in the second paragraph here, and then I'll go ahead and add a left decoration again. This time you can see it's only being applied to the second paragraph. Now, in order to have a little bit more control here, I'm actually going to scroll up to the spacing section, and I'm going to increase the indent here. This will change the intent of the entire paragraph. You can see as I increase this, the paragraph begins to come in a little bit. I'll go ahead and make this about half an inch. I'll go ahead and do this for the right indent as well. By bringing in the spacing like this, you can really start to see that we're emphasizing this is an important paragraph. Then coming back down here to decorations, we can make a few more adjustments to this. One that I haven't shown you yet is right here. If you click on this, it will introduce a fill color to this paragraph, and then you can come down here and adjust the color. We'll go ahead and make this a nice light red color. Now so that we have a little bit more space. You can see again, this is really hugging the sides of the letters here. I'm going to increase some of the spacings. Right in here, I'm going to go ahead and bring this up a little bit. You can see that's bringing it down into the text more. So we actually have to go negative. I'm just going to go negative with all of these values to space it away from the text a little bit better. Now that we increase that spacing, you can see it's butting up against the other paragraphs. I'm going to go ahead and go back to the spacing section, which affects the text, not the decorations. I'm going to increase the space before and after paragraph. With that all spaced out. This looks really nice. Now we can go ahead and stylize this text however we want. We can go ahead and make it bold and italicized to emphasize its importance. I think this looks really nice. Now that we've done that, let's go ahead and do another example. I'll go ahead and have my cursor blinking in this paragraph down here. Then coming back down to the decorations, I'm going to go ahead and turn on the decorations for the left, the right, along with the top and bottom. Now we've just created a full box here. I'm going to come down here and change the stroke. Let's make this a little bit smaller. I'll go ahead and change the color just to make things up a little bit. Let's go ahead and turn on the fill color as well and make this a nice light blue color. To space out these decorations a little bit, I'm going to go ahead and change the dense. I'm just going to go negative 0.2 on all of the sides. Now that has more breathing room, I'm going to give the other paragraphs more breathing room by going up to the spacing, and I'll go ah and increase the space before and after paragraph. While we're here, I'll go ahead and change the dense. I'm just going to increase this a little bit. I think that looks good. I'll do the right side as well. Now that we've done that, we can go ahead and stylize this text however we want. I'll go ahead and bold it and italicize it again. All right. Let's see how good that looks. I'll just turn on preview mode here. Now we can see two different styles of how we could emphasize these quotes. These look really good, but you want to know the best part. Since all of these decorations were made in the paragraph panel, we can actually save them as a text style. I'm going to click in the paragraph that we turned red right here. Then I'm going to make a new style based off of that. Going into the text styles category. I'm going to go ahead and add a new paragraph style. I'm going to name it Red style. Then I'll go ahead and press. Now coming over here to our other page. I can click in any of these paragraphs here, and I can scroll down and apply the red style to it. Easy as that. We can very quickly make this quote a repeated style throughout our document. I'll go ahead and do that for the other frame as well. I'll click in here. I'll add a new paragraph style. I'll name this one Blue Style. Then again, I can click in any of these paragraphs here. Scroll up. I don't think I've ever mentioned this, but all of the styles are in alphabetical order, which is why for Red style is down here. B for Blue Style is up here. I'll go ahead and click on that. Just like that, we were able to very quickly apply these styles. Paragraph decorations are such a wonderful way to draw attention to an important paragraph. Now that we know a little bit more about that. In the next video, we're going to take a closer look at how we can stylize an entire text frame. 13. Text Frame Panel: This video, we'll learn about the text frame panel. This panel allows us to stylize an entire text frame, similar to how we stylized paragraphs in the last video. Now in order to do this, we need to first get out the text frame panel. We can find that by going up to Window, then go down to text. Then click on text frame. I'm just going to tuck this right up here next to pages. So it's easier to see all of these options. Just so you know there's actually another way to get this out. All you need to do is click to select a text frame. Then come up to the Context toolbar and click on this arrow here. Then you can click on T for text frame, that will also open up this panel. Right now, this is a lot to look at. I'm actually going to close up all of these different sections, and then we can go ahead and go through all of this together. First, let's go ahead and take a look at the general section. Starting off here, we can change the fill color of the entire text frame. I'll go ahead and make this a gray color here. We can also change the stroke. I'll go ahead and make this a purple color, and you can increase the stroke size a little bit, so you can see this better. If I zoom in here, you can see we have a few things we need to change. Well, first thing, we can actually change the join of the corner here to make this a sharp join. Go ahead and click in here and then you can make that a sharp join. But in addition to that, we can see that just like with the last video, this frame is overlapping onto the text. We can go ahead and change that by altering the insets here. I'm going to make sure this is locked together. Then I'm just going to type in this box 0.25. All of them will update together since I locked them. Now you can see we have a lot more space here. The next thing I want to look at is actually the next section here called columns. Using this, we can add columns to a single text frame. I'll go ahead and increase this to two. Once I've done that, we can also change the gutter. You can see the gutter right down here is set 20.333, but you can go ahead and increase this if you want to or decrease it if you don't need quite that much space. The other thing you might have noticed is that we can also change the widths right here. By changing the width, you'll be able to change how wide each of your columns are. You could make one column very wide while the other one is shorter. I'll go ahead and reset this with command or Control Z. We've already worked with columns in the past. You already know that we could actually just add columns right up here in the context toolbar. But this is just another place that you can do that. One last option that we have here is called balance text in columns. If I check this on, the text will become balanced side to side here. For example, even if I delete some of these paragraphs, You can see that the text balances out so that each side of the page is about equal. This is a nice design feature. Let's go ahead and close this and open up column rules next. To start, I'm going to go ahead and add a stroke. I want this to be the same color as the stroke on the outside. I'm just going to sample that by using the color picker and I'll apply that color there. Then we can go ahead and increase the size. Now you can see that this is adding a stroke to the very center point between our columns. If you want to line this up differently, you can change the gap. As I increase this gap, you can see that the line is shrinking down. In this case, it might make more sense to bring it up like that. But you can play with that however it looks good for your particular document. Let's go ahead and close this up and look at vertical position next. Each of these vertical positions will change how your text is set up in the text frame. Right now it's set to the top, but you could also center this or bring it to the bottom, or you could space it out like this so that all of the text in your frame completely stretches out to fill the area. These positions are actually also available up here in the context toolbar. We haven't worked with them much, but they're right here. If you ever quickly want to do this, you could just use that option. That's actually all we're going to learn about the text frame panel for now. But now that we've taken all this time to stylize our text frame. Is there a way to save this text frame style for the future? We can't actually save it as a text style because what's decorated is the frame, not the actual text. Instead, we need to use the styles panel. I'm going to come up to the top to window, and then I'm going to go down to styles. We haven't used this panel yet. This is exciting to try this out. In the Styles panel, there's all these default styles that you can use on your text. Right now we're in the default category. But I'm actually going to make a new category by coming up to the Hamburger menu. Then I'm going to press Add new category. I'm going to call this category text frames. Then I'll press. Now you can see we have a brand new category here. All we need to do is make sure we have this text frame selected, and then we can go back up to the Hamburger menu. Then we'll go ahead and press Add style from selection. Now we have this style right here that we can use, and you can go ahead and apply this to the other text frame. I'll go ahead and select this and add the style. Make sure that you have the move tool selected and that you're not clicked inside of the text. Then you can go ahead and apply the style. You can add as many text room styles as you want so that you can make all of your text frames look exactly how you want. I hope this video was helpful. Now that we finished up, adding style to our text. In the next chapter, we're going to learn some advanced text features. 14. Advanced Text: Affinity has so many tools for working with text, and I know you already know about a lot of these tools. But in this chapter, we're going to move beyond the basics to learn about ways to precisely control your text. It's going to be a lot of fun, so let's get started. 15. Two Text Tricks: Let's learn two text tricks in this video. Before we jump into the main lessons for this chapter, I want to share two quick text tricks with you. I didn't think that these were big enough for their own videos, but I still wanted to show them to you. Let's quickly learn how to make vertical text and how to control the spacing in between words. First, let's go ahead and make vertical text. I already typed out the word beauty right here in this text frame, which is important because you actually need to use the frame text tool for this to work, not the artistic text tool. To turn this into vertical text, all you need to do is push all of the letters in like this, and then expand this downward. That's pretty simple? I'm going to go ahead and make this quite a bit longer, and I'll make it a little bit wider, so I can show you how you can adjust this a little bit. The first thing you can do is go into the paragraph panel and you can adjust the spacing right in here. I'm actually going to adjust the letting, which you can do right up here. I'm going to go ahead and increase this. I think I want this somewhere in 96-144. I'm actually going to click in this box and just type in 100. Now that these are spaced up nicely, I'm going to zoom in here and show you that all of these letters are spaced a little bit away from the edge. But when you get to the A, it butts right up against it. To make this less noticeable, we can actually just center the text in the text frame right up here. Now all of the text looks nice and lined up. That was a pretty easy trick. I just wanted to show you in case you were interested. Now let's go ahead and move on to changing the spacing in between each word and a text frame. I'm going to go ahead and select this text frame first. This is the opening monologue of the Beauty and the Beast movie. First, I'm going to show you what not to do. What you shouldn't do is go into the character panel. And you shouldn't adjust the tracking. The tracking is the second option right here. If I increase this, You can see that the spacing is increasing, but it's doing this by spacing out each individual letter. This looks like an eye exam as you start to make it bigger and bigger. You can't really read the words very well. I'm going to go ahead and press command or Control Z to undo that. Now I'm going to show you what you should do. To do this the right way, go to the paragraph panel. Then come down here to where it says justification. What you'll want to do is you'll want to come right over here, and you're going to want to increase the maximum spacing. I'm going to bring this all the way up to 250. Now that the maximum spacing is so large, we can go ahead and increase the desired spacing, which is this middle top option right here. As we increase this, you can see that the space between each of the words gets larger, but the space in the letters stays the same. This is much better than the non example that I showed you before. This technique also works with smaller amounts of text, like the title right up here. But to make this easier to see, I'm going to go ahead and center this. I'm also going to center it vertically by coming right over here and I'll center it vertically like this. Then I'll go ahead and do the same thing. I want the maximum word spacing to go all the way up to 250, and now I can change the desired spacing. This can be nice for titles when you want to get a little bit fancy. I think that looks really nice. I hope you enjoyed these two text tricks. In the next videos, we're going to learn about some of affinity publishers more advanced text options. O. 16. Tab Stops: This video, we're going to learn how to use tabtops. Tabstops allow you to control how adding a tab to your text will affect your text. Now, before we get started into that, I just want to show you that here we have our exercise file, and we're going to be working in this section right here. This is a play that a high school is putting on. You can see here that we have one name representing the actor and the other name representing the character. I want to separate these names from each other just so it's a little easier to read this big jumble of text. Let's go ahead and start by clicking right in here. Then before each of the characters names, go ahead and press Tab on your keyboard to create a little bit of space. Let's take a look at what just happened. As you can see, most of these names are lining up very nicely right here. But then this name and this name, both are a little bit closer to their actors names. Why is that? Well, in order to understand this, we need to go to the paragraph panel, and then go down to where it says tab stops. Using this panel right here, we're able to better control what the tab button is doing to our text. What you can see right here is right now, affinity is adding half an inch of space every time that you press tab, which means that affinity will move your text to the next half inch spot in the text frame. To see this better, let's go up to the context toolbar. I'll click on this arrow here. Then I'll click here to open up the ruler. This is the text frame ruler. It shows a measurement of what's going on in your text frame. As you can see, most of these names are lining up array here at the two inch mark. Well, these names are lining up at the 1.5 inch mark. Because Emily Smith and Barbara Hall were shorter names. When I press tab, it moved it to the next available half inch spot, which happened to be pretty close to those names. Now that we understand what's going on, let's go ahead and select all of this text and now we can customize our tab stop better. Let's come right over here. Now, first, I think I want to move all of the text over quite a bit more. I'll start by typing in three. Maybe I want this moved over a little bit more. Maybe let's go with four. Okay. You can see what's happening right here is that all of the text is lining up with the four inch mark and it's lining up by the first letter of the name. However, I want this to be aligned to the side right here. I actually want it to be aligned up to the last letter of the name. In order to do that, all you need to do is come over here and press on this button. Now, you'll be able to adjust a few things about this particular tab stop. We can see it's already set to 4 ", which is good. But if I click right here, we can change the alignment. It's left aligned right now, but I'm going to change it to right aligned. Whoops, I didn't have the text selected. Let me just undo that. I'll press command or Control Z. Then I'll select all of the texts. I'll click on that button again. Now we can go ahead and change this to write alignment. Now you can see that the last letter of each of these words is lining up with a four inch mark. Now that that's lining up better. We can keep finessing this amount. Let's go ahead and try 5 ". Just so you know, you could also actually use this ruler right up here and you could move the tabstop from here. If I wanted to move it all the way over, I could. The next option we have here in our tabsop is the Tabtop leader. Now, if you remember from when we were making tables of contents, we actually use this to add a dot dot dot to connect the chapter name to the page number. We can do the same thing here. I'm going to click on the second option here to add a dot dot dot between all of these names. I think I'm done using the ruler now. I'll just come back up to the context toolbar and I'll click on that button one more time to turn it off. Now we can take a look at how our text is looking. I'm noticing that some of these dots are pretty close to the character's name, and in order to fix that, we can just manually put in a couple of spaces. I'm just going to do that a few times. Just to space it out. I'll go ahead and turn on preview mode so we can see this better. That looks so good. I'm so glad that we were able to easily do that. You can do this with any type of document. It doesn't have to just be a table of contents or a play. There's a lot of times when you want to connect texts together like this and tabsops are the perfect way to do that. 17. Bulleted & Numbered Lists: In this video, we'll learn how to create bulleted and numbered lists. Here we have our exercise file. On the left side, we have a list of places to visit in two different countries. Here you can see we have Canada, and down here, we have the United States, and for your convenience, if you're not familiar with either of these countries geographies, I've went ahead and labeled which of these places are provinces for Canada and which of these places are states for the United States. This will just make it a little bit easier as we start making lists. Then over here on the right side. We have a list of how to make cookies with steps on how to make these cookies. We have types of cookies and then a little how to guide down here. With that all said, let's go ahead and start over here. I'm going to select all of the text in this first text frame, and I'm going to change the text style. Let's go over to the text styles, and for this one, I'm going to change it all to Bullet one. I think I'd like to make all of this text a little bit larger. I'm just going to adjust this now. Then I'll go ahead and update the style in the context toolbar. Now that we have that done, we can go ahead and go through this list and adjust how indented each of these bullet points are. Starting with Canada, I'm going to move Ontario and Quebec in. Then since these are all cities, I'm going to move them in twice hitting tab on my keyboard. You can see as I've indented them, the little bullet has changed. Now you can see we have a round bullet first, then we have a squared off bullet, and here we have a hollow bullet. If you look over here in the textiles, you can see that this is actually bullet number three, the textile for that. This one is Bullet two. They automatically update, which is super nice. I'm just going to continue to do this. Now I press tab on my keyboard for all of those different locations, and I think this makes the list a little bit more clear as to what we're talking about. That's the basics of adding bullet points. But now I want to dig a little bit deeper. I want to make the bullet points go inward more. Then I also want to make the text go farther away from the bullet points. Let's go ahead and make those adjustments. I'm going to start right here with Toronto. Then I'm going to go to the paragraph panel to adjust the spacing. Starting with the indent here. I'm going to increase this indent. I'll just click here to increase that. And I like how that looks. I'm going to update this textile. You can see all of the other bullet points also moved over that amount. Next, let's make the text go farther away from the bullet point. To do this, we actually need to stay in the paragraph panel, but we're going to come down here to where it says bullets and numbering. Using this box, we can make these adjustments. In order to do that, we need to increase the tab stop here. I'll go ahead and increase that. It looks like nothing's happening here. Well, let's go ahead and check on this. I'm going to get out the text frame ruler. You can see here that I increased it to about a half inch. But all of these bullet points are right now sitting at 1 ". That means we actually need to increase the tab stop to greater than 1 " or it won't make a difference. Let's go ahead and do 1.25 ". Now you can see that that's moved over because it's greater than the 1 " mark that it was at before. I think that looks nice. I'll go ahead and update the style. Now all of the text is moved over. I can also put away this text frame ruler now. As you can see, now we have this beautiful list. Now that we understand bullet lists. Let's go ahead and move on over here and work on some numbered lists. I'm going to select all of the text here, and then I'm going to go into our text styles. To make a numbered list, we need to use the numbered styles, which are right here. I'll click on the one numbered one style. You can see now it's updated so that all of these items have a number next to them. I think just like with the last one, I want to make the text a little bit larger, so I'll go ahead and do that. Then I'll update the text style. Now, just like with the last list, I'm going to add a tab to the appropriate areas to make this list a little bit more comprehensible. Starting up here, it says, determine which type of cookie you will make, and then it has three types of cookies with a question mark. I'm going to tap inward for each of those. Then it says, by the ingredients. We have three ingredients here, so I'll go ahead and tap inward for those. Then it says bake the cookies and has instructions for that. I'll tap inward there. Well, this is technically a numbered list, but it might not look the way you want it to. I'm going to go ahead and make sure my cursor is blinking somewhere where it's updated to numbered two. Then I'm going to adjust this. Let's go over to the paragraph panel. Let's go back up to the spacing area right up here. Then we can go ahead and increase this in. I'm just going to bring this up, maybe to about an inch. Then I'll go ahead and update this textile. This looks a little bit better. But stick with me because now I want to show you one last advanced change that you can make to numbered lists. To show you this advanced change you can make, I'll zoom in here, and I'll place my cursor blinking where it says flower. Over the paragraph panel, I'm going to go down here to where it says bullets and numbering. Affinity has some fancy code going on right here where it says text. But what does this all mean? Well, first, you need to understand levels. Numbered lists use a hierarchy system called levels. Each time you press tab in your text, you move that part of the text down a level because we didn't add a tab here to buy the ingredients. This is level one. But we tapped once when we added flower. This is level two. You can see over here that because our cursor is blinking in the flower area, it's level two. But if I click where it says by the ingredients, it updates to level one. Now that you know what a level is, I want you to notice how in this example, the level one line by the ingredients is numbered two inside our text. Then each of the subsections within that is labeled 2.1 and so on. Affinity is doing that because of the first part of the bullets and numbering code right here. It says one, and then a period. This is telling affinity to add level one's number and a period to this list here. But if you don't like this, you can actually just come right in here and delete it. I'm going to move my cursor over and I'm going to delete the period and the number. Then I'll press enter. You can see now that's changed, and I can go ahead and update the textile right up here and all of these numbers will change. Now you can see all we have left here is the number and a period and then a tab. This number code places the number of each of these lines right here, and then we have a period and a tab to bring the text inward. I know this is getting a little bit confusing, but let me just show you one more thing. If you want to add any code to this, you can just press on this drop down menu right here. If you wanted to, you could add the level one code back to the beginning. Well, I just added it after, Let me delete that. If I have my cursor blinking. Right over here, I can use the drop down to add level one back, so you can see it's back, and then I could add a period again. When I press enter, you can see this update. Now it's back to normal. The code is exactly at the default state. You could update the textile if you wanted to to bring it back. I really don't want this video to get too technical. I think I'm just going to leave it there for now. If the last part of this video got a little bit confusing, don't worry about it. You really need to do advanced customization like this, but I just wanted to show you how powerful affinity can be if you really dig into it. 18. Advanced Text Styles: In this video, we'll take a closer look at how text styles work. Before we dive in, I just want to quickly give you an overview of this document. This document is all about nature. As you come down here, we have quite a few different words here, and we're going to arrange these all into sections as we go throughout this video. The first section is land animals, which is divided into large land animals and small land animals. Within each of those categories, we have the animal itself and a few different types of that animal. We have four different sections here that we'll need to assign different styles to. This continues. We have the land animals large and small. We also have s animals, large and small. Last, we have plants, large and small, and at the very end, we'll take a look at this quote, but we'll get into that a little bit later. To start off, let's go ahead and review what we already know about textiles as we apply some textiles to this document. Coming right over here to the textiles panel. Let's go ahead and apply heading one to the main sections here. The main sections are land animals, S animals and plants. Once you've applied these headings, we can go ahead and change how these headings look. I'll highlight this first one, land animals. Then I'll go ahead and increase the size of it. Then I think it would look nice if this was actually all capital letters. I'm going to go over to the character panel and underneath where it says topography, I'm going to click right here to make this all capital letters. Now that I've changed that, I can come right up here to the context toolbar to update this, and you can see that all of these headings update at the same time. As you can see, once a certain part of your text has a textile applied, you can change up this textile however you want by changing the word and updating it. Let's go ahead and give this another shot. I think I want each of these sections to start on a new page. To do that, we'll need to go to the paragraph panel, then go down to where it says flow options, and instead of starting anywhere, let's start on the next page. Right now, and animals is highlighted. But if we update this, we can see that the other two get updated with this new feature. I think I also want to give them a new color. With and animals still highlighted, I'll go ahead and change this to a nice light purple color, and then I'll update this. As you can see, it's pretty easy to apply and update textiles. But now let's learn a few more textile skills. First, let's go ahead and apply heading two to the large and small categories underneath each of these main categories. I'll go to the textiles panel, and then I'll apply heading two to each of these. With that all done, I want to show you a new way that you can edit text diles. But to do this, I'm going to move this over here so that I can still see the text. But this will give us space for this really big dialogue box that we're about to open up. To show you this, I'm going to come to where it says Heading two, and then I'll click on the Hamburger menu. Then I'm going to come down here to where it says edit Heading two. Once you click on that, you can see this massive dialogue box will appear and I'll just move this to the side. Now we can see the dialogue box and this text. Anything that we change within this dialogue box about Heading two, we'll automatically update over here. Just to quickly show you this. Let's start by changing the font. I'll make the font larger. You can see as I move this right here, all of those different heading twos update. In addition to changing the font, we could also change the color if we want to by coming to this section. Then I'll click here and let's go ahead and update this color. Some people find it easier to work in this dialogue box because it gives us all of these different character panel and paragraph panel options all in one place, and they all update at the same time. Feel free to use this as an option if you like this method better. To confirm all of our changes, I'll just press k. Now let's move on to creating another heading for the rest of these sections. As you can see, we have elephants and the different types of elephants. I'd like to create more headings. But as you can see over here, we only have heading one and two. We don't have a heading three or a heading four. How can I create more headings? Well, we actually have two options for this. We can create a brand new textile by coming down here and clicking on this button, or we could duplicate and edit an existing textile. I'll go ahead and show you how to do this. Let's go to where it says Heading two. Click on the Hamburger menu, and then click on Duplicate Heading two. Automatically, this duplicated style has been renamed Heading three, which is perfect. Now that that's created, let's go ahead and press k. Now we can go ahead and apply heading three to elephants. Because we duplicated this style, it looks exactly the same as heading two. We can actually change this now. I'll go ahead and highlight this. I'll shrink the size down a little bit. Let's turn off the bold and I'll also change the color. Last, I think I want to make this all capital letters. Let's go to the character panel. Instead of using our regular A CAPS option. Let's go ahead and click this one. This is a fun option because it makes it so that the first capital letter is larger than the rest. I think that looks pretty nice. While we're in this character panel section, I think I also want to increase the tracking to increase the spacing between all of these letters. Let's go ahead and change this. I'll space this out to 50%. I think that looks pretty good. I'll go ahead and update Heading three. And with that updated, now I can go ahead and apply this to a few of the other words in this document. I'll go back to the textiles panel. Each of these large and small sections has two different animal categories in it. I'm just going to quickly go through and add this heading three to those categories. We have lions, rodents, domestic cats. In this section, we have whales and sharks. We have sea horses and shrimp. Then down in the plants, we have trees and bamboo. And then flowers and air plants. I just showed you how you can duplicate a style. But I also want to show you how you can create a brand new style from the bottom of the textiles panel. To do that, I'm actually going to make sure my cursor is blinking here where it says African under elephants. When you create a new paragraph style from here, your paragraph style will be based off of whatever you have your cursor blinking in. Unlike last time, where heading two was duplicated and this automatically looked like heading two. This time, we'll create a new style that looks exactly like this. Let's go ahead and add that, and we'll go ahead and call this heading four. Then I'll press. As you can see, heading four looks pretty basic right now. It just has this exact same font, font size, it's black, no color has been added. Let's go ahead and edit this now. To keep it simple, I'll just highlight this and underline it. Then I'll update this heading style. Now we can quickly go through and apply heading four to all of the rest of these. It's a little faster this time because we can just highlight all of the words at once and then apply heading four. All right, at this point, we now have four different heading styles applied to this document. I think it's pretty cool that you can apply as many headings as you want to a document, as well as create as many headings as you want. But now I want to move on to this quote down here. So far, all of these styles that we've been creating have been paragraph styles, which means that as you click and have your cursor blinking in a paragraph, your entire paragraph will be updated to that paragraph style. But textiles actually also come as character styles, and this is shown by this little simple right here. All of these are paragraph styles, but when you scroll all the way to the bottom, this paragraph simple changes to the letter A, indicating a character style. What this means is that wherever your cursor is blinking, only that word will be updated as you click on that option. Just to make this a little bit more obvious, I'm first going to make this no style. Then I'm going to go ahead and apply these character styles. Right now, I applied emphasis to this word, so it's italicized. But I'll go ahead and apply strong emphasis so that it's italicized and bolded. Just like with paragraph styles, you can also update these character styles. I'll go ahead and underline this word, and I'll also change its color. This time, instead of updating the style right here where we've normally updated paragraph styles, we're going to come over here to update the character style. With that updated. Now we can go ahead and apply the strong emphasis to a few other words in this quote. Just like with paragraph styles, if we ever want to update how this looks by underlining it or something like that, we can just update the style and all of the words will change at the same time. Publisher will automatically come with these default character styles, but you could always add your own character style if you wanted to. This is a very similar process to adding the paragraph styles. You're doing so good. I just have three last tips that I want to share with you. My first tip is how to get rid of a textile that you no longer want over here. All you need to do is click on the Hamburger menu, and then you can scroll down here to delete it. Or if you happen to have that textile selected, you could just click on the trash can down here to delete it. Tip number two is how to save your textiles. Let's say you put a lot of work into creating these textiles, and you would like them to be available every time you open publisher. Well, right now, Affinity Publisher documents open with these default styles, not the new ones that you make. Whenever you make a new document, it begins from scratch with the default styles that come with the program. But lucky for us, we can actually change what the default styles are. All you need to do is go to the textiles panel and go to the Hamburger menu. Then all you need to do is click on Save Styles as default. This will override the current default settings and make it so that you can always use these two headings that you just created as your default. Just to show you how this works, I'm going to quickly set up a new document, so I can show you that these two headings look the way that we design them in this document. I quickly just created a new document. Now I want to show you that as I apply Heading one, it's that same purple, large font that we used in our last document, and the same works for Heading two because that's also there. It's been updated. This is great if you really like this style and you want to use it over and over again. But if you ever find yourself not liking these new headings, you can actually restore the defaults. However, this is a little bit tricky, so stick with me. If you want to restore the default textiles, get out the move tool and make sure you have no layer selected. Then go to preferences, go to miscellaneous at the bottom. Then click on Reset Default textiles. Clicks, click. Now your textile should all be set back to normal. I'll make another new document to show you this. I created another new document now, and now I want to show you that heading one has been restored, it's back to normal, and Heading two is as well. My very last tip for you is what to do if your textiles aren't working the way that they should. Sometimes textiles might start acting strangely in your document. If that's the case, I suggest that you just have your cursor blinking in your text and then apply no style to it. Then you can go back and apply any of the headings again. Sometimes affinity just needs to reset and by applying no style, you'll be wiping any memory of previous textiles. This is just a very simple fix if you ever have textiles not acting properly. All right. Great job. I know that was a long video, but I hope now you understand a bit more about adding textiles, and you even now know how to add character styles. Now that you know all that, in the next video, we're going to learn about a special feature called Textile Groups. 19. Text Styles Groups: This video, we'll learn about textile groups. A Style group allows you to have multiple textiles that are all linked together. This allows you to change all of the styles in the group at the same time. Let's take a look at how this works. First, go into the textiles panel and then click on this Hamburger menu, and then make sure show hierarchal is checked on. With that checked on, now we can see all of the textile groups that affinity gives us. By default, we have a base group right here, and when we open that up, we can see we have a few categories. We have the body category, we have a bullet category, a numbered list category, and all of those categories are included in this base group. Basically, everything until we get to this no style area is in one group together. Opening up the base group, I'm going to go ahead and apply heading one and heading two to a few of these things on this first page. First, I'll go ahead and click in here and where it says Artists, I'll make that heading one, and where it says entrepreneurs. I'm also going to apply heading one to that. Then I'll go ahead and apply heading two to the two people's names. I'll do that in this category as well. Last for all of this text here, I'm going to apply Bullet one, At this point, all of this text has a style added to it. Now we can go ahead and edit all of these headings at the same time. To show you this. I'm just going to move this text over here, so we can still see it. Then I'll go ahead and click on the Hamburger menu next to its parent group here, which is Base. I'll click on that and then I'm going to press Edit base. I move the text over so we could better see it because within this dialog box, we'll now be able to change things about all of this text at the same time. I'll go ahead and go into the color area. Then I'm going to change the text fill color and check that out. At the exact same time, all of this text was updated. Now all of it's red. That's pretty amazing, and that's the magic of textile groups. Oh Whoops, I accidentally pressed cancel. Let me go back into base. And I'll turn that red and press. As you can see, all of the text was updated. Now that we understand how these text style groups act in these default categories here, let's try to make a style group of our own. To make a style group, you need to click on the S right here at the bottom of this panel. This will create a group style. I'm going to name this one. One thing I want you to notice about this is that under type, it's not a paragraph or a character style, it's a group style. That's exactly what we want. Let's go ahead and press. Now over here, we have a quotes category. Let's go ahead and add some textiles to this group. I'm going to click on this Hamburger menu, and then I'm going to come down here to where it says Create style based on quotes. Then I can go ahead and name this style. This first one here, I'm going to call short quotes. And I'm going to change the type to a paragraph style, and then I'll press okay. Now if I open up this quotes category, we can see we have one paragraph style in here called short quotes. I'm going to continue to do this a few more times, so clicking on the Hamburger menu, create style based on quotes. This one will be called Medium quotes. I'll go ahead and make this a paragraph style and I'll press k. Let's do it one more time to create a textile for long quotes. With that change to paragraph, I'll press k, and now you can see our quotes category has three different textiles in it. Now we can go ahead and apply these styles. I'll go ahead and apply the short quote style to the shorter quotes here. Of course, they're not going to change how they look yet. Once that's applied, I'll go ahead and highlight this. Then I can change a few things about it. For example, I'll increase the size. I'll make it italicized. Then in the character panel, I'm going to change this to all capital letters. Now I can go ahead and update this textile. You can see all of those quotes updated and it looks like it updated here as well. That's perfect. Let's go ahead and apply the medium quotes next. Then we can go ahead and highlight one of them so we can change it. I'll go ahead and increase the size of this one and I'll make it bold. Then I'll go ahead and update the style right up here. Let's go ahead and do the last one. We'll apply the long quote category to all of these longer que. Then we can go ahead and edit them. This time, I'll go ahead and just italicize it, and then I'll justify it left. Then I'll go ahead and update this style. Now, all of these quotes have a distinct style, and now we can edit them as a group. I'll move it over here, and then I'll go ahead and open the Hamburger menu, two quotes, and then I'll edit quotes. Now we can change things about all of these quotes at the same time. For example, going into the font category. I'm going to change the font to times New Roman. Now you can see they all updated from there. I'll go ahead and also change the color. Then I'll go into the paragraph category and change the spacing. I think I want to change the space after paragraph and I'll just increase that a bit. Then I'll press okay. All of these textiles have automatically updated because I updated the entire category at the same time. If you use textiles a lot, it might be worth your time to set up style groups because they can be very useful if you want to update all of the styles in your group at the same time. To finish this video, let's just go ahead and set our textiles back to Alphabetical order. I'll click on the Hamburger menu and turn off show hierarchal. Now you can see it's back to normal. Great work in this chapter. I hope you learned a lot about these advanced text features. In the next chapter, we're going to learn about publishers reference tools. T. 20. References: This chapter, we'll be learning all about publishers reference tools. Now, this might sound a little confusing, but all it really means is that we'll be working with things like footnotes and tables of contents. We're going to be learning a lot, so let's get started. 21. Section References: In this video, we'll learn how to add section references. To practice this, I've set up a condensed version of the adventures of Sherlock Holmes. Go ahead and open up this exercise file. In this exercise file, we have a title page and then a few chapters here. As you scroll through, you can see the title of the chapter is nice and large. My goal for this video is that I want us to have the name of the chapter at the bottom of each page so that people can easily know which chapter they're in when they open to any page. To do this, we'll need to divide our document into sections, which is the way to tell affinity where each chapter begins and ends. To do this, let's go ahead and open up the section manager. To open up the section manager, just go right over to the pages panel and click right here. Now we can start to divide up our document into sections. By default, every publisher file has one section, the section that goes from the first page to the very last page. We'll add more sections in a minute, but for now, we'll go ahead and name this first section and we'll name it right here. Let's go ahead and name this a scandal. In Bohemia. That's the name of the first chapter. Go ahead and press, enter, or return on your keyboard. Now you can see that section has been named. Now we can go ahead and add the next section. But to do this, let's first just close out of here and we'll need to scroll down to where the next section starts. You can see in the pages panel that this next chapter starts on page nine. I'll go ahead and double click on this page, and with it selected and highlighted in blue, I'll open up our section manager and I'll add a new section. Now, even though I was clicked on page nine, it went ahead and started on page eight. I think it wants us to include the entire spread, but we don't want that. I'm going to have this start on page nine, and then we can go ahead and name this section. The name of this chapter is the Red Headed League. I'll go ahead and name that here. I'll press enter on my keyboard, and now we have a new section. I just want you to note here that you can't actually tell affinity where to end a section. Instead, Section one automatically ends where Section two begins. I'll close out of this and then we'll go ahead and scroll down to the third section. Right here, it's page 15, a case of identity. Let's go ahead and go back to our section manager. We'll add a new section, starting on page 15, called a case of identity. Then I'll go ahead and repeat this process for the last section here. Now it's time for us to add the section chapter name to the bottom of each page. If we want to affect every page in our document, where should we go? To the master page? Let's go ahead and double click on that. And now we need to make a text frame that we'll place the name of the chapter into. I'm going to go ahead and place this right down here. I'll make it nice and long because some of these chapters are quite long in name. Now we need to insert the chapter's name into this text frame. But we can't just type the name of the chapter in the text frame because each chapter has a different name. We need to find a way for this text frame to update based on what section it's in. This is very similar to when we added page numbers. But this time, instead of adding page numbers, we're going to add a section field. First, we need to open the fields panel. We can do that by going to window, then references, then fields. This fields panel will open up. I'll go ahead and just tuck this right over here. I'll make sure my cursor is blinking in this text frame by clicking inside of it. Now we can go ahead and go to where it says Document sections. I'm going to double click on where it says Section name. Affinity has just entered a code right here that's telling affinity, place the section name in this box. I'll go ahead and highlight this just to make it a larger text. I'll also go ahead and center this box up like that. Then I'll center the text. Let's go ahead and close up this fields panel. We don't need it anymore. Now we can go into our document and see that each of the section names is now at the bottom of the page. We can see that this works, but now we need to update it a little to make this look better. I'm going to go back to the master page. Just to make this look a little bit better. I'm going to go ahead and highlight this. Let's change the font. I think I'll just use Ts New Roman and I'll italicize it. I like how small it is, but I think I want it a little lower on the page. Let's go into our document to make sure we like that placement. I think that looks pretty good. Now I'll just go back to the master page and I'll duplicate it for the other side. I'll hold down command or Control and shift. Then I'll click and drag it right over here. Now as we go into our document, every page should have the section name in it. You can see on this page, it updates from here to here. I did notice though that we don't need the section name right here on the first page. To get rid of that, it's pretty easy. All we need to do is enter type mode and then get rid of all of that text. Now that won't show up there. This technique is only possible because we named our sections. This is how affinity knows what each pages section should be called. That's why it was very important to make sure we put a section name in here. Just so you know, we can rename these sections at any time. Just click in this box, type in a new name. Press Enter, and then it automatically will update to the new name. All right. Great work in this video. I hope this was helpful for you. Now that we know how to add section names to each of our chapters. In the next video, I'm going to show you how to create multiple tables of contents in a single document. 22. Multiple Tables of Contents: This video, we'll learn how to add multiple tables of contents. For this exercise file, I've put together a family living magazine, organized into three different sections. We have a section here for children. Then as you scroll down, we also have a section for teenagers. Last down here, we have a section for parents. Within each of these sections, we have subsections here. As you can see, we have quite a bit going on in each of these sections, and I want to be able to organize each of these sections into their own unique table of contents. Then after all that's done, I'd also like to make a table of contents right up here at the top. The children and teenagers and parents can all have a little place right here linking to their sections as well. We have quite a bit going on. The first thing we need to do though is to open up the table of contents panel. I'll go ahead and go to Window. Then we can go ahead and go down to references, table of contents. If yours isn't already, go ahead and tuck it over here with the pages panel, and now we can go ahead and get started. Let's start off with the children's table of contents here. I'll go ahead and have my cursor blinking here. Then let's see what happens if we insert a table of contents. We've run into our first problem. This is the headings one and two for the entire document. You can see this because as we come down here, we have staying healthy and social life. Those are sections that are actually in the teenager section. In order to fix this, we need to use Affinity section manager like we did in the last video. We need to tell publisher that the children's section is separate from the other sections. Let's go ahead and go to the pages panel so that we can organize our sections. Just to show you another way to add a section. We could go to the section manager or we could right click here, and then go to Start New section. This also brings up our section manager here. Now we can go ahead and rename this section. I think I actually want this to start on page three, since that's the children page. I'll go ahead and name this children. I'll press Enter to confirm the name change, and then we can go ahead and add sections for the teenagers and the parents. But I'll need to go down and see what page number that's on. All right for the teenager page, I'll right click. Start New section. That's starting on page 15. Yeah, that looks good. I'll go ahead and name that teenagers. I'll press Enter. Let's do that one more time for the parents. With that, let's go ahead and come right back here to the Children's Table of Contents. I'll go to the Table of Contents panel. Then I'll go ahead and update this table of contents. I clicked date, but nothing happened. Here's another problem. One thing we need to change in the table of contents panel is we actually need to change the scope. We wanted to not be the entire document, but by section. If I click here and then update, now you can see that only the children's section is included. All right, with that all worked out. Let's go ahead and stylize the table of contents. With all of the texts selected, I'm going to go ahead and change the font. Let's go with times New Roman. Then I'll go ahead and increase the size, since we have quite a bit of space in this text frame. Then I think I want to bold heading one, where we have a heading one here, I'll go ahead and select that. And bold it. Then coming over here, I'm going to update this text style. Perfect. Then for Heading two, I want to add a dot dot dot to connect it to its number. To do that, we'll need to go to the paragraph panel. Go down to where it says Tabtops. Go to the third button over, and then select this tabtop leader. Now we have the dot dot dot. Perfect. Let's go ahead and update that style. I think this is looking really good. But the last thing I want to change is, I think I actually want to remove this page number right here to remove a page number from one of these headings, go to the hamburger menu next to it, and then uncheck, include page number. All right, just like that. I think this looks so good. Let's keep going. We need to do the teenager table of contents next. I'll go ahead and come down to this page. I'll have my cursor blinking, and then I'll insert a table of contents. Once again, it's including more sections than we need. We need to make sure we change the scope to section, and something looks wrong about this. We spent all that time stylizing the last table of contents, and this one doesn't have those stylizations. Why is that? Well, if you look up here, this textile is heading one, but it's TOC two. This means that affinity was trying to be helpful and it created a separate textile for us when we made a new table of contents. But we don't want this. We want the table of content styles that we already made. What we need to do is come over here and where it says TOC style. Go ahead and change that to TOC one. Now you can see we have all that styling back. All right. That went a lot faster. Let's go ahead and scroll down to the parent section and do the same thing one more time. We'll add a table of contents. In this case, this is actually going from this point onward in the document. We don't actually need to change it to section this time, but I'm going to. It's just good practice. Then I'll go ahead and change the TOC style to one. A great work. Just like that, we now have multiple tables of contents in a single document, and they all have beautiful styling. I think this looks so good. In the next video, we're going to add on a table of contents at the beginning of this document by using a custom text style. Go ahead and keep this document open, and I'll meet you in the next video. 23. TOCs with Custom Text Styles: This video, we're going to learn how to add a table of contents with a custom text style. We're going to build off of the document that we started in the previous lesson. As we do this, I'm going to show you a few other table of contents tricks that I think you're really going to enjoy. This table of contents that I want to make at the beginning of this document is going to link to the three main sections in the document. To do that, we first need to add a textile to the words children, teenagers, and parents so that the table of contents can know what to include. Now, I don't want these words to look the same as my heading ones. Instead, I think I'll just make a new textile based off of this one. With my cursor blinking in the word children, I'm going to come over here to text styles. Then I'll add a new paragraph style. This style, I'll go ahead and call Section heading. Then I'll press okay. If you scroll down here, here's section heading, and you can see that that's already been applied to children. I'll go ahead and apply the same section heading style to teenagers. And to parents. W that done. Let's go ahead and insert a table of contents at the very top of our document. I'll click in this box and then I'll go ahead and insert a table of contents. We don't want heading one and two included. I'll go ahead and turn those off, and then I'll scroll down and press on section heading to inc. This doesn't look quite right. The styling. Let's go ahead and apply table of contents one section styling. Now that really doesn't look right. It brought back heading one and two, and it's not including the section heading. Well, it looks like we can't do that then. Let's go back to table of contents two. It looks like we'll just have to manually add our own styling in this table of contents two section. Let's go ahead and do that. I'm going to change the font two times New Roman. I'll also increase the font size. Then in the paragraph panel, I'll go ahead and add that do do in the tab stop section. Then I'll go ahead and update this style right up here. This is looking pretty good, but it's not great. I don't really like that the words are in all capital letters. I want them to be in all capital letters in our document, but I don't really want that to happen here. What should I do? Well, here's a little trick for you. I'm going to come right down here to page three. I'm going to click here and I'm going to rewrite Children. Without capital letters. Then I'm going to grab the move tool so that I can edit this. Coming over here to the character panel, I'll go ahead and capitalize the letters from here. Then I'll update the text style. What I just did was a trick to tell affinity, No, no, this isn't all capital letters. It's just a style that I added. The letters are still lower case as far as affinity is concerned. They're just capitalized because of the section heading style. I'm quickly going to do the same thing for these other words. I'll rewrite it in small caps. Now, with this textile, it looks like I'm still writing in all capital letters, but I'm not. This is just the textile. I'll quickly do this one last time with parents. Now we can go right back up to the top and we can update this table of contents. Now you can see that they're all lower caste like normal, but within the document, they're all capital letters. That worked out perfectly. I have another tip for you if you want to get really fancy. We can actually use an invisible textile to have this table of content say, whatever we want. I'm going to come here to page three, and then I'll grab the artistic text tool and I'll drag out a letter. Then using this text tool, I'm going to type out articles for children. Ages seven to 11. With the move tool selected, I'm going to turn off all capital letters. Now I'm going to add a new paragraph style. I'll come to text styles. I'll add a new style with my cursor blinking right in here. I'm going to call this one invisible Section Header. Go ahead and press. We're going to update this style in a minute. But for now, I'm going to add two other section headings to the other pages. Coming right down here to teenagers, I'll go ahead and drag out some texts and this one will say articles for teenagers. Once I've typed that out, I'll go ahead and add the invisible section header. Let's do it one last time with the parent section. This one will just say Articles for parents, ages 18 plus. With the cursor blinking, I'll make sure invisible section header is applied one last time. Now for the magic, I'm going to go over here to the color panel, and I'm going to lower the opacity all the way for the fill. I messed up there. Let me make sure that the move tool is selected. Then I'm going to turn the opacity all the way down. With the opacity lowered, I'm going to go ahead and update this. Now as we scroll to the other pages, the text should be invisible. Perfect. Now we can use that text and a table of contents. This is very sneaky. Let's go ahead and see what this looks like. I'm going to turn off section heading, and I'm going to turn on invisible section header. Now the table of contents can say whatever we want. Just as before, you could style this table of contents, however you want. I'll go ahead and quickly do that. With that done, I'll go ahead and update this style up in the context toolbar. All right. Great work, everyone. Now I just have a few less tips before we finish. As a reminder, instead of using textiles throughout your document, you could manually write out whatever you want the table of contents to say. For example, if you wanted to, you could say this is articles for adults and parents. But if you do this and you ever need to update your table of contents, that writing will disappear. Just keep that in mind. If you want to customize this, don't update it later. That brings us to our next tip. The table of contents panel actually has two update arrows here. One updates the table of contents that you're currently working on, and the other updates all of the tables of contents and your entire document. This is a helpful distinction if you have lots of tables of contents, but you only want to update one of them. If you do want to update one of them, just make sure you're clicking on the first button here. Finally, my last tip, and I've told you this before, make sure when you're exporting as a PDF, you include your hyperlinks. You want to make sure that everything is linked up nicely once it's exported. Great work on this video. You are now a table of contents master. 24. Footnotes: This video, we'll learn how to add footnotes. To add footnotes. We first need to get out the notes panel. Let's go ahead and go to Window, then down to references, and then down to notes. I'm going to add this panel right here next to the pages panel. Then I'm going to go ahead and close up all of these sections. All right. Using this panel, we can add footnotes, side notes, and end notes to our document. We're going to get to these two later. But for this video, we're going to focus on adding footnotes. To start, I'm just going to click into my text and have my cursor blinking right after the word that I want footnoted. I'll go ahead and click right after the word Alexander, and then to add a footnote, I'll click on this button right here. A couple of things just happened. We have a little number one next to Alexander, and down here, we have a spot where we can type in whatever we want this footnote to say. Just in this box, I'm going to type in his friends called him, Alex. All right. Now I can go ahead and click out of this box and make sure you turn on preview mode. We can see this a little bit better. And now you can see we have a little number one down here and a one up here. This looks pretty good so far, but we can adjust this to make this look even better. For example, I want there to be a little bit more spacing between the footnote and the text. We can fix that by going to positioning. Then we can change where it says mint gap before. Let's go ahead and change this 220. This has pushed the sentence that was at the bottom to the next page since we added a minimum of a 20 point space between the footnotes and the last line of text. They just move that over, and now this looks a lot less cramped. Another thing we can change is this little line right here. This line is called a rule. If we go to the rule section, we can adjust how this looks. For example, we can change the vertical offset and increase this a little to give the footnote a little more space. We can also change the length right here. I'll go ahead and make it 1.5. I think that looks really good. Now, I think I just want to adjust how this text looks. Now that I've clicked into the text, you can see that this is the body style right now. This works well if you use the body textile for your remain body text and wanted to use the same style. But let's practice making a brand new style just for footnotes. Let's go over here to the textiles panel and add a new paragraph style. I'll call this footnotes. Then I'll press. The footnote style has been added right over here, and now we can go ahead and update our text. I'll just highlight this. I think I want this to be a little bit smaller and italicized. I'll go ahead and update the footnote style, and now you can see what that looks like. This is looking really good. Now I want to add another footnote. For your convenience, I actually already typed out a footnote for this one. Go ahead and highlight this, and we can go ahead and cut this with command or Control X. Then we'll place this footnote. I want this footnote to be right here after Macedon, go ahead and add a footnote, and then we can paste the text in with command or control V. Okay. What's going on here? We want this to look exactly the same as our footnote style, but it didn't copy that over. That's because we actually just applied that style to this one line of text, but we could actually tell the notes panel that we want to use it every time. To do that, we just need to come in here to the notes panel and go to format. Then go down here to where it says note body style, and we can go ahead and change this here to the footnotes. Now all of your footnotes will automatically be updated to this footnote style. Now that we have two different footnotes down here, I think I want to space them out a little bit. I'll go back down to the positioning area and I'm going to change the gap between. Let's go ahead and increase that to five. All right. Let's go ahead and add another footnote now. This time we'll go ahead and do one on the other side. Now, I'll go ahead and select all of this, and I'll go ahead and cut this with command or Control X. Then we can go ahead and add a footnote after the word worldwide. Go ahead and add a footnote there. Now, I just want to see test test. Yes. It did keep the style. That's good. However, there's a problem when we press command or control V. You see how it's not italicized anymore. That's because when you copy and paste something, it actually keeps the copied text style that it started with. We can actually get around this by doing some fancy pasting. I'll press command or control z to show this to you. Then we just need to come up here and go to edit and instead of simply pasting, we're going to paste without format. Now is the proper format. This allowed us to have affinity, forget the previous style and just use the footnote text style. Paste without format is actually an option that a lot of programs have, and it can be very helpful when copying and pasting. I'm just going to do one last footnote here. Let's go ahead and take the last of this text. I'll cut this with command or Control. I'm going to add a footnote right here after the great. I'll add a footnote. Then I'll go to the edit menu and paste without format. Now we have our last footnote added. Now that we have two footnotes on each page. I just wanted to point out that the numbers are restarted on the second page. We have one, two, and again, one, two. You can actually customize this if you don't like that, if you want it to continue to number upward and make this three, four instead. All you need to do is go to the numbering section, and then go to where it says restart. You could have it restart every page, every section, or you could have it restart in the document, which means the numbers will just keep going up throughout the entire document. I'm just going to keep it set to frame, but just so you know that's where you can change it. You could also change the number formatting if you wanted to right here. For example, you could use letters instead if you like how that looks. Just a quick tip. If you ever want to remove a footnote, all you need to do is actually go into your document and press delete, where it says B, just like that, the footnote disappeared right here and all the text disappeared down there. Something that I want to point out in the notes panel is that you can actually have your footnotes document wide or custom, which means that any changes that you make in this panel will be applied to your entire document in this setting, or if you change it to custom, you'll only be affecting the footnotes on the page that you're on without affecting the footnotes on all the other pages. If you really like the document wide settings that you've edited in this document, you could actually save them as the default footnote settings that publisher will use whenever you make a new document. All you need to do is go to the Hamburger menu, and then you can go down to where it says, save document settings as new default. From the same hamburger menu, you could also reset the document settings to factory defaults if you don't want to use your new settings anymore. We're just about done, but I have one last beyond the basics thing to show you. Let's learn how to split a footnote onto multiple pages. First, we need a longer footnote to work with. I'm going to go ahead and add some extra text here. I'll copy this entire paragraph and press command or Control C to copy it. Then in my footnote number two, I'm going to paste this text. I'll just add a space there. Then let's go up to edit and paste without format. Now we have a very long footnote here. In order to split your footnote, you need to go to the positioning area and then make sure allow split notes is checked on. Then you can go ahead and place your cursor wherever you want to split this, and then you can go ahead and add a page break. Let's go up to text, go down to Insert, breaks, page break. Once you've gotten there, go ahead and click on that. Now you can see this split. The text was here and now it's all over here and it's continuing on. If you ever have a super long footnote, this could be a nice thing to have in your back pocket. Something I just noticed is that the line on page two is super long, why is that? Well, if we come over here to rules, we can see that this is set to first note, and it has the length set to 1.5. What happened here was because this is a continued footnote, it went ahead and doubled the length of this line. But if we change this from first note to continued note, and then set the length back to 1.5. Now you can see that the lines are the same length again. That's just a little quirk that will happen if you ever do a continued footnote. Great work. Now that you know all about footnotes. In the next video, we're going to build on what we just learned in this lesson as we learn how to add end notes and side notes. 25. Endnotes & Sidenotes: This video, we'll learn how to add end notes and side notes. Now, lucky for us, adding notes and side notes is very similar to adding footnotes. This video should be pretty easy. Let's start off with adding side notes. I'm going to go ahead and add a side note, somewhere in this block of text, I'll just click here. Then I'll click on this little button right here to add a side note. Now you can see as I zoom in here that a number has been added right here, and now we have a place to type in text right here. I'll just go ahead and type a little side node in here. Once you've typed in your side note, you can change a few things about it just as we did with footnotes right over here. For example, we could change how the numbers are formatted if you want them to be letters instead. In addition to that, you can also go down to formatting and you can change the note body style just like we did with the footnotes. But you already know all that. Let's move on to some new stuff. The new things are down here in the positioning category. In here, you can change the width, which we definitely need to do because this is quite wide right now. I'm going to go ahead and type 0.75 right in there. Now you can see that we've shrunk it down so it can fit on the page better. But in addition to that, I think that the text is just really large right now. We can go ahead and fix that by making a new textile that's a lot smaller in size. To start, I'm just going to come over to the paragraph panel and add a new textile and we'll call this side notes. Go ahead and press. Then over here in the formatting, I'm just going to say, make sure you use side notes. Now we can go ahead and edit how side notes looks. I'm going to make the size a lot smaller. That should be good. Then I'll update the textile. Now every side note we add should look just like this. Now, back to positioning, I'd like to change a few more things about how this looks. We already decrease the width, which I think looks a lot better. But the text is currently being pushed off of the page, and we can change that by changing the distance from frame right here. I'm going to go ahead and shrink this down. At 0 ", you can see it's butted right up against the frame, but we could increase this. I think we'll need to type in a number, maybe 0.5. No, that's too far, 0.2. Maybe 0.15. That looks pretty good. If you wanted to, you could also change the note position. Right now, wherever you add a side note, this side note will appear closest to wherever your side note is. Right now, this is over here on the right side, so the side note appeared over here. But if you want to, you could just change it to always appear on the left side. Either way works just fine, and that's the basics of adding side notes. That's pretty easy. Let's go ahead and check out end notes next. I'll go to the end note section, and then I'll go ahead and add an end note somewhere in my document. I'll go ahead and click right here, and then I'll add an end note. What just happened? Well, it jumped us to the end of our document and added an end note section. Right now you can see we have a little one right here. If we go to the spot where I had my end note, There's a little one right there as well. Now we can type whatever we want in this end note section. I'll go ahead and type in. This is my first end note. Most of the options in the notes panel are very similar to what we've already seen with footnotes and side notes. Right now, this is using the body style for text, but we could give this a new text style, or we could change it to any style we want. For example, I could just change it to the normal style. Now I think I want to update how this looks a little bit. I'll go ahead and highlight this. Coming back here, I'll just go into formatting and change this to normal before I forget. Now I can go ahead and make some changes to it. I'll make it times New Roman, I'll make it a little bit larger. Then I'll update the style. We could also change the title of this n note section if we want to, and we can do that at the bottom of this panel. Just go right here to where it says title text and you can type in whatever you want here. Then press enter to confirm it and you can see it's updated right up here. Now that I've set everything up, we can easily add more en notes if we want to. I'll just come back here in my text and add another one. Now you can see that's linked right here and you can type in whatever you want. The last thing that I want to point out is that you can make end notes hyperlinks. Make sure you have hyperlinks turned on right over here where it says generate hyperlinks and make sure as you export you include hyperlinks just as we did in the table of contents lesson. Now, something I just realized is that we have numbers here for our end notes, and we also use numbers for our side notes. I think I'd actually like to change that. Maybe for the side notes. I can go ahead and change them to using letters instead. That way, there's a difference in our text. We have A, and then we have one, just to differentiate that a little bit. And with that, we are done with this video. I hope you enjoyed learning all about side notes and n notes. Now that you know about all of those features, we're going to dig a little bit deeper in the next video as we learn about another amazing feature that publisher has, which is adding an index. 26. Adding an Index: This video we'll learn how to add an index at the end of your documents. This exercise file is full of plot summaries for the first six movies of Star Wars. Spoiler alert, if you haven't seen those movies. This video will contain brief mild spoilers. As you scroll through here, you can see we have a plot summary here and then a new one starts here. There's a few pages of this, and then at the very end of your document, we have an area to add our index. To begin adding our index, we first need to get the index panel out, which you can find by going to Window, references, index. I'm just going to tuck this right over here next to our pages panel, and now we can begin. I'll go ahead and click in this text frame to start. Then I'll press on this plus button. This plus button will allow us to add a topic to our index, which is just the word that will appear there. For our first one, I'm going to type in LA. Then I'll press okay. Nothing happened yet, but if you look over here, it looks like we added the word Laya now all we need to do is tell Affinity what we want done with this topic. I'm going to right click on the word Laya then I'm going to come down here to where it says, Find in document. Right now, it's found the word Laya throughout our entire document. You can see all of the instances where she appears. You can check all if you want to include all of these references, or if you see a couple that you don't want to include, you could go ahead and uncheck them. But I'll just keep them all turned on and then I'll press done. What this has done is it's added all of these instances to the word ya, as you can see over here. Now I can go ahead and add this to our index. But first, we need to add the index. I'm going to click on this button right here, which will insert our index. Now you can see we have the letter and the word Laya right there along with all of those pages that she's included on. Let's go ahead and add a few more topics. I'll just close up Layer right here, and then I'll add another topic by pressing on the plus button. Let's go ahead and add another L word. Let's go with Ando, another character. I'll press okay. Then I'll go ahead and right click, find in document. I'll select them all and then I'll press done. We'll need to update the index every time we add a new character. I'll go ahead and update that. Now you can see him appear right here with all of his page numbers. Let's do it again. I'll press the plus putin, and this time, I'm going to add Palpatine. It's important that you spell these words correctly or it won't be able to find them. Make sure that you're doing the correct spellings. Then we can go ahead and press. I'll scroll down to find Palpatine, I'll right click, find in document, select them all, and then press done. I'll update our index right up here, and now we have an entirely new category. Now I want to do something a little bit tricky. I'm going to add another topic. And this time, I'm going to type in Sidis. If you remember Star Wars, then you'll know that Senator Palpatine is just Darth sides in disguise. When people look at the entry for Palpatine or Cis, I might want them to know about the references to the other word as well. Down here where it says C, I'm going to click on this drop down and I'll add Palpatine right here. Then I'll go ahead and press, and now you can see it says Citis C Palpatine. I'm going to go ahead and add Citus page numbers by right clicking, find in document. I'll check that and then press Done, and I'll update the index. Now you can see it says Citus with all of his page numbers, as well as C also Palpatine. You might want to do this with the word Palpatine as well, referring it back to Cis. To do that, right click on where it says Palpatine, and then you can click on Ad cross reference. Then right in here, you can use the drop down to click on where it says Ci. If I press ok right now, I'm working in A beta, so this feature actually isn't currently working. Hopefully, by the time you get this, you'll be able to just press k and it will appear. But for now, I'm just going to cancel. If that had worked properly, it would also say, S also Cis right here. Sorry about that. But this should work for you. Now, over here in the index panel, you can change the labels. If you don't want it to say C also, maybe you want this to say refer to, you can change that here and then press Enter, and that will automatically change what that says. And while we're over here in these index settings, I also want to show you that you can change where it says group page ranges. If I uncheck this, it will list every single page individually instead of using the dash to represent all of those pages. Feel free to use that if you'd like. We can also say, we don't want to include the section heading, which is the letter right here. If you'd rather it just look a little bit simpler, I'll go ahead and keep those both checked on because I like how they look, but those are another option you can change. Now that we know the basics of indexes. I want to go a little deeper and learn how you can make subsections in your index. What I want to do is I want to make a section for all of the Jet and then list the names of the Jedi underneath that. To start, I'm just going to press on the plus button, and I'm going to type in JI, I'll press K. You can see the word Jei right here and we're going to add page numbers later. But for now, I'll go ahead and add another topic. This time, I'll add Yoda, and I'm going to change the parent topic to say JI, I'll press K. Then I'm going to right click on where it says Yoda. I'm going to find all of the references to YODA in the document, and I'll add them in. Then I'm going to update the index. All right. You can see that YODA has been listed under J for JI. It's created a grouping here where I can put all of the JI under the word JI. I'll go ahead and add another one. This time, I'll add Luke. This time, I'll just go ahead and press. I'll scroll down to wherever Luke is. There is. I'll right click, find in document, I'll add all of these. Just so you know, you can also edit this later on. I'll just right click on Luke, I'll edit topic, and now I can add his parent to the JI. If you want to, you can do that later on as well. I'll press k, and that's automatically updated, which is great. Just so you know, you can also add the parent topics page numbers if you want. I'll just come right up here to where it says JI, I'll right click and find in document. I'll add all of those, and then I'll update this. To see this next tip, I'm first going to add another topic called the Force. I'll press. Then I'll go down to wherever it says the force, there it is at the bottom. I'll right click and find this in the document, and I'll add all of those references, and I'll go ahead and update or index. As you can see here, the force is included under the letter t, t for. But maybe I actually want the force to be under F for force. If you want to, all you need to do to do this is right click on the force, edit topic. Then where it says, S by, type in force. I'll press k. Now you can see that it's listed under the letter F. Just so you know as you're creating the force topic. You could also just change this right up front, sort by the force. That's nice to know, so you don't have to do it after the fact if you don't want to. The next thing I want to show you is that you can actually change the name of a topic, even after you've already added it to the index. To do this, I'm going to use the word si. I'll just scroll down here and right click on his name and edit topic. Then I'm just going to type in Darth because that was his formal name, Darth Sidis. With that typed in, I'll go ahead and press. You can see now that I've changed the name to Darth. It's listed under the letter D. But all of these have remained the same, the page numbers and the referred to Palpatine. Nothing else has changed. Affinity will remember the original word sides that we used. You can go ahead and change how this word appears here without changing those references. As another example, I'm going to make another topic for Kobe, and I'll go ahead and make the parent the Jedi. Then I'll press ok. I'll go ahead and find Kobe. There he is right above Luke, I'll right click, I'll find in document. I'll select all of those, and then click done, and let's refresh. Here you can see Kobi. Canbe is on quite a few different page numbers. However, in this document, he's also sometimes referred to as OB one, which is his first name. His full name is OB one Kobe. Maybe I want to include all of the OB one instances as well. Well, to do that. All I need to do is right click on Kobe, edit topic, and then change his name to OB one. I'll press k. You can see his name has changed and it's kept all of the Cobi references. But if I want to add the OB one references, all I need to do is go down to where it says OB one, right click, find in document, and now affinity is finding all of the OB ones in the document. If I add all of these, and then update. You can see that it's added all of the page numbers. Right now it's including all of the Kobe and OB one references, which is super nice. For this next part, I'm just going to scooch on over here to page 14 so that I can show you that all of the words that we've been adding to the index have a little flag next to them. Now, these flags are just an affinity. When you export your document, they won't be there anymore. But what this is doing is it's telling affinity, Hey, Luke is on page 14. As you come over here, you can see that Luke is on page 14. We can manually add these flags in. For example, maybe I want to add a flag to the word emperor. Now, the emperor is Emperor Palpatine, but you can see he doesn't currently have page 14 here because they're using a different word here. But if I wanted to, I could add a flag right here. To do this, click right here. And then we can change the name of the topic. We want this to be Palpatine. You can go ahead and click on that to confirm it. Then I can press k, and a little flag has appeared, linking it to Palpain. Now all we need to do is update our index, and now you can see that page 14 has been added to his references. If you need to hunt down quite a few words manually to add to your index, you might benefit from the find and replace panel. You can get this panel out by clicking on Command or Control F. This panel will appear, and then we can type in any word we want to find. And I will show you all of the instances of that word. You could click to jump to a reference, and then add a little flag to the word if you want to from here. I'll go ahead and close out of this though. Let's go ahead and come right back down to the index. I just have one last tip to share with you. We can use the index panels trash can to delete any of the topics or any of the individual markers of that word. To show you this, I'll go ahead and just delete OB one. And you can see he no longer appears there. Or I could delete page three for Yoda, and you could see that now that number no longer appears. I'll undo that with command or control Z. But as you can see, it's super easy to delete entire words or instances of words. Great work, everyone. I know that was a lot to cover. I'm just going to add a few more words to this index, and then I'll meet you in the next video. 27. Stylizing an Index: This video, we'll learn how to stylize and index. For your convenience, I've added this document to the exercise files so that you don't need to go through and index all of these words if you don't want to. The index like everything else, uses styles. You can see this as I click through these letters here. If I click next to the main letter, you can see that this is using the style index section heading. As I go down a level, this is Index entry one, and as I go to the last level, this is index entry two. I want to stylize all of these, but to start, let's go ahead and press Command or Control A to select all of the text. Then we can edit it all at the same time. To start, I'm going to change the font two times New Roman. I'll also increase the font size. Then I'll go ahead and update these styles. I need to do this individually, so I'll just start here and update, level one, update, and level two up date. Now that these are all updated, I think I want to individually change them a little bit, starting with the main letter here. I'm going to make this a larger font, and I'm going to bold it. I'll update that. Now you can see, I think this just looks a lot better to highlight the letter in each of these sections. This looks really nice. The next thing I want to work on is the separator, which is the space between the word and the numbers. You can actually see this right over here. Right now, it looks like we don't have anything in this spot, but that's actually a lie. There is something here. There are two spaces. If I use my arrow keys, I can click over once and twice. You can actually see this in the document as well. Once, twice. Those spaces are acting as a separator right now, but I actually want to remove those. I'll just press delete on my keyboard twice. Instead, I'm going to click on this drop down and add a tab. The reason why I want to add a tab is because I want to put a dot dot dot between the word and the numbers. Similar to how we have a dot dot dot and table of contents. To do that, I'm going to go ahead and highlight the JEDI line. Then I'll add a tabtop. Let's increase the spacing 24. Then let's add the dot dot dot. I want these tab stops to be aligned to the right side, so they all line up right here. I'm going to change the alignment like this. You can see that's not quite right. We need a little bit more spacing than 4 ". Let's go ahead and use the text frame ruler to see this. You can see we're lined up to the four right now, but I want to go ahead and bring this over. I'll go ahead and line it up to that edge. This is 6.5 ", and I think that looks really nice. I'll go ahead and update the text style. Now you can see that every single text entry that is index entry one has been updated, but we also have the second level right here, Index entry two that we'll also need to update. Let's go ahead and add another tabtop. I'll go ahead and make this 16.5 as well. I'll make sure that it's right aligned. I'll add the dot dot dot. I knew it was 6.5 because that's what this one was, and that looks really nice. I'll go ahead and update that. We don't need the text frame ruler anymore, so I'll go ahead and get rid of that. With all that stylizing done, let's go ahead and auto flow this. As you can see, this looks like it's the last page, but we actually have a few more entries. I'm just going to press on shift and then I'll click this arrow. We actually had two more pages of entries, so it's a good thing we did that. Just as one last tip here for the index. If you want to include the index and your table of contents at the beginning of your document, all you would need to do is give this word index a style, and it really could be any style. Then just make sure you add that style to your table of contents. All right, great job on this chapter. We're done. Now, you know all about adding references to your documents. In the next chapter, we're going to take a look at tables. 28. Tables: This chapter we'll be learning all about tables. Tables are just like what you see when you're working in an Excel file. But in this chapter, I'm going to show you how to add your own style to those tables. Let's get started. 29. Table Tool: This video, we'll learn how to use the table tool. I'll be working inside of this square blank document, which you can open up from the exercise files to make a table, we need to use the table tool, which you can find right over here. Go ahead and click on that. Then all you need to do is click and drag to make a table. The more you drag outward, the more rows and columns you're adding. I'll go ahead and release my mouse and show you that once you've released, you can use these outer knobs here to grow and shrink the sizes of all of these little cells, and you can use this outer floating knob. If you want to keep everything proportional and resize it like that. Even after you've already created your table like this, you can still adjust the number of rows and columns. By using these arrow buttons right here. I'm just going to drag this to remove a few cells. Let's go ahead and have four rows here, and I'll drag this one over and create three columns. With that done, I'll go ahead and zoom in here. We can go ahead and type in all of these cells. Now for this little example, I'm going to have a few different types of meals with the time that it takes to prepare them and the cost to prepare them. I'm just going to quickly type in a little bit of information here, starting with the name of meal. To quickly jump to the next cell, you can press tab on your keyboard, and then you can continue to type. I'll press tab again and this time we'll put cost. Then we can push tab again and it will jump you to the next line. I'm going to quickly fill in the rest of these cells. Now that I've inputted all of that information, it's time to stylize our text. If you notice here, our text is currently using a textile called table body. We can go ahead and edit the text and then update the textile. I'll just highlight name of meal. Then we can go ahead and center the text. I'll also center it vertically. Then I'll go ahead and update the font. Let's do Ts New Roman. Then I can go ahead and update this. But now I think I just want to update the top row here. To do that, I'll quickly just highlight all of these cells and I'll bold them and increase their size. Now I think I want to make this table quite a bit larger, so I'll just do that now. Now, wait a second. How come only name of M is centered vertically? All of the other ones aren't. Well, unfortunately, centering vertically isn't included in textiles. Instead, I just need to select all of these cells and then center them vertically. Now in this particular table, it probably would have been easier if I hadn't even bothered using textiles because I could have just selected all of the cells and edited them at the same time. But textiles can be useful when working on tables, which we'll see later on in the table formats lesson. But for now, I just wanted to use textiles so you could see this limitation that you can't do vertical positioning. With the text all styled nicely, it's time to start changing up some colors. I want to make this cost column green. To do that, let's go ahead and select this entire column. Then over here in the color panel, we can go ahead and update the fill color. I'll choose a nice dark green color. That changed the fill of the cells. But how do we change the text color now? Once I start selecting multiple cells, it will automatically assume that we want to change the fill of the entire cell. Instead, we can just highlight the text one at a time and then change the fill of that text. But that would take a long time. Here's another way to do it. Go ahead and highlight the entire column. Then up here, go to this first fill color. Over here, we have the cell color, but this one is actually the font color. I know it looks green right now. That's not what it's supposed to look like. Go ahead and click on that and turn it white. Now you can see the text is updated to white. I'm not sure why these colors don't match, but that's a very quick way you can adjust the color of the text. The next thing I want to do is I want to work with the strokes of each cell. We have these black lines that are quite thin. Let's see if we can adjust how they look. Go ahead and select all of the cells, and then come over here to the stroke panel and adjust the width. Right now, the stroke panel is only affecting the very outer stroke. I'm going to go ahead and undo that with command or control of z. Now I want to show you how you can adjust the strokes of different parts of this table. Right up here in the context toolbar, we have a stroke area. You can see right now that the outside of our table is currently highlighted. But if I click in this drop down, we can actually change which part of the stroke is being affected. For example, if I click on all and then change the width. Now you can see the entire table is being affected, but I'll go ahead and undo that. Now that you can see a little bit better about what we're working with in this stroke menu up here. I want to quickly show you how I usually like to style my tables. The first thing I like to do is have it set to all, and then come over here to the color panel, choose the stroke, and then choose no fill. Right now, we have zero lines. There's nothing going on. Now we can go into each of these different categories and add a specific stroke that we want. For example, I want to add a stroke in between each column. I'm going to highlight all of the cells again. Then I'll go to the stroke selection area, and I'm going to choose vertical with that selected. I'll go ahead and make this stroke black. There's a thin black stroke on each of those columns, which is perfect. Then I think I also want to stroke going around the outside border of the table. To do that, I'll select all of these. I'll go up here. This time, I'm going to select the outside, and I'll make the stroke black. Now you can see this is a little bit different from what we had before. There's no lines going across the rows. There's only lines highlighting each of the columns. I think this actually looks really nice. But the next thing I want to do is I want to add a title on top of this table. I'm going to click into our table. Then I'm going to come over here and hover over the number one. Then I'm going to add a row by clicking on this arrow and then pressing on Insert row. Now you can see I've inserted a row right above here, and this is where we can put the title of our table. I want to select all of these cells so that I can merge them together. I could click and drag to select all of them, or I could just click on the number one to select the entire row. Then I'll go ahead and right click on these cells and then click merge cells. All right now I have all the space to type. I'll go ahead and start typing. Let's call this meal planning, information. I'll go ahead and select this text and we can choose a new font if we want to. Let's see what we got here. Maybe American typewriter looks nice. I'll go ahead and make this font a little bit larger. Then I think I want this row to be bigger. I'm actually going to hover my cursor right here between rows one and two. Then I'm going to drag downward to give row one a little bit more space. This is what we're looking like right now. I think I want to remove the stroke from this title. I'm going to again click on one to select this whole row. Then I'll come over to the color panel and say, no stroke. You can see that remove the stroke around the title, but now we're missing the stroke on top of this first area right here. To add that back in, I'll just select the second row here. Then up in the context toolbar, I'll change this to Top stroke, and I'll make this black. We're really starting to get somewhere. I think to make the title area stand out a little better, I want to change its background color. I'll go ahead and click on Row one. Let's go ahead and select the fill and make this a nice light blue color. All right. I think this is looking pretty nice, but I'm noticing that time to prepare looks a little bit squishy right here, and I want to make this column wider. To do that, I'm going to cover my cursor between B and C. Then I can go ahead and click and drag. Now, this is making that column wider, but it's making the cost column smaller. I'll just press command or control Z to undo that. To make Column two wider without shrinking down column C. All you need to do is hold down shift while you click and drag. Now you can see it's making it wider without affecting the cost column. I just have one last tip for you. You need to have the table tool out in order to work on your table. If you have the move tool out, you can move the table around, but you won't be able to click inside of this to edit it. You either need to have the table tool out or you can double click to enter the table tool mode again. But that's just something to keep in mind if you ever want to come back in here and adjust anything. Great job on this video. I know that was a lot to take in. But now you know the basics of how to add tables to your document. Now that you know how to do that, in the next video, we're going to take a look at importing tables. 30. Importing Data for Tables: This video, I want to show you how to import a table that you've already made in a different program. For demonstration purposes, I just opened the blank document that we used in the last video. When you're importing a table into affinity publisher, it's actually pretty easy. All you need to do is go to file place, select your file, press open, and then click and drag. Affinity will do its best to maintain any of the formatting that you made in your original table. For example, here we have some color formatting. Once you've inserted your table, you can continue to edit it, though. Just double click to bring up the table tool, then select all of the cells, and you can adjust this however you'd like. So this was pretty easy, right. Well, unfortunately, this only works this seamlessly. If you're using an Excel file. If you're working in a different program like Google Sheets or Apple numbers, you'll need to convert your file into an Excel file in order for it to work this easily. But it's actually pretty easy to do that. If you're working in Google Sheets, for example, to turn this into an Excel file, all you need to do is go to File, download Microsoft Excel. Then once your back in Affinity Publisher, just click on File Place, and it will be as simple as what we just did. This also works if you're in Apple numbers. Just go up to file, export to Excel. In addition to turning it into an Excel file, another very easy way you can import your information is to simply highlight all of the cells you'd like to copy. Then press command or Control C to copy them. Then you can come back into publisher and I'll just delete this table here. You can create a table. It doesn't matter what size it is. Then go ahead and click into this table and press command or Control V. Now, as you can see, that didn't work as expected, and that's because we only had one cell selected. I'll just undo that with command or Control Z. Instead, make sure you have more than one cell selected and then press command or Control V. While it didn't keep the formatting with the colors and everything else. It did insert each of the words into one single cell, which could be pretty helpful. If you just want to quickly bring over some information. This is especially helpful if sometimes you might just want to include one row of information and bring it over. Just as a quick tip, you can do this copy and pasting method with Excel and with Google Sheets, if you'd like to. Now that you know how to import data. In the next video, we're going to learn some advanced tricks for formatting tables. 31. Creative Tables: In this video, we're going to use tables to create a lunch menu. This is a great way to show you that tables can be used for more than just boring numbers and dates. They can also be used as a way to space things out in stylish ways. To start off, I've created a document here that's 8.5 by 11. My plan is to have a little bit of a picture over here and then to have the lunch menu items on this side. To start, let's grab the rectangle picture frame tool, and I'm just going to click and drag out a rectangle like that. Then I'll click on Replace image. I'll go ahead and grab this one called Creative tables. I'll open that up. Feel free to adjust this however you'd like. I'm just going to zoom this in and move it up a little bit. This is going to be a nice backdrop to the word menu that I'm going to type on top of this. To create this text, I'm going to drag out a long skinny rectangle using the frame text tool. Then I'm just going to type in the word menu. I'll grab the move tool. Let's go ahead and make this text white. Let's make it quite a bit larger. I think I also want to bold it. Then I'll go ahead and center this horizontally and vertically. I'll also center it right here. I think I want to space out these letters a little bit more. Let's go over to the paragraph panel. I'm going to increase this leading to 120. I think that's a really nice start. Now let's move over here to the other side, and I'm going to grab the frame text tool again. I'm just going to type right here at the top lunch menu. I'll grab the move tool so we can make this text black, and I'll also shrink the size down. Again, I want to center this horizontally and vertically. It looks like it remembered to center it vertically, which is nice. With that I'll set up. Let's go ahead and make the table next. I'll grab the table tool and I'll click and drag out a table. For this table, I want there to be nine rows and three columns. Then I'm just going to make it taller. And using the move tool, I'll go ahead and center this. Now that we have our table created, I'm going to begin adding a few things into this table. To start, I'm going to add a few item names. We have Zucchini chips. We also have stuffed mushrooms. We have garlic knots, Last, we have broccoli, cheese tarts. I'll go ahead and make this a little bit longer by hovering between the A and B and bringing it out. Then I'm just going to put in a few prices here. Feel free to make up whatever price you want. Okay. You might have noticed that I left a space in between each of these items. That's because the next thing I want to do is I want to add a little bit of a description for each of these items. Feel free to just make something up here. We want a long block of text. I'll go ahead and start typing that out. I'm just going to space this out even more, so I'll just drag this out like that. With that all typed out, let's go ahead and stylize this text. First, I'm going to select all of the menu prices by clicking on C. Then I'm going to bold this and I'll also increase the size. I also want this to be that looks good. Next, I want to adjust the menu descriptions. I'm just going to click and drag to select all of these. But then we'll hold in command or control. I'll click on all of the items to remove them from my selection. There we go. Now, I'll go ahead and italicize this and make the font a little bit smaller. Last, let's go ahead and do the menu names. I'll go ahead and click A, and then we'll hold in Command or Control. I'm just going to remove all of the descriptions. Now I can go ahead and bold this. I'll also increase the size. I think I want this to be all capital letters, so I'll go to the character panel and do that. The next thing I want to do is I want to make all of the menu items and their prices, bottom aligned. While holding command or control, I'll select all of those. Then instead of vertically aligning them, I'll bottom align them. Now you can start to see how I'm grouping these. I want the item name and the description to be a bit closer together with a little bit of a space separating each of the items. This is really starting to look good. The next thing I think I want to do is I'm going to create a title in this first row here. To do that, I'm going to click on row one, I'll right click and merge these cells, then I'm just going to type in appetizers. Then I'll just select this text. Let's go ahead and make this a bit larger. I'll also bold it and make it all capital letters. I also want to center this vertically. But I think I actually want it to be left aligned like that. This is looking really good. But now it's time to work on some of these strokes. I really don't want much of this table to show that it's a table. What I'm first going to do is let's select all of the cells. Let's go to up here where it says stroke. I'm going to click on all. Then I'm going to select the stroke color and put no fill. As you can see, now we have zero strokes left behind. But there is one stroke that I want and that's around the word appetizers. I'm going to select that row. And then with all strokes selected, I'll make that black. Now you can see what that looks like, but I don't really like this stroke right here. Let's select this one more time. Let's select the left stroke and then click on no fill. Now you can see, we have a nice little box around appetizers. I think this looks really nice. I just have a few last tips for you to space out the cells better. First, because this is still a table, we can adjust how everything is spaced out by clicking and dragging like that. I'm going to click and drag this outward until broccoli cheese tarts is all on one line, and I'll also move the prices over. A. I think I actually want to select all of these price cells and I want them to be right aligned. I'll go ahead and change that right here. I think that looks a little better having it line up there. Another thing we can do is we can increase the spacing between each of these menu items. This is actually pretty easy. All we need to do is select all of the menu item rows by holding down command or control and clicking. Then we can click and drag between them to space them out a little bit more. Right now I'm just clicking and dragging between the seven and the eight, and all of them are adjusting at the same time, which is pretty nice. Oh, that spacing already looks better. But you know what? We can actually do a little bit more customized spacing, and to do this, I'm going to get out the table panel. You can select the table panel right here. Or if it's not showing up here, just click on this button, and it should be right in here. Go ahead and open up the table panel. Using this table panel, we can actually do quite a few things that we could do in the context toolbar. For example, we can change the frames fill and stroke. We can change which part of the stroke we're affecting. I'll just close those up. The thing I want to focus on right now is the cell area using the cell area, we can create in dense in our text. For example, maybe you want all of the descriptions to be indented. If you want that, go ahead and select all of those. Then come here to where it says insets, and you can change the left inset. Before you change this, make sure that this is unlocked. Then you can go ahead and type in 0.3 to change this. Now you can see that we've created a little bit of an indent. Now, I don't really like how that looks, so I'm going to press command or Control Z to undo that. But I just wanted to show you that it's possible to add a little bit of indenting like that. Now, one thing that I do think I want indented a little bit are these prices. I'll select all of those and with this still unlocked, I'm going to increase the right indent, and I'm just going to increase this to 0.075. Now you can see that it's just slightly indented. It's just talking a little bit underneath this line. I do think that looks a little better, so I'll leave it at that. One last thing I want to show you is how to create more space between your menu item and the description. To do this, first, I'm going to select all of the menu items. I'll just click and drag to select all of these. Then I'll hold down command or control to remove the description. With the menu items selected, we can go here where it says insets and we can change the bottom inset. I'm just going to change this to 0.04. Now you can see we have a little bit more space right here. You could really increase if you want a lot more space, but I still want them to look snug and close together. All right, and with that, Wow. We've created a beautiful table, that was a lot of work, but I think this looks really good. Now that everything is set up, we can easily repeat this table for the next part of the menu. I'm going to grab the move tool, I'll select the table. Then I'm going to press command or Control J. This has duplicated the table. Now while holding shift, I can drag this down here to move it in a straight line. Now, you can easily fill in new items. In addition to changing this table by changing the text. We can also increase the size of this table. I'll just add two more rows down here. Then I'll go ahead and copy the broccoli and cheese tarts area. I'll copy the whole te, the price, and the description. I'll press command or control C to copy it. Then coming down here, I'll highlight this and then I'll press command or control the Because we copy and pasted this, it's now formatted properly, so we can easily type whatever we want right in here and it'll still look the same. Just as easily, we can also delete rows. I'll go ahead and select the garlic knots row by holding command or control and selecting both of those. Then I'll right click on the number six and delete these rows. As one final tip, I just want to remind you about the assets panel because you can use the assets panel to store tables. I'll go to the assets panel and open it up. I'll move it over here. Then I'll go ahead and select one of these tables with the move tool selected. Let's go ahead and just save it into the trees category. I'll click on the Hamburger menu and add from selection. Now you can see we have this menu here that we can click and drag to add to our document at any time. It'll be formatted properly, and I think that's just so nice that we can save our work in this way. Great work. I hope you really enjoyed this video, and I hope it helps you to open your eyes to the possibilities of what you can do with tables. In the next video, we're going to learn how to create table styles, which you can use to quickly apply color and formatting to any table. 32. Table Formats Panel: This video, we'll learn how to use the table format panel. This panel allows you to create preset styles for tables. It's like making textiles, but for tables. This is a very powerful feature of affinity, but like most powerful features, it can be a little bit tricky. We'll start off with some very simple examples and then work our way up to more advanced techniques. First, we need to get out the table formats panel. To get this panel out, just select your table, and then come up to the context toolbar, click on this arrow, and then click on this icon. It'll look like a table, but with a little gear icon at the top right. Click on that, and now we have our table formats panel. I'll just tuck this right over here next to the Layers panel. Another way to get this out is just like with all our other panels, go to Window. Table table format. Now that we have this panel out, we can go ahead and start customizing this table, and then we can save that formatting. Let's go ahead and double click on this table to enter the table tool mode. Then I'm going to click on this first row and I'll give it a color. Then I'll click on the last row and I'll give it a color. Make sure you still have your table selected and then go up to the table format panel and click on the Hamburger menu. Then click on Add format from selection. Now, you can see we have this little thumbnail that looks just like our table. We've saved the table format and now we can go to the next page. Click on the table. Then apply this table format. As you can see this transferred over beautifully. The fun part of table format is once you have them set up like this, you can add as many rows or columns as you want, and the formatting will follow it. Let's see another example by moving on to page three. This one, I'm going to create a double header and a double footer. In the last one, this is the header, and this is the footer. But we're going to double that up. I'll select the first row, and let's make this a dark blue color. In the next row, I'll make it a light blue. Then at the very bottom, let's go ahead and make this a dark orange color. In the next row, we'll make this a lighter orange color. With that table still selected, I'm going to click on the Hamburger menu and add format from selection. And now you can see we have that formatting saved. Staying on this page. Let's go ahead and see what happens if I add more rows or columns. Well, that doesn't look very good. Why did that happen? Let's press command or Control Z to go back. What happened is we only based this format off of this table. This table currently has no formats applied to it. This is similar to textiles. You can base a textile off of text, but until you apply that format, it doesn't have all of its special properties. I'm going to click on the format to apply it and now look what happens when I move these rows. The double footer follows us. Now this is working just as expected. Let's move on to table number four. In this example, I want to add another header and footer. But this time, I also want to add alternating rows of color. Let's start on our top row here. I'll make this a nice purple color. Then on our last row, let's make this a golden color. I'm going to select all of the even numbers while holding down command or control on my keyboard. Then I'm going to make all of these a light blue color. Then I'll select all of our other rows. I'll hold command or control to do this. Let's go ahead and make these a light pink color. I'm going to go to the Hamburger menu and add this format from our selection. Then I'll apply the format by clicking on it. Now you can see what happens as I add more rows. The pattern actually continues and our footer stays right at the bottom. Pretty cool. Affinity publisher is pretty smart when it comes to these patterns. Let's move on to table number five. In this example, I want to introduce you to formatting columns. Let's start by just formatting our rows. I'll make this a dark blue color. I'll make this bottom one a dark green color. Then I'm going to create our alternating rows again. I'll hold command or control to select all of those. Let's make this one a yellow color. And let's make the other rows, a light orange color. We have all of our colors there. Now I'm going to select this column without selecting the header or footer, and I'll give it a nice bright red color. With the table still selected, I'll add the format from our selection. Then we can move down to table number six. I'll select the table and apply the format. Then as we add more rows, you can see the pattern continues. As I add more columns, the columns keep this B and C pattern going. This first column just stays the same. Now that we've seen quite a few different examples of table formats. I want to show you what's going on behind the scenes, which will help you to customize your table formats even more. I'm going to click on this Hamburger menu next to our format four here. Then I'll click on Edit Format four. Okay. Take a look at this dialog box. There's quite a lot going on here, but it's actually not as bad as it looks. Let's take a look at what's going on one thing at a time. Right here, you can see we have a model of our table format. If I click into these cells, you can see this format highlight over here. As I click into each of these, you can see it highlights the different colors. If I come over here, these are all the settings associated with that color format. In format, format five, we have a green fill. Format four, we have the red fill and so on. But what if we want to change something about our table? Well, all you need to do is click on that cell. This has format five applied to it, and as I change the fill color. You can see that everything that had that green format five applied has now been updated to this purple color. If I press okay, you can see that the table that I had this formatting applied to has now updated to the purple color. But the previous table where I didn't update it to this formatting still has the green bar there. Let's continue. I'm just going to click on the Hamburger menu and edit format four again. I want you to see that all of these different options we have over here are just the same thing that we've already been working with. You can see we have the different strokes that we can change right here. We have indentation, and we even have vertical positioning right here. Now, previously, we saw that when you center the text vertically, it doesn't update in textiles. But if you do it from here, it actually does update, but we'll see that in a little bit. The next thing I want to show you is actually a small mistake that you might run into as you try editing your table format. Right now, I have a purple cell selected. We can see all of its settings over here. But let's say I wanted to change the red cell. If I click here, oh, I just updated this cell down here that I had selected to this red formatting. I'm going to click on that and change it back to purple. If you ever want to update one of these cells, make sure you click directly on its cell. If you click on this, it will just change whatever you have selected. Make sure you select it from over here, and then you can change anything you want about that cell. Now, there's one last thing that I want to point out to you, and that's what these little triangles are. You can think of these little triangles as a spiky wall that keeps the colors in. Right here, we have a spiky wall, keeping this purple color in. It won't rise above this. It will just stay at the one row right here. We have another spiky wall right here, keeping the blue color in, and another one right here, keeping the red color in. Let's say, I want to add another row down here. To add another row, just click on this plus button right here, and you can see we have a nice blank row added here. I'm going to select both of these cells by clicking and dragging on them. Then I'm going to create a new format by clicking the plus button. Using this format, we can change the fill to whatever we want. That looks pretty good, but you'll notice that these triangles now are starting on this green area, meaning the purple is no longer included in our footer. We can easily change this though if I click on this up arrow right here and now we'll have a double footer. As I press k, you can see that with this double footer, as we add more rows, they'll both move together. Let's move down to page seven. For this final part of the video, I want to bring together everything we've learned, and I want to create a table format that you could actually use in the real world. Go ahead and click into here. For this first top area, we have the title of our table. I'm going to make this a dark blue color. In the next row, Let's go ahead and this a light blue color. Then I want alternating colors for each of these products. I'm going to select all of the even numbers and while holding command or control, I'll select them all. Let's go ahead and make this a nice light gray color. I think these colors look really nice. Now we can go ahead and form at the text. I'm going to select all of these lower areas right here. Let's go ahead and shrink the size down to size ten. Then I'm going to make sure that it's centered and I'll center vertically as well. Then I'm going to update this table body textile. You can see that everything changed, even these, but I actually want to give these a different textile, so they look different. I'm going to click on road two. Then I'll go into our textiles and apply heading two to it. I like how heading two looks, but I want to make sure that it's all centered. There we go, and then I'll update this text style. Last, let's go ahead and update this text right here. I'm going to apply heading one. Then with the text highlighted, I'm just going to make sure we have white coloring and that it's centered both vertically and horizontally. With the entire row selected, I'm going to right click and merge these cells. Now, I think that looks pretty good. I'll update heading one right there. I think this table looks really nice. I'm going to have my cursor blinking inside of it. Then I'll go back to the table formats and we can add this format from our selection. There we go. We have our little replica down there. Let's go ahead and move to the next page and apply this format. That looks really nice. We just need to merge these cells together up here. I'll click on that row. I'll right click and merge those cells. That looks so good. We were very easily able to bring all of that over. However, I want to show you a small problem that you could run into. I'm going to move down to our last table and I'll apply this format again. How come our textiles weren't applied? If you click in here, you can see there's no heading one or heading two. In fact, when you come up here, it actually says no style. Why is that? Well, what happened was all of this was copied from an Excel file, so it never actually received a textile. In order to fix this, I'm first going to press command or Control Z. Until this looks normal again. Then I'm going to select all of the cells in this table. I'm going to apply the table body textile to it. Now that that's been applied, as I click on this table format, you can see it works just fine. Whenever you have a table, make sure it always has table body applied to it. If you want to keep all of these textiles. Now all we need to do is merge all of these cells together and this looks perfect. As one final tip, I need to mention that all of these table formats are actually document based, meaning that every document you open will have its own table formats. But if you'd like to save the table formats that you've made, it's super easy. Just go to the Hamburger menu and then click on Save formats as default. Now every new document you make will have these table formats. But you can always remove any table formats that you've made. All you need to do is click on the Hamburger menu and then press delete. Then you can save this as a new default. But one thing you also need to remember is that textiles are also document based. You'll need to save your textiles as well as a default if you have any textiles involved in your table formatting. Remember that to save your textiles as a new default, just go to the Hamburger menu and then click on Save Stiles as default. But as a tip to that tip, it probably would have been better if I set up all new textiles for these headings. That way, as I save a new default, I can keep my original heading one and heading two looking just as normal. If I save these current textiles right now, every time I apply heading one to a new document, it will have a white fill, which won't work very well. That's just something to keep in mind. Maybe you want to create a table heading one and a table heading two if you're going to do something like this. All right. Nice job, everyone. I know that was a super long video, but I hope now you can understand how powerful table formatting can really be an affinity publisher. 33. Data Merge: Great job. You're almost done with the course. But before we finish, I just have one more thing I want to show you and that's data merge. Data Merge is a great tool that can really help you to speed up repetitive tasks. But instead of just blabbing on about what data merges, I want to show you an example of when you would want to use it. Let's say you're writing a college acceptance letter to 200 people, and you want this letter to have each student's name personalized on it. Let's also say that you have a list of everyone's names. But even with this list, it will still be time consuming to keep changing the name on each letter. In this example, you could save yourself a lot of time by using data merge. Data merge will duplicate the letter 200 times, but we'll fill in the blank with each student's name. With just the click of a few buttons, Affinity will create 200 individually addressed letters for you. And it gets even better than that. With data merge, you can have multiple blanks for affinity to fill in. With the click of a few buttons, Affinity will fill in the student's name and the program they got accepted to. With 200 letters to send, this will save us a lot of time. Data merge is really useful. But before you can use Data merge, you have to have your data prepared. In the next video, I'm going to show you how to prepare your data and then we'll perform a data merge in the next videos. Let's get started. 34. Preparing the Data: In this video, we'll learn how to prepare your data for a data merge. The easiest way to prepare your data is to use Excel or a similar program like Apple numbers or Google Sheets. As an example, we'll take a look at this Excel file, which was included in the course Exercise files. Right now, there's nothing you need to do to this data. I've already set everything up for you. But before we use this data in a data merge, I wanted to show you how it's organized just so that you could better understand what's going on. I'll also show you how to set up your own data for a data merge so that you'll know what to do when you're working on your own projects outside of the course. But first, let's see how this file is organized. At the top of the file, you can see some words that are marked in red. Whenever you're preparing data for a data merge, the first thing you should do is label your columns. In this example, I've made each of my column labels red just that you can see them more easily. The next thing you'll do is add your data to each column. In this exercise file, I've already added 300 rows of data to each column using fake personal information. Data Merge can handle any words or numbers that you put in your data. You can even add photos to your data, but that's a little bit trickier. We'll learn how to do that later on. After you've set up your data, all you need to do is save the Excel file, and then you can use that Excel file for Data Merge and Affinity Publisher. In fact, publishers Data Merge can use Excel files, CSV files, TSV, JSON, or even plain text files. But since Excel files are what you'll use most of the time. That's what we'll be using in this course. But you may have noticed this list doesn't include apple numbers or Google sheets. If you don't own Excel, how can you prepare your data for a data merge? Fortunately, for us, both of these other programs can export your data as an Excel file. If you want to use apple numbers to prepare your data, you'll start off the same way we did in Excel. You'll label your columns and then add your data to each column. But then to save your data as an Excel file, you'll come up to file Export two Excel. That will save your document as an Excel file, which Affinity will be able to use in a data merge. In Google Sheets, you'll follow a very similar process. Just enter your data and then go to file download Microsoft Excel. Once your data is saved as an Excel file, then you can import that data into Affinity Publisher. We're going to learn how to do that in the next video using the Excel file that we've been looking at, which was included with the course's Exercise files. 35. Importing the Data: This video, we'll learn how to bring in the data from our Excel file into Affinity Publisher. To bring our data into this file, we first need to open the fields panel, which we can get to by going to Window, references, fields. I'm going to go ahead and place this over here next to the pages panel. Then I'll make sure that all of these sections are closed up just to start. This is actually the same panel that we used earlier in the course in the section references lesson. This is where we'll access the data from our Excel file. But first, we need to import our data. Afinity actually has a special window for importing data. Just come up to Window, and then go down to it says Data Merge Manager. Using this window, go ahead and click right here. Now we can go ahead and select our Excel file. This is the exact same Excel file that I showed you in the last video, and it's been included with the courses Exercise files. Now that we've imported that Excel file. You can see over here in the field panel that the Data merge section has now opened up, and we can see all of this information that's included in the Excel file. Right now, this information is showing up by saying e mail and then e mail again. But it might be more useful to you if you could actually see a preview of what all of this information should look like. If you want to do that, all you need to do is come over here and check on preview with record. Now you can see we have some example information in here of what all of this information is going to look like. Now, we'll come back to the data merge manager later on, but I'm going to close it for now. And now that we've imported this data, we can use it to perform a data merge, which we'll learn how to do in the next video. So go ahead and keep this document open, and I'll meet you in the next on. 36. Super Simple Data Merge: This video, we'll do a super simple data merge. We're going to continue working in this document that we started in the last video, where we imported our Excel file. Now, the first thing we need to do is add a text frame to our document so that we can put our data merge into it. I'll click on the Frame Text tool, and I'm going to go ahead and click this from margin to margin. By the way, I have 1 " margins on my document here. If you didn't add that to your document, you can just go to the Move tool, click outside of your document, and then you can change your margins by going to document setup, and from here, you should be able to add those margins. I have my text frame in place. The next thing I want to do is I'm going to click in the text frame, and I'm just going to write down a spot for someone's name, someone's e mail, and someone's age. Now, I'm going to go ahead and add in the first and last name. To do this, all you need to do is double click on the first name information right here and then double click on the last name information. Then just add in the spaces that you need to make this look normal. You can see we are very easily able to insert that information. I'm going to go to e mail next. I'll just add a space and then double click on the email and in the Age, I'll add a space and click on the Age. All right, I think I want this text to be a little bit larger, so I'm just going to highlight this and let's go ahead and make it larger. Then I'm going to reopen the Data merge manager by going to Window, Data Merge Manager. I just wanted to remind you right here that all of this information right here is just a preview. What we've actually entered is code. I'm going to uncheck preview with record. Now you can see this code right here. If we look into our document, it also shows up as code as well. With all of that set up, now we can go ahead and do our data merge for real. All we need to do to do that is come right down here and click on Generate. I'll go ahead and close out of this. You can see that affinity has actually made a separate document. This was where we started. Now we have this other document with our data merging here. As I scroll through here, you can see we have all of this information. We have first last name, e mail and age of all of these people on separate pages. You can see that each of these pages has a unique name, e mail and age, which goes with their corresponding row in the Excel file. I'm going to go to the pages panel to show you that we actually have so many pages here. In fact, because there were 300 rows in our Excel file, we actually have 300 pages of information that Affinity was able to create for us. Now, after you've done a data merge, keep in mind that this new document is just a regular old document with regular layers. You could come in here and change anything you want. It's pretty easy to do that. Now, to finish off this video, I just wanted to mention why Affinity has made a new document for our data merge. Instead of just using this original document that we created? The reason why Affinity did this is to preserve the original documents in case we ever need to generate another data merge. As an example, let's say that a week has gone by and I realize I made a big mistake. I had accidentally entered everyone's ages incorrectly in my Excel file. But at this point, I can't really change my data merges output file since it's just a regular file now. How can I fix my mistake? Well, all I would need to do is update my Excel file, and then open back up my data merge template from here. I just need to generate a new data merge. I'll go back up to Window Data merge Manager. Then I can just press on generate. If you've updated your Excel file, a little pop up should come up here, asking you if you want to use your updated Excel file. Go ahead and clicks to that, and then you can generate this brand new file with all of the updated information. What I wanted you to see here is that because affinity has made this a separate file, we can always go back to this template and perform a new data merge whenever you want. That's very convenient. You now know the basics of a data merge. In the next video, we're going to build on what you've already learned and learn how to add photos to a data merge. Go ahead and close this document and I'll meet you in the next video. 37. Adding Photos to Data Merge: This video, we'll learn how to add photos to a data merge. To do this, we'll first need to add photos to our Excel file. But what does this mean? Do we just copy and paste the photos into Excel? Well, not exactly. Instead, we need to add the location of each photo. To do this, we'll need to add something like this. This tells affinity that on my desktop, there's a folder called animal photos. In that folder, there's a photo called butterfly dot Jpeg. To include my animal photos in affinities data merge, I'll need to add a string of texts like this for each photo. But you might be thinking, this looks a little complicated to write, but don't worry. It's actually a lot easier than you think. First, you just need to go to wherever the photos are stored on your computer. Next, you need to copy the photos path name. To do this on a Mc, just right click on the photo and then hold down Option. While holding Option, you'll get a button that says Copy the file as a path name. Go ahead and copy the path name. Then you just need to come back to Excel and paste that pathway into your document. If you're on a PC, you'll follow a very similar process. Just select the photo, right click on it, and then select Copy as path. Then you can paste the path name into Excel. Copying Path names isn't hard, but since you need to do this for every photo, it might take you a minute or two to do. For those of you who don't own Excel, here's what you can do. If you're on a Mc, just double click on the Excel file that was included in the courses Exercise files, and your MC will automatically open the document in Apple numbers. From there, you can enter the photos Path names just as we did in Excel. When you're done, you can export the document as an Excel file by going to File, Export two, Excel. And if you're on a PC, Google Sheets is your best option. Once you have any Google Sheet open, all you need to do is come to file import, upload, and then select the Excel file. Then import the data and open it. Then you can enter the photos Path names. Once you're finished, you can download the data as an Excel file by going to file, download Microsoft Excel. No matter which method you use, once you have an Excel file with all of the photo path names added, then you're ready to come back into Affinity Publisher. Back in Affinity Publisher. I already have this new blank document open. Let's go ahead and import our data. To do this, I'll just go up to Window. Then let's go to the Data Merge Manager. With this open, go ahead and click on the new button, and then you can go ahead and add this Excel document that we were just working on. Then go ahead and click on Open. With all of that open, I'm just going to check on preview with record. Now you can see a little preview right over here for what we're working with. I'll close this. The next thing we need to do is prepare a spot on our document so that we can input all of this information. I'll just go ahead and add a frame text right here, and I'll do this on the bottom as well. Then I'm going to grab the rectangular picture frame tool, and I'm just going to click and drag to add a picture frame. That's pretty easy. Now I'm just going to click in this text frame right here until you can see the cursor blinking. I'll go ahead and input the common name right up here. Down here, I'll go ahead and use the scientific name. Then in our box right here, I'm going to go ahead and grab the move tool. I'll select the picture frame. Then I'm going to double click on this image. This will insert the image into our picture frame. I'm just going to stylize this text a little bit. I don't want to bother doing anything too fancy. I'm just going to go to the text styles, and let's go ahead and apply heading one to this. Now that we've put in all of that information. I want to show you how you can style the photo frame a little bit. We have two different options. The first option is if all of your photos are the exact same size. Then all you need to do is get out the transform panel by going to window, transform. Then you can come in here and with the picture selected. If all of your photos are in 1920 by ten e, then you can just type that into affinity and it will convert it to inches for you. With the height and width unlocked, I'm just going to type in 1920 pixels. By 1080 pixels. Then I'll press enter on my keyboard. Now those proportions are exactly 1920 by 1080. Now that we've done that, I'll just hold down shift to resize this proportionally to fill up the space. You can go ahead and center that. Now as you put in all of your different images, they'll fit exactly into those proportions of that frame. That's one method, and we're actually going to use this exact method in the next video. But I just want to show you another method. If all of your photos are different sizes, like all of our animal photos are, then another option you have is to select the picture frame. Then click up here where it says properties. Using these properties, you can change how this appears in the photo frame. For example, you can scale to Max fit. I'll go ahead and click on that option. To see this. You can see that we actually have quite a bit more in our picture here. This picture is actually a little bit more of a vertical facing picture. But when you have scale to max fit turned on, this will just fill the space, even if it doesn't proportionally work, you're not going to have any white bars or spaces like that. The next option is scale to minimum fit, which means it will try to include the entire picture, and you might have some blank space on each side, but at least your entire picture will be in it. Also have stretch to fit, which doesn't look very nice, so I wouldn't suggest using that. I would just go with one of the first two options. I think scale to Max fit is what I mostly like to use, just so all the pictures look proportional and similar in size and shape. With all of that setup, now we can go ahead and generate our data merge. Let's go to the Window data merge manager. Then I'll go ahead and click on Generate I'll close out of this dialog box. Now you can see we've done our data merge. All of the pictures and their different names are all inputed right in here. Now, since this is just a regular file, we could go in here and adjust how all of these pictures are positioned to make them look a little nicer. You can adjust them, you can Zoom them in and out. You can do whatever you need to do to make this look a little bit nicer. With that, you've successfully completed your first data merge using images. Ts pretty exciting. Now, this has quite a few different use cases, and I'm going to show you a really fun one as we learn how to make playing cards in the next video. So get excited for that and I'll meet you there. 38. Playing Cards with Data Merge: This video, we'll practice data merge by making a custom set of playing cards. To do this, we'll use data merge to add the card names, descriptions, artwork, and the symbol for their element type. For this to work, I've included an Excel file in the courses Exercise files. This Excel file has columns for the card names, descriptions, elements, and artwork. In the file, I've already added the card names and descriptions for you. I've also labeled which photos need to go where. But since every computer has its own unique pathway, you'll need to add your computer's pathway to each photo. To add the element photos, come to this chapter's Exercise files and then open the elements folder. Then copy the air photos pathway. Then in Excel, past that pathway for all of the cards that have the air element, since all of these cards will use the same photo. Then you can repeat this process for the other three elements. For the final column, you'll do pretty much the same thing. Go into the artwork folder, and from there, copy the pathway of the first photo. Then come back to Excel and past the pathway. But now here's a little trick you can do to speed things up. You can click and drag on Excel's fill handle at the bottom right of the cell to copy this information down to the next cells. Then you just need to change the name of the photo in each cell since that's the only thing that's changing. I named each photo chronologically. All you need to do is change the end of the pathway name to say two, three, four, five, et cetera. Other than the name of each photo, the rest of the path names are exactly the same because all of the photos are stored in the same folder on my computer. After you've added all of the path names, go ahead and save the Excel file and then come back to Affinity Publisher. I've already set up a 2.5 inch by 3.5 inch document right here. That's about the standard size of a playing card. Then I went ahead and added facing pages starting on the left and I just added one page here. Last, I added a eighth of an inch margin going around all of the sides. Then I went ahead and created my new document. Feel free to do the same. Now that we have that all set up, we can go ahead and begin to import the data for our playing cards. To add our data, let's go up to Window and then down to Data merge Manager. I'll press on the plus button down here. Then we can go ahead and import the Excel file that we just added all of those pathways to. Go ahead and open that up. Now you can see we have that document right here along with all of these different elements here, we have the card name, description, element and artwork. That looks great, but let's go ahead and turn on preview with record so that we can have a better preview as we set up our document. Go ahead and close out of the data merge manager. Now we need to prepare a spot to put all of these data points into. To start, let's go ahead and add a place for all of our images. I'm going to grab the circular picture frame tool right here. It holding shift, I'm going to click and drag, and this is going to be a spot where we'll put our elements. With that, I'm going to hold down command or control as I click and drag and move this to the bottom right over here. Then I'm going to add the main artwork. I'm going to use the rectangular picture frame tool and I'll go ahead and click and drag to add that. Then I'm going to use the frame text tool to add a spot for the main title of the card, as well as a little place for the description right underneath the picture. We can adjust where all of these are positioned a little bit later. But for now, let's go ahead and input all of these different fields into their spots. With my cursor blinking in this top area, I'll double click on the card name to add that. Then I'll double click on the description to add that. Then I'm going to get out the move tool and I'll select the top circle right here and add the element, and I'll do the same to the bottom. Now, this element on bottom, I actually want rotated upside down. I'm going to hold down shift as I rotate this to make it upside down like that. And last, let's go ahead and do the main artwork right in the center. This is so cute. I'm really excited about how this is already going. Let's go ahead and make a few adjustments. I think first, let's go ahead and resize the main artwork. As I hover over here. You can see we actually have a little bit of this image that's not included. It's spilling over the edges. For this project, I made all of our images the exact same size. We should be able to include the entire image for all of them. I want to use the transform panel for this method. I'm going to go to Window transform Then with this image still selected, I'm going to adjust the width and the height so that the picture is fully included in this area. Now, to do this, the width of all of these pictures is 2,100 pixels. Go ahead and type that in and then press enter. The height for all of these is 1,400 pixels. Go ahead and press Enter again. As you can see, this has made our image a lot larger, but we can go ahead and change this. I'll hold shift to resize this proportionally. Then I'll make sure it's lined up with the margins, and I'll go ahead and raise this a little bit. Now you can see that the image is perfectly fitting into these dimensions. That looks really good, so I'll close out of the transform panel. Now we can go ahead and move on to changing some of the text. To start off, I'm going to select the card name right up here, and I'm just going to do that by triple clicking. Then I'm going to change the font. Let's use times New Roman, and I'm going to increase the size and bold it. I also want this to be centered vertically. I'm going to do that. Then I'm going to center this entire thing with the logo. You can see as I dragged that. We had a red line appear right there. That looks good. Then I'm going to select all of this text. I'll just triple click again. Then I'm going to change this two times New Roman. I need to make this quite a bit smaller because some of the descriptions for these cards are quite long. I'll just make that nine point font and I'm going to italicize it to make it look fancy. Then I'm going to justify this text to the left. I think that looks really good. We have our prototype for the first playing card. Let's go ahead and generate this. I'll go up to Window, data merge Manager. Then I'm going to click on Generate. I'll close out of this. I'll turn on preview mode. We can see this better and take a look at these adorable playing cards. Because of our data merge, each of our cars has a different element, title, artwork description. They're all unique and they're all really cute. I love how these turned out. Now that you've generated this document, you can edit it however you want. For example, the very last card, the Rainbow dragon, has a very long description here. You can select all of the text by pressing command or Control A, and you can shrink the font down so that you can see all of the text better. That looks better. You can make any other changes that you want at this point. We've seen that you can change an individual card, that's super easy. But what if we want to change all of the cards? Well, in that case, we need to go back to our template file and make adjustments here, and then we can generate a new document with all new playing cards. Let's go ahead and do that. I think this card would look nice if it had a border going around the outside of the margins. To create this border, I'm going to grab the rectangle tool and I'm going to start in the margins and click and drag out a rectangle like that. Then in the color panel, I'm going to say we want no fill and a black stroke. That looks good. Then in this stroke panel, I'm just going to increase the width here. And I'll make sure we have a sharp join, so the corners are sharp and that this is aligned to the outside. I think that looks pretty good. Just for fun, let's go ahead and grab the move tool. I'm going to select the main artwork and while holding shift, I'm going to shrink it down and then make sure it's nice and centered. Now that we've had our fun making these changes. Let's go ahead and go back to Window, Data Morge Manager, and let's generate a new set of playing cards. I'll close out of this. Again, I'll turn on preview mode. Now you can see the changes that we've made. You can make as many changes as you want to the main file and keep generating cards until you find the perfect combination for cards that you like the look of. Once you're finished, you can go ahead and wrap up your work. To do this, you can go ahead and export your work as a PDF and make sure to save this file and the template file. It's important to save your template because this is a totally separate file that you might want to go back to and generate more cards from. With that, we're done with this little project. I hope you enjoyed making these playing cards. There's a lot more use cases for data merge, and we're going to explore another one in the next video as we create address labels with data merge. 39. Address Labels with Data Merge: In this video, we'll learn how to use data merge to create address labels. I'll be working in an 8.5 by 11 inch document with a half inch margin going around the edges. To start off, let's import the data for our address labels. I'll go to Window, Data merge Manager, and then I'll add this document right here. This is the very first document in our exercise files for the chapter. Go ahead and open that up, and then check on preview with record. Next, we need to prepare a place where we're going to add our data fields. I'll grab the text frame tool. I'm just going to start right up here and add a little text frame. Then I'll go ahead and insert our fields. A quick way to do this when you want to add a lot of different fields is just to go through and click on whichever fields you want first and then come back over here and add any spaces or line breaks that you want. I'm going to go ahead and start by just clicking on the last name. Then I'm going to click on the street, the Unit number. The city, the state, and the Zip code. With all of that in place, I'm just going to zoom in over here and we can begin formatting this. What I want is I want all of these address labels to say the whatever the last name is, family. I'll go ahead and add a line break. Then in between the address and the unit number, I'll just add a comma in a space. Then I'll add another line break for the city. I'll add a comma in a space for the state and another space for the zip code. With all of that setup, let's go ahead and apply a textile so that we can easily change the font on all of our labels later on if we want. I'm going to come right over here to textiles and with all of this selected, I'm going to add the body style. Then with that still all selected. I'm going to change the font two times New Roman. Let's go ahead and keep the size at 12. Then I'm going to make sure this is centered both horizontally and vertically. I think this spacing looks a little strange. I'm going to go to the paragraph panel and I'm going to change the letting. I'm just going to type in three. Now you can see everything's a lot more compact. I think that looks better. I'll go ahead and update the body style right up here. Then I'm going to adjust the size of this text frame using the transform panel. For this document, I want there to be 24 different labels. That means it needs to be three across and eight down, and I already did the math for this. Since the page is 8.5 " this way, we have a half inch margin on each side, which means this space right here is 7.5 ". 7.5 divided by three is 2.5 ". I'm going to type this right here, 2.5, then I'll press enter. Now three labels should fit perfectly going across. But for the heights, I also need to do the little math for this. The page height is 11, but minus the half inch on each side, that would be 10 ". I need to do 10/8. Now, if I'm not sure what that equals, it's actually pretty easy. I can just type right in here, 10/8, and Affinity will do the math for us. I'll press enter, and you can see that equals 1.25 ". Now that this frame is set up with just the right dimensions. We can power duplicate this to fill the entire space. Now, if you've never done power duplicate, it's a really cool feature that affinity has that lets you duplicate something, move it, and then duplicate it again and your movement is repeated. It's really cool, so let's go ahead and check this out. I'll go ahead and grab the move tool and then I'll make sure our text box is selected, and then I'll press command or Control J. With that duplicated, I'll hold shift to drag this downward. Then I can just press command or Control J again, you can see it automatically jumps to the right position. I'm just going to continue to do that all the way down the page. Then this is pretty fun. I'm going to select all of these text boxes by clicking and dragging. Then I'll press command or Control J. With that duplicated, I'll just move it over, like that. Let's go ahead and do that one more time. Command or Control J. Now that we have all of our labels, we can go ahead and change the textile if we want to change all of the labels at the same time. I'll go ahead and select this textbox right here. Let's go ahead and just change the font. I'm going to change it to the font called Aerial Narrow. This gives us a little bit more space and makes our text more compact. Then I'll update this and you can see they all update at the same time. I think I also want this to be bolded. Then I'll go ahead and update it. All right. With that done, let's go ahead and do our data merge. I'll come up to the top two window, data merge manager, and then we can go ahead and generate. Our data merge didn't do quite what I wanted it to. In a data merge, affinity assumes you want to keep one accelrose information all throughout one page, and then it will move on to the next accrose information on the next page. Now, this worked out pretty well for our playing cards because I did want to repeat the element logo on the top and bottom of each card. But in this case, I was actually hoping that each label would have a unique name on it. I don't really want a sheet of 24 addresses for each person in Excel. But how can we do that? Well, we'll come back to that in a second. But I just wanted to point out we have another problem. What if I wanted to change how these labels look? Yes, I could change the textile. But what if I wanted to change something more substantial? Well, if I want to change something substantial, I would need to go back to the template file. But now, what do I do if I want to change how these labels look? For example, let's say these labels are for wedding invitations, and I want to add a little bouquet of flowers next to each person's name? Would I need to add that image 24 times or do I need to delete 23 of the labels, add the photo and then duplicate the label 23 times again? This all seems really tedious to edit these labels, especially if I end up making a lot of changes. There has to be a better way. Well, there is a better way. It's called the Data merge Layout tool. This tool will allow us to easily edit all the duplicate address labels in our template without needing to change each one individually. The Data Merge Layout tool will also solve our other problem by allowing us to have multiple versions of the same field on a single page. It's a really great tool for data merge. You're going to love it. Keep this document open and in the next video, we'll dive right into the Data Merge layout tool. 40. Data Merge Layout Tool: In this video, we'll learn how to use the Data Merge layout tool. To learn about this tool, we're going to keep working on the address labels that we started in the last video. But first, I'm going to delete all but one of these labels. With the move tool, I'm just going to click and drag to select most of these labels, then I'll press delete, and then I'll go ahead and delete these last two here. Now we're just left with this one. Now I'm going to get out the Data merge layout tool, which is right over here. It looks like a piece of paper being torn in half. Go ahead and click on that. Then I'm going to click and drag from margin to margin. As you can see, there's a grid here. Now, what this is doing is it's creating a grid of cells. Each of these cells will be connected together. This is the parent cell right up here. Each of these cells will incorporate whatever's in this parent cell right here. To see how this works, I'm going to grab a shape tool. Let's go with the star tool. Then I'll click and drag out a star, and you can see as I click and drag that out, it appears in all of the other cells. As I update this star, it will update with all of the rest of them. If I add another one, There you go. You can see that's also been added to all of them. If we go to the layers panel, you can see how this is set up. We have a data merged layout layer. Then you can see both of these elements. You can see we can only really select them over here in the parent layer. If we grab the move tool and try to select these other ones, nothing happens because these are just a mirror image of this one. If you want to change something about these, you'll need to select the parent layer star and then move it from here. I'm going to delete these two star layers. Now I want to see how we can make this text box a part of the Data merge layout layer so that it's repeated in the other cells. Well, that's actually pretty simple. We just need to make it a child layer to the Data merge layout layer. To do this, I'll just drag this right on top of that layer. Now you can see it's become a child layer. This is great. Now, we just need to make more data merge layout cells. I'll go ahead and select this layer. Then I'll get out the Data Merge layout tool again, and we can come right up here to the context toolbar to adjust how many cells it has. From the context toolbar, I'm going to change the number of rows to eight and the number of columns 23. Now it looks like we have our original 24 labels back. This looks really good, and now you can see how easily we can change each of these address labels. I'm going to select this text layer right here, and we can change something about it. Maybe we want to make it a little bit smaller or larger. Whatever we change about this, it will update and all of the other ones. I'll just undo that with command or Control Z. Now that we can see how these cells work, let's dile our address labels. First, I'll zoom in here. I'm going to change the family name right here, I'm going to go to textiles and add Heading one to it. Well, that's pretty large. Maybe I want to reduce the size. Then I think in the character panel, I'm going to make this look a little fancier using this setting right here under Typography. Then I'll update this textile. Next, let's update the body. I'll go ahead and change this to times New Roman. Then I'm going to decrease the size, and I'll go ahead and update this. Now, I think I forgot. I do want to change the font of heading 12 times New Roman as well. Then I'll update that. This is looking really nice. The next thing I want to do is I want to add an image to this. I'm going to make sure I have the move tool selected and I'll just click outside, so nothing selected. Then I'm going to grab the place image tool and I'll go ahead and add this Bow image. I'll open that up. Now I can click and drag this right in here. Right now because I had nothing selected, it's not being applied as a child layer, it's just on its own. But if I want this to be incorporated in all of our layers, I'm going to come over here to our layers, and I'll just make this a child layer. Now you can see that. I think I actually want this to appear underneath the words. I'm just going to drag this down like this. Now, make sure that the blue line looks like this underneath the family name. If you click too far and your blue line turns to this, you'll be dragging it outside of the group. Just make sure blue line is right underneath the text. As you can see, now we have this beautiful image on all of our address labels, and we can update how this looks. I think I'll reduce the opacity, so it's just a nice subtle image there. I think I'll also go ahead and center this. That looks really fancy. Very nice. Now here's the surprise I want to show you. I'm going to generate our address labels now. Go to Window, Data Merge Manager, and generate. I'll close out of this and show you that now every address is unique. It's using the individual rows of Excel, and it's making each of these address labels a different one. That's because the Data merge layout tool makes it so each of these cells is like a unique page. Previously, it didn't work quite like this because Data Merge wants to sate every page like its own unique Excel row. But using the Data merge layout tool now, you can see that each row in Excel can be its own cell. Let's go back to the template because I have a few last things that I want to show you about the Data merge layout tool. I'll go ahead and select the tool. Then I'll go ahead and select the layer. Now from the context toolbar, you can enter the exact width and height that you want for each of these cells. It's super easy to change this up here. I'll just undo that. Up here? You could also change the record offset, which allows you to offset where your data starts. For example, if you already printed off your first 24 address labels, you could tell the data merge that you want to start on 25. Another thing you could change is the record advance. By changing this, you could tell affinity that you want every other row in Excel to be recorded or every third entry in Excel. Why is this useful? Well, all of this really just depends on how you've set up your Excel file. For example, if you had a first name column and you had a list of everyone's first names. But in the row below each person's first name, you had their nickname. Then in affinity, you could use record advance to skip past the nicknames. Only the official first names were added to the address labels. The next thing I want to show you is how to add a gutter. But to see the gutter better, I'm first going to add a colored rectangle underneath everything. In fact, since this is the data merge, we really only need to add the colored rectangle to the very top cell here. I'll go ahead and change the color, and then I'm going to place this underneath our text. With the data merge layout layer selected and the Data merge layout tool selected, I'm going to add a gutter by coming right up here, and I'm just going to type in 0.25. This is added to space in between each cell, but it didn't resize our text frame. I'm just going to select our text frame using the move. Using the floating handle, I'll go ahead and bring this in. This could be helpful if you were printing these labels out on stickers and you needed a little bit of a gutter so that they would print properly. The last thing I want to show you is how you can change the flow of your grid. To do this, I'm just going to select the data merge layout layer again and the tool. Then I'll come right up here to where it says Layout order. If I change this, this is going to change the order that all of your data will show up in. Right now, if I select the vertical one, then all of the address labels will be in order going down this way. I'm going to check on this option, show record order to show you this. As you can see, all of your data will be in this order. But if I do the horizontal way, all of your data will be in this order. You can do whatever order works for you, but I just wanted to show you how you can change that. All right. Yeah, for the Data merge Layout tool. It can be so useful for address labels, name tags, or anything else that you just want repeated on a single page. We're now finished with the name tags, you can go ahead and close this document and in the next video, I'm going to show you a few more data merge tips. 41. Data Merge Tips: This video, I'll share a few data merge tips with you. Now, you already know about 95% of everything that you need for data merge. But I do still have a few more things that I want to teach you. The first thing that I want to show you is that you don't necessarily need to insert fields into a text frame. You could also insert your fields into tables. We're going to do that in this video. But first, we need to import our Excel file, which includes information on the 100 most populated countries in the world. To import this, let's go up to Window, Data Merge Manager, and then we can go ahead and add in the Data Merge tips file. Go ahead and open that up. I'm also going to check on Preview W Record, and then we can close out of this. Using this information, let's go ahead and set up a table over here. I'll grab the table tool. Then I'll go ahead and click and drag out a table. Now, for this table, I actually don't need quite so many rows and columns. I'm just going to use four rows and two columns. Once you have that setup, you can go ahead and click and drag this to fill the entire document. By the way, this is just an 8.5 by 11 inch document with half inch margins. Now that I have all of these rose and columns set up, I'm going to go ahead and alter a few of these cells to get them ready for our fields. First, I'm going to select these top two cells here. Then I'll right click and merge these cells because this is going to be where we put the name of the country. With that in mind, I'll go ahead and click in this box until I can see a cursor blinking, and then I'll double click on the name of the country. Then for all of these little data points here, I'm going to click in each of these cells and insert that data. Okay, with all of that inserted, I'm just going to click in each of these cells to label what all of these numbers are. So first, right up here, we have the percentage of the global population. Then down here, we have the fertility rate. Last down here, we have the median age. Now that I've inserted all of that information, I'm going to go ahead and style the text. To do this, I'm just going to first select the cells that are all beneath the main country's. I'll do that while holding down command or control. With all of those cells selected, I'll go ahead and alter it. I'll go ahead and make the Font Times New Roman. I'll make the font quite a bit larger. Then I also want to make sure that this is centered. I'm going to center it both horizontally and vertically. With that all taken care of, I'll go ahead and update the textile, which is the table body textile. Then I'll go ahead and select this top row here. For this one, I'm going to go to our textiles and make it heading one. Then I'll go ahead and update heading one. Let's make it times New Roman as well. I'll make it quite a bit larger. Then I'll make sure that it's centered both horizontally and vertically. Then I'll update the style. We're almost on stylizing this table. I just want to make it look a little bit prettier. We're going to go ahead and change the colors. Now, for these columns down here, I'll select them with command or control. Then I'm going to change the fill to a nice light blue color. That looks good. Now for the name of the country, I'll make this a nice dark blue. Because it's a dark color. I'm also going to highlight the name of the country and I'm just going to give it a white fill. Then I'll update the textile. The last thing I want to do is I actually want to select all of these ones again, I'm going to get rid of this line down the center. To do that, we'll go over to where it says stroke. I'll select where it says vertical inside. Then I'll go to the stroke in the color panel and give it no stroke. I think this looks really good. Now that we have all of that set up, we can go ahead and generate our data merge. I'll go to Window Data merge manager, and then I'll go ahead and generate this file. As expected, Data Merge has made a new table on each page. Every Excel row has its own individual page with all of the information displayed right here. Of course, all of this is still totally editable, just as we've always done. For example, I can click right in here into this table, I'll select the row, and we can change the color if we want to. Or should I say we can change the fill color if we want to. There we go. This actually leads us into the next tip that I wanted to share with you. You can still edit this output document however you want, just like any other publisher document. This means you can even do things like adding or removing pages. I'll go right back up to the beginning right here and in the pages panel, I can right click on the first page and add a page to the very beginning. I'll add one page before page one. Now we can use this page as a title page if we want to. I'll go ahead and give it a title using the artistic text tool. Let's go ahead and call this the world population report. You can go ahead and style this text, however you want. I'm just going to bold it and then center it right here. For this next tip, I want to discuss facing pages. When you make a new document, you can decide if you want your pages to be facing, which means they'll be placed side by side, just as we have in this document. Now, I've had facing pages turned on in all of my documents throughout this chapter. And if you have them turned on in your template file, which I did, then when you do your output file, it will also have facing pages. If you don't want your output file to have these facing pages. Option number one is while you're making your new document, just turn off facing pages. But option number two is that you can actually turn off facing pages afterwards right here in this output file. I'm going to grab the move tool and with nothing selected, I can come up here to document set up. Then we can go to where it says model and then uncheck facing pages. Then when I press k, you can see that all of this has been altered, so we no longer have facing pages in this document. For the next tip I have to show you, I actually want to go back to our template. So far, we've only used data merge with one page templates, but you can actually use Data merge on multiple pages. I'm going to go ahead and add another page. I'll just add one page after this page. Then I'm going to grab the move tool and I'm going to duplicate this entire table by holding command or control and dragging it over. Then I'm just going to alter a few things. I'll start by deleting. I'll just right click and then click Delete rows. Then I'll go ahead and spread this out all the way. On this side, I'll delete this top row. And then I'll spread this out. Now we have a two page template. Let's see what happens as we generate our data merge. I'll go to Window data merge and generate. As you can see, now we have every country having its own title page and all the information on the right side. But what would happen if you had even more pages as part of your template. Let's go back to the template, and let's go ahead and add another page. I'll right click and add pages. I'll add one page before page one. Now we have this page. I actually want this page to be a title page standing on its own. To do this, I'll grab the move tool and make sure nothing selected. Then I'll go to document setup. I'll go to model. Then I'm going to say, I want my pages to start on the right side. That way, this page will stand on its own. I'll press. Now you can see what that looks like. Now, unfortunately, for some reason, it moved this page to the bottom. I'm just going to click and drag this to the very top. Now you can see we have a title page and our two information pages. Now to alter this title page, I'll just grab the artistic text tool. Again, I'm just going to type out world population report. I'll go ahead and center this. Now we have a title page and our information. Let's see what happens as we generate this. It looks like we have our title page, but something happened. This title page has been repeated over and over throughout this entire document, even though I didn't put any field information on it. That's because generate we'll duplicate all of your template pages over and over again until the information from each Excel row has been accounted for. But we can actually control this behavior. To do that, we'll need to learn more about the data merge manager, which is exactly what we'll be covering in the next lesson. Keep the template file open, and I'll see you in the next video. H. 42. Data Merge Manager: This video, we'll learn some advanced tips for the Data merge manager. We'll continue working with the same document that we were using in the last video. To learn more about the data merge manager, let's go ahead and open it up. So far, we've really only been working with the data merge manager to bring in our Excel file, turn on preview with record, and then generate our output file. But there's actually quite a bit more that we can do in this data merge manager. For example, in the last video, the data merge duplicated all of the pages of the template, even the cover page. But if we didn't want this to happen, we could actually change the page ranges I'm just going to scroll down here so that you can see, we can click on page range, and then we can say which pages we want generated. In this case, I would say I want page two to page three to be generated. I'll go ahead and generate this now. Now you can see we still have our title page. But instead of repeating throughout the document, we now have just the second pages repeated through the document, which is exactly what I would have wanted from this. At this point, we've now seen two different ways you can add more pages to a data merge. One way is to just add a page after the fact in this output file, or you could add multiple pages in your template, but then tell the data merge manager not to include that page in the repetition. Either way works well, do whatever technique you prefer. Coming back to the data merge manager. I want to show you a few more things. We've already seen that when you check on preview, You can see a preview of all of the information as it's going to show up in your document down here. But you can actually change which information is being previewed. This could be quite useful. For example, maybe you want to see how your text would look right here using the largest name in your data. In this example, the largest name is the United Arab Emirates, which is entry number 93. Once I've put 93 right there, this will skip down to the third row in our Excel file, and it will let us preview what that information would look like. With that information there, now we can style the text however we want. For example, maybe we want to decrease the size of this. I date Heading one. Maybe you think that looks a little nicer since that was so long. Now you could go ahead and generate this, knowing that even the longest name will look good in this file. One thing to keep in mind is this is still just a preview, your data merge will still start on entry number one. Well, normally it would start on entry number one, but you could actually change this to. If you go to the filter section, it will just generate all of your records, but you could actually do a page range if you want to. For example, maybe you want the 50th to the 75th entry or something like that. I'll press enter on my keyboard and then I'll go ahead and generate this. Now in the data merge, we'll only have entries on the Excel file going 50-75. You can see we have a lot less pages now. Let's go back one more time to our template, and I'll open up the Data Merge Manager again. As one final tip, I want to cover what happens if you update an Excel file. Whenever you update an Excel file and then push Generate, a pop up will appear asking you if you want to use the most up to date version of your Excel file. You really don't need to worry about updating your Excel file. But if I don't need to worry about updating my file, then what's this update button for? Well, that up date button is there. Just in case you need to add a new column to your Excel file. As an example, maybe you wanted to add a new column that has every country's GDP. In that case, you would need to press the update button so that your fields over here have one more dataset right there. If you don't use this update button, it won't include that extra set of data. All right, great work. You've just about master data merge. I just have two more tips to show you that can really help you with two specific situations you might run into. We'll learn about those two tips in the next two videos. Okay. 43. Troubleshooting Blank Fields: In this video, we'll learn how to work with an Excel file that has blank fields. As an example, I want to make a data merge that's set up like this to produce pages that look like this. But if we look at my data, you can see that I'm actually missing some of the e mail addresses and ages. If I set up my data merge like this, then affinity will get to one of the blank cells in Excel, and it will just leave a blank line in the data merge, and even worse, some people are missing their e mail address and their age. It leaves an even bigger gap in the data merge. By default, affinity will just leave a blank gap if there's any blank cell in the rows. But I'd prefer it if affinity just skipped those lines instead of leaving them blank like this. Now, unfortunately, affinity doesn't have a setting that you can do this with, but I have discovered a workaround that you can use to achieve this desired effect. The technique will show you can't fix every situation. But it is a good workaround that can help you if you run into a problem like this. I've imported my Excel file from the exercise files, placing the fields into a text frame, and I went ahead and centered the text vertically in the frame. But we already saw that this isn't going to work. Instead of adding line breaks, we're going to put everything on the same line. I'll go ahead and delete the line break. Now that everything's on the same line, where I would have put a line break, I'm instead going to put $1 sign. This dollar sign is going to work as a placeholder and we'll see this in a moment. Go ahead and add those dollar signs. Then I'm going to go back up to Window, data merge manager, and I'm going to go ahead and generate this. Now as you look at all of this data, you can see that we have $1 sign in between all of the information here. If I continue to scroll through here, you can see people who are missing multiple lines of data have multiple dollar signs. In fact, some people even have $3 signs like this because they're missing so much data. Remember that these dollar signs are just a placeholder and our data merge. The dollar sign is supposed to be a line break. What I'm going to do to get rid of these dollar signs and format this properly is I'm going to use the find and replace feature of affinity to replace all of these dollar signs with a line break. To do this, I'm going to press command or Control F. I'm just going to move this right over here next to Fields. Now we can go ahead and use this to find all of the dollar signs in this document. To start, I'll just find $1 sign, and then I'll press Enter. You can see that we have quite a few dollar signs in this document. Wow. There are a lot of missing data points here. Next, I'm going to type in $2 signs. You can see we have still a lot of data but less data that has $2 signs. Last, here are the people that have $3 signs next to their name. Now what I'm going to do is I'm going to start with these people right here that have $3 signs, and I'm going to replace it with a line break. To do this, I'm going to use this drop down. Then I'm going to click right here to replace it with a line break. Then I'm going to click on Replace A. Now Affinity has replaced all of the triple dollar signs with a line break. We no longer need to worry about people with triple dollar signs. Next, I'm going to go ahead and look for people that have $2 signs. You can see these people still have $2 signs. I'll go ahead and replace all with this line break. The reason I started with $3 signs is because I didn't want to start with a single dollar at a line break and then have three line breaks for those people with $3 signs. It's better to actually start with $3 signs and replace it there and then work our way backwards. All right. This is looking good. Last, I'm just going to find the single dollar sign and replace it with the line break. All right. Now as I scroll through my data, you can see that everyone has all of their information stacked on top of each other. There's no strange line brakes and no more dollar signs. Everything looks so good now, and now you know how to work with a tricky Excel document that has some blank fields. We just have one more lesson left, so I'll meet you in the next video. 44. Splitting PDFs: This video, I'll show you how to easily split a PDF into multiple PDFs. We actually won't be using affinity publisher for this, but I still thought you would enjoy this little trick. As an example, I included this PDF in our exercise files, and in this example, I used a data merge to generate certificates for a group of students. Now, I'd like to send each student a PDF copy of their certificate, but I obviously don't want to send each student a PDF that has everyone certificates. How can I turn this PDF into multiple PDFs? Well, it's actually really easy. There's a website you can go to called PDF to G. I'll leave this linked below this video. Using this website, we can split this PDF into multiple files. I'll go ahead and choose our file to start. I'll go ahead and open that up. Now you can see down here it's uploading and that was pretty fast. Now it's going to take us to this page and on this page, we can say that we want to save this PDF, and then we can say we want to split the PDF on every page. Then go ahead and hit save. All right. Now you can see we have individual PDFs here. Every single page has its own individual one, and now I just need to download this SIP file. All right, I went ahead and opened up that SIP file, and now you can see that we have all these individual PDFs that we can send to our students. And now you know how to split a PDF. 45. Class Conclusion: Great job. You made it to the end of the course. You are now an official, Affinity Publisher master. I hope you enjoyed all of the amazing things that we were able to learn in this course. Thanks so much for watching, and I'll see you in the next Affinity Revolution Tutorial.