Excel Automation – Creating an Index sheet in a Workbook You may have worked on an Excel workbook with just 3 or 4 worksheets in them. In those workbooks, navigating

Visualization charts in Excel Microsoft Excel can be a great tool for visualization purposes. There are some very powerful charts functionalities inbuilt in Excel, that can be used to depict

In one our earlier blogs, we discussed how to create an Index/TOC sheet in an Excel workbook. Don’t recall? No worries, read it again here. Got it now. Great!   Now,