6 Formulas to Lookup in Excel
Excel
We all know the famous star of Excel functions VLOOKUP. It is commonly used for looking up values with a unique Id. But this is not the only function that can be used for looking up values in Excel. There are many other functions and formulas that can be used to lookup value. In this article, I will introduce you …
10 Excel tips and tricks to help you excel
Excel
Microsoft Excel is an integral tool for most businesses. Some people relish the capabilities of Excel, finding it to be a useful tool that allows them to easily manage, report on, and illustrate tables of data. Others, however, find it tedious and downright obtuse, unable to make heads or tails of what Excel can do for them aside from keeping things …
Extract Numbers from a String in Excel (Using Formulas or VBA)
Excel
There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa –  remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you what I am talking about. …
How to Sort Data in Excel using VBA (A Step-by-Step Guide)
Excel
Excel already has a couple of ways to sort data quickly. You can easily sort a data set by using the sort icons in the ribbon or the sort dialog box. Then why do you need to know how to do this using VBA? Knowing how to sort data using VBA can be helpful when included as a part of …
24 Useful Excel Macro Examples for VBA Beginners (Ready-to-use)
Excel
One way of getting the VBA code is to record the macro and take the code it generates. However, that code by macro recorder is often full of code that is not really needed. Also macro recorder has some limitations. So it pays to have a collection of useful VBA macro codes that you can have in your back pocket and …
Excel Personal Macro Workbook | Save & Use Macros in All Workbooks
Excel
When you create/record a macro in a workbook in Excel, it can only be used in that workbook. But what if you have a list of useful Excel macros that you want to use in all the workbooks?  In such a case, it’s a good idea to save these in your Personal Macro Workbook. Doing this would allow you to access the …
How to Add Plus Sign Before Numbers in Excel
Excel
Excel is a great spreadsheet tool, but there are a few things about it that may irritate you sometimes. For example, if you add a plus sign before a number in a cell in Excel, that plus sign would just go away. The same happens when you try and add leading zeros before a number. The reason for this is …
[Quick Tip] How to Copy a Worksheet in Excel
Excel
A lot of times we need to make a copy of a worksheet in Excel. Maybe you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting. The long (and inefficient) way is: * Right-click on the worksheet tab for which you want to create a copy. * Select …
Format Numbers as Text in a Drop Down List in Excel
Excel
I had to create a number of drop downs with the options ranging from 1 to 5. To make it more user-friendly, I also wanted to give an option of ‘Not Selected’, when a user does not want to make a selection in the drop down list in excel. Something as shown below in the pic: The problem here is …
How to Unhide Sheets in Excel (All In One Go)
Excel
In case you prefer reading a tutorial over watching a video, below is a detailed written tutorial on unhiding sheets in Excel. When you work with data that is spread across multiple worksheets in Excel, you may want to hide a few worksheets. This could be to avoid the clutter or to not show some data to your client/manager by …