Merge and Center the most commonly used feature in excel. This feature is used to combine multiple cells and create a cell that spans across multiple rows/ columns. In this post let us know about the center across selection in excel. Use and advantage of center across selection over merge and center. Though many analysts …
Center Across Selection in Excel – Merge and Center – Alternative Continue Reading »
VLOOKUP is one of the most important formula/ function in excel. In this post I will explain how to use VLOOKUP function in excel in detail and also the limitations of it. The more you use it, the simple it becomes. Before getting into the post let’s understand and break few Myths about VLOOKUP Function. …
In this post let us see how to use the if function in excel with practical examples. DOWNLOAD the practice workbook to follow along. In our day to day lives we come across different situations where we need to choose/ make a decision based on the options available. Every decision we make/ need to make …
IF Function in Excel with Practical Examples Continue Reading »
There are hundreds of functions in MS-Excel. There are a few of them which we use frequently and INDIRECT function is one among them. Indirect function is under the category of lookup or reference function. Let us know the importance of indirect function and see how to use Indirect function in excel and its usage …
How to use INDIRECT function in Excel – Complete Guide Continue Reading »
We know that every cell in the spreadsheet has a unique name by default. This name is nothing but the combination of the row number and the name of the column. Now the question is can I have my own name(s) assigned to a cell/ a group of cells (range) instead of the default name …
How to Create and Use Named Ranges in Excel Continue Reading »
Understanding Cell References in Excel is one of the important things to master excel and make the most out of spreadsheets. Cell References combined with auto fill feature of excel help you to reduce/ eliminate the dirty manual work. To begin with cell references in excel, we need to understand what a cell is and …
How to use Cell References in Excel – Relative, Absolute and Mixed Continue Reading »
In this post, let us see how to open same excel file in multiple windows to review or preview the changes before saving it. Read this Article on MEDIUM What is the need to Open Same Excel File in Multiple Windows / Instances As an Analyst, I will be working on bigger data sets which …
How to Open / View Same Excel File in Multiple Windows – Excel Efficiency Tip Continue Reading »
