Choosing Spreadsheet Software2:39 with Michael Watson
There are many different spreadsheet programs from free options like Google Sheets to industry-standards like Microsoft Excel. Learn about the options in this video.
There are countless software packages for building and working with spreadsheets. 0:00 The most widely used spreadsheet software is Microsoft Excel, it's everywhere and 0:05 is used extensively in most businesses. 0:10 And it has a very powerful set of features and 0:12 it's the spreadsheet software most people use. 0:14 In this course, we're gonna use Google Sheet software. 0:16 It's free, has all the functionality you will need, 0:19 and looks and works the same across different types of computer systems. 0:22 Generally speaking, any spreadsheet software that comes with your computer or 0:26 Google Sheets, which is free online, 0:30 are fine places to begin learning how to use spreadsheets. 0:33 But if you're working with a large amount of data and formulas 0:37 I'd argue it's probably worth investing in more robust software than Sheets. 0:41 What software do you use depends a lot on your use case, 0:46 as there are some industries with very specialized spreadsheet software needs 0:50 where using more generic spreadsheet software is impractical. 0:54 For example, you could build out an inventory management spreadsheet in Excel. 0:58 But there is specialized software out there that will allow you to do that 1:03 without Excel. 1:06 Another example, is using a spreadsheet for 1:07 your accounting instead of software like QuickBooks. 1:09 Here we are looking at a blank Google sheet. 1:13 You can see the spreadsheet title at the top. 1:16 You can rename the title by clicking on it and 1:18 then entering whatever text you want to have changed. 1:21 The menu bar includes different options that will allow us to work with 1:26 the spreadsheet's data. 1:30 This is the menu bar right here. 1:31 These menu items are similar to those you'd find in any spreadsheet software. 1:33 Under File, for example, you can see some of the typical 1:38 options you may be familiar with like New, Open, or Make a copy. 1:41 There is noticeable item missing from file though, save, 1:45 fortunately Sheets automatically saves for you, as seen right here. 1:50 Don't forget to save regularly if you are using other software 1:56 as there is nothing worse than losing work. 1:59 I do want to call out something important here. 2:02 You'll notice that if you scroll over the undo button, 2:04 there is also a Command Z in parentheses. 2:07 If you are using a PC, 2:10 it will say Control Z instead of Command, this is a keyboard shortcut. 2:11 So to undo something, instead of having to scroll through the Edit menu or 2:15 click on the toolbar I can just type Command and Z at the same time to undo. 2:20 I can't stress enough how important keyboard shortcuts are. 2:25 Learning and 2:29 using them will make you so much more productive than simply using the menus. 2:30 They're so important, in fact, I'll be talking about and 2:34 asking you to memorize them throughout the course. 2:36
You need to sign up for Treehouse in order to download course files.Sign up