Advanced Excel Training in Gurgaon

If you want to know something powerful amongst Excel features, it is its ability to quickly and easily sort data. It includes both alphabetizing the lists of strings (i.e. putting them in an alphabetical order), and ordering the numerical values — both from the largest to smallest and smallest to the largest. In this blog, we will learn the procedure to do so, i.e. we will cover everything from standard alphabetization (sorting from A to Z) to the reverse alphabetization (sorting from Z to A) to sorting numbers. Defining the problem Have a look at the below spreadsheet, that shows orders from SnackWorld's customers between the months of January and March: As it is visible, the list seems to be pretty messy on the first sight. If you wish to have a look at a particular customer's order history, it would be a very tough job to comb through the whole list and keep a note of each and every individual instance of that customer's name. But there’s a way out : If we ap...

Freezing panes in Excel Excel has an extremely interactive UI that makes viewing spreadsheet easy like zooming and freezing panes. In this blog, we will learn how to use these features and how they help us navigate through our sheets. Zooming in and out Excel sheets sometimes contain a lot of data and an ability to zoom in and out, comes in handy. For data magnification or so that more data comes fits on the screen. Excel has this feature inbuilt, we can do it with the use of slider on the bottom-right of the screen: You need to drag this slider to the right to zoom in: And you need to drag it to the left to zoom out: To set the zoom to specific level, you can also click the current zoom level (which is by default, 100%), which is visible on the zoom bar on the bottom-right hand side of the screen. Using this button, opens up a zoom options box, that allows Excel Users, to select a specific level of zoom for their sheet. If one chooses the 100% zoom option, it ...

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...