EXCEL - 1
INTRODUCTION TO EXCEL
Excel is way more handy than google sheets. You can find all the options in Excel near your eye sight but in the case of google sheets you have to find it in a lengthy way..
In this tutorial we will use google sheets because it is available to everyone for free.
Ribbon:
The Ribbon is the strip at the top of the Excel window that houses all the tools and commands you need to perform various tasks. It's designed to make it easier to find the commands you need.
The Ribbon is divided into tabs, each representing a category of related commands.
Tabs:
Tabs are the main categories on the Ribbon, each representing a specific set of tools and functions. Common tabs include
"Home,"
"Insert,"
"Page Layout,"
"Formulas,"
"Data,"
"Review,"
and "View."
Each tab is organised into groups. For example, the "Home" tab may include groups like "Clipboard," "Font," "Alignment," etc.
Commands:
Commands are the individual tools or actions you can perform in Excel. They are organised within groups on each tab.
For instance, in the "Home" tab, you have commands like "Copy," "Paste," "Bold," "Italic," and other formatting options in various groups.
Cells, Rows, Columns:
Cells:
A cell is the intersection of a row and a column in an Excel spreadsheet. It is identified by a unique cell reference, which is the combination of its column letter and row number (e.g., A1, B2).
Each cell can contain data such as numbers, text, formulas, or functions.
Rows:
Rows in Excel are horizontal collections of cells identified by numbers (1, 2, 3, ...). Row 1 is typically reserved for column headers.
You can perform various operations on rows, such as inserting, deleting, hiding, or formatting them. The row number is indicated on the left side of the worksheet.
Columns:
Columns in Excel are vertical collections of cells identified by letters (A, B, C, ...). The first 26 columns are labelled with letters (A to Z), and subsequent columns use combinations like AA, AB, etc.
Similar to rows, you can perform operations on columns, such as inserting, deleting, hiding, or formatting them. The column letter is indicated at the top of the worksheet.
These things are basic IF you want to learn with me just learn about that topic which I am posting everyday.
LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.
Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46
THANK YOU
Top comments (0)