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 …
The Best Free Gantt Chart Template for Excel
Excel
The Gantt chart is an Excel software visual representation chart that helps you to be more efficient in your work. It is simple, succinct and easy on the eyes. It works like magic and we are going to teach you how to use it. The following instructions on how to use the Gantt chart (with a free Excel Gantt chart …
How to Create a Power BI Pie Chart
Power BI
In this article, we will start by explaining what Power BI is and why it is so useful. We will then see how to create a Power BI Pie chart. If you’re a beginner to Power BI and want to see how it can help you create awesome reports quickly and easily – read on. What is Power BI? Power …