Multiple Vlookup in Excel
What is Excel?
Excel is pronounced "Eks - sel"
It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS.
The first version was released in 1985 and has gone through several changes over the years. However, the main functionality mostly remains the same.
Excel is typically used for:
1. Analysis
2.Data entry
3.Data management
4. Accounting
5. Budgeting
6. Data analysis
7. Visuals and graphs
8. Programming
9. Financial modeling
And much, much more
********************************************************************
Why Use Excel?
It is the most popular spreadsheet program in the world
It is easy to learn and to get started.
The skill ceiling is high, which means that you can do more advanced things as you become better
It can be used with both work and in everyday life, such as to create a family budget
It has a huge community support
It is continuously supported by Microsoft
Templates and frameworks can be reused by yourself and others, lowering creation costs
*******************************************************************
The Name Box in Excel
The Name Box shows you the reference of which cell or range you have selected. It can also be used to select cells or ranges by typing their values.
*******************************************************************
Excel Formula Bar
Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.
*********************************************************************
Worksheet:
A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, a workbook can store chart sheets; a chart sheet displays a single chart and is accessible by clicking a tab.
*************************************************************************
Workbook
A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet. You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook.
****************************************************************************
Active Cell: A cell that is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons. To edit a cell, you double-click on it or use F2 as well.
Column: A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column by clicking on its header.
Row: A row is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number for identity, starting from 1 to 1048576. You can select a row by clicking on the row number marked on the left side of the window.
#viral
#trending
#excel
#learnexcel
#exceltips
#microsoft
#microsoftexcel
Tags - Excel,Excel function,excel function,excel in hindi,excel introduction video,excel mein product function,product function in excel,auto sum,sum,autosum,excel for beginner,rktsir,rkt sir,excel with ease,excel in easy language,excel video in hindi,hindi,hindi mein excel,mein,excel video,excel viral video,excel trending video,excel ki video,excel ka function,excel function in hindi,trending video,viral video,Excel product and autosum,autosum in excel
Информация по комментариям в разработке