Blog Posts on MS Excel
In this blog post, I will explain two Excel formulas that can be used to pick a random value from a List. Following is a list of 6 contestants for a particular game. For each round of the game, a player should be randomly selected from this list. Let’s see how to pick a random…
In this blog post, I will show you 3 different ways to remove Macros from an Excel workbook. Saving the Workbook as XLSX file This is the easiest way to remove macros from an Excel workbook! XLS, XLSM, and XLSB are the only Excel file formats that can hold VBA projects or Macros. If you save an Excel…
A Drop-down list that depends on the selection made using another Drop-down list is called a Conditional or Dependent drop-down list. Following is an example of the same. As you can see, when we go for the degree B.sc in column C, the options are Physics, Mathematics & Chemistry. For B.A, the options are Malayalam,…
Create a Drop-Down List A drop-down list also known as a drop-down menu is a graphical control object that offers a list of options. In cells with a drop-down list, the user need not type in anything but can make the selection from the available options. In this blog post you will see, How to set up…
In Excel, when we Copy-Paste from a dataset containing hidden rows, the hidden rows also get copied. In this blog post, we will see 3 different methods to select only the visible cells in Excel. Keyboard Shortcut Alt + ; is the shortcut to select visible cells in Excel. Select the cells and press Alt…
Filtered Rows and Hidden Rows In Excel, Rows that we hide manually and those Rows get hidden while applying Filters, work in different ways. When we copy-paste a value into the filtered cells they won’t be copied into the hidden cells. At the same time, if we hide some rows manually and copy-paste a value…
This article is about 3 different methods to Reverse a List in Excel. Following is a list of candidates applied for a job. Let’s see the different methods to reverse this list for scheduling the interview. 1. Reverse the list using a Helper column Create a helper column with sequential numbers (for example 1,2,3,..) adjacent…
A few lesser-known, but pretty useful Keyboard Shortcuts in Excel are explained in this post. 1. Legacy shortcut for Creating Table Ctrl + T is a very popular Excel shortcut that is used to create Tables. But there is one more shortcut for creating a Table in Excel and that is Ctrl + L. Select…
In this blog post, I will explain the step by step procedure to Connect Google Sheets with Excel using Power Query. Once a spreadsheet in Google Sheets is connected with an Excel file, the changes made in the Source (Google Sheet) will be reflected in the Excel file at the expense of a single mouse…
How to build Relationships between Excel Tables using the Data Model of Excel is explained in this Tutorial. Purpose of connecting Tables VLOOKUP and INDEX+MATCH formulas always get the job done, but a lot of them will essentially slow down the workbook. Moreover, the Lookup and Reference formulas also demands maintenance with addition or deletion…