You know, in the world, we are building medical infrastructure in such a way that today all of us are expecting, someday we will all be seriously ill. It need not be so. If you live with Narmadaji, it need not be so, and not just her, there are many others. It need not be so if you know how to manage the elements, if not all of them. It's very easy to bring water and air into your control. These are two elements which are easily accessible. If you do this combination well and little conscious about what you consume, you will never go to the doctor. There was a time for the whole town, there used to be one doctor and it was enough. Today every street has five doctors and it's not enough. This shows how we are living. When we forget how to live, when we do not respect, what makes our life? The earth that we walk upon, air that we breathe, water that we drink, the very sky that holds us in place, when we have no respect and reverence for that, how they behave within us is very different. Today there is substantial scientific evidence to show that water has tremendous memory. If you just generate a thought looking at the water, the molecular structure of the water will change. Just a look, the molecular structure of the water will change. If you touch it, it will change. How you touch it is very important. So now for example, they keeping it in a copper vessel with a flower on top of it because this is the god, what are their god? If you don't drink water for one day, this is the only god. No other god, isn't it? So how you treat the water, the memory remains for a long period. So before we consume it or before it touches our body, how we treat the water changes the quality of everything in our system. This is a science we have always known, but today modern science has done an enormous amount of experimentation on this. Now they are saying, water is a liquid computer. The volume of memory and intelligence is carried by itself. It is a liquid computer, this is what they are saying, it's a fluid computer. We have always known this. What is called a stheerth, why for one drop of water people go and stand in a temple is because it has the memory of the divine. You want to take that into your system. If the deity is powerful and the water has touched the deity, it has the memory of the divine, you want that to enter your system. But being in a pure space like this, it's a blessing. If there are certain ways with which you can be in the water, if one does that every ailment, all chronic ailments will go. There are infectious diseases and chronic ailments. Infectious diseases are an invasion from outside. Other organisms are entering our body and troubling us. For this you need a doctor, you need warfare, you have to bomb them out. Chemical warfare is normally what we are doing. But over seventy percent of human ailments are self-help. We manufactured that within our system. This is simply because fundamentally the way we are treating the elements is within ourselves and around ourselves. The so-called modern life has absolutely no reverence to the substances which make our life. The life-making material is being treated badly and we are expecting it will behave well within us and it will not. So being here at Narmada, it's time we bring back this culture because it's gone a full circle. Now modern science is insisting that water, the way you treat it is the way it's going to behave within you. And we must learn to treat it well. If we want to be healthy, if you want to be well, if you want to be successful, if you want to be prosperous, for all these things it's important the elements within you cooperate. If they don't cooperate, nothing will work. One simple thing you could do is how you treat the water. At least the water that you consume. I know today everybody is drinking water from plastic bottles. If you keep it in a metal vessel, particularly copper or copper alloy, the very nature of the water will change. And traditionally, I don't know if it's still maintained in this part of the country, but in southern India even now it's pretty common in traditional homes where every day there is a puja for the water vessel. They will put some vibhuti on it, some kumkum on it This is a small arathi for the thing because the water should... Water has an enormous amount of memory. It remembers how you have treated it and accordingly it will behave. This is something very simple, everybody can start. And as a part of this in Tamil Nadu, we've been encouraging people to use copper vessels, pure copper vessels because copper is such a... You know, it's the best conducting metal and it energizes the water. Energizing, if you check the molecule... I mean if you check the chemical composition, it'll not change. That is the beauty of it. It's only the molecular structure of the water that will change. You might have experienced this. Suppose you ever... Is there a waterfall in Narmada, anyway? There's a waterfall. If the water is falling like let's say over 20-25 feet and just after the waterfall, if you just touch the water, you will find water is silky for touch. Have you noticed this? Because water implodes within itself and the molecular structure changes. The way it feels is different. Today, they have created what is called as implode... Water imploding machines. You can implode the water with a machine. It just churns it in a certain way and implodes it. It has been found that if you use water imploding machines with 10% of the water, you can grow the plants the same way as you're growing. The water consumption will come down. With 10% of water, the plants will yield the same because the imploded water becomes silky and its ability to become a part of the plant system or tree is much, much better. So if you're in agriculture, imploding machines can come. It's... Some people have patented it in UK. We are trying to bring some machines and give the service to the local farmers in Tamil Nadu so that people can use imploded water and their water consumption in the fields will come down dramatically because how long you pump the water, electricity not being free these days, it gets very expensive for the farmer. If the amount of water he needs to pump on his field is much less, it'll make a big difference. For daily consumption, just a copper vessel, every day if you have something, if you light a lamp next to it, if necessary, just one flower, the very way the water behaves within you will change. And when before you consume just one, one moment of gratitude and reverence, because this is the material with which you're making your life, not with some unknown God. This is the material that makes your life every moment and how you treat it is very important.   So the water, the food, just bringing that reverence, you will see the volume that you consume will also come down and the way it behaves within you will come down. If you don't catch an infection, if you treat these elements properly, as I said earlier, most probably you won't see a doctor's face unless you want.


In the previous video, we saw this quadratic formula, X equals negative B plus or minus the square root of B squared minus four AC all over two A. Now, we saw that by completing the square on a generic quadratic equation, we are able to solve every quadratic equation and we can do that with the quadratic formula. Now, this is a great tool we can use when we have to solve quadratic equations, but sometimes when it comes to solving quote unquote a quadratic equation, you don't actually need to solve it. Sometimes just knowing the nature of the solution set is good enough. So what does one mean by that? When you're trying to find out the nature of a solution set, sometimes it's good enough just to know like are my solutions gonna be whole numbers? Are they're going to be irrational, rational? Are they gonna be real complex? Do I have one solution, two solutions, no solutions? That's sometimes all that one needs to know when you're working with quadratic equations and the nature of the solution, it doesn't require the entire formula. It turns out that one only needs this part that's inside of the square root, this negative, or this B squared minus four AC part, which is referred to as the discriminant. So consider the following right here. So I mean, I just have it listed right here, this B squared minus four AC, this is what's referred to as the discriminant of the quadratic polynomial, for which we can see that when it's in standard form, AX squared plus BX plus C, it just takes the coefficients A, B, and C. And this discriminant can be useful to help us determine what's the nature of the solution set to said quadratic equation. So imagine we have a quadratic function, F of X equals AX squared plus BX plus C. And we then compute the discriminant of this quadratic function, we'll call it capital D. Now, first of all, consider that capital D is a positive number, B squared minus four AC. What that means is the square root of the discriminant is going to be a real number. And when you take the negative B in the quadratic formula, you have to add the square root of the discriminant, and you have to subtract the square root of the discriminant. And because of that, that'll give you two distinct solutions to the quadratic equation. Now be aware, if you have a quadratic function, F of X equals AX squared plus BX plus C, if you're solving the equation without equals zero, that means you're looking for the X intercepts. And so when your discriminant is positive, that indicates that you will have two distinct X intercepts, which of course are the solutions to the equation AX squared plus BX plus C equals zero. And these will be two distinct X intercepts and the equation, the quadratic equation will have two distinct real solutions. Now, when the discriminant is a perfect square, that means its square root will be a whole number. And that means that the solution to the equation AX squared plus BX plus C, the quadratic equation, will have two distinct rational solutions. That is to say the solutions will either be whole numbers or they'll be fractions. If the discriminant is not a perfect square, but it is still positive, that means you'll have two distinct irrational solutions to our equation AX squared plus BX plus C equals zero. And so whenever your discriminant is positive, you'll have two solutions to the equations, which will represent X intercepts on the graph. Perfect squares will give you rational numbers. Non-perfect square will give you irrational solutions. Now, another possibility is, what if your discriminant is equal to zero? B squared minus four AC equals zero in that situation. When we take the square root of zero, that is zero. And so that tells us that the solution to the quadratic equation will in fact be a rational number, but you only get one solution because if you add zero or minus zero, it does the same thing. In that situation, your solution would just be negative B over two A, like so. And you just give one solution to the equation AX squared plus BX plus C equals zero. Graphically speaking, that tells us that the graph would only have one X intercept. And what's interesting in this situation when you're discriminant is zero, this is actually the situation where AX squared plus BX plus C is already a perfect square. Because we got the quadratic formula by completing the square, it turns out if you're discriminant zero, the polynomial is already a perfect square and you could solve it by factoring, you just get the one solution. Now the third possibility is what if our discriminant is a negative number? If the discriminant's negative, you're gonna be taking the square root of a negative, which actually will give you non-real complex solutions. You'll get two different complex solutions to the equation AX squared plus BX plus C equals zero, and they'll be conjugates of each other, complex conjugates. You'll get some number that looks like X plus YI and X minus YI, something like that, two complex numbers, they'll be conjugates of each other. Now in terms of the graph, if we're graphing the function F of X equals AX squared plus BX plus C, if this equation has no real solutions, that actually means it'll have no X intercepts on the graph. Because the idea is, even though we can solve algebraically a equation for non-real solutions, when it comes to graphing, we only accept real numbers coming in and real numbers coming out. That was our original domain convention. And therefore there's no real number we could insert into the quadratic function that produces zero. So the graph will have no X intercepts to it whatsoever. And so I wanna illustrate again these three possibilities. The first possibility is when your discriminant was positive. When your discriminant's positive, you'll get two distinct X intercepts on the graph. You have two distinct real solutions, which will be either rational or irrational depending on whether D is a perfect square or not. If the discriminant is equal to zero, then you'll get one X intercept on the graph of the quadratic function. This will correspond to one real solution. And when your discriminant is negative, that means your quadratic equation has two non-real solutions. But in terms of the graph, the graph will have no X intercepts. So the graph is either entirely above or entirely below the X axis, as you can see in case number three right here. So what I wanna do then is just check, not actually solve the solutions of these things, but I just wanna check real quick what would the solution sets, what's the nature of the solutions for these quadratic equations. That's what we wanna check here. So for the first one, we have A equals one, B equals negative three, and C equals negative 40. So we wanna compute the discriminant. D equals, well, just remember what's inside of the quadratic formula there.   Negative 40, I should say. I miswrote that earlier. See, you have to be very careful. You grab the negative signs right here. So C is a negative 40. And so then continue on with this. We're gonna end up with negative three squared, which is a positive nine. Negative three times negative three is a positive nine. And then you're gonna get a positive because it's a double negative of 160. 160 plus nine is 169. And so 169, I wanna mention two things. It's 13 squared, but it's also a positive number. So what does this tell us about the solution set of this quadratic function? So what we're gonna see here is that since the discriminant is positive, we're gonna see that there are two real solutions to this equation. For which we could say there's also two X intercepts if we were to graph this thing. And but because the discriminant is a perfect square, we could also say the solutions are gonna be rational numbers. They're either whole numbers or they're fractions. One of those two things are gonna happen. We can continue to solve it if we want to. But if we just wanna determine the nature of the solution, well, we see that's gonna be two real, two rational solutions to this one. Well, how about the next one? The next one here says two X squared minus three X plus four equals zero. So we see that the A value is two, B is negative three and C is positive four. So the discriminant will look like B squared, which is a negative three squared again, minus four times A, which is two, times C, which is four. And then simplify this. We get nine minus four times four is 16. And if you double that, you get 32, for which we could stop right there if we wanted to. We already know that this is gonna be negative, but if you wanna be a little bit more precise, this is negative 23, but in particular, it's negative. And so what we see here is because the discriminant is negative, we're gonna see that the equation has two non-real solutions. Now, I wanna mention that it's not good enough just to say that it has two complex solutions because every real number is a complex number. It's like saying, oh, there are two plants growing in my backyard. What type of plants are we talking about? Are these bushes? Are these trees, right? So non-real solutions mean there's some non, there's imaginary component going on here. Complex numbers versus real numbers. It's not an either or situation. Real numbers are complex numbers. So because the discriminant's negative, we wanna say there's two non-real solutions to this situation. Of course, you could say there's no real solutions. That's another way of explaining this one here. Looking at the next example, we get 4x squared minus 12x plus nine. So you see that a equals four, b equals negative 12, and c equals nine. So the discriminant here, we're gonna get negative 12 squared, which is 144, minus four times nine, like so. Of course, the 144 is negative 12 squared. Four times nine is going to be, let's see, four times nine is 16 times that by, sorry, four times four is 16. Four times 16 times nine, that's gonna be 144. So this actually turns out to be zero. So what that tells us about our solution set is that because the discriminant is zero, so this equation has a single real solution. Turns out that this equation right here is a perfect square trinomial. In fact, we could have factored this thing as 2x. Let's see, there'd be 2x minus three quantity squared if we had factored it, and that would give you the solution of that one. And then for the last one, x squared plus 6x minus eight, we see that in this case, a equals one, b equals six, and c equals negative eight.  And so we see in this situation, you get 36. I'm sorry, it's gonna be plus 32. Watch out those signs there, because you have a negative eight. Let me go back and do this a little bit more detailed. We get six squared minus four times one times negative eight. This is 36 plus 32, which is gonna give us 68. 68 is positive, but it's not a perfect square. So what this tells us is that this equation has two real solutions, which are irrational, because the solutions are gonna involve this plus or minus the square root of 68.


So, myself Dr. Amit Tharpaji, I am a consultant neurosurgeon and head of the department at Manipal Hospital, Bhan Air Kune and I specialize in cerebrovascular and epilepsy surgery. So, today we are going to have a small glimpse at our center of excellence for neurosciences and I am going to navigate you to our Neurosurgical Operation Theater and also introduce you to the state of the art technology which we have and the advanced gadgets, microscopes and how we utilize this advanced technology for performing complex neurosurgical procedures. So, this is our state of the art modular neurosurgical operation theater and we have this state of the art operating table, the shadowless lights, this is a head clamp which we use for fixation of the patient's head and this is a neuro chair which is a hydraulic chair for ergonomic reasons. We always sit on the chair and operate because we have to operate for longer hours and it is easy on our hands and it gives a greater stability when we operate sitting in a chair. Last one year we have done many complex neurosurgical procedures in this operation theater. And as you know neurosurgery is a complex branch and to avoid major problems in the postoperative period we need to preserve the brain, we need to preserve the blood supply to the brain and remove only the tumor tissue. So, how do we achieve that? So, we need magnification for this and that is why we use a microscope. So, let us see how this microscopes we have got a Zeiss Tivato model and this is a very high end microscope which gives us magnification, a good amount of light which is brighter. We can record the operative videos also and it also gives an assistant view so that another competent person can help me during the surgery. So, this is the microscope and we can move it in all direction, this is the eyepiece and this is how the screen looks and this is one of our operated videos and this high magnification we can operate at which is like 10 X or 12 X zoom and we can even put sutures on the blood vessels. So, this is a very important tool in neurosurgery and which helps us to do good exhesion or good micro neurosurgery without creating problems or blood related issues in the brain and that is why the patients will recover faster and smoother. So, for further accuracy whenever we want to localize any tumor or a small lesion inside the brain we need to navigate it and that is why we have this metronic steel station SA8, very advanced navigation machine which helps us to register the patient's head inside the machine and we can actually navigate various points on the skull as respect to the MRI. So, this is the patient's MRI which is being fed into this machine we can see. This is a three dimensional view of the patient's brain, the tumor and the various important tracks which go around the tumor. So, this machine will help me in actually localizing the tumor in actually localizing the vital structures around the tumor and that will help me excise the tumor with greater accuracy, sub millimeter accuracy without damaging the normal and vital structures of the brain. So, this is a very crucial navigation machine which is advanced one and we have various features like tactography, spine navigation, biopsy modules everything can be done and I think this is a standard of care nowadays for performing state of the art neurosurgery. For SA8 and maximal resection of the tumors we need to remove the tumor without causing damage to the surrounding brain and for that we need something called as QSA. QSA is Kavitron ultrasonic aspirator machine and the probe of QSA actually softens the tumor from inside and sucks it at the same time. So, it we do not have to pull the tumor from the brain structure.  So, if we have QSA we can Kavitron the tumor from within and then slowly we can dissect that tumor from the surrounding brain. So, very important measure for glioma or the CP angle tumors and it is a must in armamentarium for excellence of neurosurgery. Apart from this we also have a high end bipolar machine which is used for coagulating the smaller blood vessels without spreading the current to the surrounding structures. So, that they are not damaged and we can be very precise in stopping the bleeding and we also have a state of the art drill system. So, drill system is basically making a hole inside the skull then removing a part of the skull that is the craniocoma and also drilling the smaller bones or other non-critical parts of the skull base with a very fine diamond drill. So, all these gadgets are very crucial in performing a safe and complicated neurosurgical procedures. So, Manipal Hospital Bhaner Pune has set up a center of excellence for neurosurgical procedures and we have a state of the art operation theater and as I showed there is microscope, QSA, drill, navigation, interoperative monitoring and we have been doing very complex and major neurosurgical procedures here with relatively good outcomes like awake craniotomy, resections of glioma under neuro monitoring, epilepsy surgeries, CMCA bypasses, CP angle tumors, endoscopic skull base procedures, endoscopic excision of pituitary adiomers and many more. So, because of the advanced technologies we have been able to reduce the patient state as at the same time we are able to preserve their neurological function because of the high end technology and advances. Setting center of excellence at this Manipal Hospital Bhaner Pune for neurosciences is dependent on performance of a team and a good teamwork and we have Dr. Shreya Shah who is my colleague neurosurgeon, we have neurologist Dr. Shruti, we have good intensive care, we have ICU intensives then we have a good anesthesia team who are expert in performing awake craniotomy and complex neurosurgical procedures. Apart from that we have strong backup of all the clinical specialties and super specialties and good OTT.


Hello Foundation staff, this is Level 2 researcher Theron Sherman, and today's broadcast addresses some unusual break room protocols. It's SCP-5499. Object Class, Safe. Threat Level, Green. Special Containment Procedures. SCP-5499 is to be stored unpowered in the **** equipment storage wing. Due to the nature of **** primary project, transfer of SCP-5499 to a proper containment site has been deemed unfeasible at present. Description. SCP-5499 is an L71 brand smart refrigerator, Model 2S. Prior to its installation in the **** break room on January 31st, 2005, SCP-5499 displayed no anomalous properties. Outside of direct observation, SCP-5499 is capable of damaging foodstuffs placed within its chassis. Such damages occur in bursts of 1-4, typically spaced at least 4 hours apart, and are accompanied by a series of messages displayed across SCP-5499's touchscreen. The process by which SCP-5499 chooses foodstuffs is unknown, although it shows considerable preference towards foodstuffs of sweet and savory flavor profiles. SCP-5499 was discovered following a series of complaints to the **** human resources department. Addendum 5499-001, Observed Activations. The following is a rough approximation of the date and time of select activations based on available security footage and subsequent tickets filed with the human resources department. In the interest of budget, no tests were conducted on SCP-5499's anomalous properties. This table lists estimated date and time, damage observed, and messages. February 1st, 2005, 1300 hours, 44 minutes. Bottle of iced tea completely drained. Message. Mmm, haha, just what I needed. February 1st, 2005, 1800 hours, 1 minute. Containment specialist **** Lunch disappears, and Officer **** Brownie is reduced to half its original mass. Message. Ah, that hit the spot. February 2nd, 2005, 1400 hours, 48 minutes. Technician **** Birthday Cake is covered in a series of uneven depressions with a plastic fork stuck into its side. Additionally, a carton of milk has been nearly drained. Message. Yeah, this is the good stuff, mm-hmm. February 3rd, 2005, 1300 hours, 36 minutes. Officer **** Lunch disappears, and Dr **** Tandori Chicken is missing a rough hemisphere of mass. Message. Hmm, not my thing, but maybe it's an acquired taste. February 4th, 2005, 0800 hours, 6 minutes. Vacuum flask of blood partially drained, and blood splatters across the interior of SCP-5499. Message.  This concludes today's broadcast. Please like, comment, subscribe, and hit the bell using your encrypted YouTube account, and support the broadcast at patreon.com slash site 42.


Have you ever seen the look of apprehension on a colleague's face or even terror when you mention using a technology tool that they're not familiar with? I remember speaking to a colleague on the Malt program and I mentioned to her about creating a screencast of her work and her eyes widened and her jaw dropped and I can tell you it wasn't from excitement. But interestingly enough that's in sharp contrast to her demeanor a couple of weeks later when she arrived at my office to proudly show me the screencasts that she had made for her students in the meantime. So what happened in the interim? Well if you don't mind I'll just park that for a minute and just tell you a little bit more about what we do. Embedding technology is a strategic goal in DKIT and in the last number of years the Malt program has emerged I suppose as a key driver of that because we've had almost one hundred of our own staff that's over one third of the teaching staff who have undertaken the program. And what do we do then? Well we model as a team we model and all our modules are blended so that gives our colleagues an opportunity to experience blended learning first hand. And then in the first module of the program our focus isn't really on technology it's on student-centered learning and we ask our colleagues to reflect on and critically evaluate their own practice but we do use technology. We introduce it gradually but only for the delivery of the program and that's really important to us because then it gives our colleagues a chance to experience it as students themselves and that gives them an insight into their own students' experiences. And we do model the use of the technologies and we introduce them as I say and we hope during that module that some of our colleagues will go on to adopt some of them and actually many of them do and they do it well in advance of our second module which focuses much more on using the technology. So when they come to the second module our colleagues still continue to use it as students but now we ask them to use technology and to look at it as teachers and we ask them to critically evaluate the technology tools that we show them and to look for tools that are appropriate for them and their students. And many of our colleagues come with diverse experiences of using technology in the classroom and even though most of them are quite open to it some of them are actually quite nervous about it. So how do we get over that? Well what we do is we encourage them by taking small steps we introduce them to tools that they can easily introduce into their own classrooms and which give them quick benefits. But all the time we ask them to be guided by those principles that they met in the first module the principles of student-centered learning, constructive alignment and to bear in mind that the technology that we're showing them is really only a catalyst for the learning. And I suppose what's really important about that module is that it provides a safe space for our colleagues to try things out, to experiment, to take risks and step into what some might call a liminal space. So what about the colleague from earlier with the screencasts? How did she move into the liminal space and beyond it? Well in the lab, our practical lab, we introduced the screencasting software she and her colleagues tried it out, they made mistakes and they tried it again but what we saw that day in the lab was a palpable excitement among our colleagues as they were encountering a tool that they could see tremendous potential for and this colleague, well her eyes were wide again, they were but this time it was because she had found something that she felt she could use in her practice something that would be a real benefit to her students where she could explain exercises to them and they could do the same with her. It was what you might call a threshold moment for her. Does the Malt program have the same impact on all our colleagues? Not surprisingly, it doesn't really. I was reading recently that we can't create a version or recreate someone else's happiness we have to create our own version and it's the exact same for our colleagues with technology they have to find tools that are appropriate for them and even more importantly their students and some of our colleagues, they are happy for the moment with minor changes others implement technology tools to a much larger extent some even go on to use them for their final research papers in the program others even take it on to doctoral studies and what about the institute as a whole? Well, change like this takes time really but our recent survey suggests that there is a momentum building and that's due in no small part to the evangelism of the staff members who have been through the Malt program and as any of them will testify, once you make that transition or cross that threshold, it's a bit like the butterfly emerging from the cocoon there's no going back. Thank you.


Hi everybody, and welcome to Take a Door of the New Microsoft Office for our webinar today on February 1, 2013 for those of us on the west coast. This is still morning, but good afternoon to everybody else in the United States as we're coming today. Just a little bit about ReadyTalk, which is the webinar tool that we'll be using. If you have any questions whether or not it's about the content, or how to use ReadyTalk, or basically any questions that pop into your mind, you can ask those via your chat box. Everybody is going to be muted today, but you can still ask those questions via chat box. We will be trying to get to all the questions that come in either in that chat box or read audibly to all the presenters at question break throughout the middle of the webinar and at the end of the webinar. If for some reason we do not get to any of your questions, we will be following up with you following the webinar, so never fear, we will get your questions answered. If for some reason you do lose your internet connection, you can reconnect to this webinar via the link that was emailed to you. So just the same way that you connected the first time, you'd be able to just get back in there that same way. And just as a reminder, we are recording today's seminar, so if for some reason you too need to leave the webinar early today, or you just want to review the information that is provided, you will be able to view this recording. We will be sending out the recording to everybody this afternoon. Everybody who registered for the event should get that email. And we will be eventually putting that up on the TechSoup website. So again, this is Tika Taur of the new Microsoft Office. We're really, really excited about this webinar today. I first want to go ahead and give a big thank you shout out to Microsoft as always. They have been such great product donors for us, and I'm just really, really excited that they are participating on this webinar today. If you want to take a look at information about new Microsoft Office products available through the Microsoft Software Donation Program, go ahead and open up as bit.ly. You'll need to just go ahead and type it into your browser. You might want to do that after the webinar, and I will share that at the end of the webinar as well. And we will be emailing this link out to everybody as well. So a little bit about the presenters today. My name is Kyla Hunt. I'm the facilitator. I'm the webinar program manager here at TechSoup. And with us today is David Alexander from Microsoft. David is the product marketing manager on the Office Technical Marketing Team at Microsoft in his role as David Managers' demo strategy across the Microsoft Office division. Also with us is Jenny Meats from TechSoup. Jenny is a content curator at TechSoup. Before coming to TechSoup, she was a senior editor for PC World where she covered mobile phones as well as consumer advocacy issues for both the website and the print magazine. And for all those librarians out there, you'll be happy to know that she's currently in her final year at San Jose State University School of Library and Information Science. And assisting with chat, you might see these names pop up in your chat box. Becky Wiegand from TechSoup, Christian Dio from Microsoft, Don Leeds from TechSoup, and Cameron Jones might be stepping in. So a little bit about the agenda today. First, David is going to take the reins. He's going to be talking about giving us an introduction to the new Microsoft Office as well as a demo and tour. Then we're going to stop, look at what questions have come in, maybe read a few to David and see what he has to say. And then I'm going to hand it over to Jenny who's going to take that basic tour of the new Microsoft Office and kind of bring it into perspective for the nonprofits and libraries out there. So the first section is just going to be kind of an overview of what Office has to provide. And then the second half is really going to be geared towards the nonprofits and libraries. And so with that, I'm going to go ahead and let David share his desktop on mute himself and take it away. All right. Hello everybody. Good morning. Good afternoon for those on the East Coast. And good evening. I even saw someone, I believe, from South Africa on the call here. It's a pleasure to be here and talk to you today a little bit about the new Office. As some of you may have seen, just on Tuesday we released the new Office for Consumers, our home premium offering on Office 365. It sort of represents a revolutionary new release for Microsoft. And in general, this new version of Office that we're coming out with right now is a pretty big step for the company and a pretty pivotal time for Microsoft in general, not only in Office, but across the company for things like Windows and the Surface and Windows Phone and everything else. And so it's really a pretty pivotal transition time for Microsoft to be becoming a services and devices company. And the new Office actually plays pretty heavily into that. I think I have actually a very, very fun job at the company. I really enjoy what I do, which is basically I get to show off the product. I get to play with toys all day long, so to speak, if you consider a software toy. And my job is basically to do demos and talk about what the new Office really looks like when you actually dive into the product and click and play around with it. Before I actually show you live product, I do want to tell you just a little bit about the new version of Office and the things that went into the way that we built it. There are sort of three major influences depicted here on this slide that were really front and center when we were developing the new version of Office that I'm about to show you. One of the first things is this notion of devices and device proliferation. Some of you may have heard of this concept of the consumerization of IT, or you may have heard it differently, but what this really means is more and more people are bringing their experience with software and with devices on a personal level in their consumer lives. They're bringing those expectations to work, and they're expecting the same level of technology, the same types of devices, the same level of capabilities from the technology at their workplace as they have in their personal lives. People are becoming less and less patient with a company that might be on one or two or even three versions of a product that are older than the one that they're currently using in their personal life. Alongside that is just the number of devices that people have. People are on the go with smartphones. Right now, based on Forester research, it's estimated that there will be about a billion smartphone customers by 2016. That's a very, very large percentage of the world. So what the experience for productivity looks like, not only on the traditional PC, but across devices like tablets and phones, or even new types of devices like large screen touch devices and displays, all of those experiences are things that we had in mind as we developed the new version of Office. The second thing you see here, people. The way that people want to get things done is also changing, and there are a lot of generations in the workforce. Actually, this is the first time in modern history that we actually have about four generations of people in the workplace. And so we have newer generations, particularly generation Y, that have different expectations of work and life that come from experiences with cloud technology, cloud email, cloud collaboration, and other things like that, maybe in student projects that they did in college or even high school. And you have generations that go all the way up to the workforce that's about to retire. And those folks have had technology at various points in their working lives but probably not evolving and changing as quickly as it is now. And so we've thought a lot about how to accommodate all of those generations and provide revolutionary new experiences that still don't alienate anybody. So we make the technology very accessible. The last thing on the right here is cloud. As I said, it's sort of a pivotal moment from Microsoft where we're really transitioning to a devices and services company, and we offer a lot of services. And this is the first release of Office that is really available front and center as a cloud subscription offer. Of course, we are still offering on-premises versions of the Office products. So you can still buy Office 2013 and install it on your physical computer the way that you've been used to. But we are now offering a subscription where you can keep your version of Office up to date perpetually if you're a subscription customer. And that goes for both consumers as well as businesses. And you can see here on the right there are just a couple of statistics about the rate at which companies are starting to think about the cloud and adopt pieces of the cloud. A lot of people take for granted today that an email experience that we are all very familiar with probably in our personal lives is actually cloud computing already. Email has been one of the first workloads both on a personal and professional basis that has moved to the cloud and things like storage for documents and collaboration and other types of productivity software are also moving to the cloud and companies are looking at that. As I said, we are still offering on-premises versions of all the products, both client like Word, Excel, PowerPoint, everything like that, as well as the server products, Exchange, SharePoint, Link, and everything. But we are also offering cloud versions of those products. And we are giving companies choice about whether they deploy on-premises, completely in the cloud, or whether they have a hybrid of the both that they want to coexist together and look like a single organization with some users on-premises, some users in the cloud, but still have it look and feel like one company. And so that basically brings us to what the new office is all about. And it really is summed up by four pillars here, devices, social, cloud, and then control. I'm going to go through these just really quickly, but I think I'm actually going to spend most of my time on demoing it and showing these key notions through the demo. But devices, as I mentioned, we are really trying to create a great experience for the new version of Office on all sorts of devices. Of course, Office is great with mouse and keyboard as we have always been with previous versions. But we are also taking touch into account, stylus, pen, and ink into account. What experiences for productivity look like on a touch-first device? So you will see some of those features play into the demo that I do and the new version of Office. The new version of Office is very social. And we don't just think that social is a place to go like a traditional newsfeed type of thing. We think that's a part of it. And having an enterprise social capability in your workplace can be a part of what social means. But we think it also includes having social activity be a part of every part of how you work. And so having good representations of people or understanding what people are up to while you are communicating with them in different ways. Having asynchronous as well as synchronous communications or real-time communications and having all those abilities right at your fingertips so you can choose the best way to communicate with someone given the type of activity you want to do, we think that that's part of what social really means. And then cloud as I talked about, cloud is a big part of the release not only in the way that we offer it but in the way that some of the features come to bear. And that's not just for people that go with Office 365 and use the cloud offering. For the on-premises versions, Office 2013, the version that you can install in the traditional fashion, you still have a lot of cloud benefits accruing to those customers as well. Because a lot of the things that we did to design the product to be very cloud ready mean that you will get scalability benefits or access and connectivity benefits on the on-premises versions just as a result of the way the product was designed from the ground up. And then let's pertinent to today's conversation but particularly pertinent to IT professionals and folks in the organization that manage the Office deployment. We've done a lot on the control compliance side of the new version of Office to really make Office a top grade product for companies that really want to make sure that data is protected and compliant. And so with that I'm actually going to end the presentation here and actually just start showing off the product. So the first thing that I actually am going to do, I'm going to open a different PowerPoint presentation here. The first thing I'm going to do is actually start in PowerPoint. So this is the new PowerPoint 2013. And there are a few things that you might notice about this version of PowerPoint. The first is that it actually looks a lot cleaner. We've done a lot to really clean up the user interface and help people stay focused on the content that they're working on and not as much the Chrome or the navigational elements surrounding the content that they're working on. Of course all of the controls that you've been used to for the ribbon for example are right here when you need it. So you can just tap or click to expose the ribbon. But a lot of these elements disappear and don't take up space when you don't need it. And this is particularly important for smaller screen sizes that people are using more and more like tablets or smaller ultrabook PCs that they're using at work. Of course people still use large displays and this is going to work great on that. But we're helping to really keep people focused on what they want to get done, not how they do it. The other thing is for people with touch, we've integrated into Office a new touch mode. And you'll see when I tap here in the top, you'll see that I can tap between a mouse mode and a touch mode. And the mouse mode basically contracts everything, makes it a little bit smaller. But if I use the mouse and come up here and click into touch mode, you'll see that everything expands just a little bit larger to make it more touch friendly and the touch targets are a little bit larger. So you can see we're really trying to have the single version of Office accommodate both people with mouse and keyboard as their primary method of use, as well as folks interacting with Office with touch. So the next thing that I want to talk about is a very common scenario with PowerPoint. And that's presenting a PowerPoint presentation. There's a statistic, and this is definitely common here at Microsoft, that people spend about the first 12 minutes of a meeting in a conference room actually doing things like messing with a projector and dealing with projector settings on their laptop to try and actually figure out just how to make a PowerPoint presentation work and show up properly. Well in the new version of PowerPoint, Office works with Windows to mess with the Windows projector settings. So all you have to do is literally just press the present button up here and it goes ahead and launches that presentation. And if you're connected to a projector or a second monitor, it will automatically extend your screen so that that projector is showing the slides while your personal monitor actually shows you a very touch friendly presenter view, which I'll show you now. So I'm actually going to launch that presenter view from down here. Again, if I were connected to an external projector or another monitor, they would still continue to see that full presentation taking up the entire screen. But I have this set of presenter controls right here at my fingertips. It's sort of like a cockpit for your presentation. It gives me all the things that I need to be a confident presenter without sort of betraying any of that additional information to the audience. So it lets me be confident and focus on the presentation and not so much how I'm actually going about it. You can see that on this presenter controls here, I have a view of the current slide. In the top right I have the view of the next slide. Down here I have a view of my notes and I can scroll through these notes if I want to get a view of all my notes. I can resize everything if I want. And you can see I'm doing this all with mouse. I can also do this with touch. You'll see the little black dot which represents my finger where I'm touching the screen. And then I can also do things in this presenter dashboard like zoom in on a particular slide. So I can choose, hey, let me zoom in right there. If there's a particularly zoomed-in part of a diagram, maybe I want to zoom in down here on this sort of March 1987 area. And so you see that these presenter controls help me be really effective without having to think a lot about how to do it. I can focus on getting my message across and communicating with my team rather than what the software is actually doing to let me do that. There are other things that I can do as a presenter, including things like using a laser pointer or I can do inking. And you can see that I'm doing this with a mouse, but I can do it just as easily with a stylus. So I'll take this and sort of cross out a word or two here so you can see that these presenter controls are very touch-friendly as well. So you can imagine that this is great for a situation where maybe you want to present off of a tablet, especially as wireless display technology becomes more and more prevalent. You can imagine just walking into a conference room, connecting wirelessly to a projector, and walking around the room or the stage with a tablet in your hand, presenting really slick and confident as a presenter. So that's a little bit about PowerPoint. Now I'm going to flip over to Outlook. I'm going to come back to my Windows Start screen here and tap into Outlook. And I'm going to go back to my inbox here. And so again you'll see the same notion that I described with PowerPoint. You can see the user interface is really cleaned up, again helping the user focus on the content, not necessarily the Chrome. And you can see again I have this touch mode that if I flip between mouse and touch, you can see that the controls expand. And in touch mode I actually get these controls on the right over here to mark as unread, delete, reply. So I can do a lot of these things in a touch friendly way. I also can do things like instead of actually having views of the calendar or people pinned to the side and taking a more room like we used to in the last version, I get peaks at that information. And these peaks are interactive. So I can actually go ahead and click through different days to get a view of my calendar, or I can go ahead and look at my favorites, or initiate a quick search of people across my organization to get a quick view of them. Again, this is available to me just when I need it, and it's not taking up space on my screen when I don't need it. Other things we're doing to help preserve screen space include inline reply. So I can now type a reply here. It sounds good. And if I go to a different email, that reply will actually be saved inline with the rest of the conversation. So I don't need to go searching through the drafts folder to go find it. And at the end of the day, maybe if I've started composing a whole bunch of emails, I can just sift through my inbox and see which ones I need to finish typing and send before I go home, again keeping it part of the conversation. The next thing that I want to show here in the people peek is a view of the person card, the people card rather. And this is one of the pieces of office being social that I discussed. So here we have Molly Dempsey. And wherever you see a person's name in office, you'll be able to get a card like this for that person which shows all sorts of information about them. In this case, I may have a few different contacts saved for Molly. You know, I might have Molly's cell phone number. I have her personal email address. I have her work email address. And instead of actually showing different contact cards for each disparate piece of information, I have a single card for Molly that's showing me all the information about her in a single place. I only know one Molly so it makes sense that I would get all the contacts on her that I need in a single place. That can bring me information about the organizational structure or even bring in social network feed information if my company has allowed that. So you see it really lets me get contacts on Molly right through this single card here. And if I go anywhere else in office again, I see Pavel here. I can hover and get a view of that card just by expanding that here. And that's consistent across the entire office experience. The last thing to show here in Outlook is a new app model that we have where basically any web developer can become an office developer and use their programming language of choice to actually embed contextually appropriate information into the office experience. And so you can see there are a couple apps showing up here above this email. Because there is an address in the email, the Bing Maps app has been triggered. And if I just expand that here, it will actually show me a Bing Maps map pulling in web data against that address to show me a live view of that data. And it's interactive too so I can just pinch and zoom. I can twist this around so I can get a lot more context and bring in relevant information through that app right into my office experience. I don't have to go to a separate website or app to get that contextual information. So again, it helps me complete flows that I want to do and get more information right in context and help me be more productive and focus on what I'm trying to get done, not what app I'm doing it in. So the next thing that I want to show is I want to show Word. So I'm going to come down here and open up Word. And you'll see that the start screen actually looks a little bit different. The first thing is we know that most users actually resume working on a document that they were previously working on. So instead of putting you into a blank document, we're going to show you your list of recent documents right here on the left. So you can easily click into a document and resume working. If people don't want to resume working on a previous document, we know that a lot of those users want to actually get some help with the template. And so we have a lot of great new templates and connectivity to template services on the web through Office.com that pull in templates that help people get started with really rich, professional, beautiful looking documents as simply as clicking to select any of them. The third thing that you'll notice in the top right is that in this case, I'm demoing as Katie Jordan, Katie is logged in. So there's now a notion of being logged into Office. This is particularly relevant for people who subscribe to the service because you'll log in, and so is your cloud identity following you. But even for on-premises customers, when you're logged in with your organizational credentials, you'll be logged in and you'll have all of your custom dictionaries, your recent documents list for things that are synchronized with company SharePoint sites. All of those things will follow you based on your identity. So this notion of it being your office, kind of wherever you go, being very personal, is a big new change for Office. If I go ahead and click here into the North Wind proposal, you'll see that it goes ahead and launches that document. And then because it knows me, it's my office, there's this little toast that comes up that says, welcome back. Pick up where you left off. So I can click here and resume working immediately in that document in the place that I was last working, letting me pick up where I left off, even if this is a new machine that I haven't been using before. Because I'm logged into Office, my identity is tracked along with Office which includes all of the metadata about these documents that are synced through the company SharePoint site, or if I'm in the cloud that are synced across the cloud. So the next thing that I want to show is a very common situation for people who work with PDFs. So in Office 2010, we introduced the ability to save to a PDF. But a very common problem for people has been, well, if I have this PDF, how do I actually edit it without having the full PDF product? And so a lot of people will do is they'll select all, they'll copy, then they'll come back into Word, and maybe paste it here in a new document. And you'll see it loses all of that formatting that it previously had. And this can be very frustrating, especially if you were the author of that PDF in the first place. Maybe all you want to do is change the date or do some other small change. Well, with the new Word 2013, you can actually go ahead and ingest a PDF and open a PDF in Word and it will preserve that formatting, but it's a Word document. So you can see I've just opened that PDF, but it's a Word document. I can highlight, I can edit some text, and I can resume working immediately as I want to without getting stuck on all these file conversion issues. Again, Office is helping me focus more on the flow and the type of work that I want to get done, not how I'm doing it or what app I'm in. The last thing that I want to show here in Word is Word has always been great as an authoring tool, but as a reading tool we've introduced this new read mode for folks that are on the go with Word documents that want to consume content. And we've done a lot of research into what type of reading experience is pleasing and how to reflow text. I'm going to reflow my original document. You can see this read mode takes that Word document and presents it to me in a touch-friendly kind of reading optimized view. I can swipe through it, or if I come to a small graphic, I can just tap on it to zoom in or zoom even further to get a view, but it doesn't take up the whole screen when I don't need to look at it. Or if maybe I'm on a plane or something like that, I can change the lighting scheme here to make it more easy to read or change it to CPO or something like that. So you can see we've thought about what these new scenarios on more than just PCs actually mean for Office, what it means to consume content on the go with a touch-friendly device. I'm now going to flip over to Excel here. So this is Excel 2013. And along the same lines of making content more accessible and the power of Office more accessible, we have a new feature called Flash Fill. So a very common scenario here is I have a whole bunch of data that's been kind of mung together. You see in column B that there's a whole bunch of data with event codes and names and things like that. And what a lot of people would traditionally have to do is either develop some sort of complicated macro which not a lot of normal people know how to do, or they'd have to just start rekeying, retyping that information. But the new feature called Flash Fill actually lets you start typing. So I'll start typing John and then Jenny. You can see after just typing two cells, Excel has actually inferred the pattern I'm trying to complete and giving me the option to just press Enter and complete that pattern. And you can see that basically what's done is it's saved me the work of having to redo all that data. I can do the same thing with events and then advertising. And you can see it's smart here with that third cell digital marketing. It's pulled out both of those words. And you can see with just four cells, I've actually rekeyed this information. And now I have a whole set of data that's nicely formatted and ready for me to do some analysis on. Excel has helped me get from data to insights quicker without having to focus on all sorts of deep complicated things to get that data formatted properly. Along the same lines, we now have a tool called the Quick Analysis Tools which give me sort of live previews of what different types of charts or formatting might look like for this data. So I can just sort of hover over these different options and get a live preview with my data of what that type of chart might look like. So I can very easily and visually understand what the best way to represent my data is. Maybe it's a clustered column chart or a pie chart. Maybe it's a table, a different table, or a pivot table. Not a lot of people know how to create pivot tables or even necessarily what they are. But you can see here just by hovering that there's a very powerful, compact view of this data that's available to me. So I can just click and get a pivot table just as quickly as I did with a single click here. Again, helping me get from data to insights quicker and get the technology out of the way of the person that's trying to be productive. The next thing that I want to show is one of the ways that the new version of Office is particularly touch optimized. So we still have all the products for the desktop as you've been familiar with in previous versions. But now with the Windows 8 experience in the Windows 8 store, we now have this new class of touch first immersive content applications that are available through the Windows Store. And we've released two of those for Office. One of them is OneNote, which is a note taking application. And so this is an immersive touch optimized version of OneNote. We still have the desktop version of OneNote 2013 available. But this is completely touch first, and you can see it prioritizes all that content full screen. I can just sort of swipe to expose my different notebook lists. But when I am dealing with my content, I can just have that take up the full screen here. And because it's a touch first application, we've thought a lot about how to actually let people do rich things with their content in a touch first way. So you can see I can just use these touch friendly handles here to highlight some text. And then this A comes up on the right here. And this is what we call the radial menu. And this is a touch optimized set of controls for dealing with that text. So I can just swipe to get this sort of speedometer type of thing maybe to change the font size. That looks pretty good. Or maybe I want to change the color. And David, just to interject, you have about 5 minutes. Sounds good. Thank you. I can swipe here to get different colors or even a richer palette of blues. Or I can tap back and get some formatting options. So you can see that a lot of rich capabilities right in my fingertips literally. If there's no text selected, you can see that this radial menu becomes a little bit different because the app is able to infer that without text selected, I may want to input some content instead of edit content. So it gives me options using touch friendly controls to input content, whether that's a new table, or a list, or a set of to-dos, or in this case the device is aware that I have a camera built-in. So I can go ahead and use that built-in camera to insert maybe a photo of a whiteboarding session or some notes. Here I have a piece of paper. Maybe I want to go ahead and add a couple of notes here. Hey, add the new TV to this list or check the specs. I can just tap to take a picture, and then use some touch friendly crop handles. Maybe I just want the note that I wrote to myself. And I can just dump it right there into the one note notebook. And because this notebook sinks across the cloud or a company's SharePoint, I can make this available to other members of my team or access it from different machines. And you can see I've gotten this rich content right into my notebook using only touch friendly controls in this touch-optimized version of OneNote. So that's a great example of how we've built Office to be really great on Windows 8 devices and thoughtful about touch experiences. The last thing I want to show in just a couple of minutes I have left is Link, which is our real-time communications client. And I'm actually going to go back here and tap into Link. So you can see here this is the Link buddy list which is akin to any other instant messaging and presence application. You have a list of buddies, and so you can have folks from your team. We're also federating with Skype, and so you can actually have folks you communicate with from Link to Skype. We have instant messaging, presence, and voice enabled at this time. And so this is a really great way to keep in touch with your colleagues. And so really easily I can just hover over a name here and initiate maybe an instant messaging session or a call or a video chat. I can just say hi to Alex here, and then Alex can type right back, hello. Or you can also schedule Link meetings. And so I have a Link meeting already scheduled here as part of an Outlook meeting. And I'm going to go ahead and join that meeting. So with just a single click I can go ahead and join, and it will connect me to this meeting that it looks like Alex Darrow is already in the meeting here. And I think Alex is already sharing his video. In this case, Alex's video is me talking. Hello, everybody. And I'm Katie Jordan, remember. And so I can very easily go ahead and start my video. And I get a little preview here first to make sure that my hair looks okay or everything is good before I start my video. And then you can see just as easily as that I'm in a rich video conferencing call with somebody else using the power of Link right here embedded with Outlook. And if there are folks that you want to join your call that don't have Link, you can still have them join using the Link web app. And so you can broadcast or integrate people outside your company into this Link meeting experience and rich video conferencing as well. And Link meetings are not only about video conferencing and the voice aspect, but it's also about sharing content. And so you can see here if I hover over this icon here, there are different types of content I can add. Maybe I want to share my desktop or share just a specific program or do a joint whiteboarding session or take a poll. Or maybe over here I can add notes to this Link session. And like I described before, we can use a shared notebook that everyone on the team together can go ahead and add notes to it, and we can collaboratively take notes during this meeting. Or a very common situation is presenting a PowerPoint through the Link meeting. And just as easily as this, I can click PowerPoint and upload this PowerPoint presentation into the meeting and use the meeting's set of controls to go ahead and control that presentation. And so I can go ahead and I can just click through the different slides. Again, there are some controls here that we can annotate this presentation if maybe we want to go ahead and cross out or make some changes and talk about this as a team. And everybody that's on the call can go ahead and do this annotation. So you can see that Alex Dero is putting some check marks over here next to other pieces of this chart. And so we can go ahead and collaborate together on this presentation and discuss it real time. So that's just a quick hit of Link and the entire Office 2013 experience and the new Office in general. With that I think my time is just about up, so I'm going to return control back to the slides and we'll continue with the next portion of the presentation. So thank you very much. Great. Thank you, David. I do want to go ahead and take a look at a couple of questions that have come in and then go ahead and give it over to Kenny Fishman. Give us a perspective of how nonprofits and libraries will be using this. This question has been addressed a little bit in the chat, but I thought that it was a good question. People are wondering, so would you recommend using the new version of Office just in Windows 8? So Office continues to be available for the Mac. We released Office 2011 for the Mac a little while ago, and we continue to make improvements on the Mac platform as well. And so customers can still get Office for Mac as well as Office for Windows. The new release that we announced on Tuesday is for Windows specifically, but I was talking about Office on mobile devices previously. We have already had Link and OneNote available on other mobile platforms like iOS and Android for folks to do things like note-taking and join Link meetings and be a part of this collaborative type of meeting process using other types of devices. So Office is really, we are thinking about other platforms besides Windows, but of course since Office is from Microsoft, we are going to have a great experience on Windows, but we also are conscious of the fact that folks use other devices and platforms to be productive, and we want to be sensitive to that too and be able to offer a great productivity solution there. Okay, great. And we did have a couple of follow-up questions to that, asking about using it on Windows 7. Yep, so Office 2013 is available for Windows 7. The immersive touch application for OneNote that I showed is something specifically available only for Windows 8 because it is one of these Windows 8 store applications that run out of that new operating system. But everything, Word, Excel, PowerPoint, Outlook, OneNote for the desktop, Link for the desktop, those are all available on Windows 7. And you can see that actually I am running them here, or in my demo you can see that I was running them there all out of the desktop mode of Windows 8. And one of the things that is very important about Windows 8 is anything that runs on the desktop in Windows 7 will work on the desktop of Windows 8 as well. So, yes. Okay, great. And I do want to make sure to give Denise some time. And a lot of these questions we can handle either at the end or after the webinar. But we did have a question wondering if Link allows recording. Link does allow recording, but it is something that is not going to be on by default. So you have to consciously turn it on. And then there is a warning that pops up to everybody that is on the call that the call is being recorded. So you make people aware that the recording has started. Okay, great. With that I do want to just go ahead and give it over to Denise. But David, definitely hang around for the questions at the end because we do have a lot of questions still to cover. So with that, thank you David for that really great demo. That was really fabulous. Thank you. Go ahead and get started and take it away. Hi everyone, and thank you David for that excellent presentation. I'm going to be showing you guys some ways you can use some of the features that David showed in your nonprofit or library. As Kyla said, I am the content curator here at TechSoup. And I've been spending the last month immersed in office and finding ways to solve little day-to-day problems that come up in the typical nonprofit or library. So I'm going to show you my next slide. So I came up with these little fictional people that work for fictional organizations, but there are problems that pretty much all of us have every day in our daily lives. So this guy is a volunteer coordinator, and he's never out of the desk. He's hardly ever in the office, but he needs to access all of his work email and his spreadsheets. So the whole office suite is connected to the SkyDrive service which is Microsoft's cloud storage service. So you can actually save your Word documents or your Excel files to SkyDrive and then access them later from either your mobile phone or your tablet or another computer. And you can do that by using Office Web Apps which is Microsoft's cloud version of the Microsoft Office suite. And you can access these documents within your Internet browser. You can view documents, and you can do some light editing as well. So moving on to our next problem, this person, Rachel, is an event planner at the Northern Next Food Bank, and she needs to create flyers but she doesn't have any design experience and she doesn't have a budget for hiring a graphic designer. So as David showed you, there are these new landing pages that come up in all of the Office applications, and particularly the Word one is really interesting for this person's situation because she can search through the templates and find something for like a fundraiser flyer or a newsletter template. And they are just right here, and you will see templates that you might have not considered previously or you had no idea existed. So it is a really useful feature if you want to do something really cool in Word but you are not really sure where to start. And another really useful solution for this person is the new image formatting features in Word. Previously, in other versions of Word, sometimes it could be kind of tricky getting your text and your image to align and work together, and sometimes you ended up just spending a lot of time trying to fit your image in and resize it and whatnot. So Word has these really new, easy image formatting options. They have something called alignment guides, and basically you just drag your image around and the text will automatically reflow to format around it. So it will save you a lot of time whether you are creating a newsletter or a flyer or just want to make a really nice pretty Word document. So moving on to our next problem. So this is a problem I personally have as a writer at TechSoup. I do a lot of writing and it goes through multiple hands and it goes through a lot of edits and there's lots of comments, and sometimes it can be hard to keep track of these comments. So this person, Allison, she is a grant writer and her projects are reviewed by multiple people and sometimes she can't keep track of who is commenting on what and what has already been fixed. So there are some new collaboration and sharing features right in Word. You can email your documents directly from Word. You don't need to close out of Word, open up Outlook, reattach. You can just do it straight from Word. You can also invite people to view your document. You can present it online. It makes it so much faster because you don't have to move through multiple applications to share this with your colleagues. And so going back to the comment problem, there's a new view in Word where you can opt to either see all of the track changes or you can switch and just see where the changes were made within the document. So you can either turn it off or on seeing all the track changes so you can more easily wade through what edits you've already done. And there's a new commenting system as well. You can actually reply to other people's comments. And when you're done dealing with that comment, you can gray it out so you know that you've already finished working on it. And let's move on to the next scenario. So James is a program analyst and he's looking for new ways to present the organization's data in Excel. But he's not really sure what his options are, and he doesn't really have a lot of graphic design experience or infographic experience. So in Excel, as David showed you, you can select your data and you can see some of your options for presenting it. It's called Quick Analysis. And you can either choose to display it as a chart or you can do it as a table. And you can preview the different ways that you can view this data right within Excel. And so you can kind of measure what your best option is and the best way to display it. It doesn't require any extra skills. Excel really does all this work for you. So you can create really professional presentations and not have to relearn Excel or be an advanced user. So our next scenario is Presentation Anxiety. You want to create a really, this person wants to create a really impressive presentation but she's not really so great at PowerPoint and she is a little intimidated by it to be frank. And as David showed you in that excellent demo, you have so much more room for creativity in PowerPoint and there's new templates to choose from. There's new themes. You get a big space to work with. There's alignment guides just like I showed you in Word where you're texting your images, reformat. So you don't have to really mess around with it. It's a huge time saver. I can create a presentation in 10 minutes that looks really professional and I don't have any design experience. So it's a really, really useful feature. And this next feature applies to both Word and PowerPoint. And it's something I think that would be really useful for nonprofits. You can insert a video directly into your Word document or your PowerPoint by searching either through Bing Video Search or YouTube. You don't have to close Word, open up YouTube, search for a video in YouTube. You can just insert it directly. And so if your organization has a fundraising campaign video or a video that just kind of shows what your organization does, you can easily search for that video, pop it into your presentation, and then play it without having to open up an internet browser. So you have to be connected to do it, but I think it's an excellent digital storytelling tool and it really gives you a chance to make your presentations shine and add a little bit of an interactive element to them. So this is a problem that I think everybody has and it's too much email, overwhelming amount of emails. Sometimes I look at my inbox and I don't even know where to start. So these changes in outlook that David showed are really, really useful for just getting like a nice big glance of what you have to deal with for the day. You can opt to see a couple lines of your email in your inbox. And so you know whether it's important or not. And you also can see your inbox as well as the email all in the same view. So it's like a really nice one glance look. And then you can start to parse through the email and it makes your day go by so much easier. And the same thing with the Outlook calendar, you have so much more information in one place. And especially useful to me is this little weather widget that's at the top. You can see whether it's going to rain and then if you need to reschedule something because it's raining like an outdoor fundraiser, you can just easily make that change. There's just more information in one place is a great thing and it saves a lot of time. And our final scenario is organizing notes. If you're like me, I take notes everywhere I don't know where they are. I lose them. I don't know what happened to them. And OneNote is an excellent way to keep track of these notes. It's really like your virtual notebook. It even has those little tabs that you can section up so you can keep all of your fundraising ideas in one area or your content themes or your social media campaigns. And really it's up to you how you use it. As you can see I drew a little picture. You can use your mouse to draw pictures or if you have like a tablet or a phone you can use your finger and use the touch screen to actually draw an image. You can insert video. You can insert photos. You can insert text. It's really up to you, but it's a really excellent organization tool and it makes my day-to-day life a lot easier. So problem solved with Office. I think you guys will find these new features really useful. Little things that you didn't even know that you could do, you can do with Office. It's been a really big help for me personally. Thank you, Jenny. That was a really, really great kind of just re-emphasis of everything that is new in the new Office and then also what will be really helpful for nonprofits and libraries. I really appreciate that. I know we just have a ton of questions that have come in, so I'm going to go ahead and take a look and a lot of these questions could probably be answered by either Jason or Jenny. So it looks like Brian was wondering, does Office 2013 or the new version of Office use the same file format as the old version of Office? Yes, it uses the same version of file formats that Office doesn't attend in. So the DocX, XLSX, PPTX, no change in file format from the previous version. Okay, great. Thank you, David. Alicia was wondering, the information outlook for the contacts, she was wondering is it provided from bots or is it manually added through human interaction? So everything that you put in will be input by you. So if you want to use your social network connections to show that information, you need to log in to Outlook with your social network credentials. And there's a place in Outlook that you can do that. You're only going to be able to see information about people that you already have access to through those social networks. So it's not like just because I'm using it in Office, I suddenly can see my bosses Facebook feed or my boss can see mine. It's only about what I already have access to. It's just showing it to me there in Outlook, so I don't necessarily need to go to Facebook to do it. In terms of the multiple pieces of contact information, that would be information that I put in. So say I create one contact with Molly's cell phone number, and then I have another contact that I saved from the company directory with her work number and her email address at work. Outlook does have some logic built into it that there are varying degrees of confidence that Outlook will have that this is actually the same person. And so in some situations it might automatically link that. Like if I put in two different email addresses in two different contacts, it figures email address is a pretty solid indicator of a single person. So it will link that. If there are other things that it might not be totally confident, me and it's the same person, it might give me the option to link it or give me sort of a suggested link that I might want to make that connection to show it on a single card, but let me make that decision. And then of course if there is disparate contact information for maybe one piece of contact information is about Robert and the other one is Bob, and Outlook wouldn't necessarily know that it's the same person, I can manually create that link. So there are a lot of different options for it, but it's all about the information that I provide or that I already have access to. Okay, great. And I think that we've already touched on this a little bit, but we have had a couple of questions on this, whether or not Office is or will ever be available on your iPad. Yep, so as I mentioned I think for the earlier question, we already have OneNote and Link available for the iOS platform, so for both iPad and iPhone. I don't have anything to share at this time about other Office applications for the iOS platform or Android platform at this time, but you can see from the fact that we have two apps out there that it is something that we are aware of that customers are using other platforms, and we want to be a great productivity experience. So that's about what I'll say there. Okay, great. Thanks. Arthur was wondering, do you have to have a touch screen to use the new Office? And I think this is a good time to reemphasize what the answer to that would be. Yeah, so no, you do not have to have a touch screen to use the new Office. And the great example of that is the fact that Office 2013 is available on Windows 7 as we discussed before, and touch screen devices were a lot less common with Windows 7 devices than with Windows 8 devices. And so everything that I showed with touch can be done with a mouse and keyboard. And of course you can continue to do all the things that you've been used to doing with mouse and keyboard. So there are just certain types of activities that because we now have touch becoming a more and more common paradigm, we've integrated that into the Office experience, but not without cutting anything out that you're used to with mouse and keyboard, if that makes sense. That totally makes sense. Thank you. We've also had quite a few questions about Publisher wondering if it's new and improved in the new Office, or if it is even included in the new Office. Yeah, so things that I didn't do demos of, whether it's InfoPath, Access, Publisher, and whatnot, those are still available. We have new versions of all of that as well. There's only so much I can show in a 20-25 minute demo. But yes, all of the products in the Office portfolio have been refreshed for this new version for Office 2013. And actually it's worth noting that this is the first release from Microsoft where every single product in the Office portfolio has been redeveloped and released in the same time frame. And that means the client products, Word, Excel, PowerPoint, Outlook, OneNote, Access, Publisher, all those client products, as well as the server products, Exchange, SharePoint, Link. Some of you may recall in the 2010 versions, Exchange launched a number of months before SharePoint launched and they were on different engineering cycles. Well, in this 2013 release, all of them were engineered on the same time frame, which meant that a lot of the product engineering teams could actually work together to do a lot of scenarios that cross product, that again really let people focus on these flows that maybe they don't really care whether they're in email in Exchange or in the document collaboration and storage world with SharePoint, they just want to get work done and collaborate on documents or communications together. And so having all of those products engineered on the same time frame for this 2013 release actually has led us to do a lot more cross product things that really make the stack kind of a 1 plus 1 equals 3 situation when you have the new version of Office and all the portfolio there. Okay, great. Thank you. We've also had quite a few questions about migrating from old Office versions. So David was wondering how difficult is it to migrate from an old Office version such as Office, as she did in 2003 for the new Office? So one of the things I think that actually is really exciting about the new version of Office and doing so much work for the cloud in particular is the new version of Office can now basically run and be streamed down to your computer and run side by side with previous versions of Office. And so that actually has helped a lot of customers with what is typically a very strong problem which is compatibility of maybe certain line of business applications that have been developed internally for things like Exchange or SharePoint or specific macros that have been developed in Excel or other things like that. And so being able to actually run versions of Office side by side with the new version of Office lets you help deal with that compatibility because if there's a line of business application or a macro or something that hasn't been validated to work with the new Office yet, you can just open it in the old version of Office where it does work and not actually delay that upgrade process. So you can have them running side by side and use the new version for everything that you need or everything that you can do there. And if it's something that's a compatibility issue, you can just revert back to the previous version until that custom application is ready to be upgraded. Okay, great. Thank you. I'm going to just cover one more question because we are getting to close to the top of the hour. Again, if anybody's question did not get answered to their FGIT chat or audibly, we will be making sure that those questions get to Ginny who will be trying to sort through everything. We will get back to you one way or another. It might just take us a little bit of time because there are a lot of questions. But to close out, I do want to ask both Ginny and David what you – this question is from Joanna. Who's wondering what you think the most useful and new feature for Office is? I've been talking for a while Ginny. Do you want to start and then I'll follow up? Sure, no problem. So I think actually the most useful feature is just how easy it is to format images. I really enjoy seeing my text automatically sort of reflow with the images. It saves me so much time. And I'd also add that I really like how I can use OneNote. I'm a cross-platform person, so I use Windows and I use iOS, and I actually also have an Android tablet. So I really like being able to use OneNote across all those different devices using the various OneNote apps. I think that's really cool. Cool. For me, I would actually say the Flash Fill feature that I showed in Excel has saved me tons of time. I do a fair amount of work with spreadsheets and I'm taking data in and out of spreadsheets. Just to be able to have a column of data that isn't the way I want it and recreate just the pieces of data in the next column over that is in the format I want with only the data that I want saves me a ton of time. So I have been astonished actually that it's been a lot of fun to use actually. It's sort of like magic sometimes. But yeah, I'd say that's probably one of my favorite features. Great. Thank you. Thank you both, Ginny and David, such great answers. With that, I do want to start kind of closing this out. Again, if you have any questions that you didn't get to even ask, I will be sending out a link to a TechSoup forum that you'll be able to post questions there. I do want to take a moment to thank Microsoft for the participation in this webinar and of course for being such a wonderful donor partner for us. And I want to thank all of the presenters today. I want to thank David, Ginny, and I thank everybody on the back end, so Becky, Cameron, Gretchen, and Dawn. Again, if you want to find out more information about new Microsoft Office products that are available through the Microsoft Software Donation Program, you can go ahead and go to the bit.ly that's showing on your screen right now. Don't worry about writing it down. I will be sending it out to you this afternoon along with a recording of space webinar, a transcript, and any other applicable documents or links. But again, thank you to everybody for attending from TechSoup. Again, TechSoup is part of TechSoup Global and we are trying to work towards a day where everybody, nonprofits, libraries, and social benefit organizations have all the technology and technology resources that they need to fulfill their potential and mission.  Just like so many of you, we really do try to get you what you need. Again, thank you to Microsoft, and thank you to our ReadyTalk webinar sponsor for providing this great platform today. And again, thank you to all of our participants. I really, really appreciate you taking this hour out of your day to spend with us. Again, if you have any other additional questions, just ask those questions of the forum that I will be sending out later today. And when you leave today's webinar, if you could just take a couple of minutes and fill out the survey that should pop up. And if it doesn't, it will be in that follow-up email as well. That survey really does help us in bettering our webinar offerings and other offerings here at TechSoup. Again, thank you, David, and thank you, Ginny. And thank you, everybody, for being here today. Thank you. It's a pleasure talking to everyone. I hope everybody has a great day. Ladies and gentlemen, that does conclude today's webinar. We thank you for your participation and ask that you please disconnect your line. Okay, thank you.


what we're going to do next is create a material for the sun so the first time we're going to do you'll may have noticed if I just press a with my mouse in here you may have noticed that something was created in here when we created the projector material and this actually represents how that material is being made when we create the sun material it will also put something in here and I'll just put it on top of the projector stuff so it's always a good idea before you make a new material to just clear your work area and to do that it's just this icon here give it a click it won't ask you to save that's just bad timing give it a click and now you've got a clean work area it doesn't really matter for what we're doing at the moment but as your materials get more complex it can get quite messy so good idea to start with a clean one I'm also going to create a new material so this time I want a Lambert because I don't want my sun to reflect anything so I'm going to create a new Lambert and I'm going to call it Sun M presenter and the colour of this I would like to be a nice bright yellow so I'm just going to click on that yellow there and I'm going to add incandescent to this which is kind of the lowlights of it and when we sort of do this later it's going to create a really nice color so you want a dark yellowy orange sort of colour so I'm going to bring in some nice orange there and I'm just going to make it a little bit more kind of a burn orange sort of look maybe a bit more into the red spectrum yeah so that is now my sun material and I'm going to assign that to the sun so I'm just going to frame up the sun in the work area and I'm going to assign the material in a different way this time so I'm making sure that I've got the sun selected and I'm going over to the sun material I'm going to right click and hold on that you'll see a radial menu appears and at the top of that is a signed material to selection so I'm going to release and you'll see that that texture is now applied it will also apply that to all the planets don't worry about that that's supposed to happen because of the hierarchy we set up and we will texture over that later


So a question I get asked all the time is can lucid dreaming make you more tired? Does it make you wake up feeling groggy and lacking energy or does it actually give you energy? Does it actually make you sleep better in a way or does it improve the quality of your sleep in some way? An interesting question and there's kind of two parts to this. So the first part is no, it does not make you more tired. It can't make you more tired because all you're really doing is using your mind to experience a dream you already have in, your conscious mind I should say. So no extra work, so to speak, is being done by your brain. You're really just being aware of the process and awareness doesn't really take much energy compared to just what you were doing anyway. So what that means is that you won't feel any more tired than you usually would. Right? In fact, in many cases, if you have a good lucid dream like one where you're flying around, you're experiencing really cool things in the dream, usually at least for me, I will wake up feeling much more energetic and motivated because I've just had that experience. Your mind and your mindset have an enormous impact on how you feel during the day. If you wake up and tell yourself I have energy, I slept well, you're going to go through that day, you know, bouncing off the walls. However, if you wake up and you see like a sleep tracking thing that says you only got one hour of sleep or something, even if you didn't get just one hour of sleep, you're going to go through the day with much less energy because your mind makes it true. And this is kind of one of the dangers of sleep tracking which I will get onto in another video. But long story short, no lucid dreaming cannot make you more tired. It just, you know, it can feel that way if you interrupt your sleep with something like the wake back to bed technique. This is where it gets interesting. If you lucid dream using the WBTB, wake back to bed, that involves obviously interrupting your sleep, right?  That's not great for your ultimate, you know, your overall sleep health and so by interrupting your sleep in that way you will feel more tired the next day. Of course you will, right? But it's not the lucid dream that made you feel more tired because in fact you might not even have a lucid dream. It's really just kind of luck and skill and practice that determines if you will have a lucid dream. It's not the lucid dream as such. It's actually the act of interrupting or sleep that makes you feel more tired. But that doesn't mean that having a lucid dream makes you more tired. It just means that certain techniques will make you feel more tired if you do them regularly.