Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Get a quick tour of the Microsoft Excel user interface for Macs.
References
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
For business applications,
Windows is far and
0:00
away the most dominant operating system.
0:03
If you're on Windows,
you can skip this video and
0:06
watch the next one where I take you
through the Windows version of Excel.
0:08
Okay, if you're still with me,
you're probably a Mac user.
0:13
I am too.
0:17
Let me take you through a tour
of the Excel interface.
0:18
So here we are looking at
a blank spreadsheet in Excel.
0:22
You can see the basic tabular
format of columns and rows.
0:26
Also, there is a sheet down below.
0:29
We can add more sheets by
clicking the plus button, or
0:32
we can go up to the Menu bar,
scroll to the Insert,
0:37
sheets, by sheet.
0:41
This is a good time to call out one
of the biggest differences between
0:45
Excel on a Mac versus a PC.
0:48
You can see on a Mac that not every
item has a keyboard shortcut.
0:50
On a PC they will.
0:57
This means that if you're
a power user of Excel,
1:00
chances are you could get things done
much more quickly on a PC than a Mac.
1:02
Just something to be aware of.
1:07
Okay.
1:09
So, we have the menu bar at the top of
the screen with the application menu.
1:10
Then below that,
on the actual Excel interface, at the top,
1:15
there is what is called
the Quick Access Toolbar.
1:18
By default, it should have the File,
Save, Undo and repeat commands available.
1:22
If you click this arrow on the right, you
can customize your Quick Access tool bar.
1:29
I'll talk more about
that in a few minutes.
1:35
Then below the Quick Access tool bar we
have what is called the reading in Excel.
1:38
It is made up of different tabs
that each have their own toolbar.
1:42
So these are the tabs in the ribbon, and
then below them they have their toolbars.
1:47
So, for example,
if I click on the Data tab in the ribbon,
1:52
you can see this is where there's the Sort
and Filter options and other features or
1:56
commands related to data analysis.
2:00
Under View, you can Freeze panes,
or Set page layouts.
2:04
You can also adjust Zoom level
of your spreadsheet from here.
2:10
Which is helpful when you're chairing
a spreadsheet on a video call.
2:14
Sometimes you need to make it bigger for
others.
2:18
Below the toolbars,
we have the formula bar.
2:24
Excel has a ton of features and
commands and
2:28
also gives you several different options
to customize the software for your needs.
2:30
In just a few seconds,
2:34
I'll briefly cover some of
the customization options available.
2:35
In future courses we'll cover
more of the features and
2:39
commands available to you in Excel.
2:41
Some of you may have been wondering why
my ribbon has the developer tab in it and
2:44
yours does not.
2:48
Well it's because the view
isn't set by default.
2:50
If you go up to the menu bar and
select Excel Preferences
2:54
note the keyboard shortcut
command comma there on the right.
2:59
We get to the Excel Preferences window.
3:03
Here you can change your default
settings to suit your needs.
3:06
For example, if I click on ribbon and
3:10
toolbar, I can change which
tabs are visible in the ribbon.
3:13
This is also where I can change
what commands appear in the quick
3:18
access toolbar.
3:20
So for example,
I would deselect Developer in View.
3:25
Save down here at the bottom.
3:31
This is a little bit off the screen here.
3:33
Save.
3:36
Close this down, and look.
3:39
Those tabs are gone.
3:42
But I want them there, so
I'm gonna go back and add them.
3:45
View, Developer, Save.
3:49
Another cool thing is I can
also create my own tab.
3:55
Plus, new tab.
3:58
I'm gonna rename it.
4:05
TreehouseTab.
4:08
And I can choose which commands
I wanna put in there so
4:13
I'll put in my filter command in.
4:17
Commands can only be
added to custom groups.
4:22
To add a custom group, click the tab
where you want the group to appear and
4:25
then click new group.
4:29
Okay there you go so
I wanna go here, new group, boom.
4:30
Format why not, let's put that in.
4:38
And Paste Special is one of my favorites.
4:41
Let's put that in.
4:43
So you get the idea.
4:45
This is where you can customize
your ribbon tabs and commands.
4:46
So let's close this window.
4:53
Go over here to Treehouse tab,
and there they are.
4:55
There are lots of other
customization options.
5:00
For example, if you go to general,
5:03
you can change whether or not you want
to have centimeters, millimeters,
5:09
basically get off the Imperial system and
go onto the metric system.
5:12
As you continue to use Excel,
5:16
you may find yourself having to repeatedly
change certain formats or settings.
5:19
That is a good sign for
you to consider changing your preferences.
5:23
I want to leave you with two of my
favorite keyboard shortcuts that
5:27
are unique to Excel on Mac.
5:31
First, is control + u.
5:33
This allows you to get into the formula
bar from the cell you are in and
5:36
start editing.
5:40
So unlike Sheets, if you press Enter, it's
gonna take you to the next cell below it.
5:42
But if you press control + U,
you can see there I am in the formula bar.
5:45
The second keyboard shortcut I wanna
share with you is Command + T.
5:51
This allows you to make an absolute
reference with the cell.
5:55
So just, for example's sake,
I'm gonna put a couple numbers in here.
5:59
And then I'm gonna make
a relative reference and now
6:04
I'm going to make an absolute reference to
sell E5 so I'm holding command and then T.
6:09
And you can see it makes it absolute.
6:13
But I can cycle through it so
it's not just both column and row.
6:16
It can also be either or so if I press
T again you can see it goes to the row.
6:19
If I press T again, it goes to the column.
6:25
So watch, I'm still holding on Command,
and just pressing T.
6:29
And it's cycling through the different
absolute references I can do.
6:31
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up