Join Aaron Quigley for an in-depth discussion in this video Understanding cells, part of Office for Educators.
Before we start designing our grade book, let's take a second, and discuss what cells are, and how they function. Unlike a Word document, when you open an Excel document, it's made up of a variety of column, and rows. The columns are labeled with the alphabet. The rows are labeled using numbers. Any individual cell can be referenced by its combination of letter, and number. The first cell would be, then, cell A one. The second cell would be B one. If I come down here to the third column over, and the fourth row down, this cell would be identified as C four.
Being able to reference cells allows us to do a variety of functions including writing formulas. Furthermore they're called Excel workbooks, because we can actually add multiple sheets, and pages to them. At the very bottom, I have this plus sign. If I add a plus sign I continue to add numbers of sheets to this workbook. Currently there are four sheets. And selecting the tab at the bottom, will allow me to change between these sheets. Sheets can function completely independent of each other, or you can reference cells in another sheet as well. We will do a little of both within this video series.
Furthermore, when it comes to adding text to cells, there's two ways to do it. If I highlight a cell, I can just go ahead, and type within that cell. You'll notice the content of that cell also appear at the bar at the top of the workbook. If I come back up to this bar, and I continue to add. You'll notice the text is continuing to be typed into the cell itself. This is really important, when it comes to writing functions. Also you'll notice that my text is longer than the cell. If I click outside to the cell, I now have text that's overlapping three different cells.
If I click on B and I type something on B, I now have an issue where I've got the text from A being cut off by the text from B. So same way with formulas, and text. If I want to quickly see what's written in column A, I can click on it, look at the formula bar, and find out what's written there. We'll talk about text formatting a little bit in this movie as well, because one thing that varies from Excel to Word. Is the ability to format text. If I come into excel, and let's say I really wanted this to be two lines, and I hit the enter key, nothing happens.
The only thing that happens is the next cell down is now highlighted. That's because formatting text in a cell is completely different, and we'll have to go into certain functions to format that text. Please keep this in mind as you move through this course. Any time cell formatting needs to take place, I will walk you step by step through the process. The last thing I'd like to mention is about margins. A lot of people when they open an excel spreadsheet, say "Well I don't want the text to go all the way to the edge of the page." And so they're tempted to start typing their first cell around there. However, there are still margins within excel spreadsheets.
And we'll talk about how to set those margins, and even how to format headers and footers in this video series. So now that we have the basics of cells, let's go ahead, and dive right in to creating our Excel spreadsheet.
- Creating lesson plan templates
- Creating worksheets with math equations, charts, and graphs
- Grading papers
- Creating a gradebook in Excel
- Creating an animated presentation
- Setting up a school email account in Outlook
- Storing documents online with SkyDrive
- Creating a class website with SharePoint
Skill Level Intermediate
Q: This course was updated on 10/01/2014. What changed?
A: We added a brand new chapter on Office Mix, the PowerPoint plugin that allows educators to record interactive presentations and test students with quizzes.
Q: This course was updated on 10/15/2015. What changed?
A. We added videos for OneNote, OneDrive, and Office Online. OneDrive replaced SkyDrive as the cloud-based file service.