Microsoft excel, also known as Ms Excel or Excel, is a Spreadsheet program used to prepare data in Tabular Format, the second and most commonly used software after Ms Word. Due to the features, it is the first choice of millions of Accountant and Office Employee. If you know how to run Microsoft Excel, then you can do many hours of office work in minutes.

A lot of Formulae are given under Microsoft excel, which when applied on any spreadsheet, very complex Calculation can also be done automatically in minutes, if you save these Formulas in the sheet once, then repeat every month. You can prepare the tasks in a pinch, in Microsoft excel very easily Salary chart, Office employee, Database management, Billing software, stock management software can be prepared.

Important parts of MS Excel – Important parts of MS Excel

What is a work book in excel – what is work book in excel

Excel’s file is called a workbook. A workbook can contain many worksheets. In other words, a workbook is a collection of worksheets. A maximum of 255 worksheets can be added or created in an Excel workbook.

What is a worksheet in excel – what is a worksheet in excel

Worksheet is the most important part of MS Excel which is visible to us when opening MS Excel. It consists of a sheet which is made up of RAW and column. All the work is done in this worksheet itself. Let’s type in. On opening the excel for the first time, the Y default opens three worksheets which are denoted as Sheet-1 Sheet-2 and Sheet-3 ….

What is Raw in Excel – What is Raw in Excel

In Excel, the Horizontal Block is called Raw. In Excel, RAW is represented by 1,2,3. The maximum number of RAW in an excel sheet can be 1048576 RAW. It moves from top to bottom.

What are columns in excel – what is columns in excel in hindi

Vertical Block in Excel is called column. It is displayed with A, B, C, D. Currently the maximum number of columns in Excel 2019 is 16384. These columns are from right to right in Excel.

What are cells in Excel? What is Cells in Excel?

A cell in Excel means the place where a raw and column is found or intersecting. The name of a cell is formed by adding the name of the raw and column. For example, if the name of a cell is “A1″, it contains ” A “is Column and” 1 “is Raw

What is the formula in Excel – What is the Formula in Excel

You also type the value in the cell of the Excel. You have to type a special formula to add, subtract, divide it in which there is a particular sequence of cell references, values, functions, which gives the result according to the values ​​in the Excel. A formula always starts with = (equal)

Why should we learn Microsoft Excel

How to open MS Excel – How to open MS Excel in Hindi

  • You can open MS Excel in two ways, first click on Start Button, select Microsoft Office and then open MS Excel.
  • Press Windows + R on the keyboard and type Excel which will open MS Excel.

MS Excel Keyboard Shortcuts – MS Excel Keyboard Shortcuts in Hindi

To create a new workbook Ctrl + N
To open the workbook Ctrl + O
To save the workbook Ctrl + S
To see the print preview of the sheet Ctrl + F2
To print the worksheet Ctrl + P
To close the excel Alt + F4
To bold Ctrl + B
To italicize Ctrl + I
To underline Ctrl + U
To move to the next worksheet Ctrl + Page Down
To go to previous worksheet Ctrl + Page Up
To find a worksheet Ctrl + F
To replace in a worksheet Ctrl + H
To convert a cell to Date format Ctrl + Shift + #
To convert cell into currency format Ctrl + Shift + &
To convert cell to percent format Ctrl + Shift +%
To convert cell to time format Ctrl + Shift + @
To draw a chart F11
To refresh the sheet F9
To open Go To command Ctrl + G

How to learn MS Excel – How To Learn MS Excel in Hindi

If you want to learn MS Excel, then watch the videos below sequentially one by one. All these videos teach Microsoft Excel in simple Hindi language from beginning to end so that you can easily access Excel in a very short time. can learn –

Ms Excel Basic Knowledge in Hindi | MS Excel Introduction

Excel Basic Knowledge in Hindi | MS Excel Introduction | Part 1 – Microsoft Excel is a very useful Office Software, nowadays you already know how much workload has increased in Office, a lot of data has to be prepared every month, which is the biggest problem, to calculate. , And for that most people use the help of calculator, the calculator is right for a small accounting book, but if the calculation book is big and professional, then there is no better option than Excel.

Format Painter in Excel | Cell Formatting in Excel | Excel Tutorial Part 2

In this section, you have explained how you can do cell formatting in KMS Excel and how you can paste in any of the cells using the formatting format printer of another cell –

In this part, we have told about a very special command paste special of Excel which is very useful command, in this video you will learn how to use paste special and what are the important tips and tricks in it.

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here