Microsoft Excel On Macs6:39 with Michael Watson
Get a quick tour of the Microsoft Excel user interface for Macs.
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 up