Tutorial – Excel 2013 – 10 Things you must know

hi everyone this is my tutorial video on Excel 2013 this is a follow up on ten things you must know in Excel 2010 I made a previous video showing how to do certain tasks in Excel 2010 Microsoft released a new version of Excel Excel 2013 and I just want to go over everything pretty much that I had taught in Excel 2010 but this time I want to do it in Excel 2013 plus show you a couple of new things Microsoft improved the UI of our UI user interface of Excel 2013 by adding the whole metro style to it so if you take a look at my screen you’ll see that I’m using Windows 8 and I’m using Start 8 I had a Start button to my vid to my my video either the start button to my um to my Windows operating system because I actually enjoy having a Start button I’m going to show you a video on how to add a start button in the future but for now let me just jump straight in forward into Excel 2013 so let me just launch up Excel 2013 and you’ll see here that I’m using the consumer preview Edition the preview Edition is distributed for free by Microsoft for limited time and it contains exactly the same features as actual excel will contain and the retail version you’ll see here just looking at the screen already things are different this blast screen which popped up just showed you the preview when you purchase Excel will tell you just Excel 2013 on the top right you’ll notice that I logged in with my SkyDrive account which is a brilliant integrate integration by Microsoft allowing you to save documents and work on them directly in SkyDrive so you’ll see here I’m not going to work off my SkyDrive but I’m going to show you that I connected to my SkyDrive and I was able to pull out documents or create new spreadsheets and atom directly to SkyDrive and work directly off of them or share them or collaborate with other people making this product a really amazing networking type platform so this is a really cool feature that they added in here SkyDrive is integrated throughout Windows 8 and through to Microsoft Office 2013 so I’m just going to click on a new document and I’m going to quickly open up a blank workbook just like my previous tutorial I’m just going to show you I’m going to go over things which I’ve talked before so you’ll notice quickly that the entire UI looks slightly different but don’t let that fool you because 2013 is very similar to 2010 except they added really really nice shortcuts to this software and I’m going to show you right now what I have one through before my 2010 version of this tutorial the first one was the populating values in ascending order let me just bubble it and bold it so populating in ascending order we discussed that suppose that we have a number in a1 and we want to have a row of numbers suppose we’re numbering something if I was to drag that little corner box right here in the corner with the number 1 you’ll see that I’ll just duplicate the same value down the rows which I’m dragging it on so if I drag it down to 20 I’ll have 20 ones but if I put the number 1 here and then the number 2 and I highlight both now it will populate it in order where it’ll go in a consecutive order of numbers in ascending order so 1 and 2 will start populating 2 3 4 and 5 so I’m going to drag this down to number 25 to a 25 and you’ll see that all my numbers have populated now I don’t have to type in numbers I suppose that I’m doing something where requires numbering things and I don’t feel like typing numbers 1 through 100 for example I wouldn’t have to do that so I can always align this if you’re worried about the alignment of it we have our standard buttons here to align it center left and right and I’m going to delete this and I’m going to show you another example where this is useful suppose I want a bubble in the years right I suppose I want to start with 1960 and I want to move all the way from 1960 to 2012 so I’m going to put in 1960 1961 and I’m going to drag it down and I’m going to move it forward and you’ll see how it starts bubbling and in the proper order which is much better than typing every single thing over and over so that is that was explained that my 2010 tutorial I just wanted to show it quickly and over viewed here in this tutorial let me move on to the next thing which is sorting columns sorting column items again quick brush up from our previous tutorial suppose that we have the numbers here 1 and then let’s put in 3 to 5 & 4 as you see these numbers are not in order so suppose I have here things next to it like let’s say I have names like John Jane Nick

Nicole and Danielle for example and I want to be able to sort them in a specific order how would I go about doing that so what I can do is I can just highlight both cells I can click on sort and filter click on custom sort and I’ll have a selection and I can pick a sort by column a which is the column where my numbers are and sort them by small as the largest and you’ll notice not only that it’s sort the numbers one through five correctly but it also sorted the the items which are next to them so if one a and if if one A and one B is the number one and John you’ll see that when I sorted them John moved up with the number one to its proper position so this is actually very useful you I’m going to undo this for example I’m going to show you I can sort just by sorting a column a without touching the items in column B and I’ll do the same type of custom sort and Excel will warn me quickly and tell me hey you’re only selecting a certain range of cells so if you sort these none of the cells will be affected do you want to expand the selection to sort everything or they just want to continue with your current selection and I’m going to say okay I want to work just with column a suppose I don’t want my name’s over here to change so I’m going to click on sort and I’ll be able to sort this from smallest to largest and you’ll see one through five is sorted and the correct order and the names are not unchanged so just another cool little trick you know the to understand sorting is a very very nice feature in Excel and I went over this and now spend too much time on it but that’s how you sort and you can sort just about anything you can sort by cell color you can sort by font color of course values moving on to the next thing is working with selections remember going over that working with selections is a very very common thing in Excel it’s a very very simple thing what is a selection a selection is a range of what you select you see here I’m selecting B through P or I’m selecting the entire column D and I’m working I can work with only specific selections so let’s go back to our numbers let’s say I have the numbers 1 3 5 4 and let’s say 2 and let’s say I only want to sort the selection between 1 & 2 I can just create a selection of only 3 items which will not affect the items not selected and I’ll be able to sort with them as well so I’ll be able to go to my sort my custom sort and it will be able to easily just click OK and you’ll see that 3 4 5 and outlined in order instead of having 3 5 4 and the 1 and the 2 are untouched now I can also expand my selection from the previous thing I said and go and do a complete sort on the entire row cell and you’ll see 1 through 5 is sorted properly so that was a quick brush up overview on sorting and working with selections you can always select within a selection so if you have a really big row of items you can actually create a selection within that row and select a certain amount of cells that you want to work with so working with selections is very powerful you’ll find yourself doing this often without think even thinking that you’re working with selections but it’s a very important thing to do removing duplicate valiance has not changed at all when you have duplicate values it’s very very easy to remove them again I’m going to go to my number line here suppose I have the word number is 1 2 2 3 3 3 4 4 and then let’s say let’s put 1 5 so I have 1 2 2 3 3 3 4 4 and a 5 suppose that I’m working with data that could be names of car brands or hotels or places or locations or addresses in this case I have numbers and I don’t want these duplicate values in here and I don’t want to spend hours going through a lot of data you’ll see Excel appear has tabs on the ribbon on top and one of these tabs is the data tab and like in the data tab you’ll see that you have the remove duplicates button which was explained in detail version and it’s the same exact feature you’ll just click on remove duplicates and you’ll select the cell of the column rather on which duplicates you’d like to remove and if I click OK you’ll see that 23 dupes were found and only 6 unique values remain those six values is 1 through 5 including a blank which I left in here so you’ll see here that it completely cleaned up my data and gave me a unique 1 through 5 rather than having the 1 2 to 3 3 3 4 4 & 5 let me delete this series of numbers so and let’s move on to the very next thing the next thing being basic formatting again this is a pretty much baby stuff up till number 6 which is the most useful thing in my opinion but basic formatting again this is something everyone pretty much should already be doing or knowing suppose I have a word here I’m just going to type my name in here and I want to format this so what is basic formatting basic formatting is that the style in which you apply a certain text so basic formatting can be the font or it could

be the size it could be bolding it could be italicizing it could be underlining it could be also creating a different color or giving it a different background so suppose I give it a color and a background and let’s say I make it bold so the reason why knowing formatting works with other things because suppose that you have I’m just going to put some random names in here again John and Jane and I’m going to format Jane in the same color I’m just going to say I want to make her yellow with a bold font I’ll make her red as well you’ll see here that sorting works with this really well also because he could just go to sort custom sort and you’ll be able to say hey I want to sort with all the yellows on top so you can say column a I want to sort by column a and I want to sort on cell color and I want to sort yellows and put them all on top I can click OK and you’ll see that John moves down while everyone else moves up what this helps me do is it helps me locate things formatting works in conjunction with conditional formatting and basic formatting where let’s say you have a big list of things and just going to make here let me just write John one and John two and again I’m going to a previous lesson here and I’m going to drag these down and you’ll see here that I made John one all the way through John 23 and I’m just going to mark a bunch of them yellow as I find them but this could be any data it doesn’t have to be names doesn’t have to be it could be anything it’s Universal data and I’ll mark a bunch of them yellow and now in the future suppose I have a big big array of numbers or a really big series of numbers I want to be able to just simply sort this and move all of them up top I could do the same exact sort over again by going to my sort and filter custom sort and then just sort it by yellow on top and everything I highlighted John 5 10 15 and 20 now moved up along with Elan and chain and the rest of the data is safely below you’ll see that the number is now I’m missing you see John 5 is on top and you’ll see in my series 3 4 and then 6 because 5 moved up because the sort so that’s where formatting comes in and it’s very helpful let me clear this as well and move on jump into the next thing the next thing is conditional formatting now in Excel 2013 there’s a really awesome way of doing this previously I mean boulders quickly previously there was a different way of doing this and it still exists by the way suppose right and I used animals last time if I remember correctly so suppose I have I’m going to use animals again I’m just going to type a bunch of animals in here I’m going to say lion tiger zebra bird cat dog lion tiger zebra bird cat and dog now before if you if you remember correctly I told you guys that if you highlight everything or highlight the entire row you can just click on conditional formatting on the very top on the very top and you’ll be able to use the conditional formatting highlight cell rules and now the the top and bottom rules which I’m going to go over that in a moment but what is conditional for writing you’re able to format based on certain certain variables let’s say everything has a variable you have a number it’s either higher or lower than number or you have a word that begins with a certain letter or ends with a certain letter or contains a certain letter so I’m just going to stray away from this conditional formatting because in the new excel the 2013 version you now have something called and I marked it down here quick analysis now the quick analysis tool is a very very awesome tool when you highlight a bunch of cells now the quick analysis icon will now pop in on the bottom of the highlight so if I highlight let’s say just a couple of cells it will pop up but I’m going to highlight all my cells and I’m going to click on the quick analysis and you’ll see that right away have the option of doing conditional formatting there it’s actually built into the menu of quick analysis having you given you a shortcut giving you the ability to quickly do certain things so let’s say I want to quickly see my duplicate value so I just have to put my mouse on it and it’ll immediately show me all my duplicate values and in this case everything is a dupe because I used every single animal twice now I can also use text it contains and I can click on text it contains and I can say show me lion and you’ll see all the lines will turn red and I can choose what color they’ll turn I can make it turn yellow or green so I’m going to type in here zebra and you’ll see that it immediately turns dynamically turns red and shows me what I’m looking for suppose I type in cat or dog or let’s say a tiger you’ll see that it will point out and red highlights everything so this is the

same exact technique used when clicking on conditional formatting highlight cell rules and then let’s say text that contains and then you get the same menu but we’re going to use a shortcut and this is this is really one of the almost awesome features I think of this I’ll save you a lot of time you can highlight certain things you can click on the quick analysis tool and you can immediately select text that contains or show me duplicate values in this case I highlighted tiger line dog cat and bird you’ll see there is no duplicate value and let me show you if i highlight zebra – zebra and i click on quick analysis and i click on duplicate show me duplicate values you’ll see my two zebras will not highlight because i have two of them and everything else is just a single unique value I can also say show me unique values only which will eliminate the zebras and again these are really powerful tools because you can actually use this to be able to see what data you really have suppose you work in an office you’re in a financial district or you’re working for a inventory company and you’re doing you’re doing some form of inventory for some sort of company or it could be just about anything could be a comparing numbers revenue and you want to see all the unique numbers you earned or you want to see all the duplicate values or you just want to search for a random string and a whole bunch of text and that is a really beautiful thing so the quick analysis tool is a really really cool thing and you’ll see here that you’re also able to create charts almost immediately using quick analysis so I’m let me highlight everything real quick and I’ll click on quick analysis and I’m going to go to charts and I’m just going to say create a chart for me and it’s going to show your chart of how many items I have you’ll see here that I have the bird the word bird twice the cat twice but I only have one line in there from what I’ve highlighted so you’ll see you can immediately create charts just based on quick analysis you can also do totals you can do a total count here I have one one item in each cell but when I do one count you’ll see that I have twelve animals all listed just by clicking on totals and amount you can insert a table almost directly which is a very very cool thing Excel will create a table for you right away and I’ll even format it for you using this particular menu this particular tool rather this also works with numbers suppose I have one two three four five six seven eight nine and zero I can highlight everything right away I can click on quick analysis and I can go to let’s say totals and I can just highlight some and I’ll get to sum of all the numbers which is forty five I can get the average of these numbers I can even get the count of how many numbers there are and the total percent of numbers the running total which is pretty much the same as some for me and you can have these numbers sums up to the right of the column so again this is very very nice and it’s dynamic it changes as your data is different you’ll see here that when I highlight words and I go to quick analysis and I click on totals you’ll see that I only have count available but when I when I go over to numbers and I go to quick analysis and I click on the totals I have much more features that have average I can find out the average of these numbers whatever it is that I highlight the count the total the running total and of course I can also do the conditional formatting I can get a really good formatting I could see numbers greater than a certain number suppose I want to see all numbers greater than 6 and you’ll see seven eight nine are greater than six so they’re highlighted in red suppose I want to see numbers greater than one it’s pretty much everything except one and zero so these are really cool tools which you can use and quick analysis really something I really wanted to touch on and this version of Excel because it does everything Excel 2010 does except this particular tool this menu gives you the option to quickly navigate through your data perform these various tasks whether it be math or word math you know you can create these little algorithms and see certain things and insert charts almost immediately you’ll see here that I can create multiple charts here based on numbers you have a number line you know the scatter chart you have a cluster chart in the clustered column chart which is very common you can actually have more charts you can click on the more charts option you can enter a pie chart or have even more Excel offers a variety from line PI bars area charts you can create a stock base chart and much more so this is pretty much it for conditional formatting again is the most powerful and most useful tool in Excel I use this feature almost daily to conduct my work let me move on forward we have basic math formulas which is again if you want to learn formulas really you should rather than and if you read books for example right the problem with books is they don’t take you back what you want to do what I like about Excel is that it gives you tooltips and it kind of talks to you

and walks you through what you’re doing so I have two numbers here one and two and I can go to formulas and in formulas you’ll see you have an array of formulas here math and trigonometry you have functions lookup and reference date and time text logical financial and of course your recently used formulas as shortcuts if you use certain formulas over time so I have one and two here and I can just go into math and I could do multiple things and when I put my mouse over every formula it look at me a tooltip telling me exactly what the formula does I have formulas which return integer or whole numbers and formulas which return decimal numbers I can have formulas convert in certain things and you know what I used in my last my last example was the sum which is the very basic thing I could have basically just type in equal and then some and a all the formulas will pop up and I could just create some of B one and A one and you’ll see the sum is 3 so I’m not going to touch on this too much I mean if you look at the actual formulas tab right and you’ll see the categories that you have you have multiple formulas here math and trigonometry being the most used when you work with numbers and then texts when you use strings right when you want to format things you know you have multiple things like one of the things I’ll show you right now is the proper one the proper for text suppose I have names right I copy and pasted names from a website or I scraped a website and I have John Jane Bob and well just John Jane and Bob and there’s a nice formula that I use often called proper so I could say equals proper and I could say proper of a 1 and what proper does is it will capitalize the first letter of every single item in the cell it’ll it’ll format things to make it much nicer so suppose you have John Jane and Bob and you want to capitalize hundreds of names for invitations or you know for any kind of report that you’re doing the proper formula just does that so that’s a basic text formula using the proper so each and every formula corresponds to its topic and I do recommend you go to formulas the formulas tab you find the topic you like I just put the mouse over it and just read what it does it is a very very neat thing and helped me learn a lot in Excel just by looking within Excel sort of speak you can say Excel teaches you to use itself which is a very cool thing Microsoft did concatenating something I went over in the previous video as well suppose I have in here number is like I said one two now suppose I have area codes five five five five five five five five five and then I have phone numbers I have the phone numbers one two three four five six seven let’s say four five six seven eight nine zero and let me remove that plus in there give it a dash and then I have five five five one two three zero nine eight seven and let’s say I want to combine these cells together and how would I go about doing that I explained that previously it’s a very very simple way you will just type equal again this is a text formula actually it exists in that formulas tab you can type in equal just say concatenate and you’ll be able to select let’s say a one and then the second cell you want to concatenate which is b1 and you’ll see that what it does is it adds the entire values together and it will dynamically change as you change the values when you drag it down it applies it to everything so suppose that I dashes in the air you’ll see how the concatenate formula will immediately populate my update so now my phone numbers which I just had a bunch of zip codes and a bunch of numbers became actual phone numbers just by concatenating the cell so what does the concatenate means it means to add values from one area into another area into one specific cell Khan joining them together that also exists in a video and I will post the link to my 2010 video which has all of this in it and 2013 and 2010 I’m very very familiar and very very similar I mean mark this is red and then we have our aging formula again I went on this on my previous video actually wanted to great lengths about it so I’m just going to do it we here suppose we have a date let’s say I have I don’t know let’s say put in January 1st 2012 and then let’s say we have let’s say we have June 1st 2012 and then let’s still in November 1st of 2012 and we want to find out how many days from today is the difference between these dates so it’s a very simple formula I’m just going to type equals today which is today’s date and I’m going to say today’s date minus a 1 which contains the date and in cell a1 kind of like the game battleship that’s

how I like to treat bless you that’s how I like to treat Excel like a game of battleship you have cells you have rows and you have columns and each thing corresponds to the other so you’ll see here I created a formula saying date equals date open paren close paren minus a1 and you’ll see here I have actual date values and that’s not what I’m looking for I’m looking to format this and I’m going to quick format I’m going to format these cells and I’m going to choose format them to a number without a decimal and you’ll see here it’s been 325 days since January 1st 2012 today’s date is November 21st if you go back 325 days ago it was January 1st 173 days ago it was June 1st and 20 days ago it was November 1st very very cool formula you can actually move this forward I can move on and create you see I’m here I’m dragging everything out and I’m going to just draw this formula forward down and you’ll see here it tells me exactly how many days it’s been it’s been minus one day since the 22nd because the 22nd is until tomorrow so I have a negative one very very cool thing to do especially when you’re calculating I use this to calculate invoice data see whenever someone is late on a payment or a certain date doesn’t match you know I do an array of analysis on dates one thing I wanted to show you when I spoke about formatting before I spoke about cosmetic formatting what I didn’t talk about is actual formatting of cells so you have let’s say a zip code right and you right click you see here this attained the formatting of a year as a matter of fact it still has the formula here let me just totally clear everything out of these sales Excel remembers everything so I like to start fresh whenever I do anything new so suppose I have a zip code in here Excel doesn’t know that this is a zip code until you tell it to now how do you tell Excel when something is actually something in fact what you put in you can right-click a cell or a row and you can choose to format the cell and you have an option here and I’m just going to choose in here custom and I’m going to say and I’m going to say this is a zip code I’m going to click OK and now Excel will actually treat this value as the zip code 1 1 2 3 5 why is formatting important formatting is important because you can actually choose how Excel will treat something we’ll the treat it as a general thing you know basically any of the above will it treat it as a number only or a number with decimals let me just quickly put like the number 2 I’ll explain what I mean suppose you have the number 2 in here if you right click this and click on format cells and you will want to format it to a number what decimal places you’ll see it what Excel does it treats it as a decimal suppose I have formatted the currency suppose I’m talking about money here I could just click on currency and you’ll see now it adds the dollar sign so it is very important to format also because you always want to tell it Excel what it is that you’re doing in order for Excel to best work with you what it is capable of doing so you could do multiple things here you can choose accounting date time percentage you can choose what type of date format you want what type of time format you want you want to show the seconds do you want to show whether it’s a p.m. or a.m. you want to show military time maybe or you want to show it as basic maybe you don’t want to have a trailing zero there’s multiple things that you can do and that’s what this formatting is about now I should have spoke about that previously but I had so I’m just quickly showing you and let me go backwards now and I’m down here and styling I’m not going to talk about because it pretty much 1 over it previously instead of going over formatting let me just highlight these is done now since my last video I did have requests from people asking me some assistance and one of the requested topics was a texture of the column so you know to answer that for you suppose I have here let’s say I have you know what it’s best to do this like this suppose I have here 1 comma 2 comma 3 right and then again I have 1 comma 2 comma 3 and then I’m going to go forward down I’m going to say 3 comma 4 comma 5 and 3 comma 4 comma 5 so how do you get these 1 2 3 s out on 3 4 5 s out and actually spread out through B ABC and D without having to copy one and then copy 2 and then copy 3 well there’s a very easy way notice there is a comma between each thing and I did highlight in my notes here to explain to you what that means so the comma is actually the delimiter in this case and what is a delimiter a delimiter is a separator what separates something delimits it so keep that in mind for example when you save something as a CSV file what is the CSV it’s a comma separated file so what is the delimiter in that particular file it’s a comma so in here you’ll see that it’s delimited by comma you’ll see here that when I highlight my cells and I go to data right

I do have an option here to go text to column and Excel will ask me if it’s delimited and in this case it is delimited there’s a comma between each thing so when I click on next now I could say okay it’s not delimited by a tab it’s not delimited by any other character except of a comma so when I click on comma you’ll see what happens it gives me a preview of what it’s going to do and I’m going to click on finish and you’ll see what it did it took everything and it created different columns for what I had all stuffed in one particular column it’s very useful when you’re scraping data again a lot of people to contact me scrape data a lot and work with it so this is a very very good thing to know one to have to be able to to take data that’s all combined together and jumbled in a certain cell let’s say I have here my name and I’m just going to put I’m going to put in a comma and then my last name and then I’m going to go and do a text column also here let’s see text the column and I’m going to make it again it’s delimited by a comma I’m going to finish it and you’ll see how it separates it one from the other then I can use my proper formula and capitalize both both first letter of the first name and last name suppose an F I have let’s say I put my C and I’m going to put let’s say K an uppercase I’m gonna put in K and I’m going to say a city I’m going to put in city K that K never K sleeps so why do I put the K in there well K is my delimiter now so now if I do text to column I’m just going to say it’s delimited and I’m going to choose a different character unless it is delimited by K and I’m going to finish and you’ll see how it separates it city that never sleeps very very cool thing and I hope that answers the question I try to explain it in the email and it’s much easier to see in a video so now you see how that works it’s a very very cool feature again exists in both 2007 2010 and in 2013 getting accustomed to using 2013 already can’t wait till actually comes out in retail and I can actually use it at work I don’t happen to use consumer previews too much so we went over this and actually show the proper formula which was another requested topic just to highlight everything in bold it and another requested topic was the if formula and I’m just going to quickly touch on that suppose I have numbers and I’m just going to quickly number things I’m going to say number 1 2 3 4 5 6 7 8 9 actually no there’s a bad example I’m going to use numbers with two digits so I’m going to use 10 20 30 40 50 60 70 80 and 90 and 100 let’s say the if formula so I want to know if certain things are true or false so they have formula is a really really cool formula I could just go here and type actually no I just highlight all of these guys go to my formulas go to logic because it’s a logical formula and I could just say if and actually I’m going to do the F formula in column B right next to the column a and I’m gonna go to logical and I’m going to say show me the if formula and I’m just going to quickly say here if let’s say if a 1 is greater than greater than let’s say 50 then say true otherwise say false I’m going to click OK and I want to drag this down a little bit so it was 10 greater than 50 nope it’s false is 20 greater than 50 nope Falls 30 greater than 50 Falls is for T greater than 50 Falls is 50 greater than 50 that’s Falls as well but 60 is true it is greater than 50 I can drag this forward and you’ll see here what happened so what did what is that formula what what exactly happened here if returns a true or false or and actually anything you want I can make it say a dog or cat based on whether something is greater or equal then it’s a really cool formula to use when you working with numbers suppose you want to know if in a big array of numbers is this number greater and less than this or is this number equal to that if that’s the case then Mark put text in the next column and tell me yes it is no it’s not delivered undelivered sold not sold on a whole not on hold again so I just quickly wanted to show you that so whatever what did I really do here I went in here I just picked the next column over I went to my logical formulas I click don’t know the if formula and it just tells me what is the logical test what is the condition what am i testing here what do I want to check so I want to check if the stuff in a 1 is let’s say greater than let’s say 80 and if it’s true then say sold under 80 and then if it’s if it’s false say

sold over 80 and I’m going to click OK and you’ll see here well actually I did this entire formula upside down this should be over this should be on there and you’ll see what happened here the item in 10 sold under 80 everything up to 80 actually sold under 80 and if I move it down forward to 90 100 you’ll see that these two items over here sold over 80 so that’s a really cool way to use the the if formula it’s very neat and very useful in Excel and let me mark that as complete and we already touch point on quick analysis and it’s going to give some final words I know this tutorial was pretty long but pretty sure it helped people have gotten tremendous feedback from my other video so I’m really happy to help other people so was it a really touch base on here the most important thing everything else is very similar but the most important thing that we’ve just learned here is the autofill option well I’m sorry not the autofill option autofill it’s a very very smart way here of if I remember it’s like it’s a predictive it’s a predictive feature of formatting I’m not even going to touch base on that as a whole new topic actually to discuss all the fills and other values and what is that we really discuss over all oh yeah the quick analysis just remember that this is if there’s any other reason to upgrade to this other than then it’s just it looks nice it has a nice Metro feely thing it goes it goes together but windows 8 the quick analysis button right here is golden it is it is amazing and of course the whole file and then save as and being able to save something as and then save it to SkyDrive that is the best because I can save something at home work on other work save it at work come back at home work on it again and never carry a jump drive with me that is great and Microsoft has very safe and secure servers and it all links together into your live account which is absolutely free and it’s it’s used to rout Microsoft Office you’ll notice that what I was doing here by highlighting and reading things I’m actually using word 2013 here and you’ll see I have the same exact features I’m going to make a video about this also you know what else in Excel that I was playing with earlier really into it let’s go back real quick I can actually go in here click on insert and let’s say I want to insert a I can insert a screenshot of what I’m looking at which is very very cool looking I can insert a screenshot or a snapshot you see it already took I can answer the screen clipping I can actually take a clip of what I’m doing like for example I just cut it in half but why not you look what happened actually insert the clip on my background very very cool stuff very much so worth upgrading if you’re considering buying this I would say absolutely it’s a really good thing and it will help anyone whether at home or business or students I just want to thank you guys for watching my video and I have my previous video if you want to check it out it’s already up to almost a quarter million views it’s very very good video it’s called 10 things you must know but Excel 2010 now welcome you guys to watch it and I’ll be making a couple more videos next video I’m going to make is probably what a lot of people are wondering I just bought Windows 8 and I have no Start button what do I do so this is Start 8 it’s a very very cool start button addition to Windows 8 and then event thank you for watching my video to really appreciate it I hope you learned a couple of things new things or brushed up on previous skills you may have had but forgot new subscribers thank you for subscribing older subscribers thank you for watching thank you again have a good night