SelmaTeacher7 Mr. Berry here. Today we're going to be going in and installing Microsoft excel
in your google account so you'll be able to use it on your chromebook i'm also going to show
you how to download a workbook or a worksheet so you'll be able to edit those offline and before we
get into the main part of the lesson i do want to remind everyone that if you're new to the channel
please hit subscribe click on the little bell icon to receive notification when new videos
are uploaded so let's get into the lesson hey here i am in my chromebook now what
we're going to do is we're going to find the web store so go ahead and click down there
at the app launcher and once you click on the app launcher you'll come up and bring up more
applications there now we're looking for the web store so right there you see it on my shelf there
but if you didn't see it on that very first click you can click on the little carrot to
reveal more applications there you can go down the list until you find it and once you find it
go ahead and double click it you know open up the web store i'm going to go into mac screen here
now what we need to do is click up here where it says search
and we need to do a search for excel so key in excel and then hit the enter key once and it's
going to bring up the extensions first we're just going to thumb through the extensions real fast
and scrolling down we see we have themes and we need to go down to the apps so once you see the
apps there go ahead and click on right there the very first one it says excel and that's offered
by live.com and live is actually created and owned by microsoft so it is the microsoft product
and it gets you into this page click on add to chrome once you click on add to chrome you get
this little window and it will ask you are you sure you wish to add this and click on add the app
and then in the lower corner there you actually seeing it it's been installed
now how do you find excel once you have it well to find it just click on the app launcher again
and if you click on the carrot you can go down that list and it should be an icon in there now
if you don't see it right away i see it right there by the way if you don't see it you can
always simply click on the search area type in excel and it'll bring up your app again for you
so double click on the excel icon and we'll open it up hey there you go and this works online
and what we can do there is you notice at the very top there we can start with a blank workbook or
worksheet you have other themes there for you or you can open up existing work that you've created
in the past and saved within your microsoft account now this is the very first time that
you've actually installed excel and actually used it before then you will need to create a microsoft
account and right when it starts it'll ask you do you want to log into your microsoft account
if you don't have one there's a little blue button there simply click on create one and then insert
an email address a password and create your brand new microsoft account now once you have that this
is free and we won't go into it and actually show you some of the things that we have so i'm going
to open it up and create a quick workbook here now if you want to see this in full screen just hit
the full screen button that's above the five on your chromebook and it fills up the whole screen
now if you notice that we have these banners so if we click on file that's how you find your old work
or save your other work there that we have we have the home banner with these icons and these tools
we have the insert banner we find formulas and charts and other things there we have formulas
next we have data we can sort your data and do other things with the information that's already
in your spreadsheet next is review then we have view we can actually change the mode of viewing so
let's say you created your work already and you're sharing with someone else and you don't
want them to edit or change any information by accident you can click on reading view and then
someone can scroll through it look through a very large spreadsheet or workbook and not
by accident change something by clicking on the wrong element
and the last thing that we have there is help now what i'm going to do is i'm going
to create a quick workbook so i'm going to highlight a1 through let's go through l1
and then i'm going to click on the home banner and now i'm going to click on merge and center
after clicking on merge and center i'm going to go down here and i'm going to change the font style
here so i'm going to choose ariel black and then we'll change the size to size 18 and let's key in
selma teacher 7. all right now so now i'm going to click into a2 and type in january
now if you look at the very corner of that cell there's one square there that's a little bit
larger and i'm going to take your mouse and place it right on there if you place it on
there and then drag straight down you'll notice that it creates the months of the year for you
and then you can resize it out so you just go up to the little line between the a and the b
drag it a little bit to the right and you get more space for your months now let's say that we need
to insert a row simply right click on that two and then select insert row okay now after creating
that row i'm going to click again on that 2 and i'm noticing it's size 18 i don't need that for
the label so i'm going to go back down to size 12 and then click into b 2 and type in income
number one and you notice that it it's too large for that cell so
you can actually take your mouse go in between the b and the c and drag it out
and now that cell is larger i'm going to do the same thing here for
so i'm just going to drag this over so i have two incomes now in d2 i'm going to type in total
okay now i'm going to be putting in some incomes there so let's say income 1 there is 1200
and income 2 there let's just say that's 650 what we're going to do is we're going to take these and
copy these down for the entire year now let's say that i wanted everything within these
columns to be dollars and cents just simply highlight them click on the dollar sign
choose the type of money that you want and it puts it in for you now for the totals
go ahead and click on the autosum and it puts it in hit the enter key and you got the first
total there if it's too narrow you'll show just the pound mark so just drag it out
click on the very first one and then we'll drag that little square
down and give me all the totals now let's just say that one of these was different so
let's say that one was 1500 you notice how the total for that one month changes
so you can go in and change any of these that you need to to correspond to real life
there you go
so now you can see how the totals have changed and it's everything is is really
done really quick there now let's say that you want to work with a spreadsheet offline
click on file then save as and you notice here we have the option download a
copy so click on download a copy and this new window will open up here in a moment or two
now here you can select which folder you want to place it in as well as you can give it a
name if you need to i think i'll keep mine as book 2 and i'm going to click on save
now to edit that excel spreadsheet offline i'm going to do is i'm going to go to my google drive
so if i go to these icons the app launcher and open up my google drive
once your google drive is open click on
the icon there that looks like a gear that's your settings and then click on settings
and then make sure that where it says offline make sure that is blue check mark inside and not empty
that will enable offline support so any work that you do will be saved
onto your hard drive of the chromebook so you'll be able to work with those files while you're
offline now once you've checked that now what you're going to do is going to click on new
file upload find your file there click it and then click on open once it's been uploaded to
your google drive it's now synchronized with your online and your offline so everything is
nice and synchronized there for you and what i'm going to do is let's say that you were offline
your google drive will still work and everything so you go in and click on recent and there's your
book two double click book two and we're maximize this and now google sheets opens now google sheets
is identical to excel has all the same features and tools and any of the formulas that you
created in excel they carry over so if i click on a cell there you can see the there's the equation
and everything's working great and so let's go ahead and let's change one of these numbers there
let's change this one to 400 and see if it works there you go it works so here as we see in google
sheets it works just fine there so it works just like excel where it takes in the same formulas
and if you need now to send this out you can click on share above me or you can click on
file and you can email it to someone and you can download it as a microsoft excel workbook
hey now you know how to find and install microsoft excel onto your google account so
you can use it on your chromebook now i'm going to show you how to actually edit microsoft excel
workbooks or spreadsheets offline just in case you find yourself on your chromebook but you're
offline okay now i'm going to test this actually offline so i'm going to go down here to my
connected to wi-fi icon and i'm going to turn off my wi-fi
okay and so now if we went to google apps and click on google drive and then once google drive
opens go to recent after a few moments you'll see this file here this is the file that we actually
worked on so let's double click it it'll open up in google sheets which does work offline
now in a moment or two it will load your workbook you notice right up here it says working offline
so for reals i am not connected to the internet and let's just make some changes here um let's
say one of these numbers there's like 3 000 here it's a good month and let's see if it changes
it does it updates it now this is saved to the device or to your chromebook it's not saving
it online it will synchronize all the changes once you're connected back onto the internet
now you know how to edit your microsoft excel spreadsheets while you're offline
using google sheets so it is easy to do everything all the formulas are the same
you can add new formulas by the way so let's say if i wanted to add a new formula they're over here
to the functions and there's my different all my different functions i'm usually using the sum
and then you highlight what you wanted so it works the same as excel in fact the formulas
are the same so let's just see here here's the function for the one that i just put in
and here's the function that excel put in it's the exact same one so
google sheets should work with all of your excel spreadsheets and then you'll be able
to do your work offline hey we've come to the end of a lesson there thank you very much for
watching the video and hopefully you've clicked on that thumbs up and if you're new to the
channel hopefully you clicked on subscribe and i love to see and read your comments down below
and if you have a question i'll make sure i answer it right away thank you very much and bye bye