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. …
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 …
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 …
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 …
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](https://zingurl.com/wp-content/uploads/2020/07/quick-tip-how-to-copy-a-worksheet-in-excel-1169-1-296x248.jpg)
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 …
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 …
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 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 …
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 …