Microsoft Excel Spreadsheet Basics - The Beginner's Guide | Connor Look | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Microsoft Excel Spreadsheet Basics - The Beginner's Guide

teacher avatar Connor Look, Tech Guide, Entrepreneur

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

11 Lessons (13m)
    • 1. Introduction

      0:47
    • 2. Opening Spreadsheet

      0:37
    • 3. Entering data

      0:48
    • 4. Organising data

      1:13
    • 5. Inserting charts

      0:55
    • 6. Changing appearance

      1:50
    • 7. Using functions

      0:55
    • 8. Using filters

      3:07
    • 9. Formatting

      2:01
    • 10. Saving and downloading

      0:25
    • 11. Project

      0:48
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

307

Students

1

Projects

About This Class

Continue your learning: Excel 2019 All-in-One For Dummies

Welcome to my course! I am going to be teaching you the basics of Microsoft Excel Spreadsheet.

Check out my Computer Basics course for more: skl.sh/2Lyhans

By the end of this course you will know how to:

  1. Open Spreadsheets
  2. Enter data
  3. Organise data
  4. Insert charts
  5. Change appearance
  6. Use functions
  7. Use filters
  8. Change the format
  9. Save and download

Let’s get started!

-

Music: https://www.bensound.com

Meet Your Teacher

Teacher Profile Image

Connor Look

Tech Guide, Entrepreneur

Teacher

Hello, I'm Connor.

I am a tech enthusiast, problem-solver and entrepreneur.

I taught myself to code after getting a taster for it in secondary school; I then went on to take Computer Science and IT for GCSE. 

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Welcome to my course. I'm teaching the basics of Microsoft. Excel. By the end of this course, you will know how to open spreadsheets. And today, sir, organized data Insert chance, change the appearance, use functions, use filters, change the format and save and download spreadsheets spread. She is a really useful tool, both personally and professionally. By In this course, you will have mastered the basics, so let's get started. 2. Opening Spreadsheet: spreadsheet is an electronic document in which data is arranged in the rows and columns off the grid and could be manipulated and used in calculations. Toe open spreadsheet. Go to your Windows Explorer or Mac Finder and search for I think so. As you could see Microsoft Excel 2010 the application has come up. Now we can select on this, and it will open. 3. Entering data: Now we have spreadsheet open. We can begin by entering some data. To do this, we click on one of the rectangle was within the grid and start typing letters or numbers. So Data one has now been entered. We can click elsewhere, and it will leave that data in their essentially submitting it. If we want to change the data within these grids, we select on it. And then we could change the value up here to a different value, or we can double click here and change it within the grid itself. 4. Organising data: to resize a rectangle. We go to the axis along the top or down the side and click and drag on the dividing line. If we move to the right, we will increase the whip, making it wider. And if we moves, the left will decrease the with making a narrower. Once we've got to a size that we want, we release the left mouse button, and now the column is wide. We could do the same with the rose, clicking and dragging on the dividing line, moving further away and increasing the height and then releasing the left mouse button. As you could see, the second row on the B column are now both wider. To move the data within a cell, we first select on it and then click and drag on the border surrounding it and then move it to another cell. Once we release the left mouse button, you could see that the data is now removed to that cell 5. Inserting charts: the chart is a sheet of information in the form of a table graph or diagram. To insert a chart, we first click and drag to select the area in which our data is located, and then we go up to the insert tab and go over to the shots section. Now we can choose from the different types of chance. There's columns, line pie bar on multiple others, which you can choose from. I'm just going to use columns, a demonstration. When we select one of them, you can see that is generated a chart, and you could change the design by going along the top and clicking on one of the other options. 6. Changing appearance: toe. Add a border to the cells within our spreadsheet for select them by clicking and dragging, and then got to this symbol here and click the arrow to make the drop down menu appear. Now, you could choose from one of the main options of the bottom top, left or right borders. I'm going to use the right border, so select that by clicking it with my left mouse bottom. Now, as you could see, a right hand side border has been applied to his cells. I'm now going to employ a bottom border to these two cells here on the headings off this table have now been separated off from the data to make it clear to color in the cells for select, um by clicking and dragging and then go up to the fill color Icahn, which is a paint bucket and choosing one of the colors from the drop down. Lee. Once you select it, as you could see, those cells have now been colored in with that color. This is very handy for keeping your spreadsheet organized and helping you to understand it to change the text properties of the text within the cells first select the cell and then go to the front section and choose from different options. And you could change the text size, the text font, the text color onda, multiple other features, which I go for him or for early in my computer basics course. 7. Using functions: to access the functions. We go to the home tab and then go up to the editing section. And to this drop downing, as you could see with different functions such as some average count numbers, Max and men. What, these Do it. If we select data and apply one of the functions such as some that there tells us what the some of those numbers is. If we change it and we make it to the average, the average of those two numbers, We also get that answer we can also see wants how many numbers? They're all, uh, what? The highest number is Andi, What the lowest number is? 8. Using filters: to demonstrate sorting data. I'm going to use this data here, which I've added. I've put the what numbers one for nine. But in a random order, I'm now going to sort this smallest to largest. Now, to do this, we select the data by clicking and dragging. And then we go up to the editing section on the home page and go to sort and filter. Once we select on it, the drop down menu will appear and we could choose sorts Morriston, largest or largest to smallest. Well, I want smallest to largest. And when I select that, it will often come up with the soft warning which will ask whether you want to expand the selection and include neighboring cells or continue with the current selection. I'm going to choose that option and then press sort as you could see, the numbers have now been ordered one for a nine from smallest to largest. If we go back by pressing control, Zed and then, as you can see, they has returned to the original position. And now I could demonstrate what happens if you include multiple columns. When you sort items. If you re select it and then do the same again, going up to sort and filter and choosing this time largest to smallest. You could see the in this column the B column. The numbers have been ordered from largest smallest 931 on the have a column. It has gone corresponding, the same as it was previously along with this order. So if I go back once again, you could see that the one on the wonder together on the night of the Naina together, like in the previous sorted selection, a filter will allow us to constantly change how that data is displayed. So to do this, we first select the data and then go up to the same section editing and sort and filter. But we go down here to the filter option. Once we select this, as you could see, a filter has been applied. You need to make sure that you have thes two top rose available and empty, because that is where the filter will go. And if there's data there, it will be cleared out to make room for this. Now, to filter columns, see, we select the little arrow and we can choose from one of the options the same of smallest to largest or largest to smallest so smallest to largest as you could see. One for nine has been sorted and column D has also been sorted. Corresponding. If we do this one column d sought that, Then, as you could see, that has been sorted and column C has been sorted along with it. 9. Formatting: the format is the way in which something is arranged or set out to demonstrate formatting that scroll down the page to give ourselves room. Let's choose one of the cells to enter some data. Now former Ting on the original Microsoft Excel spreadsheet is found in this section called Number. If we enter loaded numbers, say, 1234 then we can go up to the number section now that we have selected that data and choose how we wanted to be formatted, as you could see, General. So no specific format and we have multiple other options. So numbers, currency accounting, there's dates, times, percentages, fractions and many other options, which you could also access many more through here. But for now, I'm going to stick with the simple ones so we can choose currency, and, as you could see, it automatically set it as £1234. You can change the type of currency here, so we have the pounds, the dollar and the euro. There are more accounting formats available there, as it says. We can also change this to a percentage, or we can make it so that the thousands. Every free digits is divided by a comma to make it simple and easy to read. So if you could see it has been a common now applied there to make this more specific or less per specific to make this more or less specific, we can use this increase or decrease decimals. I'm going to decrease so that it simply says to the whole number what the amount is. 10. Saving and downloading: to save the spreadsheet, go to file and then select Save if you haven't already, and then I'll ask you where on your computer that you would like to save it. For more details, go to my computer Basics course, where I go into this more thoroughly. 11. Project: to consolidate your knowledge, I would like you to create a table with headings and data. Use the table to insert a chart, download the chart as a PNG image, then upload the PNG image to the project section of this course. If you need any help, check out my computer basics course. Link will be in the description. Good luck, and I look forward to seeing your project. It would be greatly appreciated if you shared this course, watched my other courses and left a review.