All posts by Sridhar Belide
Using the Immediate Window – Excel VBA Tips
We all know that VBA allows us to create Macros in Microsoft Excel which does complex tasks in an easy way. You can create a Macro for tasks which you are supposed to do repeatedly. But, while writing VBA code we come across some issues or errors and finding them would be hard. So, we […]
Continue readingIntersection Operator with Named Ranges – Excel Tips and Tricks
Hello All! We all are aware that VLOOKUP allows us to find the intersecting value of ranges or lists. It takes the value of one column and finds the corresponding value in the same row of another column. For example, VLOOKUP helps to find the telephone number of a person from the telephone directory. But, […]
Continue readingRemove Auto Syntax Popup – VBA Excel Coding Tips
We all love Excel and looks like there is no need any introduction for what is Visual Basic programming. As we all know VB programming allows us to automate tasks and we can do a lot more in Excel with it. But, have you observed the pop-up shown when you make any syntax error while […]
Continue readingHow to Change Comment Formatting – Excel VBA Coding Tips
Excel MVP Jordan is continuing the Excel VBA Coding tips. While coding comments play an important role. Comments explain what certain piece of code does so that it would be easy when you share the code with others. So, Jordan unfolds the new coding tip related to comment. He explains the feature which adds color […]
Continue readingHow to Change Excel Serial Date Format Using Text to Columns
Microsoft Excel allows us to show any complex data in an easy way. You could only see some format changes when you extract the data from the database. For example, say you have the data related to employee related to joining date. Then, when you extract this data from the database, then you would see […]
Continue readingCustomize Excel Ribbon – Change Case of Text
We all know that Excel Ribbon has tabs like Home, Data, review, Insert and many more. This allows us to perform some tasks like formatting the text, inserting bullets and more. Without this Excel ribbon nothing can be done. But, if you observe it, text on all tabs of ribbon is in camel case. Do you […]
Continue readingData Parsing in Excel Using LEN and SUBSTITUTE function – HOT Tips
Analyzing and parsing data in Excel is really a tedious task. If it is not done smartly, then we end up in doing lot of mess. For example, say you have list of email addresses in Excel and you want to extract the extensions of those email addresses. Most of us think of using Text […]
Continue readingCreating Random Data in Excel using RANDBETWEEN and CHOOSE
Many times we are in need of random data. Suppose, if you are doing some tutorial on Excel formulas, then we need to have random data in your Excel sheet. There are many situations in the same way and when we are in need of some random data, we generally use some websites that helps […]
Continue readingExcel Tips – Tables and Structured References
Excel Tables arranges data in a structured way in rows and columns. When you have data as output of some analysis then showing it in Excel Table is my suggestion. It makes us easy to work on that data to further process our analysis. In this tutorial Excel expert Oz explains us how to use […]
Continue readingExcel Consulting Tips: Using OneNote and Random Generators
Worried with organizing Excel workbooks and formulas associated with it? Most of us who deal with Excel in our daily life which has formulas, conditions and many things associated with it. Have you ever thought organizing Excel sheets and formulas and other stuff related to that at one place? It is really a cool idea […]
Continue readingExcel Prevent Buttons, Shapes and Objects from Resizing – Excel Tricks
Are you fond of using Dashboards in Excel? I know you would say “Yes” and why not everyone likes it. It is one of the beautiful things that can be done using Excel. So, we would have many objects to make Dashboard looks pretty. In that, we would want to insert a header, new rows […]
Continue readingWho Is Considered The Father Of Pivot Tables? – Excel Challenges
Hi Again! Excel TV is back with new Excel Challenge. Excel MV Jordan Goldmeier brings new challenge and before to going for it, let us have a look at the previous week’s challenge. Last Week’s Challenge You can create in-cell Sparklines using the REPT formula and the “pipe” | symbol. There are two commonly used […]
Continue readingCTRL + SHIFT Excel Shortcut – Drag Copy of Shape Along A Grid
Have you ever faced problems while making copy of buttons in Excel? We normally do so by dragging the button with the CTRL button being pressed. But, you might have seen that dragging by holding the CTRL button, does not allows you to move on the plane or line you want. To be frank it […]
Continue readingFonts That Make Bars Look Filled & Complete – Excel Challenges
Hey folks! Welcome. Excel TV wishes you a very happy new year. Excel Author Jordan Goldmeier is ready with the first Excel challenge in 2016, but as usual before looking at this episode’s challenge, let us have a look at answer to previous episode’s challenge. Last Week’s Challenge Correct Answer from last week’s Challenge If […]
Continue readingAuto Resizing an Excel Spreadsheet For Your Dashboard
Do you know that Excel allows us to zoom to a specified area in your work sheet? Yes, you heard it right. Suppose, you have an Excel sheet and while doing demo or so, you want to zoom to specified area, it can be done easily. Our very own Excel MVP Jordan Goldmeier lets us […]
Continue reading