I'm not making a judgment here. I know there's a lot more than seven things that you do
with a spreadsheet, but I can tell you, in my experience, I think these items work
better in Microsoft's desktop Excel product than they do in Google sheets
right now. The first one that I want to go over is splitting the view. When
you're working in a table of data like the one that you're looking at right
here you may want to look at the top and the bottom at the same time. I may be
changing numbers here and want to see what it does
to the totals at the bottom. In Excel, you can just split it. Just do the Split
function. Move these around a little bit to whatever makes sense. I'm gonna double
left click on this when to get rid of it. Now I can see the same
spreadsheet in two views. On the bottom, scroll down, I'm gonna be looking at this
but I'm gonna be changing things up here. I can see both areas of the spreadsheet nice and
easy. In Google sheets there is no option to split the view like this. A similar
option, which is available in Excel and kind of a Google sheets, is to just use
two windows. I'm going to undo the split view and this will give me two
completely independent windows. So I can a different worksheet in each
window. So in Excel you have to do a new window, then arrange window, then tell
it which way. We'll say vertical. That puts these two windows right next
to each other. I had a third one open apparently underneath. I'll close that
one. That's how you do it in Excel - new window,
arranged all, vertical. I go back to Google sheets, there is no view new, there's
no view split, you can't do it. What you have to do - I'm gonna get out of full
screen so you can see my browser. Ignore this tab for now. This will come
in later. What you need to do to give yourself a new window is just literally
open up a new tab and navigate back to that spreadsheet. I'm just gonna copy
and paste here so you don't see me digging through my
bookmarks. And see you have that spreadsheet here.
Pull it off. Just hold the left mouse and button pull it off. Hold my Windows key and
right arrow. Then go to the old one, hold my Windows key and left arrow. Now I
have the same spreadsheet in two views. You can work independently in these. In the
demonstration with what I was doing with the new window with the split views - you
can do it here. So I'm go down to the bottom and that there's a total here. I can
change in number over here and it's going to change that total. Let me make
sure this is on your screen.
Here's my total at the end of the spreadsheet. I am going to this change number and
that total's going to update live. So that's a pretty useful two windows
version for you.
Third thing that I feel like Excel is better than Google sheets is inserting
special characters. This is especially helpful for auditors or accountants if
you want tick marks. Say there's something special about this
line here. You want to insert a symbol. Later on you can define that tick mark means.
Whatever you want. I am not going to show you how to use tick marks right now. That's a little outside
a scope of this video but that's how you insert special characters or symbols. If you
go back to Google Sheets. If you want to insert a special character into Google
sheets the workaround is to open up a Google Doc. There do you insert a special
character. Take the one that you want. Copy it. Go back to Google Sheets and paste it.
There's your special character. You can make it red now and bold to use it as a tick mark.
Not easy to do in Google Sheets. Easy to do in Excel. The next way that Excel is better
is the option to just clear. For example, you can use clear in a couple different
ways. I like to use it to clear formats. It might be off your screen
right now. Let me tuck this in a little bit. This is the Clear option. It's gonna
say clear on top of it if you have the in fullscreen probably. If you want to
clear formats. Say don't want blue anymore. You just want
regular default formatting. Just do Clear Formats. It gets rid of all. I'll do control + z to
get rid of that to show you -
hey, if I want to get rid of this and I wanna give rid of the formatting - Clear All.
It's all gone. You can type into it again. It's just default. So that gets rid of
everything. That's different than the delete button. The delete button will just
get rid of the text. It won't get rid of the text and the formatting. So Clear provides
you with a lot of flexibility to wipe out stuff quickly. To do that in Google
Sheets, it's just not there.
You can delete things, but you can't go in in just clear.
If you have data and formatting you have to delete the data and then reset all
the formatting or you could select a cell that had a default formatting, do the
Format Painter and paint the cell that you wanted to erase the formatting from.
Another way I think Excel is better is the ability to just simply do a double
bottom border. Accountants live on double bottom borders. If this is a total the
standard to denote that would be to put a double bottom border on it or
you could do a double underline depending on your preference.
You can find double underline in Format Cells, Double Underline.
If you go into Google Sheets and try to do that it's not there. Can't be done.
You can do single bottom border (maybe). A work around would be to insert a
row below it and do another bottom border and then you could tuck these in
under each other. It's not same thing. Now there is an empty row there. It could trip you up
if you add another number. You can barely see it. You won't even know it's there. This
isn't the best but if you're using Google sheets, it's the only way to get a double
underline but its not the best practice so there's a couple more nuances to doing a
double underline. I have another video on it, how convenient;)
If you want to watch so go check that out. Another thing about Excel that's
just easier is the printing. One of the things that Google Sheets is
missing that I use all the time is a page break preview. You just turn this,
let me zoom in for you, and you can see where your page breaks are going to be. You can
move them around nice and simple. If you only want one page you
don't like column G just do this.
Sheets does not have that. Google sheets has more options now than they used to
such as you can take the grid lines off, or you can include the
titles but you can't just do the page break preview. The other thing you also can't do is
print with headers or footers which a lot of people miss that in Google sheets.
The last thing that you can do in Excel but you can't do in Sheets is sort by
highlighting. It can be really useful in Excel. Say this list is huge but a lot
of its highlighted. You can just go in and sort on cell color.
Let's say we want to bring the yellow to the top,
you can do that.
In Google Sheets, you can't do that. All I am going to do is I'm gonna show you that you can't do
that. Sort sheet. It just sorts it. It doesn't give you
the option to pick any criteria. Even if you try Filter
and you go to the drop down arrow, filter by values, it's not there.
There's no highlighting in here. There's no cell is filled or not filled or cell is a
certain color. That's my run down of seven things that I think work better in
the desktop version of Excel. I'm using Microsoft Excel 2010 but it gonna be really
similar 2013 or 2016 so I think this is still be pertinent to you. I know there's
a lot of things that Google sheets does better but not everything. I hope you
found this useful and talk again soon.