How to enable developer ribbon in Excel?
Do you want to enable developer ribbon and use VBA in Excel? Follow these simple steps: Step 1: Right click any ribbon name Step 2: Select “Customize Ribbon” Step 3: This opens the Excel Options. From here, Check the “Developer” option in the right side panel Step 4: Click ok. Your developer ribbon is now […]
Get all BOLD text out Excel Cells Automatically
Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.
Number to Words – Excel Formula
Ever wanted to convert numbers to words in Excel? For example, 456,123 becomes four hundred fifty-six thousand one hundred twenty-three.
Microsoft recently introduced LET function to Excel. This allows us to create variables on the fly to use within a formula. I just made a words from number formula using LET function and bit of good old INDEX.
Read on to learn how this all works.
Filter as you type [Quick VBA tutorial]
Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.
Let’s figure out how to do this using some really simple VBA code.
Show difference between cells in status bar – VBA Example
We can select a few cells in Excel and quickly see their count, sum etc. in the status bar. Ever wanted to customize the status bar to show something else, say difference? You can use VBA add-ins with application level events to achieve this. In this VBA Example, we will look at how to set up a class module, application event in our personal macro add-in to customize status bar.
Play spreadsheet soccer with Excel Penalty Game [VBA]
We love spreadsheets. And of course, once every four years, we also get mad about soccer. So why not merge both of them in to one awesome, frivolous and fun thing: Introducing….
The best part is you don’t have to run up to play this. Set your aim and let RANDBETWEEN() decide your fate.
Rescue oddly shaped data – Battle between Formulas, VBA and Power Query
Let’s say you have data like this in a spreadsheet. Don’t roll your eyes, I am 102% sure, right at this moment, someone is (ab)using Excel to create similar messy data.
How do you reshape it to one column?
You could use formulas, VBA or Power Query. Let’s examine all these methods to see what is best. All these methods assume your data is in a range aptly named myrange.