It went live on MySys. OK, yeah, I hit it again. But it failed to go live the first time. And when that happens, we usually have problems with it on the YouTube archive side. So here's to hoping. It's crossed. Yes. If you can see this, Google didn't add the video version to the podcast or anyway. Chirks. Oh, they did it. Is it only audio? They have the, so Sean, who does our video feed, submitted it. And it's there. But it only has the audio episodes that he adds to the feed because Peter doesn't do a video version for day six. So that's the only ones in there. So it says DTNS video, but there is actually no video. And it's only like two, three episodes. That's weird. It's like it's not herding their servers. It's a, yeah. They'll probably add it eventually. They just, it's part of Google Music. So I think what they're thinking is like, let's just do audio first. We can roll in video later. All right. Not very auspicious. We don't have to talk about it now. We just talked about it. That's it. That's the story. Next. All right. Yeah, right.  You blew the show. The only story in the show. As usual. So one of these days, you know, OK, there's the, I don't think it's necessarily untrue, but I think it's a truism that the Inuit have many words for snow because there are different types of snow. I would like someday to create many different types of news days, like words for the different types of news day. Because sometimes there's like, the rarest news day is the one where like it is really obvious what, like there are eight stories and everybody's on them. And it's like, that's it. There are, that's the stories. There's no question about it. When there's days where like, TechMeme and Google News don't even have the same, don't have any of the same stories up, and it's just like all over the place. Like nobody can agree what the stories of the day are. Those are pretty rare too. Usually it's around like four or five stories that everybody's like, those are the big stories. And then there's like a smattering of other stories. Today is one of those days, like four stories. And then on the tail, after the four stories, sometimes those can be closer or wider. Yeah, I was looking at Apple News this morning. It's on my tablet. And I didn't see most of these stories on there. They were, it was all they're not. Oh, one of the Apple News app, you mean? Yeah, yeah, so you write about the smattering. It's just a different, yeah. Yeah, yeah. Every feed has a different take of what they feel is important, I guess. Yeah. All right, well, speak enough. But we should probably do the show. Oh, yeah, yeah, we have a show to do. Yeah. Thank you for being here, Lamar. You're welcome, sir. Oh, I thought Netflix was doing their earnings tomorrow. Roger, can you just, like, I'm going to put the links in. Can you just flesh out the actual numbers? I'm just going to. Yes. Thank you. That made Roger sound like he was in a booth somewhere with a cough button. I was like, is that Roger Bot that you have there? Yes. That is Roger Bot. All right, I am almost ready to go. After I just said we should go, we should definitely go, and then I didn't go. No, bro, I was going to play with my little BB-8 here. Hi, BB-8. You watch Force Awakens with that? I need to watch it tonight with us. All right, here we go. Good day. This is The Daily Tech News Show. I'm American, and this is my best attempt at an Australian accent. If you'd like to hear a real Australian accent, go to dailytechnewshow.com slash support and pledge an amount so Peter Wells can do a sixth day of DTNS. Shrimp on the Barbie. This is The Daily Tech News for Monday, April 18, 2016. I'm Tom Merritt joining me today. Showcase-er and entertainer, it says here. Lamar Wilson, how's it going? I'm going good. Yes, I put my own title in there. I like it. Yeah, like, why not? Why not? It's good to see you, Tom. Yeah, it's good to see you, too. Veronica Belmont has the day off again. She will be back, though, I promise. But we're very happy to have Lamar. Because we don't get enough Lamar Wilson on the show, so I'm excited. An Amazon video is now available on its own, which is weird, and we're going to talk about that. It is, yeah. It's intriguing, right? It's very intriguing, and I definitely have some opinions about this. All right, well, we are going to get to those after the headlines. Here are the basics, though. Amazon introduced a $10.99 a month payment option for Amazon Prime. Now, that's not only the video, but the Kindle lending library, and the shipping, the two-day shipping, and all of that. There's also a separate $8.99 a month plan for just Prime Video. That's what we were just talking about. These are available in the United States. Now, Amazon UK already offered Prime Video separately for £5.99 a month, but they're going to start promoting that a little more. There is no monthly Prime shipping option in the UK yet. The Verge notes that Amazon started offering Sprint customers a monthly Prime option last month. That may have been a little bit of a test here. But yeah, that's what we're going to talk about, because Amazon, I don't know, feels like they've got a little incubator going on with Amazon Prime. Yeah, they're always very mysterious. So we definitely want to pick their brain a little bit as much as they let us a little bit later. You should pick the brain of Siri when you want to as well, because occasionally she will break news, apparently. Oh. That when you ask Siri when the WWDC is, sometime this morning, it started responding June 13th or June 17th in San Francisco. Apple has not yet confirmed this or posted it on its website. At least it may have by the time you hear this, but it hadn't by the time we started recording. So an interesting way for Apple to kind of leak out the dates. Kind of fun, very fun for Apple. I mean for Apple. Yeah, well, who was this person that was sitting there probably every day asking Siri when WWDC was? It's funny, someone on Twitter earlier this morning, like way earlier in the morning, Eastern Time, had posted a screenshot with Siri saying, I don't have that information yet, and wrote worth a try. And then later in the day, they were just, that person was just a little too early. Ah, okay. Let's see if they answered. When is WWDC? The Worldwide Developers Conference, WWDC, will be held the 13th of June through the 17th of June in San Francisco. I can't wait. Yeah, I think the most important question here is, why is your guy British, and why don't I have mine to be British as well? Yeah, well I think the second question is really the answer to the first. Yeah, I need to fix that immediately. Why don't you have yours set to be a British guy? That is amazing. The US Supreme Court declined to hear a challenge from the author's guild to a decision that allows Google to scan books for its online library project, Google Books. That leaves in place the October 2015 ruling by the Second US Circuit Court of Appeals in New York that the project was quote, at the boundaries of fair use. Google Books scans books in order to index them and then makes small excerpts available of just the page or portion of the page that your search terms apply to. Publishers can request that even that excerpt not be viewed, but the idea is to push people into buying the books. Google has always said, look, it's fair use for us to scan these to make an indexable database of it. It would be copyright violation to display the whole books, but that's not what we do. Author's Guild has taken a hard line on it and they've lost. Yeah, you know, this is an interesting thing because I totally like this idea. Someone out there has to archive our history and our writings. And I know you're author, you may have a different opinion, but I really feel like this is a good thing on the surface. And from what it sounds like, like you said, they're not giving like the book for free. I mean, you still have to pay for it. But I think the idea of scanning, let's say wartime happens and all of our things get destroyed. I mean, we've seen many movies like that. At least we have this archive of all of our great works. I don't see a problem with it for some reason. I would have preferred that Google team up with archive.org whose stated purpose is to be the library of the internet. Archive.org has their own book scanning procedure and this decision will help them. But that's neither here nor there. That's not about the law. That's just about, oh, I would like to see those two team up on this. But Google definitely had the right to make this database the same way they have the right to make a database of indexable search engine results for the web. So as somebody who, you know, I've just done self publishing, but I give away my books. I give them for free with a Creative Commons license because I want people to read them. At the same time, I can understand where there are definitely cases where a publisher would not want them given away for free and what Google's doing is trying to help expose people to books that they might then want to buy. I think the author's guilt just didn't like that they couldn't make money off of all parts of this. YouTube launched a live streaming 360 degree video and that's at NAB where my wife is because she works for YouTube. Monday, support for spatial audio was added for on demand 360 degree video. That's where you can tell which direction the sound is coming from. Select concerts from Coachella will be streamed in 360 degrees this coming weekend. Google also launched a live API for adding the streams into an app or service, though it's limited to makers of 360 degree cameras at this point. Yeah, so to be clear, 360 has been around for a while on YouTube, but this live edition is really interesting and I think for a place like Coachella or any other type of event where the audience themselves can choose what they want to see, I think it's a great feature, it doesn't hurt anything. I mean, YouTube is not going to do any kind of VR or AR list for a while, so they have to have some kind of extra gimmick to get people to stay on the site longer. I tell you, when I get in a 360 video, I'm there the whole time because I'm just being nosy, looking at every part that's going on. Well, I was just a good idea. Eileen and I were watching the Coachella streams this weekend and of course they're going to stream again this coming weekend and so there's one reason why I might watch again some bands that maybe I already saw because I'll get to play around 360 degrees, but also there are always somebody doing something in the audience where they take a quick shot of it and then they cut back to the stage and you're like, wait, what was that person wearing? What were they doing? And this way you'd be able to just go back and take a look. Yeah, yeah, good idea. CBS 60 Minutes on Sunday showed off the well-known but not widely exposed ability to use Signal System 7 or SS7 to intercept phone communication on a cellular network. This isn't really news, or at least it shouldn't be, German security researcher Karsten Null demonstrated the flaw at the Chaos Communication Congress in Hamburg back in December, 2014, but this has certainly put it in front of a wider audience of people, including a congressman. Yeah, I can't actually tell you how terrified I was to read this article because I didn't, I mean, we know things like this is possible to actually read that they only need your cell phone and they can get a ton of information and the actual carriers are just pretty much worthless in a scenario. Well, it's honestly not as terrifying as it sounds, although maybe it's because you don't think the internet is as terrifying as it should be when I say you, I mean, the wider populace. We are very concerned with encryption, an end-to-end encryption on email because right now if you send email on the internet, you have to assume that anybody along the chain could take a look at it if they really wanted to. And all this is saying is, same is true for your phone conversations out there. Right, and it was interesting, which I was looking about these apps. Now we know iMessage is person-to-person encryption, but I've always thought Facebook Messenger wasn't, I was, and it's not. And some other apps, even WhatsApp is not 100% encrypted yet. So I think we're gonna see a rise. This recently did become end-to-end 100%. Is it 100% now? Yeah, yeah, yeah, that was just last week, actually. Oh! It was for messages, but not for voice, and now it is for everything. Okay, I wanna check them out if you wanna have a really private conversation. And they're using the open signal protocol, which by the way, signal is probably your best bet if you really wanna have a secure conversation. But WhatsApp has more people using it and uses the same protocol that signal does, so there you go, it's not a bad choice. Google has launched its podcast option in Google Play Music, according to the company blog post, the service is available in the U.S. and Canada on both the web and Android. It is coming to iOS, but it's not there yet. Creators interested in making their podcasts available on Google Play Music are urged to visit g.co slash podcast portal. So I have some thoughts on this. So remember when, I feel like Google, like what took them so long? That's really my question, because they're the archive of everything on the internet. I know archive.org technically is, but do you know what I mean? And remember they had the app called Listen on Android? Yeah, it was kind of like a 10% project for one of the people and it got discontinued. But I've always wondered why Google allowed Apple to kind of have the sole product with iTunes. Apple, in my opinion, doesn't even want it. They don't like podcasts, they can't monetize it. You can put as many ads in there as you want. The podcasting section of iTunes might disagree with you there, but it's... I don't think they like podcasts at all. They take forever to make the apps for the Apple TV or make them good. Yeah, it just seems like it's not a big priority for their business. It's not as much as you might have thought it would become. And I think it's the same cause in both situations, which is you have people assuming podcasts are dead multiple times throughout podcasting history. And in fact, Google kind of let Feedburner just burn away. It's still working, but it hasn't been really actively developed in years, and now suddenly podcasts are back with Avengers again. And I think that's what's going on, is Apple's interest in podcasting is rekindling from what I can tell. And we have yet to see that really happen in public, but the podcast app coming to Apple TV I think is one instance of that. And Google, obviously, is getting back into it, like, wow, I guess we should have been paying attention to this. It's podcasting wasn't dead, so it's a good step. Interesting. Yeah, it'll be interesting to see if either company, I know we're primarily talking about Google here, as they will try to monetize this somehow.  Yeah, well, I mean, they want you to pay for Google Music, which is $10 a month, but that also gets you YouTube red. And it also gets you the, you know, dropping the commercials on YouTube, et cetera. So it's all kind of similar to the strategy we're gonna be talking about with Amazon here. Interesting, that's a good point. Now, and one other thing to point out too is video is not part of this. The DTNS video podcast is subscriberable through Google Play Music now, but it is just the audio podcasts. It is not the video podcast, and you may be wondering why there are audio podcasts at all, Sean who volunteers and does the Google or does the DTNS video subscription feed puts the audio versions of day six with Peter Wells in there because there is no video version of those. And so those show up in Google Play Music. Okay, wow. But not a thing. And also, if anyone ever doubts that when I say that even though my wife works for a Google company, I don't really have any influence over there, go look at what they're promoting on the technology page of Google Play Music. You won't find DTNS. GameStop announced its new project called Game Trust that's going to publish new games. Game Trust will focus on marketing. They'll leave the creative process to the actual game developers, but they will work with game developers. Insomniac Games, which by the way, announced two new VR games today. And Insomniac Games will do Song of the Deep, a Ratchet and Clank title. That'll be the first Game Trust title launching this summer on PS4, Xbox One and PC. And Game Trust will also be working with Frozen Byte to Key to the Works and Ready at Dawn as well. Are you into gaming a lot, or are you? What's your? Question fraught with so much peril these days. Because if I say yes, then I'll be accused of, no you're not because you don't play this often or this much.  Yeah, I guess I was asking because I wonder if you're surprised at this announcement about games. It seemed like GameStop has to do with this. It's the natural evolution of securing their name in the business in the next five, 10 years by offering marketing services. It makes sense. I went into a GameStop a couple weeks ago. It was full of people, had games for sale. But you can see that they are definitely, they have lots of displays talking about their online products. They are definitely moving into a showroom mentality of sorts. I think they're doing it well, which is like, they're not stopping selling used games. They're not stopping selling consoles. But they're saying, look, if you are someone who loves video games, we want to be the place you want to go when you're at the mall to entertain you and maybe offer you something. And so being able to provide games like this, so when they come to the mall, maybe you go into GameStop and you play these games and you order them, but you don't necessarily walk out with a physical copy of them there. It still is going to work for you.  Yeah, actually, sounds good. I have no complaints here. Yeah, how about this? Maybe you'll move to Australia. The Australia Post will begin making test deliveries by UAV, aka drones, to customers' homes later this year. Packages will include medication and online purchases. Australia Post has completed successful field trials for small packages. So they're forging ahead. They're going to start delivering stuff by drone. I kept saying to myself, wait a minute, what does UAV mean? And I was saying unannounced aerial vehicle. I had to look it up, unmanned aerial vehicle. The University of Antelope Valley. No, it's unmanned aerial vehicle. Yeah, I was just trying to figure out what that stood for before the show started. Yeah, you know what I got from this article was interesting thing about Amazon, who we'll talk about in a couple of minutes, is that when they tested it out, the maximum range was only 15 miles, which I mean, 15 miles is a big range, but it was just interesting. I always thought these things would go much further. So in Australia, everybody's spread out even more. So they were saying there's probably can only be limited to the major city areas. Yeah, at least at the beginning, it's only going to be in the metro areas. But yeah, I mean, drone range will get better over time. One would assume so maybe someday. I like it. Not all the drone news is good though. The pilot of a British Airways Airbus A320 en route from Geneva and landing at London's Heathrow Airport reported something struck at the front of the aircraft during landing, and the pilot believed it was an unmanned aerial vehicle. UK Civil Aviation Authority said that the operator of the drone could face prison time if they can determine who it was. That's a big if. Yeah, this is getting, it's gonna get worse and worse. The article mentioned they need a sense of kind of geo, well they believe it's called geofencing where the drone just cannot go past. It's like it just won't let it register your drone. I think that the fence is probably better than the registration fence, because I don't know, are some of these toys, like somebody should go buy a tourist, right? Like how would that work? Yeah, and you don't have to register under a certain weight, but even if you have registered your drones with the FAA, it's gonna be hard to tell what the drone serial number was from an Airbus A320. So I'm not sure how practical that is in hunting down the operator anyway. Good point, good point. The better thing would be preventive measures. Yeah, more education, and I think the geo-fencing is a good idea to say, hey, voluntarily, companies should turn this on and until we have a regulation that requires it, but yeah, you or UAV should not accidentally be able to fly into airport airspace. Absolutely. EU Land Trust Chief Marguith Vestiger said on Monday that her department is investigating complaints of Google's exclusive contracts for Android phone makers. Reuters sources say it's gonna be creating some charges here pretty soon, maybe even this week. The contracts in question require phones that carry the Google Play Store to install a suite of other apps. A Google spokesperson told Reuters that the company does not force phone vendors into exclusive contracts, but that's what's being investigated. Vestiger said she doesn't mind that Google bundles all their apps together and says, hey, if you take the Google Play Store, you gotta take Gmail and Maps and all of that. She says the problem is the exclusivity of the contract that says you can't sell any other versions of Android. Oh, that's what the issue is. Okay, I was trying to figure out what's different than what they were doing, but yeah, that's an interesting twist on it. Now Google says it does not force phone vendors into exclusive contracts. That's different than saying we don't have any exclusive contracts. Right. You're not forced, but hey, that's a nice lamp you have over there. Right. And here's where I go from one side to the other. I think it's fine. Android's an open source, right? It's fine for Google to say if you wanna put Google on your phone and if you wanna have the Google Play Store, you gotta take these apps. I think there's nothing wrong with that. That's a fair deal. If you don't want it, don't take the Google Play Store. That's fine. I do think though that it is a little bit, especially with the market dominance that Android has, I think it's possibly antitrust to say, and you can also not sell any other Android-based operating system. And I think that's a problem. Okay. WeChat Enterprise 1.0 version launched Monday. It's available in Chinese for iOS, Android, Windows, and OS X. Employees can use it for chat. Things like reimbursement and vacation management. They can make calls with it. Companies with official business WeChat accounts already can take advantage right away. Others will need to register with an official Chinese business license. But Tech in Asia is calling it WeSlack because it's essentially like the Slack client, but for WeChat. Okay. I've never even used WeChat. Is that something that's even available here? Yeah, you can use WeChat in the US. It's not terribly popular over here. Have you ever used Slack, though? No, I haven't. Well, there you go. So this story... I'm not an interesting person, Tom. No, yeah, but I don't believe the interestingness of a person resides in their level of familiarity with either WeChat or Slack. But you might want to check out Slack, for sure, because we use it for DTNS, and it's pretty good at helping people plan stuff. I'll invite you in. Okay, got to do it. IBM reported a 4.6% decline in quarterly revenue. That's for the first quarter ending in March 31st. Revenue was $18.68 billion down from $19.59. This is the 16th straight quarter of revenue decline according to Fortune. That income fell to $2.01 billion or $2.09 a share from $2.33 billion or $2.35 a share. And Netflix reported $0.06 a share earnings on $1.96 billion in revenue for Q1. The analysts were expecting three cents per share on $1.97 billion. So they got close to matching revenue and definitely beat earnings per share. Netflix also reported 4.5 million new international subscribers for a total growth of 6.74 new subscribers in Q1. It had forecast $6 million for Q1, so pretty much right on there, even a little above. Yeah, they were actually down in stock about 4% because of the Amazon thing, so it's good to see maybe they'll pop back up now. Thanks to Abitua La Condulce, Jason Phil, and all those who submitted things from our subreddit, submit stories, and vote on them at dailytechnewshow.reddit.com. That's a look at the headlines. So I thought there was a really interesting take on this Amazon Prime video story from Romain Dillette from TechCrunch, calling Prime a subscription launchpad. Now here's why. When you subscribe to Amazon Prime, I'm gonna talk about the US package. It varies at different parts of the world. Amazon Prime in the US gives you two-day shipping for free. It gives you Kindle Lending Library, which is different than Kindle Unlimited, but it allows you to check out one book a month.  So what they've done now is say, okay, well you don't have to pay 99 bucks a year, you can do this on a monthly basis, 10.99 a month. That would turn out to be $131.88 a year, but maybe you're not sure you wanna pay for a whole year yet, so you just try it out for a couple months before you convert to yearly. And then if you're just like, you know what, I don't buy things on Amazon, I don't need shipping, I don't read eBooks, I just wanna watch Mozart in the Jungle. Well you can do that now for $8.99 a month, that's $107.88 a year. Before we get into the wider platform here, what's curious about that Lamar, $8.99 a month looks really cheap. It's actually more expensive than it is now for the entire Amazon Prime thing, but if you just want the video for $107.88 a year, you look cheaper than Netflix, which is $9.99 a month, or Hulu, which is $7.99 a month with commercials, but $11.99 without, and Amazon Prime has no commercials, HBO's $15, Showtime's $11, even Starz is $8.99 a month. So it feels like that is the reason for this Amazon video-only subscription is to compete with those. No, I think you're right. And it's interesting, the unbundling of that. Not just on this article, but I've read comments in the past with people who have said, look, I don't like yearly subscriptions. I would rather pay more, so I have control each month of whether I want to pay it or not. And so there is a market out there of people who understand that it's gonna be more expensive in the long run, but they like the idea of having their budgeted thing per month to deal with. And so Amazon is very wisely catering to both customers in that scenario. Yeah, I've lived month to month at points in my life. I know what that's like, where you're like, no, I'm not paying $99 for a year. I can't afford that, but I'll pay for this month because I know I can afford it this month. So that's good. I think what remained a left from TechCrunch, and apologies to remain if I'm butchering the pronunciation of your name, but I think you have a really good point here, which is, yeah, there's the Kindle Lending Library, when you check out one thing a month, that might lead you eventually into Kindle Unlimited, which is a different subscription at $10 a month, which has more recent books. Then there's Amazon Cloud Drive. So you get the free unlimited Amazon photo storage as part of Prime, but if you wanna store more than photos, you pay $60 a year, and you can get the Amazon Cloud Drive, which has unlimited storage for more than just photos. So the supposition here is, while right now Prime Video is just a play for people who are like, I don't want shipping, I don't wanna pay for a year, I just want the video on a month-to-month basis. He success maybe Amazon is turning Amazon Prime into a little breeding ground to spin this off, and maybe we'll see a situation where Amazon Video has a different version that gives you more than the version that's bundled in with Amazon Prime. Oh, okay, that is really interesting. I had another little spin that I didn't see written anywhere was that with as many people shipping things now, and it's just more packages, shipping is more expensive for them than when they made Prime, I don't know, was it five years ago, 15 years ago, they made Prime, and so maybe this whole idea, I mean, they went up for 79 to 99, maybe this whole idea of unbundling maybe just a safe cost, maybe it is really expensive to add the video with the different licensing agreements, plus add this free shipping, which I mean, if you look at regular shipping, if I was to ship a Mark-A-Wave or an Xbox or something big normally, next day, I mean, that's a pretty expensive, you know, some places will charge 30, 40, 50 bucks for that, and you're getting away with it for, you know, $3.99, so it just makes me wonder, are they looking to spin it off entirely its own products so that they can, you know, just save on the whole shipping? I don't know, does that make sense to you that they were trying to do that? They did raise the price of Amazon Prime, but I can't imagine that that really covered all of the things, especially as people are shipping more and more. I know personally, when we first got Prime, I wasn't sure if it was worth it, and these days, we ship enough things from Amazon that it is definitely worth it, and that means that it's probably not worth it for Amazon, although, you know, they do the accounting on these things, so maybe they're wrong. But just to be clear, Amazon Prime, for $99 a year in the U.S., does include the video. It does still, right, absolutely. It does, so they're not gaining any extra money by spinning it out, except for the incremental money gained of people who didn't want the shipping portion, or the music, or photos, or whatever portion, that just want the video, and it does allow them to market it right next to Netflix and say, hey, that's $9.99 a month. We have award-winning shows here, plus Woody Allen film that's gonna premiere at Cannes, and we're only $8.99 a month. And then there's the, of course, there's always the value proposition, as people are already saying, wait a minute, I only watch three things in Amazon. They have a garbage selection, and my answer to that is always, well, that's your take on it. What you may see as garbage is someone else's treasure. So, I mean, I know they don't have as much content as Netflix, but I mean, there's things that I can't get on Netflix and I can't get on Amazon, so I think it's a good value to have. Would I pay the $8.99 with all the subscriptions I have now, Tom, as a quarter-cutter? I don't know. I mean, I already do Netflix, I do the expensive Netflix for 4K. I do the no commercials things on Hulu already, and HBO occasionally. I'm not sure I would. I'm not sure that it's that great of a value for me, maybe for other people though. Well, and that's the thing, right? If you, Amazon has got you coming and going here. They're like, look, if you want our video, you get the shipping, it's just, we're just gonna throw it in. And that's similar to what YouTube's doing. We're like, you want commercial free on YouTube? Pay $9.99 a month, but you also get access to Google Music, and now the podcast, and now the YouTube Red Originals, and the ability to download and play offline. Like they added all this stuff. That's what Amazon's doing. Amazon now going the other way and saying, yes, but if you don't want all that stuff, we'll allow you to pay more for less. But I'm not gonna pay for it. And again, you can do this in the UK at 5.99. Germany and Japan also have Prime Video, where it was available as part of Prime. I think Laura Roman makes a good point. He's like, maybe they, so they did this at Sprint as a possibility, as a test. Now they're rolling out to markets that already have Amazon Prime Video. What if the next step is to say, well, now that we've set up that infrastructure, Amazon Prime Video is available worldwide for $8.99 or the equivalent per month, although we don't have the shipping deal everywhere. Now, that's a good idea. Now, would they then make a Prime that is just for shipping? You'd think that wherever. They end up spending off the music, spending off the books for these little, maybe $3.99 for a Delaney Library, maybe $4.99 for the music, photo storage, just maybe a couple bucks. What would that look like and could they get away with that? Yeah, I don't know if they ever spent out the shipping. I think the idea with shipping, and this is the only reason I think you might not be barking up the right tree with the cost, is that they feel like giving you the free shipping makes you buy more, and so it pays for itself, right? Right, right. Because you're spending more on the platform and they get profits from that. So I don't think they'd ever push the shipping out as its own thing, but I do like what TechCrunch is saying here about, maybe they use Amazon Prime as a way to launch more services, right? You have an instant built-in audience if you say we've just added it to Amazon Prime. So if you already pay the $99 a year or the $10.99 a month, now you have access to this ex-new thing, and then if it gets, they can try it out in there, perfect it if it seems popular, then roll it out as its own service. Yeah, I think that's what eventually happened with Kindle Unlimited, right? It's its own thing. I don't know if they tested it in Prime, but it's not part of Prime. You can't get unlimited books with it, so that's one example. Because I'm like, well wait, don't I get that with Prime? Oh right, no, I get a version of that with Prime, but it's not the same thing. Exactly, so yeah, I just think they need to be clear, but I like that they're willing to try stuff. And they have the money to do it, and if they fail, like they did with the phone, it's fine. They get back up and try something else, so why not do it? Let's get to our pick of the day from Mike and Laurel Maryland, who wants us to pick PlayStation View, speaking of online video. I said it was finally allowed my wife and I to get rid of our $100 a month Direct TV bill and watch our DVR content on our iPhones and iPad. We're paying $35 a month for PlayStation View.  There are some annoyances. NBC Universal channels can't be watched on the mobile devices. Our area, DC and Baltimore, isn't one of the markets where you can get the major networks live through View. We use an over-the-air antenna and the on-demand through View to supplement that. There's no Roku app, so they had to buy a Fire TV. But Mike says to save $65 a month, it's worth some small annoyances and from reading other people's posts, a lot of other people feel the same way. Yeah, you know, I gave it a try. You know, I was listening to your other show, Court Killers. I found it, I used it the first week. I found it to be pretty buggy in the first week and I never went back to it and I didn't like the interface over sling. You know, but I heard it got better. It's a good value proposition. I just, I'm never on my PlayStation forward to take it back. I'm always on my Xbox, so. Yeah, I liked a lot of things about it, but it was buggier in the early days and Theater Mucky uses it and relies on it and he says it's gotten way better. So I'm thinking about dipping back in and maybe trying it out again this summer. But yeah, good, and now Mike agrees. He says, oh no, it's definitely working for me. Send your picks to us, folks. Feedback at DailyTechNewShow.com. You can find more picks at DailyTechNewShow.com slash picks. Message of the day from Keith in Beautiful. Brownwood, Texas says, thanks for the show. I've been listening since day one. I've been following your work since Buzz Out Loud. I had a quick thought on podcasts in the Google Play Music app. I'm an avid Android wearer. I'm a terrible runner, but one of the things I've always desired is an easy way to bring a podcast with me on the run without my phone, just my smartwatch. I can do this with music, but until now I couldn't do it easily with podcasts. In theory, the integration of podcasts will let me offload my podcast to my watch daily. Might be a niche case, but one I've been hoping would come. And of course, by the time you read this email, this thought may be validated by Google's announcement. Yeah, Keith, I haven't seen whether this will, in fact, work with Android wearer, so let me know now that it's launched if that's working for you, but it does seem like it should since Google Music does. And that will be a no-brainer. It's audio, so shit, in theory, work.  That's funny. Hey, thanks to Lamar Wilson, who is also funny, and you should go subscribe to his channel, youtube.com slash Lamar Wilson. That's L-A-M-A-R-R-W-I-L-S-O-N. What shenanigans have you been getting up to lately? Let's see, I've done some grocery shopping. That sounds really exciting. I have a gruel. Sir, you have more of a hudgings, or? Kind of a VONGE, not VONGE. Okay, I can see that, yeah. It was a fun video I did for a grocery haul. The audience really wanted it, and so I did, we rented a zip car, and we went to Costco and did a whole montage video. People loved it, yeah. So my next video coming up is probably gonna be a, it's a highly requested one, what's on my iPad? Now, I generally wouldn't give two rats anything what someone has on their iPad, but people wanna know what apps am I using now. So, look for that this week. Yeah, I've done several of those sort of what's on your iPad type of things, and yeah, it can be fun to see, like you wouldn't think so, but it can be fun to see, because it's not what you expect, right? If it's what's on my iPad, and you're like, here's my Twitter app, and here's my default music app, and my email, it's the default email app. That would not be fun, but it's when you find those weird things, like what is that app? Where did you get that? What do you use that for? That's what it's about. Absolutely. I mean, even though most of mine are all Candy Crush, but besides that, there's some other interesting apps that I use, so. By the way, Peter Wells just at replied me on Twitter with an error message, because he tries out a lot of devices. Can't deauthorize this device. You can only deauthorize four devices a year. What? This is Google Play Music, by the way. He wants to deauthorize a device so that he can use his account on a different device, and they're like, no, you can't deauthorize the device. Seriously? Apple gives you 10, and you can come and go as you please. Yeah, well, you can only have 10 at a time, but you can deauthorize them as often as you want, right? I mean, maybe there's a limit, but I've never run into it. Yeah, that's just ridiculous.  Stop it, Google. Yeah, or as Peter Wells says, sigh. Thank you to everybody who supports this show, dailytechnewshow.com, slash support. There are lots of ways that you can support the show. If you're already giving us something that you think is an equitable exchange for the value you get from the show, you're awesome. Thank you so much. You are the only way that we fund the show. We don't have sponsors. We don't have a trust fund. We don't have secret offshore accounts. We only have you. So if you get some value out of the show, dailytechnewshow.com slash support is the place to go to give some value back. Reminder, tomorrow the show will be recorded two hours later than usual, 6.30 p.m. Eastern. It's our Japan special, or Patrick Beja gets to sleep until 7 a.m. special, because he's in Japan tomorrow. We'll do it a little later so that he can actually get up at a decent hour, and he's gonna share a lot of his observations of the technology culture that he's run into over in Japan. He's been in a few different areas besides Tokyo, so check that out. But if you're waiting for it on time in your podcatcher, or if you're coming for the livestream, just remember we'll be recording it at 6.30 p.m. Eastern tomorrow. Sounds fun. Yeah, should be. I'm looking forward to it. Our email address is feedback at dailytechnewshow.com. You can give us a call 51259 daily, catch the show live Monday through Friday, 4.30 p.m. Eastern at alphageekradio.com, or diamondclub.tv. Drop on by and take a look. And visit our website, dailytechnewshow.com. Back tomorrow with that special show, Patrick Beja. I'll see you then. We're always part of the Frog Pants Network. Get more at frogpants.com. The Diamond Club hopes you have enjoyed this program. I took a book at home. That laugh gets me every time. That's so good. Yeah. You know, I think you did a satisfactory job today, Tom. If anything, I think you should probably work on more joy and more laughter and things. More beard, more beard if possible. More beard? Well, I just do. Yeah, see, I trimmed the beard this week. I know. That was a bad move. I kind of wanted to tell you as well. You were perfect as all of us. I know. I know. You know that. In fact, I'm making a mistake by telling you, because you already know. Yeah, I pretty much just need to be here daily. So just, I have enough to do for a level. The Lamar Wilson Cinecura level. Tom, I have enough to do that's going on in my life. Let's just do it. You guys have so much going on. Please, happy daily. No, you are my favorite. You already know that. You're my favorite. Oh, stop. You're my favorite. No, you've known it. I love doing these shows with you. Yeah, you are my favorite guy on the internet. You are awesome.  You make me blush. If you start turning red, Tom, everybody will see. I know. Watch your arms, it'll be impossible. You can tell. You look close. You can tell. What should we call this? Working at NAB. Roger, we can hear you. Are you muted? You're viewed from above. You're talking really silently. Oh, he's muted. Man, my MacBook Pro screen is dying. It's more than three years old now. Really? And something hit it in the corner, and it started showing a line. And then, all of April, it's just slowly eating the right side of the screen. And I'm like, just please hang in there until New Macs are announced. Just I got other laptops I can use. Because we can get these patrons going. I can tell them right now on this microphone. Guys, Patreon him a laptop. What are you doing? But no, see, I want to wait until the new ones come out. I don't want to buy one of the old ones like a month before they announce a new one. OK. I mean, that's fair. I mean, it always gives me a free one. I always have that battle with technology. It's like, as soon as you buy it, it's going to be something new coming out anyway. I've always missed the boat on GoPros. I've been wanting to get one for three years, and I always forget. And then I think about the middle of the year, and I was like, well, shoot. They come out in around October. I might as well just wait for the next one. What's going on with Roger's audio? He still can't hear. Oh, man. Maybe Roger needs a new laptop first. Yeah, I don't know. I don't know, man. You need to sign language to the title, then, to us. Showbot.tv, folks. Play along at home. We'll be picking title shortly. No, he's out. He's like, goodbye. I'm going to re-log in. How about a prime view? Ah. That's so funny. Now it's terrible. I'll stop. You know I'm a sucker for that, though. You are. What do we got? Amazon Video has reached its prime. Tom's wife working at NAB. Amazon wants its prime cut. Ooh, that's clever. OK, OK. That's the winner. You going with that? I'm going to get me now. Yes, we can finally hear you. It said it. What was that? He just left. Did he leave or? He did. He got kicked out. Yeah, he's like, it said. We were having this problem before the show where it was saying it couldn't authenticate him. I think he's got some kind of browser cache issue. We stopped using Netscape Navigator, Roger, and just used a regular browser. Upgrade from Mosaic. Hey, so Amazon has reached its prime. I like that one. Amazon wants its prime cut is what we were thinking. Oh, that's good, unless you're a vegan or vegetarian, never heard of prime cut. Oh, they've heard of it. They've heard of it. Prime cut of squash. Give me some of that. The vegetarians secretly admire the prime cuts. They just won't eat them, but they admire them. I am not big on the red meats as they used to be. I think it's just age and health. Oh, it's age. I feel the same way. Like, it's so heavy. Lately, I've been eating. I've done a couple of Instagrams on this. Sorry, Tom, you probably have overloaded you with Armenian food. But I have, like, got a Armenian food kick. And it's so light. Like, there's a number of it, a good amount. You know, it's a nice plate. But I do not like hummus at all, because it's never made right. They're hummus. Oh, my goodness, it's good. I will say that most packaged hummus, like, you get in the supermarkets, kind of bland and off-tasting. But, like, really fresh, like, fresh-made or stuff you can actually get at, like, that's, like, like the organic brand, they actually sell in the supermarkets, actually not too bad up here. But, like, it's, like, Persian. And there was another, there was like a Middle Eastern restaurant, really amazing chicken. Oh, my gosh. Like, if you eat, you can stuff yourself, but you don't feel bloated or sick. Yeah. And so, that's the, as I'm getting older, I'm looking for more food like that, that's quality. Like, I went to one restaurant, and it felt like, it was a tiny restaurant, really, really small. But I felt like the lady was, like, cooking for me in her house. Yeah. You know, it was just that feel, and loved it. Well, and when you have a small restaurant, it makes your portions seem bigger. That's an interesting point. No, no, my stomach tells me. My stomach got smaller as I got older. No, it has scientifically proven that if you serve the same amount of food on a smaller plate, you will get full faster. What do you need? I'm working right now. Hello? Hello? Roger's on the phone. Hello? We can hear you, Roger. I'm working right now, what do you need? I'm going to mute Roger. Casey, what, my social security number? It's one, two, three. He's making a mob deal there. What do you need? I'm sorry, I didn't answer it. All right, I'm still exporting. But yeah, man, I love those kind of places.  You were there with your dog the other day, right? Or yesterday? Yeah, I was swear. Yeah, I recognized the table. Sorry, I was like, I like that place. I like little places like that. Yeah, it might be a little bit higher, but it's like you get kind of a, you really good customer service. Yeah. Because they know they need you. And you generally get better food. Yeah, I think so. It's probably what I'll, I'll probably recreate that today. Cause I told the lady I'll be back. So I have to, I have to go back now. You know, it's not actually a restaurant. You just wanted into a lady's house.  I was like, I smell some good food here. Oh, come on, baby. I don't know, you got 20 bucks. I'll make some for you. She got 20 bucks out of me, too. But the LA health code doesn't know is won't hurt anybody. I'm like, where is your, where's the letter A or anything? Oh, don't worry, don't worry, don't worry about that. She's like, oh, I'll, I'll get all the alphabet. It's fine. Have you ever eaten at a place with a B? Yeah, yeah, but it should be months to go there.  And I was like, whoa, like dude. Yeah. It was a trendy restaurant. It was back to an A, so. It was a trendy restaurant, so they had an A. It was in Hollywood for the longest. And I just kept looking in every day as I went to a restaurant next to it. And I finally said, let me give them a try, because they see, it was a lot of people in there. So it seemed like they were doing something right. There was a place by the cemetery I saw once that had an F. And then of course, not too long after that, it was out of business. I've never seen a C or anything. I've only ever seen an A, B, and an F. Like the F was like, whoa, yeah, that's not good. Wow. Okay, that's a, yeah, we got an F. You shouldn't even be open. Why was somebody walking there? The next time I drove past there, there was no restaurant. It was gone. Roger, I unmuted you now. I'm sorry. I didn't want you to accidentally say something on the phone that everyone would hear. No, my dad, my CPA kept calling me and I didn't get it. I can't do that. I'll still pay taxes later. Don't make me pay today. Oh no, it's, yeah, no. It is tax day, though. It is, it is, we didn't mention that, but it's kind of obvious. It's not a tech story, it's just file electronically. Well, you can actually file by post date, right? Like, those you have the post marked, you get to start at the end of the day, April 18th. Yeah. Man, we used to run tax stories on techTV.com and CNET, and they would never do well. It was always this thing like, oh, you gotta run a tax story, because it's tax day. And I'm like, no, it's too late, and nobody wants to be reminded about it. No, almost, yeah. Or if they didn't do it, they don't want to, yeah, they don't want to throw it in their face. Right, yeah. So prime cuts, prime cut. Amazon wants its prime cut. Oh, yeah, a couple of states it is tomorrow. Tomorrow? Really? Because they have all this? But that's a state income tax, right? Well, the state income tax is the same for everyone. Should be. Otherwise, I'm moving. You get that extra day. That's what I have an account for. They better did it on time. They said they did it electronic, you know what I'm saying? All right, because it's Patriots Day today in Massachusetts. Good point, Captain Jack. Patriots Day, okay. So if that's the case, Boston Marathons today, and that means that the Federal Government Postal Office has to deliver mail, because it's not a federal holiday. May I still look? Oh, taxes. I actually don't mind paying a reasonable amount of tax to support the government that does many things, and it gives me the right to complain about what those things are. I would just like it to be simpler. And obviously I'd like it to be more order too, but yeah. The issue is the simplest. I mean, I have to hire a company for mine now, because it's just, it's too detailed, and I don't know, and now we have to do estimated quarterly taxes. Well, they're not required, but they strongly encourage you to. Because they want to make the interest off your money, not you. Right. That's like, well, yeah, that's my, yeah, because this is my first year I've been doing that, and they're like, well, you know, you don't, they said you don't have to, but we strongly encourage it if you want to make sure that you're not hit with a big bill next year. What's a good safety measure to make sure you have enough money to pay your taxes? Absolutely. Yeah. And so, you know, they're right, and when I have the money, I will. Okey-dokey. That was fun talking about money I'm losing today, or we're all losing. I ended on a downer. I agree, I just really need the money to pay right in two weeks, so. But thanks everybody for watching, and... Oh, no. Don't cry, Roger. Have a lovely Patriots Day. Patriots. Yes. Go Patriots.


Welcome to our webinar for the very beginner. Excel for the very beginner. Thank you so much for joining us. I am Alicia Kidd an online learning specialist with TechSoup. Now let's make sure everyone is comfortable using the webinar platform. Now the chat box which is located on the bottom left hand corner of your screen, at any time if you have problems viewing or hearing the audio, just make sure the chat is and our chat person Susan Hope Bar will assist you with chatting the number as well as the passcode. Also if you are hearing an echo through your computer speakers or having any issues with the audio, again you can dial the toll free number that was listed in your registration email, but we are also going to be chatting it out if you are having those issues. The chat box is also for your questions. We will be flagging your questions and queuing your answers and questions during the Q&A session so we encourage high engagement and dialogue throughout this amazing presentation. You will be able to find this recording at TechSoup webinar page by the end of the day. This is where we share our webinar recordings and also announce upcoming webinars and we encourage everyone to check our future webinars and our recorded webinars. Also following this presentation it will be recorded as well as with the PowerPoint we will send an email to all registered attendees no matter if you attended or not. You will receive that by the end of the day as well as it will be uploaded on our YouTube page and slide share in all of our social media. And if you are on Twitter we highly encourage you to follow us on Twitter, become a follower, and we hopefully will follow you back. And then you can also tweet us at TechSoup. Also hashtag us at TechSoup webinars with the hashtag sign. Again my name is Alicia Kidd and I am the Online Learning Specialist with TechSoup. And our presenter here is LaChica Phillips. She is an Associate Program Manager with TechSoup. Now let's talk a little bit more about our amazing organization TechSoup. It's headquartered here in San Francisco. And what I want to know is since I'm in San Francisco where is everyone from? So chat out, spin it the next few seconds to let us know where you are coming from. I'm in San Francisco, Florida, Toronto, Texas, New York, Huntsville, Alabama, Waco. Oh my God, this isn't a, oh, it's everyone here, great. Atlanta, Maryland, Phoenix, great. So as I stated before, TechSoup basically is, we have a global mission. And what we do is we offer so many great services. We help so many of our organizations get billions of dollars in technology projects and grants to our partner in NGOs. And those products and grants come from all of our corporate sponsors and partners. So now what I'm getting ready to do is I'm getting ready to turn this over to our presenter LaChica Phillips. She's going to go through this amazing demo. And just remember this is Excel for the very beginner. So this is going to be a fast ride. It's going to be engaging. Please, if you have questions, we are going to queue it up. And look forward to answering your questions. And now I'm going to turn it over to LaChica Phillips. Hi, good morning everyone. Thank you again, Alicia. And thank you, Susan. I know that you are managing the chat right now. And I just saw that we also have people listening in and watching from India and Canada. So thank you for joining us today. I'm so excited for the opportunity to share the basics of Excel with you. And as Alicia mentioned, this webinar is designed for the very beginner in mind. Yes, we welcome first-time users all the way to Excel experts. So to get a better idea of our audience, I know we know your location now, but now I want to find out what is your level of skill and experience with Excel. So are you a new Excel user?  Are you an advanced Excel user? So if you've not already done so, if you look at your screen, you can select your level of experience. Thank you. Okay, wow, look at this. So we have, majority of our listeners today are new Excel users. So that is fabulous. Well, you are definitely at the right place at the right time. So now I would like to find out what is your primary goal in joining this webinar? Well, now I've just found out that the majority of you are on here for the first time. So I'm guessing it's to learn how to use Excel, but we're more than happy if you have ideas on how you need to train your staff, or you need quick refreshers. We welcome you to answer that as well. Thank you so much. Really appreciate you taking the opportunity to do that. So we're going to jump right in, and I'm going to start sharing my screen. So in just a minute here, you are going to see an Excel spreadsheet, and we are going to start from the very, very beginning, and we're going to go over some of the most commonly used tools and features. So get ready, here we go. Okay, and so if you're not aware, just let me share this with you very briefly. Excel is a great spreadsheet application used to create forms. You can use it to create reports, graph data, and even directories. Some nonprofits use Excel to track donations, to record volunteer hours, and to manage contacts. With a wide range of financial functions and formulas and add-ons, nonprofits can really manage data in a more effective way using Excel. I want to point out that the reason why you would want to use Excel as opposed to using a table in Microsoft Word is that the table in Microsoft Word does not give you those added features as far as calculations, as far as filtering. So if you just need a simple table without the calculations and without the other features, and you don't have a lot of data, then a table in Microsoft Word would be effective. It would be enough. However, if you do have a large amount of data, and you do need those calculations, then yes, Excel is definitely perfect for you, for your team. So let's just dive in and look at these most commonly used tools. So if you notice when I went to the spreadsheet, we have these options at the top. But I'm going to show you, if you select this drop-down arrow here, so if you select Home, you get an expanded toolbar section. Now to keep this toolbar to stay visible, you want to click this option, Pin the Ribbon. And so what this will do, I'll give you an example. So you see how the expanded toolbar disappeared? But if I click Home again and have it expanded, and I select Pin the Ribbon, watch what happens. It stays. So now I've just pinned the ribbon. So now I don't have to keep selecting Home to get these extra icons and features. So you want to pin the ribbon. Now let's jump right in to Clipboard. And as you can see, I know that a lot of you are first-time users, but perhaps you've used Microsoft Word. And if you have, that's very good because a lot of the features in Excel are similar to the features in Microsoft Word. For instance, this first section here, Clipboard, you've got the Copy, Paste, and the Cut icon. And this is the Copy information that you want to duplicate it. This is the Cut information, and to place it somewhere else. And this is to Paste. So I'm going to just show you very briefly. We can Copy here. Here's the icon, Copy. And we want to paste it. Let's say we want to paste it here in this sale. These little boxes, these are called sales. And if you notice, each time I move into a different sale, I want you to look here, right under the Toolbar. This box is the Name box. I like to call it the address of the sale, but that's exactly what it is. So if I'm here, and as you can see, I'm in K2. Okay? So we're going to Copy the date, and then we're going to Paste it there. And so that's the Copy, Paste feature. I want to show you something else here that I really, really love with the Clipboard icon features here. It's this Format Painter. So let's make this date bold. And let's make it red. And let's make it bigger. And we're going to go over some of these fonts here. Okay? And let's make it bigger. So what I want to do is I want to copy the format of this sale. I don't want to copy the contents of this. I want to copy the format. Okay?  But I don't want to have to go to each sale and do that manually for each one. So that's where the Format Painter comes in hand, and I'm going to show you. So what we want to do is we want to select the sale that we want to duplicate the format, not the content. Okay? So we have that sale selected, and now we want to select Format Painter. And let's select the sale where we want to duplicate that formatting. Let's try an email address. And voila, that's what the Format Painter does. And so moving on to Font. And as you saw, as I played around a little bit changing the font here to red and to bold, this is where you can change your font. I showed you here how to change the color, how to make it bold, italics underlined just like in Microsoft Word. Here is where you can add borders. And what you would want to do is select the sales that you want to have a border. So let's say these are the sales. And you can select all borders. And now you have borders around all of those sales. Okay? And you can remove that here. No border. Okay? Now alignment. Alignment is where we want to change the direction and the alignment of our content. So using this, looking at this sale here, we can have it left aligned. We can have it right aligned. You can center it. And you can also have it where it's at the bottom of the sale. It's at the top of the sale. And depending on how you need your data displayed, you may want it any of these ways. Okay? And so now I want to show you the Wrap Text. As you can see here, this sale has the feature it's Wrap Text. If we remove that, you can see that some of that, the data is cut off. You can't see everything. You can either expand the column this way by double clicking on that column. That's all I did. I just double clicked and then expanded to the longest set of content in this column. But if it happens to be a column like this, perhaps you have a lot of data. And you have to see all of the content of the sale in the sale and maybe multiple lines. And that's where the Wrap Text makes those visible. Now of course, you can select the whole column and now you have multiple lines. And you can see all of your data or again stretch it out this way. You can expand it. Okay? Now with the alignment with the orientation, this is the orientation of the actual content of the sale and not the actual page. To change the page orientation it would be here under Page Layout for the orientation. But this is for the direction of the content of the text. So if you select the drop down, we can change the direction this way. Now this is just demo. We wouldn't want to do, we wouldn't want the email address to be that way. So I'm going to show you. And remember all is not lost because we have Undo, Undo. And the shortcut to the Undo is Control-Z. Okay? So let me take a different sale and show you. Let's change the orientation of the date. Okay? And so now moving on to numbers. This is where we can change the format or select the format that we want to use for the numbers in our spreadsheet. So if you look here, the drop down, you have several options for formats for your numbers. So we have general where there is, there is no number format. This right here is general as you can see. And what I mean by that is there is not a dollar sign. It's not currency. It's not a date. It's the general format. So the number format would have decimals. Currency would have the currency symbol associated with it. You have accounting, short date, the long date, time, and percentage. There are other formats, however, Excel for beginner. We are going to stick with these here. And I believe that most beginners will feel comfortable using all of these formats. One of the questions that I get asked the most is what's the difference between using the format for currency and the format for accounting. And currency is mainly used for general monetary value. And accounting is used to actually align the decimals and the currency symbols. So I'm going to select this column here. And I want, I can do this drop down here and select currency. But I can also just select the dollar sign icon. And so now it's currency. So if I were to calculate a sum, which we will in a little bit, then we will see that everything will line up. The dollar sign will line up. The decimals will line up because it is under the accounting format. So now let's look at styles. And since we are talking to the very beginner, we won't go into a lot of these. But there is something that I want to show you. If you are a nonprofit and you are managing a lot of data, there is a tool that can really help you analyze your data very, very quickly. And that tool that I love to share is found right under here in the Styles tab. And so it's under conditional formatting. So if we drop down the arrow here, we have all of these options. And the one that I want to point out today is to highlight sales rules option and greater than. Now I'm going to explain why this would be in handy. If you have a spreadsheet from a fundraiser and you need to reach out or send a separate letter to all of the donors who gave over $100, let's say, you can go to your spreadsheet and you can create a rule to highlight everything over whatever amount or everything over $100. And so then your data would tabulate and you would have all of your data. So let's try that. Highlight sales rules greater than. And so for this spreadsheet, let's say greater than, let's say greater than $200. I'm going to find myself, do I have a $250? No, I have a $250. So we want greater than $250. So I'm going to select that value that's here. And I'm going to say, okay, so what's going to happen? Nothing happened. Do you know why? I did not select the column. So let's select the column, conditional formatting, highlight sales rules, greater than. I said $250, let's say $250. Okay. So everything that's highlighted is greater than $250. So now I've identified all of those donors who've made that contribution and now I can easily reach out as opposed to searching the spreadsheet and trying to find that information. I can use this tool to help me locate that very easily. I can also use the duplicate values tool to find out where duplicates are. Okay, again the column has to be selected. Let's remove this rule. I'm going to show you how to do that. So to remove a rule, select the column, clear rules. Okay. So now let's look at the sales section. And this is where we can insert and delete columns and rows. We can also format our different rows, row height, column width. You can also hide and unhide rows and columns. I'm going to show you a shortcut to that. You can rename a sheet, copy your sheets, and you can change those colors. But I'm going to show you a very easier way to do that. But I wanted you to be aware what is under this Format Sales tab. These are just a little bit more options for you to choose from. Okay. So to insert, you can go here. You can also, if we wanted to insert a column, you can select where you would like to include your column. If you right click, you can insert. Okay. You can also do the same thing for if you wanted to insert a row. Just highlight the row. If you right click, you can now insert a row. Now I want to bring this here attention because the question I was just asked was why would you need to change row height or why is this important? If you have a spreadsheet and it has to be on a specific size of paper, if there has to be certain information, it has to be on one page, you can go and make your column width. You can customize it. You can make it bigger. You can make it smaller. But these are just like I said, additional options for you. Now with organizing your sheets, these are sheets. This entire application is a workbook. And inside each workbook are these different sheets. What I recommend is when you start with your raw data, it's to let that be maybe your first sheet. But you can also rename it. And I like to do that. And we can call this raw data. Okay. Because what's going to happen, because in a minute we're going to go over sorting and filtering. And so once we have sorted and filtered our data for however we need to use it, then what we would want to do is to have that information maybe on a different sheet. So if we were going to filter with the same example I just used, the organization needs to reach out to all of the donors that gave over $250. Then what we would want to do is to take that data, the list of those $250, and maybe move that here. Okay. We can move that information onto this sheet. And so then we would name this maybe Donors 250. Okay. So we can delete this here. And if we wanted to come back again to our conditional formatting, highlight the rules, and then put all of that information here on this separate sheet. Because now you have your own separate sheet that's dedicated to these donors only. And then you have your original raw data always in place. Okay. Okay. Let's move to the fun stuff. This is the editing tab. Because this is where, this is definitely where the magic happens I feel when it comes to analyzing your data. Because here this icon is where you sort and filter. So this allows you to sort your information in alphabetical order, largest to smallest, or smallest to largest. And filtering though is another way for you to remove some information and not delete the information. You're just simply taking it out of the data like I just showed you. We have the donors that gave over $250. So if we wanted to filter those, we would actually be removing that information from the main data. So let me show you how we want to filter. If I select donation and if I select the filter option, I don't know if you can see. Let's expand. And the way we zoom in is here. Do you see that? I'm at the bottom left-hand corner. So I'm going to do this again so you can see that. So I've highlighted the cell, the top of the row, the column I need to filter. And I'm going to select filter. And so you see now I have this option. So now I'm going to select this arrow. Okay. And let's see. Am I not getting what I want here? I think I may have just done. There we go. Yay! Just a little patience. I don't know sometimes Excel can do that. But just be patient. It happens to the best of us. But this is what I was looking for because what happens is when you select the filter option, what happens is it will generate all of the variables here. And so now it gives you the option to actually filter. So again, let's filter 250. Okay? And so let's see. So now all I have here is the donations, the $250 donations. Do you see that? So now what I can do is I could copy this. Copy. A shortcut to copying is Ctrl-C. I'm not sure if you know that. I could go now to my Donors tab and I can paste. And so now here is my $250 Donors tab. So we know how to fix these dates. Remember we are going to double click to expand. We can make this just a little prettier maybe. Expand. Okay? So now let's move right into some and a couple of formula features if we have time. But I think I do have time definitely to show you how to come up with a some because that is definitely the most commonly used feature in our formula in Excel. So let's show you that. I'm going to zoom out just a bit. And to get the some, this is the icon for autosum. Okay? And so to get the some, what you want to do is select the cell where you want your some to be displayed. And so for just purposes of this example, we want the some to be displayed here. And here is I2. Okay? So now that I've selected that, now I want to select the autosum icon. Now I want to select the cells that I need calculated for this some. And so here I want to select this one. This was G2. And I also want to select, I want to select G3. So we have G2 selected. And we also have G3 selected. And so I'm going to hit Enter. And so now I have the total. I'm going to do that again. You want to select the cell where you want your total to be displayed. Select the autosum icon. And you can either drag like this to select the total and hit Enter. Okay? And I'm going to do it again. Or you can select. And maybe I need a different cell. If you hold down the Ctrl key, you can move throughout your spreadsheet. And now let's select Enter. So did you see that? I do believe there's going to be a part 2 of this webinar. I'm excited about that. So we'll definitely go over some more formulas in the future. But I also want to show you something else with the sum. So this is just a quick way. There is a manual way. I don't know anyone who has ever said, can you tell me how to do the manual way for it to get some? But really, really quick, I can definitely show you that. So again, if you want to be in the cell where you want your total to be displayed, you want to enter the equal sign. You have to type the word sum. Now you have to use a parentheses. And then you select the cells that you want the sum. And hit Enter. So that's the manual way. Okay? But you can also equal sign the cell that you want. And I'm going to just do plus sign, and then another cell, and Enter. Okay? So that's how you can get your sum. And of course, if you need to, you need the difference, it would be the same thing. Of course, you wouldn't use the plus sign, you would use the minus sign. Okay? Alright, so what else can we show you? What else do we have time for? Oh, I know what I wanted to show you. What is, this may be a life changer for you. I'm not sure. I know that it was for me when I first started using Excel. And that is, sometimes you have a lot of data. I'm just going to remove this. Okay? But sometimes you have a lot of data. And let's say we needed to look at row 40. Okay, so we're at row 40. Well, if I'm just looking at this, maybe I don't know if this is his first or his last name, because my header, I can't see my header. And if you have a lot of data, and I know that a lot of you nonprofits do, and it's so hard. And sometimes you don't remember, what was the title of that header? So what you can do is, you can come up here, you can select your first row. If you select view, you have an option, excuse me, freeze panes, freeze top row. And so now what happens is, no matter how far down you go in your spreadsheet, the header will always be visible. Okay? The other thing that for me as Newby with Excel that really, really helped me was to be able to hide data. Sometimes you have so much data. Now I don't want to delete it, and I don't want to filter it. I just want to hide it so that I don't see it. And so we can do that. And the way you do that is, you can select the column, you could right click, and you can hide. Okay? So it's not filtered out. It's not deleted. And as you can see, it's just hidden. Column D is the column that we just did. And to unhide it, you would select the column before and in the column after, right click, unhide. Okay? Excellent. So now I want to go over the best ways when it comes to printing your information. I don't know about you when I first started Excel and I started printing reports. It didn't look like what I thought was on my computer screen. And that was very, very frustrating. You know, sometimes we need the headers on every single column, but you know what? You have to tell Excel to do that for that to happen. And the way that we do that is we can go to Page Layout. Sorry. We can go to Print Titles. And you see here Print Area, Print Titles, Roles to Repeat at Top, Columns to Repeat at the Left. We want to do Roles to Repeat at the Top. And this is the role that we want to repeat it on every single page. Okay? Okay. Did you see that? And so now when it's printed, if there are several pages, let's see if we can do a print preview here. Is it on the second page? Let's see. It looks like it is. But do you see how the donation? It's just on that one page. Let's fix that. So the way we can fix that, a couple of ways actually. Let's go to View. And let's do Page Break Preview. When you do Page Break Preview, do you see this little dotted line here? This lets me know this is the beginning of a new page. Do you see that? So that's why donation was on a page of its own. The Page Break is right here. But you have the power in Excel. You can move this Page Break. Let's move it over here. And now let's just delete this column. I don't know why it's here, but let's delete it. And so now we should have one page. It looks like there's going to be a second page, but it's going to be blank. Do you see that? We can get rid of that too. So now we have a clean spreadsheet. It looks like it's all on one page. Let's go back and let's take a look. And there it is. Okay? Now I also want to let you know that you can print to PDF as well. So you can convert your Excel spreadsheets to PDFs if need be. Okay? Okay. I also want to show you here. I believe there was something I also wanted to go over here. Okay? Does anyone have any questions? So yes, thank you so much, LaQuisha. We do have a lot of questions. A lot of questions. So let's start this question and answer. And since this is a live demo, the question and answer, if LaChica can demo some of your answers to the questions are verbally just say it, it's going to be engaging. So the first question that we have is can we convert a Word table into an Excel spreadsheet? That is a great question. And yes, you can. So that's taking a Microsoft Word table and making that into an Excel table. Do I have time to show? Okay. So I may move, I'm going to try to do this slowly, but I have to move out of Excel and I'm going to Word and I'm going to do the exact, all of the steps that you would do, okay? And I'm going to use the same data if that's okay. So what I'm going to do is I just want to select this information. Just one moment, I'm just going to copy this and I'm going to put this in Microsoft Word just for the purposes of demonstrating this to answer this question. It's a great question, by the way. Thank you. So we are saying that this is our information. We have a table in Excel. I'm sorry, we have a table in Word and we want this to be in Excel. So what you would do, here's our table, okay? And so we want this in Excel. Again, as you notice, a lot of the icons here, all of these icons here are exactly the same as they are in Excel. So what we can do is select all, we can copy. Oh, I've been told that you can't see my table. Okay, okay. So this is what, when I go to Word you can't see my table. I'm so sorry. Okay, let's see, how can we, okay, okay, okay, okay. I'm sorry about that. Thank you for your patience. So I'm going to try something here and I hope that you can, okay, here's my table. Can you see that? Can I get a thumbs up? No one can see the table? Okay. Everyone can see it. Oh, okay, great, great. So I have a table in Word. Do you see this here? And what I want to do is we need to convert this to Excel. We can just really copy and paste. You copy the content from your Word table, okay. And then we're going to go to Excel. Can you see my Excel sheet? I'm going to click on sheet 3 and I'm going to go to my first sale here and I'm going to paste, okay. I believe that that is the easiest and the best way if you want to convert, per se, Word table into Excel because sometimes what would happen is if you try to use some software to convert what tends to happen is you lose a lot of formatting. So what would happen is a lot of times what I've seen is that instead of this being two sales as it was on the original Microsoft Word file, what I have seen is that these two then they merge as one. Okay, when you try to use some different program, you don't have to use a program to convert Word to Excel. So hopefully that was easy for you. I'm happy to show that again if need me. If not, I'm happy to take any more questions or any more demos. I'm happy to do that. So yes, thank you for that. So see we have a lot of tips, tricks, and hacks. So remember if we don't get to all of your questions, I am chatting out a link that has some help, some answers to your questions to give you some run, just give you examples of how to use tips and tricks. So the next question that we have here is, is there any shortcut to paste the self format painter inside of control V? Okay, we can move on. Let me give you another question. Can you quickly review locking a roll of sales? I tend to get the wrong one that's fixed while the other one's others are moved. So locking sales, I think a good example would be to freeze. We've gotten a couple of those questions where there's a lot of columns or rolls with a lot of data. If you can show them how to do a freeze pane. Yes, I think that's something that a lot of people have questions about. That was actually something that helped me when I first started using Excel because again, depending on the amount of data that you're working with, it is very important to be able to hide columns and information so that you can focus on what you need to focus on, or analyze what you need to analyze very quickly. So right now I'm in page break preview. That's why you have the blue box. So I want to go back to normal view. And so that's what I did there. And so again, to freeze your pane. And I believe, yeah, this one is already, so let's do, so I'm going to select the roll that I need to freeze. And it's this one I have that selected, freeze pane, freeze top row. Okay. You can also select the row or the, I'm sorry, select the columns or the rows that you want to hide. You can right click and hide. You can select, right click, and hide. Okay. And so if I want to unhide that, I would select the column before and after it, unhide, and then it's visible. Okay. I hope that answers your question. Great. Thank you for that. Another question is, can you organize your data in numerical order? Say you want your raw data donations in greatest relief. Oh, absolutely, absolutely. Okay. So yes, so you have here in column F, these are donations. Actually, let's go to our raw data because if you remember, we filtered our raw data to get this because we were looking at $250 donations. So let's go to our raw data. And I'm going to remove the filter because right now, again, we just filtered for $250. So I want to click that and I want to clear filters. So now this is my raw data. So what I can do here is I can select the column, go back to my home so I can have all of my options here. And so again, remember this is the sort, sort. And so now they are in order from smallest to largest. Great. So we also have another great demo question that you can do. It's can you protect a sheet? So if you can show us how to protect because you know, working with private and sensitive information, you know, you want to probably show how to show the users how they can protect the data. Absolutely. So what you want to do, we can, you can actually, you can protect sheets and you can also protect your, the entire workbook. Okay. So I'm going to go to, did I lose it? Oh, I'm sorry. Oh, I have an error message. I'm sorry. Okay. Okay. Okay. So we're going to show you how to, how to protect your workbook. Okay. So what you want to do is I think I've just selected the, can you see my screen? Can you see my screen? Okay. Sorry about that. I seem to be having some technical difficulties. I'm sorry. I want to see if I can fix this on my end. So while, while we're working on dealing with the technical difficulty, I will be chatting out additional links for everyone to, if they have any questions in reference to utilizing Excel, I just chatted out a link to everyone and this will give you the tips and tricks. Again, this is a helpful for more Excel help because we have a lot of in-depth questions and answers and to help you. Again, we've already looked at the freeze pane. We also have showed you guys how to manipulate data and everything. So since we don't have any, let's see if I can find some other questions. If you guys can chat about any other questions, that would be great. And also chat your feedback. Is there anything that you would like to know in detail? Okay. So now we're back. We're ready now to answer more questions. I just wanted to get everyone engaged, everyone. This is a lot of great information. So again, we are going to show you how to protect the data. We're going to show you how to protect data because in your nonprofits you have highly sensitive data and you want to protect it. So Sheika, hand it over to you. Thank you. I'm actually having technical difficulties on this end. So what I'm going to do is I am going to make sure that when we send out the follow-up after the webinar, we will definitely include those steps in that email, in that follow-up. It looks like we do have time though for another question, maybe perhaps another demo. Does anyone have any questions? Anything else I can demo? I do. So another great question I have is, what is the best way to use Excel for accounting within nonprofits? Well, I definitely would not recommend using Excel for accounting meaning to actually manage the books per se for an organization. I believe that using a software like QuickBooks and other different programs and software that we offer through our TechSoup product donation program would be best suited for a nonprofit. There are just some things and some settings that are a part of the accounting software that you just cannot get with Excel. You can do a lot with Excel however, as far as calculating taxes and just the way that Excel is organized. I think that it would be difficult to use only Excel to be your accounting management tool. I believe that Excel can be used as far as accounting purposes. I believe that that's the best tool to use to develop profit and loss statements. I believe that it's the best tool to use to generate expense report forms. Those types of things, I believe that's good for accounting. But again, I would not recommend a nonprofit or any organization of that matter to use Excel as their solely software for accounting. I wouldn't recommend that. Thank you, Lashika. Now everyone, we are done with our questions. We are running out of time. But before we close, I just want to say a few things. Now again, I chatted out several times some links for everyone to utilize. We will hopefully have a part 2. This will be a recorded webinar along with the PowerPoint presentations and additional tips, tricks, and hacks that we didn't cover. We are going to look through the historical chat to look for some common questions and try to find some tips to direct you. So now before we close, I would love for everyone to take a look here at the screen. We have our website, techsoup.course.tc4 slash catalog. That's our learning management system. We encourage everyone to sign up. You can sign up and take a host of classes when it comes to our software, when it comes to just all types of cool data technology related information for your nonprofit. Now before we go, what I want you to do because you guys have been so amazing and engaged, just chat one thing that you learned today in the webinar. So just chat a couple of three characters, 10 characters, a paragraph. We love all the feedback. What did you learn? What would you like to learn in the future? Will you share this also? Will you share this information with your colleagues and your network? So yeah, just type that in. And while you are doing that, once this webinar concludes, we will have a survey that we would really love for you guys to fill out. It will only take you a few minutes and it will pop up once the webinar concludes. We take that data and it is for TechSoup so we can bring our customer base, the latest and greatest information, and make improvements for our audience. Also, we have some amazing upcoming webinars. Not only did we just do Excel, but we also have three upcoming webinars. One that is going to be in the month of August on the 24th which is in a couple of days. It is creating accessible online resources with people that have disabilities. And then you probably heard about our Storymakers campaign and we have our first campaign coming up. And it is a 10-step process with our partner Greenpeace. And then finally, all of you guys love or want to hear about funding. That is what keeps our nonprofits running is learning about funding. So GrantStation, which I am sure everyone is familiar with. They are one of our partners. You will hear if you sign up on the 20th an amazing presentation that is the first of a three-part series of how GrantStation works and how you can utilize it to increase fundraising with your organization. And finally, I do want to say thank you to our sponsor ReadyTalk. This is a webinar platform that we give our great presentations. I want to thank everyone that participated, all 600 of you. And remember, this is a recorded webinar. You are going to get your PowerPoints for all of those that registered and also will be up on our YouTube, all of our social media by the end of the day. And we will include the PowerPoint slides. I want to thank LaChica Phillips, Susan Hope Bard, and again, my name is Alicia Kidd. And we want to thank you. And please don't forget to fill out the survey once the meeting concludes. Thank you everyone. Have an awesome day. And I hope this was a helpful webinar. And we look forward to seeing you again.