Tutorial Playlist

Excel Tutorial

Overview

Your One-Stop Solution to Know About Excel Worksheets

Lesson - 1

Your One-Stop Solution For Excel UserForms

Lesson - 2

The Best Guide on How to Send an Email in Excel

Lesson - 3

Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel

Lesson - 4

A One-Stop Solution for Acing the Excel MIS Report

Lesson - 5

All You Need to Know About Barcode in Excel

Lesson - 6

Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation

Lesson - 7

A Comprehensive Guide on Excel Flash Fill

Lesson - 8

Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers

Lesson - 9

One-Stop Solution to Learn Everything About Excel Budget Template

Lesson - 10

All You Need to Learn About Match Function in Excel and Its Real-Time Implementation

Lesson - 11

Everything You Need to Learn on How to Create a Pivot Table From Multiple Sheets

Lesson - 12

The Major Fundamentals About XLookUp in Excel Along With Practical Examples

Lesson - 13

The Ultimate Guide to Learn How to Compare Two Columns in Excel

Lesson - 14

The Best Guide and Your One-Stop Solution to Master the Fill Series in Excel

Lesson - 15

What Is the DATE Function in Excel and How to Implement It?

Lesson - 16

Your One-Stop Solution to Designing and Implementing Hyperlinks in Excel

Lesson - 17

One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Lesson - 18

DAX in Excel: The Complete Guide for DAX Functions and Formulas in Excel

Lesson - 19

A Perfect Guide for All You Need to Know About Data Formatting in Excel

Lesson - 20

The Perfect Guide to Learn How to Add Columns in Excel

Lesson - 21
Your One-Stop Solution to Know About Excel Worksheets

Microsoft Excel is a software product designed and developed to store, organize and manipulate structured data. Excel Worksheet plays a vital role in offering multiple functionalities to ease the tedious process of managing data.

What is an Excel Worksheet?

An Excel worksheet is a software program/document that collects rows and columns designed to store information in an organized manner. An Excel worksheet also enables users to apply mathematical and statistical logic to the data and manipulate it according to the requirements of the business strategies.

So, this was a brief introduction to Excel Worksheet. In the next section, you will learn how to create a new Excel Worksheet.

How to Create an Excel Worksheet?

To create a new Excel worksheet, you need to follow the steps mentioned below.

By default, when you start Microsoft Excel, there is an option of selecting a variety of worksheets, as shown below.

Excel-Worksheet-Default-home.

You can select the option based on the requirements. For now, create a blank worksheet. The blank worksheet looks as shown below.

Excel-Worksheet-blank-worksheet

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program in Business Analysis

Insert a New Excel Worksheet

There might be a situation where you would need to include another worksheet along the side of the existing worksheet. This collection of Excel Worksheets is called an Excel Workbook. To insert a new worksheet, you can right-click on the sheet name in the bottom sheet tracker tray, as shown below.

Excel-Worksheet-right-click-insert

By selecting the new worksheet option from the available options, you can create a new worksheet as displayed below.

Excel-Worksheet-right-click-insert-new-worksheet.

A new dialogue box will appear on the screen, where you can select the option to include a new sheet.

In the next part, you will learn how to rename a worksheet.

Rename Excel Worksheet

You can rename the Excel Worksheet by right-clicking on the sheet name and selecting the rename option from the dialogue box as shown below.

Excel-Worksheet-right-click-rename.

In the next segment, you will learn how to delete a worksheet.

Delete Excel Worksheet

If you wish to eliminate the Excel Worksheet, you must right-click onto the worksheet tab and select the delete option from the dialogue box as shown below.

Excel-Worksheet-right-click-delete

Worksheets in Excel can also be hidden. Now, you will see how that can be done.

Hide Excel Worksheet

Sometimes, you might have to keep a particular worksheet hidden. You can achieve this by right-clicking the worksheet name on the worksheet tray and selecting the hide option from the dialogue box, as shown below.

Excel-Worksheet-right-click-hide.

If you want to unhide the hidden worksheet, you can right-click on the existing worksheet and choose the option of Unhide, as shown below.

Excel-Worksheet-right-click-unhide-dialog-box

The following dialogue box will show the list of hidden sheets, and you can choose the sheet you wish to unhide, as shown below.

Excel-Worksheet-right-click-unhide.

In the next part, you will learn to move or copy an Excel Worksheet

Move or Copy an Excel Worksheet

To move or copy an excel worksheet, you must right-click on the sheet name you wish to move or copy and select the option of copy or move option from the dialogue box as shown below.

right-click-move-or-copy.

After selecting the option, you will find a new dialogue box, as shown below.

right-click-move-or-copy-menu-box

The first step is to select the workbook where you want to copy or move the current worksheet. It can be the current workbook or a different workbook, as shown below.

-click-move-or-copy-workbook-selection-box.

The next step is to select if you want to move (cut and paste) the worksheet or copy the worksheet. If you wish to copy the sheet, then make sure you select the tick option as shown below.

Excel-Worksheet-right-click-copy-tick-box

If you wish to move the worksheet to a new workbook, then select the new workbook option in the first menu and do not select the tick in the last option that reads "make a copy".

In the upcoming part, you will learn to protect the cells in the excel worksheet.

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

Protect Cells in Excel Worksheet

To protect the cells in the Excel Worksheet, you should right-click on the sheet and select the safeguard cells option on the dialogue box, as shown below.

Excel-Worksheet-right-click-Protect-cells

The following dialogue box will help you select the contents on the sheet with a password, as shown below. 

Excel-Worksheet-right-click-Protect-cells-dialog-box.

With this, you have come to an end of this "Excel Worksheet" article. 

Looking forward to a career as a Business Analyst? Check out the Business Analytics Certification Training with Excel and get certified today.

Next Steps

"UserForms in Excel" can be your next stop. Generating a user form in excel will help you simplify the process to insert, delete, and manipulate data in Excel Worksheet.

Are you looking to go deeper with your Microsoft Excel learning Perhaps you are interested in furthering your career in Business Analytics?

If the answer is yes to either or both the above questions, the Business Analytics certification course offered by Simplilearn is something you should definitely explore. This applied training program is designed to help you grasp the basic concepts of data analysis and statistics which can help you devise insights from the data available to present the findings as visualizations with the help of executive-level dashboards. You will learn all this and more in our cutting-edge program. Take a look and enroll now.

Have you got any questions for us on this Excel Worksheet tutorial? If yes, do feel free to share them in the comments section below. Our subject matter experts will resolve them for you as soon as possible.

FAQs

1. What is an Excel worksheet?

You can sort and analyze raw data on excel. It is a collection of rows and columns. Each worksheet has 1048576 rows and 16384 columns. 

2. What are the basic Excel functions? 

Most basic and essential Excel functions are as follows: 

1. =IF(logical test, value if true, value if false)

2. SUMIFS

=SUMIFS(sum range, criteria range 1, criteria 1, …)

3. COUNTIFS

=COUNTIFS(criteria range 1, criteria 1, …)

4. TRIM

=TRIM(text)

5. CONCATENATE

=CONCATENATE(text1, text2, text3, …)

6. LEFT/RIGHT

=LEFT(text, num chars)

=RIGHT(text, num chars)

7. VLOOKUP

=VLOOKUP(lookup value, table array, column index number, range lookup)

8. IFERROR

=IFERROR(VLOOKUP(B2,$G$2:$H$12,2,FALSE),"Name not found. Check both lists")

9. VALUE

=VALUE(text)

10. UNIQUE 

=UNIQUE(array, by col, exactly once)

3. How many worksheets are there in Excel?

In one workbook you can add 255 separate sheets. 

4. What are Excel files called?

Excel has worksheets or spreadsheets where we usually work.These worksheets are stored in a workbook. One book can have multiple worksheets in it.

5. What are the shortcut keys for Excel?

Some common shortcut keys for excel are as follows: 

  1. Close a workbook - Ctrl+W
  2. Open a workbook - Ctrl+O
  3. Go to the Home tab - Alt+H
  4. Save a workbook - Ctrl+S
  5. Copy selection - Ctrl+C
  6. Paste selection - Ctrl+V 
  7. Undo recent action - Ctrl+Z 
  8. Remove cell contents - Delete 
  9. Choose a fill color - Alt+H, H 
  10. Cut selection - Ctrl+X 
  11. Go to the Insert tab - Alt+N 
  12. Apply bold formatting - Ctrl+B 
  13. Center align cell contents - Alt+H, A, C 
  14. Go to the Page Layout tab - Alt+P 
  15. Go to the Data tab - Alt+A

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.