A VBA script converts Excel tables to JSON and exports the data to a file, for App Registration for Azure Active Directory
Excel export Json for Azure Active Directory
Read More
Tag: microsoft-excel
Add logging to Microsoft Office add-ins
In this post I explain how to add logging to Office add-ins for debug also when your add-in is on the client machine.
Dropdown list in Excel
The tutorial shows how to create dropdown list in Microsoft Excel depending on another cell by using new dynamic array functions.
How to change to sentence case in Excel
How to change a normal text to sentence case in Excel if we don’t have any function or option? In this port I explain how
Create a Positive/Negative bar chart in Excel
In this post I want to explain step by step how to create a positive/negative bar chart in Microsoft Excel. Another interesting post for Excel is here about how to highlight content. If you want to show how multiple units does comparison to each other based on the same criteria clearly, you can use the positive negative bar chart which can display positive and negative development very good as below screenshot shown. Arrange data Supposing the original data displayed as below: Firstly, add some helper columns: Calculate the difference between…
How to highlight specific text in Excel
In Excel, I want to highlight a specific text within a cell to make it outstanding but not the entire cell
Microsoft teases its future Office UI
Microsoft is teasing the future of its Office UI and design today, and it involves some big changes to the traditional ribbon interface.