Essential Digital Skills Level 1

111 videos, 7 hours and 55 minutes

Course Content

MS Excel

Video 64 of 111
3 min 17 sec
Want to watch this video? Sign up for the course or enter your email below to watch one free video.

Unlock This Video Now for FREE

This video is normally available to paying customers.
You may unlock this video for FREE. Enter your email address for instant access AND to receive ongoing updates and special discounts related to this topic.

We are now going to have a basic overview of Microsoft Excel. Now, once we have logged into the program, we are now on the homepage. Now, this is very similar to the video we had on Microsoft Word, things are pretty much in the same place, so we are just going to overview them. Along the top, you have got blank spreadsheet, so if you want to have a blank workbook, you just click that too, exactly the same as with the Microsoft Word. I suggest that you do go through the whole other tour on this, and you would learn more and more about the program and how it works. You are not going to know it all straight away, it's very complex, but you will get a hold of the basics pretty quickly. On from here, there are other standard templates, this is a list template, so if you want to start creating lists of things, you can use that as a basic template and you can adjust quite a lot. You can do financial calculations on there, you can have task lists and track tasks, you can create different charts as well and track your money. So there is lots of other things on there, family budgets, personal budgets. And again, at the top right-hand side, there are more templates should you need them.

The recent documents are down here, and you can tell that they are Excel files because they got little X in there, so that is how they are all displayed on here. And on the right-hand side, you can see when they were last opened or when they were created. The left-hand menu, we have got the New button, which calls up the blank template, but also a lot more spreadsheets, so you can see there is a lot more complex charts there. So with these charts, there is something that you might find, and rather than go start from scratch, there is something that is already on the system that you can use. And often, you can also download extra templates online should you need to.

The Recents file is all the recent folders on there, much more than on the home button. So if you go down, there is a lot more files on there than there were originally. Shared will wear anything shared, but you would need to be logged in and also, you would need to... If you are using the shared folders, have something shared. So in this example, there are not any in this folder. The open is where you can open documents up, and again, you can use it from OneDrive. As I said, we are not currently logged in, so that is why we got the triangle there. But if you are using OneDrive, you can click on those, if not, just go directly onto here, and you can go on My Mac and you can find the file that you want. So if you want to open this spreadsheet here, so it is Excel spreadsheet docs XLSX, that it shows it is a new file, so we just click on that, that will open up the folder we want. We are just going to put it full screen, and then this is the file that we are working with, so what we can do on here is we can type whatever we want in the document and do all the calculations in bits and pieces. To get out of this, just go up to the top left-hand corner with a Mac on the right-hand corner with a Windows machine, and you click the red dots or the X, and that will then shut it down. It will give you the option to save it, so obviously you want to make sure your work is saved, so just hit the Save button, and that will take you back to the main desktop page.

So we then go from here and just open up Excel again. To shut Excel down fully, we can just go up to the top, Excel, quit Excel, and we are straight back on the desktop page on your computer.

Learning Outcomes:
  • EDSQ Unit 2 LO 8.1