Advanced Excel Training in Gurgaon

Now when we have had a good feel about the Excel interface, and some practice of using familiar functions like Copy and Paste to manipulate, move, and duplicate data on our spreadsheets. But after using these features for a while now, we have faced a common problem lot of times, that we are unable to figure out a solution for : while we are copying and pasting cells, everything about the cell is copied and pasted — not just the value of the cell, but also its format. And, if we copy and paste a cell containing a formula, the formula itself is duplicated rather than the value that the formula outputs. This is often helpful, but sometimes it doesn't give the wanted result due to relative cell references. Sometimes, we just want to copy and paste the values of cells without bringing along anything else! That's where the Paste Special command comes in. Once we have copied the contents of a cell or range of cells, it is quick and easy to paste only the parts of that cell that ...

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