Posts

What is Excel? And What are the uses of Excel?

Image
What is Excel? It is a software program included in the MS-Office Suite. It is used to create spreadsheets, that are documents in which data is laid out in rows and tables like a big table. Because of its extreme versatility and power, it has become one of the most used software in the business world for creating and managing data, be it of small amount or large in size. It was officially launched for public use in 1985. Excel has been one of the contributing reasons, that drove personal computing revolution in 1980’s and 1990’s all across the world. What is a spreadsheet? It is a specialised way of data organisation into rows and columns, with an aim to make it simpler to read and change, as and when required by the user. What are the uses of Excel? Excel has to offer something to everyone. Spreadsheets that are extraordinary and powerful tools, are frequently used in the corporates i.e. commercially for data storage and manipulation. Below are some examples that w...
7 comments
Read more

Working with rows, columns, and cells

Image
Working with rows, columns, and cells As the name suggests, here in this article we would be discussing one of the Basic Excel Topics that BeXpert Advanced Excel Home Tuition covers. In Excel, every worksheet is organised into a grid of rows, columns and cells. These Individual cells can also be grouped into ranges, which are just a series of cells that are strung together. All these work in coordination with each other, in order to form the basic layout of an Excel document. Cell Addresses Below is the diagram that shows rows, columns, cells, and ranges all in one place: As it is clearly visible, that Excel labels columns letterwise. It is also visible that column labels are highlighted along the top of the screen: A, B, C, etc. Rows are highlighted along the screenside and organised number wise : 1,2,3 etc. At each row and column intersection is a cell, which is just one of the boxes on the grid of a worksheet. Every cell has a unique address that is a result of the c...
1 comment
Read more