Welcome to Toffy TV, here is the Everton News Daily. Everton won 5-1 last night at Brighton Hovalbyn in the Premier League to climb out the bottom three and give every Evertonian an easier night to sleep. The 3,000 fans that travelled down were fantastic, in fantastic voice and got rewarded with a tremendous performance. One of Everton's best performances over the last few years and certainly one of Everton's best away performances for a number of years. Si'n ddait was obviously delighted with the results after the game. This is what he had to say. Fantastic last night obviously to beat a team in as good form as Brighton and to play the way we did and to score the goals we did. Obviously everyone put in a tremendous performance, but man had a match certainly for me and for a lot of people was Dwight McNeill who's improved so much too late. Everton's top scorer now at seven goals and it's just seemed to be getting better. It's obviously got more confidence since Si'n ddait's come in as well. This is what the manager had to say on the performance of Dwight McNeill. He sort of goes inside and short and I said, no, no, keep going, keep driving forwards because he does it so well and he can cross the ball and he can deliver calm finishes. His two finishes are terrific. It's just another sign of what he's got. I think he's got a lot to be honest, but I do a lot of these players. When they're on the edge and they're all playing well and they're all full of confidence, but you have to build confidence, it doesn't just come naturally. Some players actually does come naturally, but others have to build it, and I think he's been building his confidence levels. A player who was fantastic last night and was key to Everton's victory was Abdelhaid Ikora. He scored the first two goals and was everywhere really and since Si'n ddait's come in he has been a key part of everything that Everton has done well. Obviously he was sent off against Tottenham and that led to Everton and Dait struggling to get a decent performance and results suffered from it, but he's back now and he's doing really well and he was key last night. This is what the manager had to say about the contribution of Abdelhaid Ikora. I mean, Duke's been tremendous anyway since I got here, but he's energy and he's will to go and score a goal. I've always liked Dwight as everyone would know, but his question was for all God. He's delivered very good performance. Dom, of course, makes a big deal. He's missed the 10-11 games for us. No disrespect to any other forwards because I believe in all of them, but he's quite obviously a very good player. That does give you more of a focal point at times, so please for him and he's getting fitter and stronger. There's so many good performances, part of what I thought was excellent against arguably one of the best or highest performing wide men in the division, so lots of good individual performances. Ikora's been brilliant for Dyche and getting forward and that looks more like the player we bought, doing the things we bought and for from Watford, which was breaking into the penalty area. We've needed him and McNeill to step up with the goals of late, and that's what they're doing. But just more on Ikora who's asked about his contract situation after the game, this is what he had to say. He said, the club knows my position since even a year ago. Now, obviously it becomes very difficult for us to reach an agreement, but I'm doing my job at the moment and we are just going to sit at the end of the season, but I am fully focused on keeping Everton up. Everton do have an option to trigger in the core age contract and trigger another season. He is higher in it, so it's quite clear Everton are waiting to see what division they're in before seeing if they can come to some sort of agreement to keep Ikora at the club certainly for at least one more year. So they'll have to wait and hopefully he can weigh in with another couple of goals, get us another win that will hopefully see us safe for the season. Andrews Townsend rather returned to action yesterday after 13 months out with the knee injury. He played for the under 21s, he played the first 45 minutes. They were beaten 2-0 at home by Leicester in the final game of the season, but massive boost for Townsend to get back on the grass. Whether he'll be able to play any part in Everton's final games remains to be seen, but it's good to see him back out there in 45 minutes will have done the world a good and then it'll be a case. Can he step up training now and train with the first team? We'll have to wait and see. Finally, Everton have been linked to David Railbetty striker Raal Garcia, the 22-year-old that spent the season on loan in the league of two with C.D. Miranda. He has scored 19 goals this season. He is available for around £8.7 million apparently and Everton are keeping tabs on him, so we'll see with Daphne and the marker for at least one forward this summer. Again, dependence on whatever division we are in, hopefully it is the Premier League. That is it for the newsday. Give the video a thumbs up, subscribe if you haven't and if you want to become a Toffy TV Premier member, the link is in the description and the QR code will be on the screen in about two seconds. Thanks for watching. See you later.


It's day 17 of the 2022 diamond ink vent calendar ink reveal today's ink is called flame It's a very pretty orange We have an ink splash and ink swatch and then a writing sample for you guys today We hope you enjoyed this ink reveal and if you haven't gotten your calendar already head to our website to get your


Hi everyone. Thank you so much for joining us today for our webinar, Excel Made Easy for Beginners. Before we get started I just want to go over a few housekeeping items so everyone is going to be muted. So if you have any questions you should be seeing a Q&A box to the left-hand side of your screen. Feel free to ask questions as we proceed through the webinar and we will try and answer as many of them as we can towards the end. If you lose your Internet connection you can reconnect by using the link that was emailed to you. Sometimes you'll want to refresh your browser to make sure that it's working and that your Internet is functioning. If you want to watch this webinar again or if you have to drop off early we're going to be hosting the webinar on our website at techsoup.org slash community slash events dash webinars. You'll also receive an email with a presentation, the recording, and any relevant links that we go over today. If you're on social media feel free to send us a tweet at techsoup using hashtag TS webinars. But like I said earlier the Q&A box is what we'll be focusing on today for your questions. So just a little bit about techsoup. We are in 236 countries and territories. We serve over a million nonprofits. So just to kind of make sure that the chat box is working we'd love to hear who is on the call today and where you guys are calling in from. So if you want to tell us where you're dialing in from today I'll read out a few. So we've got Alice from New York, Sarah from Lexington, Terry from Miami, Baltimore. So we have people calling in from all over the country. I haven't seen any international folks yet, but hopefully there's some international folks on the call as well. So it looks like the chat box is working so I'm going to go ahead and move along. So we partner with several technology companies like Adobe, Intuit, Microsoft, Symantec. They help make our mission possible. And we offer hardware and software either discounted or donated. I know for many of you it is the end of the fiscal year. So now is a great time to stock up on your technology products. So we'll share a link with this information. But our product website is techsoup.org slash get product donation. So if you're interested in seeing what technologies we have available for your nonprofit either discounted or donated feel free to visit that URL. All right. So I am going to go ahead, just a quick introduction. So my name is Seema Tucker. I'm the online learning producer here at Techsoup. And my colleague Lashika Phillips is going to be presenting Excel today. She is an Excel wizard. So I'm excited to introduce her. So just a little bit about Lashika. She is the Associate Program Manager at NGO Source. She's been with NGO Source for about two years. And prior to joining NGO Source she had her own consultancy helping nonprofits with operational management, fundraising, and administrative processes. So without further ado I'm going to go ahead and hand it over to Lashika. Wow, thank you Seema. But first I have to address this Excel wizard. That is hilarious. I wouldn't say that I'm a wizard. Maybe a super user only because I do use Excel every single day for about maybe 30, 40% of my work. I have to go in between and use a lot of different reports. We use Excel in our department for reports. We look at sales. We view transactions. So a lot of different things. But yes, like Seema said before joining TechSoup I did have my own consultancy business helping nonprofits and other businesses. And what I noticed is Excel it can be a little intimidating yes. But I hope that today we can show you how you can feel more confident using Excel. And that's the goal today is for at the end of this you feel more confident and maybe perhaps you will be ready for part two and then maybe perhaps you can become the Excel wizard. That would be great. So before we get started now that I know where all of you are joining from now it would be very helpful to know your level of experience with Excel. I love this. Are you in a place where you feel as if you don't Excel at Excel? I think you are in the right place. Do you know the basics and need a refresher? You have some expertise and maybe this training will help you kind of put together a training for your team? Or are you pretty proficient? You can do this in your sleep and you are actually ready to take over this webinar. So I'll give you a couple of seconds to provide your response. And let's see, wow so okay it looks like a vast majority of you do know the basics. And for those of you who feel that you don't Excel with Excel then hopefully today that will change. So let's see here I'm going to see if we can pull up the results.  I love that. Some expertise, many of you know the basics and then again some of you don't Excel at Excel but hey that is going to change. I promise. I promise. So let's go to the next. I have one other question. So if you are not aware I actually did a webinar much similar to this last year. Actually I think it was the exact same title because this is something that TechSoup always, we're always getting questions and inquiries about Excel. So if you did, I just want to know are you returning or is this your first time? It's just really, really nice to see. So I'm going to give you a few more seconds to respond and we will move forward. So it looks like wow this is actually really exciting. So to the few of you less than 1% who attended last year, thank you for returning. Welcome again. And for those of you this is your first time. Thank you so much for joining. So let's dig in and let's do what you came to do and to see. So I am getting ready to share my screen. Before I do that I want to warn you a couple of things. One, I am using Excel 10 for Office 10. And I also want you to know that I am on a PC. I am not on a Mac. So some of the things and some of the shortcuts that you see that I will do it may be different if you will be using a Mac. The other thing I want to mention is because I am sharing my screen. Occasionally you may see a pop-up, but no worries. It will go away in just a second. I just want to prepare you before we dive in. I have one question. Is everybody ready? Are you ready? Please count it out. Are you ready? Are you ready? Are we ready to excel in Excel? Let's do this. Let's do this. Okay, I am sharing my screen and let's see. Okay, so now you should see an Excel spreadsheet or workbook. And hopefully you would have seen a little black box disappear. And maybe now you've seen another one just disappear, hopefully.  And of course this is really simple. It's not a lot of data because I didn't want to overwhelm the people who do not excel with Excel and for those of us who know the basics. So this is a really simple spreadsheet. And trust me, I understand that the data that you are working with, it's probably maybe 20 times this size. And I get that. But again, for purposes of this demonstration, I wanted to keep it really simple. Are we ready? I think we are. So here's the spreadsheet. Here's one. And let me show you this. So this entire application, all of this here is a workbook. Okay. And as you can see down here, these are the different sheets that you can have in your workbook. What I recommend is you always have with your first sheet, I always recommend renaming this and letting this be your master information. And it will make sense in a minute. So in order to change the name of your sheets, this is just to kind of get started to get everything organized so you can start analyzing and managing your data. So I would say this would be the first step, is to come down and begin to organize your sheets. So I would rename this. And so what I did is if you go down to where the sheets are, you want to right click on the tab and you can rename it. My recommendation is to always name the first one maybe your master list. Because the goal is once we finish filtering and sorting our information, then we will take some of that information and maybe put it into a separate spreadsheet. I hope that makes sense. You can also change the color of the tabs. So if you wanted the master tab to stand out a little bit more, again simply right click on the tab. And then as you can see here, tab color, and then we can change that. So as you can see, this is our agenda today. These are the things that we are going to talk about. I'm getting ready to show you some most commonly used tools.  The only toolbar that you see, it starts with Home, and then you see Insert, Page Layout, Formulas, and so forth, correct? But I want to show you something. If you click on the Home tab here, if you click Home, then if you notice that toolbar expanded. And this is what I love. What I love is that for any one of you who feels as if you don't excel with Excel, hopefully you are familiar with Microsoft Word because you will notice that a lot of the icons and a lot of the functions that you see in Microsoft Word are the exact same thing in Excel. Even the shortcuts, and I will talk about shortcuts in a minute. No need to worry about that. We will get there. But this is the main toolbar here. This is actually called a ribbon. But I want to show you something. Excel is very intuitive because I have this expanded. I have this ribbon expanded, right? But if I want to do something in my spreadsheet, watch what happens. It disappears. So if every time I want to change my font or do anything in this toolbar, I have to continuously go up, click Home.   You can pin the ribbon. So when you pin the ribbon, what that does is it allows this toolbar to remain intact while you move on into your workbook. So the next time you are in Excel, try pinning the ribbon. I'm sure it will save you some time and maybe a headache or two. So we are going to move right into this section, the clipboard section. And again, as I mentioned, you notice that if you are familiar with Microsoft Word, the cut icon, copy and paste, format painter, all of these are the same exact functions as in Microsoft Word for purposes of demonstration. I will just show you. So copy is when you want to copy information from one cell. These individual boxes here in Excel are called sales. And if you notice as I move to these various sales, notice this number here changes. I like to call this the cell address, but it is actually called the name box, but that is really what it is. So if we come here and we want to, let's copy this information. So we are going to copy this and we want to move it over into this cell. So it has been copied and I am coming here because this is where I want to place the information and I want to say paste, and that is the copy and paste function. If I want to maybe have this information in this cell here, if I want to have this information somewhere else, what I could do is cut it from here by selecting the cell, select cut, and maybe go to a different cell and I can paste it here. And so then it removed it there as you can see and now it is here. Now I am going to show you Format Painter because for me it was a game changer. It was a huge deal for me. So I want to show you very briefly. A lot of times in your spreadsheets you will notice that for instance your headers, if your header is maybe bold and I am going to use these functions here as you can see, and maybe underline. And if I want, maybe I don't want this entire, all of my data to be bold and underline. I just need a couple, maybe a couple of cells. So what I can do is select the cell where I want to copy the format. So I am going to repeat that we are copying the format, not the content. So we are going to select this cell and we want to click Format Painter. And now we are going to select the cells where we want the format copied. So let's do that here. And voila, that's the format painter. And the reason why this was a game changer for me was because there were so many times where things needed to be highlighted or underlined in various spreadsheets that I was working in, and I was doing that manually. So if you have been doing that manually like I was, you do not have to do that anymore. So hopefully you like that tool and you can begin to use that tool. So as you notice, once we re-select that option you can see that the formatting then goes away. That's how you remove the formatting. And again, same thing with Microsoft Word. We have our list of fonts here. We have the font size. You can decrease and increase your font size here. This is where you would add lines and borders to your spreadsheet. And here we have where if you wanted to maybe feel a highlight. If we wanted to highlight this, this is a header. Then we could select the fill color there. And if we wanted this to stand out even more, we could make our font color a different color this way. And if we don't like what we did, one of my favorite things is undo. Just pull the arrow up here and we can undo that again. Just a quick shortcut to undo is Ctrl Z. But again, if you are working from a Mac it will be different. So let me move into the spreadsheet with some data. It's down here in sheet 2. So this is the data that we are going to be working on. And I will say this, if you need access to data where you and maybe your team can play around with, feel free to reach out because I can provide some links to where you can find this information. So you can take the information that you learned today and maybe play around with it without messing up your real raw data. So let us know if that's helpful as well. So here is our information. And this is what we are going to be working with today. Here with the alignment section you can see again, it's the same exact icons that you would see in Microsoft Word. We can align our text to the top of the sale in the center and at the bottom. And we can also align the text to the left in the center as well as to the right. And that's how you do that. You can even indent here. This is what this is for. And then this icon up here for the orientation, just to be clear, it's the orientation of the text and not the actual orientation of the spreadsheet like landscape or portrait. So this will give you the ability, if you need it for the header to stand out, then you can actually come here and maybe you could, let's see, let's change it. So I want to make sure you saw what I just did. So with this drop down, there is a drop down here. And you see Format Cell Alignment and that brought me here. So from here you can actually do a lot of different things. But here I want to show you how easy it is to change this text orientation. You can just move this arrow that way and I'm going to show you what it does. So it makes the text like that. Now you say, well, who would want to do that? Believe it or not, depending on the amount of data you have, sometimes having the header slant is actually better. It just really depends on what your report is for, what you need this data for, and how you're using it. For purposes of this demonstration, I'm not going to leave it that way. I prefer to have it just horizontal. Okay. So now we're at the number section. And I know a lot of people have asked me before, so what's the difference? Why do we have all of these different options? So when you have general, it's no number. Then Excel won't add a decimal for you. There are no functions involved. It's just a number. Currency will actually give you the currency symbol. When you use the accounting method, it will give you the currency as well as align the decimals and all of the numbers. And then again, with the short date, it's just the short date. As you can see, an example here, a long date, as you can see, the long date here, time, and so forth. And so for here, let's see what happens if I make this, if I decide that this is actually just a number, it's not currency. So we're going to say general, not a specific number. So you see the difference? It's just a number. It's not a dollar amount. It's not currency. It's just a number. But we know that because the header is donation, we know that this is currency. So we're going to say currency. And so now we have our currency symbol. We have decimals. Everything looks great. And what I want to show you here is because I'm very familiar with this data, I know that these are all whole numbers. I know that there isn't any change in any of these donations here. So what I can do is select this column and I can remove the decimals. And so that's just as simple as that. Moving on to styles. Now I can say the only time I've ever used anything under the style section, it was to remove duplicates. I'm going to show you how. So if you look at conditional formatting, you have all of these different options. Again, this is for the very beginner. I promise you I am not going to talk about top-bottom rules and data bars. And we won't deal with that today. We're going to focus on highlight sales rules. And from here, this has been really another awesome game changer, not just for me, but for several other nonprofits. And I'm going to show you why. Yes, there is a way in Excel where we can sort and filter and I'm going to get to that. But using this tool here, I can easily identify any donors that donated more than let's say $800. Let me show you. So conditional formatting, highlight sales rules, greater than. So I want to look for, did we say 800? I believe I said 800. So we're going to look for sales or we want to look for everything that's greater than 800. So I'm going to say 800. And I'm going to say okay. Hmm, it did not do what I wanted to do. This is a great lesson because when I went to conditional formatting and I started moving around here, this was the sale that was selected. So make a note of that. Before you do anything in Excel, be sure that the sale that you are working with and the sale that you want to work from or where you need your sum or your formulas work to be sure that that sale is selected. So let's fix this. How can we fix this? Anyone know? You can chat it in the chat box. How do we fix this? Anyone know? I don't know. So the answer is you got it, Control Z or the undo button. Very good. Thank you all for participating today. So let's do this the right way. We're going to select the column because this is what I want Excel to check. I want Excel to check column E. So now let's do this again. Conditional formatting, highlight sales rules, greater than. And let's say 800. And according to this rule, everything that's over 800, Excel says that it's going to highlight it for me in a light red field. Let's see. I believe it worked. I believe it worked. So now I have identified everything over 850. So now that I've done that, if I don't need this rule anymore, now that I've identified, maybe I want to look at something else, but I want to show you how to remove this rule. We're just going to go back again. What's the first step? Exactly. Select the column or the sale that you are working with. Go back to that function. For this, we're looking at conditional formatting in clear rules. And that's it. So I'm going to move on to how to insert and delete sales. It's really simple. If you've used or worked in a table in Microsoft Word, then I'm sure these icons in that function is the same. And let me address a question. Why do I need to use Microsoft Excel if I can create a table in, let's say, Microsoft Word or in Google Docs? That is actually a really, really great question. And the answer is those other applications, they do not allow you the add-ons and the other functions and tools that Excel offers you. So I always recommend, if you have to have something in a Google Sheet, I always recommend doing it in Excel first, creating that workbook in Excel first, and then you can upload that into a Google Sheet. But keep in mind the formulas and the different add-ons and the functions that you have in Excel, they're not all available in those other applications. So you aren't able to do formulas for instance in Microsoft in a Microsoft Word table. So let's insert, let's insert a row here. So what you want to do is to go to the row where you want to insert an additional row or multiple rows, and you can select the insert icon here. And as you can see, I'm sorry, a row was just inserted. And the same thing with column, we can go here, maybe we want to add one next to the donation column. And so I can go here to insert and add another column. And to delete, again here's the icon here, I can delete. The other thing I can do is right-click after the row of the column is selected. If I right-click, there's a delete option here as well. Oh, I just realized that I skipped over something. So I just want to show you something because I noticed that, notice how the information here is wrapped. I can see the entire email address for each entry, correct? However, a lot of times when I receive a report, it usually doesn't look this way. It usually looks this way. And information is cut off. And sometimes, and if you aren't aware, you can double-click where the beginning of the column is here. And that will expand to the longest line, or to the longest line of sales with information in it here. But what happens is, what if your spreadsheet or what if your report has to be on a certain size paper? Sometimes you can't display your information or your content this way. And so what you would want to do is you can pull, you can shorten your column this way and then select and wrap text. And so now the entire email address is visible. I hope you saw that. Okay, does anybody, we're not at Q&A quite yet, but before I go in, before I move further because we're going to start talking about formulas, I just want to see does anybody have any questions about where we are now? No? So yeah, we have a few questions that came in. Let me see if there are ones that you'll be able to answer. Let's see, how do I select certain cells instead of all at once? I'm not sure. Okay, I think I understand the question. So if you want to select, there are a few ways that you can select a cell. You can select the cell by first putting your cursor in, let's say you wanted to, let's say you needed to select cells 4 through 7. And if you click on this, do you see this up in the top right hand corner? This selects the entire workbook, okay, or this entire worksheet here. That's what this does. So if you want to just select certain cells, you just go to the cell that you want highlighted, I believe I said 3 through 7. If you go here and then you just drag, drag your cursor, drag your mouse all the way to where you want to select, where you need the information selected. And so now I've selected all of that. I hope I've answered your question. So that's how you can select certain cells as opposed to selecting the entire spreadsheet. So this is me selecting certain cells. I'm just dragging my mouse over these different cells. And now this is me selecting the entire spreadsheet. I hope that answers the question. Yes, thank you. And then there's another question, how do you make each column the same width? So there's one way you can do it, and if you just, actually it's a really great question right after I just showed how to select the entire workbook. So you want to select this here where you can select the entire workbook. And if you just go to any column, any column anywhere, if you just go here and just click, double click, it will, oh wait, did I do something? Okay, well, maybe I'm not doing something. That's what I did. So lesson learned, you want to select the column, the columns ahead. Do not select the entire workbook. So I hope that makes sense. So let me show you what we're going to do. We're going to select the columns from the top here. And now if we double click, it should give us, hmm, this is interesting. So usually, and I don't know if I have something blocked or if I did something with my formatting. But typically if you just select the columns and you double click, it will expand and keep the columns the same width. But not an issue. Let me show you something else. If you select the columns, you can right click and you can do column width. So I was trying to give you a shortcut. And as you can see that it's not working for us right now, which is okay because there's always another way with Excel. So please remember that if you get stumped because you're not an Excel wizard and I'm not an Excel wizard, if you get stumped, there's always another way. And again, I'm going to give you some shortcuts in just a moment. But so let me go over this again. We're going to select the columns and then we're going to right click, column width. Now let's make the column width let's just say 12. Let's just see what happens. And so now all of the columns are the same width. So did you see that? I'm going to do it again. And you can do the same thing with rows as well. So I've selected the columns from the top here and I'm going to right click, column width, and I'm going to make this time 20. So now you can see what that looks like. I can do the same thing with the rows, width, row height, and let's say 10. Do you see what happens? So we don't like that. I can Ctrl Z, Ctrl Z, and here we are. I hope that answers your question. Yes, definitely. There's one more question and then we can move on. I really like this question because I always have the same problem. But when you're printing, how do you make sure you're able to capture all the data that's on the Excel spreadsheet? Oh my goodness. That happens to me all the time, all of the time. And I promise I'm going to get to that. I'm going to get to that and I'm going to move on if that's okay, Sima, because I am. Okay, perfect. Okay, good. Such a great question.  We're just putting a pin in it. Like we pinned the ribbon earlier. We're just putting a pin in it for now.  So take a deep breath. It is okay. You are about to learn formulas. And I'm going to show you how. Are we ready? Can someone say ready? Ready, ready, ready. Let's get ready to Excel in Excel. Here we go. So the first formula I want to show you, and it really is the most simple formula to use in Excel, I promise, and that is autosum. And all it is is self-explanatory to automatically generate the sum of certain sales. Okay? Are you with me? Great. Now, what we want to do, I've already told you that before you do anything, make sure that you are in the cell that you want to work from or that you want to work with. So in this case, and for purposes of this demonstration, I want to put the sum here, in this cell here, in G2. This is where I want the sum. So I want to give myself a header. I'm going to call it sum, but this is where I want it. And I want to add, I need the sum of, let's just get the sum of this entire column. Okay? So here I'm in this cell here in G2. I want the autosum. So all I'm going to do is click autosum. And now I'm going to select the column that I need added, where I need the total. And for this, I need column E. So I'm going to select column E. And now I'm just going to hit Enter. And that, you just learn how to do autosum. If you said that you feel like you don't excel in Excel, then you've just learned how to do a formula. Looks like, okay. So are you able to see that? Awesome. So now, let me show you. Okay. Now let's go to the next sum. I believe I'm having technical difficulties here. Let's see. All right. We're just having a little bit of a technical difficulty. So if you guys don't mind being on standby for a second until we figure it out. Feel free to ask questions in the meantime. And we will try and answer them as we can. All right, everyone. Thank you for your patience. We were able to figure it out. And Lashika will be back on shortly. Sima, that was a little strange. But hopefully now, hopefully you all can see my, can you just confirm, can you still see the spreadsheet? Yes, no, maybe. I want to also confirm that you were able to just see how to do autosum. Yes, yes, yes. Awesome. Okay, I see someone said no. So okay, let me show you again. So we want the sum to be here in G2. So I'm going to select some, and I'm going to select the column. For this case, I want the sum of the entire column. So I have that selected now, and then I'm going to hit enter. And there is the sum. So you've just learned how to do autosum here. Okay. There's some other basic formulas here in Excel that I want to show you from this drop down. So the next one is average. So if I wanted to get the average, what I could do, same thing. So I'm going to say average. Okay, and I want the average here. So I'm going to go average. Then I can select the entire column here and enter. So basically what this is telling me is that the average donation from this event or from this fundraiser, let's say, was $1,401. I'm able to see that very fast. There wasn't any math on my end or some assistant or CPA. We were able to figure this out in less than two seconds. So let's look at the other one. There is count numbers. So let's see how we do this. So the reason you would use count numbers is if you have, again, if you are working with a large data set and you need to easily identify numbers in a column, you can select and we'll do that here. You can count numbers. And so it will let me know here if I hit enter. Okay, well, did you see what happened? So it gave me that there's 103. So there are basically 103 sales with numbers in it. But you notice there's a dollar sign there's currency somewhere here. That's because this says currency. So I can change that though and make this general. It's not a number. It's not currency I should say. Okay. And I think that's, let's see, do we have questions? Yes, we have quite a few questions. Let's see. All right, so this one, I don't know if you'll be able to get to this right now, but when I download data into a spreadsheet from certain sites, it puts a space at the beginning of the field which causes problems with sorting. Is there an easy way to remove the space in front of the data in the cell? Yes, that is a great question. I hate when that happens. And do you remember when I showed you the indent and decrease where you can decrease the indentation here? So I'm going to show you. If you have information, you have text, and it's maybe you're saying that it's like this, once you download it. There is a way, let me show you, there is a way if you see indent, I don't know what's not, you're able to move it over. I don't know if you were able to see that. The other thing that you could do if you are downloading information, sometimes it also actually depends where it's coming from, and how are you uploading it? Can you give me just a little bit more information? Because there may be another trick to removing those spaces for you. Okay, well wait, let's see, for Heather to let us know. She said she's downloading the data from a brokerage site. So I don't know if that's something we can address right now. But what she can do is provide my email address, because I'm interested to see where the data is coming from and how she's actually uploading that information. Because there may be a couple of tricks that I can help it with, but I'm going to have to see that. Is that okay to just say Heather? Is that okay Heather? Heather will reach out to you after the webinar to help you. She said yes, thanks. Okay, so I think we only have a few more minutes. So if you want to finish up and then we can try and tackle this. I do, thank you. Now I want to show you, so let's fix this. Yeah, because you want to avoid from doing what I just did, right Heather? It was like this, and you want to avoid doing this. Yeah, I can definitely help you. We'll connect offline. So I want to show you before we leave, I need to show you the sorting and the filtering. Because like I said, the goal was we had this information, so now we need to sort it and move forward with what we need to do with our data. So what I want to do, I know that I showed you a way to identify using conditional formatting. I also want to show you how to use the filter. So to filter information, you want to be in the row, typically in the row of your header. You want to have a header that really helps you to easily identify a sorting filter. And so you want to come here, do you see sorting filter? And let's filter. And as you can see that problem, those drop-down buttons for us.  And if you notice if you select this drop-down, it's only showing me the amounts that are listed here in this spreadsheet. So there are only four amounts here. So I can filter my spreadsheet by selecting all or just deselecting the ones that I don't need. So I want to look at, let's look at the 250. And so now I have a 250. I have a spreadsheet that just shows donations that were $250. And do you remember how I said we would start out with the master list and then move over? So what we could do is, I'm going to go back and I'm going to clear the filter for just a moment. And I actually need to, let's see if you all remember how to do this agenda. This is now the master. And now this can be sorted. Aha, take a look at this. This is definitely a bonus. We'll come back to this. So this is our master information. Let's just add a sheet. Did you see just added a sheet? And we are going to name this. Let's name this, this is our president. I'm just making things up for purposes of this demonstration. But we're going to call this the president's circle. And that was for donations that were over $100. So now I can go here. Let's filter this again. And I just want to work with the information for $250. I'm just working with these donations. And so now I have that here. So what I could do is to copy this. And then I can go to now, have a tab for my president's circle and I can paste my information here. And so now I have master. All I can do, what I can do here is clear this. So here's all of my raw data. And now here is my president's circle. And so what we did was we filtered from here, sort and filter. That gave us the drop down option. And we took that information and placed that here. And the reason why I always recommend you doing this is because now you have your raw data and now you have the information that you need to work from whether that's sending emails or whatever the case is. Do we have any other questions? All right. I think one thing that I think might be useful is you can freeze the pain at the top. I think that's a great trick for people to know when they're sorting through their data. Yes. So that is actually one of my favorite things because what I used to always say is, again, I know that the information that you are working with is so much more expansive than what's before you on your screen. And so can you imagine if you are at row, let's just imagine this is 860. And if your content goes all the way across this workbook, I know for me sometimes it's hard to remember, wait, what's this header? Is this the amount they gave? Is this the amount they promised? What is this? And so then you have to scroll all the way up to the top to find out what that header is.  So what you can do, great question. What you can do is you can come up here to view, freeze pains. And what I like to say is that it really does, it actually freezes your pain while you're working on your spreadsheet because you're not having to scroll up and down and figure things out. So you can do freeze top row. So if you freeze the top row, now regardless of where I am, that is still there. The other thing that I can show you, now this is freezing the top row and we did this from view, freeze pains. Now another thing that I can show you is, let's say for instance you just need to focus on the email addresses here and not necessarily you're not concerned with the address or how much they donated. What you can do is if you select the column, you can right click and then you can hide it. So that way now you've not deleted the information. It's still there. It's just hidden. As you can see we went from column B to column D because C is hidden. And to unhide it, you can select these two or select where the column is hidden and now right click and you can do unhide. So it's still visible. It's still there. So I want to answer the question as far as what happens when you get ready to print and it's just not right. That happens all of the time. So I always recommend before you print, before you print, always click on Page Break Preview. That's just rule of thumb. Always check Page Break Preview. A little tongue twister because what you will see is this bold blue line. You see that here? This is what is called the Page Break. This is where the page breaks. And you have the control of where it breaks. So I'm going to show you something. So I'm going to go to Home. I'm sorry, I'm going to go to File and we're going to Print.  And you can see based on this preview the donations are missing. Do you see that? The donations are missing. So what I'm going to do is I can go back to View, Page Break, and I can move this. I can just move this over. And this is another Page Break here. And I can move this as well. I can move it. And all I'm doing is putting my mouse over the blue line.  Do you see that? And now I'm able to move. I'm able to maneuver that and manipulate that a little bit. But this is going to be key. The other key is when you go to Print here, all of these other different options. The Scaling option, because I know this is very important for a lot of organizations that have a huge data set. Please know that this option is here for you where you can actually scale to see these options. Fit Sheet on one page. Now keep in mind if you fit an entire sheet on one page that the text could be very, very small. And I can show you what that looks like. Do you see what that looks like? So depending on how you need the information presented, depending on where the information is going, that actually may be okay for someone. But I know that, again, there are a lot of different ways and reasons that we're using Excel and the outputs and everything that we have to do. So just be mindful of that. You do have those options. This page break, you have the option to scale the page. So I hope that answers that question. It does. So I think we have just about five minutes left. So if you have any closing statements for our audience, we can let everyone go back to work in just a few minutes. That sounds very exciting. So you got a little sneak peek of what I wanted to give to you today. And this is just my little handy-dandy shortcuts. I told you that I was going to get to it. And so here we are. And yes, you will receive this. Do not try to screenshot this. Don't try to write this down. I promise we will make sure that you get this in your email. So these are just shortcuts that when I was starting out using Excel, and I knew that I couldn't Excel at Excel. And these shortcuts really helped me again. If you have a Mac, these would be slightly different. These are all PC-based, but I will work on getting something for you for those Mac users. So again, thank you so much for joining us today, Seema. Thank you so much for facilitating the chat and working with all of our learners today. It is always always always a pleasure to be able to engage with you all. And it's just really great. So I want to now have a quick question. Would you be interested in a Part 2 for Excel for Beginners? Would you be interested in Part 2? Are you ready to dive a little bit more into formulas? Because we can go deeper. We can go deeper into exporting. Would that be of interest to you? Are you using Excel spreadsheets on your website? How are you using it for financial things? All of those things. So let's see, who wants Part 2? I can skip to a result. I believe.  They are almost 100%. So that is awesome. So then that gives me work to do. I will have to put some things together so that we can have a Part 2. So because you expressed interest in Part 2, be sure to complete the post survey after this webinar because that is how you can give us feedback. What is it that you want to know in Part 2? There are some things that I could have gone over a little bit longer for you, or some things that you could have cared less about. So we want to know. So again, thank you so much for joining. Thank you, Seema. All right, so just a few final thoughts before we go. If you want to go ahead and share one thing that you learned today in the chat box, it's always fun for us to kind of see what was helpful for you today. And then also we have a post-event survey that Lashika mentioned. So once you log out of the webinar, you should be able to see that post-event survey. And any feedback that you have really helps us, and it can help us decide what to talk about in our future webinars. So if you could take a few extra minutes to let us know, that is always great for us. And then if you are on social media, Facebook, Instagram, and Twitter, we try to post helpful tips and tricks there as well in addition to general updates of the work that we are doing. And then also we have a blog, blog.techsoup.org, where we also try to post valuable information that will help you run your nonprofit a little bit better. So if you have any interest in joining us for our upcoming webinars, we have one on 7.10 which is about getting rid of storage and moving to the cloud that is hosted by Amazon Web Services. And then we have a library specific webinar on the 17th about moving to HTTPS. So please join us. And then we have all of our webinars archived on our website. So this one will be hosted there in addition to the other ones that we have done in the past. So please check it out if you want some additional tips and tricks. And then lastly, thank you to ReadyTalk, our webinar sponsor, and then also to LaShika who was super helpful today. And I said she was a wizard so hopefully you agree with me. And thank you all for joining us today. See you next time.


Hello there, it's Sandy Olnock, and today I have a never-ending sketchbook to show you, and it's never-ending. It kind of keeps going around and around. There's pocket areas that you can tuck something into, like seal the pockets and put treasures in if you want to make one of these. I've made one for a specific purpose that's going to prove to you I don't always follow my intuition well, and at the end of the video I have a giveaway, so be sure to stay tuned at the very end to find out how you could win a seat in a class for free. So the first part of this video as I said is something that I learned about trusting my intuition. I had a pen on the way, and the pen I didn't know anything about, the company or anything, but somebody emailed me and said, hey would you like to try our pen? And you know me in fountain pens? I love me a fountain pen, so why not? So I got out some mineral paper that I've had for a while and I made a little mini sketchbook, one of those kind of never-ending sketchbooks because it has stuff you can do on both sides and the way that it flips, you fold it in half both directions and then fold each of those halves in half. I was doing this with gloves because I didn't want to like wreck the surface of the paper. This is a mineral paper and I haven't played with mineral paper like folding it like this in a while. I've done stuff in sketchbooks, but I didn't want to get the oil from my fingers all over it in case that caused any problems with the color that I was going to put on because you know me, I'm going to do my color first and my inking second. So I decided to wear gloves, but once you fold this thing as I'm showing you here, it's really easy to just do some quick trims. So you take one side of it and trim three of the boxes.  You want them to be connected and that's what this is going to give you. So you have one piece and when you fold it every other one, it starts to turn into a tiny sketchbook. Now I have done this with a full sheet of watercolor paper to make sketchbooks for classes. So this is a technique that many of you will know because of that, but I decided I wanted to do a small one because I wanted to put a pen through its paces. So I needed something to do it on and they asked for a video in a time frame that I wanted to make sure I met their time frame. They were going to be so kind as to send me a pen. So I've got my sketchbook all done inside. Okay, now it's time to add color. So I used a bunch of different mediums to just see what would happen. I used some alcohol inks and just dropped some ink on. I was trying stuff because at the end of this video, you'll see I have something else going on that I was going to need some alcohol ink stuff for. So I wanted to kind of get back in the swing of it. I haven't played with alcohol inks in quite some time. So this seemed like a great way to kind of knock out a bunch of projects at once, test a pen, play with the alcohol inks, just let them kind of float around on the paper. And on a sketchbook like this, I didn't really want to use my airbrush to move things around too much just because it's so small. And I wanted to have some consistency across maybe, I don't know, I wasn't thinking real clearly. I just wanted color on there. So I could start doing all kinds of fun stuff to it with the pen. So I got out some acrylics. And there were a couple of panels I did in acrylics. I even used some thick acrylic paint you can see in that top one with some shimmery shiny color. And I use bubble wrap on this. I just went crazy. Anything I could find in the studio, I made a mess with. I was reminded, of course, of the fact that distressed inks are water based and distressed oxides are water based. And I had to wipe off most of the color by the time I was done or else it would never dry. But it was fine. I mean, it was just a reminder to me. Sometimes when you don't use something for a while, you just need those reminders. I decided this, I'd try it like a Halloween kind of panel with some orange and black and see what would happen using a baby wipe to blend the colors. And just seeing what would happen. But remember that all of this is going to have to dry. So I ended up putting together the whole book, right? I've got all this color on here. I'm ready for the pen. Let's get here, watch in the mailbox to see when it arrives. But you can see I've got all kinds of fun things. A book like this has pockets. As you can see, I'm kind of flipping through some of them. So you can see there's panels underneath the panels. So you can do all kinds of fun stuff with it, seal the pockets and put things in them, etc. So then the pen arrives. And this is the box that it comes in. And I looked it up on Amazon, and it's about $30, I believe, for the set that they sent me. And I say a set because it has two nibs in it.  And I trusted my intuition. Yeah, just send me this thing. But I was not really impressed with this. Yes, it has a little baggy for the pen. Maybe that's a nice add-on, I don't know. But it just didn't feel quite great. The nib is not a proprietary nib. It's just a generic nib. And it's not a bad nib. But okay, fine. That's the extra one. And then the pen, when I started twisting it to try to take the cap off, the back came off with the piston converter inside. So I put it back on and, you know, realized it's a pull-off lid. But the pull-off lid has this other plastic lid inside of it, which we will get to in a moment. And the other nib is kind of an interesting shape. So I thought, oh, okay, I at least want to try that interesting shape and see what's up with it. I could have filled that thing with my own ink, but I decided to use their inks, these little refills. And you have to press it in really hard and kind of poke through one end so that the ink flows and screw it back on and then see if it writes. And this one wrote okay. It wasn't great. It wasn't a huge, ginormous, wonderful experience. It was just okay. The pen is very lightweight. But the other nib, I could not get to work. I tried three different refills on it, and I could not get it to work. And I was kind of frustrated, so I didn't even bother adding my own ink to the piston converter because the piston converter is broken. It has like a loose spring in it. And then the cap.  And unfortunately, it's useless as a pen. Like the cap does not make me happy. So sadly, I said yes to a pen without doing my smart thing, which was going with my gut. And my gut generally says, when I get emailed by some random person and says, hey, do you want to try one of our supplies? I like to do my research a little bit more, or at least have heard of the thing before necessarily trying it. And I did not do any of that. I just said, yeah, okay, fine, send me a pen. And that was a waste of their money, a waste of my time.  The Peter Pen I used a few weeks ago, and I had some mixed feelings about like a stop start that it would do on occasion, like it would just every 20th line, it would just have an eighth of an inch hiccup that it just needed to get past that. And then it would write fine again. That was the paper pretty clearly because this one did just great. I was able to just blast through this and do wonderfully and be really careful, of course, as I was going because touch wet ink on this paper, it takes a while to dry. I had a few smushes and had some cleanup that I had to do, let's just say. But the Peter Pen passes the test. It is more expensive than the Twizby Eco that I generally recommend. And I wouldn't necessarily say it's a better pen than a Twizby Eco. Aside from the fact that it's heavier pen, it's just got more weight to it. So if you're looking for a pen that has weight to it, this might be a good option. So I will leave a link in the doobly-doo to that so you can check it out if you're interested. But trusting my intuition was something I did not do in the just blindly saying okay to this company about sending me a pen. But I got right back to it when I started doodling because I've had some people say, hey, how do you just do the doodles? How do you just make stuff? How do you just make the lines? Because my stuff looks like a kindergartener did it. Well, I'm just going by intuition. I'm not thinking about very much. The only thing that I'm thinking as I do this is are there places where I can create some motion? And I want to create something that's different between one panel and another, or some connection between one panel and another. But that's really all. I am not thinking, okay, I should make a line here. Okay, should make a line there. I am just going for it. I am tracing around shapes that I see. And it's only in between some of those areas when I'm trying to figure out how to transition from one color to the next, or I get tired of making one kind of line, tired of making bubbles so I start making swooshes and get tired of making swooshes and start making straight lines and kind of bouncing around between different types of lines. But if you think about it too much, that's when your lines get stilted. If you just look at the character of the color that's underneath, and that's what I was looking at here. I was looking at some more ethereal kinds of color, some soft cloudy distress oxide inks versus some really hard edges that were in others where you could see the color flowing on the paper. And trying to capture that characteristic in the lines that I was creating, but not in like every line is going to be a character building type thing. But it was just going to be something where little by little I could I could build a piece that went from one end to the other and each one of the panels kind of connects to each other.  Peter draws is the guy who I got my fountain pen fetish from. And he accepts mail and he opens mail on YouTube and everything. And I have never sent him anything. And I thought it'd be kind of fun to send him this drawing that I have done with his Peter pen since he makes money off his Peter pen and I like to support artists that way.  I wish I had thought ahead and done a better flip through in the first version. Instead, I got hung up on showing the pockets like where the book flips the other direction so that I didn't have these two lined up. But you know, sometimes best laid plans of mice and men don't work in video. But I hope Peter will like it. Hope he'll be excited that somebody's using his pen to make some fun doodles. And for the giveaway, we are finally at that part of this video. I am going to be teaching in the gratitude junk journal class again this year. And I have a seat to give away. So to enter that giveaway, you need to comment what you're thankful for this year, but do so using the word grateful. If you don't want to be in the class, if you're not going to take the class, even if you win, then use the word thankful and tell me what you are thankful for this year. And I have been working in my journal already. This one is one that I made. I'll show you on Friday how I made it. And I am using alcohol inks as much as I can. I'm just exploring techniques and seeing what does it take to make a stencil work, etc. This page was all about my aunt and it was very therapeutic as I'm grieving her loss. She was a writer. She wrote stories, lots of romance stories and Christmas stories and Christian stories and just those chicken soup for the soul things that are fabulous. And I just miss her so much. So it's great to do a page about her. This is the one I'll be doing in class. So if you want to learn how to do this, learn the layering techniques that I did on the grapes or some of the fun that I did with the stenciling, then join me in class. Just have some flower stencils and whatever medium you want to use at hand. And that is about it for me. Just don't forget to leave your comments if you want to be entered into the drawing. And if the class is available for pre-registration, I'll put the link in the doobly-doo. But I don't know at the time of filming this whether it's going to be available quite yet. All right, I will see you guys later. Take care. Bye-bye.


I feel like you were in trouble off the bat there. No, I felt like I made some quality pitches early. Just didn't get the calls. So then that happens. Then to their credit, I think they control the strike zone pretty well tonight. So that's what good teams do. So then they kind of made us pay for pitches we left in middle of the plate. So yeah, but I mean, one of the crazier games I've been a part of and Hicks made one of the best catches I've ever seen. You take me through as he's trying to track that ball down. What are you thinking as you're watching it all unfold? I mean, I thought he got a pretty good beat on it. I thought he got a great jump. And it kind of stayed up just long enough for him to cover some more ground and make a great catch. So I mean, I was just obviously relieved that the game was over at that point. What did you say to him when he got back to the end, Joe? I mean, just great catch.  I mean, I think everybody at that point knows what was on the line. So there's really not much to say. When you see a catch like that, do you let out a sigh of relief, do you jump for joy? What was your first reaction? I just put my arms up. I'm not a picture to show much emotion. And that's one might be the most you'll get out of me. But.