Skip to main content
HomeTutorialsData Analysis

Getting Started with Spreadsheets

This tutorial will give you a basic understanding of the terminology in spreadsheets along with learning how to create a basic table.
Feb 2019  · 5 min read

Spreadsheets are used by millions of people every day. They are an easy tool to use that can collect data, make calculations, and create visualizations. There are many types of spreadsheet platforms that you can check out here. For this tutorial though, you will learn the basics about Microsoft Excel and Google Sheets. A great course to take if you are new to spreadsheets is Spreadsheet Basics from DataCamp. With that said, let’s get started with spreadsheets and particularly Excel.

Excel

For Excel, you do need to pay for it and a link to do that is here. You will then need to download Excel to use it. Microsoft does offer a free trial to use.

Once you have Excel on your computer, you will be prompted to the page below. Here you can select that you want to create a new blank spreadsheet, choose from a recent one you were working on, select a spreadsheet that is shared with you, or open a past spreadsheet that you either downloaded or haven’t opened recently. For this tutorial, we will select “New” and then “Blank Workbook”.

Excel

Terminology

A big thing with spreadsheets is learning the terminology, and it is pretty consistent with both Excel and Google Sheets.

Sheets

So for the page, you are looking at when creating a “Blank Workbook” is called a sheet. To add a sheet to your workbook click on the + sign next to sheet1. This will create a new sheet for you. You can also name sheets by double-clicking on the sheet title.

Sheets

Columns

A column is classified vertically and located at the top of the sheet. They are identified by using letters. It is important to understand what these are called and how they are identified when writing formulas.

Columns

Rows

A row is classified horizontally and located on the right side of the sheet. They are identified by using numbers. Similarly to columns, it is important to understand what these are called and how they are identified when writing formulas.

Rows

Cells

A cell is the box where you can type in the sheet. You can type both letters and numbers in cells. To identify a cell, you use the column letter with the row number. An example would be B7. This means the cell is 2 columns over and 7 rows down.

Cells

Creating a Table

Below are gifs that show how to create a chart in Excel. The following things are covered:

Merge & Center Cells

Merge & Center Cells

This is useful for table titles, and it keeps things clean without having so many cell lines.

Formatting Text

Excel has all the capabilities a word document does when formatting the text. You can bold, italicize, or underline. Highlight

Wrap Text

Wrap Text

Here we wrap the text, so our table does in grow in width. This is especially useful when you have many columns, and you want to see all or most of them on the screen.

Add Borders

Finally, to keep fields and cells separated and distinct from one another, you can add borders. There are many options so you can try different ones until you find what you are looking for.

Saving

Lastly, you can save the workbook by clicking file... Save or Save As... By clicking on Save AS... you will be able to change the title of the workbook and select the location of where it is being saved. Finally, you can choose the file type you want to save the workbook as, e.g., .csv or .xlsx.

Google Sheets

In Google Sheets, the terminology is the same as Excel. To create a google sheet, you click on the nine square image in the top right corner of your Gmail account. Once you are there, you can click on the "Sheets" option or on "Drive" where you can then select "Sheets".

Step 1:

Google Sheets

Step 2:

Google Sheets

Step 3:

Google Sheets

Changing the Title

Changing the title

Creating a Table

Below are gifs that show how to create a chart in Excel. The following things are covered:

Merge & Center Cells

Merge & Center Cells

Formatting Text

Wrap Text

Wrap Text

Add Borders

That is it for Google Sheets, as you can see there is little difference between Excel and Google Sheets when it comes to the basics. Most of the time it is just the location of where the functions you need are located in different spots. One benefit of Google Sheets compared to an Excel workbook is the ease of sharing the workbooks with others and working on the same sheet simultaneously as someone else.

Conclusion

The purpose of this tutorial is to help people at the beginner level of spreadsheets understand the options they have to use spreadsheets, the basic terminology, and how to create their first table. As mentioned at the beginning of the tutorial, to expand on these basics take DataCamp's Spreadsheet Basics course and check out our Graphs in Spreadsheets tutorial. Thanks for reading and look for more spreadsheet tutorials to come out on more beginner and advanced topics.

Topics

Spreadsheets Courses

Course

Introduction to Google Sheets

2 hr
18.3K
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
See DetailsRight Arrow
Start Course
See MoreRight Arrow
Related

20 Top SQL Joins Interview Questions

Prepare your SQL interview with this list of the most common SQL Joins questions
Javier Canales Luna's photo

Javier Canales Luna

15 min

Data Sets and Where to Find Them: Navigating the Landscape of Information

Are you struggling to find interesting data sets to analyze? Do you have a plan for what to do with a sample data set once you’ve found it? If you have data set questions, this tutorial is for you! We’ll go over the basics of what a data set is, where to find one, how to clean and explore it, and where to showcase your data story.
Amberle McKee's photo

Amberle McKee

11 min

You’re invited! Join us for Radar: The Analytics Edition

Join us for a full day of events sharing best practices from thought leaders in the analytics space
DataCamp Team's photo

DataCamp Team

4 min

10 Top Data Analytics Conferences for 2024

Discover the most popular analytics conferences and events scheduled for 2024.
Javier Canales Luna's photo

Javier Canales Luna

7 min

A Data Science Roadmap for 2024

Do you want to start or grow in the field of data science? This data science roadmap helps you understand and get started in the data science landscape.
Mark Graus's photo

Mark Graus

10 min

Mastering Bayesian Optimization in Data Science

Unlock the power of Bayesian Optimization for hyperparameter tuning in Machine Learning. Master theoretical foundations and practical applications with Python to enhance model accuracy.
Zoumana Keita 's photo

Zoumana Keita

11 min

See MoreSee More