Microsoft Excel Tutorial (Beginner to Advanced) – Tutorial #01: [Excel /Spreadsheet Terminology].

in Steem For Bangladesh5 days ago (edited)

@arjinarahman ©
#Bangladesh 🇧🇩


Greetings


As-salamu Alaikum.
Hello Steemians! Hope everything is going well with you all. I'm going to share a tutorial on Microsoft Excel. I hope this tutorial will benefit you in your work and lead to enjoyable learning.
Let’s get started!


Excel /Spreadsheet terminology

Microsoft Excel _20250217_005429_0000.png

Designed with Canva Pro

In this tutorial series, I will share different topics about Microsoft Excel, from beginner to advanced levels. Today’s lesson is the first tutorial of the series. So, let’s start!

For this tutorial, I will use my laptop. My laptop is from the Lenovo brand, and it runs on Windows 10. I will use Microsoft Excel 2013 for this tutorial. To take screenshots, I will use a software called Lightshot.

Screenshot _20250216_205736.png

Screenshot _20250216_210151.png

First, I turn on my laptop and click on the Windows Start icon. Then, from the menu that appears, I select "Excel 2013".

Screenshot _20250216_210455.png

Now, you can see that Microsoft Excel has opened, and its interface is visible. Here, I click on "Blank Workbook", and a new Excel workbook opens. You can see the full Excel interface in the screenshot.

Screenshot _20250216_210827.png

This looks like a grid-lined notebook. When we make a shopping list or a shopkeeper gives us a receipt, we see similar grid lines. In schools, attendance registers also look like this. This digital version of a grid-lined notebook is called a worksheet or spreadsheet.

Screenshot _20250217_023116.png

In today’s tutorial, I will introduce you to some important terminology in Microsoft Excel. I will not explain them in detail today. I will only introduce them. In the next tutorials, I will explain each topic in detail.


Screenshot _20250216_213457.png

Screenshot _20250216_225801.png

The top part of the worksheet is called the "Ribbon." The ribbon has different tabs, like Home, Insert, Page Layout, and more.

Now, let’s discuss these tabs one by one.

  • Home Tab:

Screenshot _20250216_220614.png

This tab has tools like Clipboard, Font, and Alignment. These tools help in formatting text.

Screenshot _20250216_222744.png

For example, I type "Steemit.com" in a cell. Now, I will increase the font size. I select the text size, then click on "Bold" and "Italic." Now, the text looks bigger and slanted (italic).


  • Insert Tab:

Screenshot _20250216_220301.png

This tab allows us to add pictures, tables, and charts in Excel.


  • Page Layout Tab:

Screenshot _20250216_220147.png

This tab has page setup and print layout options.


  • Formula Tab:

Screenshot _20250216_215407.png

We use this tab for mathematical calculations in Excel.


  • Data Tab:

Screenshot _20250216_215817.png

This tab is useful for sorting and organizing data.


  • Review Tab:

Screenshot _20250216_215715.png

This tab has extra tools like spell check.


  • View Tab:

Screenshot _20250216_215257.png

This tab helps to control how the worksheet appears on the screen.

Screenshot _20250216_222322.png

When we click on a cell, a green border appears around it. This means the cell is active, and we can type data into it.

Screenshot _20250216_221232.png

The Excel version I am using has more than 1 million rows and over 16,000 columns.

Screenshot _20250216_221714.png

When we click on a cell, its data appears in the formula bar. We can also edit the data from the formula bar. If we change the data in the formula bar, it will update in the cell. If we change the data in the cell, it will also update in the formula bar.

Screenshot _20250217_032013.png

Each cell has a unique name. For example, if I type my name (Arjina Rahman) in a cell located in column C and row 7, the cell’s name will be "C7."

Screenshot _20250216_222939.png

Like a physical accounting notebook, an Excel workbook can have multiple sheets. If you look at the bottom left corner, you will see the "Sheet" option. Click on the plus (+) sign to add a new sheet.

Screenshot _20250216_223826.png

At the bottom right corner, there are three view options: "Normal," "Page Layout," and "Page Break Preview." These options help us change how the worksheet looks. Next to these, there is a "Zoom" option, which allows us to zoom in or out of the worksheet.

Screenshot _20250217_020206.png

Screenshot _20250217_020232.png

We can use spreadsheets on mobile if we want. A free software for mobile use is WPS Office. Its usage rules are almost the same as Microsoft Excel.



That’s all for today. In this tutorial, I introduced some important Microsoft Excel terms. In the next tutorial, I will teach more new topics. Stay well.

Image Information
Device NameLenovo
Screenshot ToolLightshot
Screenshot Taken and Edited by@arjinarahman

Sort:  

Upvoted! Thank you for supporting witness @jswit.