New Feature: Playlist Center! Pick a topic and let our playlists guide the way—like a learning mixtape.

Start learning with our library of video tutorials taught by experts. Get started

Computer Literacy for Windows
Illustration by Neil Webb

Creating a simple data table


From:

Computer Literacy for Windows

with Garrick Chow

Video: Creating a simple data table

Now, let's take a look at how to create a basic spreadsheet from scratch. Again, I am working in Microsoft Excel, but everything I am going to show you here, should apply to other spreadsheet applications as well. I am going to create a new blank spreadsheet by clicking the Office button, selecting New and then choosing Blank Workbook. If you are using another spreadsheet application, you'll probably choose File > New Workbook, or something like that. So, let's say I am trying to decide between two jobs at an hourly rate. One pays more per hour but offers slightly fewer hours than the one that pays less. I am going to start by using the first rows of columns B and C as headers for the two job calculations.
Expand all | Collapse all
  1. 2m 44s
    1. Welcome
      1m 9s
    2. Using the assessment files
      1m 2s
    3. Using the exercise files
      33s
  2. 9m 53s
    1. What's a computer?
      1m 48s
    2. What's inside a computer?
      2m 46s
    3. Laptop vs. desktop computers
      1m 52s
    4. Special considerations when using a laptop
      3m 27s
  3. 17m 29s
    1. Understanding the operating system
      3m 3s
    2. Understanding files, folders, and directories
      4m 38s
    3. Understanding your Home (User) folder
      3m 9s
    4. Using your desktop
      2m 46s
    5. Taking out the trash (recycle bin)
      1m 45s
    6. The right click
      2m 8s
  4. 25m 38s
    1. Understanding applications
      4m 36s
    2. Opening and saving files
      4m 3s
    3. Choosing the right tool
      4m 37s
    4. How to learn any application
      4m 53s
    5. Five things that work in all applications
      7m 29s
  5. 35m 26s
    1. Understanding computer ports
      2m 33s
    2. Setting up a printer
      3m 36s
    3. Printing your documents
      3m 52s
    4. Setting up a scanner
      2m 8s
    5. Scanning a document
      5m 59s
    6. Setting up a projector or a second monitor
      6m 17s
    7. Using a projector
      3m 43s
    8. Portable storage devices
      3m 55s
    9. Pairing with Bluetooth devices
      3m 23s
  6. 20m 46s
    1. Understanding networks and internet access
      2m 58s
    2. Connecting to wired networks
      2m 47s
    3. Connecting to wireless networks
      5m 0s
    4. Working in a networked environment
      5m 49s
    5. Staying protected from viruses
      4m 12s
  7. 23m 24s
    1. Understanding email servers and clients
      2m 11s
    2. Setting up your email application
      4m 15s
    3. Receiving and reading email
      3m 50s
    4. Composing new email messages
      7m 4s
    5. Reply vs. Reply All
      2m 12s
    6. Dealing with spam
      3m 52s
  8. 8m 22s
    1. Understanding search engines
      1m 24s
    2. Conducting basic searches
      3m 44s
    3. Conducting advanced searches
      3m 14s
  9. 27m 15s
    1. Introduction to word processors
      4m 46s
    2. Formatting text
      7m 57s
    3. Introduction to spreadsheets
      4m 0s
    4. Creating a simple data table
      8m 13s
    5. Formatting a data table
      2m 19s
  10. 28m 52s
    1. Importing images from a digital camera
      7m 57s
    2. Storing and organizing digital images
      4m 28s
    3. Basic image manipulation
      9m 17s
    4. Tagging images
      4m 56s
    5. Sharing images
      2m 14s
  11. 12m 46s
    1. Common obstacles in sharing files
      1m 37s
    2. Creating PDFs for document sharing
      6m 4s
    3. Compressing files
      5m 5s
  12. 1m 4s
    1. Goodbye
      1m 4s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Computer Literacy for Windows
3h 33m Beginner Aug 06, 2010

Viewers: in countries Watching now:

In Computer Literacy for Windows, author Garrick Chow walks through the skills necessary to use computers comfortably, while improving learning, productivity, and performance. This course focuses on the Microsoft Windows operating system and offers a thorough introduction to computers, networks, and computer peripherals such as printers, digital cameras, and more. In addition, basic procedures with software applications, the Internet, and email are covered. Exercise files accompany the course.

This course also includes chapter-level assessments for use as instructional aides. To download the assessments, click the following link: Computer Literacy Assessments. The file contains an assessment movie, chapter-level assessments, and answer keys.

Topics include:
  • Working with a laptop versus a desktop computer
  • Understanding an operating system
  • Understanding five traits almost all applications share
  • Printing
  • Setting up a scanner
  • Connecting to a wired or wireless network
  • Sending and receiving email
  • Searching the Internet
  • Importing and editing images from a digital camera
  • Sharing documents and images
Subjects:
Business Operating Systems Computer Skills (Windows)
Software:
Windows
Author:
Garrick Chow

Creating a simple data table

Now, let's take a look at how to create a basic spreadsheet from scratch. Again, I am working in Microsoft Excel, but everything I am going to show you here, should apply to other spreadsheet applications as well. I am going to create a new blank spreadsheet by clicking the Office button, selecting New and then choosing Blank Workbook. If you are using another spreadsheet application, you'll probably choose File > New Workbook, or something like that. So, let's say I am trying to decide between two jobs at an hourly rate. One pays more per hour but offers slightly fewer hours than the one that pays less. I am going to start by using the first rows of columns B and C as headers for the two job calculations.

So I'll click Cell B1 and I'll type Job A. To move horizontally from cell to cell, press the Tab key on your keyboard. Notice each time I press Tab, it moves one cell to the right. You can go back to the left by holding the Shift key down as you press Tab. So I'll label Cell C1 as Job B. And I'll use Column A to label all the rows I am going to need. I'll start with A3. This is just kind of arbitrary. I could start with A2, but I like having a little bit of space in there. Now, I'll type Hourly Wage.

Pressing Enter or Return on your keyboard lets you move down a single row. So each time I press Enter or Return, you can see I move down. And again, holding Shift while pressing Return in this case moves you back up. So, I'll make the next cell here, Hours/week, and I'll press Enter twice and type Annual Income. Now, Column A isn't quite wide enough for the text that I type. So I am going to place my mouse cursor between Columns A and B until my mouse cursor looks like this vertical line with the two arrows pointing in either direction.

Then I can click and drag Column A a little wider. Okay, so far I've added labels to these cells. Basically, cells containing only text and no numbers are generally referred to as labels. Next thing I am going to add the data that I know about each job, namely the Hourly Wage and Hours/week. Now, since these are going to be numbers, I could format the appropriate cells to only accept numbers. It's not absolutely necessary, but it's a good habit to format your cells for the type of content they are supposed to accept, especially if other people are going to be using the worksheets you are creating. You want to make sure they can't fill in any incorrect information.

So I'll first drag to select the two cells where I am going to type in my Hourly Wage information. With those cells selected, I am going to go over to the Data tab and here in the Data Tools section, I am going to click Data Validation. That opens the Data Validation window and here into the Settings tab, I can specify what type of input is allowed in this cell. Since this will be an Hourly Wage, I am going to choose Decimal. In order to validate cells like these that are going to accept numbers, I have to specify a range of numbers. In this case, I'll put in a range of 0 to 100.

As I doubt I'll be making more than $100 per hour, but I could also come back and change this if necessary and I'll click OK. So now if I click in one of these cells and try to type anything but numbers and I press Return, I get a message telling me the value I entered is not valid and that the cells have been restricted. It would be nice if it actually told you what kinds of values are acceptable but I'll just click Retry. Let's say the Hourly Wage for this Job A is $14.75. I'll press tab to enter it and move to the next cell and that value is accepted because it is a number.

Let's make Job B's Hourly Wage $15.85. I'll just press Return. Those both numbers were aligned to the right side of their cells. Now since these are both monetary values, I want to format the cells to make their contents look more like dollar values. So I am just going to select both those cells again, and then under the Home tab in the Number section of the Home tab, I am going to select Currency as the kind of number for these cells. And that puts a dollar sign in front of my numbers. So for the Hours/week cells, I can do something very similar. Let's select both of those cells and let's validate those as decimal numbers too.

So I am going to go back to Data > Data Validation > Decimals and let's make a range between 0 and 80 hours per week. I'll click OK. All right, so let's click in Job A's column and let's say Job A is offering 40 hours per week. Press Tab, and Job B is offering 37.75 per week. I know it's a weird number but bear with me here. Now, if I wanted to, I could again go back to the Home tab, select those cells, and this time choose Number as the format.

That reformats the number in those cells and gives them both two decimal places. Now, Job B already had two decimal places, but it added a .00 for Job A. Now, you can the number of decimal places using these two buttons in the Number section. So I could add a third decimal place if necessary or reduce it to only one decimal place. Notice that it automatically rounds up 37.75 to 37.8. Now if I lose the decimal places altogether, it rounds the entire number up to 38. But I'll keep this at two decimal places.

Okay, by now you should have the basic idea of how to enter data into a new worksheet from scratch as well as how to validate the contents of the cells. Now, I could get out of regular calculator and figure out what my annual income for both jobs would be, but it's worth entering the proper formulas into Excel so if the terms of the Hourly Wage or Hours/week change, I'd just have to plug in the new numbers to update my totals. So, to add a formula to a cell, I first select the cell by clicking it, and then I'll click the Formulas tab. Next, I am going to click the arrow under the AutoSum button, which gives me a list of common calculations.

But I need a formula other than what's listed here so I'll choose More Functions. That opens up the Insert Function window. So to figure out the annual income for each job, I need to multiply my Hourly Wage by my Hours/week, and then multiply that number by the number of weeks I'll be working in a year. So it's going to be multiplication and multiplication is a basic math function. So in the select a category menu, I already have Math & Trig selected, and you can see there are other different categories we could choose from. Statistical, Database, Text and so on, but I am going to stick with Math & Trig.

And then under the Math & Trig functions, I am going to find Product, which means to multiply. I'll just double-click that. That opens the Function Arguments window. So, now it's just a matter of building my formula by specifying which cells need to get multiplied together. So, I have Number1 currently selected. So I'll click Cell B3, which is my Hourly Wage for Job A. And you can see B3 gets entered for Number1. Then I'll click in the Number2 field and select B4. Notice the formula I am building appears in the cell itself as well as in the panel that appears at the top of my worksheet.

Okay, so now I need to multiply the product of B3 and B4 by the number of weeks a year I'll be working, which we'll say is 52. So I'll click in Number3 and type in 52. Notice each time you click in one of these cells, it adds another number in case you have more numbers you need to add into your formula. But that's basically all I need here. I need to multiply B3 by B4 by 52. And I can already see the result at the bottom of the window here, Formula result 30680. So I'll click OK to close out the formula and just like that, the calculation is preformed, and I see the annual income for Job A is $30,680 a year.

Now, a really nice thing about most spreadsheet programs is that if you want to perform the same calculation on another set of numbers in your spreadsheet, you don't have to build the whole formula again. I am just going to make sure Cell B6 is selected, which is the Annual Income for Job A and under the Home tab, I am going to click Copy. You can also use Ctrl+C or choose Edit > Copy in other spreadsheet programs. Then I'll select the Annual Income cell for Job B and I'll choose Paste or you would choose Edit > Paste or press Ctrl+V. It's that easy. Notice the formula area at the top of my worksheet shows that I am multiplying C3, C4 times 52, which is swapped out for B3, B4 and 52.

Now, I can plainly see that Job B will offer me slightly more money even though it's fewer hours. And if any of this data changes, maybe Job B is reduced to say 35 hours/week, I just need to plug that in, hit Enter, and my product is instantly updated. Now lastly, I should probably reformat these Annual Income cells as Currency. I'll just select them, change it to Currency, and there we go. So that's the basics of entering your own data into a new worksheet and performing calculations.

There are currently no FAQs about Computer Literacy for Windows.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Computer Literacy for Windows.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.